点卷插件数据库与变量的问题 - 联机问答

浮尔魔司Ya

变量刚开始会显示然后有几个玩家进来就不显示了报错如下

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications
[06:23:33] [Craft Scheduler Thread - 202/ERROR] [org.black_ixx.playerpoints.PlayerPoints]: [PlayerPoints] Could not create getter statement.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 553,674 milliseconds ago. The last packet sent successfully to the server was 553,674 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_251]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_251]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_251]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_251]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[Util.class:5.1.45]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[SQLError.class:5.1.45]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3746) ~[MysqlIO.class:5.1.45]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2509) ~[MysqlIO.class:5.1.45]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) ~[MysqlIO.class:5.1.45]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) ~[ConnectionImpl.class:5.1.45]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[PreparedStatement.class:5.1.45]
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197) ~[PreparedStatement.class:5.1.45]
at lib.PatPeter.SQLibrary.Database.query(Database.java:261) ~[?:?]
at lib.PatPeter.SQLibrary.Database.query(Database.java:278) ~[?:?]
at org.black_ixx.playerpoints.storage.models.MySQLStorage.getPoints(MySQLStorage.java:87) ~[?:?]
at org.black_ixx.playerpoints.storage.StorageHandler.getPoints(StorageHandler.java:39) ~[?:?]
at org.black_ixx.playerpoints.PlayerPointsAPI.look(PlayerPointsAPI.java:102) ~[?:?]
at com.extendedclip.papi.expansion.playerpoints.PlayerPointsExpansion.getPoints(PlayerPointsExpansion.java:73) ~[?:?]
at com.extendedclip.papi.expansion.playerpoints.PlayerPointsExpansion.onPlaceholderRequest(PlayerPointsExpansion.java:65) ~[?:?]
at me.clip.placeholderapi.PlaceholderHook.onRequest(PlaceholderHook.java:38) ~[?:?]
at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:237) ~[?:?]
at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:377) ~[?:?]
at \?.?.?.MiaoBoard.?ˊ.?(Replace.java:41) ~[?:?]
at \?.?.?.MiaoBoard.?ˊ.?(Replace.java:35) ~[?:?]
at \?.?.?.MiaoBoard.?ˊ.?(Replace.java:29) ~[?:?]
at \?.?.?.MiaoBoard.??.onBodyUpdate(SelfListener.java:37) ~[?:?]
at catserver.server.executor.asm.generated.GeneratedEventExecutor196.execute(Unknown Source) ~[?:?]
at org.bukkit.plugin.EventExecutor$2.execute(EventExecutor.java:67) ~[EventExecutor$2.class:git-CatServer-1.12.2-ae86f3c]
at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[RegisteredListener.class:git-CatServer-1.12.2-ae86f3c]
at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:503) ~[SimplePluginManager.class:git-CatServer-1.12.2-ae86f3c]
at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:485) ~[SimplePluginManager.class:git-CatServer-1.12.2-ae86f3c]
at \?.?.?.MiaoBoard.??.?(SidebarBoard.java:43) ~[?:?]
at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:76) [CraftTask.class:git-CatServer-1.12.2-ae86f3c]
at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52) [CraftAsyncTask.class:git-CatServer-1.12.2-ae86f3c]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_251]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_251]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_251]
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:1.8.0_251]
at java.net.SocketOutputStream.socketWrite(Unknown Source) ~[?:1.8.0_251]
at java.net.SocketOutputStream.write(Unknown Source) ~[?:1.8.0_251]
at java.io.BufferedOutputStream.flushBuffer(Unknown Source) ~[?:1.8.0_251]
at java.io.BufferedOutputStream.flush(Unknown Source) ~[?:1.8.0_251]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3728) ~[MysqlIO.class:5.1.45]
... 30 more

浮尔魔司Ya

变量是正确的点卷也连了数据库由于是1.12 所以不能更新版本对接着充值插件想问一下这个如何解决？

hapijun2

关于这个问题，我洗不明白，来个高手回答一下

hapijun2

变量是函数变量？？

极光酋长

本帖最后由极光酋长于 2022-5-28 09:46 编辑

[PlayerPoints] Could not create getter statement.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
......

实际上数据库那边给插件标记成连接超时，并拒绝了请求。
网上有一些解决办法，可以参考一下：https://www.pudn.com/news/628f8317bf399b7f351e69eb.html
https://blog.csdn.net/qq_38904700/article/details/79514791

另外，如果你的数据库需要强制SSL连接的话，建议在插件配置文件里吧use-ssl设置为true；但如果你第一次连接没打开也能连上，可能就没有这个SSL的问题

慕由

额，点券启用数据库要前置啊，下载前置了吗

酷泽Ckupe

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications

初步判定是PlayerPoints数据库连接时开启了SSL连接，请找到PlayerPoints config下述内容

  # If the database connection should use SSL
  # You should enable this if your database supports SSL
  # Default: false
  use-ssl: true

use-ssl改为false

下一页最后一页