I have a root server with Linux, but there has been a big problem since the day before yesterday.
On the root server runs a Minecraft network with a MySQL database.
Suddenly the server started to lodge and a subserver of Minecraft crashed.
I have restarted everything, but since then there's no connection to the database (MySQL).
When I enter: http://IP-ADRESSE-VERSTECKT/phpmyadmin, I usually got into the phpmyadmin interface, but now suddenly it says:
--------------------------
The website is not accessible
IP ADDRESS HID denied the connection. Try the following:
Check connection
http://chrome-error://chromewebdata/#buttons
ERR_CONNECTION_REFUSED
--------------------------
EDIT:
I have phpMyAdmin and co. Updated on the server, now suddenly there's:
Error during session start; please check your PHP and / or webserver log file and configure your PHP installation properly. So that cookies are enabled in your browser.
session_write_close (): write failed: No space left on device (28)
session_write_close (): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/ var / lib / php / sessions)
--------------------------
I have censored the IP address here, which of course is the placeholder for my IP address.
Make sure that Apache2 / NGINX (depends on what you use), mariaDB / mySQL (depending on what you use), phpMyAdmin are started.
If you can't start them (and they're not already started), look at the logs, maybe there's a bug in them.
Now it says:
Error during session start; please check your PHP and / or webserver log file and configure your PHP installation properly. So that cookies are enabled in your browser.
session_write_close (): write failed: No space left on device (28)
session_write_close (): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/ var / lib / php / sessions)
I interpret "No space left on device" as if you had no more space on the server.
Log in via Console and give
df.
As you can see how full the drives are. I suspect your drives are full because you as Errormeldung
session_write_close (): write failed: No space left on device (28)
session_write_close (): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/ var / lib / php / sessions)
got back.
If there's no room left, then clean up!
No space left on device
Check with the df -h command how much memory is allocated. It seems. As if the hard drive is full.
Tip: A good tool for showing used space is ncdu.
Otherwise, a few notes:
If I:
http://IP-ADRESSE-VERSTECKT/phpmyadmin
Security through Obscurity is a bad approach. Others can see the IP. Namely, those who use the server.
I have phpMyAdmin and co. Updated on the server
Please do not. Please stop using phpMyAdmin. Why do you just clap a web server on the machine just to access the database. Just use an SSH tunnel and an appropriate client, like the MySQL Workbench. The SSH tunnel is bombproof. Your phpMyAdmin and web server do not mind.
Many Thanks!
Strato support told me to get a hardware test done. (Takes 6 hours and is too much time for me)
I will change the provider and implement your proposal with the MySQL Workbench.
