Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

L2J [Help]ACCESS help

Initiate Mage
Joined
Oct 10, 2006
Messages
8
Reaction score
0
When i start RegisterGameServer,loginserver:

INFO : loading login config
INFO : MLog clients using log4j logging.
INFO : Initializing c3p0-0.9.0.4 [built 23-January-2006 22:20:29 -0500; debug? t
rue; trace: 10]
INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource@121f1
d[ acquireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, a
utoCommitOnClose -> true, automaticTestTable -> connection_test_table, breakAfte
rAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com
.mchange.v2.c3p0.impl.DefaultConnectionTester, description -> null, driverClass
-> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTra
nsactions -> false, identityToken -> 121f1d, idleConnectionTestPeriod -> 60, ini
tialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost/l2jdb, loginTimeout -> 0, m
axIdleTime -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnecti
on -> 100, minPoolSize -> 1, numHelperThreads -> 20, preferredTestQuery -> null,
properties -> {user=******, password=******}, propertyCycle -> 300, testConnect
ionOnCheckin -> true, testConnectionOnCheckout -> false, usesTraditionalReflecti
veProxies -> false ]
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.MysqlIO.checkErrorPacket(MysqlIO.ja va:2926)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 3647)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:11 76)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:79)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:82)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:497)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:421)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:342)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:360)
at com.mchange.v2.c3p0.PoolBackedDataSource.getConnec tion(PoolBackedData
Source.java:94)
at com.mchange.v2.c3p0.ComboPooledDataSource.getConne ction(ComboPooledDa
taSource.java:521)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.cfg.SettingsFactory.buildSettings(Se ttingsFactory.java:
84)
at org.hibernate.cfg.Configuration.buildSettings(Conf iguration.java:2009
)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.jav
a:1292)
at org.springframework.orm.hibernate3.LocalSessionFac toryBean.newSession
Factory(LocalSessionFactoryBean.java:804)
at org.springframework.orm.hibernate3.LocalSessionFac toryBean.buildSessi
onFactory(LocalSessionFactoryBean.java:744)
at org.springframework.orm.hibernate3.AbstractSession FactoryBean.afterPr
opertiesSet(AbstractSessionFactoryBean.java:131)
at org.springframework.beans.factory.support.Abstract AutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableB eanFactory.java:1118)
at org.springframework.beans.factory.support.Abstract AutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBean Factory.java:1085)
at org.springframework.beans.factory.support.Abstract AutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFact ory.java:429)
at org.springframework.beans.factory.support.Abstract BeanFactory$1.getOb
ject(AbstractBeanFactory.java:250)
at org.springframework.beans.factory.support.DefaultS ingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:1 41)
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean
(AbstractBeanFactory.java:247)
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean
(AbstractBeanFactory.java:161)
at org.springframework.beans.factory.support.DefaultL istableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactor y.java:270)
at org.springframework.context.support.AbstractApplic ationContext.refres
h(AbstractApplicationContext.java:346)
at org.springframework.context.support.ClassPathXmlAp plicationContext.<i
nit>(ClassPathXmlApplicationContext.java:92)
at org.springframework.context.support.ClassPathXmlAp plicationContext.<i
nit>(ClassPathXmlApplicationContext.java:77)
at net.sf.l2j.L2Registry.loadRegistry(L2Registry.java :53)
at net.sf.l2j.gsregistering.GameServerRegister.main(G ameServerRegister.j
ava:47)

INFO : Loaded 127 server names
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.CannotCreateTransa cti
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.handledN onSpecificException
(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.j
ava:91)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelp
er.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:424)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:349)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:255)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversService s$$EnhancerByCGLIB$
$33f1fa34.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.l oad(GameServerManag
er.java:149)
at net.sf.l2j.loginserver.manager.GameServerManager.< init>(GameServerMan
ager.java:104)
at net.sf.l2j.loginserver.manager.GameServerManager.g etInstance(GameServ
erManager.java:86)
at net.sf.l2j.gsregistering.GameServerRegister.main(G ameServerRegister.j
ava:51)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usi
ng password: NO)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2926)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 3647)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:11 76)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:79)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:82)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:497)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:421)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:342)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:360)
at com.mchange.v2.c3p0.PoolBackedDataSource.getConnec tion(PoolBackedData
Source.java:94)
at com.mchange.v2.c3p0.ComboPooledDataSource.getConne ction(ComboPooledDa
taSource.java:521)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:421)
... 15 more
Press any key to continue . . .

P.S. Server L2jFree 778.DB install sucefuly.
 
Moved on
Joined
Jan 13, 2006
Messages
706
Reaction score
0
Re: ACESS help!!

