[Serusers] Why SER query MySQL x times for the same thing?

Rodrigo P. Telles telles at devel-it.com.br
Tue Nov 9 18:03:00 CET 2004


-----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 at devel-it.com.br>
|>Project Manager
|>Devel-IT - http://www.devel-it.com.br
|>TDKOM Group
|>============================================
|>
|>_______________________________________________
|>Serusers mailing list
|>serusers at lists.iptel.org
|>http://lists.iptel.org/mailman/listinfo/serusers
|>
|
|
|

- --
============================================
Rodrigo P. Telles <telles at 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-----
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ngrep-dump.txt
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20041109/10561310/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ser.cfg
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20041109/10561310/attachment.asc>


More information about the sr-users mailing list