HarpyWar, сервера свежеустановленные: PVPVGN на FreeBSD 11, D2GS на WS 2012 R2. Протестировал на MySQL 5.6 и SQLite 3.17. По части MySQL - ошибка не воспроизводится, с SQLite возникла другая проблема: данные в таблицу (pvpgn_BNET) вставляются корректно, но похоже что в момент выборки что-то идет не так - при попытке создать персонажа или в момент аутентификации на bnet, сервис bnetd падает, при этом, новые аккаунты создаются без проблем. Вот лог при попытке залогиниться (10.24.5.19 - pvpgn, 10.24.5.53 - client):
May 20 12:28:49 [debug] ipbanlist_check: lastcheck: 0, now: 1495272529, now-lc: 1495272529.
May 20 12:28:49 [debug] ipbanlist_check: checking 10.24.5.19
May 20 12:28:49 [info ] sd_accept: [24] accepted connection from 10.24.5.19:37324 on 0.0.0.0:6112
May 20 12:28:49 [info ] conn_create: [24][22] sessionkey=0x1495312252 sessionnum=0x00000000
May 20 12:28:49 [debug] sd_accept: [24] client connected to a bnet listening address
May 20 12:28:49 [info ] handle_init_packet: [24] client initiated d2cs_bnetd connection
May 20 12:28:49 [trace] conn_shutdown: [24] connection already closed
May 20 12:28:49 [info ] handle_d2cs_init: sent init packet to d2cs (sessionnum=0)
May 20 12:28:49 [info ] on_d2cs_authreply: d2cs 10.24.5.19 authed
May 20 12:28:49 [debug] conn_set_realm: [24] set to "ARTCOM"
May 20 12:28:49 [info ] realm_active: realm ARTCOM actived
May 20 12:28:56 [debug] ipbanlist_check: lastcheck: 1495272529, now: 1495272536, now-lc: 7.
May 20 12:28:56 [debug] ipbanlist_check: checking 10.24.5.53
May 20 12:28:56 [info ] sd_accept: [25] accepted connection from 10.24.5.53:52260 on 0.0.0.0:6112
May 20 12:28:56 [info ] conn_create: [25][22] sessionkey=0x407862666 sessionnum=0x00000001
May 20 12:28:56 [debug] sd_accept: [25] client connected to a bnet listening address
May 20 12:28:56 [info ] handle_init_packet: [25] client initiated bnet connection
May 20 12:28:56 [trace] conn_shutdown: [25] connection already closed
May 20 12:28:56 [debug] conn_set_class: added latency check timer
May 20 12:28:56 [debug] _client_countryinfo109: [25] COUNTRYINFO_109 packet tzbias=0xffffff4c lcid=1049 langid=1049 arch="IX86" client="D2XP" versionid=0x0000000d gamelang="enUS"
May 20 12:28:56 [debug] _client_countryinfo109: [25] COUNTRYINFO_109 packet from "Russia" "RUS"
May 20 12:28:56 [info ] conn_set_archtag: [25] setting client arch to "IX86"
May 20 12:28:56 [info ] conn_set_clienttag: [25] setting client type to "D2XP"
May 20 12:28:56 [info ] conn_set_gamelang: [25] setting client gamelang to "enUS"
May 20 12:28:56 [debug] _client_countryinfo109: [25] selecting version check
May 20 12:28:56 [debug] versioncheck_create: version check entry archtag=IX86, clienttag=W3XP
May 20 12:28:56 [debug] versioncheck_create: version check entry archtag=IX86, clienttag=WAR3
May 20 12:28:56 [debug] versioncheck_create: version check entry archtag=IX86, clienttag=D2XP
May 20 12:28:56 [debug] _client_countryinfo109: [25] selected "ver-IX86-1.mpq" "A=3845581634 B=880823580 C=1363937103 4 A=A-S B=B-C C=C-A A=A-B"
May 20 12:28:56 [info ] _client_authreq109: [25] CLIENT_AUTHREQ_109 ticks=0xc0ef2386, verstr=1.0.13.0 exeinfo="Game.exe 10/18/11 20:48:14 65536" versionid=0x0000000d gameversion=0x01000d00 checksum=0x635b0558
May 20 12:28:56 [info ] versioncheck_validate: no match in list, setting to: D2XP
May 20 12:28:56 [info ] _client_authreq109: [25] unable to test client, allowing anyway
May 20 12:28:56 [info ] _client_authreq109: [25] client matches versiontag "D2XP"
May 20 12:28:56 [info ] _client_authreq109: [25] no upgrade for D2XP is available
May 20 12:28:56 [info ] _client_fileinforeq: [25] file requested: "bnserver-D2DV.ini" - type = 0x80000004
May 20 12:29:05 [trace] sql_read_account: SELECT uid FROM pvpgn_BNET WHERE username='artcom'
May 20 12:29:05 [trace] sql_read_attrs: SELECT * FROM pvpgn_BNET WHERE uid='1'
