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

[Rafael Risco Gonzales-Vigil]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090115/2f205a23/attachment.htm