mysql-server newest version 5.7.42 Error

Is it possible that for a simple mysql update everything stopped?
I'm not an expert in Ubuntu and Ispconfig, I need commercial support to solve my problem

 

Yes, that is likely the cause of this failure. I told you in #2 ISPConfig only supports the mysql version that comes with the operating system, other versions usually just fail.
You should start with this:
https://forum.howtoforge.com/threads/please-read-before-posting.58408/
Newish linux releases use systemctl to start and stop services. Try with these commands:

Code:

systemctl status mysql.service
systemctl status mysqld.service
systemctl start mysqld.service

How did you install the new mysql version? Did you remove the old mysql before that?

 

I didn't remove the old service I upgraded to the new version

 

root@srv ~ # cat htf_report.txt | more

##### SERVER #####
IP-address (as per hostname): ***.***.***.***
[WARN] could not determine server's ip address by ifconfig
[INFO] OS version is Ubuntu 18.04.6 LTS

[INFO] uptime: 15:02:16 up 2:02, 1 user, load average: 0.00, 0.00, 0.00

[INFO] memory:
total used free shared buff/cache available
Mem: 62G 2.0G 59G 74M 1.3G 60G
Swap: 31G 0B 31G

[INFO] ISPConfig is installed.

##### ISPCONFIG #####
ISPConfig version is 3.2.11

 

root@srv ~ # wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispco nfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php
PHP Fatal error: Uncaught mysqli_sql_exception: No such file or directory in /r oot/htf-common-issues.php:288
Stack trace:
#0 /root/htf-common-issues.php(288): mysqli_connect()
#1 {main}
thrown in /root/htf-common-issues.php on line 288

 

You have not revealed how you did the upgrade of mysql.

 

I dont remenber
maybe by this command:
sudo apt-get upgrade mysql-server

 

root@srv ~ # systemctl start mysqld.service
Failed to start mysqld.service: Unit mysqld.service not found.

 

Code:

sudo apt-get upgrade mysql-server

That can not work.
And if it worked and that is only thing you did I would say the upgraded server can not work, it needs additional stuff done.
But assuming you only used apt commands, you can remove the installed mysql using apt commands, and then install the original mysql back. Or your system gets even more messed up, so think about the risks. Make backups first.
See files /var/log/dpkg.log* to see what has been installed and removed at the time you started with upgrading mysql. Then decide what needs to be removed, it might be better to use apt remove --purge to get rid of configuration files, since they likely do not work with older version of mysql. If you had added extra repositories for this, remove them.
Then use ISPConfig installation guides to install mysql back, https://www.howtoforge.com/tutorial...l-pureftpd-bind-postfix-doveot-and-ispconfig/ or the related guide for nginx if you use that instead of apache.
Finally force ispconfig to reconfigure services with ispconfig-update.sh --force and answer yes when it asks about reconfiguring services.

 

Dear Taleman
I am unable to restore the system. I made a request for business intervention but did not receive a response. Thom's behavior is unacceptable, he shows himself to be an irresponsible person who holds a monopoly on the support of this forum. I don't think it's right and I ask that other programmers be given the opportunity to collaborate with the support of ISPConfig.
It's the third day that my server is down and my customers are complaining. This is a huge damage to our association.
Is it possible that there isn't a person who can do the restoration work for me, obviously paying?

 

You wrote in #3:

Is the host a rented instance from some provider? If it is, there likely is an image backup, which you can restore. Or pay the provider support to do the restore for you.
If you know there is a copy system, you should focus on finding out about it and restore the system to before the mysql update point.

I do not think that is true. You can purchase support from anyone you like. It might be a good idea to scout locally for ISPConfig expertise, and pay them to fix your system