help me !!

[gryzli]

Starting L2J Login Server.

 

INFO : loading login config

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] ]

WARN : SQL Error: 1045, SQLState: 28000

ERROR : Access denied for user 'root'@'localhost' (using password: YES)

WARN : Could not obtain connection metadata java.sql.SQLException: Access denied

for user 'root'@'localhost' (using password: YES)

        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 org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.

getConnection(LocalDataSourceConnectionProvider.java:81)

        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:

84)

        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009

)

        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav

a:1292)

        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSession

Factory(LocalSessionFactoryBean.java:804)

        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi

onFactory(LocalSessionFactoryBean.java:744)

        at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr

opertiesSet(AbstractSessionFactoryBean.java:131)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:429)

        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb

ject(AbstractBeanFactory.java:250)

        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr

y.getSingleton(DefaultSingletonBeanRegistry.java:141)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:247)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:161)

        at org.springframework.beans.factory.support.DefaultListableBeanFactory.

preInstantiateSingletons(DefaultListableBeanFactory.java:270)

        at org.springframework.context.support.AbstractApplicationContext.refres

h(AbstractApplicationContext.java:346)

        at org.springframework.context.support.ClassPathXmlApplicationContext.<i

nit>(ClassPathXmlApplicationContext.java:92)

        at org.springframework.context.support.ClassPathXmlApplicationContext.<i

nit>(ClassPathXmlApplicationContext.java:77)

        at net.sf.l2j.L2Registry.loadRegistry(L2Registry.java:65)

        at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:104)

        at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)

 

INFO : Loaded 127 server names

INFO : LoginManager initiating

INFO : Cached 10 KeyPairs for RSA communication

INFO : RandomIntGenerator: initialized

INFO : Stored 20 keys for Blowfish communication

WARN : SQL Error: 1045, SQLState: 28000

ERROR : Access denied for user 'root'@'localhost' (using password: YES)

WARN : SQL Error: 1045, SQLState: 28000

ERROR : Access denied for user 'root'@'localhost' (using password: YES)

Exception in thread "main" org.springframework.transaction.CannotCreateTransacti

onException: Could not open Hibernate Session for transaction; nested exception

is org.hibernate.exception.GenericJDBCException: Cannot open connection

Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException

(SQLStateConverter.java:103)

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j

ava:91)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:43)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:29)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager

.java:424)

        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.

java:144)

        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)

        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:

57)

        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326

)

        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi

n(HibernateTransactionManager.java:497)

        at org.springframework.transaction.support.AbstractPlatformTransactionMa

nager.getTransaction(AbstractPlatformTransactionManager.java:349)

        at org.springframework.transaction.interceptor.TransactionAspectSupport.

createTransactionIfNecessary(TransactionAspectSupport.java:255)

        at org.springframework.transaction.interceptor.TransactionInterceptor.in

voke(TransactionInterceptor.java:102)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

ReflectiveMethodInvocation.java:176)

        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc

eptor.intercept(Cglib2AopProxy.java:616)

        at net.sf.l2j.loginserver.services.GameserversServices$$EnhancerByCGLIB$

$ea482160.getAllGameservers(<generated>)

        at net.sf.l2j.loginserver.manager.GameServerManager.load(GameServerManag

er.java:208)

        at net.sf.l2j.loginserver.manager.GameServerManager.<init>(GameServerMan

ager.java:111)

        at net.sf.l2j.loginserver.manager.GameServerManager.getInstance(GameServ

erManager.java:82)

        at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:113)

        at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)

Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usi

ng password: YES)

        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 org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.

getConnection(LocalDataSourceConnectionProvider.java:81)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager

.java:421)

        ... 16 more

 

Server terminated abnormaly

 

 

server terminated

 

 

Im newbie so it will be nice if you write what exacly i have to do :).

[Flarez]

Mysql reiinstall can help maybe

[livogro]

You forget write pasword in the server.properties I think.. :?

Sry for my bad english..

[gryzli]

mysql reinstal didnt help, and i think that i have pasword in server.properties, it looks like this:

# Database info

Driver=com.mysql.jdbc.Driver

#Driver=org.hsqldb.jdbcDriver

#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

URL=jdbc:mysql://localhost/l2jdb

#URL=jdbc:hsqldb:hsql://localhost/l2jdb

#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=root

Login=root

Password=root

MaximumDbConnections=50

[selassie]

URL to MySQL isn't correct. fix it.

[gryzli]

Ok but how?? :P Sorry for that stupid questions but im newbie :)

[Destorion]

mysql reinstal didnt help, and i think that i have pasword in server.properties, it looks like this:

# Database info

Driver=com.mysql.jdbc.Driver

#Driver=org.hsqldb.jdbcDriver

#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

URL=jdbc:mysql://localhost/l2jdb

#URL=jdbc:hsqldb:hsql://localhost/l2jdb

#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=root

Login=root

Password=root

MaximumDbConnections=50

Root Password=No u must remove Root Password

[gryzli]

i removed password and didnt work ;/

[Destorion]

i removed password and didnt work ;/

Reinstall all from the begining and this time u will not add Root Password.

I mean Root Password=No!.

 

Good Luck

[gryzli]

I reinstaled all and didn't help ;/. And i must change that password in mysql instalation?

Sorry for my english :P

[RammS]

just when instal the mysql dont put any pass. thats all.

 

or if you want to put a pass .. .u must go to config/serverproperties.

 

 

and find this .. if you are using l2jfree.

 

# Database info

Driver = com.mysql.jdbc.Driver

# Driver = org.hsqldb.jdbcDriver

# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

URL = jdbc:mysql://localhost/l2jdb

# URL = jdbc:hsqldb:hsql://localhost/l2jdb

# URL = jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=

Login = root

Password =root  ==>> make sure that this is the same pas of your mysql

MaximumDbConnections = 50

 

 

next step go in  \l2j-loginserver\dist\config\loginserver

 

 

# Database info

Driver=com.mysql.jdbc.Driver

#Driver=org.hsqldb.jdbcDriver

#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

URL=jdbc:mysql://localhost/l2jdb

#URL=jdbc:hsqldb:hsql://localhost/l2jdb

#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=

Login=root

Password=root == >> same pass of your mysql

 

 

thats all i hoppe  that your problem is solved.

 

[fdLP.]

you have to add there the psw u used on mysql to start and the same u use in navicat for the communication to start and see your databases! if you havent setted up any , leave it blank!