Page 1 of 1

help, authorization be for the third time

Posted: Mon Dec 03, 2012 1:42 pm
by coolmans
help, authorization be for the third time
(помогите, авторизация происходить с третьего раза)

[12.12.03 18:25:51] 'admin' 192.168.0.4 - ERR : LoginFailed
[12.12.03 18:26:23] 'admin' 192.168.0.4 - ERR : LoginFailed
[12.12.03 18:26:33] 'admin' 192.168.0.4 - OK : LoginOk
[12.12.03 18:46:51] 'admin' 192.168.0.4 - ERR : LoginFailed
[12.12.03 18:46:55] 'admin' 192.168.0.4 - ERR : LoginFailed
[12.12.03 18:46:58] 'admin' 192.168.0.4 - OK : LoginOk

GameServer: L2J Server Version: 5711
GameServer: L2J Datapack Version: 9307

Script Engine: Rhino Rhino 1.7 release 3 2012 05 18 - Language: ECMAScript - Language Version: 1.7
Script Engine: jython 2.2.1 - Language: python - Language Version: 2.2.1
Script Engine: java 1.7 - Language: java - Language Version: 1.7

ubuntu 13.04, Linux ubuntu 3.7.0-4-generic #12-Ubuntu SMP Tue Nov 27 23:13:21 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
mysql Ver 14.14 Distrib 5.5.28, for debian-linux-gnu (x86_64) using readline 6.2


+


Dec 03, 2012 7:36:58 PM com.l2jserver.gameserver.taskmanager.TaskManager$ExecutedTask run
WARNING: ExecutedTask: Cannot updated the Global Task 3: Communications link failure

The last packet successfully received from the server was 499,989 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 499,989 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.GeneratedConstructorAccessor96.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:139)
at com.l2jserver.gameserver.taskmanager.TaskManager$ExecutedTask.run(TaskManager.java:109)
at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3489)
... 20 more

Re: help, authorization be for the third time

Posted: Mon Dec 03, 2012 2:09 pm
by UnAfraid
The communication between game server and mysql server is laggy that's why those errors appears..
Also it could be caused by wrong mysql/firewall config

Re: help, authorization be for the third time

Posted: Wed Dec 05, 2012 6:28 pm
by coolmans
UnAfraid wrote:The communication between game server and mysql server is laggy that's why those errors appears..
Also it could be caused by wrong mysql/firewall config
not firewall is 127.0.0.1


mysql:

Code: Select all

 [client]port        = 3306socket      = /var/run/mysqld/mysqld.sock [mysqld_safe]socket      = /var/run/mysqld/mysqld.socknice        = 0 [mysqld]  user        = mysqlpid-file    = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.sockport = 3306basedir     = /usrdatadir = /var/lib/mysqltmpdir      = /tmplc-messages-dir = /usr/share/mysqlskip-external-locking  key_buffer      = 256Mmax_allowed_packet = 16Mthread_stack        = 192Kthread_cache_size       = 128  myisam-recover         = BACKUPmax_connections = 50000table_cache = 1536thread_concurrency     = 4wait_timeout=40connect_timeout=20   query_cache_limit   = 2Mquery_cache_size = 128Mquery_cache_type=1interactive_timeout=100      log_error = /var/log/mysql/error.log  expire_logs_days    = 10max_binlog_size         = 100M   [mysqldump]quickquote-namesmax_allowed_packet  = 16M [mysql]  [isamchk]key_buffer      = 256M !includedir /etc/mysql/conf.d/