finkorn Posted September 25, 2009 Posted September 25, 2009 Pls help >:( Starting l2jfree INFO logging initialized =============================================================-[ Configuration ] INFO loading ./config/server.properties INFO loading ./config/hexid.txt INFO loading ./config/subnets.properties INFO loading ./config/rates.properties INFO loading ./config/enchant.properties INFO loading ./config/pvp.properties INFO loading ./config/telnet.properties INFO loading ./config/options.properties INFO loading ./config/other.properties INFO loading ./config/geodata.properties INFO loading ./config/altsettings.properties INFO loading ./config/clans.properties INFO loading ./config/champions.properties INFO loading ./config/lottery.properties INFO loading ./config/wedding.properties INFO loading ./config/siege.properties INFO loading ./config/fortsiege.properties INFO loading ./config/clanhall.properties INFO loading ./config/castle.properties INFO loading ./config/idfactory.properties INFO loading ./config/fun_engines.properties INFO loading ./config/sevensigns.properties INFO loading ./config/GMAccess.properties INFO loading ./config/command-privileges.properties INFO loading ./config/irc.properties INFO loading ./config/boss.properties INFO loading ./config/sayfilter.txt INFO loading ./config/elayne.properties ==================================================================-[ Database ] INFO : MLog clients using log4j logging. INFO : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace : 10] INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ jav a.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [num ThreadsAwaitingCheckoutDefaultUser] ] Exception in thread "main" java.sql.SQLException: L2DatabaseFactory: Failed to i nit database connections: java.sql.SQLException: Access denied for user 'root'@' localhost' (using password: NO) at com.l2jfree.L2DatabaseFactory.<init>(L2DatabaseFactory.java:125) at com.l2jfree.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:40) at com.l2jfree.gameserver.GameServer.<init>(GameServer.java:149) at com.l2jfree.gameserver.GameServer.main(GameServer.java:439) Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usi ng password: NO) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :283) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag erDataSource.java:119) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:143) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:132) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu tomaticTestTable(C3P0PooledConnectionPoolManager.java:772) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled ConnectionPool(C3P0PooledConnectionPoolManager.java:696) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0 PooledConnectionPoolManager.java:257) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0 PooledConnectionPoolManager.java:271) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A bstractPoolBackedDataSource.java:128) at com.l2jfree.L2DatabaseFactory.<init>(L2DatabaseFactory.java:116) ... 3 more Server terminated abnormaly server terminated Press any key to continue...
0 drogata Posted September 25, 2009 Posted September 25, 2009 1. wrong selection 2. SQL problem with acc and pass in DB and SQL i think
0 Nik Posted September 25, 2009 Posted September 25, 2009 nothing to do with java... the server cant connect to the database... prolly you havent edited server.properties
0 Saint® Posted September 26, 2009 Posted September 26, 2009 your problem is on Server.properties. dbpass = ? what is your pass on mysql? just put them in there..
Question
finkorn
Pls help >:(
Starting l2jfree
INFO logging initialized
=============================================================-[ Configuration ]
INFO loading ./config/server.properties
INFO loading ./config/hexid.txt
INFO loading ./config/subnets.properties
INFO loading ./config/rates.properties
INFO loading ./config/enchant.properties
INFO loading ./config/pvp.properties
INFO loading ./config/telnet.properties
INFO loading ./config/options.properties
INFO loading ./config/other.properties
INFO loading ./config/geodata.properties
INFO loading ./config/altsettings.properties
INFO loading ./config/clans.properties
INFO loading ./config/champions.properties
INFO loading ./config/lottery.properties
INFO loading ./config/wedding.properties
INFO loading ./config/siege.properties
INFO loading ./config/fortsiege.properties
INFO loading ./config/clanhall.properties
INFO loading ./config/castle.properties
INFO loading ./config/idfactory.properties
INFO loading ./config/fun_engines.properties
INFO loading ./config/sevensigns.properties
INFO loading ./config/GMAccess.properties
INFO loading ./config/command-privileges.properties
INFO loading ./config/irc.properties
INFO loading ./config/boss.properties
INFO loading ./config/sayfilter.txt
INFO loading ./config/elayne.properties
==================================================================-[ Database ]
INFO : MLog clients using log4j logging.
INFO : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace
: 10]
INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ jav
a.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [num
ThreadsAwaitingCheckoutDefaultUser] ]
Exception in thread "main" java.sql.SQLException: L2DatabaseFactory: Failed to i
nit database connections: java.sql.SQLException: Access denied for user 'root'@'
localhost' (using password: NO)
at com.l2jfree.L2DatabaseFactory.<init>(L2DatabaseFactory.java:125)
at com.l2jfree.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:40)
at com.l2jfree.gameserver.GameServer.<init>(GameServer.java:149)
at com.l2jfree.gameserver.GameServer.main(GameServer.java:439)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usi
ng password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:283)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at com.l2jfree.L2DatabaseFactory.<init>(L2DatabaseFactory.java:116)
... 3 more
Server terminated abnormaly
server terminated
Press any key to continue...
5 answers to this question
Recommended Posts