10 Nov
2004
10 Nov
'04
12:47 p.m.
Jan Janak wrote:
The configuration file seems to be OK, you have just
one is_user_in
function call in the file and the SIP message dumps show only one INVITE
message coming to SER -- that means SER will query the database for the
group membership only once.
Is there possibly any other traffic (INVITE messages) than can trigger
the query at the same time ?
In the network capture, I see a filter(1919) was used. I could hide
other messages. Also can be some traffic on loopback interface.
bogdan
Jan.
On 09-11 15:03, Rodrigo P. Telles wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Jan,
Thanks for your answer!
See the attached files (ser.cfg and ngrep dump).
PS: Of corse I did some modifications in that files just to protect our
Network.
If you want the original files I can send to your personal e-mail.
Thanks again.
Jan Janak wrote:
| Could you send the whole config file and also SIP message dumps ?
|
| Jan.
|
| On 08-11 18:18, Rodrigo P. Telles wrote:
|
|>Hi folks,
|>
|>I've been having litle troubles with SER.
|>When I offhook my BT100 and called another phone, I saw in
|>my log file that SER query the MySQL 3 or more times for the same
|>thing (in this case, about group membership) and the same for log
messages.
|>I tried to flag the action but it doens't work.
|>
|>I think that the real problem is that I'm missing some thing
|>in my configuration or I just didn't understand the call flow in SER.
|>any ideas?
|>
|>I'm sending part of my ser.cfg, I hope it helps.
|>===================================
|>record_route();
|>
|>if (method=="INVITE" && !isflagset(11)) {
|>~ log(1, "Voicemail is enable? ");
|>~ if (is_user_in("To", "voicemail")) {
|>~ log(1, "Yes\n");
|>~ setflag(8);
|>~ t_on_failure("1");
|>~ } else {
|>~ log(1, "No\n");
|>~ }
|>
|>~ # native SIP destinations are handled using our
USRLOC DB
|>~ if (!lookup("location")) {
|>~ #sl_send_reply("404", "Not
Found");
|>~ if (uri=~"sip:[0-9]{4,6}@") {
|>~ if (!radius_proxy_authorize(""))
{
|>~ proxy_challenge("",
"0");
|>~ sl_send_reply("403",
"That's not
|>your home");
|>~ break;
|>~ };
|>~ rewriteuser("901");
|>~ rewritehostport("x.y.z.w:5060");
|>~ log(1, "Not found\n");
|>~ t_relay();
|>~ break;
|>~ } else {
|>~ route(1);
|>~ break;
|>~ };
|>~ };
|>~ setflag(11);
|>};
|>=========================================
|>Thanks in advance.
|>
|>--
|>============================================
|>Rodrigo P. Telles <telles(a)devel-it.com.br>
|>Project Manager
|>Devel-IT - http://www.devel-it.com.br
|>TDKOM Group
|>============================================
|>
|>_______________________________________________
|>Serusers mailing list
|>serusers(a)lists.iptel.org
|>http://lists.iptel.org/mailman/listinfo/serusers
|>
|
|
|
- --
============================================
Rodrigo P. Telles <telles(a)devel-it.com.br>
Gerente de Projetos
Devel-IT - http://www.devel-it.com.br
Grupo TDKOM
============================================
>interface: eth0 (200.xxx.yyy.www/255.255.255.x)
>filter: ip and ( port 5060 )
>match: 1919
>#####
>U 192.168.0.91:44863 -> 192.168.0.65:5060
> INVITE sip:2020@ser.server.net SIP/2.0..Via: SIP/2.0/UDP
10.0.0.2:44863;branch=z9hG4bKc2c125fc7680ccf0..Fr
> om: "Telles 2" <sip:1919@ser.server.net>;tag=ef9d331f5bca723c..To:
<sip:2020@ser.server.net>..Contact: <sip:19
> 19@10.0.0.2:44863>..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33385
INVITE..User-Agent: Grandstream BT
> 100 1.0.5.11..Max-Forwards: 70..Allow:
INVITE,ACK,CANCEL,BYE,NOTIFY,REFER,OPTIONS,INFO,SUBSCRIBE..Content-Ty
> pe: application/sdp..Content-Length: 394....v=0..o=1919@ 8000 8000 IN IP4
10.0.0.2..s=SIP Call..c=IN IP4 1
> 72.16.22.2..t=0 0..m=audio 20390 RTP/AVP 99 18 4 0 8 9 2 15 101..a=rtpmap:99
iLBC/8000..a=fmtp:99 mode=20..a
> =rtpmap:18 G729/8000..a=rtpmap:4 G723/8000..a=rtpmap:0 PCMU/8000..a=rtpmap:8
PCMA/8000..a=rtpmap:9 G722/8000
> ..a=rtpmap:2 G726-32/8000..a=rtpmap:15 G728/8000..a=ptime:20..a=rtpmap:101
telephone-event/8000..a=fmtp:101
> 0-11..
>#
>U 192.168.0.65:5060 -> 192.168.0.91:44863
> SIP/2.0 100 trying -- your call is important to us..Via: SIP/2.0/UDP
10.0.0.2:44863;branch=z9hG4bKc2c125f
> c7680ccf0;rport=44863;received=192.168.0.91..From: "Telles 2"
<sip:1919@ser.server.net>;tag=ef9d331f5bca723
> c..To: <sip:2020@ser.server.net>..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq:
33385 INVITE..Server: Sip EXpr
> ess router (0.8.14 (i386/linux))..Content-Length: 0..Warning: 392 192.168.0.65:5060
"Noisy feedback tells:
> pid=20180 req_src_ip=192.168.0.91 req_src_port=44863
in_uri=sip:2020@ser.server.net out_uri=sip:2020@192.
> 168.0.87:5060 via_cnt==1"....
>#
>U 192.168.0.65:5060 -> 192.168.0.87:5060
> INVITE sip:2020@192.168.0.87:5060 SIP/2.0..Record-Route:
<sip:2020@192.168.0.65;ftag=ef9d331f5bca723c;lr
> =on>..Via: SIP/2.0/UDP 192.168.0.65;branch=z9hG4bK54.23f86f66.0..Via: SIP/2.0/UDP
10.0.0.2:44863;rport=
> 44863;received=192.168.0.91;branch=z9hG4bKc2c125fc7680ccf0..From: "Telles
2" <sip:1919@ser.server.net>;tag=
> ef9d331f5bca723c..To: <sip:2020@ser.server.net>..Contact:
<sip:1919@192.168.0.91:44863>..Call-ID: e0b16e3a3
> d427e23@10.0.0.2..CSeq: 33385 INVITE..User-Agent: Grandstream BT100
1.0.5.11..Max-Forwards: 69..Allow: IN
> VITE,ACK,CANCEL,BYE,NOTIFY,REFER,OPTIONS,INFO,SUBSCRIBE..Content-Type:
application/sdp..Content-Length: 397.
> .P-hint: fixed NAT contact for request..P-hint: request forced to
mediaproxy....v=0..o=1919@ 8000 8000 IN IP4
> 10.0.0.2..s=SIP Call..c=IN IP4 192.168.0.67..t=0 0..m=audio 35566 RTP/AVP 99 18 4 0
8 9 2 15 101..a=rt
> pmap:99 iLBC/8000..a=fmtp:99 mode=20..a=rtpmap:18 G729/8000..a=rtpmap:4
G723/8000..a=rtpmap:0 PCMU/8000..a=r
> tpmap:8 PCMA/8000..a=rtpmap:9 G722/8000..a=rtpmap:2 G726-32/8000..a=rtpmap:15
G728/8000..a=ptime:20..a=rtpma
> p:101 telephone-event/8000..a=fmtp:101 0-11..
>#
>U 192.168.0.87:5060 -> 192.168.0.65:5060
> SIP/2.0 100 Trying..To: <sip:2020@ser.server.net>..From: "Telles 2"
<sip:1919@ser.server.net>;tag=ef9d331f5bca
> 723c..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33385 INVITE..Via: SIP/2.0/UDP
192.168.0.65;branch=z9hG
> 4bK54.23f86f66.0..Via: SIP/2.0/UDP
10.0.0.2:44863;rport=44863;received=192.168.0.91;branch=z9hG4bKc2c12
> 5fc7680ccf0..Record-Route:
<sip:2020@192.168.0.65;ftag=ef9d331f5bca723c;lr=on>..Server: Sipura/SPA2000-2.0
> .10(e)..Content-Length: 0....
>#
>U 192.168.0.87:5060 -> 192.168.0.65:5060
> SIP/2.0 180 Ringing..To:
<sip:2020@ser.server.net>;tag=3033786eec83f67bi0..From: "Telles 2"
<sip:1919@ser.serv
> er.net>;tag=ef9d331f5bca723c..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33385
INVITE..Via: SIP/2.0/UDP 19
> 2.168.65;branch=z9hG4bK54.23f86f66.0..Via: SIP/2.0/UDP
10.0.0.2:44863;rport=44863;received=192.168.
> 0.91;branch=z9hG4bKc2c125fc7680ccf0..Record-Route:
<sip:2020@192.168.0.65;ftag=ef9d331f5bca723c;lr=on>..Se
> rver: Sipura/SPA2000-2.0.10(e)..Content-Length: 0....
>#
>U 192.168.0.65:5060 -> 192.168.0.91:44863
> SIP/2.0 180 Ringing..To:
<sip:2020@ser.server.net>;tag=3033786eec83f67bi0..From: "Telles 2"
<sip:1919@ser.serv
> er.net>;tag=ef9d331f5bca723c..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33385
INVITE..Via: SIP/2.0/UDP 10
>
.0.0.2:44863;rport=44863;received=192.168.0.91;branch=z9hG4bKc2c125fc7680ccf0..Record-Route:
<sip:2020@
> 192.168.0.65;ftag=ef9d331f5bca723c;lr=on>..Server:
Sipura/SPA2000-2.0.10(e)..Content-Length: 0....
>##
>U 192.168.0.87:5060 -> 192.168.0.65:5060
> SIP/2.0 200 OK..To: <sip:2020@ser.server.net>;tag=3033786eec83f67bi0..From:
"Telles 2" <sip:1919@ser.server.ne
> t>;tag=ef9d331f5bca723c..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33385
INVITE..Via: SIP/2.0/UDP 192.168
> .0.65;branch=z9hG4bK54.23f86f66.0..Via: SIP/2.0/UDP
10.0.0.2:44863;rport=44863;received=192.168.0.91;
> branch=z9hG4bKc2c125fc7680ccf0..Record-Route:
<sip:2020@192.168.0.65;ftag=ef9d331f5bca723c;lr=on>..Contact
> : Someone NET <sip:2020@192.168.0.87:5060>..Server:
Sipura/SPA2000-2.0.10(e)..Content-Length: 244..Allo
> w: ACK, BYE, CANCEL, INFO, INVITE, NOTIFY, OPTIONS, REFER..Supported:
x-sipura..Content-Type: application/sd
> p....v=0..o=- 10523026 10523026 IN IP4 192.168.0.87..s=-..c=IN IP4 192.168.0.87..t=0
0..m=audio 16408 RT
> P/AVP 18 100 101..a=rtpmap:18 G729a/8000..a=rtpmap:100 NSE/8000..a=rtpmap:101
telephone-event/8000..a=fmtp:1
> 01 0-15..a=ptime:30..a=sendrecv..
>#
>U 192.168.0.65:5060 -> 192.168.0.91:44863
> SIP/2.0 200 OK..To: <sip:2020@ser.server.net>;tag=3033786eec83f67bi0..From:
"Telles 2" <sip:1919@ser.server.ne
> t>;tag=ef9d331f5bca723c..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33385
INVITE..Via: SIP/2.0/UDP 10.0.
>
0.2:44863;rport=44863;received=192.168.0.91;branch=z9hG4bKc2c125fc7680ccf0..Record-Route:
<sip:2020@192.1
> 68.0.65;ftag=ef9d331f5bca723c;lr=on>..Contact: Someone NET
<sip:2020@192.168.0.87:5060>..Server: Sipu
> ra/SPA2000-2.0.10(e)..Content-Length: 244..Allow: ACK, BYE, CANCEL, INFO, INVITE,
NOTIFY, OPTIONS, REFER..Su
> pported: x-sipura..Content-Type: application/sdp..P-hint: response forced to
mediaproxy....v=0..o=- 10523026
> 10523026 IN IP4 192.168.0.87..s=-..c=IN IP4 192.168.0.67..t=0 0..m=audio 35566
RTP/AVP 18 100 101..a=rt
> pmap:18 G729a/8000..a=rtpmap:100 NSE/8000..a=rtpmap:101
telephone-event/8000..a=fmtp:101 0-15..a=ptime:30..a
> =sendrecv..
>#
>U 192.168.0.91:44863 -> 192.168.0.65:5060
> ACK sip:2020@192.168.0.87:5060 SIP/2.0..Via: SIP/2.0/UDP
10.0.0.2:44863;branch=z9hG4bK7246a42746efbbc5.
> .Route: <sip:2020@192.168.0.65;ftag=ef9d331f5bca723c;lr=on>..From:
"Telles 2" <sip:1919@ser.server.net>;tag
> =ef9d331f5bca723c..To:
<sip:2020@ser.server.net>;tag=3033786eec83f67bi0..Contact:
<sip:1919@10.0.0.2:44863
> >..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33385 ACK..User-Agent: Grandstream
BT100 1.0.5.11..Max-Forwa
> rds: 70..Allow:
INVITE,ACK,CANCEL,BYE,NOTIFY,REFER,OPTIONS,INFO,SUBSCRIBE..Content-Length: 0....
>#
>U 192.168.0.65:5060 -> 192.168.0.87:5060
> ACK sip:2020@192.168.0.87:5060 SIP/2.0..Record-Route:
<sip:2020@192.168.0.65;ftag=ef9d331f5bca723c;lr=on
> >..Via: SIP/2.0/UDP 192.168.0.65;branch=0..Via: SIP/2.0/UDP
10.0.0.2:44863;rport=44863;received=192.168
> .0.91;branch=z9hG4bK7246a42746efbbc5..From: "Telles 2"
<sip:1919@ser.server.net>;tag=ef9d331f5bca723c..To:
> <sip:2020@ser.server.net>;tag=3033786eec83f67bi0..Contact:
<sip:1919@192.168.0.91:44863>..Call-ID: e0b16e3a
> 3d427e23@10.0.0.2..CSeq: 33385 ACK..User-Agent: Grandstream BT100
1.0.5.11..Max-Forwards: 69..Allow: INVI
> TE,ACK,CANCEL,BYE,NOTIFY,REFER,OPTIONS,INFO,SUBSCRIBE..Content-Length: 0..P-hint:
fixed NAT contact for requ
> est....
>######
>U 192.168.0.91:44863 -> 192.168.0.65:5060
> BYE sip:2020@192.168.0.87:5060 SIP/2.0..Via: SIP/2.0/UDP
10.0.0.2:44863;branch=z9hG4bK63b83d2965c75b38.
> .Route: <sip:2020@192.168.0.65;ftag=ef9d331f5bca723c;lr=on>..From:
"Telles 2" <sip:1919@ser.server.net>;tag
> =ef9d331f5bca723c..To:
<sip:2020@ser.server.net>;tag=3033786eec83f67bi0..Contact:
<sip:1919@10.0.0.2:44863
> >..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33386 BYE..User-Agent: Grandstream
BT100 1.0.5.11..Max-Forwa
> rds: 70..Allow:
INVITE,ACK,CANCEL,BYE,NOTIFY,REFER,OPTIONS,INFO,SUBSCRIBE..Content-Length: 0....
>#
>U 192.168.0.65:5060 -> 192.168.0.87:5060
> BYE sip:2020@192.168.0.87:5060 SIP/2.0..Record-Route:
<sip:2020@192.168.0.65;ftag=ef9d331f5bca723c;lr=on
> >..Via: SIP/2.0/UDP 192.168.0.65;branch=z9hG4bK24.615e1d66.0..Via: SIP/2.0/UDP
10.0.0.2:44863;rport=448
> 63;received=192.168.0.91;branch=z9hG4bK63b83d2965c75b38..From: "Telles 2"
<sip:1919@ser.server.net>;tag=ef9
> d331f5bca723c..To: <sip:2020@ser.server.net>;tag=3033786eec83f67bi0..Contact:
<sip:1919@192.168.0.91:44863>
> ..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33386 BYE..User-Agent: Grandstream BT100
1.0.5.11..Max-Forwar
> ds: 69..Allow:
INVITE,ACK,CANCEL,BYE,NOTIFY,REFER,OPTIONS,INFO,SUBSCRIBE..Content-Length: 0..P-hint:
fixed N
> AT contact for request....
>#
>U 192.168.0.87:5060 -> 192.168.0.65:5060
> SIP/2.0 200 OK..To: <sip:2020@ser.server.net>;tag=3033786eec83f67bi0..From:
"Telles 2" <sip:1919@sip.server.ne
> t>;tag=ef9d331f5bca723c..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33386
BYE..Via: SIP/2.0/UDP 192.168.
> 0.65;branch=z9hG4bK24.615e1d66.0..Via: SIP/2.0/UDP
10.0.0.2:44863;rport=44863;received=192.168.0.91;bra
> nch=z9hG4bK63b83d2965c75b38..Record-Route:
<sip:2020@192.168.0.65;ftag=ef9d331f5bca723c;lr=on>..Server: Si
> pura/SPA2000-2.0.10(e)..Content-Length: 0....
>#
>U 192.168.0.65:5060 -> 192.168.0.91:44863
> SIP/2.0 200 OK..To: <sip:2020@ser.server.net>;tag=3033786eec83f67bi0..From:
"Telles 2" <sip:1919@sip.server.ne
> t>;tag=ef9d331f5bca723c..Call-ID: e0b16e3a3d427e23@10.0.0.2..CSeq: 33386
BYE..Via: SIP/2.0/UDP 10.0.0.
>
2:44863;rport=44863;received=192.168.0.91;branch=z9hG4bK63b83d2965c75b38..Record-Route:
<sip:2020@192.168.
> 0.65;ftag=ef9d331f5bca723c;lr=on>..Server:
Sipura/SPA2000-2.0.10(e)..Content-Length: 0....
># -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQFBkPhEiLK8unYgEMQRArnLAKCCkhYncvM4jgOmenYhoOM94Sz+lwCeLaMe
ugGOf/J334pWDu2U0b5U+AQ=
=2krN
-----END PGP SIGNATURE-----