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:
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
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;
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
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;
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
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:
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
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
On 4/28/2014 17:54, Charles Chance wrote:
Hi,
Maybe try http://kamailio.org/docs/modules/stable/modules/htable.html?
Regards,
Charles
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:
On 4/28/2014 17:54, Charles Chance wrote:
Hi,
Maybe try http://kamailio.org/docs/modules/stable/modules/htable.html?
Regards,
Charles
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,
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,
value 1 must be without double quotes around it.
Cheers, Daniel
On 28/04/14 20:55, 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;
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 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://www.asipto.com/ http://twitter.com/#!/miconda http://twitter.com/#%21/miconda -http://www.linkedin.com/in/miconda
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:
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;
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
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
-
Alex Balashov -
arun Jayaprakash -
Carsten Bock -
Charles Chance -
Daniel-Constantin Mierla -
Gary Wallis