[SR-Users] Kamctl / kamcmd

[Sergey Safarov]

Single quotes not allow to resolve variables.

Could you test notation "${MY_VAR_NAME}" instead of "$MY_VAR_NAME"

Sergey

вт, 5 мар. 2019 г. в 20:17, Daniel W. Graham <dan at cmsinter.net>:

> Changing double quotes to single quotes around passwords in kamctlrc fixed
> the issue with kamctl.
>
>
>
> -dan
>
>
>
> *From:* sr-users <sr-users-bounces at lists.kamailio.org> *On Behalf Of *Daniel
> W. Graham
> *Sent:* Tuesday, March 5, 2019 11:44 AM
> *To:* Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>;
> miconda at gmail.com
> *Subject:* Re: [SR-Users] Kamctl / kamcmd
>
>
>
> Got a little ahead of myself, not an issue with the quotes, those have to
> be there obviously. Appears to be an issue with the way the password is
> presented though, still digging.
>
>
>
> -dan
>
>
>
> *From:* sr-users <sr-users-bounces at lists.kamailio.org> *On Behalf Of *Daniel
> W. Graham
> *Sent:* Tuesday, March 5, 2019 11:36 AM
> *To:* miconda at gmail.com
> *Cc:* Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>
> *Subject:* Re: [SR-Users] Kamctl / kamcmd
>
>
>
> -x didnt yield anything.
>
>
>
> I checked the source of kamctl -
>
>
>
> $MYSQL $2 -h $DBHOST -u $DBRWUSER "-p$DBRWPW" $DBNAME
>
>
>
> The issue is due to special characters in the password being interpreted
> by the shell due to the double quotes around "-p$DBRWPW".
>
>
>
> -dan
>
>
>
> *From:* Daniel-Constantin Mierla <miconda at gmail.com>
> *Sent:* Tuesday, March 5, 2019 10:07 AM
> *To:* Daniel W. Graham <dan at cmsinter.net>
> *Cc:* Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>
> *Subject:* Re: [SR-Users] Kamctl / kamcmd
>
>
>
> Then run with -x as suggested in another response on the mailing list,
> maybe you can get some hints there. Otherwise, kamctl is just using mysql
> tool for sending commands, is not implementing any mysql client itself.
>
> kamcmd doesn't do anything with mysql, it is just a binrpc client
> interacting with ctl module in kamailio.
>
> Cheers,
> Daniel
>
> On 05.03.19 15:15, Daniel W. Graham wrote:
>
> Version 5.1.7
>
>
>
> I saw a post talking about the grant issues on database creation, using an
> existing database in this case.
>
>
>
> -dan
>
> On Mar 5, 2019, at 2:53 AM, Daniel-Constantin Mierla <miconda at gmail.com>
> wrote:
>
> What version of kamailio are you using? Iirc, there were some updates to
> kamctl or kamdbctl related to latest mysql version, but if I am not wrong,
> they were about granting access, not executing queries.
>
> Cheers,
> Daniel
>
> On 05.03.19 05:54, Daniel W. Graham wrote:
>
> Are there any known compatibility issues with kamctl and mysql 8.0.x?
>
>
>
> Getting access denied when executing kamctl command. Kamcmd just hangs
> when executed.
>
>
>
> Kamctlrc is setup proper and connection can be made direct from shell to
> database using the same credentials.
>
>
>
> -dan
>
>
>
> _______________________________________________
>
> Kamailio (SER) - Users Mailing List
>
> sr-users at lists.kamailio.org
>
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
> --
>
> Daniel-Constantin Mierla -- www.asipto.com
>
> www.twitter.com/miconda -- www.linkedin.com/in/miconda
>
> Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.com
>
> Kamailio Advanced Training - Mar 25-27, 2019, in Washington, DC, USA -- www.asipto.com
>
> --
>
> Daniel-Constantin Mierla -- www.asipto.com
>
> www.twitter.com/miconda -- www.linkedin.com/in/miconda
>
> Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.com
>
> Kamailio Advanced Training - Mar 25-27, 2019, in Washington, DC, USA -- www.asipto.com
>
> _______________________________________________
> 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/20190305/9678a1c2/attachment.html>