Re: [SR-Users] define a DBURL with SLQOPS fails

Hello, use: #!substdef "!DBURL!mysql://user:password@localhost/dbname!" The define is replacing only standalone tokens, not inside string values, like you have for sqlcon. More docs about should be in core cookbook from wiki. Cheers, Daniel On 11.05.19 02:05, David Villasmil wrote: 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 email: david.villasmil.work(a)gmail.com phone: +34669448337 On Sat, May 11, 2019 at 12:59 AM Sergiu Pojoga <pojogas(a)gmail.com> wrote: _______________________________________________ Kamailio (SER) - Users Mailing Listsr-users@lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla -- www.asipto.comwww.twitter.com/miconda -- www.linkedin.com/in/miconda --