[OpenSIPS-Users] RES: exec_dset / mySQL / SER

[Phillip Jones]

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 <flavio at asteriskguide.com>wrote:

>  As simple as possible is usually the best way.
>
>
>
> $ru=avp(i:1);
>
>
>
> Is ok.
>
>
>
> Flavio E. Goncalves
>
>
>
> *De:* users-bounces at lists.opensips.org [mailto:
> users-bounces at lists.opensips.org] *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 <brett at nemeroff.com>
> 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 <pjintheusa at gmail.com>
> 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:121255555666 at 64.55.55.555: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:121255555666 at 64.55.55.555: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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100224/5eaa1de8/attachment-0001.htm