[rtg] yrtg not reconnecting after mysql loss

Bryan Wann bwann-rtg at wann.net
Fri May 2 16:15:33 EDT 2008


I've noticed with 0.8.1+yrtg, it's not reconnecting after loss of the 
mysql server.  All the threads report back with "mysql unavailable (2006), 
buffering", over and over again after the server was back up.  I checked 
my build and verified the yrtg patch for this did apply.

I'm running mysql 5.0.58 and I know from snort and a few other apps that 
in 5.0.3 reconnect was turned off by default.  I tried adding in a 
"mysql->reconnect = 1" in librtgmysql.c in __db_connect() after 
mysql_real_connection(), but this didn't seem to help.  I noticed it's 
also using mysql_options(), so I tried adding a [rtg] section to my.cnf 
with 'reconnect 1'.  No luck.  Does this sound like the right avenue of 
attack for this problem?


kind regards,
bryan


More information about the RTG mailing list