On Wednesday 14 January 2004 18:38, Jiri Kuthan wrote:
At 12:01 AM 1/15/2004, Andres wrote:
On Wednesday 14 January 2004 17:02, Jiri Kuthan wrote:
see http://www.iptel.org/ser/doc/seruser/seruser.html#USINGEXEC
SIP_HF_FROM="alice" sip:alice@iptel.org;tag=76ff7a07-c091-4192-84a0-d56e91fe104f
I don't see how I can use this variable for an SQL query.
use text processing utils such as awk, sed, whatever you like better. That's not so difficult, is it?
No problem. I was just trying to avoid yet another external command in the ser.cfg file.
Thanks, Andres.
On the other hand the SIP_OUSER variable can be used like this:
QUERY="select email_address from subscriber where user=\"$SIP_OUSER\""; EMAIL=`mysql -Bsuser -pheslo -e "$QUERY" ser`;I want the same type of query but for the originating user. Is there any way to take apart the SIP_HF_FROM and extract just the username?
you need to do it yourself. There is infitnitely many interesting elemenents in a sip message and it makes little sense to break all of them in separate variables.
-jiri