[Serdev] RPID and MySQL

Martin Koenig martin.koenig at toplink-plannet.de
Tue Jul 6 08:29:49 UTC 2004


Hallo,

tried today to make use of the rpid-field in the subscriber database.

append_rpid_hf() is called after authorizing clients invite msg.

Nothing happens. No header field is appended at all. Dumps below.

Is it true that append_rpid_hf() always returns true in ser.cfg, even if nothing happens? If so, is this by design?

-- snip ser.cfg
if (!www_authorize("serafima.int.toplink-plannet.de", "subscriber")) {
     log(1, "Auth: NO - requesting authentification\n");
     www_challenge("serafima.int.toplink-plannet.de", "0");
     break;
} else {
     log(1, "Auth: YES\n");
     consume_credentials();
};

if (append_rpid_hf("", ";party=calling;id-type=subscriber;screen=yes")) {
     log(1, "RPID found - appended\n");
} else {
     log(1, "RPID not found\n");
}
-- 

Also I set

modparam("auth_db", "rpid_column", "rpid")

to make sure it is querying the right db column.

Tried to search the archives for relevant information but didn't find anything that helped me.

Greetings,
Martin

PS: SIP network dump .168 = client1, .20 = SER, .221 = client2

SIP:
U 192.168.42.168:5060 -> 192.168.42.20:5060
   INVITE sip:410 at serafima.int.toplink-plannet.de SIP/2.0..Via: SIP/2.0/UDP 19
   2.168.42.168:5060;branch=z9hG4bKnp1593051031-435a75f9192.168.42.168;rport..
   From: "MK" <sip:mk at serafima.int.toplink-plannet.de>;tag=5ef40b8a..To: <sip:
   410 at serafima.int.toplink-plannet.de>..Call-ID: 1593053000-433bf198 at 192.168.
   42.168..CSeq: 1 INVITE..User-Agent: Ahead SIPPS IP Phone Version 2.0.46.23.
   .Expires: 180..Accept: application/sdp..Content-Type: application/sdp..Cont
   ent-Length: 249..Route: <sip:serafima.int.toplink-plannet.de;lr>..Contact:
   <sip:mk at 192.168.42.168>..Max-Forwards: 70....v=0..o=SIPPS 1593051003 159305
   1000 IN IP4 192.168.42.168..s=SIP call..c=IN IP4 192.168.42.168..t=0 0..m=a
   udio 30000 RTP/AVP 0 8 97 2 3..a=rtpmap:0 pcmu/8000..a=rtpmap:8 pcma/8000..
   a=rtpmap:97 ilbc/8000..a=rtpmap:2 g726-32/8000..a=rtpmap:3 gsm/8000..
#
U 192.168.42.20:5060 -> 192.168.42.168:5060
   SIP/2.0 401 Unauthorized..Via: SIP/2.0/UDP 192.168.42.168:5060;branch=z9hG4
   bKnp1593051031-435a75f9192.168.42.168;rport=5060..From: "MK" <sip:mk at serafi
   ma.int.toplink-plannet.de>;tag=5ef40b8a..To: <sip:410 at serafima.int.toplink-
   plannet.de>;tag=9c965d368830255bfa063e70dbfdb3fb.5017..Call-ID: 1593053000-
   433bf198 at 192.168.42.168..CSeq: 1 INVITE..WWW-Authenticate: Digest realm="se
   rafima.int.toplink-plannet.de", nonce="40ea616095efe4dcc3dadbf804a5806da88d
   d904"..Server: Sip EXpress router (0.8.13-dev-31-usrloc (i386/linux))..Cont
   ent-Length: 0..Warning: 392 192.168.42.20:5060 "Noisy feedback tells:  pid=
   11300 req_src_ip=192.168.42.168 req_src_port=5060 in_uri=sip:410 at serafima.i
   nt.toplink-plannet.de out_uri=sip:410 at serafima.int.toplink-plannet.de via_c
   nt==1"....
#
U 192.168.42.168:5060 -> 192.168.42.20:5060
   ACK sip:410 at serafima.int.toplink-plannet.de SIP/2.0..From: "MK" <sip:mk at ser
   afima.int.toplink-plannet.de>;tag=5ef40b8a..Call-ID: 1593053000-433bf198 at 19
   2.168.42.168..Via: SIP/2.0/UDP 192.168.42.168:5060;branch=z9hG4bKnp15930510
   31-435a75f9192.168.42.168;rport..To: <sip:410 at serafima.int.toplink-plannet.
   de>;tag=9c965d368830255bfa063e70dbfdb3fb.5017..Route: <sip:serafima.int.top
   link-plannet.de;lr>..CSeq: 1 ACK....
