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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers