Hi,
I have a weird scenario, my sites are running fine but when I try to manage databases I get this:
"MySQL is not running on your system - database list could not be retrieved" I also get this: "/usr/bin/mysqlshow: Can't connect to local MySQL server through socket 'var/run/mysqld/mysqld.sock' (2)"
I noticed mysql service is stopped when I go to system information. If I try to start it through Virtualmin, the page refresh but nothing happens..
do you know what it may be?
Here's my extract of ps -A. I see a process for mysqld, so it's weird Virtualmin doesn't show it's started though..
PID TTY TIME CMD 1 ? 00:02:01 init 2 ? 00:00:00 kthreadd 3 ? 00:00:00 ksoftirqd/0 4 ? 00:00:00 kworker/0:0 5 ? 00:00:00 kworker/u:0 6 ? 00:00:00 migration/0 7 ? 00:00:00 watchdog/0 8 ? 00:00:00 cpuset 9 ? 00:00:00 khelper 10 ? 00:00:00 kdevtmpfs 11 ? 00:00:00 netns 12 ? 00:00:00 sync_supers 13 ? 00:00:00 bdi-default 14 ? 00:00:00 kintegrityd 15 ? 00:00:00 kblockd 16 ? 00:00:00 ata_sff 17 ? 00:00:00 khubd 18 ? 00:00:00 md 19 ? 00:00:00 kworker/0:1 20 ? 00:00:00 kworker/u:1 21 ? 00:00:00 khungtaskd 22 ? 00:00:00 kswapd0 23 ? 00:00:00 ksmd 24 ? 00:00:00 khugepaged 25 ? 00:00:00 fsnotify_mark 26 ? 00:00:00 ecryptfs-kthrea 27 ? 00:00:00 crypto 35 ? 00:00:00 kthrotld 36 ? 00:00:00 scsi_eh_0 37 ? 00:00:00 scsi_eh_1 38 ? 00:00:00 kworker/u:2 57 ? 00:00:00 devfreq_wq 192 ? 00:00:00 jbd2/vda1-8 193 ? 00:00:00 ext4-dio-unwrit 224 ? 00:00:00 mountall 274 ? 00:00:00 upstart-udev-br 276 ? 00:00:00 udevd 400 ? 00:00:00 vballoon 403 ? 00:00:00 kpsmoused 411 ? 00:00:00 kworker/0:2 446 ? 00:00:00 udevd 475 ? 00:00:00 dhclient3 478 ? 00:00:00 udevd 547 ? 00:00:00 upstart-socket- 652 ? 00:00:00 kjournald 687 ? 00:00:00 sshd 690 ? 00:00:00 dbus-daemon 703 ? 00:00:00 rsyslogd 809 tty4 00:00:00 getty 816 tty5 00:00:00 getty 824 tty2 00:00:00 getty 826 tty3 00:00:00 getty 834 tty6 00:00:00 getty 850 ? 00:00:00 dovecot 851 ? 00:00:00 acpid 853 ? 00:00:00 cron 854 ? 00:00:00 atd 855 ? 00:00:00 named 868 ? 00:00:00 mysqld 876 ? 00:00:00 whoopsie 930 ? 00:00:00 mailmanctl 931 ? 00:00:00 python 932 ? 00:00:00 python 933 ? 00:00:00 python 934 ? 00:00:00 python 935 ? 00:00:00 python 936 ? 00:00:00 python 937 ? 00:00:00 python 938 ? 00:00:00 python 954 ? 00:00:00 opendkim 1062 ? 00:00:00 master 1068 ? 00:00:00 pickup 1069 ? 00:00:00 qmgr 1097 ? 00:00:00 saslauthd 1098 ? 00:00:00 saslauthd 1099 ? 00:00:00 saslauthd 1100 ? 00:00:00 saslauthd 1101 ? 00:00:00 saslauthd 1113 ? 00:00:00 flush-253:0 1115 ? 00:00:00 flush-253:16 1128 ? 00:00:00 snmpd 1631 ? 00:00:00 miniserv.pl 1641 ? 00:00:00 vnstatd 1696 ? 00:00:00 proftpd 1732 ? 00:00:00 apache2 1741 ? 00:00:00 apache2 1763 ? 00:00:00 apache2 1766 ? 00:00:00 miniserv.pl 1772 tty1 00:00:00 getty 1796 ? 00:00:00 anvil 1797 ? 00:00:00 log 1799 ? 00:00:00 config 1825 ? 00:00:00 ntpd 1831 ? 00:00:00 sshd 1834 ? 00:00:00 console-kit-dae 1901 ? 00:00:00 polkitd 1999 ? 00:00:00 sshd 2000 pts/0 00:00:00 bash 2098 ? 00:00:01 php5-cgi 2102 ? 00:00:00 apache2 2317 ? 00:00:00 apache2 2417 ? 00:00:00 /usr/share/webm 2438 ? 00:00:00 cleanup 2439 ? 00:00:00 php5-cgi 2440 ? 00:00:00 trivial-rewrite 2442 ? 00:00:00 local 2492 pts/0 00:00:00 ps
Thanks!
This issue is being discussed in the support tracker here:
https://www.virtualmin.com/node/23296