Okay, so here is the guide I'm going off.
Now, I've done everything that they have said to do, I've actually done this several ways.
First I read it, and edited a few things that I knew how to edit, normally, seeing as how I've hosted a few other servers, such as a world of warcraft, GunZ, Maple Story, and now trying this. I had my issues here and there trying to get each one to come up, but hey, thats what happens right? In the end the result was great, they all came up, I learned a few things, and after I got it up the first time, It ran great!
This is the second server I've tried to host with Java, Maple story being the first, seeing as how I just got that up two days ago..I'm still new with handling Java, but either way. The problem I'm getting is, no matter what I do, or how hard I try, The server refuses to come up, it ALWAYS comes up with "Server terminated abnormally" and of course, shuts down.
Infact..in this guide, it tells you to start the "start.bat" but when I do that, it just brings me to some webpage, that doesnt even work.
After installing this, I had to reinstall MySQL once to get my password working again...It was odd, but not a big deal.
I also tried it EXACTLY how he said to do, not touching anything at all, except for what the guide told me to do, and still the SAME thing.
I also went in there, doing everything he said, making it public as well, and still as said before, no matter what I do, seems to ALWAYS error out, I'm positive the database is installed, I moved it into MySQL and used Navicat to see if it picked up, of course It did.
I even moved the file i had to extract to C: just to make sure i did everything how they said, and once again, it was a error.
I'll send a pic of the config files and error message that is comming up, maybe someone can help me.
Loginserver.properties
Quote:
# General login server setting !!! REQUIRED to configure to everyone !!!
# ================================================== ==============
# Bind ip of the loginserver, use 0.0.0.0 to bind on all available IPs
LoginServerHostname=My Hamachi IP
LoginServerPort=2106
GMMinLevel=100
# The port, ip on which login will listen for GameServers
LoginHostname=My Hamachi IP // I even left this alone before, still with the same error.
LoginPort=9014
# If set to true any GameServer can register on your login's free slots
AcceptNewGameServer = False
# If false, the licence (after the login) will not be shown
ShowLicence = True
# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriv er
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=root
# Useable values: "True" - "False", use this option to choose whether accounts will be created
# automatically or not.
AutoCreateAccounts=True
# The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)
# (0 = disable)
IpUpdateTime=0
# ================================================== ============
# Test server setting, shoudnt be touched in online game server
# ================================================== ============
Debug = False
Assert = False
Developer = False
# Enforce GG Authorization from client
# Login server will kick client if client bypassed GameGuard authentication
ForceGGAuth=False
#FloodProtection. time in ms
EnableFloodProtection=True
FastConnectionLimit=15
NormalConnectionTime=700
FastConnectionTime=350
MaxConnectionPerIP=50
#Ban management
# number of attempt before a user is banned when he fails his login
LoginTryBeforeBan=10
# Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600)
LoginBlockAfterBan=600
Server.properties
Quote:
# Usually you have to change the ExternalHostname option to
# - 127.0.0.1 (if you want to play alone / testing purpose)
# - LAN IP* (if you want to play from another computer in the network)
# - WAN IP** (if you want to play with friends over internet)
# - Questions? =>
#
# * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"
# **= If you want to get you WAN IP, visit
# ================================================== =================================================
# ================================================== ==============
# General server setting !!! REQUIRED to configure to everyone !!!
# ================================================== ==============
# Bind ip of the gameserver, use 0.0.0.0 to bind on all available IPs
GameserverHostname=My Hamachi IP // I have even left this alone, just to see
GameserverPort=7777
# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname=My Hamachi IP // I have even left this alone, just to see.
# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname=127.0.0.1
# Define internal networks (10.0.0.0/8,192.168.0.0/16 is default internal networks)
InternalNetworks=
# Define optional networks and router IPs
# IP (200.100.200.100) or fully qualified domain name
# (google.com) that resolves to an IP (use ping to determine if a domain resolves).
# Format: ip,net/mask;ip,net/mask,net/mask
# (mask 192.168.0.0/16 or 192.168.0.0/255.255.0.0 would be 192.168.*.*)
# Note: keep InternalNetworks and OptionalNetworks blank for compatibility with older login server
OptionalNetworks=
# The Loginserver host and port
LoginPort=9014
LoginHost=127.0.0.1 // I've edited this as well, and left it alone.
# This is the server id that the gameserver will request (i.e. 1 is Bartz)
RequestServerID = 1
# If set to true, the login will give an other id to the server if the requested id is allready reserved
AcceptAlternateID = True
# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriv er
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=root
MaximumDbConnections=50
# Datapack root directory, defaults to current directory from which the server is started
#DatapackRoot=H:/workEclipse/L2J Free/trunk/L2_DataPack_IL
# Define character name template
# These ones are regular expressions, visit
# Note: Checking lengths are done server side, but keep it in pattern for future purposes
# Character name ( Default [A-Za-z0-9\-]{3,16} )
CnameTemplate=[A-Za-z0-9\-]{3,16}
# Pet name ( Default [A-Za-z0-9\-]{3,16} )
PetNameTemplate=[A-Za-z0-9\-]{3,16}
# Clan and ally name ( [A-Za-z0-9 \-]{3,16} )
ClanAllyNameTemplate=[A-Za-z0-9 \-]{3,16}
# Title ( [A-Za-z0-9 \-\\[\\]\<\>\(\)\!\|]{3,16} )
TitleTemplate=[A-Za-z0-9 \-\\[\\]\<\>\(\)\!\|]{3,16}
# Maximum number of chars per account - 0 = illimited - default = 7
CharMaxNumber = 7
# Define how many players are allowed to play simultaneously on your server.
MaximumOnlineUsers=100
# Minimum and maximum protocol revision that server allow to connect.
# You must keep MinProtocolRevision <= MaxProtocolRevision.
MinProtocolRevision = 740
MaxProtocolRevision = 746
#---------------------------------------------
# Safe Reboot configuration
#---------------------------------------------
# This will prevent some exploit during restart/shutdown process
SafeReboot = True
# To use following options, SafeReboot must be set to True
# Time in seconds before server complete shutdown/reboot, when
# following striction take effect
SafeRebootTime = 10
# Disable item enchant
SafeRebootDisableEnchant=True
# Disable players teleportations
SafeRebootDisableTeleport=False
# Disable craft and crystallize
SafeRebootDisableCreateItem=False
# Disable trades and shops
SafeRebootDisableTransaction=False
# Disable actions between players
SafeRebootDisablePcIteraction=False
# Disable actions on NPC
SafeRebootDisableNpcIteraction=False
# Network traffic optimization: minimum time between sending char's hp/mp status update packet.
NetworkTrafficOptimization = False
NetworkTrafficOptimizationMs = 1100
# Flood Protection
# if enabled players which send more then PACKETLIMIT packets in PACKETTIMELIMIT ms will get kicked
# warning not tested made a quickhack for squeezed
FloodProtection = False
PacketLimit = 500
PacketTimeLimit = 1100
# ================================================== ==============
# JMX Administration
# ================================================== ==============
# Port to connect with l2jmx, -1 to disable jmx completely
admin_portJMX=-1
# Port to connect to jmx via HTTP, -1 to disable
# disable it if it is not local test
# http adaptor is usefull to see if your server is running with l2jbeans, or to see others beans (JRE, logging)
# It is also possible to use it if you forbid this port for external host, but you have to be sure nobody can reach this url !
admin_portHTTP=-1
# password for keystore_file, the keystore file should be in config folder.
# Comment it or remove the keystore file if you doesn't want to activate secure socket.
#keystore_password=password
# keystore file
# this file is used to store a SSL certificate for your jmx server.
# You have to create it with keytool like this :
# $JAVA_HOME/bin/keytool -genkey -keyalg "RSA" -keystore myKeystore.jks -storepass myPassword -dname "cn=myhost"
# Change myKeystore, myPassword and myhost for your own needs
# You have to give this file to all people that will use l2jmx
#keystore=keystore.jks
Login Server Error
Quote:
WARN : SQL Error: 0, SQLState: 08S01
ERROR : Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.ja
va:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2541)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:421)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:349)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:255)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversService s$$EnhancerByCGLIB$
$8e622b88.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.l oad(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.< init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.g etInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2Logi nServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginS erver.java:77)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
WARN : SQL Error: 0, SQLState: 08S01
ERROR : Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.ja
va:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2541)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:421)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:349)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:255)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversService s$$EnhancerByCGLIB$
$8e622b88.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.l oad(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.< init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.g etInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2Logi nServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginS erver.java:77)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
Exception in thread "main" org.springframework.transaction.CannotCreateTransa cti
onException: Could not open Hibernate Session for transaction; nested exception
is org.hibernate.exception.JDBCConnectionException: Cannot open connection
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connecti
on
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.j
ava:74)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelp
er.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:424)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:349)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:255)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversService s$$EnhancerByCGLIB$
$8e622b88.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.l oad(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.< init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.g etInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2Logi nServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginS erver.java:77)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure d
ue to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.ja
va:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2541)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:421)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:349)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:255)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversService s$$EnhancerByCGLIB$
$8e622b88.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.l oad(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.< init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.g etInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2Logi nServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginS erver.java:77)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2607)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:421)
... 16 more
Server terminated abnormaly
server terminated
Press any key to continue . . .
Game Server Error
Quote:
WARN : SQL Error: 0, SQLState: 08S01
ERROR : Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.ja
va:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2541)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:421)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:349)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:255)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversService s$$EnhancerByCGLIB$
$8e622b88.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.l oad(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.< init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.g etInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2Logi nServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginS erver.java:77)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
WARN : SQL Error: 0, SQLState: 08S01
ERROR : Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.ja
va:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2541)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:421)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:349)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:255)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversService s$$EnhancerByCGLIB$
$8e622b88.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.l oad(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.< init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.g etInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2Logi nServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginS erver.java:77)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
Exception in thread "main" org.springframework.transaction.CannotCreateTransa cti
onException: Could not open Hibernate Session for transaction; nested exception
is org.hibernate.exception.JDBCConnectionException: Cannot open connection
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connecti
on
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.j
ava:74)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelp
er.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:424)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:349)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:255)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversService s$$EnhancerByCGLIB$
$8e622b88.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.l oad(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.< init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.g etInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2Logi nServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginS erver.java:77)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure d
ue to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.ja
va:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2541)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:421)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransa ctionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPl atformTransactionMa
nager.getTransaction(AbstractPlatformTransactionMa nager.java:349)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupp ort.java:255)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$D ynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversService s$$EnhancerByCGLIB$
$8e622b88.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.l oad(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.< init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.g etInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2Logi nServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginS erver.java:77)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2607)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.j ava:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.jav a:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSource ConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.ja va:81)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager
.java:421)
... 16 more
Server terminated abnormaly
server terminated
Press any key to continue . . .
