Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Mysql is not starting #57

Open
marwan2 opened this issue Feb 15, 2024 · 7 comments
Open

Mysql is not starting #57

marwan2 opened this issue Feb 15, 2024 · 7 comments
Assignees
Labels

Comments

@marwan2
Copy link

marwan2 commented Feb 15, 2024

I started the container:
docker run --name myXampp -p 41061:22 -p 41062:80 -d -v ~/my_web_pages:/www tomsik68/xampp:8

and connected to it using SSH:
ssh root@localhost -p 41061

And trying to start the server:
/opt/lampp/lampp restart

But Mysql never started, tried many work-arounds but failed:
Version: XAMPP for Linux 8.2.4-0
Apache is running.
MySQL is not running.
ProFTPD is running.

Also I deleted the container, and started new one, but same issue "MySQL is not running."

@tomsik68
Copy link
Owner

Hey Marwan, thanks for reporting this! These issues are kind of heisenbugs so they're really difficult to debug but I'll try to help if I can.

Firstly, can you share which platform you're running Docker on? Is it Windows, Mac, Linux? It might be that the port 3306 is blocked by some process on your local machine (outside Docker). Do you happen to have a MariaDB running locally? If so, please try stopping it and see if it works now.

Besides that, can you share some of the workarounds that you tried? It might help us diagnose what's wrong.

@marwan2
Copy link
Author

marwan2 commented Feb 19, 2024

Thanks tomsik, I was using this docker image a few months ago, using PHP 8, it was working properly.
The latest updates cause this issue,

I'm running docker on Ubuntu 20.04
Docker version 19.03.6, build 369ce74a3c

@tomsik68
Copy link
Owner

Good, can you check whether anything is using your port 3306? This command should help:

$ sudo netstat -ntlp

@marwan2
Copy link
Author

marwan2 commented Feb 27, 2024

This is the output

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      38/httpd            
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      6/sshd: /usr/sbin/s 
tcp        0      0 0.0.0.0:443             0.0.0.0:*               LISTEN      38/httpd            
tcp6       0      0 :::21                   :::*                    LISTEN      -                   
tcp6       0      0 :::22                   :::*                    LISTEN      6/sshd: /usr/sbin/s 

@tomsik68
Copy link
Owner

tomsik68 commented Jun 1, 2024

I apologize, I don't see why MariaDB isn't starting for you and I'm not sure where to look next. I'll leave this open just in case anyone has a solution.

@suntong
Copy link

suntong commented Jul 24, 2024

I'm running docker on Ubuntu 20.04 as well, and my Mysql is not starting either.

After hour-long troubleshooting, I found my symptom is exactly as reported at https://serverfault.com/questions/1103333/mariadb-10-8-3-in-docker-cant-initialize-timers, i.e., the error is Can't initialize timers, and the answer is:

your docker version is likely < 20.10.10, which is the minimum required to use Jammy-based images. MariaDB > 10.8.2 uses Jammy, so there's a conflict there.

Upgrading docker is really the only correct option at this point.

@d0rb
Copy link

d0rb commented Jul 29, 2024

Sadly same here , couldn't find any solution.
Im using Docker version 27.1.1, build 6312585 .

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

4 participants