<div>Yes, i have checked all these options. Everything is in correct status.</div>
<div> </div>
<div>I doubt, connecting between vmware and with 64 bit RHEL. My set is running on vmware image. When i ping on from vmware where opensips+asterisk is running to the MySQL server vmware image, i see this problem. But when i set MySQL server on non-vmware, it works perferctly fine.</div>
<div> </div>
<div>i 'll update once i figure out the reason.</div>
<div> </div>
<div>Between, to route a call from OPENSIP to the destination. I need to fetch the destination details IP from MySQL DB. </div>
<div>Meaning,</div>
<div> </div>
<div>User --------> OPENSIPS(1)--------->ASTERISK(IVR)-------------->OPENSIPS(1)----------------->Destination</div>
<div> </div>
<div>Here, for authentication user enters the PIn and extension to access, if the extension is present in the DB, Asterisk(IVR) will allow the user to access it. From this from asterisk, i can make query to DB and fetch the neccessary details. Likewise is it possible to fetch the details(IP where the extension is connected and to be routed) from DB from opensips.cfg to route the call to requested destination.</div>
<div> </div>
<div>Thanks,</div>
<div>Prem<br><br></div>
<div class="gmail_quote">On Thu, Jun 10, 2010 at 3:01 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="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Are you sure the DB conn params are correct (like address of myql server) ?<br><br>Also are you sure the mysql server is remotely reachable (it 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 client -<br>just to see if it works?<br><br>Regards,<br>Bogdan<br>
<div>
<div></div>
<div class="h5"><br>Premalatha Kuppan wrote:<br>> Iam facing one more problem.<br>><br>> Iam running my set up on 64bit processor. Opensips and asterisk 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 registered. of<br>> 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<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 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 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 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, 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>
</div></div>
<div class="im">> <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></div>
<div class="im">> <<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a> <mailto:<a href="mailto:premalatha@ngintech.com">premalatha@ngintech.com</a>>> wrote:<br>><br>> Thanks a lot.<br>
><br>> I have one question. If i route the call to asterisk for IVR (<br>> in my case ivr is to authenticate the user to access the<br>> system), who will have the control, meaning who will 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></div>
<div>
<div></div>
<div class="h5">> <<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 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></div></div>> 2010/6/8 ram <<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 Kuppan<br></div>> <<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>> >> Can you pleae guide me how to do this ?<br>> >><br>> >> On Mon, Jun 7, 2010 at 4:04 PM, Douglas Lane<br>
</div>
<div class="im">> <<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 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>
</div>
<div class="im">> <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>> >>>> <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></div>
<div class="im">> <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>
> >>>> > <a href="mailto:bounces@lists.opensips.org">bounces@lists.opensips.org</a><br></div>
<div>
<div></div>
<div class="h5">> <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 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>> >>>> Users mailing list<br>
> >>>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br></div></div>> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
<div class="im">> >>>> <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></div>> >>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
<div class="im">> >>> <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></div>> >>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
<div class="im">> >>> <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></div>> >> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
<div class="im">> >> <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></div>> > <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
<div class="im">> > <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></div>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
<div class="im">> <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></div>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
<div class="im">> <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></div>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
<div class="im">> <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">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><font color="#888888">--<br>Bogdan-Andrei Iancu<br><a href="http://www.voice-system.ro/" target="_blank">www.voice-system.ro</a><br></font>
<div>
<div></div>
<div class="h5"><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>