Help RegisterGameServer error

[Grosniuhas]

Hello everyone,

 

So 10 years ago i have had a project and now because of nostalgic feelings wan't to run server and see how l2j world has been changed since then...

 

Getting back to the topic:

I'm trying to run latest free aCis server but receiving error while running RegisterGameServer (keep in mind that database has been imported smoothly)

 

Here's the error that I'm receiving:

                        aCis gameserver registering
                        ____________________________

OPTIONS : a number : register a server ID, if available and existing on list.
          list : get a list of IDs. A '*' means the id is already used.
          clean : unregister a specified gameserver.
          cleanall : unregister all gameservers.
          exit : exit the program.

Your choice? 1

Exception in thread "main" java.lang.ExceptionInInitializerError
        at net.sf.l2j.L2DatabaseFactory$SingletonHolder.<clinit>(L2DatabaseFacto
ry.java:164)
        at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:32)
        at net.sf.l2j.loginserver.GameServerTable.loadRegisteredGameServers(Game
ServerTable.java:110)
        at net.sf.l2j.loginserver.GameServerTable.<init>(GameServerTable.java:57
)
        at net.sf.l2j.loginserver.GameServerTable$SingletonHolder.<clinit>(GameS
erverTable.java:399)
        at net.sf.l2j.loginserver.GameServerTable.getInstance(GameServerTable.ja
va:391)
        at net.sf.l2j.gsregistering.GameServerRegister.main(GameServerRegister.j
ava:143)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
 Could not create connection to database server.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
568)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:346)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:131)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:161)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:147)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:987)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:910)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:397)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:414)
        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:145)
        at net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:81)
        at net.sf.l2j.L2DatabaseFactory$SingletonHolder.<clinit>(L2DatabaseFacto
ry.java:160)
        ... 6 more
Caused by: java.lang.NullPointerException
        at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionIm
pl.java:3279)
        at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1940)
        at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(My
sqlIO.java:1866)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
519)
        ... 26 more
Press any key to continue . . .

EDIT: sorry forgot to mention machines details:

OS - Windows Server 2012 R2

Java JDK 8

 

Any help will be appreciated.

 

Thank you.

 

Edited January 8, 2019 by Grosniuhas

[SweeTs]

2 hours ago, Grosniuhas said:

Could not create connection to database server.

Errors says it all.

[Kara]

8 hours ago, SweeTs said:

Errors says it all.

He felt nostalgia for Lineage 2 so instead of download a system and join a low rate - mid rate he open server to use //gmspeed 3 

 

Ontopic: You didn't install database or your db settings are wrong.

[Grosniuhas]

9 hours ago, SweeTs said:

Errors says it all.

Thank you SweeTs, have missed that - Top man!

 

38 minutes ago, Kara` said:

He felt nostalgia for Lineage 2 so instead of download a system and join a low rate - mid rate he open server to use //gmspeed 3 

  

Ontopic: You didn't install database or your db settings are wrong.

I made it clear that i wan't to check how L2j has changed not L2 in general.

All database tables are in - checked...

[Tryskell]

It's definitively a miss on connection parameters (if you successfully added tables). Check your LS and GS configs regarding it. Db name, user and password must be correct.

 

Caused by: java.lang.NullPointerException
        at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionIm
pl.java:3279)

You probably used exotic charset. Try to use regular alphanumerical stuff.

Edited January 9, 2019 by Tryskell

[Grosniuhas]

7 hours ago, Tryskell said:

It's definitively a miss on connection parameters (if you successfully added tables). Check your LS and GS configs regarding it. Db name, user and password must be correct.

 

Caused by: java.lang.NullPointerException
        at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionIm
pl.java:3279)

You probably used exotic charset. Try to use regular alphanumerical stuff.

 

Thank you for your replay!

 

So i have fixed it by doing everything from scratched as i could't identify problem(everything seemed to be as it should) only this time i have done few things differently:

*Used older version of MySQL server(previously used newest, now 5.7)

*Used other version of Eclipse

*Used older version of SVN

*Used database name acis(previously l2jdb - even thought i have changed it everywhere on previous installation)

*Used simple password for database "example"(Previously used "ExampeExample123)

 

So as i said previously i don't know what caused problem even you have identified and suggested fix for the error. I can only guess that database name for some reason has caused the problem as well as it's password - maybe.

 

Anyway - thank you a lot for your time and suggestions/solutions! Much appreciated!

 

[Tryskell]

There's probably a link between the mySQL you were using, and the mySQL connector which is kinda old.

 

Cool for you it works :).