Hi<br>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. <br><br>
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.<br>
<br>Another detail: I am using a VIEW from mya2billing.cc_card as a subscriber table to load 70000 subscribers in this way:<br><br>CREATE VIEW opensips.subscriber_v1 AS <br>SELECT id AS id, <br>useralias AS username, <br>
'192.168.12.254' AS domain, <br>
userpass AS password, <br>email AS email_address, <br>md5(concat(useralias,' : ','192.168.12.254',' : ',userpass)) AS ha1, <br>md5(concat(useralias,'@','192.168.12.254',' : ','192.168.12.254',' : ',userpass)) AS ha1b, <br>
useralias AS rpid from mya2billing.cc_card WHERE tariff=2;<br><br>INSERT INTO version (table_name,table_version) VALUES ('subscriber_v1','6');<br><br><br>-----><br>LOGS when trying opensips 1.4.4<br>.<br>
..<br>
...<br>....<br>Jan 15 16:05:08 [23335] INFO:nathelper:rtpp_test: rtp proxy <unix:/var/run/rtpproxy.sock> found, support for it enabled<br>Register authentication failed - F=<a href="mailto:sip%3A64820062@192.168.12.254" target="_blank">sip:64820062@192.168.12.254</a> IP=10.254.52.120 UA=CM5K-TA1S (712280) <br>
Registration successful - F=<a href="mailto:sip%3A64820028@192.168.12.254" target="_blank">sip:64820028@192.168.12.254</a> IP=192.168.83.107 UA=CM5K (611220) <br><br>Jan 15 16:05:08 [23323] INFO:nathelper:rtpp_test: rtp proxy <unix:/var/run/rtpproxy.sock> found, support for it enabled<br>
Jan 15 16:05:08 [23329] INFO:nathelper:rtpp_test: rtp proxy <unix:/var/run/rtpproxy.sock> found, support for it enabled<br>Registration successful - F=<a href="mailto:sip%3A64820062@192.168.12.254" target="_blank">sip:64820062@192.168.12.254</a> IP=10.254.52.120 UA=CM5K-TA1S (712280) <br>
<br>Jan 15 16:05:08 [23336] INFO:nathelper:rtpp_test: rtp proxy <unix:/var/run/rtpproxy.sock> found, support for it enabled<br>Jan 15 16:05:08 [23338] INFO:nathelper:rtpp_test: rtp proxy <unix:/var/run/rtpproxy.sock> found, support for it enabled<br>
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)<br>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<br>
Jan 15 16:05:08 [23340] ERROR:core:init_mod_child: failed to initializing module usrloc, rank 27<br>Jan 15 16:05:08 [23340] ERROR:core:tcp_init_children: init_children failed<br>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)<br>
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<br>Jan 15 16:05:08 [23339] ERROR:core:init_mod_child: failed to initializing module usrloc, rank 26<br>
Jan 15 16:05:08 [23339] ERROR:core:tcp_init_children: init_children failed<br>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)<br>
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<br>Jan 15 16:05:08 [23341] ERROR:core:init_mod_child: failed to initializing module usrloc, rank 28<br>
Jan 15 16:05:08 [23341] ERROR:core:tcp_init_children: init_children failed<br>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)<br>
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<br>Jan 15 16:05:08 [23310] ERROR:core:init_mod_child: failed to initializing module usrloc, rank 0<br>
Jan 15 16:05:08 [23310] ERROR:core:main_loop: error in init_child for PROC_MAIN<br>Jan 15 16:05:08 [23335] INFO:core:sig_usr: signal 15 received<br>Jan 15 16:05:08 [23334] INFO:core:sig_usr: signal 15 received<br>Jan 15 16:05:08 [23333] INFO:core:sig_usr: signal 15 received<br>
Jan 15 16:05:08 [23332] INFO:core:sig_usr: signal 15 received<br>Jan 15 16:05:08 [23331] INFO:core:sig_usr: signal 15 received<br>....<br>..<br>..<br>.<br><br>any idea?<br>rafo<br><br>