Open maszaa opened 4 years ago
Hi @maszaa Azure DB is not supported and help is welcome.
Hello I got the same error messages...
My DB server is MySQL on a virtual server, which is hosted on VMC cloud.
Thank you, Regards, Tomolimo
As I can see, there is an issue with ssl connections – there is only one param --ssl-ca – this might cause an issue with mariadb client which is shipped now by default in debian and ubuntu instead of mysql.
Also, I am struggling a little bit to understand this line: https://github.com/major/MySQLTuner-perl/blob/master/mysqltuner.pl#L771 – I hadn't touched perl for the best part of last 20 years, but doesn't that mean that setting --ssl-ca prevents authentication using credentials altogether? This would cause issues on almost all remote servers configured nowadays.
As I understand, what is need to be done is:
– pass ssl parameters depending on client version (whether it's mysql or mariadb) – perhaps just make --ssl[a-z-]+
params passed straight to client application?
– allow ssl to be passed with credentials
After some hacking around (commenting out return 1
in if opt{ssl-ca} and adding an extra param --ssl which is passed through to mysql and mysqladmin), mysqltuner seems to be working. I will try to prepare PR if I'll be able to find some time next couple days.
I'm trying to run the tuner against MariaDB 10.3 hosted and managed by Microsoft Azure. SSL enforcement is enabled.
The command I'm using looks like this:
perl mysqltuner.pl --host <instance>.mariadb.database.azure.com --user <username>@<instance> --pass '<password>' --ssl-ca <certpath> --forcemem 10000
I've also tried --userenv and --passenv env variables, and providing host, user and pass with and without single and double quotes, and explicitly providing the port. No matter what I try I always get the following error
What is wrong? I am using the admin user account created when I deployed the database. I can connect to the database via mysql client.
When I use --debug I also get
[DG] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
though I've specified a host. I also tried using a different socket (--socket /tmp/mariadb.sock
) but that didn't help.