Database connection problem. SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

Web page cannot connect says “database connection problem”.

When I go to the maintenance.php page, I get this error:
Database connection problem. SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

I did find in Services.msc that MySQL57 wasn’t running (set to Automatic) even after a reboot. I started it. After a long time it did start and everything seems to be operating normally. In Event Viewer I see events indicating MySQL recovered from a crash.

I found addition events that indicate the hard drive was full. Is there a maintenance script I can run to clean up disk space being used by the database?

Thanks!

Have you been able to determine what SQL files are large?

Are you running the Xibo maintenance routine regularly?

There are typically 2 SQL tables that can get large - log and stat, you can truncate them both to free up space inside the MySQL database. That won’t necessarily help with your disk space usage though - try it and see.