Hello Daniel, 

When I set the use_domain parameter 

modparam("avpops","domain_column","domain")
modparam("avpops","use_domain","1")

I get the following error:

 ERROR: <core> [modparam.c:152]: set_mod_param_regex(): set_mod_param_regex: parameter <use_domain> of type <1> not found in module <avpops>
Apr 28 18:45:48 ip-172-10-30-4 kamailio: : <core> [cfg.y:3570]: yyerror_at(): parse error in config file /usr/local/etc/kamailio//kamailio.cfg, line 510, column 35: Can't set module parameter

Can you let me know what needs to be done, thank you.

Arun



From: Daniel-Constantin Mierla <miconda@gmail.com>
To: arun Jayaprakash <jayaprakasharun@yahoo.com>; Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org>
Sent: Monday, April 28, 2014 3:29 AM
Subject: Re: [SR-Users] avp_db_load() & fetch attribute ....

Hello,

have you set use_domain parameter?

http://kamailio.org/docs/modules/stable/modules/avpops.html#avpops.p.use_domain

Then you can use the '/uri' flag for first parameter of avp_db_load().

Cheers,
Daniel

On 28/04/14 00:12, arun Jayaprakash wrote:
Can someone let me know how I can fetch an attribute depending on the value of two columns. For eg, in my usr_preference table I have 3 columns; 

username, domain, attribute. 

I need to fetch the attribute if the username = $ru and domain= $rd. Can someone let me know how this can be done, thanks.

Arun


_______________________________________________
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

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