5 Feb
2007
5 Feb
'07
6:52 p.m.
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers