<div>have you set this option in the config</div>
<div> </div>
<div>"<b class="highlight">mysql</b>://user:db_password@remote_db_ip_address/opensips"<br><br><br></div>
<div class="gmail_quote">On Mon, Jan 11, 2010 at 12:15 PM, Alok Kushwaha <span dir="ltr"><<a href="mailto:alok.cs04@gmail.com">alok.cs04@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Hi! All,<br>I am using opensips 1.5 and installed using source. my DB server (mysql) is running on a remote machine. I have enabled the remote access and granted the proper privileges.<br>
<br>I started the opensips with " service opensips start " but it stopped in 2 minutes.<br>and follwing error message is logged - (in /var/log/message) <br><br>Jan 11 07:01:15 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.11<br>
Jan 11 07:01:35 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.12<br>Jan 11 07:01:55 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.13<br>Jan 11 07:02:15 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.14<br>
Jan 11 07:02:35 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.15<br>Jan 11 07:02:56 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.11<br>Jan 11 07:03:16 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.12<br>
Jan 11 07:03:36 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.13<br>Jan 11 07:03:56 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.14<br>Jan 11 07:04:16 localhost opensips: WARNING:core:fix_socket_list: could not rev. resolve 200.200.100.15<br>
Jan 11 07:04:16 localhost opensips: INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected)<br>Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: NOTICE:core:main: version: opensips 1.5.0-notls (i386/linux)<br>
Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:core:main: using 32 Mb shared memory<br>Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:core:main: using 1 Mb private memory per process<br>Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: NOTICE:signaling:mod_init: initializing module ...<br>
Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:sl:mod_init: Initializing StateLess engine<br>Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:tm:mod_init: TM - initializing...<br>Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:maxfwd:mod_init: initializing...<br>
Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:usrloc:ul_init_locks: locks array size 512<br>Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:registrar:mod_init: initializing...<br>Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:textops:mod_init: initializing...<br>
Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:xlog:mod_init: initializing...<br>Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:acc:mod_init: initializing...<br>Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:auth:mod_init: initializing...<br>
Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:auth_db:mod_init: initializing...<br>Jan 11 07:04:36 localhost /usr/local/sbin/opensips[4645]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb<br>
Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4645]:last message repeated 5 times<br>Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4663]: ERROR:db_mysql:db_mysql_new_connection: driver error(2003): Can't connect to MySQL server on '200.200.100.22' (4)<br>
Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4663]: ERROR:core:db_do_init: could not add connection to the pool<br>Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4663]: ERROR:auth_db:child_init: unable to connect to the database<br>
Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4663]: ERROR:core:init_mod_child: failed to initializing module auth_db, rank 17<br>Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4663]: ERROR:core:main_loop: init_child failed for UDP listener<br>
Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4665]: ERROR:db_mysql:db_mysql_new_connection: driver error(2003): Can't connect to MySQL server on '200.200.100.22' (4)<br><br><br><br>for me it's look like some problem in core module. but i don't where to find it.<br>
please tell me why it's stopped.<br>any help is appreciated.<br>thanks in advance.<br clear="all"><font color="#888888"><br>-- <br>Regards,<br>Alok Kushwaha<br><br><br> <br>"always be the reason of someones happiness."<br>
</font><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br>