gryzli

I reinstaled all and didn't help ;/. And i must change that password in mysql instalation? Sorry for my english :P

i removed password and didnt work ;/

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

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

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 :).

Thx man

Ty man

Ty man

Thx man! nice!