ИНСТРУКЦИЯ ПО УСТАНОВКЕ SERVER l2j HF5

SlipX

Малый
VIP
Стальной Визионер
Сообщения
87
Розыгрыши
0
Решения
1
Репутация
11
Реакции
26
Баллы
145
Хроники
  1. Chaotic Throne: High Five
Исходники
Присутствуют
Сборка
l2jeternity or else
нужна инструкция по установке server HF5 на винде и линуксе

направьте на путь плз
 
А что там запускать? Залей базу и пропиши реквизиты к ней в конфигах, запускай батники лса и гса... Что на винде что на лине одинаково ставится, разве что на линуксе все через консоль. Но базу все равно можно залить через sh готовые.
 
Запрещается написания сообщения с использованием транслита, чрезмерно большого количества смайлов.
  • Мне нравится
Реакции: KATE
 
какую версию явы выбрать? есть ли разница между версией явы и сборкой?

[l2j@l2-server ~]$ yum list jdk*
Loaded plugins: langpacks, ulninfo
Available Packages
jdk-11.0.11.0.1.aarch64 2000:11.0.11.0.1-ga ol7_oci_included
jdk-16.0.1.0.1.aarch64 2000:16.0.1.0.1-ga ol7_oci_included


нужен MariaDB или MySQL подойдет?
 
какую версию явы выбрать? есть ли разница между версией явы и сборкой?

[l2j@l2-server ~]$ yum list jdk*
Loaded plugins: langpacks, ulninfo
Available Packages
jdk-11.0.11.0.1.aarch64 2000:11.0.11.0.1-ga ol7_oci_included
jdk-16.0.1.0.1.aarch64 2000:16.0.1.0.1-ga ol7_oci_included


нужен MariaDB или MySQL подойдет?
От сборки версия явы зависит, которую ты накатить решил. А мариа или майскл зависит от твоих предпочтений в самоудовлетворениях
 
ну вот вроде установил не запустить не могу

[opc@l2-server ~]$ java -version
openjdk version "1.8.0_292"
OpenJDK Runtime Environment (build 1.8.0_292-b10)
OpenJDK 64-Bit Server VM (build 25.292-b10, mixed mode)
[opc@l2-server ~]$

[opc@l2-server ~]$ mysql -V
mysql Ver 8.0.25 for Linux on aarch64 (MySQL Community Server - GPL)
[opc@l2-server ~]$


при запуске ГеймСервера:
[opc@l2-server game]$ ./startGameServer.sh
[opc@l2-server game]$ ./startGameServer.sh: ./GameServer_loop.sh: /bin/bash^M: bad interpreter: No such file or directory

когда включаю ЛогинСервер:
вроде все ок
 
SlipX, содержимое файлов startGameServer.sh, GameServer_loop.sh в тег код и под спойлер. Может там чего не так
 
ну вот вроде установил не запустить не могу

[opc@l2-server ~]$ java -version
openjdk version "1.8.0_292"
OpenJDK Runtime Environment (build 1.8.0_292-b10)
OpenJDK 64-Bit Server VM (build 25.292-b10, mixed mode)
[opc@l2-server ~]$

[opc@l2-server ~]$ mysql -V
mysql Ver 8.0.25 for Linux on aarch64 (MySQL Community Server - GPL)
[opc@l2-server ~]$


при запуске ГеймСервера:
[opc@l2-server game]$ ./startGameServer.sh
[opc@l2-server game]$ ./startGameServer.sh: ./GameServer_loop.sh: /bin/bash^M: bad interpreter: No such file or directory

когда включаю ЛогинСервер:
вроде все ок
установи dos2unix, и сделай вот так вот: dos2unix GameServer_loop.sh:Bloodnose:
 

    SlipX

    Баллов: 1
    GameServer stal ly4she rabotat vrode no BD ne pashet
может я БД криво поставил

1624555823594.png
первый юзер и уже занят? :(

Код:
Jun 24, 2021 5:25:00 PM l2e.loginserver.LoginController retriveAccountInfo
WARNING: Exception while retriving account info for 'test'!
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:208)
    at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
    at l2e.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:63)
    at l2e.loginserver.database.DatabaseFactory.getConnection(DatabaseFactory.java:39)
    at l2e.loginserver.LoginController.retriveAccountInfo(LoginController.java:187)
    at l2e.loginserver.LoginController.retriveAccountInfo(LoginController.java:175)
    at l2e.loginserver.network.clientpackets.RequestAuthLogin.run(RequestAuthLogin.java:108)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)

