Hello,

you can use htable module to cache data in memory and access it from config file or lua script via pv.

Cheers,
Daniel

On 6/13/12 2:27 PM, Sharif Tanvir Rahman wrote:
Hi Daniel,

I need to access custom database tables (i.e. not default with kamailio) from a lua script (extending kamailio.cfg).

Processing any incoming SIP request starts with a lua function and that in turn call other functions - and each one needs database access for taking routing decision. This seems to be a huge performance issue (connecting/querying db in several functions for a sip invite).

Could you please suggest

  * Any global scope (loads only once during start-up, but valid for
    each routing) in kamailio, where the required tables could be cached.
  * Or any other way to address this.


Thanks in advance.




On Tue, Jun 21, 2011 at 2:21 PM, Daniel-Constantin Mierla <mico...@gmail.com <mailto:mico...@gmail.com>> wrote:

    Hello,

    to rewrite the r-uri you can use the function for setting PV value:

    sr.pv.sets("$ru", "_here_is_new_uri_");

    To add contact headers to reply, you should use:

    sr.hdr.append_to_reply("Contact: <_here_is_your_uri_>\r\n");

    Cheers,
    Daniel


    On 6/20/11 3:23 PM, Sharif Tanvir Rahman wrote:
    Hello,

    We plan to use Kamailio as redirect server. Corresponding contact
    list is to be fetched by a Lua script from DB.

    The problem is about calling the required 'rewriteuri' function:

     1. From lua script. both 'sr.rewriteuri()' and
        'sr.modf("rewriteuri", ...)" fails to write the 'contact' field.
     2. I tried an alternative way; pushing the value from lua (e.g.
        sr.pv.sets("contact", "sip:...")) and got the value in the
        Kamailio.cfg ($var(contact)). But can't call the rewriteuri
        function with this variable's value as argument. This seems
        to be a general problem of calling a function from .cfg with
        a variable's value as parameter.

    Any help much appreciated.

-- Sharif


    _______________________________________________
    SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
    sr-users@lists.sip-router.org  <mailto:sr-users@lists.sip-router.org>
    http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla --http://www.asipto.com
    http://linkedin.com/in/miconda  --http://twitter.com/miconda




--
Sharif Tanvir

--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - 
http://asipto.com/u/katu
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - 
http://asipto.com/u/kpw



_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Reply via email to