Urgent - Power Failure during upgrade- Apache and Mysql not running

Hi does any one know how to recover from this.

I was busy updating to the latest version via : ispconfig_update.sh. When I had a power failure during the process. I dont know how far it got on the update. So i did a little digging and found what looks to be the back before it does the actual update. This is a live server and I can login to the server.
I tried to start each service manually:
Postfix - Startred
Bind - Started
MYSQL -
root@ns:~# /etc/init.d/mysql start
[....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
failed!
Apache -
root@ns:~# /etc/init.d/apache2 start
[....] Starting apache2 (via systemctl): apache2.serviceJob for apache2.service failed. See 'systemctl status apache2.service' and 'journalctl -xn' for details.
failed!

Please any help would appreciated

I did say do a backup and I found the following :
etc.tar.gz
ispconfig_db_backup.sql
ispconfig_software.tar.gz

Found these errors in the mail.log
1 15:01:39 ns dovecot: master: Fatal: service(auth) Group doesn't exist: vmail (See service auth { unix_listener /var/run/dovecot/auth-userdb { group } } setting)
Oct 1 15:01:39 ns dovecot: master: Fatal: service(auth) Group doesn't exist: vmail (See service auth { unix_listener /var/run/dovecot/auth-userdb { group } } setting)
Oct 1 15:01:39 ns dovecot: master: Fatal: service(auth) Group doesn't exist: vmail (See service auth { unix_listener /var/run/dovecot/auth-userdb { group } } setting)
Oct 1 15:01:39 ns dovecot: master: Fatal: service(auth) Group doesn't exist: vmail (See service auth { unix_listener /var/run/dovecot/auth-userdb { group } } setting)
Oct 1 15:01:39 ns dovecot: master: Fatal: service(auth) Group doesn't exist: vmail (See service auth { unix_listener /var/run/dovecot/auth-userdb { group } } setting)
Oct 1 15:29:17 ns postfix[1878]: fatal: file /etc/postfix/main.cf: parameter setgid_group: unknown group name: postdrop
Oct 1 15:29:18 ns postfix[1880]: fatal: file /etc/postfix/main.cf: parameter setgid_group: unknown group name: postdrop
Oct 1 15:49:37 ns postfix/sendmail[2459]: fatal: file /etc/postfix/main.cf: parameter setgid_group: unknown group name: postdrop
Oct 1 16:55:57 ns postfix/sendmail[4670]: fatal: file /etc/postfix/main.cf: parameter setgid_group: unknown group name: postdrop


Found these errors in the sys.log
1 13:30:01 ns CRON[1379]: (root) CMD (/usr/local/ispconfig/server/cron.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done)
Oct 1 13:30:01 ns CRON[1381]: (root) CMD (/usr/local/ispconfig/server/server.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done)
Oct 1 13:30:06 ns systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
Oct 1 13:30:06 ns mysql[1433]: Starting MariaDB database server: mysqldinstall: invalid group ‘root’
Oct 1 13:30:06 ns systemd[1]: mysql.service: control process exited, code=exited status=1
Oct 1 13:30:06 ns systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Oct 1 13:30:06 ns systemd[1]: Unit mysql.service entered failed state.

 

to restore /etc:
cd /
rm -fr etc/
tar xvfz /path/to/your/backup/etc.tar.gz

to restore ispconfig installation:
cd /usr/local
rm -fr ispconfig/
tar xvfz /path/to/your/backup/ispconfig_software.tar.gz.tar.gz

to restore the mysql database:
mysql -h localhost -u root -p[database password] dbispconfig < /path/to/your/backup/ispconfig_db_backup.sql

 

Thank you

Will give it a try

 

Ok

get the following error when running: Database restore
root@ns:/home/simon# mysql -h localhost -u root -p[notmypassword] dbispconfig < /var/backup/ispconfig_ns.somewhere.co.za_2018-10-01_10-41/ispconfig_db_backup.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Post fix is running -
Apache still says
root@ns:/home/simon# /etc/init.d/apache2 start
[....] Starting apache2 (via systemctl): apache2.serviceJob for apache2.service failed. See 'systemctl status apache2.service' and 'journalctl -xn' for details.
failed!

 

Hi Till

Thanks for the input

Postfix is loading now - But can download mail -

Apache - gives the following error when you start it:
Failed to start apache :
Starting apache2 (via systemctl): apache2.serviceJob for apache2.service failed. See 'systemctl status apache2.service' and 'journalctl -xn' for details.
failed!
Msql - Now stars up and i can see the databases

 

@ Till
Saw this off the bat:

1 20:03:32 ns postfix/smtpd[4319]: warning: cannot get RSA certificate from file /etc/postfix/smtpd.cert: disabling TLS support
Oct 1 20:03:32 ns postfix/smtpd[4319]: warning: TLS library problem: error:02001002:system library:fopen:No such file or directory:bss_file.c:398:fopen('/etc/postfix/smtpd.cert','r'):
Oct 1 20:03:32 ns postfix/smtpd[4319]: warning: TLS library problem: error:20074002:BIO routines:FILE_CTRL:system lib:bss_file.c:400:
Oct 1 20:03:32 ns postfix/smtpd[4319]: warning: TLS library problem: error:140DC002:SSL routines:SSL_CTX_use_certificate_chain_file:system lib:ssl_rsa.c:687:
Oct 1 20:03:32 ns postfix/smtpd[4319]: connect from localhost.localdomain[127.0.0.1]
Oct 1 20:03:32 ns postfix/smtpd[4319]: warning: SASL: Connect to private/auth failed: Connection refused
Oct 1 20:03:32 ns postfix/smtpd[4319]: fatal: no SASL authentication mechanisms
Oct 1 20:03:32 ns postfix/smtpd[4320]: warning: cannot get RSA certificate from file /etc/postfix/smtpd.cert: disabling TLS support
Oct 1 20:03:32 ns postfix/smtpd[4320]: warning: TLS library problem: error:02001002:system library:fopen:No such file or directory:bss_file.c:398:fopen('/etc/postfix/smtpd.cert','r'):
Oct 1 20:03:32 ns postfix/smtpd[4320]: warning: TLS library problem: error:20074002:BIO routines:FILE_CTRL:system lib:bss_file.c:400:
Oct 1 20:03:32 ns postfix/smtpd[4320]: warning: TLS library problem: error:140DC002:SSL routines:SSL_CTX_use_certificate_chain_file:system lib:ssl_rsa.c:687:
Oct 1 20:03:32 ns postfix/smtpd[4320]: connect from localhost.localdomain[127.0.0.1]
Oct 1 20:03:32 ns postfix/smtpd[4320]: warning: SASL: Connect to private/auth failed: Connection ref

 

Sorted

The following folder was missing usr\local\intefaces
Restored it and all services are working now

Thanks to all for the assitance