Litebans MySQL help

[DarkBoomba]

Hey,

I'm having a problem with setting up a MySQL database for Litebans.

Info:

- MySQL is hosted on GoDaddy
- Server is hosted on OVH
- mc version 1.11.2
- Newest Litebans version

Problem:

Litebans can't connect to the database. It gives this error.

Spoiler: Error

[22:10:45 INFO]: [LiteBans] Loading SQL driver: mysql (com.mysql.jdbc.Driver)
[22:10:45 INFO]: [LiteBans] Connecting to database...
[22:11:20 ERROR]: [LiteBans] Failed to connect to [jdbc:mysql://160.153.129.232:3306/DowsingRod] using mysql driver.
[22:11:20 ERROR]: [LiteBans] Error: Exception during pool initialization: litebans-pool - Connection is not available, request timed out after 30000ms.
[22:11:20 ERROR]: [LiteBans] Please configure: plugins/LiteBans/config.yml
[22:11:20 ERROR]: [LiteBans] Connection failed.
[22:11:20 INFO]: LiteBans reloaded. Failed to connect to database.

What I did:

- I created a database for Litebans and a user that has full access to it
- I configured Litebans to connect to that exact database with that user
- I've allowed the OVH server's IP to access MySQL on GoDaddy's end

I created a local test server with Litebans and it can connect to the database with no problems. I am a 100% sure that all the settings are the same.

Does anyone knows what I could do about this?

Thanks!

- DarkBoomba

 

[Jack]

Hey,

I'm having a problem with setting up a MySQL database for Litebans.

Info:

- MySQL is hosted on GoDaddy
- Server is hosted on OVH
- mc version 1.11.2
- Newest Litebans version

Problem:

Litebans can't connect to the database. It gives this error.

Spoiler: Error

[22:10:45 INFO]: [LiteBans] Loading SQL driver: mysql (com.mysql.jdbc.Driver)
[22:10:45 INFO]: [LiteBans] Connecting to database...
[22:11:20 ERROR]: [LiteBans] Failed to connect to [jdbc:mysql://160.153.129.232:3306/DowsingRod] using mysql driver.
[22:11:20 ERROR]: [LiteBans] Error: Exception during pool initialization: litebans-pool - Connection is not available, request timed out after 30000ms.
[22:11:20 ERROR]: [LiteBans] Please configure: plugins/LiteBans/config.yml
[22:11:20 ERROR]: [LiteBans] Connection failed.
[22:11:20 INFO]: LiteBans reloaded. Failed to connect to database.

What I did:

- I created a database for Litebans and a user that has full access to it
- I configured Litebans to connect to that exact database with that user
- I've allowed the OVH server's IP to access MySQL on GoDaddy's end

I created a local test server with Litebans and it can connect to the database with no problems. I am a 100% sure that all the settings are the same.

Does anyone knows what I could do about this?

Thanks!

- DarkBoomba

Make sure MySQL user is setup to allow remote access too.

 

[fts]

Hosting SQL locally is better, it prevents problems like this. Like Jack said you might not have remote access to the database enabled or the database could be just flat out disabled.