SlipX, содержимое файлов startGameServer.sh, GameServer_loop.sh в тег код и под спойлер. Может там чего не так
startGameServer.sh,:
JavaScript:
#! /bin/sh

./GameServer_loop.sh &
GameServer_loop.sh:
JavaScript:
#!/bin/bash

# exit codes of GameServer:
#  0 normal shutdown
#  2 reboot attempt

while :; do
    [ -f log/java0.log.0 ] && mv log/java0.log.0 "log/`date +%Y-%m-%d_%H-%M-%S`_java.log"
    [ -f log/stdout.log ] && mv log/stdout.log "log/`date +%Y-%m-%d_%H-%M-%S`_stdout.log"
    java -server -Dfile.encoding=UTF-8 -Djava.util.logging.manager=l2e.commons.util.L2LogManager -Xmx8G -cp config:./../libs/* org.strixplatform.StrixPlatform l2e.gameserver.GameServer > log/stdout.log 2>&1
    [ $? -ne 2 ] && break
#    /etc/init.d/mysql restart
    sleep 10
done

если смотреть на stdout.log от логин сервера:
Bash:
Loading configs...
Loading LoginController...
Cached 10 KeyPairs for RSA communication
Stored 20 keys for Blowfish communication
GameServerManager: Loaded 127 server name(s).
GameServerManager: Loaded 0 registered game server(s).
GameServerManager: Loaded 0 proxy server(s).
GameServerManager: Cached 10 RSA keys for game server communication.
Loaded 2 IP Bans.
Listening for GameServers on *:9014
Login Server ready on *:2106


тут login\log\error1.log:

JavaScript:
Jun 24, 2021 10:57:59 PM l2e.loginserver.LoginController retriveAccountInfo
WARNING: Exception while retriving account info for 'test'!
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:208)
    at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
    at l2e.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:63)
    at l2e.loginserver.database.DatabaseFactory.getConnection(DatabaseFactory.java:39)
    at l2e.loginserver.LoginController.retriveAccountInfo(LoginController.java:187)
    at l2e.loginserver.LoginController.retriveAccountInfo(LoginController.java:175)
    at l2e.loginserver.network.clientpackets.RequestAuthLogin.run(RequestAuthLogin.java:108)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)



и тут: login\log\java0.log:
Bash:
2021.06.24 23:06:52 Loading configs...
2021.06.24 23:06:52 Loading LoginController...
2021.06.24 23:06:52 Cached 10 KeyPairs for RSA communication
2021.06.24 23:06:52 Stored 20 keys for Blowfish communication
2021.06.24 23:06:52 GameServerManager: Loaded 127 server name(s).
2021.06.24 23:06:52 GameServerManager: Loaded 0 registered game server(s).
2021.06.24 23:06:52 GameServerManager: Loaded 0 proxy server(s).
2021.06.24 23:06:52 GameServerManager: Cached 10 RSA keys for game server communication.
2021.06.24 23:06:52 Loaded 2 IP Bans.
2021.06.24 23:06:52 Listening for GameServers on *:9014
2021.06.24 23:06:52 Login Server ready on *:2106


на stdout.log от game сервера:

Bash:
а на stdout.log от гейм сервера:
23:06:42 [strixplatform] INFO - |============= Strix-Platform =============|
23:06:42 [strixplatform] INFO - Configuration file loaded! Strix-Platform: Disabled
23:06:42 [strixplatform] INFO - |============= Strix-Platform =============|
Loading configuration files...
Network Config: ipconfig.xml exists using manual configuration...
ExperienceParser: Loaded 87 levels.
Loaded 707 Filter Words.
Loaded 3 BroadCast Filter Words.
-----------------------------------------------------------------=[ Database ]
Could not update characters online status: Table 'serverDB.characters' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1354)
    at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2127)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at l2e.gameserver.idfactory.IdFactory.setAllCharacterOffline(IdFactory.java:162)
    at l2e.gameserver.idfactory.IdFactory.<init>(IdFactory.java:127)
    at l2e.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory.java:47)
    at l2e.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:146)
    at l2e.gameserver.GameServer.<init>(GameServer.java:233)
    at l2e.gameserver.GameServer.main(GameServer.java:618)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)

Could not clean up database: Table 'serverDB.characters' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1354)
    at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2127)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at l2e.gameserver.idfactory.IdFactory.cleanUpDB(IdFactory.java:179)
    at l2e.gameserver.idfactory.IdFactory.<init>(IdFactory.java:134)
    at l2e.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory.java:47)
    at l2e.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:146)
    at l2e.gameserver.GameServer.<init>(GameServer.java:233)
    at l2e.gameserver.GameServer.main(GameServer.java:618)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)

Cleaned 0 expired timestamps from database.
BitSetIDFactory: Could not be initialized properly: Table 'serverDB.characters' doesn't exist
BitSetIDFactory: 102912 id's available.
Could not read object IDs from DB. Please Check Your Data.
Exception in thread "main" java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)
Caused by: java.lang.Exception: Could not initialize the ID factory
    at l2e.gameserver.GameServer.<init>(GameServer.java:238)
    at l2e.gameserver.GameServer.main(GameServer.java:618)
    ... 5 more

тут java0.log:

JavaScript:
2021.06.24 23:06:42 Loading configuration files...
2021.06.24 23:06:42 Network Config: ipconfig.xml exists using manual configuration...
2021.06.24 23:06:43 ExperienceParser: Loaded 87 levels.
2021.06.24 23:06:43 Loaded 707 Filter Words.
2021.06.24 23:06:43 Loaded 3 BroadCast Filter Words.
2021.06.24 23:06:43 -----------------------------------------------------------------=[ Database ]
2021.06.24 23:06:43 Could not update characters online status: Table 'serverDB.characters' doesn't exist
2021.06.24 23:06:43 Could not clean up database: Table 'serverDB.characters' doesn't exist
2021.06.24 23:06:43 Cleaned 0 expired timestamps from database.
2021.06.24 23:06:43 BitSetIDFactory: Could not be initialized properly: Table 'serverDB.characters' doesn't exist
2021.06.24 23:06:43 BitSetIDFactory: 102912 id's available.
2021.06.24 23:06:43 Could not read object IDs from DB. Please Check Your Data.

TyT error0.log:

JavaScript:
Jun 24, 2021 11:06:43 PM l2e.gameserver.idfactory.IdFactory setAllCharacterOffline
WARNING: Could not update characters online status: Table 'serverDB.characters' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1354)
    at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2127)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at l2e.gameserver.idfactory.IdFactory.setAllCharacterOffline(IdFactory.java:162)
    at l2e.gameserver.idfactory.IdFactory.<init>(IdFactory.java:127)
    at l2e.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory.java:47)
    at l2e.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:146)
    at l2e.gameserver.GameServer.<init>(GameServer.java:233)
    at l2e.gameserver.GameServer.main(GameServer.java:618)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)

Jun 24, 2021 11:06:43 PM l2e.gameserver.idfactory.IdFactory cleanUpDB
WARNING: Could not clean up database: Table 'serverDB.characters' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1354)
    at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2127)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at l2e.gameserver.idfactory.IdFactory.cleanUpDB(IdFactory.java:179)
    at l2e.gameserver.idfactory.IdFactory.<init>(IdFactory.java:134)
    at l2e.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory.java:47)
    at l2e.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:146)
    at l2e.gameserver.GameServer.<init>(GameServer.java:233)
    at l2e.gameserver.GameServer.main(GameServer.java:618)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)

постараюсь описать процесс заливки бд:
при запуске ./database_installer.sh
есть пару вопросов про бэкап и тд
и потом начинаются эрроры


при залитии самой БД


походу что то пошло не так c DataBAse
qSxBiNm.png

java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
я так понимаю тебе нужно файл characters залить в бд
это не должно быть автоматически при залитии БД? в любом случае как это сделать тогда?
 

Вложения

  • 1624555781021.png
    1624555781021.png
    39,8 КБ · Просмотры: 1
Последнее редактирование модератором:
Написано что не существует таблицы 'ServerDB.character'
 
ServerDB это я так свою базу данный назвал сервера л2
когда добавляю через Хейди то вот эрор как когда заливаю БД через скрипт

fpXEgZP.png

h1ErBxd.png

вот что внутри файла characters.sql
o8nbSIy.png
 
Последнее редактирование модератором:
Public Key Retrieval is not allowed
в настройках подключения к базе логина попробуйте изменить таким образом
Код:
jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false
где в строке указать имя базы надеюсь понятно

по поводу таблицы characters, попробуйте у поля createDate указать значение по умолчанию '0' вместо '0000-00-00'
 
в настройках подключения к базе логина
у меня вот так в гейм и логин настройках:
Код:
URL = jdbc:mysql://localhost/serverDB?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true
изначально было без allowPublicKeyRetrieval=true , но и с ним не помогает

о поводу таблицы characters, попробуйте у поля createDate указать значение по умолчанию '0' вместо '0000-00-00'

после смены залило спасибо

на даный момен дальше выбора сервера не заходит(
 
на даный момен дальше выбора сервера не заходит(
если есть ошибки логин/гейм сервера, показываем/выкладываем (в теге код, не нужно скринами)

если нет ошибок, настраивайте внутренние и внешние айпи адреса логин/гейм серверов
вот пример:
Код:
# Host and Port for client connections
LoginserverHostname = *
LoginserverPort = 2106

# Host and Port for gameserver to connect to
LoginHost = указать локальный IP-адрес
LoginPort = 9014

Код:
# IP to bind gameserver, * - for all IP's
GameserverHostname = указать локальный IP-адрес
GameserverPort = 7777
# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname = указать внешний IP-адрес
# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname = указать локальный IP-адрес

# IP and Port of login server
LoginPort = 9014
LoginHost = указать локальный IP-адрес

ну и не забываем зарегистрировать гейм сервер в базе логина в таблице gameservers,
и указать айди зарегистрированного в настройках геймсервера RequestServerID

процесс регистрации сервера в базе логина может немного отличатся в зависимости от сборки
 
по поводу таблицы characters, попробуйте у поля createDate указать значение по умолчанию '0' вместо '0000-00-00'
залить базу я то залил но вот теперь создать не могу юзеров
прохожу выбор сервера а при созданиии вот тебе такое
cFOAhPK.png
в \game\log\java0.log:
Код:
2021.06.25 12:52:46 Could not insert char data: Unknown column 'createDate' in 'field list'
2021.06.25 12:52:46 Exception on create new char(): null
2021.06.25 12:53:13 Could not insert char data: Unknown column 'createDate' in 'field list'
2021.06.25 12:53:13 Exception on create new char(): null
2021.06.25 12:53:21 Could not insert char data: Unknown column 'createDate' in 'field list'
2021.06.25 12:53:21 Exception on create new char(): null
а тут game\log\stdout.log:

Код:
Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
    at l2e.gameserver.model.actor.Player.create(Player.java:915)
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Exception on create new char(): null
java.lang.NullPointerException
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
    at l2e.gameserver.model.actor.Player.create(Player.java:915)
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Exception on create new char(): null
java.lang.NullPointerException
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
    at l2e.gameserver.model.actor.Player.create(Player.java:915)
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Exception on create new char(): null
java.lang.NullPointerException
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

тут: game\log\error0.log

Код:
Jun 25, 2021 12:52:46 PM l2e.gameserver.data.dao.CharacterDAO isPlayerCreated
SEVERE: Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
    at l2e.gameserver.model.actor.Player.create(Player.java:915)
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Jun 25, 2021 12:52:46 PM l2e.gameserver.network.clientpackets.RequestCharacterCreate runImpl
WARNING: Exception on create new char(): null
java.lang.NullPointerException
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Jun 25, 2021 12:53:13 PM l2e.gameserver.data.dao.CharacterDAO isPlayerCreated
SEVERE: Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
    at l2e.gameserver.model.actor.Player.create(Player.java:915)
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Jun 25, 2021 12:53:13 PM l2e.gameserver.network.clientpackets.RequestCharacterCreate runImpl
WARNING: Exception on create new char(): null
java.lang.NullPointerException
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Jun 25, 2021 12:53:21 PM l2e.gameserver.data.dao.CharacterDAO isPlayerCreated
SEVERE: Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
    at l2e.gameserver.model.actor.Player.create(Player.java:915)
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)

Jun 25, 2021 12:53:21 PM l2e.gameserver.network.clientpackets.RequestCharacterCreate runImpl
WARNING: Exception on create new char(): null
java.lang.NullPointerException
    at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
    at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
    at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
    at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
 
SEVERE: Could not insert char data: Unknown column 'createDate' in 'field list'
не может найти поле createDate в таблице (наверно characters)

или папка sql не от этой сборки, или же вы не залили какие-то обновления, где это поле (createDate) было переименовано во что-то еще
 
не может найти поле createDate в таблице (наверно characters)

или папка sql не от этой сборки, или же вы не залили какие-то обновления, где это поле (createDate) было переименовано во что-то еще
как найти во что переименовано?
папка SQL от этернити и база залита вроде как
 
Назад
Сверху Снизу