логин сервер и регистрация не проходят

[AM0S 16]

 

При регистрации персонажа такая беда, гейм сервер загрузился без ошибок

 

 

Enter account name: 132132
Enter account pass: 123132
[19:36:40]  INFO Loaded 127 server names
Exception in thread "main" java.lang.RuntimeException: Can't init database connections pool
        at l2.commons.db.BaseDataConnectionFactory.<init>(BaseDataConnectionFactory.java:54)
        at l2.authserver.database.L2DatabaseFactory.<init>(L2DatabaseFactory.java:31)
        at l2.authserver.database.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:20)
        at l2.authserver.AccountManager.main(AccountManager.java:24)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'interlude.accounts' doesn't exist
        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:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1521)
        at com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeQuery(StatementWrapper.java:745)
        at l2.authserver.database.L2DatabaseFactory.testDB(L2DatabaseFactory.java:58)
        at l2.commons.db.BaseDataConnectionFactory.<init>(BaseDataConnectionFactory.java:49)
        ... 3 more
Для продолжения нажмите любую клавишу . . .

authserver.properties

# External Connection Address
# The host and port for client connections (Physical Ethernet address)
LoginserverHostname = *
LoginserverPort = 2106

# Internal Login server communication address with game server or External if the game server is on another physical server
# The host and port for game servers
LoginHost = 127.0.0.1
LoginPort = 9014

# Take a new game server into a free slot (auto parking game server to auth server)
AcceptNewGameServer = False

# ================================================================
# Database Setting
# ================================================================
# Database Host
DatabaseHost = 127.0.0.1
# Database Port
DatabasePort = 3306
# Database Name
DatabaseName = interlude
# Database User
DatabaseUser = root
# Database Password
DatabasePassword = мой пароль!!!!
# Database max connections (This value does not make sense to expand, if you use direct connection from web server - can add 5-10 pools)
DatabaseMaxConnections = 8
# DB connection timeout
DatabaseConnectionTimeout = 30
# Automatic creation of accounts
AutoCreateAccounts = True
# Template for login and password (The game client supports a maximum of 14 characters. You can not put more)
AccountTemplate = [A-Za-z0-9]{4,14}
PasswordTemplate = [A-Za-z0-9]{4,16}
# Password Encryption Method
# recommended encryption whirlpool2 / Current cache is recommended whirlpool 2
PasswordHash = whirlpool2
# Supported outdated methods, example sha1 (l2jserver)
LegacyPasswordHash = sha1

# Key cache size
BlowFishKeys = 20
RSAKeyPairs = 10

# Autoban IP - The number of failed logins count, to ban IP
LoginTryBeforeBan = 10
# Allowable minimum time between the authorization from one IP (in seconds)
LoginTryTimeout = 5
# Time to ban IP, if exceeded the number of failed logins (seconds)
IpBanTime = 300
# White ip list. This IPs will NEVER be banned.
WhiteIpList = 127.0.0.1

# Successful logining from logging into the database
LoginLog = true

# Check server status LS/GS connection - ping game server
# Time between pings, in seconds, 0 - disable
GameServerPingDelay = 30
# The maximum number of failed attempts to ping beyond which, the connection to the game server is interrupted
GameServerPingRetry = 4

#-------------------------------------------------------------
# Settings server reboot
#-------------------------------------------------------------
# Daily auto restart on schedule. The restart in the format of cron.
# If the field is empty, the daily auto restart is disabled
# Example: 0 5 * * *
AutoRestartAt =

 

Изменено 26 января, 2019 пользователем AM0S

[FORD 33]

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'interlude.accounts' doesn't exist

[AM0S 16]

может кто-то дать эту таблицу ?

Изменено 27 января, 2019 пользователем AM0S

[WolfRam 66]

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

[AM0S 16]

 

Сборка люцерка. проблема была вернее я ее сам создал, при заливке в БД надо было заливать sql и с папки геймсервер и логин сервер,   в моей старой сборке все таблицы были только в папке гейм сервер потому такая лажа вишла...   сори я уже разобрался... всем спасибо

 

 

Enter account name: 123123
Enter account pass: 123132
[12:01:13]  INFO Loaded 127 server names
[12:01:14]  INFO DatabaseFactory: Database connection tested and working.
[12:01:14]  INFO Loaded whirlpool2 as default crypt.
[12:01:15]  INFO Cached 10 KeyPairs for RSA communication
[12:01:15]  INFO Stored 20 keys for Blowfish communication
Creating account "123123" with password "123132"
Account "123123" created.
Для продолжения нажмите любую клавишу . . .

 

Изменено 27 января, 2019 пользователем AM0S

[FORD 33]

Как гласит статистика 95% системных ошибок сидят в полуметре от монитора. Рады помочь, обращайтесь.