Войти или зарегистрироваться
  • Вы находитесь в сообществе Rubukkit. Мы - администраторы серверов Minecraft, разрабатываем собственные плагины и переводим на различные языки плагины наших коллег из других стран.

Плагин [ADMN] ShoppingCart Reloaded 1.2 - плагин для выдачи предметов из БД [1.4.7 - 1.7.2R-0.3]

У меня тоже подобная проблема. Абсолютно все настройки введены правильно. В логах плагин пытается подключиться к бд по адресу моего сервера, хотя в настройках прописан хост хостинга
 
Возможно у вас на хостинге закрыт внешний доступ к бд.
 
Возможно у вас на хостинге закрыт внешний доступ к бд.
Подключаюсь на своем компе

Что в логе пишет?

<логи>
[18:00:27] [Server thread/WARN]: [ShoppingCartReloaded] Error setting up DB
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_66]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_66]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_66]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_66]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_66]
at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_66]
at com.j256.ormlite.jdbc.JdbcConnectionSource.makeConnection(JdbcConnectionSource.java:252) ~[ormlite-jdbc-4.48.jar:?]
at com.j256.ormlite.jdbc.JdbcPooledConnectionSource.getReadWriteConnection(JdbcPooledConnectionSource.java:136) ~[ormlite-jdbc-4.48.jar:?]
at com.j256.ormlite.jdbc.JdbcPooledConnectionSource.getReadOnlyConnection(JdbcPooledConnectionSource.java:111) ~[ormlite-jdbc-4.48.jar:?]
at me.limito.bukkit.shopcart.database.CartItemInfoDao.tableExists(CartItemInfoDao.scala:34) ~[shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.database.CartItemInfoDao.setupTableAndStatements(CartItemInfoDao.scala:29) ~[shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.ShoppingCartReloaded.initDatabase(ShoppingCartReloaded.scala:101) [shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.ShoppingCartReloaded.reload(ShoppingCartReloaded.scala:48) [shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.ShoppingCartReloaded.onEnable(ShoppingCartReloaded.scala:29) [shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.PluginPreloader.onEnable(PluginPreloader.java:67) [shopping-cart-reloaded-1.2u9.jar:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:250) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:350) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:390) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at org.bukkit.craftbukkit.v1_7_R1.CraftServer.loadPlugin(CraftServer.java:460) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at org.bukkit.craftbukkit.v1_7_R1.CraftServer.enablePlugins(CraftServer.java:380) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.MinecraftServer.m(MinecraftServer.java:348) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.MinecraftServer.g(MinecraftServer.java:325) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.MinecraftServer.a(MinecraftServer.java:281) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.DedicatedServer.init(DedicatedServer.java:186) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.MinecraftServer.run(MinecraftServer.java:437) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.ThreadServerApplication.run(SourceFile:617) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
[18:00:27] [Server thread/INFO]: [ShoppingCartReloaded] PowerNBT not detected
</логи>
 
Подключаюсь на своем компе



<логи>
[18:00:27] [Server thread/WARN]: [ShoppingCartReloaded] Error setting up DB
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_66]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_66]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_66]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_66]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_66]
at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_66]
at com.j256.ormlite.jdbc.JdbcConnectionSource.makeConnection(JdbcConnectionSource.java:252) ~[ormlite-jdbc-4.48.jar:?]
at com.j256.ormlite.jdbc.JdbcPooledConnectionSource.getReadWriteConnection(JdbcPooledConnectionSource.java:136) ~[ormlite-jdbc-4.48.jar:?]
at com.j256.ormlite.jdbc.JdbcPooledConnectionSource.getReadOnlyConnection(JdbcPooledConnectionSource.java:111) ~[ormlite-jdbc-4.48.jar:?]
at me.limito.bukkit.shopcart.database.CartItemInfoDao.tableExists(CartItemInfoDao.scala:34) ~[shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.database.CartItemInfoDao.setupTableAndStatements(CartItemInfoDao.scala:29) ~[shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.ShoppingCartReloaded.initDatabase(ShoppingCartReloaded.scala:101) [shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.ShoppingCartReloaded.reload(ShoppingCartReloaded.scala:48) [shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.ShoppingCartReloaded.onEnable(ShoppingCartReloaded.scala:29) [shopping-cart-reloaded-1.2u9.jar:?]
at me.limito.bukkit.shopcart.PluginPreloader.onEnable(PluginPreloader.java:67) [shopping-cart-reloaded-1.2u9.jar:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:250) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:350) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:390) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at org.bukkit.craftbukkit.v1_7_R1.CraftServer.loadPlugin(CraftServer.java:460) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at org.bukkit.craftbukkit.v1_7_R1.CraftServer.enablePlugins(CraftServer.java:380) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.MinecraftServer.m(MinecraftServer.java:348) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.MinecraftServer.g(MinecraftServer.java:325) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.MinecraftServer.a(MinecraftServer.java:281) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.DedicatedServer.init(DedicatedServer.java:186) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.MinecraftServer.run(MinecraftServer.java:437) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
at net.minecraft.server.v1_7_R1.ThreadServerApplication.run(SourceFile:617) [spigot.jar:git-Spigot-1.7.2-R0.3-122-gb58e277]
[18:00:27] [Server thread/INFO]: [ShoppingCartReloaded] PowerNBT not detected
</логи>

Пользователю отказано в доступе
 
А как его настроить на группы,что бы выдовал?
 
В общем, установил плагин, прописал конфиги, доступ к БД открыл, но плагин не хочет подключатся к БД.

вот логи:
[17:15:27 ERROR]: [ShoppingCart] Couldn't connect to database
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai
lure

The last packet sent successfully to the server was 0 milliseconds ago. The driv
er has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
~[?:1.8.0_66]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
~[?:1.8.0_66]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce) ~[?:1.8.0_66]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_6
6]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[Spigot.jar:git
-Spigot-5f38d38-18fbb24]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
116) ~[Spigot.jar:git-Spigot-5f38d38-18fbb24]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) ~[Spigot.jar:git-Spig
ot-5f38d38-18fbb24]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~
[Spigot.jar:git-Spigot-5f38d38-18fbb24]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
371) ~[Spigot.jar:git-Spigot-5f38d38-18fbb24]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~
[Spigot.jar:git-Spigot-5f38d38-18fbb24]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[Spigo
t.jar:git-Spigot-5f38d38-18fbb24]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[Spig
ot.jar:git-Spigot-5f38d38-18fbb24]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
~[?:1.8.0_66]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
~[?:1.8.0_66]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce) ~[?:1.8.0_66]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_6
6]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[Spigot.jar:git
-Spigot-5f38d38-18fbb24]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[
Spigot.jar:git-Spigot-5f38d38-18fbb24]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:305) ~[Spigot.jar:git-Spigot-5f38d38-18fbb24]
at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_66]
at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_66]
at net.rubukkit.limito.shoppingcart.service.DatabaseConnection.init(Data
baseConnection.java:42) [ShoppingCart-1.5.4-permfix.jar:?]
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.initDBConnection(
ShoppingCartPlugin.java:166) [ShoppingCart-1.5.4-permfix.jar:?]
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.onEnable(Shopping
CartPlugin.java:56) [ShoppingCart-1.5.4-permfix.jar:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) [Sp
igot.jar:git-Spigot-5f38d38-18fbb24]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:340) [Spigot.jar:git-Spigot-5f38d38-18fbb24]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:405) [Spigot.jar:git-Spigot-5f38d38-18fbb24]
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.jav
a:357) [Spigot.jar:git-Spigot-5f38d38-18fbb24]
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.
java:317) [Spigot.jar:git-Spigot-5f38d38-18fbb24]
at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:4
14) [Spigot.jar:git-Spigot-5f38d38-18fbb24]
at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:3
78) [Spigot.jar:git-Spigot-5f38d38-18fbb24]
at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:3
33) [Spigot.jar:git-Spigot-5f38d38-18fbb24]
at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.jav
a:263) [Spigot.jar:git-Spigot-5f38d38-18fbb24]
at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java
:525) [Spigot.jar:git-Spigot-5f38d38-18fbb24]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_66]
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method) ~[?:1.8.0_6
6]
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source) ~[?:1
.8.0_66]
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) ~[?:1.8.0_
66]
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) ~[?
:1.8.0_66]
at java.net.AbstractPlainSocketImpl.connect(Unknown Source) ~[?:1.8.0_66
]
at java.net.PlainSocketImpl.connect(Unknown Source) ~[?:1.8.0_66]
at java.net.SocksSocketImpl.connect(Unknown Source) ~[?:1.8.0_66]
at java.net.Socket.connect(Unknown Source) ~[?:1.8.0_66]
at java.net.Socket.connect(Unknown Source) ~[?:1.8.0_66]
at java.net.Socket.<init>(Unknown Source) ~[?:1.8.0_66]
at java.net.Socket.<init>(Unknown Source) ~[?:1.8.0_66]
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
va:254) ~[Spigot.jar:git-Spigot-5f38d38-18fbb24]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ~[Spigot.jar:git-Spig
ot-5f38d38-18fbb24]
... 28 more
 
Прошу реализовать работу с материалами блоков.
 
Обновите этот плагин до 1.8. Он слишком хорош, чтобы пропасть
 
группы выдает только для мира world, как исправить? что бы группы работали и в аду и в эндер мире
 
Оживить его что ли... Ну блин времени нет.
 
Оживить его что ли... Ну блин времени нет.
Если добавите поддержку material name и добавите функцию покупку команд, будет великолепно. 500 рублей могу дать для благого дела, думаю кто нибудь еще тоже скинет
 

Поделиться этой страницей

Назад
Верх