yes, with same <user-name> and <passwd> i am able to login from opensips box to remote mysql server.<br><br><div class="gmail_quote">On Mon, Jan 18, 2010 at 11:41 AM, ram-2-3 [via OpenSIPS (Open SIP Server)] <span dir="ltr"><<a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4414072&i=0" target="_top" rel="nofollow">[hidden email]</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<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="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4412061&i=0" rel="nofollow" target="_blank">[hidden email]</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); 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>"mysql://user:db_password@remote_db_ip_address/opensips"<br><br><br></div>
<div>
<div></div>
<div>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"<div><div></div><div class="h5"><br>><br>><br>> On Mon, Jan 11, 2010 at 12:15 PM, Alok Kushwaha <<a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4412061&i=1" rel="nofollow" target="_blank">[hidden email]</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>
</div></div>
>> _______________________________________________<br>>> Users mailing list<br>>> <a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4412061&i=2" rel="nofollow" target="_blank">[hidden email]</a><br>
>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="nofollow" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>><br>>><br>><br>> _______________________________________________<br>> Users mailing list<br>> <a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4412061&i=3" rel="nofollow" target="_blank">[hidden email]</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="nofollow" 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" rel="nofollow" target="_blank">http://n2.nabble.com/Need-Help-on-integrating-opensips-with-mysql-on-remote-machine-tp4287536p4408184.html</a><br>
</font>
<div>Sent from the OpenSIPS - Users mailing list archive at Nabble.com.<br><br>_______________________________________________<br></div>
<div>
<div></div>
<div>Users mailing list<br><a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4412061&i=4" rel="nofollow" target="_blank">[hidden email]</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="nofollow" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br>
<br>_______________________________________________
<br>Users mailing list
<br><a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4412061&i=5" rel="nofollow" target="_blank">[hidden email]</a>
<br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="nofollow" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Alok Kushwaha<br>Citrix R&D India Pvt. Ltd.<br>Netscaler Product Group<br>Bangalore -560025<br> <br>"always be the reason of someones happiness."<br>
<br><hr align="left" width="300">
View this message in context: <a href="http://n2.nabble.com/Need-Help-on-integrating-opensips-with-mysql-on-remote-machine-tp4287536p4414072.html">Re: [OpenSIPS-Users] Need Help on integrating opensips with mysql on remote machine</a><br>
Sent from the <a href="http://n2.nabble.com/OpenSIPS-Users-f1449235.html">OpenSIPS - Users mailing list archive</a> at Nabble.com.<br>