-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@gmail.com Sent: Tuesday, March 5, 2019 10:07 AM To: Daniel W. Graham dan@cmsinter.net Cc: Kamailio (SER) - Users Mailing List sr-users@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@gmail.commailto:miconda@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@lists.kamailio.orgmailto:sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com
www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda
Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.comhttp://www.kamailioworld.com
Kamailio Advanced Training - Mar 25-27, 2019, in Washington, DC, USA -- www.asipto.comhttp://www.asipto.com
--
Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com
www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda
Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.comhttp://www.kamailioworld.com
Kamailio Advanced Training - Mar 25-27, 2019, in Washington, DC, USA -- www.asipto.comhttp://www.asipto.com