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

Discussion in 'Installation/Configuration' started by Nomis, Oct 1, 2018.

  1. Nomis

    Nomis New Member

    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 -
    [email protected]:~# /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 -
    [email protected]:~# /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.
     
  2. Frankenstein

    Frankenstein Member

    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
     
    Nomis likes this.
  3. Nomis

    Nomis New Member

    Thank you

    Will give it a try
     
  4. Nomis

    Nomis New Member

    Ok

    get the following error when running: Database restore
    [email protected]:/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
    [email protected]:/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!
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    In my opinion, your problem is not the ispconfig backup, so a restore of that won't help you as the ispconfig installation is not damaged. The problem is that mysql itself is broken and probably parts of the apache setup is broken as well or your whole filesystem is mounted read-only due to a filesystem failure. Take a look at the Linux syslog file to find out why mysql fails and at the apache error.log to see why apache fails.
     
  6. Nomis

    Nomis New Member

    Hi Till

    Thanks for the input

    Postfix is loading now - But can download mail -
    upload_2018-10-1_19-53-10.png
    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
    upload_2018-10-1_19-52-11.png

     
  7. Nomis

    Nomis New Member

    @ 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
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    The ssl cert is missing. Get the file /etc/postfix/smtpd.cert from the etc backup file that ispconfig created and copy it back to the original location /etc/postfix/smtpd.cert. Then restart apache, postfix and dovecot.
     
    Nomis likes this.
  9. Nomis

    Nomis New Member

    Sorted

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

    Thanks to all for the assitance
     
    Frankenstein and till like this.

Share This Page