BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => AO 0.6 support => Topic started by: Dochere on August 31, 2009, 12:42:17 am

Title: Bebot, jailed shell. (MySQL has gone away)
Post by: Dochere on August 31, 2009, 12:42:17 am

Hi,

I have a Bot running I'm basically trying to run it on my webhost's webserver (Hostgator).

After many queries back and forth, I'm now able to run my bot somewhat, after a few minutes i get this message "MySQL server has gone away" and it wont create a new/reconnect to MySQL server.

This can be a combination of 2 things: a low timeout on server and reconnection not allowed. (i have no access to change these as I'm trying to run bot on a "webserver only server", lucky enough to get them to open the port so witch i could connect to the chat server inn the first place)

Adding a mysql_ping() into the code should make this issue go away, how should i go forth adding ping?


All feedback appreciated :)

Title: Re: Bebot, jailed shell. (MySQL has gone away)
Post by: Dochere on August 31, 2009, 09:29:03 am

mysql_pconnect seems like it did the trick, hope i just dont jinx it now. Only been running for a little while.

with mysql_connect bot would only stay connected to database for a few minutes.