l2link Posted December 18, 2008 Share Posted December 18, 2008 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 Quote Link to comment Share on other sites More sharing options...
0 Hax0r Posted December 18, 2008 Share Posted December 18, 2008 Well, if .bat(s) can't run...you prolly can't set up the server. Quote Link to comment Share on other sites More sharing options...
0 l2link Posted December 18, 2008 Author Share Posted December 18, 2008 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... Quote Link to comment Share on other sites More sharing options...
0 Hax0r Posted December 19, 2008 Share Posted December 19, 2008 Mysql server running? Quote Link to comment Share on other sites More sharing options...
0 l2link Posted December 19, 2008 Author Share Posted December 19, 2008 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 . . . Quote Link to comment Share on other sites More sharing options...
0 Hax0r Posted December 19, 2008 Share Posted December 19, 2008 It's not even connected to the MySQL server(?) Java JDK/JRE installed? MySQL server is on localhost? Machine's OS? Quote Link to comment Share on other sites More sharing options...
0 l2link Posted December 19, 2008 Author Share Posted December 19, 2008 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. Quote Link to comment Share on other sites More sharing options...
0 Hax0r Posted December 19, 2008 Share Posted December 19, 2008 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. Quote Link to comment Share on other sites More sharing options...
0 l2link Posted December 19, 2008 Author Share Posted December 19, 2008 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.... ? Quote Link to comment Share on other sites More sharing options...
0 l2link Posted December 24, 2008 Author Share Posted December 24, 2008 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.... Quote Link to comment Share on other sites More sharing options...
0 Hax0r Posted December 25, 2008 Share Posted December 25, 2008 Just outta curiosity could you post what the problem was? Quote Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
10 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.