[OpenSIPS-Users] siptrace db connection now fails

[Jeff Pyle]

Hi Bogdan,

1.5.  But, I discovered I had the same problem on a 1.4.3 instance as well.
I was just about to report to the list that I solved the issue by restarting
the mysql server daemon.

Still odd, though.  The mysql server instance itself is running on CentOS
64bit, with mysql's RPMs (i.e. MySQL-server-community-5.1.30-0.rhel5).  Even
when Opensips couldn't connect, I could still connect from the opensips 1.5
machine using the mysql command line client.  That machine has
/usr/lib/libmysqlclient.so.16.0.0 on it from the
MySQL-Cluster-gpl-client-6.3.20-0.rhel5 RPM direct from mysql's site.

The good news is the problem has gone away.  The bad news is I have no idea
what caused it, or how to recreate it.



- Jeff



On 3/5/09 12:37 PM, "Bogdan-Andrei Iancu" <bogdan at voice-system.ro> wrote:

> Hi Jeff,
> 
> Is this  1.4.4 or 1.5 ?
> 
> Regards,
> Bogdan
> 
> Jeff Pyle wrote:
>> Hello,
>> 
>> Until recently siptrace (running on opensips svn) was able to connect
>> without a problem via mysql to its database.  Now, it fails will the
>> following error 2 seconds after startup:
>> 
>> ERROR:db_mysql:db_mysql_new_connection: driver error: Can't connect to MySQL
>> server on '207.xx.xx.xx' (4)
>> ERROR:db_mysql:db_mysql_new_connection: driver error: Can't connect to MySQL
>> server on '207.xx.xx.xx' (4)
>> ERROR:core:db_do_init: could not add connection to the pool
>> ERROR:core:db_do_init: could not add connection to the pool
>> ERROR:siptrace:child_init: unable to connect database
>> ERROR:siptrace:child_init: unable to connect database
>> ERROR:core:init_mod_child: failed to initializing module siptrace, rank 1
>> ERROR:core:main_loop: init_child failed for UDP listener
>> ERROR:core:init_mod_child: failed to initializing module siptrace, rank 4
>> ERROR:core:main_loop: init_child failed for UDP listener
>> 
>> 
>> But a network capture shows the server answered correctly.  Here's an
>> excerpt of the messaging:
>> 
>> MySQL Login Request user=opensips_up1 db=theshow
>> MySQL Response OK
>> MySQL Server Greeting proto=10 version=5.1.30-community-log
>>   ... after this opensips tears down the connections with [FIN, ACK] tagged
>> packets.
>> 
>> I'm not sure at what point it stopped working.  We haven't done any updates
>> on the mysql server, and only svn updates with opensips.  Here's the
>> siptrace config from opensips.cfg:
>> 
>> loadmodule "siptrace.so"
>> modparam("siptrace", "db_url",
>> "mysql://opensips_up1:password@207.xx.xx.xx/theshow")
>> #modparam("siptrace", "trace_flag", 7)
>> modparam("siptrace", "trace_on", 1)
>> 
>> I'm not sure where to start debugging this, since the DB server appears to
>> answer okay.  I tried updating to the most recent svn revsion, 5394, but no
>> change. Any suggestions?
>> 
>> 
>> Thanks,
>> Jeff
>> 
>> 
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> 
>>   
>