1. Welcome to skUnity!

    Welcome to skUnity! This is a forum where members of the Skript community can communicate and interact. Skript Resource Creators can post their Resources for all to see and use.

    If you haven't done so already, feel free to join our official Discord server to expand your level of interaction with the comminuty!

    Now, what are you waiting for? Join the community now!

  2. LOOKING FOR A VERSION OF SKRIPT?

    You can always check out our Wiki for downloads and any other information about Skript!

Dismiss Notice
This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Solved MySQL connection?

Discussion in 'Skript' started by FlameikTV, Oct 20, 2021.

  1. FlameikTV

    FlameikTV Member

    Joined:
    May 22, 2020
    Messages:
    19
    Likes Received:
    2
    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. :emoji_cry:

    Please, if you know how to do it - please reply here :emoji_pray::emoji_pray:
     
  2. Best Answer:
    Post #2 by Minecoll_YT, Oct 20, 2021
  3. Minecoll_YT

    Supporter Forums Helper

    Joined:
    Dec 2, 2018
    Messages:
    597
    Likes Received:
    37
    • Agree Agree x 1
  4. FlameikTV

    FlameikTV Member

    Joined:
    May 22, 2020
    Messages:
    19
    Likes Received:
    2
    Yes, I tried this one before, but it doesn't work for me (or maybe I've just used that wrong) :emoji_frowning:


    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
     
  5. Minecoll_YT

    Supporter Forums Helper

    Joined:
    Dec 2, 2018
    Messages:
    597
    Likes Received:
    37
    any error messages when using skript-db?
     
  6. FlameikTV

    FlameikTV Member

    Joined:
    May 22, 2020
    Messages:
    19
    Likes Received:
    2
    I am sorry for late reply, here is the error:
    Code (Text):
    1. 17:52:48[ERROR] [Skript] Skript's 'ExpressionInfo' class could not be resolved.
    2. 17:52:48[INFO] [com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Starting...
    3. 17:53:19[ERROR] [com.zaxxer.hikari.pool.HikariPool] HikariPool-1 - Exception during pool initialization.
    4. com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
    5. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    6. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[server.jar:git-Paper-349]
    7. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[server.jar:git-Paper-349]
    8. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833) ~[server.jar:git-Paper-349]
    9. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453) ~[server.jar:git-Paper-349]
    10. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[server.jar:git-Paper-349]
    11. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[server.jar:git-Paper-349]
    12. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121) ~[skript-db.jar:?]
    13. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[skript-db.jar:?]
    14. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[skript-db.jar:?]
    15. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[skript-db.jar:?]
    16. at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[skript-db.jar:?]
    17. at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[skript-db.jar:?]
    18. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[skript-db.jar:?]
    19. at com.btk5h.skriptdb.skript.EffExecuteStatement.executeStatement(EffExecuteStatement.java:224) ~[skript-db.jar:?]
    20. at com.btk5h.skriptdb.skript.EffExecuteStatement.lambda$execute$1(EffExecuteStatement.java:91) ~[skript-db.jar:?]
    21. at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) ~[?:?]
    22. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[?:?]
    23. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[?:?]
    24. at java.lang.Thread.run(Unknown Source) ~[?:?]
    25. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
    26. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    27. at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
    28. at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:?]
    29. at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:?]
    30. at java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source) ~[?:?]
    31. at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:?]
    32. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[server.jar:git-Paper-349]
    33. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[server.jar:git-Paper-349]
    34. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[server.jar:git-Paper-349]
    35. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[server.jar:git-Paper-349]
    36. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89) ~[server.jar:git-Paper-349]
    37. at com.mysql.cj.NativeSession.connect(NativeSession.java:144) ~[server.jar:git-Paper-349]
    38. at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953) ~[server.jar:git-Paper-349]
    39. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[server.jar:git-Paper-349]
    40. ... 16 more
    41. Caused by: java.net.SocketTimeoutException: Connect timed out
    42. at sun.nio.ch.NioSocketImpl.timedFinishConnect(Unknown Source) ~[?:?]
    43. at sun.nio.ch.NioSocketImpl.connect(Unknown Source) ~[?:?]
    44. at java.net.SocksSocketImpl.connect(Unknown Source) ~[?:?]
    45. at java.net.Socket.connect(Unknown Source) ~[?:?]
    46. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155) ~[server.jar:git-Paper-349]
    47. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63) ~[server.jar:git-Paper-349]
    48. at com.mysql.cj.NativeSession.connect(NativeSession.java:144) ~[server.jar:git-Paper-349]
    49. at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953) ~[server.jar:git-Paper-349]
    50. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[server.jar:git-Paper-349]
    51. ... 16 more
    52. 17:53:19[INFO] [com.zaxxer.hikari.HikariDataSource] HikariPool-1 - Starting...
    --- Double Post Merged, Oct 25, 2021, Original Post Date: Oct 25, 2021 ---
    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 :emoji_grinning:

    Thanks a lot for your help! <3
     
    • Like Like x 1

Share This Page

Loading...