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