[SR-Users] using avpops for querying an external db on kamailio 3.0.2

yaron nahcum yaron_nachum at yahoo.com
Tue Jun 29 17:47:14 CEST 2010


Hi,
I have recently installed a kamailio server with release 3.0.2. 
I would like to use the kamilio as a redirect server that would recieve REGISTER messages from users and query a proprietary database that holds users information - if the users are registered to the service it would redirect the user to the registrar. I need it for security reasons which I can't fully explain.

Now, I am using the avpops module. I have been able to make it work using the following configuration:

modparam("avpops","db_url","mysql://user:pass@localhost/mysql")
modparam("avpops","avp_table","proptable")
modparam("avpops","db_scheme","scheme0:username_col=sipUsername;value_col=sipDomainName;table=proptable")
----------

        if (is_method("REGISTER"))
        {
                if (avp_db_load("$fu/username","$avp(s:CONSTANT_DOMAIN)/$scheme0"))
                {
                        append_branch("sip:registrarIP");
                        sl_send_reply("302","Test Redirect");
                }
                else
                {
                        sl_send_reply("404","Test Not found");
                }
--------------

The thing is that I don't need to match the string CENTREX against the domain- it is something I added because I couldn't find another way to do it. I would like to match only the username. I tried wildcards or leaving it empty but it didn't work. I tried not to use the scheme and instead use the table it self but again it didn't work.
Is it possible? Do you know a better to do it?

Thanks,
Yaron.


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20100629/5f7dd7f2/attachment.htm>


More information about the sr-users mailing list