UBUNTU server JAVA,SQL problem

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
xdavidoff11
Posts: 5
Joined: Thu Jul 30, 2009 9:48 am

UBUNTU server JAVA,SQL problem

Post by xdavidoff11 »

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:3332
L2JDP Revision Number:6443

Servers runing on UBUNTU server!

Code: Select all

 Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsExcepti                                                      on: 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(NativeConstruct                                                      orAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC                                                      onstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        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:2120)        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct                                                      orAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC                                                      onstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        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                                                      :282)        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 net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:95)        at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:206)        at net.sf.l2j.accountmanager.SQLAccountManager.addOrUpdateAccount(SQLAcc                                                      ountManager.java:168)        at net.sf.l2j.accountmanager.SQLAccountManager.main(SQLAccountManager.ja                                                      va:98)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(NativeConstruct                                                      orAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC                                                      onstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1                                                      074)        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)        ... 21 moreCaused by: java.net.ConnectException: Connection refused        at java.net.PlainSocketImpl.socketConnect(Native Method)        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)        at java.net.Socket.connect(Socket.java:519)        at java.net.Socket.connect(Socket.java:469)        at java.net.Socket.<init>(Socket.java:366)        at java.net.Socket.<init>(Socket.java:209)        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja                                                      va:253)        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)        ... 22 more 
Top
xdavidoff11
Posts: 5
Joined: Thu Jul 30, 2009 9:48 am

Re: UBUNTU server JAVA,SQL problem

Post by xdavidoff11 »

Success- must chenge bind adress for sql my.cnf but i have another problem!

Code: Select all

Exception in thread "AWT-EventQueue-0" java.awt.HeadlessException:No X11 DISPLAY variable was set, but this program performed an operation which requires it.        at java.awt.GraphicsEnvironment.checkHeadless(GraphicsEnvironment.java:159)        at java.awt.Window.<init>(Window.java:414)        at java.awt.Frame.<init>(Frame.java:403)        at java.awt.Frame.<init>(Frame.java:368)        at javax.swing.JFrame.<init>(JFrame.java:163)        at net.sf.l2j.gsregistering.GUserInterface.<init>(GUserInterface.java:58)        at net.sf.l2j.gsregistering.BaseGameServerRegister$1.run(BaseGameServerRegister.jav                      a:273)        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269                      )        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174                      )        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Install xorg but not work:(
Top
xdavidoff11
Posts: 5
Joined: Thu Jul 30, 2009 9:48 am

Re: UBUNTU server JAVA,SQL problem

Post by xdavidoff11 »

Success- switch xorg nad register game:)
but when start loginServerGame.sh nothing will happen
Top
User avatar
BiggBoss
L2j Veteran
L2j Veteran
Posts: 1104
Joined: Wed Apr 15, 2009 3:11 pm
Location: Spain

Re: UBUNTU server JAVA,SQL problem

Post by BiggBoss »

are you using

Code: Select all

 chmod +x startLoginServer.sh LoginServer_loop.sh 
before launch the loginserver?
Image
Top
xdavidoff11
Posts: 5
Joined: Thu Jul 30, 2009 9:48 am

Re: UBUNTU server JAVA,SQL problem

Post by xdavidoff11 »

:( nothing:(
Image
Top
User avatar
BiggBoss
L2j Veteran
L2j Veteran
Posts: 1104
Joined: Wed Apr 15, 2009 3:11 pm
Location: Spain

Re: UBUNTU server JAVA,SQL problem

Post by BiggBoss »

ah, you mean that. dont worry, with ./startLoginServer.sh you will not see anything in putty console (dont you think if putty becomes the loginserver and gameserver console would be a problem :) ? you couldnt use the terminal anymore)
go where your server folder is /login/log/stdout.log (Same for gameserver after initialize it)
Image
Top
xdavidoff11
Posts: 5
Joined: Thu Jul 30, 2009 9:48 am

Re: UBUNTU server JAVA,SQL problem

Post by xdavidoff11 »

java0.log.0

Code: Select all

2009.07.31 00:25:41,551	INFO	10	net.sf.l2j.Config	loading login config2009.07.31 00:25:41,624	INFO	10	net.sf.l2j.Config	Loading mmo.properties2009.07.31 00:25:41,657	INFO	10	com.mchange.v2.log.MLog	MLog clients using java 1.4+ standard logging.2009.07.31 00:25:41,762	INFO	10	com.mchange.v2.c3p0.C3P0Registry	Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]2009.07.31 00:25:42,226	INFO	10	com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource	Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCommitOnClose -> true, automaticTestTable -> connection_test_table, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> z8kfsx821l3d6ik1ctvgo9|ae000d, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kfsx821l3d6ik1ctvgo9|ae000d, idleConnectionTestPeriod -> 3600, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost/l2jdb, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 100, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]2009.07.31 00:25:42,305	INFO	10	net.sf.l2j.loginserver.LoginController	Loading LoginController...2009.07.31 00:25:44,808	INFO	10	net.sf.l2j.loginserver.LoginController	Cached 10 KeyPairs for RSA communication2009.07.31 00:25:45,360	INFO	10	net.sf.l2j.loginserver.LoginController	Stored 20 keys for Blowfish communication2009.07.31 00:25:45,384	INFO	10	net.sf.l2j.loginserver.GameServerTable	Loaded 127 server names2009.07.31 00:25:45,391	INFO	10	net.sf.l2j.loginserver.GameServerTable	Loaded 1 registered Game Servers2009.07.31 00:25:45,952	INFO	10	net.sf.l2j.loginserver.GameServerTable	Cached 10 RSA keys for Game Server communication.2009.07.31 00:25:45,955	CONFIG	10	net.sf.l2j.loginserver.L2LoginServer	Loaded 2 IP Bans.2009.07.31 00:25:46,061	INFO	10	net.sf.l2j.loginserver.L2LoginServer	Listening for GameServers on *:90142009.07.31 00:25:46,062	INFO	10	net.sf.l2j.loginserver.L2LoginServer	Telnet server is currently disabled.2009.07.31 00:25:46,065	INFO	10	net.sf.l2j.loginserver.L2LoginServer	Login Server ready on *:2106 
stdout.log

Code: Select all

loading login configLoading mmo.propertiesMLog clients using java 1.4+ standard logging.Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCommitOnClose -> true, automaticTestTable -> connection_test_table, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> z8kfsx821l3d6ik1ctvgo9|ae000d, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kfsx821l3d6ik1ctvgo9|ae000d, idleConnectionTestPeriod -> 3600, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost/l2jdb, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 100, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]Loading LoginController...Cached 10 KeyPairs for RSA communicationStored 20 keys for Blowfish communicationLoaded 127 server namesLoaded 1 registered Game ServersCached 10 RSA keys for Game Server communication.Loaded 2 IP Bans.Listening for GameServers on *:9014Telnet server is currently disabled.Login Server ready on *:2106
???
Why nothing see for my console?
Top
_DS_
L2j Veteran
L2j Veteran
Posts: 3437
Joined: Wed Apr 30, 2008 8:53 am
Location: Russia

Re: UBUNTU server JAVA,SQL problem

Post by _DS_ »

Because console redirected to the file. Welcome to the unix world.
Commiter of the shit
public static final int PI = 3.1415926535897932384626433832795;
Top
Post Reply

Return to “High Five Support”