[Serusers] DB disconnects with MySQL 5.0.27

[sip]

Okay... apparently, as of 5.0.3, there's a timeout on the connection and the
option to auto-reconnect has been turned off. In order to turn it back ON, one
has to modify the connection with MYSQL_OPT_RECONNECT. 

I added a few lines to the my_con.c file in the mysql modules dir, and we'll
see how it fares. 


Added: 

my_bool my_true;

And below the mysql_init(ptr->con); line, I added:

mysql_options(ptr->con, MYSQL_OPT_RECONNECT, &my_true);


Has anyone done anything similar and had decent results (incidentally, if you
have mysql 5.0.18 or lower, the MYSQL_OPT_RECONNECT is reset as soon as you
call mysql_real_connect, so it has to be set afterward) ? 


N.


On Mon, 5 Feb 2007 07:38:04 -0500, sip wrote
> Something I've never run into before when I was using MySQL 4.x, but 
> now crops up on MySQL 5.0.27... I get these errors:
> 
> Feb  5 07:30:40 qabalah ser[26765]: submit_query(): MySQL server has 
> gone away 
> Feb  5 07:30:40 qabalah ser[26765]: db_update: Error while 
> submitting query 
> Feb  5 07:30:40 qabalah ser[26765]: db_upd_ucontact(): Error while updating
> database
> 
> Feb  5 07:30:40 qabalah ser[26765]: wb_timer(): Error while updating 
> contact in db
> 
> I assume there's some sort of timeout of the SER connection to 
> mysql? Is there a standard way to rectify this? Is this something 
> new in MySQL 5?
> 
> N.
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers