I use USERLOC and AUTH to handle my REGISTER requests. libmysqlclient is the one shipped with Ubunty Server 8.04:
$ dpkg-query --status libmysqlclient15-dev Package: libmysqlclient15-dev Version: 5.0.51a-3ubuntu5.4 Regards, Chris 2009/6/24 Bogdan-Andrei Iancu <[email protected]> > > Hi Chris, > > Thanks for the feedback - in regards to your setup - for REGISTER, do you use > only USRLOC or also some other modules doing DB ops (like auth, avpops, etc) ? > > Also, what version of libmysqlclient do you have? > > Regards, > Bogdan > > Chris Maciejewski wrote: >> >> Hi Bogdan, >> >> I applied the patch, but unfortunately OpenSIPs still crashes with the >> following output in the log: >> >> ERROR:db_mysql:re_init_statement: failed while mysql_stmt_prepare: >> (1243) Unknown prepared statement handler (2) given to >> mysql_stmt_close >> ERROR:db_mysql:db_mysql_do_prepared_query: failed to re-init statement! >> ERROR:usrloc:db_timer_udomain: failed to delete from table location >> ERROR:usrloc:timer: synchronizing cache failed >> CRITICAL:core:receive_fd: EOF on 12 >> INFO:core:handle_sigs: child process 11842 exited by a signal 11 >> INFO:core:handle_sigs: core was generated >> INFO:core:handle_sigs: terminating due to SIGCHLD >> INFO:core:sig_usr: signal 15 received >> >> To reproduce: >> 1. Start MySQL. >> 2. Start opensips. >> 3. Register a SIP phone (Twinkle in my case). >> 4. Deregister / Register SIP phone couple of times. >> 5. Run the following on MySQL server: "FLUSH TABLES WITH READ LOCK;" >> 6. Deregister / Register SIP phone couple of times. OpenSIPs will show >> the following in the log: >> >> ERROR:db_mysql:get_new_stmt_ctx: failed while mysql_stmt_prepare: >> (2013) Lost connection to MySQL server during query >> ERROR:db_mysql:db_mysql_do_prepared_query: failed to create new context >> ERROR:usrloc:db_update_ucontact: updating database failed >> ERROR:usrloc:update_ucontact: failed to update database >> >> 7. Run the following on MySQL server: "UNLOCK TABLES;" >> 8. OpenSIPs will crash after a little while. >> >> If there is anything more I can do to help solving this problem, >> please let me know. >> >> Best regards, >> Chris >> >> >> 2009/6/23 Bogdan-Andrei Iancu <[email protected]> >> >>> >>> Hi Chris, >>> >>> following other reports, I made a fix on the SVN (trunk) - I did not >>> commited yet on branch as there is still under testing. I would really >>> appreciate your help in confirming the correctness of this fix, by simply >>> testing it - apply the attached patch to your 1.5 sources and give it a try. >>> >>> Thanks and regards, >>> Bogdan >>> >>> Chris Maciejewski wrote: >>> >>>> >>>> Hi, >>>> >>>> I just noticed OpenSIPs dies with the following output in the log, >>>> when MySQL goes down: >>>> >>>> ERROR:db_mysql:re_init_statement: failed while mysql_stmt_prepare: >>>> (1243) Unknown prepared statement handler (4) given to >>>> mysql_stmt_close >>>> ERROR:db_mysql:db_mysql_do_prepared_query: failed to re-init statement! >>>> ERROR:usrloc:db_timer_udomain: failed to delete from table location >>>> ERROR:usrloc:timer: synchronizing cache failed >>>> ERROR:db_mysql:re_init_statement: failed while mysql_stmt_prepare: >>>> (2013) Lost connection to MySQL server during query >>>> ERROR:db_mysql:db_mysql_do_prepared_query: failed to re-init statement! >>>> ERROR:presence:update_db_subs: deleting expired information from database >>>> INFO:core:handle_sigs: child process 8655 exited by a signal 11 >>>> INFO:core:handle_sigs: core was generated >>>> INFO:core:handle_sigs: terminating due to SIGCHLD >>>> >>>> Would it be possible to change this behaviour, so for example: >>>> >>>> 1. Both OpenSIPs and MySQL is running. >>>> 2. MySQL goes down. >>>> 3. OpenSIPs sends "500 Server error" but the process stays up and running. >>>> 4. MySQL is back online. >>>> 5. OpenSIPs resumes normal operation. >>>> >>>> Best regards, >>>> Chris >>>> _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
