i need some help with java server i am absoulitle newbie :)

kafroylis · December 15, 2008

i puss startserverlogin.bat and it write me this

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; tracestart

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

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

for user 'root'@'localhost' (using 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 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: NO)

WARN : SQL Error: 1045, SQLState: 28000

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

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$

$418817a8.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: 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 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

Press any key to continue . . .

macdonald12 · December 20, 2008

The gameserver is failing to connect to your database. Make sure your database is up and running and the parameters are set correctly in server.config

Hax0r · December 20, 2008

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

You'll have to edit server.properties and loginserver.properties with MySQL's password.

eKo · August 6, 2010

goood.

dont spam !...

check your password in your Config

extr3me · August 6, 2010

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

Go in config and search or in gameserver.properties or network.properties or server.properties and loginserver.properties and you will find that

# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Uncomment the appropriate driver and url for the database you're using. If you don't know what this is... www.google.com
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 = 
#Database user info (using root user is not recommended)
Login = root
Password =

Put Your Password witch you used on mysql server [sorry for my bad english]

Hax0r · August 6, 2010

Jeez guys, check the date.

Erol · August 6, 2010

dont spam !...

check your password in your Config

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

Go in config and search or in gameserver.properties or network.properties or server.properties and loginserver.properties and you will find that

# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Uncomment the appropriate driver and url for the database you're using. If you don't know what this is... www.google.com
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 = 
#Database user info (using root user is not recommended)
Login = root
Password =

Put Your Password witch you used on mysql server [sorry for my bad english]

thnx for the help

he didn't fixed it since 2008. GOD.

Locked.

i need some help with java server i am absoulitle newbie :)

Question

kafroylis

6 answers to this question

Recommended Posts

macdonald12

Hax0r

eKo

extr3me

Hax0r

Erol

Posts

Topics

Browse

Activity

Store

Important Information