[Jillchang]

I rented a kimsufi box in europe, and I can't seem to get mysql working.
Did anyone have issues with mysql when getting a dedi from kimsufi?
Any fixes? I think it is just the kimsufi configurations when they install out of the box. I installed debian 8 from their panel.

The error on sourcemod I'm getting is : Failed to connect to database: [1129]: Host 'ns364299.ip-91-121-184.eu' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

I'm getting that on all my mysql plugins and I did try flushing the mysql but didn't fix the problem. None of my mysql plugins are working.
I checked /var/log/mysql/error.log and it seems like mysql boots ok.

170220  6:52:15 [Note] /usr/sbin/mysqld: Normal shutdown

170220  6:52:15 [Note] Event Scheduler: Purging the queue. 0 events
170220  6:52:15  InnoDB: Starting shutdown...
170220  6:52:16  InnoDB: Shutdown completed; log sequence number 1595685
170220  6:52:16 [Note] /usr/sbin/mysqld: Shutdown complete

170220  6:52:16 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170220  6:52:16 [Note] Plugin 'FEDERATED' is disabled.
170220  6:52:16 InnoDB: The InnoDB memory heap is disabled
170220  6:52:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170220  6:52:16 InnoDB: Compressed tables use zlib 1.2.8
170220  6:52:16 InnoDB: Using Linux native AIO
170220  6:52:16 InnoDB: Initializing buffer pool, size = 128.0M
170220  6:52:16 InnoDB: Completed initialization of buffer pool
170220  6:52:16 InnoDB: highest supported file format is Barracuda.
170220  6:52:16  InnoDB: Waiting for the background threads to start
170220  6:52:17 InnoDB: 5.5.54 started; log sequence number 1595685
170220  6:52:17 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170220  6:52:17 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170220  6:52:17 [Note] Server socket created on IP: '0.0.0.0'.
170220  6:52:17 [Note] Event Scheduler: Loaded 0 events
170220  6:52:17 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.54-0+deb8u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)

[Cooky]

They do have their own kernels and OS, yes. Try to install Linux yourself or change to a stock kernel.

[404UserNotFound]

I run Ubuntu 16.somethingorother on Kimsufi, two boxes, and MySQL works on both. The OS is 64-bit though, so I had to install 32-bit libs, and a full reboot of the VPS I *believe* is required for the OS and your servers to detect that MySQL is on and working.

This was a pain in the ass problem I always used to have when setting things up from scratch (due to various pain-in-the-ass reasons), but once I got into the habit of writing down all the usual apt-get's I need and running them, followed by a reboot, everything works beautifully.

[Jillchang]

Originally Posted by abrandnewday I run Ubuntu 16.somethingorother on Kimsufi, two boxes, and MySQL works on both. The OS is 64-bit though, so I had to install 32-bit libs, and a full reboot of the VPS I *believe* is required for the OS and your servers to detect that MySQL is on and working. This was a pain in the ass problem I always used to have when setting things up from scratch (due to various pain-in-the-ass reasons), but once I got into the habit of writing down all the usual apt-get's I need and running them, followed by a reboot, everything works beautifully.

Can you share the apt-gets for the mysql packages?
I can't seem to find it. I use these packages and it usually works, but on kimsufi it doesn't.

apt-get install libdbd-mysql-perl

To be honest, I don't think that package does anything for srcds xD. I just tried it a long time ago and it fixed one of my issues.

[404UserNotFound]

Taken from my bash history, in order I installed:

-snipping-

Keep in mind those were all run on Ubuntu 16.10 (finally checked my console and saw the version). If you're running a different Linux build, I don't know if using those installs will break shit. Give it a shot I guess!

I tried to eliminate any duplicate entries (due to me fucking things up whilst following "good VPS security practices" guides and making mistakes whilst installing things) but if there are any, I do apologize.

EDIT: I think MariaDB is the "SQL" package. I forget.

[Jillchang]

Thanks for that abrandnewday. I'll try it. I don't think it can break anything since it is just installing packages.
I'm running debian 7 or 8 (i have to check i forget xD)

*update
Seems like mariadb didn't work. I guess I'll have to try a different build xP.

[404UserNotFound]

google "debian <version> how to set up mysql"

[Jillchang]

Originally Posted by abrandnewday google "debian <version> how to set up mysql"

Yea, I tried that and installed mysql. Just gave up and went onto a different provider and it worked fine.

[404UserNotFound]

Originally Posted by Jillchang Yea, I tried that and installed mysql. Just gave up and went onto a different provider and it worked fine.

Odd. Not sure why it didn't work for you under Kimsufi. Definitely strange.

[Jillchang]

Yea, who knows. Maybe it was just debian. I tried both their debian 7 and 8.