yes that works.

My problem is not with sqlops.

My problem is with the DEFINE.

If I define:

#!define DBURL "mysql://user:password@localhost/dbname"

and later:

modparam("domain", "db_url", DBURL)

and then:

modparam("sqlops","sqlcon","cb=>mysql://user:password@localhost/dbname")

Everything works properly.


My problem is how to use that DEFINE on ALL instances where i need to use it.
i.e.

#!define DBURL "mysql://user:password@localhost/dbname"
modparam("domain", "db_url", DBURL)
modparam("sqlops","sqlcon","cb=>mysql://user:password@localhost/dbname")

works, but;

#!define DBURL ©
modparam("domain", "db_url", DBURL)
modparam("sqlops","sqlcon","cb=>DBURL")

does NOT, since
DBURL translates "mysql://user:password@localhost/dbname" (quotes included)

so 
modparam("sqlops","sqlcon","cb=>DBURL")
translates into
modparam("sqlops","sqlcon","cb=>"mysql://user:password@localhost/dbname"")

and that, of course, fails.




Regards,

David Villasmil
phone: +34669448337


On Sat, May 11, 2019 at 12:59 AM Sergiu Pojoga <pojogas@gmail.com> wrote:
does is work like below? That's how mine is set, probably for the same reason.

modparam("sqlops","sqlcon","cb=>mysql://user:password@localhost/dbname")

On Fri, May 10, 2019 at 7:47 PM David Villasmil <david.villasmil.work@gmail.com> wrote:
No, 

DBURL translates into 

"mysql://user:admin@dbuser/dbname"

so in sqlops:

modparam("sqlops","sqlcon","cb=>DBURL")  

translates into:

modparam("sqlops","sqlcon","cb=>"mysql://user:admin@dbuser/dbname"")  

that works great on 

modparam("domain", "db_url", DBURL)

because it translates into:

modparam("domain", "db_url", "mysql://user:admin@dbuser/dbname")



But not on the sqlops case

Regards,

David Villasmil
phone: +34669448337


On Sat, May 11, 2019 at 12:32 AM Sergiu Pojoga <pojogas@gmail.com> wrote:
You've got a typo

modparam("sqlops","sqlcon","cb=>DBURL")  

On Fri, May 10, 2019 at 7:02 PM David Villasmil <david.villasmil.work@gmail.com> wrote:
Hello guys,

So, i'm defining:

DBURL "mysql://user:password@dbhost/dbname"

and later on...

modparam("sqlops","sqlcon","cb=>"DBURL)

and this fails miserably..

What do do on this case?


Thanks all!

Regards,

David Villasmil
phone: +34669448337
_______________________________________________
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