Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team
  • 0

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

kafroylis

Asked by kafroylis,

 Share

Question

kafroylis Newbie

kafroylis

Posted
Posted

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

6 answers to this question

Recommended Posts

  • 0
Hax0r Newbie

Hax0r

Posted
Posted 

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

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

  • 0
extr3me Newbie

extr3me

Posted
Posted 

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]

  • 0
Erol Newbie

Erol

Posted
Posted

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.

Guest
This topic is now closed to further replies.
 Share
Go to question listing


×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock