MySQL attempts to connect to a completely different MySQL Server

Question

MySQL attempts to connect to a completely different MySQL Server

DieselJS opened this issue 5 years ago · 26 comments

DieselJS commented 5 years ago

Sooo, I enter my MySQL Details into the config.
It ends up looking like this:

data:

  # Define the address and port for the database.
  # - The standard DB engine port is used by default
  #   (MySQL: 3306, PostgreSQL: 5432, MongoDB: 27017)
  # - Specify as "host:port" if differs
  address: "69.super.kewl.ip"

  # The name of the database to store LuckPerms data in.
  # - This must be created already. Don't worry about this setting if you're using MongoDB.
  database: dieselg_perms

  # Credentials for the database.
  username: dieselg_lperms
  password: 'sup3raw3s0m3Pa55w0rd'

And when starting up it is connecting to this address:

static.58.36.202.116.clients.your-server.de

Sooooo yeah.

DieselJS commented 5 years ago

Lmao

DieselJS commented 5 years ago

Yes

DieselJS commented 5 years ago

How

Andre601 · Answer 1 · 2019-08-30T16:39:25.000Z

Is the port setup?
You have to provide one when it isn't the default

DieselJS · Answer 2 · 2019-08-30T16:39:50.000Z

Ye port is 3306

toxamin · Answer 3 · 2019-08-31T12:20:42.000Z

did you change the mode from h2 to mysql?

lucko · Answer 4 · 2019-09-06T17:59:54.000Z

That's normal - it's just resolving the hostname of the IP address.

Use https://ping.eu/nslookup/

static.58.36.202.116.clients.your-server.de resolves to 116.202.36.58 - is that your IP?! 😉

DieselJS · Answer 5 · 2019-09-06T18:03:00.000Z

No, it's not. My IP is 69.197.157.218. It doesn't try to connect to my MySQL server IP, it connects to this random thing.

lucko · Answer 6 · 2019-09-06T18:06:19.000Z

Well, no idea then - it's certainly not a random thing though, so there'll be a reason.

Could you show me the logs you're seeing which suggest it's connecting to a different address?

DieselJS · Answer 7 · 2019-09-06T18:08:47.000Z

Yes, give me a minute.

DieselJS · Answer 8 · 2019-09-06T18:10:11.000Z

> [20:09:17 INFO]: [LuckPerms] Enabling LuckPerms v4.4.29
> [20:09:17 INFO]: __
> [20:09:17 INFO]: | |__) LuckPerms v4.4.29
> [20:09:17 INFO]: |___ | Running on Bukkit - CraftBukkit
> [20:09:17 INFO]:
> [20:09:17 INFO]: [LuckPerms] Loading configuration...
> [20:09:17 INFO]: [LuckPerms] Loading storage provider... [MYSQL]
> [20:09:23 ERROR]: [LuckPerms] Failed to init storage dao
> [20:09:23 WARN]: java.sql.SQLTransientConnectionException: luckperms-hikari - Connection is not available, request timed out after 5002ms.
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:697)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
> [20:09:23 WARN]: at me.lucko.luckperms.common.storage.implementation.sql.connection.hikari.HikariConnectionFactory.getConnection(HikariConnectionFactory.java:131)
> [20:09:23 WARN]: at me.lucko.luckperms.common.storage.implementation.sql.SqlStorage.tableExists(SqlStorage.java:153)
> [20:09:23 WARN]: at me.lucko.luckperms.common.storage.implementation.sql.SqlStorage.init(SqlStorage.java:170)
> [20:09:23 WARN]: at me.lucko.luckperms.common.storage.Storage.init(Storage.java:110)
> [20:09:23 WARN]: at me.lucko.luckperms.common.storage.StorageFactory.getInstance(StorageFactory.java:88)
> [20:09:23 WARN]: at me.lucko.luckperms.common.plugin.AbstractLuckPermsPlugin.enable(AbstractLuckPermsPlugin.java:136)
> [20:09:23 WARN]: at me.lucko.luckperms.bukkit.LPBukkitBootstrap.onEnable(LPBukkitBootstrap.java:153)
> [20:09:23 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
> [20:09:23 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
> [20:09:23 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:403)
> [20:09:23 WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:381)
> [20:09:23 WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:330)
> [20:09:23 WARN]: at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:206)
> [20:09:23 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:545)
> [20:09:23 WARN]: at java.lang.Thread.run(Thread.java:748)
> [20:09:23 WARN]: Caused by: me.lucko.luckperms.lib.hikari.pool.PoolBase$ConnectionSetupException: java.sql.SQLException: Access denied for user 'dieselg_mcuser'@'static.58.36.202.116.clients.your-server.de' (using password: YES)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:501)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.access$100(HikariPool.java:71)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:727)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:713)
> [20:09:23 WARN]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> [20:09:23 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> [20:09:23 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> [20:09:23 WARN]: ... 1 more
> [20:09:23 WARN]: Caused by: java.sql.SQLException: Access denied for user 'dieselg_mcuser'@'static.58.36.202.116.clients.your-server.de' (using password: YES)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
> [20:09:23 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> [20:09:23 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> [20:09:23 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> [20:09:23 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.handleNewInstance(Util.java:425)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:428)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:136)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
> [20:09:23 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
> [20:09:23 WARN]: ... 7 more
> [20:09:23 INFO]: [LuckPerms] Loading messaging service... [SQL]
> [20:09:28 WARN]: java.lang.RuntimeException: java.sql.SQLTransientConnectionException: luckperms-hikari - Connection is not available, request timed out after 5000ms.
> [20:09:28 WARN]: at me.lucko.luckperms.common.messaging.sql.SqlMessenger.init(SqlMessenger.java:56)
> [20:09:28 WARN]: at me.lucko.luckperms.common.messaging.MessagingFactory$SqlMessengerProvider.obtain(MessagingFactory.java:132)
> [20:09:28 WARN]: at me.lucko.luckperms.common.messaging.LuckPermsMessagingService.<init>(LuckPermsMessagingService.java:72)
> [20:09:28 WARN]: at me.lucko.luckperms.common.messaging.MessagingFactory.getServiceFor(MessagingFactory.java:95)
> [20:09:28 WARN]: at me.lucko.luckperms.bukkit.messaging.BukkitMessagingFactory.getServiceFor(BukkitMessagingFactory.java:63)
> [20:09:28 WARN]: at me.lucko.luckperms.common.messaging.MessagingFactory.getInstance(MessagingFactory.java:73)
> [20:09:28 WARN]: at me.lucko.luckperms.common.plugin.AbstractLuckPermsPlugin.enable(AbstractLuckPermsPlugin.java:137)
> [20:09:28 WARN]: at me.lucko.luckperms.bukkit.LPBukkitBootstrap.onEnable(LPBukkitBootstrap.java:153)
> [20:09:28 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
> [20:09:28 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
> [20:09:28 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:403)
> [20:09:28 WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:381)
> [20:09:28 WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:330)
> [20:09:28 WARN]: at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:206)
> [20:09:28 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:545)
> [20:09:28 WARN]: at java.lang.Thread.run(Thread.java:748)
> [20:09:28 WARN]: Caused by: java.sql.SQLTransientConnectionException: luckperms-hikari - Connection is not available, request timed out after 5000ms.
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:697)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
> [20:09:28 WARN]: at me.lucko.luckperms.common.storage.implementation.sql.connection.hikari.HikariConnectionFactory.getConnection(HikariConnectionFactory.java:131)
> [20:09:28 WARN]: at me.lucko.luckperms.common.messaging.sql.SqlMessenger.getConnection(SqlMessenger.java:84)
> [20:09:28 WARN]: at me.lucko.luckperms.common.messaging.sql.AbstractSqlMessenger.init(AbstractSqlMessenger.java:55)
> [20:09:28 WARN]: at me.lucko.luckperms.common.messaging.sql.SqlMessenger.init(SqlMessenger.java:54)
> [20:09:28 WARN]: ... 15 more
> [20:09:28 WARN]: Caused by: me.lucko.luckperms.lib.hikari.pool.PoolBase$ConnectionSetupException: java.sql.SQLException: Access denied for user 'dieselg_mcuser'@'static.58.36.202.116.clients.your-server.de' (using password: YES)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:501)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.access$100(HikariPool.java:71)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:727)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:713)
> [20:09:28 WARN]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> [20:09:28 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> [20:09:28 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> [20:09:28 WARN]: ... 1 more
> [20:09:28 WARN]: Caused by: java.sql.SQLException: Access denied for user 'dieselg_mcuser'@'static.58.36.202.116.clients.your-server.de' (using password: YES)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
> [20:09:28 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> [20:09:28 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> [20:09:28 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> [20:09:28 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.handleNewInstance(Util.java:425)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:428)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:136)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
> [20:09:28 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
> [20:09:28 WARN]: ... 7 more
> [20:09:28 WARN]: [LuckPerms] Messaging service 'sql' not recognised.
> [20:09:28 INFO]: [LuckPerms] Loading internal permission managers...
> [20:09:28 INFO]: [LuckPerms] Performing initial data load...
> [20:09:33 WARN]: java.util.concurrent.CompletionException: java.sql.SQLTransientConnectionException: luckperms-hikari - Connection is not available, request timed out after 5000ms.
> [20:09:33 WARN]: at me.lucko.luckperms.common.storage.Storage.lambda$makeFuture$1(Storage.java:99)
> [20:09:33 WARN]: at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1626)
> [20:09:33 WARN]: at me.lucko.luckperms.common.plugin.scheduler.AbstractJavaScheduler$ErrorReportingRunnable.run(AbstractJavaScheduler.java:106)
> [20:09:33 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> [20:09:33 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> [20:09:33 WARN]: at java.lang.Thread.run(Thread.java:748)
> [20:09:33 WARN]: Caused by: java.sql.SQLTransientConnectionException: luckperms-hikari - Connection is not available, request timed out after 5000ms.
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:697)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
> [20:09:33 WARN]: at me.lucko.luckperms.common.storage.implementation.sql.connection.hikari.HikariConnectionFactory.getConnection(HikariConnectionFactory.java:131)
> [20:09:33 WARN]: at me.lucko.luckperms.common.storage.implementation.sql.SqlStorage.loadAllGroups(SqlStorage.java:646)
> [20:09:33 WARN]: at me.lucko.luckperms.common.storage.Storage.lambda$loadAllGroups$10(Storage.java:190)
> [20:09:33 WARN]: at me.lucko.luckperms.common.storage.Storage.lambda$makeFuture$1(Storage.java:94)
> [20:09:33 WARN]: ... 5 more
> [20:09:33 WARN]: Caused by: me.lucko.luckperms.lib.hikari.pool.PoolBase$ConnectionSetupException: java.sql.SQLException: Access denied for user 'dieselg_mcuser'@'static.58.36.202.116.clients.your-server.de' (using password: YES)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:501)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.access$100(HikariPool.java:71)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:727)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:713)
> [20:09:33 WARN]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> [20:09:33 WARN]: ... 3 more
> [20:09:33 WARN]: Caused by: java.sql.SQLException: Access denied for user 'dieselg_mcuser'@'static.58.36.202.116.clients.your-server.de' (using password: YES)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
> [20:09:33 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> [20:09:33 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> [20:09:33 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> [20:09:33 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.handleNewInstance(Util.java:425)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:428)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:136)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
> [20:09:33 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
> [20:09:33 WARN]: ... 7 more
> [20:09:33 INFO]: [LuckPerms] Successfully enabled. (took 16295ms)
``` This is the latest one.

lucko · Answer 9 · 2019-09-06T18:13:52.000Z

Definitely got the correct value in the config?

Only thing I can think of is that the nameservers/DNS service your machine is using an out of date entry for the IP?

Since this is an issue with an external library (Hikari) and not LuckPerms, there's not much more I can offer in the way of help.

DieselJS · Answer 10 · 2019-09-06T18:18:26.000Z

Correct values definitely, as some servers do start with the MySQL one time, then don't another. I'll check with my friend who maintains my server. Thanks though.

BrainStone · Answer 11 · 2019-09-06T18:20:44.000Z

What I'd recommend is that you run dig <hostname> from the linux command line (replace <hostname> with the hostname of the MySQL server you've configured in the config).
That should tell you where it tries to connect.

DieselJS · Answer 12 · 2019-09-06T18:24:13.000Z

I tried dig from a Linux command line, it said the command wasn't found. Linux isn't really my thing so I don't understand how they work.

BrainStone · Answer 13 · 2019-09-06T18:29:18.000Z

Then the software is not installed. Try ping <hostname> -c 4 Should still give you the IP

DieselJS · Answer 14 · 2019-09-06T18:30:38.000Z

69.197.157.218, and that is the IP in the config.

BrainStone · Answer 15 · 2019-09-06T18:49:12.000Z

Looking at the log you're getting Access Denied erros. This seems to be on the MySQL or the user config.

Make sure the user is allowed to connect from where you are connecting.

DieselJS · Answer 16 · 2019-09-06T18:50:31.000Z

It's Access Denied because it's trying to connect to a server that isn't mine and doesn't have the account on it.

BrainStone · Answer 17 · 2019-09-06T18:51:08.000Z

What makes you think so?

DieselJS · Answer 18 · 2019-09-06T18:51:48.000Z

static.58.36.202.116.clients.your-server.de is not ME.

BrainStone · Answer 19 · 2019-09-06T18:52:46.000Z

This is not the server you are connecting to. This is the server you are connecting from

BrainStone · Answer 20 · 2019-09-06T18:55:00.000Z

The static.58.36.202.116.clients.your-server.de you see in the log is the MySQL client. Aka you. Not the the server.
So you are connecting to the right server. But it rejects your login attempts.

DieselJS · Answer 21 · 2019-09-06T18:57:42.000Z

Hm Ok. This seems random. Because I have now 3 servers that successfully connect to the database the first time I've verified the settings etc. There is one server now that just refuses to. I'll have a look at it now.

DieselJS · Answer 22 · 2019-09-06T19:01:37.000Z

Well, that sure is weird. I copied a working section on the MySQL settings to the broken one and now it connects..? The copy-paste changed nothing in the config I swear. They are working for now, Thanks.

BrainStone · Answer 23 · 2019-09-06T19:03:38.000Z

Most likely a whitespace issue then.

Share to