Jump to content
MaxCheaters Official Group at Discord
--> Place your ad text here <--
  • 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 . . .

Link to comment
Share on other sites

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.

Link to comment
Share on other sites
  • 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]

Link to comment
Share on other sites
  • 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.

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing


  • Posts

    • L2LIVEpro
      L2jOrion - Sourcecode.

      By L2LIVEpro · Posted

      Well, sorry not sorry for resurrecting old topic, but I believe it's ultimately stupid to implement license checks like Vilmis did 🙂   private static String url = "jdbc:mysql://185.80.128.233/" + getData("Zm9ydW1fZGI="); private static String username = getData("bXJjb3B5cmlnaHQ="); private static String password = getData("Y29weXJpZ2h0XzEyMw=="); con = GlobalDB.getInstance().getConnection(); PreparedStatement statement; statement = con.prepareStatement("SELECT field_6 from core_pfields_content WHERE member_id = ?"); statement.setInt(1, Config.FORUM_USER_ID); ResultSet rset = statement.executeQuery();   This awesome way of coding things leaves us with base64-encoded credentials and DB exposed and accessible globally 😉 Btw he checks his licensing data from some plugin generated table his forum uses. Vilmis took action and ensured that mrcopyright user would have only needed accesses and rights for this operation. But he forgot to ensure that his INFORMATION_SCHEMA database would not be exposed and readable... That leads us to fully readable server variables like version used (10.1.26-MariaDB-0+deb9u1 - pretty ancient DB and OS, I'd assume). From here you can go south and do some kinky stuff, if you want and have knowledge for that. But who cares, right?   Ooh, table core_pfields_content field_6 is IP address which is checked by FORUM_USER_ID. Yep, you can query all IP addresses there (124 of them right now) and also do whatever you want with them! 🙂  The most fun part? Files source has been shared what, more than 2 years ago?  Vilmis still uses very same credentials and never changed it after sources exposure - who cares. Although, "sources" may be way too strong word here. If anyone still use paid Orion versions, I'd suggest packing your shit and leaving immediately, or at least fix this incompetent fool caused problems. It's obvious Vilmis don't care or maybe doesn't even know from the first place how to solve this problem (hint hint - tiny PHP Rest API microservice which would do absolutely the same but without exposing sensitive data?). By doing that, he exposes his infrastructure and YOUR data, and he does that for more than 2 years now 🙂 Developer of century!    
    • lol021
      ⭐ LIST OF FORUMS FOR YOUR NEEDS ⭐ [OVER 100 RUSSIAN FORUMS]

      By lol021 · Posted

      discord please   
    • Finn
      Help with folder system!

      By Finn · Posted

      rename the l2.bin into l2.exe
    • L2LIVEpro
      [L2j] L2LIVE

      By L2LIVEpro · Posted

      L2LIVE.PRO- Dynamic Mid-rates Essence Seven Signs GRAND OPENING - July 5, 20:00 GMT+3 (EEST) TEST SERVER IS OPEN - COME AND CHECK IT OUT TODAY! Join our community and be part of it at: https://www.l2live.pro https://discord.gg/k3NMgR4Dmu   Server description * EXP/SP: Dynamic (x1- x100 based on your level, *before* Sayha and EXP buffs * Adena: x50 / Item Drop: x10 / Fishing EXP increased / Attribute EXP increased * Simplified gameplay to stay in the loop while not spending hours and hours farming * Starter Pack containing very useful items for beginners * MP replenishing potions with auto-consumption * No overpowered donations L2LIVE shop * All spellbook coupons, pet spellbook coupons and master books are sold via Game Assistant * Additionally you can buy SP pouches, enchanted talismans, pet training guides and various other consumables for Adena and L-Coin * More items such as cloaks, more talismans, agathions, belts, pendants, enchantment scrolls of various grades, evolution stones, etc will be added! Shop server as a shortcut, and all retail-like ways of earning items are still here! L-Coins * Drops with small change and in random amounts from Lv60+ monsters  * All raidbosses drop random amount of L-Coin Pouches generating up to 420 Lcoin per unit. **Grand Olympiad and Events** * Grand Olympiad is held week day * Format is 1v1, unlimited weekly fights  * Heroes are declared weekly at Sunday * There are three automated events - TvT, CTF and Deathmatch, running at evenings * Orc Fortress, Battle with Balok, Keber Hunter, Archievements Box, Daily Gift Calendar provisional events are active too Custom user commands * .offlineplay command, your character will keep playing till death or server restart * .offlineshop command, keeps your shop sitting until all items are purchased * .apon / .apoff - enable/disable HP/MP autoconsume And lots of other small improvements are waiting for you!   Join our community and be part of it at: https://www.l2live.pro https://discord.gg/k3NMgR4Dmu
    • milozare
      ⭐ LIST OF FORUMS FOR YOUR NEEDS ⭐ [OVER 100 RUSSIAN FORUMS]

      By milozare · Posted

      Relevant! List of forums on sale! Contact us!

  • Topics

×
×
  • Create New...