[SR-Users] load credentials in cnxcc from dburl

Daniel-Constantin Mierla miconda at gmail.com
Mon Aug 7 10:52:29 CEST 2017


Note also the is_subscriber() function from auth_db, it can be used to
load credentials without requiring the authentication process.

Also, sqlops is a handy module for loading data from any sql database table.

Cheers,
Daniel


On 07.08.17 10:04, Logeshwaran G wrote:
> Thanks a lot,
>
> Will refer the avpops module, If I need help, will get back to you.
>
> On Mon, Aug 7, 2017 at 1:24 PM, Federico Cabiddu
> <federico.cabiddu at gmail.com <mailto:federico.cabiddu at gmail.com>> wrote:
>
>     Hi,
>     you can use the avpops module for
>     this http://www.kamailio.org/docs/modules/devel/modules/avpops.html
>     <http://www.kamailio.org/docs/modules/devel/modules/avpops.html>.
>
>     Regards,
>
>     Federico
>
>     On Mon, Aug 7, 2017 at 9:52 AM, Logeshwaran G
>     <logeshwarangs at gmail.com <mailto:logeshwarangs at gmail.com>> wrote:
>
>         Yes, I am using the script which I have sent you in the
>         Previous mail,
>
>         But That   if($avp(credits) < 30
>         $avp(credits) is not reading the credits value from the
>         subscriber table,
>
>         Do i need to implement something for reading that database.
>
>
>         On Mon, Aug 7, 2017 at 1:14 PM, Federico Cabiddu
>         <federico.cabiddu at gmail.com
>         <mailto:federico.cabiddu at gmail.com>> wrote:
>
>             Hi,
>             so you don't need any credentials in cnxcc.
>             Just do as you are doing, read the subscriber's column
>             which hold the user's balance,and call or not the cnxcc's
>             functions according to the value of the avp.
>
>             Cheers,
>
>             Federico
>
>             On Mon, Aug 7, 2017 at 9:38 AM, Logeshwaran G
>             <logeshwarangs at gmail.com <mailto:logeshwarangs at gmail.com>>
>             wrote:
>
>                 Hi ,
>
>                 I do have one column name Credits in the kamailio
>                 table subscriber,
>
>                 I am trying to disallow the calls to the user whom
>                 they have low credits balance.
>
>                 with the below codes:
>
>                  if($avp(credits) < 30) {
>                                 xlog("L_ALERT", "ALERT: Credit balance
>                 is less");
>                                 sl_send_reply("403", "Forbidden");
>                                 drop; 
>                         }
>
>                 Correct me if I am wrong!!
>
>                 On Mon, Aug 7, 2017 at 12:37 PM, Federico Cabiddu
>                 <federico.cabiddu at gmail.com
>                 <mailto:federico.cabiddu at gmail.com>> wrote:
>
>                     Hi,
>                     maybe I don't understand your question, but cnxcc
>                     does not make any usage nor requires credential.
>                     What are you trying to achieve exactly?
>
>                     Cheers,
>
>                     Federico
>
>                     On Mon, Aug 7, 2017 at 8:21 AM, Logeshwaran G
>                     <logeshwarangs at gmail.com
>                     <mailto:logeshwarangs at gmail.com>> wrote:
>
>                         Is there any possibility of loading credential
>                         from the db in the cnxcc module.
>
>                         For Example: modparam("auth_db",
>                         "load_credentials", "$avp(status)=status")
>
>                         Like the above one , I need it for CNXCC
>
>                         _______________________________________________
>                         Kamailio (SER) - Users Mailing List
>                         sr-users at lists.kamailio.org
>                         <mailto:sr-users at lists.kamailio.org>
>                         https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>                         <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>
>
>                     _______________________________________________
>                     Kamailio (SER) - Users Mailing List
>                     sr-users at lists.kamailio.org
>                     <mailto:sr-users at lists.kamailio.org>
>                     https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>                     <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>
>
>                 _______________________________________________
>                 Kamailio (SER) - Users Mailing List
>                 sr-users at lists.kamailio.org
>                 <mailto:sr-users at lists.kamailio.org>
>                 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>                 <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>
>
>             _______________________________________________
>             Kamailio (SER) - Users Mailing List
>             sr-users at lists.kamailio.org
>             <mailto:sr-users at lists.kamailio.org>
>             https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>             <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>
>
>         _______________________________________________
>         Kamailio (SER) - Users Mailing List
>         sr-users at lists.kamailio.org <mailto:sr-users at lists.kamailio.org>
>         https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>         <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>
>
>     _______________________________________________
>     Kamailio (SER) - Users Mailing List
>     sr-users at lists.kamailio.org <mailto:sr-users at lists.kamailio.org>
>     https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>     <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>
>
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - www.asipto.com
Kamailio World Conference - www.kamailioworld.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20170807/cb264027/attachment.html>


More information about the sr-users mailing list