[SQL Connection with Latest TFS lost]

[Zonet]

Hello everyone i got a War script bought from nahruto [<3]
And with the latest TFS in config there's something

mysqlReadTimeout = 10 <-- this one.

My friend got this script too, he is using gui and getting this problem

in the console] Access denied for user 'ODBC'@'localhost' (using password: YES)

and i'm getting this error [using my kill.lua with svargrond arena.]

I'm getting error in line 12 <-->

if enemyGuild == getGuildWarInfo(myGuild).With then

and this getGuildWarInfo(myGuild).With <---use sql

so, i think it is TFS problem, i'll now post my latest config and the old config. my screen first.

Latest.

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "pass"
sqlDatabase = "dbname"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 60
mysqlReadTimeout = 10
optimizeDatabaseAtStartup = "yes"
passwordType = "plain"

Old

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "pass"
sqlDatabase = "dbname"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 60
optimizeDatabaseAtStartup = "yes"
passwordType = "plain"

i hope any of TFS developers take a look, what is wrong it that since when it lost the connection my server crashes.


Thank you.

 

[mamon_2]

KeepAlive got on 1000 
ReadTimeOut on 1000000

kleksu, may you can explain how does this work?
KeepAlive... for what?
ReadTimeOut... for when lose conecction and stop transfering? :S

I have it like

KeepAlive got on 60 
ReadTimeOut on 0

 

[klekSu]

No idea how it works to be honest.

 

[mamon_2]

Waiting the new realese RC2 then...
Thanks anyway.

 

[Zonet]

So we will still get these errors until that?

 

[klekSu]

Not sure if Elf will even fix that in RC2. I'm chaging to linux on days.

 

[ScorpiOOn93]

but i'm working od debian etch and i have the same problem. TFS looses connection after something about 24 hours sometimes even more. So probably the problem is somewehere in the configuration of TFS or mysql server. I'm working on it for about two weeks and i have no idea what to do now.

#BTW:
Now I know that if i set mysqlReadTimeout to lower value then the mysql is not loosing connection so fast.
I will try to set mysqlReadTimeout to 0 (mysqlReadTimeout = 0) and check what happens.

 

[klekSu]

Have you got that on debian too? Can't be, damnit.

 

[Zonet]

Bump

 

[Migxxx]

edit your mysql variables, BTW i lossed it just 1 time and was because of that and was when i had like 300 hrs uptime or so...

 

[klekSu]

I have no variables in my.cnf u_U

 

[Zonet]

bump

 

[Markey]

For me the problem comes pretty soon if there are many players online...
If there are only 10-20 players than there is nearly no problem...

Same by yours?

 

[Zonet]

Nope, I dont know i always had 100+ players.

 

[TriamerA]

mysql_real_query(): SELECT `password` FROM `accounts` WHERE `id` = 5021057: MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10056)
mysql_real_query(): SELECT `expires` FROM `bans` WHERE `type` = 1 AND ((860951870 & 4294967295 & `param`) = (`value` & `param` & 4294967295)) AND `active` = 1;: MYSQL ERROR: Bad handshake

 

[Master-m]

lol Bad handshake xD

 

[mamon_2]

We are f*cked xD

 

[Pietia]

comes to me too with 200 -100 players on linux on 50 it works fine .

 

[Artii]

I don't have such problems..

 

[trixet]

I also changed my sqlkeepAlive and mysql ReadTimeout to 0..
No error this far, still waiting..!

 

[trixet]

double post