[OpenSIPS-Users] exec_dset / mySQL / SER

[Brett Nemeroff]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100224/04543ad6/attachment-0001.htm