Re: [OpenSIPS-Users] OpenSIPs dies when connection to MySQL is lost.

2009-06-25 Thread Bogdan-Andrei Iancu
Hi Chris, Yesterday I discovered some serious issues with the libmysqlclient (source for all the mysql related crashed that were reported). I had to rework some part of the code (for dealing with reconnects at application level instead of lib level, as the one in lib is not reliable at all).

Re: [OpenSIPS-Users] OpenSIPs dies when connection to MySQL is lost.

2009-06-24 Thread Chris Maciejewski
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 > > Hi Chris, > > Thanks for the f

Re: [OpenSIPS-Users] OpenSIPs dies when connection to MySQL is lost.

2009-06-24 Thread Bogdan-Andrei Iancu
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 patc

Re: [OpenSIPS-Users] OpenSIPs dies when connection to MySQL is lost.

2009-06-23 Thread Chris Maciejewski
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: fail

Re: [OpenSIPS-Users] OpenSIPs dies when connection to MySQL is lost.

2009-06-23 Thread Bogdan-Andrei Iancu
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

Re: [OpenSIPS-Users] OpenSIPs dies when connection to MySQL is lost.

2009-06-21 Thread Chris Maciejewski
Sorry, should have mentioned this in my first post. I am running opensips-1.5.1-notls Best regards, Chris 2009/6/21 Thomas Gelf > > What OpenSIPS version are you running? Some related issues habe been > fixed with 1.5.1... > > Best regards, > Thomas Gelf > > > Chris Maciejewski schrieb: > > Hi,

Re: [OpenSIPS-Users] OpenSIPs dies when connection to MySQL is lost.

2009-06-21 Thread Thomas Gelf
What OpenSIPS version are you running? Some related issues habe been fixed with 1.5.1... Best regards, Thomas Gelf Chris Maciejewski schrieb: > 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

[OpenSIPS-Users] OpenSIPs dies when connection to MySQL is lost.

2009-06-21 Thread Chris Maciejewski
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 stat