After a reboot. Mysql is not running and will not start. I get this error when starting:
DBI connect failed : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
/var/run/mysqld directory does not exist. this was there before the reboot as the server was running.
I have just installed a new Ubuntu 18.04 server with the virtualmin script. Basic system seemed to be working ok. Post install config ran fine checked and satting ready for use.
This is a replacement machine for an older 14.04 virtualmin host that is now creaking. I backed up a domain and restored it on the new server. All seemed to go well. All users were created DB’s website etc.
This domain is a domain owned by us that we use as a dev domain. When trying to log into roundcube webmail on the new server we cannot login. We just get connection to Imp server failed.
We can connect to the domain using an externail email client in this case an android phone to create an email for a use on the test domain, account authenticate using SSL for IMAP (Accept All certs) and STARTTLS for SMTP (Accept all certs) perfect from the external email client. We can send and receive fine.
But trying to login from the same system using roundcube throws the error below. We have spent hours on google looking for a solution to no avail. We must be missing something or the new installer has missed something when it setup the server. Roundcube connects to dovecot and postfix using:
IMAP connections $config[‘default_host’] = ‘ssl://localhost’;
SMTP connections $config[‘smtp_server’] = ‘tls://localhost’;
May 24 21:26:22 vps7 dovecot: imap-login: Disconnected (no auth attempts in 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, TLS handshaking: SSL_accept() failed: error:14094418:SSL routines:ssl3_read_bytes:tlsv1 alert unknown ca: SSL alert number 48, session=<BCsBrWqmaJt/AAAB>
Seems to be something to do with unknown ca file. But this is OOTB in terms of webmin/virtualmin config.
Another anomaly is that there is no option to copy the ssl cert to Dovecot all we see is Webmin Usermin and Postfix. The virtualmin server has a letsencrypt cert installed. The transferred domain has a new letsencrypt cert also installed. Those processes worked fine.
Until we can get this working we cannot migrate the other domains. So any help urgently appreciated so we can get the new server working.