[SR-Users] Kamctl / kamcmd

[Daniel W. Graham]

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<mailto: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<mailto:miconda at gmail.com>
Cc: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org<mailto: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<mailto:miconda at gmail.com>>
Sent: Tuesday, March 5, 2019 10:07 AM
To: Daniel W. Graham <dan at cmsinter.net<mailto:dan at cmsinter.net>>
Cc: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org<mailto: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<mailto: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<mailto:sr-users at lists.kamailio.org>

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

--

Daniel-Constantin Mierla -- www.asipto.com<http://www.asipto.com>

www.twitter.com/miconda<http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda<http://www.linkedin.com/in/miconda>

Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.com<http://www.kamailioworld.com>

Kamailio Advanced Training - Mar 25-27, 2019, in Washington, DC, USA -- www.asipto.com<http://www.asipto.com>

--

Daniel-Constantin Mierla -- www.asipto.com<http://www.asipto.com>

www.twitter.com/miconda<http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda<http://www.linkedin.com/in/miconda>

Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.com<http://www.kamailioworld.com>

Kamailio Advanced Training - Mar 25-27, 2019, in Washington, DC, USA -- www.asipto.com<http://www.asipto.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190305/cce30f19/attachment.html>