L2-scripts Форум

L2-scripts Форум (http://l2-scripts.ru/forum/index.php)
-   Archive Lindvior, Ertheia, Odyssey, Undergeround, Helios, Grand Crusade (http://l2-scripts.ru/forum/forumdisplay.php?f=103)
-   -   accounts (FIXED) (http://l2-scripts.ru/forum/showthread.php?t=5136)

l2gold 04.02.2015 17:45
accounts (FIXED)
 
[16:57:42] INFO =================================================
[16:57:42] INFO Project Revision: ........ L2s [14244]
[16:57:42] INFO Build Revision: .......... 4076
[16:57:42] INFO Update: .................. Epic Tale of Aden: Ertheia
[16:57:42] INFO Build date: .............. 2015.01.27 17:59
[16:57:42] INFO Compiler version: ........ 1.7.0_71-b14 (Oracle Corporation)
[16:57:42] INFO =================================================

если в конфиге прописать

#Ban account if switches too many times (player on player login, make character to force disconnect), Disable = -1 (Retail should be enabled, but numbers are unknown)
#BanAccountIfExceedManyTimesCount = -1
BanAccountIfExceedManyTimesCount = 3

на линдвиоре все норм

таблица accounts находится в другой базе

3-5 ошибок в день

Код:

[17:31:10]  INFO Character KissMyAss bought 1 of 19574 igridients: Id: 19574 count: 1
[17:31:13]  INFO | eared | null | 94.20.219.203 | 8 |
[17:31:13]  INFO bad statement
[17:31:13] ERROR
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gsertheia.accounts' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at l2s.gameserver.network.l2.GameClient.updLogin(GameClient.java:610)
    at l2s.gameserver.network.l2.GameClient.setTimesSwiched(GameClient.java:530)
    at l2s.gameserver.network.l2.GameClient.checkTimesToSwitchAccounts(GameClient.java:504)
    at l2s.gameserver.network.authcomm.as2gs.PlayerAuthResponse.runImpl(PlayerAuthResponse.java:85)
    at l2s.gameserver.network.authcomm.ReceivablePacket.run(ReceivablePacket.java:43)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
[17:31:13] ERROR
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gsertheia.accounts' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at l2s.gameserver.network.l2.GameClient.updLogin(GameClient.java:610)
    at l2s.gameserver.network.l2.GameClient.setFirstAcoountSwitch(GameClient.java:591)
    at l2s.gameserver.network.l2.GameClient.checkTimesToSwitchAccounts(GameClient.java:505)
    at l2s.gameserver.network.authcomm.as2gs.PlayerAuthResponse.runImpl(PlayerAuthResponse.java:85)
    at l2s.gameserver.network.authcomm.ReceivablePacket.run(ReceivablePacket.java:43)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
[17:31:34]  INFO Character KissMyAss bought 1 of 30193 igridients: Id: 30193 count: 1
[17:31:45]  INFO Character Огурец bought 300 of 37607 ingridients: ID: 37607 count: 1

l2gold 04.02.2015 17:57
на линдвиоре после апдейта тоже такое

[17:20:35] INFO =================================================
[17:20:35] INFO Project Revision: ........ L2s [13905]
[17:20:35] INFO Build Revision: .......... 4099
[17:20:35] INFO Update: .................. Chapter 3: Lindvior
[17:20:35] INFO Build date: .............. 2015.02.04 07:11
[17:20:35] INFO Compiler version: ........ 1.7.0_71-b14 (Oracle Corporation)
[17:20:35] INFO =================================================

Код HTML:
    at java.lang.Thread.run(Thread.java:745)
[17:26:37] ERROR
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gsisidor.accounts' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at l2s.gameserver.network.l2.GameClient.updLogin(GameClient.java:610)
    at l2s.gameserver.network.l2.GameClient.setFirstAcoountSwitch(GameClient.java:591)
    at l2s.gameserver.network.l2.GameClient.checkTimesToSwitchAccounts(GameClient.java:505)
    at l2s.gameserver.network.authcomm.as2gs.PlayerAuthResponse.runImpl(PlayerAuthResponse.java:85)
    at l2s.gameserver.network.authcomm.ReceivablePacket.run(ReceivablePacket.java:43)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
[17:26:41]  INFO | prizrak6869 | 189F9001 | 109.94.192.6 | 9 |
[17:26:43]  INFO | boiko507 | 129FF807 | 31.41.70.82 | 9 |
[17:26:53]  INFO | dimonsuper | 12A0C401 | 77.52.152.82 | 9 |
[17:26:56]  INFO | interlude | 18A0C401 | 134.19.214.6 | 9 |
[17:27:30]  INFO | xeka1488 | 129F9801 | 95.72.160.138 | 9 |
[17:27:30]  INFO bad statement
[17:27:30] ERROR
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gsisidor.accounts' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at l2s.gameserver.network.l2.GameClient.updLogin(GameClient.java:610)
    at l2s.gameserver.network.l2.GameClient.setTimesSwiched(GameClient.java:530)
    at l2s.gameserver.network.l2.GameClient.checkTimesToSwitchAccounts(GameClient.java:504)
    at l2s.gameserver.network.authcomm.as2gs.PlayerAuthResponse.runImpl(PlayerAuthResponse.java:85)
    at l2s.gameserver.network.authcomm.ReceivablePacket.run(ReceivablePacket.java:43)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
[17:27:30] ERROR
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gsisidor.accounts' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at l2s.gameserver.network.l2.GameClient.updLogin(GameClient.java:610)
    at l2s.gameserver.network.l2.GameClient.setFirstAcoountSwitch(GameClient.java:591)
    at l2s.gameserver.network.l2.GameClient.checkTimesToSwitchAccounts(GameClient.java:505)
    at l2s.gameserver.network.authcomm.as2gs.PlayerAuthResponse.runImpl(PlayerAuthResponse.java:85)
    at l2s.gameserver.network.authcomm.ReceivablePacket.run(ReceivablePacket.java:43)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
[17:27:35]  INFO | alexmix87 | 18993C01 | 83.220.236.152 | 9 |

iqman 07.02.2015 01:55
Не рассчитано если логинсервер стоит на другой машине или в отдельной ДБ. это ваш случай?

l2gold 07.02.2015 02:05
да, логин в отдельной ДБ.

iqman 07.02.2015 02:14
Это проблема для этого сервиса, я тему не закрываю сделаю через пакетку тогда в ближайшее время.

l2gold 18.03.2015 15:28
актуально ....

maxx12 22.03.2015 20:44
Так же актуально и в сборке high five.

У нас так же несколько игровых серверов. И по определению базы от них не могут находится в одной куче с логин сервером.

Может в настройках модуля добавить настройки для указания пути и доступов к базе(таблицам) логин сервера?

l2gold 24.04.2015 19:25
актуально....

Core 26.04.2015 14:48
Отключите пока эту функцию. Она несовершенная и вообще вызывает мои сомнения.

Core 07.02.2016 01:54
Исправлено. Закрыто.


Часовой пояс GMT +4, время: 06:38.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd. Перевод: zCarot