[OpenSIPS-Users] Cant connect remote DB using new opensips 1.4.4

[Bogdan-Andrei Iancu]

Hi Rafo,

as the logs show, only the usrloc has problems connecting to the DB, so 
first of all check if the "db_url" modparam for "usrloc" module points 
to a valid DB URL.

Regards,
Bogdan

triplef wrote:
> Hi
> I've downloaded opensips 1.4.4 to upgrade my system from 1.4.3, it compiled
> ok but with this version opensips can not connect to the remote DB so I had
> to go back to 1.4.3, please see the error logs below.
>
> Sometimes this problem appears when run 1.4.3 but opensips load in second
> try, so most of the time I have to run '/etc/init.d/opensips.init
> opensipsstart' twice.. but with this version 1.4.4 do not load properly.
>
> Another detail: I am using a VIEW from mya2billing.cc_card as a subscriber
> table to load 70000 subscribers in this way:
>
> CREATE VIEW opensips.subscriber_v1 AS
> SELECT id AS id,
> useralias AS username,
> '192.168.12.254' AS domain,
> userpass AS password,
> email AS email_address,
> md5(concat(useralias,' : ','192.168.12.254',' : ',userpass)) AS ha1,
> md5(concat(useralias,'@','192.168.12.254',' : ','192.168.12.254',' :
> ',userpass)) AS ha1b,
> useralias AS rpid from mya2billing.cc_card WHERE tariff=2;
>
> INSERT INTO version (table_name,table_version) VALUES ('subscriber_v1','6');
>
>
> ----->
> LOGS when trying opensips 1.4.4
> .
> ..
> ...
> ....
> Jan 15 16:05:08 [23335] INFO:nathelper:rtpp_test: rtp proxy
> <unix:/var/run/rtpproxy.sock> found, support for it enabled
> Register authentication failed -
> F=sip:64820062 at 192.168.12.254<sip%3A64820062 at 192.168.12.254>IP=10.254.52.120
> UA=CM5K-TA1S  (712280)
> Registration successful -
> F=sip:64820028 at 192.168.12.254<sip%3A64820028 at 192.168.12.254>IP=192.168.83.107
> UA=CM5K  (611220)
>
> Jan 15 16:05:08 [23323] INFO:nathelper:rtpp_test: rtp proxy
> <unix:/var/run/rtpproxy.sock> found, support for it enabled
> Jan 15 16:05:08 [23329] INFO:nathelper:rtpp_test: rtp proxy
> <unix:/var/run/rtpproxy.sock> found, support for it enabled
> Registration successful -
> F=sip:64820062 at 192.168.12.254<sip%3A64820062 at 192.168.12.254>IP=10.254.52.120
> UA=CM5K-TA1S  (712280)
>
> Jan 15 16:05:08 [23336] INFO:nathelper:rtpp_test: rtp proxy
> <unix:/var/run/rtpproxy.sock> found, support for it enabled
> Jan 15 16:05:08 [23338] INFO:nathelper:rtpp_test: rtp proxy
> <unix:/var/run/rtpproxy.sock> found, support for it enabled
> Jan 15 16:05:08 [23340] ERROR:db_mysql:db_mysql_new_connection: driver
> error: Can't connect to MySQL server on '192.168.1.29' (4)
> Jan 15 16:05:08 [23340] ERROR:core:db_do_init: could not add connection to
> the poolJan 15 16:05:08 [23340] ERROR:usrloc:child_init: child(27): failed
> to connect to database
> Jan 15 16:05:08 [23340] ERROR:core:init_mod_child: failed to initializing
> module usrloc, rank 27
> Jan 15 16:05:08 [23340] ERROR:core:tcp_init_children: init_children failed
> Jan 15 16:05:08 [23339] ERROR:db_mysql:db_mysql_new_connection: driver
> error: Can't connect to MySQL server on '192.168.1.29' (4)
> Jan 15 16:05:08 [23339] ERROR:core:db_do_init: could not add connection to
> the poolJan 15 16:05:08 [23339] ERROR:usrloc:child_init: child(26): failed
> to connect to database
> Jan 15 16:05:08 [23339] ERROR:core:init_mod_child: failed to initializing
> module usrloc, rank 26
> Jan 15 16:05:08 [23339] ERROR:core:tcp_init_children: init_children failed
> Jan 15 16:05:08 [23341] ERROR:db_mysql:db_mysql_new_connection: driver
> error: Can't connect to MySQL server on '192.168.1.29' (4)
> Jan 15 16:05:08 [23341] ERROR:core:db_do_init: could not add connection to
> the poolJan 15 16:05:08 [23341] ERROR:usrloc:child_init: child(28): failed
> to connect to database
> Jan 15 16:05:08 [23341] ERROR:core:init_mod_child: failed to initializing
> module usrloc, rank 28
> Jan 15 16:05:08 [23341] ERROR:core:tcp_init_children: init_children failed
> Jan 15 16:05:08 [23310] ERROR:db_mysql:db_mysql_new_connection: driver
> error: Can't connect to MySQL server on '192.168.1.29' (4)
> Jan 15 16:05:08 [23310] ERROR:core:db_do_init: could not add connection to
> the poolJan 15 16:05:08 [23310] ERROR:usrloc:child_init: child(0): failed to
> connect to database
> Jan 15 16:05:08 [23310] ERROR:core:init_mod_child: failed to initializing
> module usrloc, rank 0
> Jan 15 16:05:08 [23310] ERROR:core:main_loop: error in init_child for
> PROC_MAIN
> Jan 15 16:05:08 [23335] INFO:core:sig_usr: signal 15 received
> Jan 15 16:05:08 [23334] INFO:core:sig_usr: signal 15 received
> Jan 15 16:05:08 [23333] INFO:core:sig_usr: signal 15 received
> Jan 15 16:05:08 [23332] INFO:core:sig_usr: signal 15 received
> Jan 15 16:05:08 [23331] INFO:core:sig_usr: signal 15 received
> ....
> ..
> ..
> .
>
> any idea?
> rafo
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>