load credentials in cnxcc from dburl - sr-users - kamailio.org

List overview All Threads
Download

load credentials in cnxcc from dburl

Some Fault messages I am trying to...

Question regarding t_check_trans()

Logeshwaran G

7 Aug 2017 7 Aug '17

9:21 a.m.

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

Attachments:

attachment.html (text/html — 288 bytes)

Reply

Show replies by date

Federico Cabiddu

7 Aug 7 Aug

10:07 a.m.

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

Reply

Logeshwaran G

10:38 a.m.

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

_______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply

Federico Cabiddu

10:44 a.m.

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

_______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

_______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply

Logeshwaran G

10:52 a.m.

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(a)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(a)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(a)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(a)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(a)lists.kamailio.org >>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>> >>>> >>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing List >>> sr-users(a)lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>> >> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users(a)lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users(a)lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >

Reply

Federico Cabiddu

10:54 a.m.

Hi, you can use the avpops module for this http://www.kamailio.org/docs/modules/devel/modules/avpops.html. Regards, Federico On Mon, Aug 7, 2017 at 9:52 AM, Logeshwaran G <logeshwarangs(a)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(a)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(a)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(a)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(a)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(a)lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > > _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

_______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

_______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

_______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply

Logeshwaran G

11:04 a.m.

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(a)gmail.com

wrote:

> Hi, > you can use the avpops module for this http://www.kamailio.org/ > docs/modules/devel/modules/avpops.html. > > Regards, > > Federico > > On Mon, Aug 7, 2017 at 9:52 AM, Logeshwaran G <logeshwarangs(a)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(a)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(a)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(a)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(a)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(a)lists.kamailio.org >>>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Kamailio (SER) - Users Mailing List >>>>> sr-users(a)lists.kamailio.org >>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Kamailio (SER) - Users Mailing List >>>> sr-users(a)lists.kamailio.org >>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>> >>>> >>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing List >>> sr-users(a)lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>> >> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users(a)lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users(a)lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >

Reply

Daniel-Constantin Mierla

11:52 a.m.

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(a)gmail.com <mailto:federico.cabiddu@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(a)gmail.com <mailto:logeshwarangs@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(a)gmail.com <mailto:federico.cabiddu@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(a)gmail.com <mailto:logeshwarangs@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(a)gmail.com <mailto:federico.cabiddu@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(a)gmail.com <mailto:logeshwarangs@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(a)lists.kamailio.org <mailto:sr-users@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(a)lists.kamailio.org <mailto:sr-users@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(a)lists.kamailio.org <mailto:sr-users@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(a)lists.kamailio.org <mailto:sr-users@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(a)lists.kamailio.org <mailto:sr-users@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(a)lists.kamailio.org <mailto:sr-users@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(a)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

Reply

2667

days inactive

2667

days old

sr-users@lists.kamailio.org

Manage subscription

7 comments

3 participants

tags (0)

participants (3)

Daniel-Constantin Mierla
Federico Cabiddu
Logeshwaran G