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@devel-it.com.br |>Project Manager |>Devel-IT - http://www.devel-it.com.br |>TDKOM Group |>============================================ |> |>_______________________________________________ |>Serusers mailing list |>serusers@lists.iptel.org |>http://lists.iptel.org/mailman/listinfo/serusers |> | | |
============================================ Rodrigo P. Telles telles@devel-it.com.br Gerente de Projetos Devel-IT - http://www.devel-it.com.br Grupo TDKOM ============================================ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQFBkPhEiLK8unYgEMQRArnLAKCCkhYncvM4jgOmenYhoOM94Sz+lwCeLaMe ugGOf/J334pWDu2U0b5U+AQ= =2krN -----END PGP SIGNATURE-----
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.... #