Thanks Daniel; The thing is I’m trying to implement password-less starts (no hardcoded password)
So I’m querying the password on start from aws ssm and injecting it as a define, like. Kamailio -f kamailio.cfg -A “DBURL `script-than-returns-MySQL-dburl-lambda.sh`“ Is it possible to do substrdef from the command line? Better yet, do you have a different. Approach to doing this? David On Sat, 11 May 2019 at 07:12, Daniel-Constantin Mierla <[email protected]> wrote: > 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: [email protected] > phone: +34669448337 > > > On Sat, May 11, 2019 at 12:59 AM Sergiu Pojoga <[email protected]> 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 < >> [email protected]> 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 >>> email: [email protected] >>> phone: +34669448337 >>> >>> >>> On Sat, May 11, 2019 at 12:32 AM Sergiu Pojoga <[email protected]> >>> wrote: >>> >>>> You've got a typo >>>> >>>> modparam("sqlops","sqlcon","cb=>DBURL") >>>> >>>> On Fri, May 10, 2019 at 7:02 PM David Villasmil < >>>> [email protected]> 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 >>>>> email: [email protected] >>>>> phone: +34669448337 >>>>> _______________________________________________ >>>>> Kamailio (SER) - Users Mailing List >>>>> [email protected] >>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>> >>>> _______________________________________________ >>>> Kamailio (SER) - Users Mailing List >>>> [email protected] >>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing List >>> [email protected] >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> [email protected] >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> > > _______________________________________________ > Kamailio (SER) - Users Mailing > [email protected]https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > > -- > Daniel-Constantin Mierla -- www.asipto.comwww.twitter.com/miconda -- > www.linkedin.com/in/miconda > > -- Regards, David Villasmil email: [email protected] phone: +34669448337
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
