[SR-Users] sqlops error

[Logeshwaran G]

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 at 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 at 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 at gmail.com> wrote:
>>
>>> Hi,
>>> have you defined DBURL anywhere?
>>>
>>> Cheers,
>>>
>>> Federico
>>>
>>>
>>> On Wed, Aug 9, 2017 at 8:00 AM, Logeshwaran G <logeshwarangs at 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 at lists.kamailio.org
>>>> 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
>>>
>>>
>>
>> _______________________________________________
>> Kamailio (SER) - Users Mailing List
>> sr-users at lists.kamailio.org
>> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20170809/7cb641c2/attachment.html>