INFO : Loaded 127 server names
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.CannotCreateTransa cti

Read it again...
 
Upvote 0
Initiate Mage
Joined
Oct 10, 2006
Messages
8
Reaction score
0
Re: ACESS help!!

Where i can whrite password?In server.propetries i whrite.
 
Upvote 0
Initiate Mage
Joined
Oct 10, 2006
Messages
8
Reaction score
0
Re: ACESS help!!

All right!!Now in gameserver:
INFO
java.io.IOException: An attempt was made to access a socket in a way forbidden b
y its access permissions
at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)
at sun.nio.ch.ServerSocketChannelImpl.accept(Unknown Source)
at net.sf.l2j.gameserver.SelectorThread.acceptConnect ion(SelectorThread.
java:553)
at net.sf.l2j.gameserver.SelectorThread.run(SelectorT hread.java:299)

INFO
java.io.IOException: An attempt was made to access a socket in a way forbidden b
y its access permissions
at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)
at sun.nio.ch.ServerSocketChannelImpl.accept(Unknown Source)
at net.sf.l2j.gameserver.SelectorThread.acceptConnect ion(SelectorThread.
java:553)
at net.sf.l2j.gameserver.SelectorThread.run(SelectorT hread.java:299)

INFO
java.io.IOException: An attempt was made to access a socket in a way forbidden b
y its access permissions
at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)
at sun.nio.ch.ServerSocketChannelImpl.accept(Unknown Source)
at net.sf.l2j.gameserver.SelectorThread.acceptConnect ion(SelectorThread.
java:553)
at net.sf.l2j.gameserver.SelectorThread.run(SelectorT hread.java:299)

INFO
java.io.IOException: An attempt was made to access a socket in a way forbidden b
y its access permissions
at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)
at sun.nio.ch.ServerSocketChannelImpl.accept(Unknown Source)
at net.sf.l2j.gameserver.SelectorThread.acceptConnect ion(SelectorThread.
java:553)
at net.sf.l2j.gameserver.SelectorThread.run(SelectorT hread.java:299)

INFO
java.io.IOException: An attempt was made to access a socket in a way forbidden b
y its access permissions
at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)
at sun.nio.ch.ServerSocketChannelImpl.accept(Unknown Source)
at net.sf.l2j.gameserver.SelectorThread.acceptConnect ion(SelectorThread.
java:553)
at net.sf.l2j.gameserver.SelectorThread.run(SelectorT hread.java:299)


And when i push login buttom i have table "INVALID_SOCKED"


P.S. sry for my bad english

P.S.S This error with Oneo 363
 
Upvote 0
Just Ask ME!!!
Joined
Nov 16, 2006
Messages
833
Reaction score
0
Re: ACESS help!!

what program said this error? register, Login, Gameserver??? CHANGE THE PASWORD in server.properties and login.properties...
 
Upvote 0
Just Ask ME!!!
Joined
Nov 16, 2006
Messages
833
Reaction score
0
Re: ACESS help!!

well edit the server.properties search where said DatabasePas and put u pasword
 
Upvote 0
Initiate Mage
Joined
Oct 10, 2006
Messages
8
Reaction score
0
Re: ACESS help!!

well edit the server.properties search where said DatabasePas and put u pasword

not in server.properties ,but in .xml i see error.All right.Plz tell me good Interlude server with gm shop who have c6 weapons,armors,accesoryes.....

Plz ;]
P.S. Sorry for my bad english ;]
 
Upvote 0
Initiate Mage
Joined
Oct 20, 2006
Messages
2
Reaction score
0
Re: ACESS help!!

I have the same probleam on the L2JCNC5Final
信息:
java.io.IOException: 以一种访问权限不允许的方式做了一个访问套接字的尝试。
at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)
at sun.nio.ch.ServerSocketChannelImpl.accept(Unknown Source)
at net.sf.l2j.gameserver.SelectorThread.acceptConnection(SelectorThread.java:581)
at net.sf.l2j.gameserver.SelectorThread.run(SelectorThread.java:302)
2007-3-30 18:00:02 net.sf.l2j.gameserver.SelectorThread acceptConnection

信息 = INFO
以一种访问权限不允许的方式做了一个访问套接字的尝试 = An attempt was made to access a socket in a way forbidden by its access permissions
 
Upvote 0
Junior Spellweaver
Joined
Jun 22, 2004
Messages
141
Reaction score
1
Re: ACESS help!!

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

hehe , You dont have a MySQL Password set on User root ^^ Delete only the password^^


Do you run your server on Linux or Windows?@MafasZ


When u run it on Linux than go in the folder where is the server and tip chmod 777 *
 
Upvote 0
Back
Top