DiddiZ/LogBlock — Issue #48: LogBlock cannot connect to MySQL if config values are integers.
Author: Elitay
Created: 2011-12-13 10:09:14+00:00
State: open

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)