Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Mysql error while installing RTB #448

Closed
punitdarji opened this issue Jul 27, 2021 · 3 comments
Closed

Mysql error while installing RTB #448

punitdarji opened this issue Jul 27, 2021 · 3 comments

Comments

@punitdarji
Copy link

punitdarji commented Jul 27, 2021

Hey guys I am using ubuntu 20.4 version and Mysql Server version: 8.0.26-0ubuntu0
While installing RTB in new machine it is showing an error.

I have tried with database connection string, it is working fine.

I have tried with older version the same error is coming. please help me out

image

@eljeffeg
Copy link
Collaborator

I'm surprised to see the 5500@ specified as part of the "server host". Is 5500 the username? Your config should look something like this:

# [ Database ]
sql_dialect = "mysql"
sql_database = "rootthebox"
sql_host = "127.0.0.1"
sql_port = 3306
sql_user = "rtb"
sql_sslca = ""
sql_password = "rtb"
log_sql = False

@punitdarji
Copy link
Author

punitdarji commented Jul 27, 2021

Digits are related to my password. I am also surprised why it is taking password rather than username.
Connection string should be username@127.0.0.1 but here it is taking password part.

@eljeffeg
Copy link
Collaborator

I think we identified the issue as being an @ symbol used in the mysql password, which the Python MySQL or SQL Alchemy is parsing as a delimiter. Will follow up with some code that warns a user if this is detected.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants