Плагин [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
</логи>

 

Пользователю отказано в доступе

 

Проблему понял, + в репу

 

А как его настроить на группы,что бы выдовал?

 

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

вот логи:

Спойлер

[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

 

Прошу реализовать работу с материалами блоков.

 

Всмысле не добавляются? Командой /cart put или что?

 

Доброго вечера! На 1.7.10 идем?

 

Все норм работает.

 

Да, все работает. НО не поддерживаются материалы, только id.

 

Обновите этот плагин до 1.8. Он слишком хорош, чтобы пропасть

 

И лучше бы добавить поддержку материалов!

 

группы выдает только для мира world, как исправить? что бы группы работали и в аду и в эндер мире

 

А можно выдавать регионы на время(аренда)?

 

нет

 

Оживить его что ли... Ну блин времени нет.

 

Если будет время, сделай доброе дело

 

Если добавите поддержку material name и добавите функцию покупку команд, будет великолепно. 500 рублей могу дать для благого дела, думаю кто нибудь еще тоже скинет