collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18366
  • stats Total Topics: 2501
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: Bebot, jailed shell. (MySQL has gone away)  (Read 1763 times)

0 Members and 1 Guest are viewing this topic.

Offline Dochere

  • BeBot User
  • **
  • Posts: 43
  • Karma: +0/-0
Bebot, jailed shell. (MySQL has gone away)
« 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 :)

Offline Dochere

  • BeBot User
  • **
  • Posts: 43
  • Karma: +0/-0
Re: Bebot, jailed shell. (MySQL has gone away)
« Reply #1 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.

 

* Recent Posts
Com bot module by bitnykk
[November 25, 2024, 05:36:11 pm ]


0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm ]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am ]

* Who's Online
  • Dot Guests: 349
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal