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
Wouldn't you be better off just having your own tables and using your own SQL with 'sqlops'?
On 04/27/2014 06:12 PM, arun Jayaprakash wrote:
Hello,
have you set use_domain parameter?
http://kamailio.org/docs/modules/stable/modules/avpops.html#avpops.p.use_dom...
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:
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_dom...
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;
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
Hello,
Moving away from OpenSIPS...
How can I replace the functionality that
loadmodule "cachedb_local.so"
gives in Kamailio 4.1?
It is even needed?
Best regards, Gary
Hi,
Maybe try http://kamailio.org/docs/modules/stable/modules/htable.html?
Regards,
Charles On 28 Apr 2014 21:26, "Gary Wallis" gary.wallis@voicecarrier.com wrote:
On 4/28/2014 17:54, Charles Chance wrote:
Excellent idea.
This with the DMQ module has allowed me to replace Cassandra in a cluster setting for custom dialog limit per PBX.
Works great!
Thank you.
Best regards,
Hi Gary,
That's good to hear.
Best regards,
Charles On 29 Apr 2014 13:37, "Gary Wallis" gary.wallis@voicecarrier.com wrote:
Hello,
value 1 must be without double quotes around it.
Cheers, Daniel
On 28/04/14 20:55, arun Jayaprakash wrote:
Hi Arun,
The parameter should be: modparam("avpops","use_domain",1)
(no brackets around the 1)
Kind regards, Carsten
2014-04-28 20:55 GMT+02:00 arun Jayaprakash jayaprakasharun@yahoo.com:
-
Alex Balashov -
arun Jayaprakash -
Carsten Bock -
Charles Chance -
Daniel-Constantin Mierla -
Gary Wallis