[OpenSER-Users] Insert in location table very slow

Ovidiu Sas sip.nslu at gmail.com
Mon Oct 15 19:17:02 CEST 2007


That's normal.  Set the db_mode to 1 if you want instant updates:
http://www.openser.org/docs/modules/1.3.x/usrloc.html#AEN285


Regards,
Ovidiu Sas

On 10/15/07, Gregorio <goyo.villalba at dialcom.com> wrote:
> Hi,
>
> Up to 60 seconds in mode 2: 'modparam("usrloc", "db_mode", 2)'
>
>         Gregorio.
>
> -----Mensaje original-----
> De: Alex Balashov [mailto:abalashov at evaristesys.com]
> Enviado el: lunes, 15 de octubre de 2007 18:48
> Para: Gregorio
> CC: users at openser.org
> Asunto: Re: [OpenSER-Users] Insert in location table very slow
>
>
> Gregorio,
>
> How long does it take?
>
> -- Alex
>
> On Mon, 15 Oct 2007, Gregorio wrote:
>
> > Hi all.
> >
> >
> >
> > I am using openSer 1.3 with mySQL. My problem is that although
> registration
> > is fast in SIP protocol terms, the contact binding is written in the
> > 'location' table long time after this contact has received a 200 OK to his
> > registration. So a user could think that he is registered before he is in
> > the data base.
> >
> >
> >
> > Could it be a configuration issue?
> >
> > Can I solve this?
> >
> >
> >
> > Thanks!
> >
> >
> >
> > This is my config:
> >
> >
> >
> >
> >
> > # ----------- global configuration parameters ------------------------
> >
> >
> >
> > debug=2            # debug level (cmd line: -dddddddddd)
> >
> > log_facility=LOG_LOCAL7
> >
> > fork=yes
> >
> > log_stderror=no   children=4
> >
> > port=5060
> >
> >
> >
> > listen=udp:192.168.1.206:5060
> >
> > listen=tcp:192.168.1.206:5060
> >
> >
> >
> > # ------------------ module loading ----------------------------------
> >
> >
> >
> > #set module path
> >
> > mpath="/usr/local/lib/openser/modules/"
> >
> >
> >
> > loadmodule "mysql.so"
> >
> > loadmodule "xlog.so"
> >
> > loadmodule "sl.so"
> >
> > loadmodule "tm.so"
> >
> > loadmodule "rr.so"
> >
> > loadmodule "maxfwd.so"
> >
> > loadmodule "usrloc.so"
> >
> > loadmodule "registrar.so"
> >
> > loadmodule "textops.so"
> >
> > loadmodule "auth.so"
> >
> > loadmodule "auth_db.so"
> >
> >
> >
> > loadmodule "presence.so"
> >
> >
> >
> > loadmodule "presence_xml.so"
> >
> >
> >
> > loadmodule "mi_fifo.so"
> >
> >
> >
> > loadmodule "mi_xmlrpc.so"
> >
> >
> >
> > # ----------------- setting module-specific parameters ---------------
> >
> >
> >
> >
> >
> > modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")
> >
> >
> >
> > # -- usrloc params --
> >
> >
> >
> > modparam("usrloc", "db_mode", 2)
> >
> >
> >
> > # -- auth params --
> >
> > modparam("auth_db", "calculate_ha1", yes)
> >
> > modparam("auth_db", "password_column", "password")
> >
> >
> >
> > # -- rr params --
> >
> > # add value to ;lr param to make some broken UAs happy
> >
> > modparam("rr", "enable_full_lr", 1)
> >
> >
> >
> >
> >
> > #Agnadido para la Presencia
> >
> > modparam("presence|usrloc|pua",
> > "db_url","mysql://openser:openserrw@127.0.0.1/openser")
> >
> > modparam("presence", "presentity_table", "presentity")
> >
> > modparam("presence", "active_watchers_table", "active_watchers")
> >
> > modparam("presence", "watchers_table", "watchers")
> >
> > modparam("presence", "clean_period", 100)
> >
> > modparam("presence", "max_expires", 3600)
> >
> > modparam("presence", "server_address", "sip:192.168.1.206:5060" )
> >
> >
> >
> > #Presence_XML
> >
> > modparam("presence_xml",
> > "db_url","mysql://openser:openserrw@127.0.0.1/openser")
> >
> > modparam("presence_xml", "xcap_table", "xcap")
> >
> > modparam("presence_xml", "force_active", 1)
> >
> > modparam("presence_xml", "integrated_xcap_server", 1)
> >
> > modparam("presence_xml", "pidf_manipulation", 1)
> >
> > modparam("presence_xml", "pidf_manipulation", 1)
> >
> >
> >
> > #Mi FIFO
> >
> > modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")
> >
> > modparam("mi_fifo", "fifo_mode", 0600)
> >
> > modparam("mi_fifo", "fifo_group", 0)
> >
> > modparam("mi_fifo", "fifo_group", "root")
> >
> > modparam("mi_fifo", "fifo_user", 0)
> >
> > modparam("mi_fifo", "fifo_user", "root")
> >
> > modparam("mi_fifo", "reply_dir", "/home/openser/tmp/")
> >
> >
> >
> > #Mi XMLRPC
> >
> > modparam("mi_xmlrpc", "port", 8080)
> >
> > modparam("mi_xmlrpc", "log_file", "/var/log/openser-xmlrpc.log")
> >
> > modparam("mi_xmlrpc", "reply_option", 0)
> >
> > modparam("mi_xmlrpc", "buffer_size", 8192)
> >
> >
> >
> >
> >
> > # -------------------------  request routing logic -------------------
> >
> >
> >
> > # main routing logic
> >
> >
> >
> > route{
> >
> >
> >
> >        # initial sanity checks -- messages with
> >
> >        # max_forwards==0, or excessively long requests
> >
> >
> >
> >       if (!mf_process_maxfwd_header("10")) {
> >
> >                sl_send_reply("483","Too Many Hops. Route filter");
> >
> >                exit;
> >
> >        }
> >
> >
> >
> >        if (msg:len >= max_len ) {
> >
> >                sl_send_reply("513", "Message too big. Route filter");
> >
> >                exit;
> >
> >        }
> >
> >
> >
> >        if (!method=="REGISTER")
> >
> >                record_route();
> >
> >
> >
> >        # subsequent messages withing a dialog should take the
> >
> >        # path determined by record-routing
> >
> >        if (loose_route()) {
> >
> >                # mark routing logic in request
> >
> >                append_hf("P-hint: rr-enforced\r\n");
> >
> >                route(1);
> >
> >        };
> >
> >        if (uri==myself) {
> >
> >                route(1);
> >
> >        };
> >
> >
> >
> >        if (uri==myself) {
> >
> >                # presence handling
> >
> >                if( is_method("PUBLISH|SUBSCRIBE")){
> >
> >                        route(2);
> >
> >                };
> >
> >
> >
> >                if (is_present_hf("MyHeader"))
> >
> >                {
> >
> >                        t_relay("192.168.1.111");
> >
> >                        exit;
> >
> >                };
> >
> >
> >
> >
> >
> >                if (method=="REGISTER") {
> >
> >                        # Uncomment this if you want to use digest
> > authentication
> >
> >                        if (!www_authorize("openserDialcom", "subscriber"))
> > {
> >
> >                                www_challenge("openserDialcom", "0");
> >
> >                                exit;
> >
> >                        };
> >
> >
> >
> >                        save("location");
> >
> >                        exit;
> >
> >                };
> >
> >
> >
> >                lookup("aliases");
> >
> >                if (!uri==myself) {
> >
> >                        append_hf("P-hint: outbound alias\r\n");
> >
> >                        route(1);
> >
> >                };
> >
> >
> >
> >                # native SIP destinations are handled using our USRLOC DB
> >
> >                if (!lookup("location")) {
> >
> >                        sl_send_reply("404", "Not Found in openSer");
> >
> >                        exit;
> >
> >                };
> >
> >                append_hf("P-hint: usrloc applied\r\n");
> >
> >        };
> >
> >
> >
> >        route(1);
> >
> > }
> >
> >
> >
> > route[1] {
> >
> >        # send it out now; use stateful forwarding as it works reliably
> >
> >        # even for UDP2TCP
> >
> >        if (!t_relay()) {
> >
> >                sl_reply_error();
> >
> >        };
> >
> >        exit;
> >
> > }
> >
> > route[2]
> >
> > {
> >
> >        # absorb retransmissions
> >
> >        if (! t_newtran())
> >
> >        {
> >
> >                sl_reply_error();
> >
> >                exit;
> >
> >        };
> >
> >
> >
> >        if(is_method("PUBLISH"))
> >
> >        {
> >
> >                handle_publish();
> >
> >                t_release();
> >
> >        } else if( is_method("SUBSCRIBE")) {
> >
> >                handle_subscribe();
> >
> >                t_release();
> >
> >        };
> >
> >
> >
> >        exit;
> >
> > }
> >
> >
>
> --
> Alex Balashov
> Evariste Systems
> Web    : http://www.evaristesys.com/
> Tel    : +1-678-954-0670
> Direct : +1-678-954-0671
>
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>




More information about the Users mailing list