Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team
  • 0

L2Junity Loginserver [Error]

camolus

Asked by camolus,

 Share

Question

camolus Newbie

camolus

Posted
Posted (edited)
[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 by camolus

8 answers to this question

Recommended Posts

  • 0
AccessDenied Newbie

AccessDenied

Posted
Posted

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

  • 0
eressea Newbie

eressea

Posted
Posted (edited)

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 by eressea
  • 0
AccessDenied Newbie

AccessDenied

Posted
Posted

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

  • 0
camolus Newbie

camolus

Posted
  • Author
Posted (edited)

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 by camolus
  • 0
camolus Newbie

camolus

Posted
  • Author
Posted (edited)

LoginServer.properties 

Default: 2106
LoginserverPort = 2106

 

 

netstat -a

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

 

 

2106 = l2.exe & l2j
 
My server status: 
Edited by camolus
  • 0
eressea Newbie

eressea

Posted
Posted (edited)

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 by eressea

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing


  • Posts

    • SmurfsZone
      SmurfsZone: Your Best Source for League of Legend

      By SmurfsZone · Posted

      This is a bump
    • Splicho
      Web Services, Auto-Updater, Discord Logo.

      By Splicho · Posted

      Lol good joke.   If I'd be the one contacting yo then I'd say at least 50% in advance because you can basically just fuck off when things doesn't go your way, and then you as a developer just wasted days or even weeks of time with development.
    • Mobius
      aCis - another CRAPPY interlude server

      By Mobius · Posted

      "Just make your own game!" sounds simple until you’ve tried it. I did, with Epic Dragon World and learned the hard way that "open source" often means "free labor for resellers." The MIT license became a buffet for people to grab code, rebrand it and ghost the project. Even basic collaboration collapsed because everyone wanted their vision, not *a* vision. NCSoft’s lawyers aren’t theoretical. They’re a sword of Damocles. Even if you rebuild a client from scratch, if it feels like Lineage 2, they’ll come knocking. Ask the Chrono Trigger fangame corpses how that goes. MMOs are hospice care. The genre’s on life support, kept alive by whales and nostalgia. Look at Throne and Liberty, NCSoft’s own "successor" to L2, flopping harder than a 2004 PKer in ToI. Classic reboots (WoW, L2) are bandaids, not resurrections. This is the hobby. Optimizing old systems, reverse-engineering spaghetti code and preserving janky mechanics is the fun part. Monetizing it turns it into customer service hell. No thanks. Community? What community? The L2 scene is 90% resellers, 10% players who’ll quit the second they don’t get +16 on day one. Both asking how to install Java and why running the uncompiled server does not work.
    • MarGaZeaS
      Web Services, Auto-Updater, Discord Logo.

      By MarGaZeaS · Posted

      trusted panel i use in 10+ servers
    • Noveria
      [L2PTS] Elmorelab

      By Noveria · Posted

      Dear players, Open beta test for C3 begins today at 19:00 server time (GMT +2). 💰 All participants who find bugs during OBT will be rewarded with Coin of Luck (CoL): - 1 CoL for each staticmesh issue found — e.g., walking through textures, etc., - 2 CoL or more for server-side issues, depending on their severity., We strongly recommend reviewing the quest list - when switching to Chronicle 3, the total number of quests should match the number shown in the upper right corner of the window and correspond to the quest count from Chronicle 2. To log into the game, use the same data you use to access the Airin server. 📌 Download client: Google Drive

  • 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