<div>are you able to login to remote mysql server from opensips box ?<br><br></div>
<div class="gmail_quote">On Sun, Jan 17, 2010 at 5:50 AM, 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"><br>Hi! ram<br>thanks for reply.<br><br>yes , i have set this option. like -<br>
<div class="im">"mysql://user:db_password@remote_db_ip_address/opensips"<br><br><br></div>
<div>
<div></div>
<div class="h5">ram-2-3 wrote:<br>><br>> have you set this option in the config<br>><br>> "*mysql*://user:db_password@remote_db_ip_address/opensips"<br>><br>><br>> On Mon, Jan 11, 2010 at 12:15 PM, Alok Kushwaha <<a href="mailto:alok.cs04@gmail.com">alok.cs04@gmail.com</a>><br>
> wrote:<br>><br>>> Hi! All,<br>>> I am using opensips 1.5 and installed using source. my DB server (mysql)<br>>> is<br>>> running on a remote machine. I have enabled the remote access and granted<br>
>> the proper privileges.<br>>><br>>> I started the opensips with " service opensips start " but it stopped in<br>>> 2<br>>> 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<br>>> not<br>>> rev. resolve 200.200.100.11<br>>> Jan 11 07:01:35 localhost opensips: WARNING:core:fix_socket_list: could<br>
>> not<br>>> rev. resolve 200.200.100.12<br>>> Jan 11 07:01:55 localhost opensips: WARNING:core:fix_socket_list: could<br>>> not<br>>> rev. resolve 200.200.100.13<br>>> Jan 11 07:02:15 localhost opensips: WARNING:core:fix_socket_list: could<br>
>> not<br>>> rev. resolve 200.200.100.14<br>>> Jan 11 07:02:35 localhost opensips: WARNING:core:fix_socket_list: could<br>>> not<br>>> rev. resolve 200.200.100.15<br>>> Jan 11 07:02:56 localhost opensips: WARNING:core:fix_socket_list: could<br>
>> not<br>>> rev. resolve 200.200.100.11<br>>> Jan 11 07:03:16 localhost opensips: WARNING:core:fix_socket_list: could<br>>> not<br>>> rev. resolve 200.200.100.12<br>>> Jan 11 07:03:36 localhost opensips: WARNING:core:fix_socket_list: could<br>
>> not<br>>> rev. resolve 200.200.100.13<br>>> Jan 11 07:03:56 localhost opensips: WARNING:core:fix_socket_list: could<br>>> not<br>>> rev. resolve 200.200.100.14<br>>> Jan 11 07:04:16 localhost opensips: WARNING:core:fix_socket_list: could<br>
>> not<br>>> rev. resolve 200.200.100.15<br>>> Jan 11 07:04:16 localhost opensips: INFO:core:init_tcp: using epoll_lt as<br>>> the TCP io watch method (auto detected)<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>
>> NOTICE:core:main:<br>>> version: opensips 1.5.0-notls (i386/linux)<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:core:main:<br>>> using 32 Mb shared memory<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]: INFO:core:main:<br>
>> using 1 Mb private memory per process<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>>> NOTICE:signaling:mod_init: initializing module ...<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>
>> INFO:sl:mod_init:<br>>> Initializing StateLess engine<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>>> INFO:tm:mod_init:<br>>> TM - initializing...<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>
>> INFO:maxfwd:mod_init: initializing...<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>>> INFO:usrloc:ul_init_locks: locks array size 512<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>
>> INFO:registrar:mod_init: initializing...<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>>> INFO:textops:mod_init: initializing...<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>
>> INFO:xlog:mod_init: initializing...<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>>> INFO:acc:mod_init: initializing...<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>
>> INFO:auth:mod_init: initializing...<br>>> Jan 11 07:04:16 localhost /usr/local/sbin/opensips[4645]:<br>>> INFO:auth_db:mod_init: initializing...<br>>> Jan 11 07:04:36 localhost /usr/local/sbin/opensips[4645]:<br>
>> 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<br>>> repeated 5 times<br>>> Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4663]:<br>
>> ERROR:db_mysql:db_mysql_new_connection: driver error(2003): Can't connect<br>>> to<br>>> MySQL server on '200.200.100.22' (4)<br>>> Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4663]:<br>
>> ERROR:core:db_do_init: could not add connection to the pool<br>>> Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4663]:<br>>> ERROR:auth_db:child_init: unable to connect to the database<br>>> Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4663]:<br>
>> 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]:<br>>> ERROR:core:main_loop: init_child failed for UDP listener<br>
>> Jan 11 07:06:36 localhost /usr/local/sbin/opensips[4665]:<br>>> ERROR:db_mysql:db_mysql_new_connection: driver error(2003): Can't connect<br>>> to<br>>> 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<br>>> find it.<br>>> please tell me why it's stopped.<br>>> any help is appreciated.<br>
>> thanks in advance.<br>>><br>>> --<br>>> Regards,<br>>> Alok Kushwaha<br>>><br>>><br>>><br>>> "always be the reason of someones happiness."<br>>><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>>><br>><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>><br><br></div></div><font color="#888888">--<br>View this message in context: <a href="http://n2.nabble.com/Need-Help-on-integrating-opensips-with-mysql-on-remote-machine-tp4287536p4408184.html" target="_blank">http://n2.nabble.com/Need-Help-on-integrating-opensips-with-mysql-on-remote-machine-tp4287536p4408184.html</a><br>
</font>
<div class="im">Sent from the OpenSIPS - Users mailing list archive at Nabble.com.<br><br>_______________________________________________<br></div>
<div>
<div></div>
<div class="h5">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>
</div></div></blockquote></div><br>