[Request] Help setting up Dedicated server

[l2link]

Hey Guys , have had home l2j server for 4 or 5 months now and want to put a Hellbound server on a dedicated host which I have now.

 

However can not get Diskw to work on dedicated host and login / gamserver files do not run...

 

Can anyone help set me set up a testing server on my dedicated host or if any dev's want to use my server for testing they can...

 

L2link

 

PM me

 

 

[Hax0r]

Well, if .bat(s) can't run...you prolly can't set up the server.

[l2link]

Sorry what I ment to say is they run but with errors.... When I set up servers from my house is easy just 1 2 3 click and have set up one without 123 click from home pc no problem.

 

For some reason it is not creating the diskw and getting error when I try to create database... I think it is something easy... If anyone has a pack they want to install on my host let me know...

[Hax0r]

Mysql server running?

[l2link]

Yes... I have tried with and without depending on if it is a 1 2 3 click or where you install the database and hexid.... not sure if there is a path problem, secutity problem, or disk managment problem where can not install disk w?

 

 

Login server has the following which has a sql error but is the same with sql installed...

 

Starting L2J Login Server.

 

INFO : loading login config

INFO : MLog clients using log4j logging.

INFO : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace

: 10]

INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ jav

a.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [num

ThreadsAwaitingCheckoutDefaultUser] ]

WARN : SQL Error: 0, SQLState: 08S01

ERROR : Communications link failure

 

Last packet sent to the server was 0 ms ago.

WARN : Could not obtain connection metadata com.mysql.jdbc.exceptions.jdbc4.Comm

unicationsException: Communications link failure

 

Last packet sent to the server was 0 ms ago.

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1

074)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:283)

        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag

erDataSource.java:119)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:143)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:132)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu

tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled

ConnectionPool(C3P0PooledConnectionPoolManager.java:696)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:257)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:271)

        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A

bstractPoolBackedDataSource.java:128)

        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.

getConnection(LocalDataSourceConnectionProvider.java:81)

        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:

84)

        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009

)

        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav

a:1292)

        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSession

Factory(LocalSessionFactoryBean.java:804)

        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi

onFactory(LocalSessionFactoryBean.java:744)

        at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr

opertiesSet(AbstractSessionFactoryBean.java:131)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:429)

        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb

ject(AbstractBeanFactory.java:250)

        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr

y.getSingleton(DefaultSingletonBeanRegistry.java:141)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:247)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:161)

        at org.springframework.beans.factory.support.DefaultListableBeanFactory.

preInstantiateSingletons(DefaultListableBeanFactory.java:270)

        at org.springframework.context.support.AbstractApplicationContext.refres

h(AbstractApplicationContext.java:346)

        at org.springframework.context.support.ClassPathXmlApplicationContext.<i

nit>(ClassPathXmlApplicationContext.java:92)

        at org.springframework.context.support.ClassPathXmlApplicationContext.<i

nit>(ClassPathXmlApplicationContext.java:77)

        at net.sf.l2j.L2Registry.loadRegistry(L2Registry.java:65)

        at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:104)

        at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)

Caused by: java.net.ConnectException: Connection refused: connect

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(Unknown Source)

        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

        at java.net.PlainSocketImpl.connect(Unknown Source)

        at java.net.SocksSocketImpl.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at java.net.Socket.<init>(Unknown Source)

        at java.net.Socket.<init>(Unknown Source)

        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja

va:256)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)

        ... 38 more

 

INFO : Loaded 127 server names

INFO : LoginManager initiating

INFO : Cached 10 KeyPairs for RSA communication

INFO : RandomIntGenerator: initialized

INFO : Stored 20 keys for Blowfish communication

WARN : SQL Error: 0, SQLState: 08S01

ERROR : Communications link failure

 

Last packet sent to the server was 0 ms ago.

WARN : SQL Error: 0, SQLState: 08S01

ERROR : Communications link failure

 

Last packet sent to the server was 0 ms ago.

Exception in thread "main" org.springframework.transaction.CannotCreateTransacti

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.convert(JDBCExceptionHelp

er.java:43)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:29)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager

.java:424)

        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.

java:144)

        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)

        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:

57)

        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326

)

        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi

n(HibernateTransactionManager.java:497)

        at org.springframework.transaction.support.AbstractPlatformTransactionMa

nager.getTransaction(AbstractPlatformTransactionManager.java:349)

        at org.springframework.transaction.interceptor.TransactionAspectSupport.

createTransactionIfNecessary(TransactionAspectSupport.java:255)

        at org.springframework.transaction.interceptor.TransactionInterceptor.in

voke(TransactionInterceptor.java:102)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

ReflectiveMethodInvocation.java:176)

        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc

eptor.intercept(Cglib2AopProxy.java:616)

        at net.sf.l2j.loginserver.services.GameserversServices$$EnhancerByCGLIB$

$f56dd62a.getAllGameservers(<generated>)

        at net.sf.l2j.loginserver.manager.GameServerManager.load(GameServerManag

er.java:208)

        at net.sf.l2j.loginserver.manager.GameServerManager.<init>(GameServerMan

ager.java:111)

        at net.sf.l2j.loginserver.manager.GameServerManager.getInstance(GameServ

erManager.java:82)

        at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:113)

        at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communicatio

ns link failure

 

Last packet sent to the server was 0 ms ago.

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1

074)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:283)

        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag

erDataSource.java:119)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:143)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:132)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu

tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled

ConnectionPool(C3P0PooledConnectionPoolManager.java:696)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:257)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:271)

        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A

bstractPoolBackedDataSource.java:128)

        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.

getConnection(LocalDataSourceConnectionProvider.java:81)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager

.java:421)

        ... 16 more

Caused by: java.net.ConnectException: Connection refused: connect

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(Unknown Source)

        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

        at java.net.PlainSocketImpl.connect(Unknown Source)

        at java.net.SocksSocketImpl.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at java.net.Socket.<init>(Unknown Source)

        at java.net.Socket.<init>(Unknown Source)

        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja

va:256)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)

        ... 35 more

 

Server terminated abnormaly

 

 

server terminated

 

Press any key to continue . . .

[Hax0r]

It's not even connected to the MySQL server(?)

Java JDK/JRE installed?

MySQL server is on localhost?

Machine's OS?

[l2link]

Java JDK 6 update 11 is installed. The dedicated server is running Windows 2003 Server revision 2. Everthing works perfect from home pc. When I install Mysql it say's can not install as a service.

[Hax0r]

That's the problem...try to communicate with the company.

Or if u have remote control access.-->

Right click on My Computer>Manage

-Expand Services and Applications

-Select Services

-Find "MySQL" service and start it.

[l2link]

Yes I have remote access. Tried that however it say's  Could not start the Mysql service on local computer. Error 1067: The process terminated unexpetcantly.... ?

[l2link]

OK not a double post 6 days from previous post. Found out the problem was a bug in Mysql. Have it fixed now and server running on a dedicated host however only testing at the moment. If anyone needs help on to to put a pack on a dedicated host pm me....

 

Later

 

L2link....

 

P.S. Thanks for the help....

[Hax0r]

Just outta curiosity could you post what the problem was?