Ответов

[Destus]

Другие темы в разделе будут удалятся.

[oleg27]

Железо: Pentium® D CPU 3.00GHz ; 1024 Оперативки.
ОС: Windows XP Professional server pack 2.
Программы: MySQL 5.2 x32 ; Java x32
Сборка: Graica,L2jFree.

Суть проблемы: при запуске Login Server,он не загружаеться до конца.(Логи ниже)
Вопрос: в чем причина и как исправить?
Мои соображения по этому поводу: судя по всему где то не указал пароль.

Код

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
[color="#FF0000"]ERROR : Access denied for user 'root'@'localhost' (using password: YES)[/color]
[color="#FF0000"]WARN : Could not obtain connection metadata java.sql.SQLException: Access denied
for user 'root'@'localhost' (using password: YES)[/color]
  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 com.l2jfree.L2Registry.loadRegistry(L2Registry.java:65)
  at com.l2jfree.loginserver.L2LoginServer.<init>(L2LoginServer.java:104)
  at com.l2jfree.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 com.l2jfree.loginserver.services.GameserversServices$$EnhancerByCGLIB
$$7ce219a1.getAllGameservers(<generated>)
  at com.l2jfree.loginserver.manager.GameServerManager.load(GameServerMana
ger.java:210)
  at com.l2jfree.loginserver.manager.GameServerManager.<init>(GameServerMa
nager.java:113)
  at com.l2jfree.loginserver.manager.GameServerManager.getInstance(GameSer
verManager.java:82)
  at com.l2jfree.loginserver.L2LoginServer.<init>(L2LoginServer.java:113)
  at com.l2jfree.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

Для продолжения нажмите любую клавишу . . .

[Ruxx]

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

пароль от базы неправильный.