#
U 192.168.42.168:5060 -> 192.168.42.20:5060
   INVITE sip:410 at serafima.int.toplink-plannet.de SIP/2.0..Route: <sip:serafim
   a.int.toplink-plannet.de;lr>..Via: SIP/2.0/UDP 192.168.42.168;branch=z9hG4b
   Knp1593023013-4505b50b192.168.42.168;rport..From: "MK" <sip:mk at serafima.int
   .toplink-plannet.de>;tag=5ef40b8a..To: <sip:410 at serafima.int.toplink-planne
   t.de>..Call-ID: 1593053000-433bf198 at 192.168.42.168..CSeq: 2 INVITE..Authori
   zation: Digest  username="mk",realm="serafima.int.toplink-plannet.de",uri="
   sip:192.168.42.168",nonce="40ea616095efe4dcc3dadbf804a5806da88dd904",nc="00
   000001",response="94ed47a813b822b7661c3577f95cef1c"..Content-Type: applicat
   ion/sdp..Content-Length: 249..Date: Tue, 06 Jul 2004 08:17:56 GMT..Contact:
    <sip:mk at 192.168.42.168>..Expires: 180..Accept: application/sdp..Max-Forwar
   ds: 70..User-Agent: Ahead SIPPS IP Phone Version 2.0.46.23....v=0..o=SIPPS
   1593051003 1593051000 IN IP4 192.168.42.168..s=SIP call..c=IN IP4 192.168.4
   2.168..t=0 0..m=audio 30000 RTP/AVP 0 8 97 2 3..a=rtpmap:0 pcmu/8000..a=rtp
   map:8 pcma/8000..a=rtpmap:97 ilbc/8000..a=rtpmap:2 g726-32/8000..a=rtpmap:3
    gsm/8000..
#
U 192.168.42.20:5060 -> 192.168.42.168:5060
   SIP/2.0 100 trying -- your call is important to us..Via: SIP/2.0/UDP 192.16
   8.42.168;branch=z9hG4bKnp1593023013-4505b50b192.168.42.168;rport=5060..From
   : "MK" <sip:mk at serafima.int.toplink-plannet.de>;tag=5ef40b8a..To: <sip:410@
   serafima.int.toplink-plannet.de>..Call-ID: 1593053000-433bf198 at 192.168.42.1
   68..CSeq: 2 INVITE..Server: Sip EXpress router (0.8.13-dev-31-usrloc (i386/
   linux))..Content-Length: 0..Warning: 392 192.168.42.20:5060 "Noisy feedback
    tells:  pid=11300 req_src_ip=192.168.42.168 req_src_port=5060 in_uri=sip:4
   10 at serafima.int.toplink-plannet.de out_uri=sip:410 at 192.168.42.211:5060 via_
   cnt==1"....
#
U 192.168.42.20:5060 -> 192.168.42.211:5060
   INVITE sip:410 at 192.168.42.211:5060 SIP/2.0..Record-Route: <sip:192.168.42.2
   0;ftag=5ef40b8a;lr=on>..Via: SIP/2.0/UDP 192.168.42.20;branch=z9hG4bK8bcd.c
   4cbe8b5.0..Via: SIP/2.0/UDP 192.168.42.168;branch=z9hG4bKnp1593023013-4505b
   50b192.168.42.168;rport=5060..From: "MK" <sip:mk at serafima.int.toplink-plann
   et.de>;tag=5ef40b8a..To: <sip:410 at serafima.int.toplink-plannet.de>..Call-ID
   : 1593053000-433bf198 at 192.168.42.168..CSeq: 2 INVITE..Content-Type: applica
   tion/sdp..Content-Length: 249..Date: Tue, 06 Jul 2004 08:17:56 GMT..Contact
   : <sip:mk at 192.168.42.168>..Expires: 180..Accept: application/sdp..Max-Forwa
   rds: 69..User-Agent: Ahead SIPPS IP Phone Version 2.0.46.23....v=0..o=SIPPS
    1593051003 1593051000 IN IP4 192.168.42.168..s=SIP call..c=IN IP4 192.168.
   42.168..t=0 0..m=audio 30000 RTP/AVP 0 8 97 2 3..a=rtpmap:0 pcmu/8000..a=rt
   pmap:8 pcma/8000..a=rtpmap:97 ilbc/8000..a=rtpmap:2 g726-32/8000..a=rtpmap:
   3 gsm/8000..

etc...






More information about the Serdev mailing list