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

[triplef]

Im getting the same error, it seems its when there's connections registers / etc while its stil lloading its config.
i run screen -d -m /usr/local/sbin/kamailio -d -d -d -v -f /usr/local/etc/kamailio/kamailio.cfg

and the screen dies 3-4 times on that same error , THE DB IS ACCESIBLE as it can load after-2-3 shots.. and can read the other tables fine.

Mar 28 22:57:08 [15510] ERROR:db_mysql:db_mysql_new_connection: driver error: Can't connect to MySQL server on 'myserverHERE' (4)
Mar 28 22:57:08 [15510] ERROR:core:db_do_init: could not add connection to the poolMar 28 22:57:08 [15510] ERROR:usrloc:mi_child_init: failed to connect to database
Mar 28 22:57:08 [15510] ERROR:core:init_mi_child: failed to init <ul_rm>
Mar 28 22:57:08 [15510] CRITICAL:mi_datagram:datagram_process: failed to init the mi process
Mar 28 22:57:08 [15505] INFO:core:handle_sigs: child process 15510 exited normally, status=255
Mar 28 22:57:08 [15505] INFO:core:handle_sigs: terminating due to SIGCHLD
Mar 28 22:57:08 [15509] INFO:core:sig_usr: signal 15 received
Mar 28 22:57:08 [15507] INFO:core:sig_usr: signal 15 received
Mar 28 22:57:08 [15508] INFO:core:sig_usr: signal 15 received


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



-- 
View this message in context: http://n2.nabble.com/Cant-connect-remote-DB-using-new-opensips-1.4.4-tp2165346p2551349.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.