[prev in list] [next in list] [prev in thread] [next in thread]
List: serusers
Subject: Re: [SR-Users] "kamdbctl create" failing with MySQL 8
From: Jonathan Tyler <jonathan.tyler () basement ! cloud>
Date: 2018-11-21 2:16:04
Message-ID: 140251312.3394.1542766564046.JavaMail.zimbra () basement ! cloud
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I just had the same thing happen to me. I installed Kamailio via Apt, and I'm using a \
dedicated MySQL server, with non-root admin credentials. Previously today I \
installed it using a local MySQL 5.7 database with no issues.
Kamailio Host: Kamailio 5.1.2 (Ubuntu 18.04)
MySQL Host: MySQL 8.0.13 (Windows Server 2012 R2)
It creates the database, then fails at granting permissions. Accounts were created \
and privileges flushed before executing.
> root@kamailio:~# kamdbctl create
> INFO: creating database kamailio ...
> mysql: [Warning] Using a password on the command line interface can be insecure.
> INFO: granting privileges to database kamailio ...
> mysql: [Warning] Using a password on the command line interface can be insecure.
> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the \
> manual that corresponds to your MySQL server version for the right syntax to use \
> near 'IDENTIFIED BY '<password>'' at line 1
I turned on query logging on the database host but didn't see any errors there, or in \
the error log itself.
> 2018-11-21T01:58:15.045586Z 8 Connect <user>@kamailio on using SSL/TLS
> 2018-11-21T01:58:15.046239Z 8 Query select @@version_comment limit 1
> 2018-11-21T01:58:15.046764Z 8 Query CREATE DATABASE kamailio CHARACTER SET utf8mb4
> 2018-11-21T01:58:15.189109Z 8 Quit
> 2018-11-21T01:58:15.208476Z 9 Connect <user>@kamailio on using SSL/TLS
> 2018-11-21T01:58:15.209019Z 9 Query select @@version_comment limit 1
> 2018-11-21T01:58:15.210114Z 9 Quit
I've tried with the default MySQL 5.7 Client on Ubuntu, and upgrading it to 8.0.13, \
but got the same result.
Unfortunately I don't know how to see the output of the SQL Statement being sent \
(without installing 5.7), or I'd try to run it manually.
- Jonathan
[Attachment #5 (text/html)]
<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; \
color: #000000"><div>I just had the same thing happen to me. I installed Kamailio via \
Apt, and I'm using a dedicated MySQL server, with non-root admin \
credentials.</div><div> <!--StartFragment--><div> <!--StartFragment--><div>Previously \
today I installed it using a local MySQL 5.7 database with no \
issues.</div><!--EndFragment--> </div><div><br data-mce-bogus="1"></div><div>Kamailio \
Host: Kamailio 5.1.2 (Ubuntu 18.04)</div><div data-marker="__SIG_PRE__">MySQL Host: \
<!--StartFragment-->MySQL 8.0.13<!--EndFragment--> (Windows Server 2012 \
R2)</div><!--EndFragment--> </div><div><br data-mce-bogus="1"></div><div>It creates \
the database, then fails at granting permissions. Accounts were created and \
privileges flushed before executing.</div><div></div><div><br></div><div><div>> \
root@kamailio:~# kamdbctl create</div><div> <!--StartFragment--><span style="color: \
#000000; font-family: arial, helvetica, sans-serif; font-size: 13.3333px; font-style: \
normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; \
letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; \
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; \
-webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: \
initial; text-decoration-color: initial; display: inline !important; float: none;" \
data-mce-style="color: #000000; font-family: arial, helvetica, sans-serif; font-size: \
13.3333px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: \
normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; \
text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: \
0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; \
text-decoration-style: initial; text-decoration-color: initial; display: inline \
!important; float: none;">><span> </span></span>INFO: creating database \
kamailio ...</div><div> <!--StartFragment--><span style="color: #000000; font-family: \
arial, helvetica, sans-serif; font-size: 13.3333px; font-style: normal; \
font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; \
letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; \
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; \
-webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: \
initial; text-decoration-color: initial; display: inline !important; float: none;" \
data-mce-style="color: #000000; font-family: arial, helvetica, sans-serif; font-size: \
13.3333px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: \
normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; \
text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: \
0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; \
text-decoration-style: initial; text-decoration-color: initial; display: inline \
!important; float: none;">><span> </span></span>mysql: [Warning] Using a \
password on the command line interface can be insecure.</div><div> \
<!--StartFragment--><span style="color: #000000; font-family: arial, helvetica, \
sans-serif; font-size: 13.3333px; font-style: normal; font-variant-ligatures: normal; \
font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; \
text-align: start; text-indent: 0px; text-transform: none; white-space: normal; \
widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: \
#ffffff; text-decoration-style: initial; text-decoration-color: initial; display: \
inline !important; float: none;" data-mce-style="color: #000000; font-family: arial, \
helvetica, sans-serif; font-size: 13.3333px; font-style: normal; \
font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; \
letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; \
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; \
-webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: \
initial; text-decoration-color: initial; display: inline !important; float: \
none;">><span> </span></span>INFO: granting privileges to database kamailio \
...</div><div> <!--StartFragment--><span style="color: #000000; font-family: arial, \
helvetica, sans-serif; font-size: 13.3333px; font-style: normal; \
font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; \
letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; \
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; \
-webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: \
initial; text-decoration-color: initial; display: inline !important; float: none;" \
data-mce-style="color: #000000; font-family: arial, helvetica, sans-serif; font-size: \
13.3333px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: \
normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; \
text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: \
0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; \
text-decoration-style: initial; text-decoration-color: initial; display: inline \
!important; float: none;">><span> </span></span>mysql: [Warning] Using a \
password on the command line interface can be insecure.</div><div> \
<!--StartFragment--><span style="color: #000000; font-family: arial, helvetica, \
sans-serif; font-size: 13.3333px; font-style: normal; font-variant-ligatures: normal; \
font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; \
text-align: start; text-indent: 0px; text-transform: none; white-space: normal; \
widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: \
#ffffff; text-decoration-style: initial; text-decoration-color: initial; display: \
inline !important; float: none;" data-mce-style="color: #000000; font-family: arial, \
helvetica, sans-serif; font-size: 13.3333px; font-style: normal; \
font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; \
letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; \
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; \
-webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: \
initial; text-decoration-color: initial; display: inline !important; float: \
none;">> <span></span></span>ERROR 1064 (42000) at line 1: You have an error \
in your SQL syntax; check the manual that corresponds to your MySQL server version \
for the right syntax to use near 'IDENTIFIED BY '<password>'' at line \
1</div></div><div><br></div><div>I turned on query logging on the database host but \
didn't see any errors there, or in the error log itself.</div><div><br \
data-mce-bogus="1"></div><div>> 2018-11-21T01:58:15.045586Z<span \
style="white-space: pre;" data-mce-style="white-space: pre;"> </span> 8 \
Connect<span style="white-space: pre;" data-mce-style="white-space: \
pre;"> </span><user>@kamailio on using SSL/TLS</div><div><div>> \
2018-11-21T01:58:15.046239Z<span style="white-space: pre;" \
data-mce-style="white-space: pre;"> </span> 8 Query<span \
style="white-space: pre;" data-mce-style="white-space: pre;"> </span>select \
@@version_comment limit 1</div><div>> 2018-11-21T01:58:15.046764Z<span \
style="white-space: pre;" data-mce-style="white-space: pre;"> </span> 8 \
Query<span style="white-space: pre;" data-mce-style="white-space: \
pre;"> </span>CREATE DATABASE kamailio CHARACTER SET utf8mb4</div><div>> \
2018-11-21T01:58:15.189109Z<span style="white-space: pre;" \
data-mce-style="white-space: pre;"> </span> 8 Quit<span \
style="white-space: pre;" data-mce-style="white-space: pre;"> </span></div><div>> \
2018-11-21T01:58:15.208476Z<span style="white-space: pre;" \
data-mce-style="white-space: pre;"> </span> 9 Connect<span \
style="white-space: pre;" data-mce-style="white-space: \
pre;"> </span><user>@kamailio on using SSL/TLS</div><div>> \
2018-11-21T01:58:15.209019Z<span style="white-space: pre;" \
data-mce-style="white-space: pre;"> </span> 9 Query<span \
style="white-space: pre;" data-mce-style="white-space: pre;"> </span>select \
@@version_comment limit 1</div><div>> 2018-11-21T01:58:15.210114Z<span \
style="white-space: pre;" data-mce-style="white-space: pre;"> </span> 9 \
Quit<span style="white-space: pre;" data-mce-style="white-space: \
pre;"> </span></div></div><div><br></div><div>I've tried with the default MySQL 5.7 \
Client on Ubuntu, and upgrading it to 8.0.13, but got the same result.</div><div><br \
data-mce-bogus="1"></div><div>Unfortunately I don't know how to see the output of the \
SQL Statement being sent (without installing 5.7), or I'd try to run it \
manually.</div><div><br data-mce-bogus="1"></div><div>- \
Jonathan</div><div></div></div></body></html>
[Attachment #6 (text/plain)]
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic