Solved MySQL connection?

[FlameikTV]

Hi,
is there in Skript still feature to connect with Skript to the MySQL database?
I tried everything that I found on Google but nothing of that works for me.

Please, if you know how to do it - please reply here

 

[Minecoll_YT]

https://www.spigotmc.org/resources/skript-db-updated.89363/

 

[FlameikTV]

Yes, I tried this one before, but it doesn't work for me (or maybe I've just used that wrong)


I've used before I wrote this topic:

• Original one with $db.
• skript-db (orginal and also that updated one).
• Skellet.
• SkQuery.

But non of them works :c

 

[Minecoll_YT]

any error messages when using skript-db?

 

[FlameikTV]

I am sorry for late reply, here is the error:

Spoiler: Console error after reload of the Skript

17:52:48[ERROR] [Skript] Skript's 'ExpressionInfo' class could not be resolved.
17:52:48[INFO] [com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Starting...
17:53:19[ERROR] [com.zaxxer.hikari.pool.HikariPool] HikariPool-1 - Exception during pool initialization.
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[server.jar:git-Paper-349]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[server.jar:git-Paper-349]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833) ~[server.jar:git-Paper-349]
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453) ~[server.jar:git-Paper-349]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[server.jar:git-Paper-349]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[server.jar:git-Paper-349]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121) ~[skript-db.jar:?]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[skript-db.jar:?]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[skript-db.jar:?]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[skript-db.jar:?]
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[skript-db.jar:?]
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[skript-db.jar:?]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[skript-db.jar:?]
at com.btk5h.skriptdb.skript.EffExecuteStatement.executeStatement(EffExecuteStatement.java:224) ~[skript-db.jar:?]
at com.btk5h.skriptdb.skript.EffExecuteStatement.lambda$execute$1(EffExecuteStatement.java:91) ~[skript-db.jar:?]
at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[?:?]
at java.lang.Thread.run(Unknown Source) ~[?:?]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:?]
at java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source) ~[?:?]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:?]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[server.jar:git-Paper-349]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[server.jar:git-Paper-349]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[server.jar:git-Paper-349]
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[server.jar:git-Paper-349]
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89) ~[server.jar:git-Paper-349]
at com.mysql.cj.NativeSession.connect(NativeSession.java:144) ~[server.jar:git-Paper-349]
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953) ~[server.jar:git-Paper-349]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[server.jar:git-Paper-349]
... 16 more
Caused by: java.net.SocketTimeoutException: Connect timed out
at sun.nio.ch.NioSocketImpl.timedFinishConnect(Unknown Source) ~[?:?]
at sun.nio.ch.NioSocketImpl.connect(Unknown Source) ~[?:?]
at java.net.SocksSocketImpl.connect(Unknown Source) ~[?:?]
at java.net.Socket.connect(Unknown Source) ~[?:?]
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155) ~[server.jar:git-Paper-349]
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63) ~[server.jar:git-Paper-349]
at com.mysql.cj.NativeSession.connect(NativeSession.java:144) ~[server.jar:git-Paper-349]
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953) ~[server.jar:git-Paper-349]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[server.jar:git-Paper-349]
... 16 more
17:53:19[INFO] [com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Starting...

[doublepost=1635179682,1635177411][/doublepost]Ah, its now working - I am using that skript-db.
There was problem with database hosting that I used, I don't know exactly why but nevermind, its fixed now

Thanks a lot for your help! <3