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

[Bogdan-Andrei Iancu]

Hi Rafael,

between 1.4.3 and 1.4.4, nothing was changed at DB level, so there is 
not reason to act differently. Based on the logs, it looks like you 
opensips simply cannot connect to DB server.

have you took a look with tcpdump to see if the there is any attempt 
(and where) to connect to DB?

Regards,
Bogdan

Rafael Risco Gonzales-Vigil 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 
> <mailto: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 
> <mailto: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 
> <mailto: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
>