Help L2Junity Loginserver [Error]

[camolus]

[15:34:55] L2LoginServer: FATAL: Failed initializing database. Reason: Access denied for user 'root'@'localhost' (using password: NO)

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1665) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2249) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2280) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_111]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_111]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_111]

at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_111]

at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325) ~[mysql-connector-java-5.1.36.jar:5.1.36]

at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161) ~[c3p0-0.9.5.1.jar:0.9.5.1]

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161) ~[c3p0-0.9.5.1.jar:0.9.5.1]

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147) ~[c3p0-0.9.5.1.jar:0.9.5.1]

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:1000) ~[c3p0-0.9.5.1.jar:0.9.5.1]

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:921) ~[c3p0-0.9.5.1.jar:0.9.5.1]

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:397) ~[c3p0-0.9.5.1.jar:0.9.5.1]

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:414) ~[c3p0-0.9.5.1.jar:0.9.5.1]

at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) ~[c3p0-0.9.5.1.jar:0.9.5.1]

at org.l2junity.DatabaseFactory.<init>(DatabaseFactory.java:101) ~[bin/:?]

at org.l2junity.DatabaseFactory.getInstance(DatabaseFactory.java:155) ~[bin/:?]

at org.l2junity.loginserver.L2LoginServer.<init>(L2LoginServer.java:77) [bin/:?]

at org.l2junity.loginserver.L2LoginServer.main(L2LoginServer.java:58) [bin/:?]

 

~https://cdn.discordapp.com/attachments/252146718718558208/252804097076363264/unknown.png

 

Some advice would be nice ;)
I followed the LJUnity Eclipse Tutorial, but i still get lots of errors x.x

Edited November 29, 2016 by camolus

[AccessDenied]

You're probably worst than Justin bieber. First of all it's not about JAVA is about english if you read not even carefuly what you pasted you gonna understand that it tell you

 

[15:34:55] L2LoginServer: FATAL: Failed initializing database. Reason: Access denied for user 'root'@'localhost' (using password: NO)

in other words the password in your MYSQL is not equal to the password in LOGINSERVER and GAMESERVER. 

Please consider of drink a mochito and make 2-3 bungee jumping before you post any other questions cause you guys in 2k16 dont even search.

 

http://www.l2jserver.com/forum/viewtopic.php?t=13283

 

http://www.maxcheaters.com/topic/5982-help1045-access-denied-for-user-rootlocalhost-using-password-yes/

 

http://www.maxcheaters.com/topic/107444-helpcant-register-gameserver/page-1

[eressea]

First, you've probably set some password when installing MySQL.

Second, you shouldn't use root (administrator) MySQL account for running l2j - you should create another user, eg. run this under root:

 

GRANT ALL PRIVILEGES ON gameserver.* TO gameserver@localhost IDENTIFIED BY 's0m3n3wp455w0rdf0rg4m353rv3r'; -- create gameserver user

GRANT ALL PRIVILEGES ON loginserver.* TO loginserver@localhost IDENTIFIED BY 's0m3n3wp455w0rdf0rl0g1n53rv3r'; -- create loginserver user

FLUSH PRIVILEGES; -- just for sure

and then use username "gameserver" in gameserver and "loginserver" in loginserver... (look in gameserver.properties and loginserver.properties)

 

Elementary, my dear Watson

 

EDIT: sorry, I had 'l2j' in the grant query instead of 'loginserver' / 'gameserver' - now it should be ok

Edited November 28, 2016 by eressea

[AccessDenied]

First, you've probably set some password when installing MySQL.

Second, you shouldn't use root (administrator) MySQL account for running l2j - you should create another user, eg. run this under root:

 

GRANT ALL PRIVILEGES ON gameserver.* TO l2j@localhost IDENTIFIED BY 's0m3n3wp455w0rdf0rg4m353rv3r'; -- create gameserver user

GRANT ALL PRIVILEGES ON loginserver.* TO l2j@localhost IDENTIFIED BY 's0m3n3wp455w0rdf0rl0g1n53rv3r'; -- create loginserver user

FLUSH PRIVILEGES; -- just for sure

 

and then use username "gameserver" in gameserver and "loginserver" in loginserver... (look in gameserver.properties and loginserver.properties)

 

Elementary, my dear Watson

 

Ohhhhhhhh dear god, help us... 

[eressea]

Ohhhhhhhh dear god, help us... 

 

Wut? oO

[camolus]

Thanks for respond^^ Here is my next issue:

[00:42:07] LoginController: Loading LoginController...

[00:42:07] LoginController: Cached 10 KeyPairs for RSA communication

[00:42:07] LoginController: Stored 20 keys for Blowfish communication

[00:42:07] GameServerTable: GameServerTable: Loaded 127 server names

[00:42:07] GameServerTable: GameServerTable: Loaded 0 registered Game Servers

[00:42:07] GameServerTable: GameServerTable: Cached 10 RSA keys for Game Server communication.

[00:42:07] L2LoginServer: Loaded 2 IP Bans.

[00:42:07] L2LoginServer: Listening for GameServers on 127.0.0.1:9014

[00:42:07] L2LoginServer: L2LoginServer: is now listening on: *:2106

[00:42:07] UPnPService: Looking for UPnP Gateway Devices...

[00:42:07] UPnPService: Using UPnP gateway: FRITZ!Box 7490 (UI)

[00:42:07] UPnPService: Using local address: 192.168.178.25 External address: 84.186.194.188

[00:42:07] UPnPService: Mapping failed on [192.168.178.25:2106] - Already mapped?

Edited November 28, 2016 by camolus

[AccessDenied]

Thanks for respond^^ Here is my next issue:

The port that loginserver is listening to is already used by other software. 

[camolus]

LoginServer.properties 

Default: 2106

LoginserverPort = 2106

 

 

netstat -a

TCP    192.168.178.25:2106    ec2-54-76-88-165:http  CLOSE_WAIT

 

 

http://www.speedguide.net/port.php?port=2106

2106 = l2.exe & l2j

 

My server status: 

https://www.youtube.com/watch?v=h7KPxCk-7mQ

Edited November 29, 2016 by camolus

[eressea]

You have two possible choices:

 

1. Wait until the closed socket expires

2. Fix l2j code to reuse the closed socket - find all occurrences of "new ServerSocket();" and then (right on the next line) add call "socket.setReuseAddress(true);" on that socket

Edited November 29, 2016 by eressea