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
kamctl is shell script
You can add "set -x" at start of script and check what command failed.
вт, 5 мар. 2019 г. в 07:54, Daniel W. Graham dan@cmsinter.net:
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.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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
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.com mailto: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.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
-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
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@lists.kamailio.org On Behalf Of Daniel W. Graham Sent: Tuesday, March 5, 2019 11:36 AM To: miconda@gmail.com Cc: Kamailio (SER) - Users Mailing List sr-users@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@gmail.commailto:miconda@gmail.com> Sent: Tuesday, March 5, 2019 10:07 AM To: Daniel W. Graham <dan@cmsinter.netmailto:dan@cmsinter.net> Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto: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
Changing double quotes to single quotes around passwords in kamctlrc fixed the issue with kamctl.
-dan
From: sr-users sr-users-bounces@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@lists.kamailio.org; miconda@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@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Daniel W. Graham Sent: Tuesday, March 5, 2019 11:36 AM To: miconda@gmail.commailto:miconda@gmail.com Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@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@gmail.commailto:miconda@gmail.com> Sent: Tuesday, March 5, 2019 10:07 AM To: Daniel W. Graham <dan@cmsinter.netmailto:dan@cmsinter.net> Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto: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
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@cmsinter.net:
Changing double quotes to single quotes around passwords in kamctlrc fixed the issue with kamctl.
-dan
*From:* sr-users sr-users-bounces@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@lists.kamailio.org; miconda@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@lists.kamailio.org *On Behalf Of *Daniel W. Graham *Sent:* Tuesday, March 5, 2019 11:36 AM *To:* miconda@gmail.com *Cc:* Kamailio (SER) - Users Mailing List sr-users@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@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.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.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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
In this case its ok since it’s the source of the password:
From default kamctlrc -
## password for database read/write user DBRWPW="kamailiorw"
## password for database read only user DBROPW="kamailioro"
-dan
From: sr-users sr-users-bounces@lists.kamailio.org On Behalf Of Sergey Safarov Sent: Tuesday, March 5, 2019 12:20 PM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Subject: Re: [SR-Users] Kamctl / kamcmd
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@cmsinter.netmailto:dan@cmsinter.net>: Changing double quotes to single quotes around passwords in kamctlrc fixed the issue with kamctl.
-dan
From: sr-users <sr-users-bounces@lists.kamailio.orgmailto:sr-users-bounces@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@lists.kamailio.orgmailto:sr-users@lists.kamailio.org>; miconda@gmail.commailto:miconda@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@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Daniel W. Graham Sent: Tuesday, March 5, 2019 11:36 AM To: miconda@gmail.commailto:miconda@gmail.com Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@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@gmail.commailto:miconda@gmail.com> Sent: Tuesday, March 5, 2019 10:07 AM To: Daniel W. Graham <dan@cmsinter.netmailto:dan@cmsinter.net> Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto: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 _______________________________________________ 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
Any ideas on the kamcmd issue? Executing any kamcmd command hangs with no output.
-dan
From: sr-users sr-users-bounces@lists.kamailio.org On Behalf Of Daniel W. Graham Sent: Tuesday, March 5, 2019 12:26 PM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Subject: Re: [SR-Users] Kamctl / kamcmd
In this case its ok since it’s the source of the password:
From default kamctlrc -
## password for database read/write user DBRWPW="kamailiorw"
## password for database read only user DBROPW="kamailioro"
-dan
From: sr-users <sr-users-bounces@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Sergey Safarov Sent: Tuesday, March 5, 2019 12:20 PM To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org> Subject: Re: [SR-Users] Kamctl / kamcmd
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@cmsinter.netmailto:dan@cmsinter.net>: Changing double quotes to single quotes around passwords in kamctlrc fixed the issue with kamctl.
-dan
From: sr-users <sr-users-bounces@lists.kamailio.orgmailto:sr-users-bounces@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@lists.kamailio.orgmailto:sr-users@lists.kamailio.org>; miconda@gmail.commailto:miconda@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@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Daniel W. Graham Sent: Tuesday, March 5, 2019 11:36 AM To: miconda@gmail.commailto:miconda@gmail.com Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@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@gmail.commailto:miconda@gmail.com> Sent: Tuesday, March 5, 2019 10:07 AM To: Daniel W. Graham <dan@cmsinter.netmailto:dan@cmsinter.net> Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto: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 _______________________________________________ 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
This has something to do with TLS config.
If tls settings are removed/disabled in kamailio config file, kamcmd works normal. I havent identified the issue any further.
-dan
From: sr-users sr-users-bounces@lists.kamailio.org On Behalf Of Daniel W. Graham Sent: Tuesday, March 5, 2019 1:19 PM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Subject: Re: [SR-Users] Kamctl / kamcmd
Any ideas on the kamcmd issue? Executing any kamcmd command hangs with no output.
-dan
From: sr-users <sr-users-bounces@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Daniel W. Graham Sent: Tuesday, March 5, 2019 12:26 PM To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org> Subject: Re: [SR-Users] Kamctl / kamcmd
In this case its ok since it’s the source of the password:
From default kamctlrc -
## password for database read/write user DBRWPW="kamailiorw"
## password for database read only user DBROPW="kamailioro"
-dan
From: sr-users <sr-users-bounces@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Sergey Safarov Sent: Tuesday, March 5, 2019 12:20 PM To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org> Subject: Re: [SR-Users] Kamctl / kamcmd
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@cmsinter.netmailto:dan@cmsinter.net>: Changing double quotes to single quotes around passwords in kamctlrc fixed the issue with kamctl.
-dan
From: sr-users <sr-users-bounces@lists.kamailio.orgmailto:sr-users-bounces@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@lists.kamailio.orgmailto:sr-users@lists.kamailio.org>; miconda@gmail.commailto:miconda@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@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Daniel W. Graham Sent: Tuesday, March 5, 2019 11:36 AM To: miconda@gmail.commailto:miconda@gmail.com Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@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@gmail.commailto:miconda@gmail.com> Sent: Tuesday, March 5, 2019 10:07 AM To: Daniel W. Graham <dan@cmsinter.netmailto:dan@cmsinter.net> Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto: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 _______________________________________________ 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 W. Graham -
Daniel-Constantin Mierla -
Sergey Safarov