Hi. I have just installed Virtualmin on Ubuntu 12.04 LTS but cant get it to see the running MySQL instance. I get the error above.
I can log into MySQL manually:
root@server:/# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.24-0ubuntu0.12.04.1-log (Ubuntu)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
and confirm the correct password is set in /etc/webmin/mysql/config
I also saw a post on sourceforge suggesting changing nodbi=1 in the above config file but that did not help either.
can see the process running
root@server:/# service mysql status
mysql start/running, process 14531
And also see it in the process list inVirtualmin:
14531 mysql 13:29 /usr/sbin/mysqld
Any suggestions?
Thanks.
Howdy,
Is your Ubuntu installation something you performed yourself, such as onto a dedicated server? Or is it based on an image created by a provider, such as with a VPS?
Also, what does this command show:
dpkg -l 'mysql-server'
Hi thanks for getting back to me.
The Ubuntu installation was performed by me onto a dedicated server. I installed using minimal options, only the SSH option was ticked, then I installed Virtualmin using the GPL installer script with no problems at all.
Only changes I have made to default install is to use another my.cnf file from another server. Also tried replacing the my.cnf with one of the default templates but no joy.
root@server# dpkg -l 'mysql-server'Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Description
+++-=====================================================-=====================================================-==========================================================================================================================
ii mysql-server 5.5.24-0ubuntu0.12.04.1 MySQL database server (metapackage depending on the latest version)
root@server#
What's the output of
netstat -tpln | grep 3306?I'm assuming that Virtualmin determines the "MySQL is not running" by trying to connect to it and having that fail. It might also be caused by VM having incorrect paths to the MySQL executables or PID files in its config.
H thanks for the reply. Unfortunately I cant test as rebuilt the server last night. Working now with the same config. Strange.