AsteriskGuide & Brett - thanks for help - I now have a working system :)
John! How are you? Yes - your code barley ran 3 years with zero problems before I had to jump in and fix it! Seriously - new datacenter so thought time to swap out SER. I will ping you offline for an update. Thanks again guys. On Wed, Feb 24, 2010 at 4:18 PM, AsteriskGuide <[email protected]>wrote: > As simple as possible is usually the best way. > > > > $ru=avp(i:1); > > > > Is ok. > > > > Flavio E. Goncalves > > > > *De:* [email protected] [mailto: > [email protected]] *Em nome de *Phillip Jones > *Enviada em:* Wednesday, February 24, 2010 5:49 PM > *Para:* OpenSIPS users mailling list > *Assunto:* Re: [OpenSIPS-Users] exec_dset / mySQL / SER > > > > Thank you both for that help. > > I have gone ahead and successfully implemented the avp_db_query version and > I now have a variable $avp(i:1) that contains the correct forwarding uri. > > Now this is really where I show my ignorance. > > How go I use $avp(i:1) correctly, considering that I am going to call > t_relay() > > if (!t_relay()) > { > sl_reply_error(); > }; > > Is it simply a case of $ru = $avp(i:1); > > That appears to work but I just want to make sure it is the correct > approach. > > Thanks again > > pj > > > On Wed, Feb 24, 2010 at 2:25 PM, Brett Nemeroff <[email protected]> > wrote: > > Something else I wanted to mention regarding your code here.. There is an > obvious race condition if two calls come in at once.. your script writes the > query results to a tmp file which could already be written by another call. > > > > Overall, exec_dset should be avoided IMO. avp_db_query is fast, and easy to > implement. I think you'll be happy with the results. The conversion should > be simple enough, especially if your shell script really is that simple.. > > > > -Brett > > > > > > > > On Wed, Feb 24, 2010 at 12:44 PM, Phillip Jones <[email protected]> > wrote: > > Hi there, > > I am new to opensips - and I am trying to convert a script currently > working in SER. I am almost done - but have one last issue that is getting > the better of me. This is the script part: > > exec_dset(' > > AQUERY="CALL Routing(\"$$SIP_USER\", \"$$SIP_SRCIP\", > \"$$SIP_RURI\", \"$$SIP_ORURI\", False);"; > AURI=`mysql -Broot -pxxxxxxx -e "$$AQUERY" opensips`; > > echo $$AQUERY > /tmp/AQUERY.txt > echo $$AURI> /tmp/AURI.txt > > if [ ! -z "$$AURI" ] ; then > > printf ("$$AURI"); > fi; > > exit; > > echo > dev/null > > '); > > AURI contains "+-----------------------------------+ | DestinationURI | > +-----------------------------------+ | sip:[email protected]:5060 > | +-----------------------------------+" which kind of makes sense. > > Opensips falls over with error: ERROR:core:parse_uri: bad uri - which also > makes sense. > > If I use printf ("sip:[email protected]:5060"); then every thing > works nicely. > > What I am missing here? If this worked in SER - what has changed - a config > in MySQL?? > > Any help would be much appreciated. I think I could use REGEX here to > extract the uri, but I not familiar with the syntax in opensips. > > > > Thanks > > > pj > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
