Problems with installation

mendozal

I had a problem installing a small VPS (1core, 2gb, 20gb, ubuntu 22.04) where the error was that the mysql docker container wasn't being created.
https://discord.com/channels/1205652108213485568/1205652108213485571/1250190455501619280

After using --repair in the installation, that issue was fixed and the installation was successfully finished.

After that I decided to create a somewhat larger server to test in Hetzner this time with Debian 12. The only things I did to the server were to create a non root user, disable root login with password, change hostname and change timezone. I also opened some ports on the hardware firewall (I couldn't find a list of ports to open in the docs)

After that I tried the installation and I got the same error than before

ERROR: Skipping creating swap space as there already exists a swap partition.
Waiting for MySQL to start...
Waiting for MySQL to start...
Waiting for MySQL to start...
Waiting for MySQL to start...
Waiting for MySQL to start...
ERROR 2002 (HY000): Can't connect to server on 'localhost' (111)
ERROR 2002 (HY000): Can't connect to server on 'localhost' (111)
SQL file import failed or database is not ready.
Error: Installation failed!

I'm sharing the report generated with the opencli public command.
http://support.openpanel.co/server_info/TdCjz51lxL62oUL3CXpLXXc6C6fEkrviMWFW0HkljGreww5Dc4NjAZuNTjim.txt

This is a test machine. If you want access to the server to I can reformat and give you access to test.

Regards.

mendozal

I'm also sharing the report from the first server (mentioned in discord) in case you want to take a look
http://support.openpanel.co/server_info/KevoSOJsN6pP1bPgH1dUzIwlej7yPwF8RclERfFGDtpKNDbQPMtYRzKdIjJk.txt

Please note that this is now working fine after the --repair command.

mendozal

I reinstalled the VM to Ubuntu 22.04 and tried again. This time it worked fine.

stefan

It takes mysql some time to initialize _15s, thats why I added those delays 5 x 5s - which should be enough for most cases.

This next update should do better job installing it.
We now use docker compose file where mysql-server with pre-fillled database Is started first, then OpenPanel image waits for mysql to be operational before running. This lowers the total install script time from 15 to 5m, and avg MySQL start time from 20 to 5s.
So far all tests are passing, even on low resource machines (2 core, 2g ram). Hopefully this will finally resolve all install problems ✌️

sline

Hi, I got a similar error on debian 12 (hetzner) system