Thanks Bogdan.<br><br>
<div class="gmail_quote">On Fri, Jun 11, 2010 at 9:41 AM, 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="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi Prem,<br>
<div class="im"><br>Premalatha Kuppan wrote:<br>> Hi Bogdan,<br>><br>> Thanks for yor reply.<br>><br>> Can you brief me about the "lookup(location) to send the call to the<br>> callee device."<br>
</div>Please check the default opensips cfg that comes with the sources/packages.<br><br>Also listen the tutorial on the CFG -<br><a href="http://www.opensips.org/Resources/Webinars#toc8" target="_blank">http://www.opensips.org/Resources/Webinars#toc8</a><br>
<br>Even more, read the docs related to user location (see module "registrar").<br>
<div class="im">><br>> Here, during the IVR the user will sent the callee #, i have to fetch<br>> the corresponding IP addr of that callee from the database to route<br>> the call. From asterisk, i can do that by connecting to mysql and<br>
> fetch the IP of that callee from the DB. I wonder how it can be done<br>> at opensips.<br></div>You put the same question like last time - the answer is the same - if a<br>device registered with OpenSIPS, OpenSIPS is the best place to send back<br>
calls to that device - querying from Asterisk the opensips DB is a dirty<br>hack with a lot of potential problems.<br><br>Regards,<br>Bogdan<br>
<div class="im"><br>><br>> If you could help me in briefing more on "lookup(location) to send the<br>> call to the callee device" from opensips. I appreciate.<br>><br>> Thanks,<br>> Prem<br>><br>
><br>> On Fri, Jun 11, 2010 at 2:26 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>> 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 -<br>> if call<br>> comes from Asterisk -> outbound routing ; if not from asterisk -><br>> inbound logic.<br>><br>
> Regards,<br>> Bogdan<br>><br>> Premalatha Kuppan wrote:<br>> > Yes, i have checked all these options. Everything is in correct<br>> 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>> ><br>> OPENSIPS(1)--------->ASTERISK(IVR)-------------->OPENSIPS(1)----------------->Destination<br>> ><br>
> > Here, for authentication user enters the PIn and extension to<br>> 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<br>
> 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)<br>> 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>> > <<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>><br>
</div></div>> <mailto:<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>>>><br>
<div>
<div></div>
<div class="h5">> wrote:<br>> ><br>> > Are you sure the DB conn params are correct (like address of<br>> 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<br>> 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<br>> 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.<br>
> 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,<br>> 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,<br>
> 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<br>
> database<br>> > > Jun 9 03:39:12 204548-4 /usr/local/sbin/opensips[7341]:<br>> > > ERROR:core:init_mod_child: failed to initializing module<br>> 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>
> > <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a>>><br>> > > <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a>><br>
> <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><br>> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a><br>
> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>>><br>> > <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a><br>> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a><br>
> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>>>>><br>> > wrote:<br>> > ><br>> > > Thanks a lot.<br>> > ><br>
> > > I have one question. If i route the call to<br>> asterisk for<br>> > IVR (<br>> > > in my case ivr is to authenticate the user to<br>> access the<br>
> > > system), who will have the control, meaning who will<br>> > maintian<br>> > > all the transactions and dailog. Is it<br>> 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>
> <mailto:<a href="mailto:elgabo81@gmail.com">elgabo81@gmail.com</a> <mailto:<a href="mailto:elgabo81@gmail.com">elgabo81@gmail.com</a>>><br>> > <mailto:<a href="mailto:elgabo81@gmail.com">elgabo81@gmail.com</a> <mailto:<a href="mailto:elgabo81@gmail.com">elgabo81@gmail.com</a>><br>
> <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<br>> 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<br>> 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>> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a>><br>
> > <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a>>><br>> <mailto:<a href="mailto:talk2ram@gmail.com">talk2ram@gmail.com</a> <mailto:<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">> > > > 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<br>> Kuppan<br>> > > <<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a><br>
> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>><br>> > <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">> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>><br>> > <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a><br></div>
<div>
<div></div>
<div class="h5">> <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>> <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>>><br>
> > <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>><br>> <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<br>> wrote:<br>> > > >>><br>> > > >>> Thanks Sebastian.<br>
> > > >>><br>> > > >>> I have followed up this link and tried<br>> extending the<br>> > > opensips.cfg file to<br>
> > > >>> route call to Asterisk.<br>> > > >>><br>> > > >>> I doubt/not clear that after IVR (meaning<br>> 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<br>> transactions.<br>
> > > >>><br>> > > >>> Any insight on this ?<br>> > > >>><br>> > > >>> Thanks,<br>
> > > >>> Prem<br>> > > >>><br>> > > >>> On Mon, Jun 7, 2010 at 3:15 PM, Schumann<br>> 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>>><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><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>> > <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>>><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>><br>
> > <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>> > > <mailto:<a href="mailto:users-">users-</a> <mailto:<a href="mailto:users-">users-</a>> <mailto:<a href="mailto:users-">users-</a><br>
> <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>>><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><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<br>> Opensips and<br>> > > Asterisk Integration.<br>
> > > >>>> ><br>> > > >>>> > I want to Use OpenSIPS as SIP PROXY<br>> (i.e all<br>> > > transactions and dialogs<br>
> > > >>>> > should be<br>> > > >>>> > handled by Opensips) and Asterisk to do<br>> only IVR<br>> > > functionality.<br>
> > > >>>> ><br>> > > >>>> > I appreciate if anyone can guide me in<br>> writing a<br>> > > routing logic from<br>
> > > >>>> > Opensips to<br>> > > >>>> > Asterisk for IVR and futher call flow<br>> OPENSIPS to<br>> > > handle.<br>
> > > >>>> ><br>> > > >>>> > Thanks,<br>> > > >>>> > Prem<br>> > > >>>> ><br>
> > > >>>><br>> > > >>>><br>> > > >>>><br>> _______________________________________________<br>
> ><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">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>