Yes I have defined

#!define DBURL "mysql://root:root@localhost/kamailio"

On Wed, Aug 9, 2017 at 11:32 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:

Hi, have you defined DBURL anywhere?

Cheers,

Federico

On Wed, Aug 9, 2017 at 8:00 AM, Logeshwaran G logeshwarangs@gmail.com wrote:

...

modparam("sqlops","sqlcon",DBURL)

Whether the above modparam implementation is wrong ? I am not sure

Its saying some error as 0(2519) ERROR: sqlops [sql_api.c:669]: sql_parse_param(): invalid sqlops parameter

---

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

---

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

Yes I have corrected the mistake.

Thanks.

Hi Federico,

Sorry to interrupt you once again, As per your input avpops worked fine for my scenario. Thanks once again.

I am having one more query, I need to know how to reduce the user balance amount .

Is there any module? Input please

Scenario: ======= I am having an user name 777, 777 having the credit of 10$

I mentioned the below details as well:

$var(credit) = "10$" $var(cost_per_sec) = "1"; # 1$ per sec $var(i_pulse) = "1"; # 1$ to establish the call $var(f_pulse) = "1"; # 1$ per second

so the user 777 should make call only for 9 seconds, the call should disconnect after the 9th second.

Also I need to reduce the credit balance as well.

On Wed, Aug 9, 2017 at 11:43 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:

Assuming that you started from default kamailio.cfg or kamailio-basic.cfg, do you also have #!define WITH_MYSQL?

Cheers,

Federico

On Wed, Aug 9, 2017 at 8:05 AM, Logeshwaran G logeshwarangs@gmail.com wrote:

...

Yes I have defined

#!define DBURL "mysql://root:root@localhost/kamailio"

On Wed, Aug 9, 2017 at 11:32 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:

...

Hi, have you defined DBURL anywhere?

Cheers,

Federico

On Wed, Aug 9, 2017 at 8:00 AM, Logeshwaran G logeshwarangs@gmail.com wrote:

...

modparam("sqlops","sqlcon",DBURL)

Whether the above modparam implementation is wrong ? I am not sure

Its saying some error as 0(2519) ERROR: sqlops [sql_api.c:669]: sql_parse_param(): invalid sqlops parameter

---

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

---

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

---

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

---

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