GameServer and LoginServer SQLException.

[LilPeachie]

I cannot figure out this error that I'm receiving on my server. I cannot get the GameServer or the LoginServer to boot up. Chat server boots up just fine but I think that might be because the chat server does not use the database? anyways here is my console output for the DATABASE section.

Here is my entire console output. Any help would be greatly appreciated :)

Starting Aion Lightning Game Server in PRODUCTION mode.
13:52:03.498 INFO [main]: - JavaAgent [Callback Support] is configured.
=========================[ ===========CRON========== ]=========================
13:52:03.538 INFO [main]: - Using default implementation for ThreadExecutor
13:52:03.557 INFO [main]: - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
13:52:03.558 INFO [main]: - Quartz Scheduler v.2.1.7 created.
13:52:03.561 INFO [main]: - RAMJobStore initialized.
13:52:03.564 INFO [main]: - Scheduler meta-data: Quartz Scheduler (v2.1.7) 'QuartzScheduler' with instanceId 'NON_CLUSTERED'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 1 threads.
Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

13:52:03.564 INFO [main]: - Quartz scheduler 'QuartzScheduler' initialized from an externally provided properties instance.
13:52:03.564 INFO [main]: - Quartz scheduler version: 2.1.7
13:52:03.564 INFO [main]: - Scheduler QuartzScheduler_$_NON_CLUSTERED started.
========================[ ===========CONFIG========== ]========================
13:52:03.566 INFO [main]: - Loading: mygs.properties
13:52:03.567 INFO [main]: - No override properties found
===============================[ ADMINISTRATION ]===============================
13:52:03.594 INFO [main]: - Loading: ./config/administration/admin.properties
13:52:03.595 INFO [main]: - Loading: ./config/administration/developer.properties
====================================[ MAIN ]====================================
13:52:03.608 INFO [main]: - Loading: ./config/main/ai.properties
13:52:03.611 INFO [main]: - Loading: ./config/main/autogroup.properties
13:52:03.612 INFO [main]: - Loading: ./config/main/commons.properties
13:52:03.612 INFO [main]: - Loading: ./config/main/cache.properties
13:52:03.613 INFO [main]: - Loading: ./config/main/cleaning.properties
13:52:03.615 INFO [main]: - Loading: ./config/main/craft.properties
13:52:03.621 INFO [main]: - Loading: ./config/main/custom.properties
13:52:03.623 INFO [main]: - Loading: ./config/main/drop.properties
13:52:03.624 INFO [main]: - Loading: ./config/main/enchants.properties
13:52:03.625 INFO [main]: - Loading: ./config/main/events.properties
13:52:03.626 INFO [main]: - Loading: ./config/main/falldamage.properties
13:52:03.627 INFO [main]: - Loading: ./config/main/fasttrack.properties
13:52:03.629 INFO [main]: - Loading: ./config/main/gameserver.properties
13:52:03.631 INFO [main]: - Loading: ./config/main/geodata.properties
13:52:03.632 INFO [main]: - Loading: ./config/main/group.properties
13:52:03.634 INFO [main]: - Loading: ./config/main/housing.properties
13:52:03.635 INFO [main]: - Loading: ./config/main/html.properties
13:52:03.636 INFO [main]: - Loading: ./config/main/ingameshop.properties
13:52:03.642 INFO [main]: - Loading: ./config/main/legion.properties
13:52:03.644 INFO [main]: - Loading: ./config/main/logging.properties
13:52:03.648 INFO [main]: - Loading: ./config/main/membership.properties
13:52:03.649 INFO [main]: - Loading: ./config/main/name.properties
13:52:03.650 INFO [main]: - Loading: ./config/main/periodicsave.properties
13:52:03.651 INFO [main]: - Loading: ./config/main/playertransfer.properties
13:52:03.653 INFO [main]: - Loading: ./config/main/prices.properties
13:52:03.657 INFO [main]: - Loading: ./config/main/punishment.properties
13:52:03.658 INFO [main]: - Loading: ./config/main/ranking.properties
13:52:03.664 INFO [main]: - Loading: ./config/main/rates.properties
13:52:03.666 INFO [main]: - Loading: ./config/main/security.properties
13:52:03.667 INFO [main]: - Loading: ./config/main/shutdown.properties
13:52:03.668 INFO [main]: - Loading: ./config/main/siege.properties
13:52:03.669 INFO [main]: - Loading: ./config/main/thread.properties
13:52:03.672 INFO [main]: - Loading: ./config/main/weddings.properties
13:52:03.673 INFO [main]: - Loading: ./config/main/world.properties
13:52:03.673 INFO [main]: - Loading: ./config/main/veteran_rewards.properties
==================================[ NETWORK ]==================================
13:52:03.674 INFO [main]: - Loading: ./config/network/database.properties
13:52:03.678 INFO [main]: - Loading: ./config/network/network.properties
========================[ =========================== ]========================
========================[ ==========DATABASE========= ]========================
13:52:03.958 ERROR[main]: - Error while creating DB Connection pool
java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/al_server_gs?useUnicode=true&characterEncoding=UTF-8, username = AionServer. Terminating connection pool. Original Exception: ------
java.sql.SQLException: Unexpected exception encountered during query.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3868)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3407)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2384)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
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 Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256)
at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:305)
at com.aionemu.commons.database.DatabaseFactory.init(DatabaseFactory.java:104)
at com.aionemu.gameserver.GameServer.initUtilityServicesAndConfig(GameServer.java:253)
at com.aionemu.gameserver.GameServer.main(GameServer.java:277)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 255
at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3100)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
... 22 more
------

