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

LogBlock cannot connect to MySQL if config values are integers. #48

Closed
Elitay opened this issue Dec 13, 2011 · 1 comment
Closed

LogBlock cannot connect to MySQL if config values are integers. #48

Elitay opened this issue Dec 13, 2011 · 1 comment

Comments

@Elitay
Copy link

Elitay commented Dec 13, 2011

LogBlock doesn't seem to be able to read integers from the config file when it expects strings?. When using a number as a username or password it fails to connect. This is a problem for those of us who are assigned such passwords by our host. Observe the difference:

mysql:
user: test
port: 3306
password: test
host: mysqlus2.fragnet.net
database: ****

2011-12-13 01:53:53 [SEVERE] [LogBlock] Error while fetching connection:
java.sql.SQLException: Access denied for user 'test'@'108.60.213.82' (using password: YES)

mysql:
user: 1234
port: 3306
password: 1234
host: mysqlus2.fragnet.net
database: ****

2011-12-13 02:04:13 [SEVERE] [LogBlock] Error while fetching connection:
java.sql.SQLException: Access denied for user ''@'108.60.213.82' (using password: NO)

@DiddiZ
Copy link
Member

DiddiZ commented Dec 13, 2011

Put the numer in single quotes to make it a string: '123'

I may add a workaround :D

@DiddiZ DiddiZ closed this as completed Dec 13, 2011
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