[OpenSIPS-Users] siptrace db connection now fails

[Bogdan-Andrei Iancu]

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
>
>