at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:312) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at com.aionemu.commons.database.DatabaseFactory.init(DatabaseFactory.java:104) ~[al-commons.jar:na]
at com.aionemu.gameserver.GameServer.initUtilityServicesAndConfig(GameServer.java:253) [AL-Game.jar:na]
at com.aionemu.gameserver.GameServer.main(GameServer.java:277) [AL-Game.jar:na]
Caused by: java.sql.SQLException: Unexpected exception encountered during query.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2664) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3868) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3407) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2384) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.18.jar:na]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_80]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_80]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_80]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_80]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[mysql-connector-java-5.1.18.jar:na]
at java.sql.DriverManager.getConnection(Unknown Source) ~[na:1.7.0_80]
at java.sql.DriverManager.getConnection(Unknown Source) ~[na:1.7.0_80]
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:305) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
... 3 common frames omitted
Caused by: java.lang.ArrayIndexOutOfBoundsException: 255
at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3100) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618) ~[mysql-connector-java-5.1.18.jar:na]
... 22 common frames omitted
13:52:03.961 ERROR[main]: - Critical Error - Thread: main terminated abnormaly: java.lang.Error: DatabaseFactory not initialized!
java.lang.Error: DatabaseFactory not initialized!
at com.aionemu.commons.database.DatabaseFactory.init(DatabaseFactory.java:107) ~[al-commons.jar:na]
at com.aionemu.gameserver.GameServer.initUtilityServicesAndConfig(GameServer.java:253) ~[AL-Game.jar:na]
at com.aionemu.gameserver.GameServer.main(GameServer.java:277) ~[AL-Game.jar:na]
Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/al_server_gs?useUnicode=true&characterEncoding=UTF-8, username = AionServer. Terminating connection pool. Original Exception: ------
java.sql.SQLException: Unexpected exception encountered during query.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3868)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3407)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2384)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
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 Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256)
at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:305)
at com.aionemu.commons.database.DatabaseFactory.init(DatabaseFactory.java:104)
at com.aionemu.gameserver.GameServer.initUtilityServicesAndConfig(GameServer.java:253)
at com.aionemu.gameserver.GameServer.main(GameServer.java:277)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 255
at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3100)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
... 22 more
------

at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:312) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at com.aionemu.commons.database.DatabaseFactory.init(DatabaseFactory.java:104) ~[al-commons.jar:na]
... 2 common frames omitted
Caused by: java.sql.SQLException: Unexpected exception encountered during query.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2664) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3868) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3407) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2384) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.18.jar:na]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_80]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_80]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_80]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_80]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[mysql-connector-java-5.1.18.jar:na]
at java.sql.DriverManager.getConnection(Unknown Source) ~[na:1.7.0_80]
at java.sql.DriverManager.getConnection(Unknown Source) ~[na:1.7.0_80]
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:305) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
... 3 common frames omitted
Caused by: java.lang.ArrayIndexOutOfBoundsException: 255
at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3100) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618) ~[mysql-connector-java-5.1.18.jar:na]
... 22 common frames omitted

[MentaL]

[Robyson]

I cannot figure out this error that I'm receiving on my server. I cannot get the GameServer or the LoginServer to boot up. Chat server boots up just fine but I think that might be because the chat server does not use the database? anyways here is my console output for the DATABASE section.

Here is my entire console output. Any help would be greatly appreciated :)

There are some tutorials here on the forum, you searched?

This is an example https://forum.ragezone.com/f588/aion...7-5-a-1073648/

[cinus]

There are some tutorials here on the forum, you searched?

This is an example https://forum.ragezone.com/f588/aion...7-5-a-1073648/

Even on youtube are like a 20 or more .
From experience i know people always want make it fast skipping something ..But important is be patient and fallow instruction .
https://www.youtube.com/watch?v=Y0GdmvmzTAE

[LilPeachie]

There are some tutorials here on the forum, you searched?

This is an example https://forum.ragezone.com/f588/aion...7-5-a-1073648/

I've done this exactly and nothing seems to be working. I've tried to follow this tutorial a couple times starting completely from scratch but nothing seems to help.

Even on youtube are like a 20 or more .
From experience i know people always want make it fast skipping something ..But important is be patient and fallow instruction .
https://www.youtube.com/watch?v=Y0GdmvmzTAE

I'll give this a try and report back.

- - - Updated - - -

Even on youtube are like a 20 or more .
From experience i know people always want make it fast skipping something ..But important is be patient and fallow instruction .
https://www.youtube.com/watch?v=Y0GdmvmzTAE

even after following the video tutorial to a 'T'. I'm still receiving the same error up to trying to launch the LoginServer at 7:22 on the video. I've done everything exactly as shown in the video as I watched it.

- - - Updated - - -

UPDATE: IDK wtf i did but it works now. I restarted my PC so i guess something was running (or not running) that shouldn't have been (or should have been)