logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Database Went away

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Linux technical support
View previous topic :: View next topic  
Author Message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Thu Jul 17, 2008 23:51    Post subject: Database Went away Reply with quote

I have had this issue for a long time. I found a thread here about a DB ping, and this is the script, but it still goes away.

OnModLoad
Code:
ExecuteScript("db_keepalive", OBJECT_SELF);//Script to keep database connected


db_keepalive
Code:
#include "aps_include"
void main()
{
SQLExecDirect("SELECT 1");
DelayCommand(150.0, ExecuteScript("db_keepalive", GetModule()));
}
Back to top
View user's profile Send private message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Thu Jul 17, 2008 23:59    Post subject: Reply with quote

Code:
1216331873 o ERROR: DB went away
Back to top
View user's profile Send private message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Fri Jul 18, 2008 0:33    Post subject: Reply with quote

in hind sight, i put this in the wrong forum Embarassed

feel free to move
Back to top
View user's profile Send private message
TroveLord



Joined: 22 Nov 2006
Posts: 136
Location: Italy

PostPosted: Fri Jul 18, 2008 1:36    Post subject: Reply with quote

I'm using a 60 seconds delay and it works.
Back to top
View user's profile Send private message
Extreme



Joined: 28 Nov 2007
Posts: 135

PostPosted: Fri Jul 18, 2008 9:46    Post subject: Reply with quote

60 seconds seems to work
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Linux technical support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group