[OpenSER-Users] Insert in location table very slow

Christian Schlatter cs at unc.edu
Mon Oct 15 19:36:36 CEST 2007


Ovidiu Sas wrote:
> 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

Or use cache-less db_mode 3.

/Christian

> 
> 
> 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
>>
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users





More information about the Users mailing list