I just got this link from "SIP"

http://www.iptel.org/faq/why_does_my_mysql_5_0_x_connection_time_out_when_us...

Thanks for him/her.

Cheers, Mitya

Mitya wrote:

Hi all,

I'm running SER 0.9.6 on a Debian Etch, compiled it from source, using etch's libmysqlclient5 to connect a mysql server 5.0.20 (running on a different server, but on the same LAN)

From my ser.cfg:

modparam("usrloc", "db_mode", 1) modparam("usrloc", "timer_interval", 10) modparam("usrloc", "use_domain", 1) modparam("usrloc", "db_url", "mysql://ser:xxxxx@x.x.x.x:3306/ser")

When I start SER, everything seems to be fine for a while. After about one day, when I unplug my UAC and the registration expires, SER can not remove it from the database because it says:

Oct 18 14:47:07 sip ser[21813]: Binding '1111111@1.2.3.4','sip:1111111@2.3.4.5:1164' has expired Oct 18 14:47:07 sip ser[21813]: submit_query(): mysql_ping failed Oct 18 14:47:07 sip ser[21813]: submit_query(): MySQL server has gone away Oct 18 14:47:07 sip ser[21813]: db_delete: Error while submitting query Oct 18 14:47:07 sip ser[21813]: db_del_ucontact(): Error while deleting from database Oct 18 14:47:07 sip ser[21813]: wt_timer(): Error while deleting contact from database

If I restart SER, everything works fine (for a while) again.

I'm sure that _NO_ONE_ was restarted the MySQL server during the test period. I can reproduce it at any time.

Is it a known issue, or do I have a special case ?

Every comments are welcome.

Thanks, Mitya