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

1

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!

2

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.