[OpenSIPS-Users] Reboot errors

[Carlo Dimaggio]

Hi all,

I have a strange problem. When I reboot my server I see these errors  
in syslog:

Oct 16 12:35:15 sip /sbin/opensips[4600]:  
ERROR:db_mysql:db_mysql_new_connection: driver error: Can't connect  
to MySQL server on 'XXX.XXX.XXX.XXX' (4)
Oct 16 12:35:15 sip /sbin/opensips[4600]: ERROR:core:db_do_init:  
could not add connection to the pool
Oct 16 12:35:15 sip /sbin/opensips[4600]: ERROR:uri_db:uridb_db_ver:  
unable to open database connection
Oct 16 12:35:15 sip /sbin/opensips[4600]: ERROR:uri_db:mod_init:  
Error while querying table version
Oct 16 12:35:15 sip /sbin/opensips[4600]: ERROR:core:init_mod: failed  
to initialize module uri_db
Oct 16 12:35:15 sip /sbin/opensips[4600]: ERROR:core:main: error  
while initializing modules

but if I restart the service (/etc/init.d/opensips restart), opensips  
starts rightly.
What can be the problem (all modules are loaded in the right order...)?

Thank you in advance.

Regards


-------

Here my opensips.cfg:



loadmodule "usrloc.so"
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "nat_bflag", 6)
modparam("usrloc", "db_url","mysql://user:pass@XXX.XXX.XXX.XXX/ 
opensips")
modparam("usrloc", "use_domain", 1)

loadmodule "registrar.so"
modparam("registrar", "received_avp", "$avp(i:42)")

loadmodule "rr.so"
modparam("rr", "enable_full_lr", 1)

loadmodule "tm.so"

loadmodule "xlog.so"
modparam("xlog", "buf_size", 4096)
modparam("xlog", "force_color", 0)

loadmodule "mi_fifo.so"
modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")

loadmodule "mi_datagram.so"
modparam("mi_datagram", "socket_name", "/var/run/opensips/ 
opensips_mi.sock")

loadmodule "domain.so"
modparam("domain", "db_url","mysql://user:pass@XXX.XXX.XXX.XXX/ 
opensips")

loadmodule "nathelper.so"
modparam("nathelper","natping_interval", 0)
modparam("nathelper","received_avp", "$avp(i:42)")

loadmodule "textops.so"

loadmodule "mediaproxy.so"
modparam("mediaproxy","mediaproxy_socket", "/var/run/mediaproxy/ 
dispatcher.sock")

loadmodule "uri.so"

loadmodule "sl.so"
modparam("sl", "enable_stats", 1)

loadmodule "maxfwd.so"

loadmodule "db_mysql.so"
modparam("db_mysql", "ping_interval", 300)
modparam("db_mysql", "auto_reconnect", 1)
modparam("db_mysql", "timeout_interval", 2)

loadmodule "auth.so"

loadmodule "auth_db.so"
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("auth_db", "db_url","mysql://user:pass@XXX.XXX.XXX.XXX/ 
opensips")
modparam("auth_db", "use_domain", 1)

loadmodule "uri_db.so"
modparam("uri_db", "db_url","mysql://user:pass@XXX.XXX.XXX.XXX/ 
opensips")

loadmodule "avpops.so"
modparam("avpops", "avp_url", "mysql://user:pass@XXX.XXX.XXX.XXX/ 
opensips")
modparam("avpops", "avp_table", "usr_preferences")
modparam("avpops", "use_domain", 1)

loadmodule "permissions.so"
modparam("permissions", "db_mode", 1)
modparam("permissions", "trusted_table", "trusted")
modparam("permissions", "db_url","mysql://user:pass@XXX.XXX.XXX.XXX/ 
opensips")

loadmodule "lcr.so"
modparam("lcr", "fr_inv_timer_avp", "$avp(i:704)")
modparam("lcr", "gw_uri_avp", "$avp(i:709)")
modparam("lcr", "contact_avp", "$avp(i:711)")
modparam("lcr", "ruri_user_avp", "$avp(i:500)")
modparam("lcr", "rpid_avp", "$avp(i:302)")
modparam("lcr", "flags_avp", "$avp(i:712)")
modparam("lcr", "db_url","mysql://user:pass@XXX.XXX.XXX.XXX/opensips")

loadmodule "alias_db.so"
modparam("alias_db", "db_url","mysql://user:pass@XXX.XXX.XXX.XXX/ 
opensips")
modparam("alias_db", "use_domain", 1)

loadmodule "acc.so"
modparam("acc", "radius_config", "/etc/radiusclient-ng/ 
radiusclient.conf")
modparam("acc", "radius_flag",  2)
modparam("acc", "radius_missed_flag", 3)
modparam("acc", "radius_extra", "User-Name=$Au; Calling-Station-Id= 
$from; Called-Station-Id=$to; Sip-Translated-Request-URI=$ruri; Sip- 
RPid=$avp(s:rpid); Source-IP=$si; Source-Port=$sp; Canonical-URI=$avp 
(s:can_uri); Billing-Party=$avp(s:billing_party); Divert-Reason=$avp 
(s:divert_reason); X-RTP-Stat=$hdr(X-RTP-Stat); User-Agent=$hdr(user- 
agent); Contact=$hdr(contact); Event=$hdr(event); SIP-Proxy-IP=$avp 
(s:sip_proxy_ip); ENUM-TLD=$avp(s:enum_tld)")

loadmodule "uac.so"		

loadmodule "options.so"		

loadmodule "siptrace.so"
modparam("siptrace", "db_url", "mysql://user:pass@XXX.XXX.XXX.XXX/ 
opensips")
modparam("siptrace", "trace_flag", 22)
modparam("siptrace", "trace_on", 1)

loadmodule "dialog.so"
modparam("dialog", "db_mode", 1)
modparam("dialog", "enable_stats", 1)
modparam("dialog", "dlg_flag", 4)
modparam("dialog", "db_url", "mysql://user:pass@XXX.XXX.XXX.XXX/ 
opensips")

loadmodule "group.so"
modparam("group", "db_url","mysql://user:pass@XXX.XXX.XXX.XXX/opensips")

loadmodule "nat_traversal.so"
modparam("nat_traversal", "keepalive_interval", 90)
modparam("nat_traversal", "keepalive_method", "OPTIONS")
modparam("nat_traversal", "keepalive_state_file", "/var/run/opensips/ 
keepalive_state")