Re: [Serusers] Database queries?

sip wrote: I didn't see any mention of ngrep (or other packet sniffer) in this discussion. Have you used ngrep to see exactly what is arriving/departing from you proxy? It may be as simple as a port number is appended or perhaps the protocol tag (sip:) is not included. These are just suggestions but I think a packet sniffer will tell you exactly what is in the SIP message. >does match. Seems to be picking up the DB entry and will match it if I >statically enter what it's supposed to match, but not against a $from >variable. I was trying to figure out how to get debug messages to print so I >could see what was going on, but I have as yet been unsuccessful. > > >N. > >On Tue, 27 Sep 2005 13:50:56 +0300, Daniel-Constantin Mierla wrote > > >>Hello, >> >>the content of $from is sip:motherinlaw@another.domain.com >> >>$from is a sip uri, that's why does not match when do the check. >> >>Daniel >> >>On 09/26/05 22:09, sip wrote: >> >> >> >>>I'm attempting to figure out how to use AVPops to grab data from the >>>calls_forwarding database table so I can avoid having to write my own module >>>to handle that sort of thing, and I can avoid doing what I'm CURRENTLY doing >>>which is using a pretty hideous exec_msg SQL query hack. >>> >>>I've run into a snag that I can't figure a way around.... >>> >>>In the calls_forwarding table, I have these fields used in this fashion: >>>username == username >>>domain == domain >>>uri_re == username@domain information (for use in a couple of ways) >>>purpose == purpose for this entry (callblock, callfwd, screening, etc) >>>action == action to take (for callblock, could be reply or relay, etc) >>>param1 == option for the action above >>>param2 == additional option >>> >>>So... if I have a call block entry, it would be like this: >>> >>>username = bob >>>domain = mydomain.com >>>uri_re = motherinlaw(a)another.domain.com >>>purpose = callblock >>>action = reply >>>param1 = 486 >>>param2 = "Busy" >>> >>>The logic would be along the lines of, when a call comes in for >>>bob(a)mydomain.comomain.com, I check to see if he has any callblock entries. If so, I >>>check those to see if any match the From user. If there's a match, take the >>>action in action (in this case reply with 486 - Busy... could be relay to >>>voicemail, etc). >>> >>>The problem I'm having is in the grabbing of all the data from the DB and >>>comparing it to the right values. For instance, with this avpops query >>> >>> >>>avp_db_load("$ruri/username", "$urire/$urire_scheme"); >>># Load the urire column for this and check to see if >>># it matches the $from address >>>if(avp_check("$urire", "eq/$from/I")) >>>{ >>> send reply... take action... etc. >>>} >>> >>>I'm calling from the number motherinlaw(a)another.domain.com. If I use the >>>above, the avp_check test fails. If I put >>> >>>if(avp_check("$urire", "eq/motherinlaw(a)another.domain.com/I")) >>>{ >>> send reply... take action... etc. >>>} >>> >>> >>>Then the test succeeds and the appropriate action is taken. >>> >>>Any guesses as to what I'm missing here... why the test is failing when I use >>>the $from variable for AVPops, but not when I hard-code the $from address

-- ISC Network Engineering The University of Pennsylvania 3401 Walnut Street, Suite 221A Philadelphia, PA 19104 voice: 215-573-8396 215-746-8001 fax: 215-898-9348 sip:blairs@upenn.edu