Update from I-MSCP 1.2.9 to 1.3.0 failed, certificates have been removed, mysql server cannot restart

    Hi Nuxwin,


    today I have tried to update to the latest version 1.3.0.


    I ran the installer and got the error message that the roundcube schema could not be updated. Next, I googled the error and found a thread that it is an issue with php7. So I have downgraded to 5.6.24 and tried it again. It did not work. The installation canceled and stopped the apache/mysql/php services. First, Apache2 didn't come up. I found out that the SSL certificate has been removed during the update process, thus the SSL site could not be loaded. I have disabled the site and the service has been started. Next, mysql is not able to start.


    Code
    1. Unit mysql.service entered failed state.
    2. Aug 26 17:16:37 menkisyscloudsrv29 sshd[30559]: Failed password for root from 116.31.116.24 port 58705 ssh2
    3. Aug 26 17:16:37 menkisyscloudsrv29 sshd[30559]: Failed password for root from 116.31.116.24 port 58705 ssh2
    4. Aug 26 17:16:37 menkisyscloudsrv29 sshd[30559]: Failed password for root from 116.31.116.24 port 58705 ssh2
    5. Aug 26 17:16:37 menkisyscloudsrv29 sshd[30559]: Received disconnect from 116.31.116.24: 11: [preauth]
    6. Aug 26 17:17:01 menkisyscloudsrv29 CRON[30561]: pam_unix(cron:session): session opened for user root by (uid=0)
    7. Aug 26 17:17:01 menkisyscloudsrv29 CRON[30562]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
    8. Aug 26 17:17:01 menkisyscloudsrv29 CRON[30561]: pam_unix(cron:session): session closed for user root
    9. Aug 26 17:17:09 menkisyscloudsrv29 sshd[30564]: Failed password for root from 116.31.116.24 port 19060 ssh2

    I have made an database backup from my Wordpress installation but not from my other databases. I did not backup the /var/www/imcp folder.


    I have only the key and scr files from my wildcard certificate but not the pem file which was missing for the SSL startup.


    Nuxwin: your public key is still registered with my server. Could you have a look at the issue to the i-mscp 1.3.0 up and running again? I don't want to loose my settings! I will honor your efforts with a donoation. The ip address is 178.33.26.29. The imscp install files can be found in /root.



    Thanks,
    Sven

    Please have a look if the certificates of the relevant domains still exists in the db cert table. If yes try to purge apache2 + all configs and rerun installer with param -r

    Sry was not online. I'll write you in private

    Ok fixed:

    • Changed mysql root password
    • Fixed /etc/mysql/my.cnf
    • Reran imscp-autoinstall

    Hey Ninos,


    wow, thanks!! How did you get past the roundcube error? How did you reset the mysql password?


    Thanks again! I have to recheck my site as it is not working but the backend is running :-)


    I'll give you an update later once I figured out what is wrong with my frontend.

    The my.cnf was corrupt, surely the socket settings.
    About the root password reset, just google there are lots of tutorials :)


    Ok nice just give feedback

    Hi Ninos,


    sorry for the late reply. Yesterday I was able to run all my tests and encountered some problems with PHP 5.6.24 and Wordpress. But this is not related to that topic :-).


    I will post a follow up question in a new thread.


    Sven