sqlops error

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

sqlops error

Logeshwaran G
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
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sqlops error

Federico Cabiddu-3
Hi,
have you defined DBURL anywhere?

Cheers,

Federico


On Wed, Aug 9, 2017 at 8:00 AM, Logeshwaran G <[hidden email]> 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
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users



_______________________________________________
Kamailio (SER) - Users Mailing List
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sqlops error

Alex Balashov
In reply to this post by Logeshwaran G
What is the value of DBURL?

On August 9, 2017 2:00:58 AM EDT, Logeshwaran G <[hidden email]> 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


-- Alex

--
Principal, Evariste Systems LLC (www.evaristesys.com)

Sent from my Google Nexus.

_______________________________________________
Kamailio (SER) - Users Mailing List
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sqlops error

Logeshwaran G
In reply to this post by Federico Cabiddu-3
Yes I have defined

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

On Wed, Aug 9, 2017 at 11:32 AM, Federico Cabiddu <[hidden email]> wrote:
Hi,
have you defined DBURL anywhere?

Cheers,

Federico


On Wed, Aug 9, 2017 at 8:00 AM, Logeshwaran G <[hidden email]> 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
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users



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



_______________________________________________
Kamailio (SER) - Users Mailing List
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sqlops error

Federico Cabiddu-3
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 <[hidden email]> wrote:
Yes I have defined

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

On Wed, Aug 9, 2017 at 11:32 AM, Federico Cabiddu <[hidden email]> wrote:
Hi,
have you defined DBURL anywhere?

Cheers,

Federico


On Wed, Aug 9, 2017 at 8:00 AM, Logeshwaran G <[hidden email]> 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
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users



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



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



_______________________________________________
Kamailio (SER) - Users Mailing List
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: 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 <[hidden email]> 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 <[hidden email]> wrote:
Yes I have defined

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

On Wed, Aug 9, 2017 at 11:32 AM, Federico Cabiddu <[hidden email]> wrote:
Hi,
have you defined DBURL anywhere?

Cheers,

Federico


On Wed, Aug 9, 2017 at 8:00 AM, Logeshwaran G <[hidden email]> 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
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users



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



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



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



_______________________________________________
Kamailio (SER) - Users Mailing List
[hidden email]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Loading...