Hi ,<br><br>I running Mysql server on seperate PC and OPENSIPS on seperate PC. First time when i start opensips, its taking lot of time to connect, appro: 2 min 50 secs.<br><br>So, all registration fails.<br><br><br>May 31 <b>09:11:23</b> 204548-4 /usr/local/sbin/opensips[27971]: DBG:db_mysql:db_mysql_connect: opening connection: mysql://<a href="http://xxxx:xxxx@10.140.1.120/opensips">xxxx:xxxx@10.140.1.120/opensips</a> <br>
May 31<b> 09:13:58</b> 204548-4 /usr/local/sbin/opensips[27971]: DBG:db_mysql:db_mysql_connect: connection type is 10.140.1.120 via TCP/IP <br><br>After subsquent attempts, User is getting registered. But not consistent.<br>
<br>After sometime; i can see in log file,<br>May 31 09:18:48 204548-4 /usr/local/sbin/opensips[28167]: DBG:core:grep_sock_info: checking if port 5060 matches port 5060 <br>May 31 09:18:48 204548-4 /usr/local/sbin/opensips[28167]: DBG:auth:check_nonce: comparing [4c03b73c0000000d81a4fdaeb1ffc73590e1f3345dbf9bda] and [4c03b73c0000000d81a4fdaeb1ffc73590e1f3345dbf9bda] <br>
May 31 09:18:48 204548-4 /usr/local/sbin/opensips[28167]: DBG:db_mysql:has_stmt_ctx: ctx found for subscriber <br>May 31 09:18:48 204548-4 /usr/local/sbin/opensips[28167]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x79a9f0 (tail=7973264) MC=0x79cf40 <br>
May 31 09:18:48 204548-4 /usr/local/sbin/opensips[28167]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run <br>May 31 09:18:48 204548-4 /usr/local/sbin/opensips[28167]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=3; type=254; is_null=0 <br>
May 31 09:18:48 204548-4 /usr/local/sbin/opensips[28167]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in... <br>May 31 09:19:13 204548-4 /usr/local/sbin/opensips[28175]: <b style="color: rgb(153, 0, 0);">ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect to MySQL server on '10.140.1.120' (110) <br>
May 31 09:19:13 204548-4 /usr/local/sbin/opensips[28175]: ERROR:db_mysql:db_mysql_new_connection: initial connect failed <br>May 31 09:19:13 204548-4 /usr/local/sbin/opensips[28175]: ERROR:core:db_do_init: could not add connection to the pool <br>
May 31 09:19:13 204548-4 /usr/local/sbin/opensips[28175]: ERROR:auth_db:child_init: unable to connect to the database <br>May 31 09:19:13 204548-4 /usr/local/sbin/opensips[28175]: ERROR:core:init_mod_child: failed to initializing module auth_db, rank 7 <br>
May 31 09:19:13 204548-4 /usr/local/sbin/opensips[28175]: ERROR:core:tcp_init_children: init_children failed <br>May 31 09:19:13 204548-4 /usr/local/sbin/opensips[27971]: ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect to MySQL server on '10.140.1.120' (110) <br>
May 31 09:19:13 204548-4 /usr/local/sbin/opensips[27971]: ERROR:db_mysql:db_mysql_new_connection: initial connect failed </b><br>May 31 09:19:13 204548-4 /usr/local/sbin/opensips[27971]: ERROR:core:db_do_init: could not add connection to the pool <br>
May 31 09:19:13 204548-4 /usr/local/sbin/opensips[27971]: ERROR:usrloc:child_init: child(0): failed to connect to database <br>May 31 09:19:13 204548-4 /usr/local/sbin/opensips[27971]: ERROR:core:init_mod_child: failed to initializing module usrloc, rank 0 <br>
May 31 09:19:13 204548-4 /usr/local/sbin/opensips[27971]: ERROR:core:main_loop: error in init_child for PROC_MAIN <br>May 31 09:19:13 204548-4 /usr/local/sbin/opensips[27971]: DBG:xlog:destroy: destroy module... <br><br><br>
Can any1 help me out, what is missing?<br><br>Thanks,<br><br><br><br><br><div class="gmail_quote">On Thu, May 27, 2010 at 7:26 PM, Premalatha Kuppan <span dir="ltr"><<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</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;">Hi Bogdan,<br><br>Have you seen my opensips.cfg file. Is that correct ?<br><br>Thanks,<br>Prem<div>
<div></div><div class="h5"><br><br><br><div class="gmail_quote">On Thu, May 27, 2010 at 7:19 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</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;">The reply you posted seams to come from opensips (see the Server<br>
header)...it seams the REGISTER gets to opensips, but opensips cannot<br>
forward it (the RURI is not resolvable via DNS).<br>
<br>
Maybe you can post the full SIP trace from xlite diagnostic.<br>
<div><br>
Regards,<br>
Bogdan<br>
<br>
<br>
Premalatha Kuppan wrote:<br>
</div><div>> I couldn't see any log at Opensips.<br>
><br>
> I have attached my /usr/local/etc/opensips/opensips.cfg file too.<br>
> Please tell me whats wrong in that.<br>
><br>
> Also i have set SIP_DOMAIN=opensips (export SIP_DOMAIN=opensips)<br>
><br>
> At xlite: Diagnostic log: i see 476 unresolvable destination<br>
> RECEIVE TIME: 3545688717<br>
</div>> RECEIVE << <a href="http://10.140.1.110:5060" target="_blank">10.140.1.110:5060</a> <<a href="http://10.140.1.110:5060" target="_blank">http://10.140.1.110:5060</a>><br>
<div><div></div><div>> SIP/2.0 *476 Unresolvable destination (476/TM) *<br>
> Via: SIP/2.0/UDP<br>
> 10.140.1.103:5060;rport=5060;branch=z9hG4bK7D40C114C611CB3CD48AB170D43528DC<br>
><br>
> From: 100 <sip:100@opensips>;tag=230907502<br>
> To: 100 <sip:100@opensips>;tag=65a8173f323da42f74a97c90a2e694f7-b6e3<br>
> Call-ID: 1A300741EB1C1E842BFF6333D8D43E60@opensips<br>
> CSeq: 48981 REGISTER<br>
> Server: OpenSIPS (1.6.2-tls (x86_64/linux))<br>
> Content-Length: 0<br>
><br>
> 1. When i start opensips, /etc/init.d/opensips - it shows running. But<br>
> after some time,<br>
> when i check the status: /etc/init.d/opensips status: I see "opensips<br>
> dead but subsys locked"<br>
><br>
> 2. Also, when Opensips is running, i tried "*opensipsctl ul show*",<br>
> iam getting following error,<br>
> "opensipsctl ul show<br>
> database engine 'MYSQL' loaded<br>
> Control engine 'FIFO' loaded<br>
> entering fifo_cmd ul_dump<br>
> ERROR: Error opening OpenSIPS's FIFO /tmp/opensips_fifo<br>
> ERROR: Make sure you have the line 'modparam("mi_fifo", "fifo_name",<br>
> "/tmp/opensips_fifo")' in your config<br>
> ERROR: and also have loaded the mi_fifo module.<br>
> "<br>
> mi_fifo is.so is available. But opensips_fifo is not available in that<br>
> directory. From where should i copy the opensips_fifo in to /tmp.<br>
><br>
><br>
> Can you please help me. I have attached my .cfg file.<br>
><br>
> Thanks,<br>
> Prem<br>
><br>
> On Wed, May 26, 2010 at 1:04 AM, Bogdan-Andrei Iancu<br>
</div></div><div><div></div><div>> <<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a> <mailto:<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>>> wrote:<br>
><br>
> Do you see the REGISTER getting to your opensips ? what is the reply<br>
> send back to xlite?<br>
><br>
> Regards,<br>
> Bogdan<br>
><br>
> Premalatha Kuppan wrote:<br>
> > Thanks, meaning in my config file do i need to uncomment the<br>
> following<br>
> > (below mail from you) and comment the following lines ?,<br>
> > # authenticate the REGISTER requests (uncomment to enable auth)<br>
> > if (!www_authorize("10.140.1.110", "subscriber"))<br>
> > {<br>
> > www_challenge("10.140.1.110", "0");<br>
> > exit;<br>
> > }<br>
> ><br>
> > I tried this too...But still facing problem.<br>
> ><br>
> > Probably my set up overview:<br>
> > 1.Opensips 1.6.2_tls: i hav etaken the src code and compiled on Red<br>
> > Hat Linux 5 enterprise version.<br>
> > 2. MySQL is running on seperate PC (10.10.1.2), i created the<br>
> MySQL of<br>
> > OPENSIPS in that seperate PC (10.10.1.2)<br>
> > 3. copied the opensips.init and opensips.default from packaging/rpm<br>
> > 4. created user using opensipsctl add 200 200<br>
> > 5. corresponding entries updated in MySQL. I have changed the<br>
> > SIP_DOMIAN to opensips.<br>
> > 6. Now testing call flow through xlite. i hav included in /etc/hosts<br>
> > opensips domain IP.<br>
> ><br>
> > Can you please help me. Where the problem is ? How to fix it. I<br>
> > appreciate your kind help.<br>
> ><br>
> > On Fri, May 21, 2010 at 7:57 PM, Stefano Pisani<br>
> > <<a href="mailto:stefano.pisani@omnianet.it" target="_blank">stefano.pisani@omnianet.it</a> <mailto:<a href="mailto:stefano.pisani@omnianet.it" target="_blank">stefano.pisani@omnianet.it</a>><br>
> <mailto:<a href="mailto:stefano.pisani@omnianet.it" target="_blank">stefano.pisani@omnianet.it</a><br>
> <mailto:<a href="mailto:stefano.pisani@omnianet.it" target="_blank">stefano.pisani@omnianet.it</a>>>> wrote:<br>
> ><br>
> > you uncommented the wrong lines.<br>
> > you have to uncomment these lines<br>
> ><br>
> > # authenticate if from local subscriber (uncomment to<br>
> enable auth)<br>
> > # authenticate all initial non-REGISTER request that<br>
> pretend to be<br>
> > # generated by local subscriber (domain from FROM URI is<br>
> local)<br>
> > ##if (!(method=="REGISTER") && from_uri==myself) /*no<br>
> > multidomain version*/<br>
> > ##if (!(method=="REGISTER") && is_from_local())<br>
> /*multidomain<br>
> > version*/<br>
> > ##{<br>
> > ## if (!proxy_authorize("", "subscriber")) {<br>
> > ## proxy_challenge("", "0");<br>
> > ## exit;<br>
> > ## }<br>
> > ## if (!db_check_from()) {<br>
> > ## sl_send_reply("403","Forbidden auth ID");<br>
> > ## exit;<br>
> > ## }<br>
> > ##<br>
> > ## consume_credentials();<br>
> > ## # caller authenticated<br>
> > ##}<br>
> ><br>
> ><br>
> ><br>
> > Il 21/05/2010 16:21, Premalatha Kuppan ha scritto:<br>
> >> I hv attached my opensips.cfg file<br>
> >><br>
> >><br>
> >><br>
> >><br>
> >><br>
> >> On Fri, May 21, 2010 at 7:37 PM, Premalatha Kuppan<br>
> >> <<a href="mailto:premalatha@ngintech.com" target="_blank">premalatha@ngintech.com</a> <mailto:<a href="mailto:premalatha@ngintech.com" target="_blank">premalatha@ngintech.com</a>><br>
</div></div>> <mailto:<a href="mailto:premalatha@ngintech.com" target="_blank">premalatha@ngintech.com</a> <mailto:<a href="mailto:premalatha@ngintech.com" target="_blank">premalatha@ngintech.com</a>>>><br>
<div>> wrote:<br>
> >><br>
> >> Yes<br>
> >> I created using opensipsctrl add 200 200<br>
> >><br>
> >> But, even in log file i cudn't see nything :(<br>
> >><br>
> >> Iam Opensips running on RHEL, and MySQL on seperate<br>
> machine.<br>
> >> Xlite from one Machine A, i changed the /etc/hosts also.<br>
> >><br>
> >><br>
> >><br>
> >> On Fri, May 21, 2010 at 7:28 PM, Stefano Pisani<br>
> >> <<a href="mailto:stefano.pisani@omnianet.it" target="_blank">stefano.pisani@omnianet.it</a><br>
> <mailto:<a href="mailto:stefano.pisani@omnianet.it" target="_blank">stefano.pisani@omnianet.it</a>><br>
</div><div>> >> <mailto:<a href="mailto:stefano.pisani@omnianet.it" target="_blank">stefano.pisani@omnianet.it</a><br>
</div><div><div></div><div>> <mailto:<a href="mailto:stefano.pisani@omnianet.it" target="_blank">stefano.pisani@omnianet.it</a>>>> wrote:<br>
> >><br>
> >> did you create the user?<br>
> >> post your opensips.cfg<br>
> >><br>
> >> s<br>
> >><br>
> >> Il 21/05/2010 15:48, Premalatha Kuppan ha scritto:<br>
> >>> Hi,<br>
> >>><br>
> >>> When i run /etc/int.d/opensips it show running,<br>
> >>><br>
> >>> /etc/init.d/opensips start<br>
> >>> Starting<br>
> >>> opensips:<br>
> [ OK ]<br>
> >>><br>
> >>> But, cudn't register xlite to Opensips. No info can be<br>
> >>> found in the log file.<br>
> >>><br>
> >>> Please help.<br>
> >>><br>
> >>> [root@204548-4 ~]# tail -f /var/log/messages<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:sl:mod_init: Initializing StateLess engine<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:tm:mod_init: TM - initializing...<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:maxfwd:mod_init: initializing...<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:usrloc:ul_init_locks: locks array size 512<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:registrar:mod_init: initializing...<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:textops:mod_init: initializing...<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:xlog:mod_init: initializing...<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:acc:mod_init: initializing...<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:auth:mod_init: initializing...<br>
> >>> May 21 09:34:05 204548-4<br>
> /usr/local/sbin/opensips[8938]:<br>
> >>> INFO:auth_db:mod_init: initializing...<br>
> >>><br>
> >>> Thanks,<br>
> >>> Prem<br>
> >>><br>
> >>><br>
> >>> _______________________________________________<br>
> >>> Users mailing list<br>
> >>> <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
</div></div>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<div>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>><br>
> >>><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>
> >> Users mailing list<br>
> >> <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
</div>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<div>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>><br>
> >><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>
> >> _______________________________________________<br>
> >> Users mailing list<br>
> >> <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><br>
</div>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>><br>
<div>> >> <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>
> > Users mailing list<br>
> > <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><br>
</div>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>><br>
<div>> > <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>
> ><br>
> > _______________________________________________<br>
> > Users mailing list<br>
> > <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">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>> --<br>
> Bogdan-Andrei Iancu<br>
> <a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a> <<a href="http://www.voice-system.ro" target="_blank">http://www.voice-system.ro</a>><br>
<div><div></div><div>><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">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>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org" target="_blank">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>
Bogdan-Andrei Iancu<br>
<a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">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>
</div></div></blockquote></div><br>