Need some help.

[Mozone20]

Don't really know where to put this, but i'm trying to make a private server using Java, Nivicat, and MySQL. But i'm getting alot of java errors....Any help?

[InPanic Kev]

screens ? if yes i can help u maybe ...

[Mozone20]

Starting Aion X Emu Login Server.

================================================== =================-[ Network ]
[INFO] 2012-01-10 04:48:57 - Loading: ./config/network/network.properties
[INFO] 2012-01-10 04:48:57 - Loading: ./config/network/database.properties
================================================== ================-[ DataBase ]
[FATAL] 2012-01-10 04:49:03 - Error with connection string: jdbc:mysql://localho
st:3306/aionx_ls?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientC onnectionException: Could not
create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:929)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(C onnectionImpl.java:
2226)
at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2127)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:774)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion.java:49)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:375)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:289)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.apache.commons.dbcp.DriverManagerConnectionFac tory.createConnecti
on(DriverManagerConnectionFactory.java:75)
at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(Poolable
ConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.bor rowObject(GenericOb
jectPool.java:1158)
at org.apache.commons.dbcp.PoolingDataSource.getConne ction(PoolingDataSo
urce.java:106)
at com.aionemu.commons.database.DatabaseFactory.getCo nnection(DatabaseFa
ctory.java:174)
at com.aionemu.commons.database.DatabaseFactory.init( DatabaseFactory.jav
a:129)
at loginserver.LoginServer.main(LoginServer.java:53)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown da
tabase 'aionx_ls'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 4004)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 84)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(C onnectionImpl.java:
2172)
... 19 more
Exception in thread "main" java.lang.Error: DatabaseFactory not initialized!
at com.aionemu.commons.database.DatabaseFactory.init( DatabaseFactory.jav
a:138)
at loginserver.LoginServer.main(LoginServer.java:53)

Login Server Terminated Abnormaly, Please Verify Your Files.


Login Server Terminated.

Press any key to continue . . .
Starting Aion X Emu Game Server.

================================================== ================-[ DataBase ]
[FATAL] 2012-01-10 04:50:46 - Error with connection string: jdbc:mysql://localho
st:3306/aionx_gs?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientC onnectionException: Could not
create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:929)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(C onnectionImpl.java:
2226)
at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2127)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:774)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion.java:49)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:375)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:289)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.apache.commons.dbcp.DriverManagerConnectionFac tory.createConnecti
on(DriverManagerConnectionFactory.java:75)
at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(Poolable
ConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.bor rowObject(GenericOb
jectPool.java:1158)
at org.apache.commons.dbcp.PoolingDataSource.getConne ction(PoolingDataSo
urce.java:106)
at com.aionemu.commons.database.DatabaseFactory.getCo nnection(DatabaseFa
ctory.java:174)
at com.aionemu.commons.database.DatabaseFactory.init( DatabaseFactory.jav
a:129)
at com.aionemu.commons.database.DatabaseFactory.init( DatabaseFactory.jav
a:89)
at gameserver.GameServer.initUtilityServicesAndConfig (GameServer.java:27
3)
at gameserver.GameServer.main(GameServer.java:96)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usi
ng password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 4004)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 84)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(C onnectionImpl.java:
2172)
... 21 more
[ERROR] 2012-01-10 04:50:46 - 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.jav
a:138)
at com.aionemu.commons.database.DatabaseFactory.init( DatabaseFactory.jav
a:89)
at gameserver.GameServer.initUtilityServicesAndConfig (GameServer.java:27
3)
at gameserver.GameServer.main(GameServer.java:96)

Server is terminated abnormaly ...


Server is terminated ...

Press any key to continue . . .

Im using the guide here , but i took a login and gameserver from another website that was 2.7.

[InPanic Kev]

Originally Posted by Mozone20

Error with connection string: jdbc:mysql://localho
st:3306/aionx_ls

1. Check the Default cfg
2. Check the Database .

So the error is the login Server cant connect to the database cuz the informations are wrong .

[Mozone20]

# This class represents database driver class that will be used while connecting to database
database.driver = com.mysql.jdbc.Driver

# This is database url.
database.url = jdbc:mysql://localhost:3306/aionx_ls?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true

# Database user
database.user = root

# Database password
# Write your password here!
database.password = mokiller20

# Minimum amount of database connections that will allways in the pool
database.connections.min = 5

# Maximum amount of DB connections that server can use
database.connections.max = 10

# Script context that will be loaded by database factory, it should implement DAO instances
database.scriptcontext.descriptor = ./data/scripts/system/database.xml# LoginServer will listen for connections on specified port
loginserver.network.client.port = 3306
# LoginServer will bind specified network interface
# * - bind all interfaces
loginserver.network.client.host = *

# How many times player can try to login before he get's banned for bruteforcing
loginserver.network.client.logintrybeforeban = 5

# For what time in minutes player should be banned in case of bruteforcing
loginserver.network.client.bantimeforbruteforcing = 15

