Need some help.

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? :confused:

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

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 [Only registered and activated users can see links. Click Here To Register...], but i took a login and gameserver from another website that was 2.7.

Quote:

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 .

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

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.

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

[Only registered and activated users can see links. Click Here To Register...]