LogBlock Help! Remote MySQL Errors

I have been trying to install LogBlock to my server and use a remote database. I have tested it on other programs and it works fine. But Bukkit gives an error when it tries to connect to the remote database.

Error while fetching connection
java.sql.SQLException: null, message from server: "Host 'xxxxx.xxxxxxx.net' is not allowed to connect to this MySQL server"
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1116)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(DriverManager.java:620)
at java.sql.DriverManager.getConnection(DriverManager.java:200)
at de.diddiz.util.ConnectionPool$ConnectionService.getConnection(ConnectionPool.java:417)
at de.diddiz.util.ConnectionPool.connect(ConnectionPool.java:56)
at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:529)
at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:78)

I really need help badly, as there are currently no rollback plugins on my server. I've tried bigbrother but it has near the same issue.

 

For security purposes by default MySQL will not allow remote connections.

You can add your IP to the permissions list though.

Assuming your using something similar to cPanel go to Remote Mysql Database and add the IP you are connecting FROM

 

I have added my server IP to the list to accept connections through cPanel, it still does this. I will recheck it and re-add the IP again and restart my server.

I did add the IP again. I am doing this on the host that I am wanting to connect to.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

why risk losing connection on a remote host when you can install mysql locally?

 

When you add your IP do this:

xx.xxx.xxx.0/24

x's should be the first three sections of your IP.

Also, can you post your Config for connecting to your database please

 

I am not posting my config file as it has my remote host credentials in it Silly.

Also I can't get MySQL to work correctly on my server, if anyone can help me via TeamViewer please send me a Private Message with your Skype, or we can use my server's Mumble server to talk.

 

Go ahead and star out the specific details.

Also,I recommend checking this out:
http://forums.bukkit.org/threads/tu...r-automated-whitelisting-mysql-db-info.14835/

 

What information are you needing/asking for?

 

are you using linux or windows?

 

Also, are you using shared hosting? I cant remember if you need a Dedicated IP for remoteMySQL?

 

The server the game is hosted on is Linux. The remote SQL is on shared hosting, I've been with the company for over a year and a half. Also the IP on the shared host has never changed over a year period, so that isn't a problem.

- If someone would, please TeamViewer me and help setup MySQL w / the correct database for LogBlock I would really appreciate it.

 

Mike,

Im going to install this on my own server using my settings and I will get back to you with my results.

 

but before i help you install it, do you have a mysql connector in your servers folder, its usually in the lib folder.

 

I have the connector .jar file in my server root, the lib folder, and the logblock directory just to make sure. l

 

It installed fine on my server.

If you need TeamViewer assistance pm me.

 

* I got it fixed.
I obviously forgot to assign the user to the database, lol..
Sorry!