# Host that will be used by LS to listen for GS connections
loginserver.network.gameserver.host = *

# Port that will be used by LS to listen for GS connections
loginserver.network.gameserver.port = 3306

# Nuber of additional threads for NIO that will handle only reading
loginserver.network.nio.threads.read = 0

# Nuber of additional threads for NIO that will handle only writing
loginserver.network.nio.threads.write = 0

# Create accounts automatically or not? -- You do not need a website / CMS if set true
loginserver.accounts.autocreate = true
Gameserver: # ===================================
# DATABASE
# ===================================

# JDBC driver to use
database.driver = com.mysql.jdbc.Driver

# JDBC database URL
database.url = jdbc:mysql://localhost:3306/aionx_gs?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true

# Database user
database.user = root

# Database password
database.password = mokiller20

# JDBC Connection Pool minimum size (concurrent connections)
database.connections.min = 5

# JDBC Connection Pool maximum size
database.connections.max = 10

# DAO Scripts context file
database.scriptcontext.descriptor = ./data/scripts/system/database.xml

# ===================================
# NETWORK
# ===================================

# GameServer ID
gameserver.network.login.gsid = 3306

# GameServer bind IP address (* for all available IP)
gameserver.network.client.host = *

# GameServer bind TCP port
gameserver.network.client.port = 3306

# RDC (Remote Data Call) bind IP address
gameserver.network.rdc.client.host = *

# RDC bind TCP port
gameserver.network.rdc.client.port = 3306

# Online players limit
gameserver.network.client.maxplayers = 1000

# Required access level to enter gameserver
# If set to bigger than 0 only GM's are able to connect
# and normal players can't see server on serverlist
# Default = 0
gameserver.network.client.requiredlevel = 0

# LoginServer location
gameserver.network.login.address = localhost:3306

# LoginServer password for this GameServer
gameserver.network.login.password = mokiller20

# ChatServer location
gameserver.network.chat.address = localhost:3306

# ChatServer password for this ChatServer
gameserver.network.chat.password = mokiller20

# Enable debug information from network layer
gameserver.network.nio.debug = true

# Additional threads that are used to read network data
gameserver.network.nio.threads.read = 1

# Number of retries to do when reading a packet
gameserver.network.nio.threads.read.retries = 8

# Additional threads that are used to write network data
gameserver.network.nio.threads.write = 1

# Number of retries to do when writing a packet
gameserver.network.nio.threads.write.retries = 8

# Enable additional threads (workers) to handle data processing
gameserver.network.nio.threads.workers.enable = true

# Number of workers
gameserver.network.nio.threads.workers = 1

# Number of buffers by worker
gameserver.network.nio.threads.workers.buffers = 16

# Display/hide unknown packets received by server
gameserver.network.display.unknownpackets = false

# ===================================
# GAMESERVER
# ===================================

# GameServer Name
gameserver.name = Aion PTS

# Pattern for player names validation
# To enable UTF support for names - set this parameter to [a-zA-Z\u0410-\u042f\u0430-\u044f]{2,16}
gameserver.character.name.pattern = [a-zA-Z\u0410-\u042f\u0430-\u044f]{2,20}

# Server Country Code (cc)
gameserver.country.code = 1

# Server Version
gameserver.version = 2.7.0.1

# Server Mode
# 1 = user can create characters from both factions
# 34 = user is bound to a faction, can't create more than 2 characters and can't enter the game world (character reservation mode)
# 128 = user is bound to a faction (can't create characters from both factions at the same time)
gameserver.mode = 1

# Disable chat server connection
gameserver.disable.chatserver = true

# Disable the RDC server
gameserver.disable.rdcserver = false

# Display the server revision in player MOTD
# SHALL BE DISABLED ON UNIX SERVERS
gameserver.motd.revision.display = true

# Enable ratios limitation
gameserver.factions.ratio.limited = false

# When a faction ratio reach this value, it's not possible to create new characters of this faction
gameserver.factions.ratio.value = 50

# Minimum character level to take into account in ratio calculation
gameserver.factions.ratio.level = 10

# Minimum characters count in each faction needed before limiting ratios
gameserver.factions.ratio.minimum = 50

# Enable server freefly
gameserver.enable.freefly = false

# Log chat?
gameserver.log.chat = false

# Log item?
gameserver.log.item = false

# Language
gameserver.lang = "en" Im very new to this, if there is a easy way plz tell>.< ty in advance.

[ant2012]

I have the exact same issue. I do not know enough to establish if it is my port forwarding address from the ipconfig file or if it is the password for the data base in msql.

[dallas_extreme]

First of all Aion X Emu is not 2.7, it was never more then 2.1, but anyway....
Second, the better way to setup your IP (LAN for Localhost, WAN for Internet) is to repleace the "*" with your real IP.

Third, check if your Database match the; Gameserver Id, IP and Password you setup in the config files.


For example: (Loginserver/Gameservers table)

ID= 100
Mask:192.168.2.2
Password: mokiller20