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


  • Posts

    • protoftw
      Graphic/Html Designs - Protojah

      By protoftw · Posted

      L2 PVPTOP - HTML DESIGN    
    • Yahwehh
       Sell/Buy Gold WOW / WOW classic !

      By Yahwehh · Posted

      Do not trust this guy, he will scam you. I have sent proof to the mods, I have posted proof on another thread and I can send proof to anyone who DMs me. Avoid this guy. So not only did he scam me out of $51 USDTthen delete his messages and blocked me (I have proof) . You can see his Facebook group is constantly changing names depending on his most current scam. If you see this message and you still decide to go forward with sending your money to him, that’s on you. I can’t stress this enough. This guy is a scammer. 
    • Yahwehh
      🎯 Selling Adena for Lineage 2 — ALL SERVERS (Reborn all)

      By Yahwehh · Posted

      So Goldbar thinks that deleted his side of the conversation makes it easier to claim he didn’t scam me. But I sent him $51 USDT to his ERC-20 account it was verified, he acted like it was fine but then deleted his messages and blocked me. Seriously do not trust this guy. 
    • zambog420
      Junior developer, looking to intern on a non-profit project.

      By zambog420 · Posted

      Hi everyone, let me introduce myself—I'm Martin, a junior developer. I'm diving into the world of L2 servers, and honestly, I'm super overwhelmed about where to start learning the right way to set up, configure, and run a server. There are so many datapacks—free, private—but it's so much that my head feels like it's going to explode. I'm currently looking for someone or an active project willing to take me on as an intern. I'm not looking to make money—I'm just here to learn and grow out of pure passion for L2. I've already been working with L2jMobius H5. I managed to edit the Community Board, add a buffer, GM Shop, and teleports. I've also created custom NPCs for the GM Shop, and imported new custom weapons and armors—complete with original glow effects, like the Valakas and Antharas weapons. But there's still a lot I don't know, and it can get overwhelming. That’s why I’m looking for someone—or an active non-profit project—willing to take me on as an intern. I’m not looking to make money; I just want to learn, contribute, and grow out of pure passion for L2. If you’re working on a project and could use a motivated learner who’s eager to help, I’d love to connect!
    • Mantosh
      [L2J] L2Toggle

      By Mantosh · Posted

      Our next easy-botting project, Kain, is right around the corner! Launching tomorrow, Saturday, April 26th at 9:00 ET (UTC -4)! If you haven’t, check out the features and join our Discord to catch up on the latest drama. See you very soon! Read more about L2Toggle and Kain on our site and forum!  

  • Topics

×
×
  • Create New...