Page 1 of 1

Server won't start.

Posted: Sat Oct 23, 2010 2:29 pm
by valeriya
L2J Revision Number:4422
L2JDP Revision Number:7669

When I run the login server I get this:

Code: Select all

 Starting L2J Login Server. loading login configL2Properties: Missing property for key - PacketHandlerDebugL2Properties: Missing property for key - RequestServerIDL2Properties: Missing property for key - AcceptAlternateIDL2Properties: Missing property for key - DatapackRootLoading mmo.propertiesMLog clients using java 1.4+ standard logging.Initializing c3p0-0.9.2-pre1 [built 27-May-2010 01:00:49 -0400; debug? true; trace: 10]Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [numThreadsAwaitingCheckoutDefaultUser] ]FATAL: Failed initializing database. Reason: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)         at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2308)        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)         at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:866)        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:789)        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:298)        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:312)        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)        at com.l2jserver.L2DatabaseFactory.<init>(L2DatabaseFactory.java:100)        at com.l2jserver.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:211)        at com.l2jserver.loginserver.L2LoginServer.<init>(L2LoginServer.java:109)        at com.l2jserver.loginserver.L2LoginServer.main(L2LoginServer.java:56)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.java:256)        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)        ... 23 more  Server terminated abnormaly  server terminated Press any key to continue . . . 
[/color]
I've used the MySQL tools and successfully connected using my WAN IP so I know the database is accessible. The game server gives a similar error as well. I've hosted successfully on the past but that was on a different computer.

Re: Server won't start.

Posted: Sat Oct 23, 2010 2:47 pm
by Hitokiri
Was you in the config folder?

Re: Server won't start.

Posted: Sat Oct 23, 2010 2:53 pm
by janiii
check your gameserver and login configs. check that you specify the right host, the right port, the right database and also the right user and password for the database. if the database is on remote machine, check that the remote port is open and accessible.

Re: Server won't start.

Posted: Sat Oct 23, 2010 6:16 pm
by valeriya
It's because I was already hosting an old MySQL service on the default port and you can't tell the game to use another port (weird choice on their part) so I had to close the other service and adjust this one's port. Thanks anyways though guys.

Re: Server won't start.

Posted: Tue Oct 26, 2010 6:25 pm
by kotk
you can tell they server to use another port.

Code: Select all

URL = jdbc:mysql://localhost:3306/l2jdb