avp_db_load() & fetch attribute .... - sr-users - kamailio.org

List overview All Threads
Download

avp_db_load() & fetch attribute ....

Does Kamailio not support multiple...

What does this statement do?

arun Jayaprakash

28 Apr 2014 28 Apr '14

1:12 a.m.

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

Attachments:

attachment.html (text/html — 1.3 KB)

Reply

Show replies by date

Alex Balashov

28 Apr 28 Apr

1:44 a.m.

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(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/

Reply

Daniel-Constantin Mierla

11:29 a.m.

Hello, have you set use_domain parameter? http://kamailio.org/docs/modules/stable/modules/avpops.html#avpops.p.use_do… 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(a)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

Reply

arun Jayaprakash

9:55 p.m.

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(a)gmail.com> To: arun Jayaprakash <jayaprakasharun(a)yahoo.com>om>; Kamailio (SER) - Users Mailing List <sr-users(a)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_do… 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(a)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

Reply

Gary Wallis

11:25 p.m.

New subject: How to replace cachedb_local.so functionality

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

Reply

Charles Chance

11:54 p.m.

New subject: How to replace cachedb_local.so functionality

Hi, Maybe try http://kamailio.org/docs/modules/stable/modules/htable.html? Regards, Charles On 28 Apr 2014 21:26, "Gary Wallis" <gary.wallis(a)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(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- www.sipcentric.com Follow us on twitter @sipcentric <http://twitter.com/sipcentric> Sipcentric Ltd. Company registered in England & Wales no. 7365592. Registered office: Unit 10 iBIC, Birmingham Science Park, Holt Court South, Birmingham B7 4EJ.

Reply

Gary Wallis

29 Apr 29 Apr

3:37 p.m.

New subject: How to replace cachedb_local.so functionality

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,

Reply

Charles Chance

30 Apr 30 Apr

11:51 a.m.

New subject: How to replace cachedb_local.so functionality

Hi Gary, That's good to hear. Best regards, Charles On 29 Apr 2014 13:37, "Gary Wallis" <gary.wallis(a)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(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- www.sipcentric.com Follow us on twitter @sipcentric <http://twitter.com/sipcentric> Sipcentric Ltd. Company registered in England & Wales no. 7365592. Registered office: Unit 10 iBIC, Birmingham Science Park, Holt Court South, Birmingham B7 4EJ.

Reply

Daniel-Constantin Mierla

29 Apr 29 Apr

12:09 a.m.

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(a)gmail.com> *To:* arun Jayaprakash <jayaprakasharun(a)yahoo.com>om>; Kamailio (SER) - Users Mailing List <sr-users(a)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_do… 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(a)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

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

Reply

Carsten Bock

3:06 p.m.

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(a)yahoo.com>om>:

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(a)gmail.com> To: arun Jayaprakash <jayaprakasharun(a)yahoo.com>om>; Kamailio (SER) - Users Mailing List <sr-users(a)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_do… 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(a)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(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- Carsten Bock CEO (Geschäftsführer) ng-voice GmbH Schomburgstr. 80 D-22767 Hamburg / Germany http://www.ng-voice.com mailto:carsten@ng-voice.com Office +49 40 34927219 Fax +49 40 34927220 Sitz der Gesellschaft: Hamburg Registergericht: Amtsgericht Hamburg, HRB 120189 Geschäftsführer: Carsten Bock Ust-ID: DE279344284 Hier finden Sie unsere handelsrechtlichen Pflichtangaben: http://www.ng-voice.com/imprint/

Reply

3862

days inactive

3865

days old

sr-users@lists.kamailio.org

Manage subscription

9 comments

6 participants

tags (0)

participants (6)

Alex Balashov
arun Jayaprakash
Carsten Bock
Charles Chance
Daniel-Constantin Mierla
Gary Wallis