Jump to content
  • 0

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


kafroylis

Question

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

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

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

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

    • I've made over 200 euro just by fixing Kara codes, this guy was actually pathetic saying stuff like: 'I can't work today I'm sad because I broke up'.
    • Hello everyone, I am excited to announce the launch of my new Lineage 2 High Five server! If you're a fan of Lineage 2, you won't want to miss out on the action that my server has to offer. With a High Five chronicle, you can expect a truly unique and immersive gaming experience. My server offers a variety of exciting features, including a balanced economy, custom NPCs, and a friendly and active community. One of the standout features of my server is the focus on PvP. Whether you're a seasoned veteran or a newcomer to the world of Lineage 2, you'll find plenty of opportunities to engage in thrilling battles with other players. With our custom PvP system and unique events, you'll never run out of challenges to overcome. But that's not all - my server also offers a range of custom content and quests that will keep you engaged and entertained for hours on end. With regular updates and a dedicated team of developers, you can expect a high-quality and enjoyable gaming experience every time you log in. So what are you waiting for? Join the action on my Lineage 2 High Five server today and experience the thrill of a truly epic adventure!     Cronica High Five Rates: XP x30 SP x30 Adena x10 Drop x10 Spoil x 10 Seal Stone  x10 RateQuestsReward x5 RateQuestsAdenaReward x 5 RateRaidBoss x5 RateQuestsDrop x5 RateSiegeGuard x 1 RateSiegeGuardPA x1 RateManor x 5 Features Server: Free subb class Free class transfer Gm shop grade S Gk global Quest certification :on Siegue castle  monthly :on Olympiad  monthly :on Seven sings free :on 2 HOUR buffs Olympiad max enchant +6 Safe enchant normal 50% Safe enchant blessed 50% EnchantAttributeChance  50% EnchantAttributeCrystalChance =30% EPIC RAID BOSS CONFIG ANTHARAS_RESPAWN_TIME_PATTERN  17DAYS +-120 MINT #Time in minutes, at the end of which, Antharas spawned at the entrance to the lair: ANTHARAS_SPAWN_DELAY = 20 MIN. # Time in minutes, after which, if Antharas is not attacked, he falls asleep ANTHARAS_SLEEP_TIME = 30 # Valakas settings VALAKAS_RESPAWN_TIME_PATTERN  27 DAYS +- 120 M,IN # Time in minutes, at the end of which, Valakas spawned at the entrance to the lair: VALAKAS_SPAWN_DELAY = 10 # Time in minutes, after which, if Valakas is not attacked, he falls asleep: VALAKAS_SLEEP_TIME = 20 # Baium settings BAIUM_RESPAWN_TIME_PATTERN =  8 DAYS +-120 MIN # Time in minutes, after which, if Baium is not attacked, he falls asleep BAIUM_SLEEP_TIME = 30   "We are in beta phase."   L2EUROLATIN HIGH FIVE X30
    • Does anybody found the way to solve problems with precice calculation on drop? i found the same formula of drop in l2jsunrise en l2jserver. https://bitbucket.org/l2jserver/l2j-server-game/src/develop/src/main/java/com/l2jserver/gameserver/model/drops/strategy/IGroupedItemDropCalculationStrategy.java yesterday i check that the problem is with drop group, because for example Celtus npc drops holys on 100% configurated like datapack is comming. but if i creat a drop of holys or an item outside of a group drop. it is droped well.
    • Well, i have to agree with you here, as a community we should respect each other and respect each others interests and not damage them, they unbanned the idiot kara for no reason like 5 times like he will bring something to the community but all he did was to damage it over and over again and i still cant explain why that had to happen, i swear whoever contact me says that he've been scammed by him for atleast 50-100e and some for even much more.   p.s. its a community to provide/share cheats for games not share someone's work.
    • I dont see the unfairness here, I provided free sources to everyone for free, as a Cheater would do, isnt this what MAXCHEATERS were meant to be? Hell YES! As Im aware, the poor subscriber I took over to get your files, had PAID for them. Nobody is scamming anyone, not from my part, since I offered those files for FREE and they are virus free which anyone who have downloaded them can scan and provide full report they're clean as a fresh shaved pussy!   Maxcheaters once was MaxBastards, which i Liked more. It shall rise again for the old memories sake and not become a den full of pussies who are afraid to do what this forum is ALL about.   my 2 cents
  • Topics

×
×
  • 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