Iam facing one more problem. <br><br>Iam running my set up on 64bit processor. Opensips and asterisk on one PC and Mysql server on seperate PC.<br><br>Iam running on RHEL enterprise version.<br><br>Problem is that, its taking more than 2 mins to connect to MySQL server when i start Opensips. Also user is not getting registered. of 10 attmept, only 1 is getting successful. But even this is not consistent.<br>
<br>I have increased connection_timeout in /etc/my.cnf also. But still facing the same problem.<br><br>Any insight ?<br><br><br>Jun 9 03:36:03 204548-4 /usr/local/sbin/opensips[7575]: DBG:db_mysql:db_mysql_connect: opening connection: mysql://xxxx:xxxx@MySQLserver/opensips <br>
Jun 9 03:36:03 204548-4 /usr/local/sbin/opensips[7576]: DBG:core:init_mod_child: type=PROC_TCP_MAIN, rank=-4, module=acc <br>Jun 9 03:36:03 204548-4 /usr/local/sbin/opensips[7576]: DBG:core:init_mod_child: type=PROC_TCP_MAIN, rank=-4, module=auth_db <br>
Jun 9 03:36:03 204548-4 /usr/local/sbin/opensips[7576]: DBG:core:db_do_init: connection 0x79e858 not found in pool <br>Jun 9 03:36:03 204548-4 /usr/local/sbin/opensips[7576]: DBG:db_mysql:db_mysql_connect: opening connection: mysql://xxxx:xxxx@MySQLserver/opensips <br>
Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]: ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect to MySQL server on 'MySQLserver' (110) <br>Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]: ERROR:db_mysql:db_mysql_new_connection: initial connect failed <br>
Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]: ERROR:core:db_do_init: could not add connection to the pool <br>Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]: ERROR:auth_db:child_init: unable to connect to the database <br>
Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]: ERROR:core:init_mod_child: failed to initializing module auth_db, rank 3 <br>Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]: ERROR:core:main_loop: init_child failed for UDP listener <br>
Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]: ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect to MySQL server on 'MySQL server' (110) <br>Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]: ERROR:db_mysql:db_mysql_new_connection: initial connect failed <br>
Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]: ERROR:core:db_do_init: could not add connection to the pool <br>Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]: ERROR:usrloc:child_init: child(0): failed to connect to database <br>
Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]: ERROR:core:init_mod_child: failed to initializing module usrloc, rank 0 <br>Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]: ERROR:core:main_loop: error in init_child for PROC_MAIN <br>
Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]: DBG:xlog:destroy: destroy module... <br><br><div class="gmail_quote">On Wed, Jun 9, 2010 at 1:04 PM, ram <span dir="ltr"><<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.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;"><div>depends on the design</div>
<div> </div>
<div>you can have one point of authenticaion and transaction</div>
<div> </div><font color="#888888">
<div>Ram</div></font><div><div></div><div class="h5">
<div><br><br> </div>
<div class="gmail_quote">On Tue, Jun 8, 2010 at 10:59 PM, Premalatha Kuppan <span dir="ltr"><<a href="mailto:premalatha@ngintech.com" target="_blank">premalatha@ngintech.com</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">
<div>Thanks a lot. </div>
<div> </div>
<div>I have one question. If i route the call to asterisk for IVR ( in my case ivr is to authenticate the user to access the system), who will have the control, meaning who will maintian all the transactions and dailog. Is it opensips/Asterisk ?</div>
<div> </div>
<div>Thanks,</div>
<div>Prem<br><br></div>
<div>
<div></div>
<div>
<div class="gmail_quote">On Tue, Jun 8, 2010 at 9:50 AM, Gabriel Bermudez <span dir="ltr"><<a href="mailto:elgabo81@gmail.com" target="_blank">elgabo81@gmail.com</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">Hi,<br><br>I basically use the load_balancer module to dispatch to different<br>asterisk servers<br>
<br>on the main route block after handling auth, registrations, etc<br>
<br>if(db_is_user_in("Request-URI", "ccivr")) {<br> xlog("The call will be redirect to calling card server");<br> route(3);<br>}<br><br># route for call handled by calling card servers<br>
route[3] {<br> # for INVITEs enable some additional helper routes<br> if (is_method("INVITE")) {<br> t_on_branch("2");<br> t_on_reply("2");<br> t_on_failure("1");<br>
if(client_nat_test("15")) {<br> nat_keepalive();<br> }<br> }<br><br> # prepare the message for the IVR<br><br> # select less loaded IVR<br> if(!load_balance("1", "ccivr")) {<br>
xlog("No IVR available !!!");<br> sl_send_reply("503", "Service Unavailable");<br> exit;<br> };<br><br> if(!t_relay()) {<br> sl_reply_error();<br>
exit;<br> }<br><br> exit;<br><br>}<br><br><br>Hope it helps<br><br>Regards,<br><br>2010/6/8 ram <<a href="mailto:talk2ram@gmail.com" target="_blank">talk2ram@gmail.com</a>>:<br>
<div>
<div></div>
<div>> I forgot the link<br>><br>> i did this work some time back<br>><br>> Lost the link, google it<br>><br>> Opensips+asterisk+a2b<br>><br>> Ram<br>><br>> On Mon, Jun 7, 2010 at 4:07 PM, Premalatha Kuppan <<a href="mailto:premalatha@ngintech.com" target="_blank">premalatha@ngintech.com</a>><br>
> wrote:<br>>><br>>> Can you pleae guide me how to do this ?<br>>><br>>> On Mon, Jun 7, 2010 at 4:04 PM, Douglas Lane <<a href="mailto:doug@wd.co.za" target="_blank">doug@wd.co.za</a>> wrote:<br>
>>><br>>>> Hi Premalatha,<br>>>><br>>>> Perhaps have a look at SEMS for this.<br>>>><br>>>> Thanks<br>>>> Doug<br>>>><br>>>><br>>>> On 2010/06/07 12:30 PM, Premalatha Kuppan wrote:<br>
>>><br>>>> Thanks Sebastian.<br>>>><br>>>> I have followed up this link and tried extending the opensips.cfg file to<br>>>> route call to Asterisk.<br>>>><br>>>> I doubt/not clear that after IVR (meaning when the user is authenticated<br>
>>> through IVR) who will handle all the transactions and dialog (OPENSIPS or<br>>>> Asterisk ) ?<br>>>><br>>>> I want Opensips to handle all the transactions.<br>>>><br>>>> Any insight on this ?<br>
>>><br>>>> Thanks,<br>>>> Prem<br>>>><br>>>> On Mon, Jun 7, 2010 at 3:15 PM, Schumann Sebastian<br>>>> <<a href="mailto:Sebastian.Schumann@t-com.sk" target="_blank">Sebastian.Schumann@t-com.sk</a>> wrote:<br>
>>>><br>>>>> Hi Prem<br>>>>><br>>>>> There is a good tutorial at<br>>>>> <a href="http://www.opensips.org/Resources/DocsTutAsterisk" target="_blank">http://www.opensips.org/Resources/DocsTutAsterisk</a> It does exactly what you<br>
>>>> need I assume.<br>>>>><br>>>>> For details in writing and extending basic configuration, you can find<br>>>>> also the linked documentation there.<br>>>>><br>
>>>> Best regards<br>>>>> Sebastian<br>>>>><br>>>>> > -----Original Message-----<br>>>>> > From: <a href="mailto:users-bounces@lists.opensips.org" target="_blank">users-bounces@lists.opensips.org</a> [mailto:<a href="mailto:users-" target="_blank">users-</a><br>
>>>> > <a href="mailto:bounces@lists.opensips.org" target="_blank">bounces@lists.opensips.org</a>] On Behalf Of Premalatha Kuppan<br>>>>> > Sent: Monday, 07. June 2010 11:35<br>>>>> > To: OpenSIPS users mailling list<br>
>>>> > Subject: [OpenSIPS-Users] OPENSIPS+ASTERISK Integration<br>>>>> ><br>>>>> > Hi,<br>>>>> ><br>>>>> > Can anyone guide me in building the Opensips and Asterisk Integration.<br>
>>>> ><br>>>>> > I want to Use OpenSIPS as SIP PROXY (i.e all transactions and dialogs<br>>>>> > should be<br>>>>> > handled by Opensips) and Asterisk to do only IVR functionality.<br>
>>>> ><br>>>>> > I appreciate if anyone can guide me in writing a routing logic from<br>>>>> > Opensips to<br>>>>> > Asterisk for IVR and futher call flow OPENSIPS to handle.<br>
>>>> ><br>>>>> > Thanks,<br>>>>> > Prem<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>>>> 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>
>>> 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>>> 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>
> 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>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><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></blockquote></div><br>
</div></div><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>