Thank you Ali, for your prompt response. I will read about it to implement it.
Still i am a bit puzzled as why this is not working in such a simple scenario.
It worked in the old SER box.
Regards,
Xavier
________________________________
De: Ali Pey <[email protected]>
Para: Xavier Herlindo <[email protected]>; OpenSIPS users mailling list
<[email protected]>
Enviado: Sábado, 6 de octubre, 2012 19:09:40
Asunto: Re: [OpenSIPS-Users] bash shell variable not kept when run in
opensips.cfg
Hello Xavier,
Try the avops module. This is your best option in this scenario:
http://www.opensips.org/html/docs/modules/1.8.x/avpops.html#id292750
Regards,
Ali Pey
On Sat, Oct 6, 2012 at 7:38 PM, Xavier Herlindo <[email protected]> wrote:
Hello all,
>
>
>this is my first post, so please bare with me if i commit any protocol error.
>All comments are welcome. Thanks all in advance for any help i can get.
>
>
>I am running Opensips 8.1 with a Centos 5.8 install. I am setting up a
>redirect server. Only using the slo.so, mi_fifo.so, rr.so (not sure if i
>really need this one) and exec.so modules.
>
>
>I am trying to run a simple bash script that checks if the number in the URI
>exists in a mysq table and if so, the script rewrites the prefix and ip
>address to redirect. If not, there is a default address to redirect to.
>
>
>The sh script works fine as i have tested it directly from the shell, running
>without issues. If i input an URI with an existing number in my mysql table,
>the script connects to the db, validates it, an the output is the modified URI
>as expected. Now if the script is called from within opensips.cfg file, the
>script is not validating in mysql. The opensips log file show no errors when
>running the sh file. If i try to set an incorrect connection param string
>there is no change either, as if the line is ignored.
>
>
>This is my unrecognized variable:
>
>
>exec_query=`mysql -u USER --password=TEST -s -D MY_DB -e "SELECT numB FROM
>valid_numb WHERE numB = '123';"`
>
>
>
> If i echo the value for exec_query it is empty when running within
>opensips.cfg
>Running in the bash prompt the value of exec_query is set correctly.
>
>
>
>This same shell script was tested in an old SER box without not issues, so i
>think it is something out of the script directly related to opensips
>configuration.
>
>
>Do you know what may be the problem?
>
>
>Regards,
>
>
>
>Xavier
>_______________________________________________
>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
