#133 Can't connect to database - Issues - WebAuction - Bukkit Plugins - Projects

Can't connect to database #133

New
Defect

Open

Assigned to

_ForgeUser4509640

_ForgeUser8254778 created this issue Jan 14, 2012

When i lunch the server :
14:20:31 [INFO] [WebAuction] WebAuction is initializing.
14:20:31 [INFO] [WebAuction] MySQL Initializing.
14:20:31 [SEVERE] [WebAuction] Exception getting mySQL Connection
14:20:31 [SEVERE] java.sql.SQLException: Acc├¿s refus├® pour l'utilisateur: 'roo
t'@'@localhost' (mot de passe: OUI)
14:20:31 [SEVERE]   at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
ava:1073)
14:20:31 [SEVERE]   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
3593)
14:20:31 [SEVERE]   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
3525)
14:20:31 [SEVERE]   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
931)
14:20:31 [SEVERE]   at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:403
1)
14:20:31 [SEVERE]   at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
14:20:31 [SEVERE]   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionI
mpl.java:2338)
14:20:31 [SEVERE]   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Conne
ctionImpl.java:2371)
14:20:31 [SEVERE]   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
mpl.java:2163)
14:20:31 [SEVERE]   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.j
ava:794)
14:20:31 [SEVERE]   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection
.java:47)
14:20:31 [SEVERE]   at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
14:20:31 [SEVERE]   at sun.reflect.NativeConstructorAccessorImpl.newInstance
(Unknown Source)
14:20:31 [SEVERE]   at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(Unknown Source)
14:20:31 [SEVERE]   at java.lang.reflect.Constructor.newInstance(Unknown Sou
rce)
14:20:31 [SEVERE]   at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
14:20:31 [SEVERE]   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionI
mpl.java:378)
14:20:31 [SEVERE]   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegist
eringDriver.java:305)
14:20:31 [SEVERE]   at java.sql.DriverManager.getConnection(Unknown Source)
14:20:31 [SEVERE]   at java.sql.DriverManager.getConnection(Unknown Source)
14:20:31 [SEVERE]   at me.exote.webauction.MySQLDataQueries.getConnection(My
SQLDataQueries.java:46)
14:20:31 [SEVERE]   at me.exote.webauction.MySQLDataQueries.tableExists(MySQ
LDataQueries.java:77)
14:20:31 [SEVERE]   at me.exote.webauction.MySQLDataQueries.initTables(MySQL
DataQueries.java:114)
14:20:31 [SEVERE]   at me.exote.webauction.WebAuction.onEnable(WebAuction.ja
va:83)
14:20:31 [SEVERE]   at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlug
in.java:188)
14:20:31 [SEVERE]   at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(
JavaPluginLoader.java:968)
14:20:31 [SEVERE]   at org.bukkit.plugin.SimplePluginManager.enablePlugin(Si
mplePluginManager.java:280)
14:20:31 [SEVERE]   at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftSe
rver.java:187)
14:20:31 [SEVERE]   at org.bukkit.craftbukkit.CraftServer.enablePlugins(Craf
tServer.java:170)
14:20:31 [SEVERE]   at org.bukkit.craftbukkit.CraftServer.reload(CraftServer
.java:444)
14:20:31 [SEVERE]   at org.bukkit.Bukkit.reload(Bukkit.java:187)
14:20:31 [SEVERE]   at org.bukkit.command.defaults.ReloadCommand.execute(Rel
oadCommand.java:22)
14:20:31 [SEVERE]   at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCo
mmandMap.java:165)
14:20:31 [SEVERE]   at org.bukkit.craftbukkit.CraftServer.dispatchCommand(Cr
aftServer.java:379)
14:20:31 [SEVERE]   at org.bukkit.craftbukkit.CraftServer.dispatchCommand(Cr
aftServer.java:375)
14:20:31 [SEVERE]   at net.minecraft.server.MinecraftServer.b(MinecraftServe
r.java:570)
14:20:31 [SEVERE]   at net.minecraft.server.MinecraftServer.w(MinecraftServe
r.java:547)
14:20:31 [SEVERE]   at net.minecraft.server.MinecraftServer.run(MinecraftSer
ver.java:431)
14:20:31 [SEVERE]   at net.minecraft.server.ThreadServerApplication.run(Sour
ceFile:457)
14:20:31 [SEVERE] Error occurred while enabling WebAuction v0.6.4 (Is it up to d
ate?): null
java.lang.NullPointerException
at me.exote.webauction.MySQLDataQueries.tableExists(MySQLDataQueries.jav
a:82)
at me.exote.webauction.MySQLDataQueries.initTables(MySQLDataQueries.java
:114)
at me.exote.webauction.WebAuction.onEnable(WebAuction.java:83)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:188)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:968)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:280)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:187)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:170
)
at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:444)
at org.bukkit.Bukkit.reload(Bukkit.java:187)
at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:
22)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:16
5)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:3
79)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:3
75)
at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:570)
at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:547)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:431)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
14:20:31 [INFO] Server permissions file permissions.yml is empty, ignoring it
14:20:31 [INFO] Reload complete.
>
it's in local with easyphp "root" is correct user, "127.0.0.1 or localhost" is correct host, there is no password and port 3306 is that in config in easyphp.
Don't understand.
_ForgeUser8254778 added the tags New Defect Jan 14, 2012
_ForgeUser4509640 posted a comment Jan 14, 2012

Because of the way the config file is read, I think it may have trouble if you don't give it a password.

Try setting up a user account with a password for your database.
_ForgeUser8254778 posted a comment Jan 14, 2012

2012-01-14 16:32:13 [INFO] [WebAuction] WebAuction is initializing.
2012-01-14 16:32:13 [INFO] [WebAuction] MySQL Initializing.
2012-01-14 16:32:13 [SEVERE] [WebAuction] Exception getting mySQL Connection
2012-01-14 16:32:13 [SEVERE] java.sql.SQLException Access denied for user 'plysken'@'localhost' (using password: YES)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
2012-01-14 16:32:13 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2012-01-14 16:32:13 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-14 16:32:13 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-14 16:32:13 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
2012-01-14 16:32:13 [SEVERE] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
2012-01-14 16:32:13 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source)
2012-01-14 16:32:13 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source)
2012-01-14 16:32:13 [SEVERE] at me.exote.webauction.MySQLDataQueries.getConnection(MySQLDataQueries.java:46)
2012-01-14 16:32:13 [SEVERE] at me.exote.webauction.MySQLDataQueries.tableExists(MySQLDataQueries.java:77)
2012-01-14 16:32:13 [SEVERE] at me.exote.webauction.MySQLDataQueries.initTables(MySQLDataQueries.java:114)
2012-01-14 16:32:13 [SEVERE] at me.exote.webauction.WebAuction.onEnable(WebAuction.java:83)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:188)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:968)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:187)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:170)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:444)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.Bukkit.reload(Bukkit.java:187)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:165)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:379)
2012-01-14 16:32:13 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:375)
2012-01-14 16:32:13 [SEVERE] at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:570)
2012-01-14 16:32:13 [SEVERE] at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:547)
2012-01-14 16:32:13 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:431)
2012-01-14 16:32:13 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
2012-01-14 16:32:13 [SEVERE] Error occurred while enabling WebAuction v0.6.4 (Is it up to date?): null
java.lang.NullPointerException
   at me.exote.webauction.MySQLDataQueries.tableExists(MySQLDataQueries.java:82)
   at me.exote.webauction.MySQLDataQueries.initTables(MySQLDataQueries.java:114)
   at me.exote.webauction.WebAuction.onEnable(WebAuction.java:83)
   at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:188)
   at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:968)
   at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
   at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:187)
   at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:170)
   at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:444)
   at org.bukkit.Bukkit.reload(Bukkit.java:187)
   at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
   at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:165)
   at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:379)
   at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:375)
   at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:570)
   at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:547)
   at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:431)
   at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
2012-01-14 16:32:13 [INFO] Server permissions file permissions.yml is empty, ignoring it
2012-01-14 16:32:13 [INFO] Reload complete.

-----------
I did it.
I set up the plugin "logblock" with exaclty the same parameters and this one works. But webauction don't.

Edited Jan 14, 2012
_ForgeUser8254778 posted a comment Jan 14, 2012

config :

MySQL:
  Host: 127.0.0.1
  Username: plysken
  Password: ****
  Port: 3306
  Database: web
Misc:
  ReportSales: false
  UseOriginalRecentSigns: false
  SignDelay: 1000
Development:
  UseMultithreads: false
SignLink:
  UseSignLink: false
  NumberOfLatestAuctionsToTrack: 10
Updates:
  SaleAlertFrequency: 30
  ShoutSignUpdateFrequency: 90
  RecentSignUpdateFrequency: 160

Edited Jan 14, 2012
_ForgeUser8254778 posted a comment Jan 17, 2012

Somebody help?
_ForgeUser8254778 posted a comment Jan 21, 2012

....Up

To post a comment, please login or register a new account.