[Help]Cant register gameserver .

[Kwlotoumpas]

Someone could tell me what im doing wrong ???? Thanks you in advance! :-[

 

FATAL: Failed loading GameServerTable. Reason: Access denied for user 'root

'@'localhost' (using password: YES)

java.sql.SQLException: Access denied for user 'root     '@'localhost' (using pas

sword: YES)

       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)

       at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)

       at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)

       at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)

       at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2

371)

       at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)

       at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

       at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

       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:407)

       at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)

       at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:305)

       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 net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:101)

       at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:208)

       at net.sf.l2j.loginserver.GameServerTable.loadRegisteredGameServers(Game

ServerTable.java:148)

       at net.sf.l2j.loginserver.GameServerTable.<init>(GameServerTable.java:87

)

       at net.sf.l2j.loginserver.GameServerTable.load(GameServerTable.java:69)

       at net.sf.l2j.gsregistering.GameServerRegister.main(GameServerRegister.j

ava:49)

Press any key to continue . . .

[SweeTs]

Check your loginserver.properties and remove password (if you don't use).

 

Login = root

Password =

[Kwlotoumpas]

Finally an answer!Thank so much.It didnt help me tho.Im using password =/

 

So the problem is somewhere else  :'(

[SweeTs]

Im using password =/

 

I know this may sound silly, but you have typed the correct password? :P

[Kwlotoumpas]

I register both for Gameserver and Loginserver the password root.Same goes to navicat and MySql :S

[SweeTs]

Well, it's strange :P

It reminds me my friend's problem. He was using password and he wasn't able to create a successful connection in Navicat.

Hmm check your loginserver, in Login and Password, if there isn't any 'space' while typing.

 

Access denied for user 'root    '@'localhost'

 

There is a space after root. If this doesn't help, I have no more ideas. :P

[Kwlotoumpas]

Where should i check for this? Im confused.About 1 hour now searching how to fix this and make freaking hexid ;P

[SweeTs]

Hmm check your loginserver, in Login and Password

 

Loginserver.prop :D

 

Login = root <--- See if there is no free space after the word

Password = root <--- See if there is no free space after the word

[Kwlotoumpas]

that's how it looks like :S

 

So i think its ok :S

 

Login = root

Password = root

[SweeTs]

In Login after root___ there is a space :D

Ahh, I forgot something.. you have to put also password above :P

 

URL = jdbc:mysql://localhost/acis

#URL = jdbc:hsqldb:hsql://localhost/acis

#URL = jdbc:sqlserver://localhost/database=acis/user=sa/password=root

 

Login = root

Password = root

[Kwlotoumpas]

I did :S

 

Not working argh :D

[SweeTs]

Errm, dunno wtf :D

Probably navicat don't want to listen your password :D

Well, try to do a 'test connection' in navicat. I mean, press 'Connection' type ur User Name and Password (root, root) and press 'Test Connection'.

If result will be positive, that mean you put wrong pass in loginserver.

[Kwlotoumpas]

I dont know how to do this :S Didnt understand

[Kwlotoumpas]

I will remove all programs and try again without passwords :P

[Howl3r]

#URL = jdbc:sqlserver://localhost/database=acis/user=sa/password=root

Are you blind? # = commented. Is not needed to add password there. w00t

 

Your problem is too simple........

java.sql.SQLException: Access denied for user 'root    '@'localhost' (using pas

sword: YES)

[Kwlotoumpas]

I'm reinstalling programs.I'll post news soon