Hi Bogdan,<br><br>Thanks for yor reply. <br><br>Can you brief me about the "lookup(location) to send the call to the callee device."<br><br>Here, during the IVR the user will sent the callee #, i have to fetch the corresponding IP addr of that callee from the database to route the call. From asterisk, i can do that by connecting to mysql and fetch the IP of that callee from the DB. I wonder how it can be done at opensips.<br>
<br>If you could help me in briefing more on "lookup(location) to send the call to the callee device" from opensips. I appreciate.<br><br>Thanks,<br>Prem<br><br><br><div class="gmail_quote">On Fri, Jun 11, 2010 at 2:26 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">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;">Hi Prem,<br>
<br>
Once asterisk did the IVR based auth, I suggest that asterisk should<br>
route the SIP call back to OpenSIPS - and OpenSIPS will do the<br>
lookup(location) to send the call to the callee device.<br>
<br>
In OpenSIPS, based on source Ip, you can have 2 routing logics - if call<br>
comes from Asterisk -> outbound routing ; if not from asterisk -><br>
inbound logic.<br>
<div class="im"><br>
Regards,<br>
Bogdan<br>
<br>
Premalatha Kuppan wrote:<br>
</div><div class="im">> Yes, i have checked all these options. Everything is in correct status.<br>
><br>
> I doubt, connecting between vmware and with 64 bit RHEL. My set is<br>
> running on vmware image. When i ping on from vmware where<br>
> opensips+asterisk is running to the MySQL server vmware image, i see<br>
> this problem. But when i set MySQL server on non-vmware, it works<br>
> perferctly fine.<br>
><br>
> i 'll update once i figure out the reason.<br>
><br>
> Between, to route a call from OPENSIP to the destination. I need to<br>
> fetch the destination details IP from MySQL DB.<br>
> Meaning,<br>
><br>
> User --------><br>
> OPENSIPS(1)--------->ASTERISK(IVR)-------------->OPENSIPS(1)----------------->Destination<br>
><br>
> Here, for authentication user enters the PIn and extension to access,<br>
> if the extension is present in the DB, Asterisk(IVR) will allow the<br>
> user to access it. From this from asterisk, i can make query to DB and<br>
> fetch the neccessary details. Likewise is it possible to fetch the<br>
> details(IP where the extension is connected and to be routed) from DB<br>
> from opensips.cfg to route the call to requested destination.<br>
><br>
> Thanks,<br>
> Prem<br>
><br>
> On Thu, Jun 10, 2010 at 3:01 PM, Bogdan-Andrei Iancu<br>
</div><div><div></div><div class="h5">> <<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a> <mailto:<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>>> wrote:<br>
><br>
> Are you sure the DB conn params are correct (like address of myql<br>
> server) ?<br>
><br>
> Also are you sure the mysql server is remotely reachable (it<br>
> listens on<br>
> routable IP and there is no firewall in front)<br>
><br>
> Have you tried to connect to mysql by using directly the mysql<br>
> client -<br>
> just to see if it works?<br>
><br>
> Regards,<br>
> Bogdan<br>
><br>
> Premalatha Kuppan wrote:<br>
> > Iam facing one more problem.<br>
> ><br>
> > Iam running my set up on 64bit processor. Opensips and asterisk<br>
> on one<br>
> > 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<br>
> > server when i start Opensips. Also user is not getting<br>
> registered. of<br>
> > 10 attmept, only 1 is getting successful. But even this is not<br>
> consistent.<br>
> ><br>
> > I have increased connection_timeout in /etc/my.cnf also. But still<br>
> > facing the same problem.<br>
> ><br>
> > Any insight ?<br>
> ><br>
> ><br>
> > Jun 9 03:36:03 204548-4 /usr/local/sbin/opensips[7575]:<br>
> > DBG:db_mysql:db_mysql_connect: opening connection:<br>
> > mysql://xxxx:xxxx@MySQLserver/opensips<br>
> > Jun 9 03:36:03 204548-4 /usr/local/sbin/opensips[7576]:<br>
> > 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]:<br>
> > 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]:<br>
> > DBG:core:db_do_init: connection 0x79e858 not found in pool<br>
> > Jun 9 03:36:03 204548-4 /usr/local/sbin/opensips[7576]:<br>
> > DBG:db_mysql:db_mysql_connect: opening connection:<br>
> > mysql://xxxx:xxxx@MySQLserver/opensips<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]:<br>
> > ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't<br>
> connect to<br>
> > MySQL server on 'MySQLserver' (110)<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]:<br>
> > ERROR:db_mysql:db_mysql_new_connection: initial connect failed<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]:<br>
> > 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]:<br>
> > ERROR:auth_db:child_init: unable to connect to the database<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]:<br>
> > ERROR:core:init_mod_child: failed to initializing module<br>
> auth_db, rank 3<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7567]:<br>
> > ERROR:core:main_loop: init_child failed for UDP listener<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]:<br>
> > ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't<br>
> connect to<br>
> > MySQL server on 'MySQL server' (110)<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]:<br>
> > ERROR:db_mysql:db_mysql_new_connection: initial connect failed<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]:<br>
> > 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]:<br>
> > ERROR:usrloc:child_init: child(0): failed to connect to database<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]:<br>
> > ERROR:core:init_mod_child: failed to initializing module usrloc,<br>
> rank 0<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]:<br>
> > ERROR:core:main_loop: error in init_child for PROC_MAIN<br>
> > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]:<br>
> > DBG:xlog:destroy: destroy module...<br>
> ><br>
> > On Wed, Jun 9, 2010 at 1:04 PM, ram <<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a><br>
> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a>><br>
</div></div><div class="im">> > <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a>>>> wrote:<br>
> ><br>
> > depends on the design<br>
> ><br>
> > you can have one point of authenticaion and transaction<br>
> ><br>
> > Ram<br>
> ><br>
> ><br>
> ><br>
> > On Tue, Jun 8, 2010 at 10:59 PM, Premalatha Kuppan<br>
> > <<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>><br>
</div>> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>>>><br>
<div class="im">> wrote:<br>
> ><br>
> > Thanks a lot.<br>
> ><br>
> > I have one question. If i route the call to asterisk for<br>
> IVR (<br>
> > in my case ivr is to authenticate the user to access the<br>
> > system), who will have the control, meaning who will<br>
> maintian<br>
> > all the transactions and dailog. Is it opensips/Asterisk ?<br>
> ><br>
> > Thanks,<br>
> > Prem<br>
> ><br>
> > On Tue, Jun 8, 2010 at 9:50 AM, Gabriel Bermudez<br>
> > <<a href="mailto:elgabo81@gmail.com">elgabo81@gmail.com</a> <mailto:<a href="mailto:elgabo81@gmail.com">elgabo81@gmail.com</a>><br>
</div><div><div></div><div class="h5">> <mailto:<a href="mailto:elgabo81@gmail.com">elgabo81@gmail.com</a> <mailto:<a href="mailto:elgabo81@gmail.com">elgabo81@gmail.com</a>>>> wrote:<br>
> ><br>
> > Hi,<br>
> ><br>
> > I basically use the load_balancer module to dispatch to<br>
> > different<br>
> > asterisk servers<br>
> ><br>
> > on the main route block after handling auth,<br>
> > registrations, etc<br>
> ><br>
> > if(db_is_user_in("Request-URI", "ccivr")) {<br>
> > xlog("The call will be redirect to calling card<br>
> > 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<br>
> 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<br>
> 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">talk2ram@gmail.com</a><br>
</div></div>> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a>> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a><br>
<div class="im">> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a>>>>:<br>
> > > 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<br>
> > <<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a><br>
</div>> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a><br>
<div class="im">> <mailto:<a href="mailto:premalatha@ngintech.com">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<br>
> > <<a href="mailto:doug@wd.co.za">doug@wd.co.za</a> <mailto:<a href="mailto:doug@wd.co.za">doug@wd.co.za</a>><br>
</div><div><div></div><div class="h5">> <mailto:<a href="mailto:doug@wd.co.za">doug@wd.co.za</a> <mailto:<a href="mailto:doug@wd.co.za">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<br>
> > opensips.cfg file to<br>
> > >>> route call to Asterisk.<br>
> > >>><br>
> > >>> I doubt/not clear that after IVR (meaning when the<br>
> > user is authenticated<br>
> > >>> through IVR) who will handle all the<br>
> transactions and<br>
> > 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">Sebastian.Schumann@t-com.sk</a><br>
> <mailto:<a href="mailto:Sebastian.Schumann@t-com.sk">Sebastian.Schumann@t-com.sk</a>><br>
> > <mailto:<a href="mailto:Sebastian.Schumann@t-com.sk">Sebastian.Schumann@t-com.sk</a><br>
> <mailto:<a href="mailto:Sebastian.Schumann@t-com.sk">Sebastian.Schumann@t-com.sk</a>>>> wrote:<br>
> > >>>><br>
> > >>>> Hi Prem<br>
> > >>>><br>
> > >>>> There is a good tutorial at<br>
> > >>>><br>
> <a href="http://www.opensips.org/Resources/DocsTutAsterisk" target="_blank">http://www.opensips.org/Resources/DocsTutAsterisk</a> It<br>
> > does exactly what you<br>
> > >>>> need I assume.<br>
> > >>>><br>
> > >>>> For details in writing and extending basic<br>
> > 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">users-bounces@lists.opensips.org</a><br>
> <mailto:<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>><br>
</div></div><div><div></div><div class="h5">> > <mailto:<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a><br>
> <mailto:<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>>> [mailto:<a href="mailto:users-">users-</a><br>
> <mailto:<a href="mailto:users-">users-</a>><br>
> > <mailto:<a href="mailto:users-">users-</a> <mailto:<a href="mailto:users-">users-</a>>><br>
> > >>>> > <a href="mailto:bounces@lists.opensips.org">bounces@lists.opensips.org</a><br>
> <mailto:<a href="mailto:bounces@lists.opensips.org">bounces@lists.opensips.org</a>><br>
> > <mailto:<a href="mailto:bounces@lists.opensips.org">bounces@lists.opensips.org</a><br>
> <mailto:<a href="mailto:bounces@lists.opensips.org">bounces@lists.opensips.org</a>>>] On Behalf Of<br>
> > Premalatha Kuppan<br>
> > >>>> > Sent: Monday, 07. June 2010 11:35<br>
> > >>>> > To: OpenSIPS users mailling list<br>
> > >>>> > Subject: [OpenSIPS-Users] OPENSIPS+ASTERISK<br>
> Integration<br>
> > >>>> ><br>
> > >>>> > Hi,<br>
> > >>>> ><br>
> > >>>> > Can anyone guide me in building the Opensips and<br>
> > Asterisk Integration.<br>
> > >>>> ><br>
> > >>>> > I want to Use OpenSIPS as SIP PROXY (i.e all<br>
> > transactions and dialogs<br>
> > >>>> > should be<br>
> > >>>> > handled by Opensips) and Asterisk to do only IVR<br>
> > functionality.<br>
> > >>>> ><br>
> > >>>> > I appreciate if anyone can guide me in writing a<br>
> > routing logic from<br>
> > >>>> > Opensips to<br>
> > >>>> > Asterisk for IVR and futher call flow OPENSIPS to<br>
> > handle.<br>
> > >>>> ><br>
> > >>>> > Thanks,<br>
> > >>>> > Prem<br>
> > >>>> ><br>
> > >>>><br>
> > >>>><br>
> > >>>> _______________________________________________<br>
><br>
<br>
</div></div>--<br>
<div><div></div><div class="h5">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">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>