[OpenSIPS-Users] siptrace db connection now fails

[Jeff Pyle]

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