Solved Server doesn't appear to be reading config.lua for sql connection?

[ADeadlySpoon]

Hey again,
It would appear my server (TFS 0.2.3.0) isn't reading the config.lua because it says in the GUI:

[23/10/2010 00:28:26] >> Loading config
[23/10/2010 00:28:26] >> Loading RSA key
[23/10/2010 00:28:26] >> Testing SQL connection... MySQL.
[23/10/2010 00:28:26] > MySQL ERROR mysql_real_connect: Access denied for user 'root'@'localhost' (using password: NO)
[23/10/2010 00:28:27] > ERROR: Failed to connect to database, read doc/MYSQL_HELP for information or try SqLite which doesn't require any connection.

The config.lua settings have been changed to point to mysql with a different password, same user. The really weird part is, if I try using SQLite this comes up:

[23/10/2010 00:30:51] >> Loading config
[23/10/2010 00:30:51] >> Loading RSA key
[23/10/2010 00:30:51] >> Testing SQL connection... SqLite.
[23/10/2010 00:30:51] > ERROR: Failed to connect to sqlite database file, make sure it exists and is readable.

(Yes I'm able to change from MySQL to SQLite in config.lua, so I'm really confused why the first error shows at all.)

I have tried multiple databases in the config.lua.

Thanks,
ADS.

 

[_Arthur]

It's because you didn't enter a password to login to your PMA, in config.lua

 

[ADeadlySpoon]

The password is set and correct, I've made sure of this quite a few times. :/

 

[_Arthur]

Are you using SQLite Expert?

 

[ADeadlySpoon]

No, I'm not using any database software, just PhpMyAdmin and the files that came with the server.

I've previously had SQL servers, but never had a problem like this. :/

 

[Xau]

Change localhost to 127.0.0.1 and it should work. Some of the newer versions are weird with localhost.

 

[ADeadlySpoon]

It already is set to localhost, that's why I asked is it not reading from the config.lua properly? Or is it the .exe?

 

[Xau]

No, instead or localhost set it to "127.0.0.1"

 

[ADeadlySpoon]

Sorry, I meant already set to 127.0.0.1... These are the settings (obv without the password)

sqlType = "mysql"
	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "......."
	sqlDatabase = "rrot"
	sqlFile = "armonia.sql"
	sqlKeepAlive = 60
	mysqlReadTimeout = 10
	optimizeDatabaseAtStartup = "yes"
	passwordType = "plain"

 

[_Arthur]

Sorry, I meant already set to 127.0.0.1... These are the settings (obv without the password)

sqlType = "mysql"
	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "......."
	sqlDatabase = "rrot"
	sqlFile = "armonia.sql"
	sqlKeepAlive = 60
	mysqlReadTimeout = 10
	optimizeDatabaseAtStartup = "yes"
	passwordType = "plain"

Change to this..

sqlType = "mysql"
	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "......."
	sqlDatabase = "rrot"
	sqlFile = "armonia.sql"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	optimizeDatabaseAtStartup = "yes"
	passwordType = "plain"

 

[ADeadlySpoon]

Change to this..

sqlType = "mysql"
	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "......."
	sqlDatabase = "rrot"
	sqlFile = "armonia.sql"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	optimizeDatabaseAtStartup = "yes"
	passwordType = "plain"

Nope. Still comes up with the same error. :/

 

[ADeadlySpoon]

-bump-
Anyone have any ideas? =)

 

[qban]

if it still won't work, change

passwordType = "plain"

to

passwordType = "sha1"

 

[ADeadlySpoon]

Nope that doesn't work either. :/
Does anyone have a link to an 8.42 TFS server? I think I should try another...

 

[qban]

sqlDatabase = "rrot"

isn't a misstake? :>

 

[ADeadlySpoon]

Nah that's right, the server name is RRoT so the database in mysql is called rrot

 

[ADeadlySpoon]

There is something really wrong, I deleted

	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "wcde8bku"
	sqlDatabase = "armonia"
	sqlFile = "armonia.sql"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	optimizeDatabaseAtStartup = "yes"
	passwordType = "sha1"

and it still said access denied blah blah exactly the same as before, yet there's no password being provided at all.

 

[qban]

is sql user root too?
and is sql type changed to "mysql"?
sqlType = "mysql"

 

[ADeadlySpoon]

Right, I fixed it, I used a difrent config.lua and it's fine now.
It would appear the server and config.lua weren't compatible (no idea how that happens but it fixed it).