Skip to forum content

You are not logged in. Please login or register.


forums.pvpgn.pro → [RU] Tech Support → Проблемы с сервом

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 9

1

Topic: Проблемы с сервом

PVPGN 1.8.5

батл через некоторое время (всегда по разному) перестает работать , точнее выкидывает всех с сервера
и после этого при заходе всем пишет неверный пароль , когда создаешь новый акк пишет такое имя занято и т.д
в чем мб проблема?
вот лог за последнее время

Mar 16 15:13:23 [info ] anongame_infos_load: got langID: []
Mar 16 15:13:23 [info ] anongame_infos_load: got langID: [deDE]
Mar 16 15:13:23 [info ] anongame_infos_load: got langID: [zhCN]
Mar 16 15:13:23 [info ] anongame_infos_load: got langID: [ruRU]
Mar 16 15:13:23 [trace] topiclist_load: start reading topic file
Mar 16 15:13:23 [trace] topiclist_load: channel: DotA All Stars topic: "No topic"
Mar 16 15:13:23 [trace] topiclist_load: channel: Moderated Support topic: "Support is provided in this channel..."
Mar 16 15:13:23 [trace] topiclist_load: channel: Chat topic: "This is the public chat channel. Feel free to chat..."
Mar 16 15:13:23 [trace] topiclist_load: finished reading topic file
Mar 16 15:13:23 [info ] _server_mainloop: done reconfiguring
Mar 16 15:14:30 [debug] ipbanlist_check: lastcheck: 1300277097, now: 1300277670, now-lc: 573.
Mar 16 15:14:30 [debug] ipbanlist_check: checking 10.11.14.237
Mar 16 15:14:30 [info ] sd_accept: [356] accepted connection from 10.11.14.237:3562 on 10.11.14.237:6112
Mar 16 15:14:30 [info ] conn_create: [356][280] sessionkey=0x4d80dc9e sessionnum=0x00000070
Mar 16 15:14:30 [debug] sd_accept: [356] client connected to a bnet listening address
Mar 16 15:14:30 [info ] handle_init_packet: [356] client initiated bnet connection
Mar 16 15:14:30 [trace] conn_shutdown: [356] connection allready closed
Mar 16 15:14:30 [debug] conn_set_class: added latency check timer
Mar 16 15:14:30 [debug] handle_udp_packet: [280] got UDPTEST packet from 10.11.14.237:6112 (myself?)
Mar 16 15:14:30 [debug] handle_udp_packet: [280] got UDPTEST packet from 10.11.14.237:6112 (myself?)
Mar 16 15:14:30 [debug] _client_countryinfo109: [356] COUNTRYINFO_109 packet tzbias=0xffffff4c(-180) lcid=1049 langid=1049 arch="IX86" client="W3XP" versionid=0x00000018 gamelang="ruRU"
Mar 16 15:14:30 [debug] _client_countryinfo109: [356] COUNTRYINFO_109 packet from "Russia" "RUS"
Mar 16 15:14:30 [info ] conn_set_archtag: [356] setting client arch to "IX86"
Mar 16 15:14:30 [info ] conn_set_clienttag: [356] setting client type to "W3XP"
Mar 16 15:14:30 [info ] conn_set_gamelang: [356] setting client gamelang to "ruRU"
Mar 16 15:14:30 [debug] _client_countryinfo109: [356] selecting version check
Mar 16 15:14:30 [debug] versioncheck_create: version check entry archtag=IX86, clienttag=W3XP
Mar 16 15:14:30 [debug] _client_countryinfo109: [356] selected "IX86ver1.mpq" "A=3845581634 B=880823580 C=1363937103 4 A=A-S B=B-C C=C-A A=A-B"
Mar 16 15:14:30 [debug] ipbanlist_check: lastcheck: 1300277670, now: 1300277670, now-lc: 0.
Mar 16 15:14:30 [debug] ipbanlist_check: checking 10.11.14.237
Mar 16 15:14:30 [info ] sd_accept: [388] accepted connection from 10.11.14.237:3563 on 10.11.14.237:6112
Mar 16 15:14:30 [info ] conn_create: [388][280] sessionkey=0x4d80f514 sessionnum=0x00000071
Mar 16 15:14:30 [debug] sd_accept: [388] client connected to a bnet listening address
Mar 16 15:14:30 [info ] handle_init_packet: [388] client initiated file download connection
Mar 16 15:14:30 [trace] conn_shutdown: [388] connection allready closed
Mar 16 15:14:30 [info ] file_send: [388] sending file "IX86ver1.mpq" of length 6963
Mar 16 15:14:30 [debug] sd_tcpinput: [388] read returned -1 (closing connection)
Mar 16 15:14:30 [info ] conn_destroy: [388] closed file connection
Mar 16 15:14:30 [info ] _client_authreq109: [356] CLIENT_AUTHREQ_109 ticks=0x07afc534, verstr=1.24.4.243 exeinfo="war3.exe 08/15/10 14:42:12 471040" versionid=0x00000018 gameversion=0x011804f3 checksum=0xde4443c5
Mar 16 15:14:30 [info ] versioncheck_validate: got a matching entry: W3XP_124E
Mar 16 15:14:30 [info ] _client_authreq109: [356] client matches versiontag "W3XP_124E"
Mar 16 15:14:30 [info ] _client_authreq109: [356] no upgrade for W3XP_124E is available
Mar 16 15:14:30 [info ] _client_fileinforeq: [356] TOS requested: "termsofservice-ruRU.txt" - type = 0x01
Mar 16 15:14:30 [info ] _client_fileinforeq: [356] TOS requested: "newaccount-ruRU.txt" - type = 0x02
Mar 16 15:14:30 [debug] ipbanlist_check: lastcheck: 1300277670, now: 1300277670, now-lc: 0.
Mar 16 15:14:30 [debug] ipbanlist_check: checking 10.11.14.237
Mar 16 15:14:30 [info ] sd_accept: [388] accepted connection from 10.11.14.237:3564 on 10.11.14.237:6112
Mar 16 15:14:30 [info ] conn_create: [388][280] sessionkey=0x4d8091e2 sessionnum=0x00000072
Mar 16 15:14:30 [debug] sd_accept: [388] client connected to a bnet listening address
Mar 16 15:14:30 [info ] _client_fileinforeq: [356] TOS requested: "chathelp-war3-ruRU.txt" - type = 0x03
Mar 16 15:14:30 [info ] handle_init_packet: [388] client initiated file download connection
Mar 16 15:14:30 [trace] conn_shutdown: [388] connection allready closed
Mar 16 15:14:30 [debug] ipbanlist_check: lastcheck: 1300277670, now: 1300277670, now-lc: 0.
Mar 16 15:14:30 [debug] ipbanlist_check: checking 10.11.14.237
Mar 16 15:14:30 [info ] sd_accept: [304] accepted connection from 10.11.14.237:3565 on 10.11.14.237:6112
Mar 16 15:14:30 [info ] conn_create: [304][280] sessionkey=0x4d80f848 sessionnum=0x00000073
Mar 16 15:14:30 [debug] sd_accept: [304] client connected to a bnet listening address
Mar 16 15:14:30 [info ] handle_init_packet: [304] client initiated file download connection
Mar 16 15:14:30 [trace] conn_shutdown: [304] connection allready closed
Mar 16 15:14:30 [debug] ipbanlist_check: lastcheck: 1300277670, now: 1300277670, now-lc: 0.
Mar 16 15:14:30 [debug] ipbanlist_check: checking 10.11.14.237
Mar 16 15:14:30 [info ] sd_accept: [224] accepted connection from 10.11.14.237:3566 on 10.11.14.237:6112
Mar 16 15:14:30 [info ] conn_create: [224][280] sessionkey=0x4d808d03 sessionnum=0x00000074
Mar 16 15:14:30 [debug] sd_accept: [224] client connected to a bnet listening address
Mar 16 15:14:30 [debug] ipbanlist_check: lastcheck: 1300277670, now: 1300277670, now-lc: 0.
Mar 16 15:14:30 [debug] ipbanlist_check: checking 10.11.14.237
Mar 16 15:14:30 [info ] sd_accept: [316] accepted connection from 10.11.14.237:3567 on 10.11.14.237:6112
Mar 16 15:14:30 [info ] conn_create: [316][280] sessionkey=0x4d80acef sessionnum=0x00000075
Mar 16 15:14:30 [debug] sd_accept: [316] client connected to a bnet listening address
Mar 16 15:14:30 [info ] handle_init_packet: [224] client initiated file download connection
Mar 16 15:14:30 [trace] conn_shutdown: [224] connection allready closed
Mar 16 15:14:30 [info ] file_send: [388] sending file "termsofservice-ruRU.txt" of length 502
Mar 16 15:14:30 [info ] handle_init_packet: [316] client initiated file download connection
Mar 16 15:14:30 [trace] conn_shutdown: [316] connection allready closed
Mar 16 15:14:30 [info ] file_send: [304] sending file "newaccount-ruRU.txt" of length 158
Mar 16 15:14:30 [debug] sd_tcpinput: [388] read returned -1 (closing connection)
Mar 16 15:14:30 [info ] conn_destroy: [388] closed file connection
Mar 16 15:14:30 [debug] sd_tcpinput: [304] read returned -1 (closing connection)
Mar 16 15:14:30 [info ] file_send: [224] sending file "chathelp-war3-ruRU.txt" of length 1204
Mar 16 15:14:30 [info ] conn_destroy: [304] closed file connection
Mar 16 15:14:30 [info ] file_send: [316] sending file "icons-WAR3.bni" of length 1841010
Mar 16 15:14:30 [debug] sd_tcpinput: [224] read returned -1 (closing connection)
Mar 16 15:14:30 [info ] conn_destroy: [224] closed file connection
Mar 16 15:14:30 [debug] sd_tcpinput: [316] read returned -1 (closing connection)
Mar 16 15:14:30 [info ] conn_destroy: [316] closed file connection
Mar 16 15:14:31 [info ] _client_fileinforeq: [356] TOS requested: "bnserver-WAR3.ini" - type = 0x05
Mar 16 15:14:31 [debug] ipbanlist_check: lastcheck: 1300277670, now: 1300277671, now-lc: 1.
Mar 16 15:14:31 [debug] ipbanlist_check: checking 10.11.14.237
Mar 16 15:14:31 [info ] sd_accept: [316] accepted connection from 10.11.14.237:3572 on 10.11.14.237:6112
Mar 16 15:14:31 [info ] conn_create: [316][280] sessionkey=0x4d808e7f sessionnum=0x00000076
Mar 16 15:14:31 [debug] sd_accept: [316] client connected to a bnet listening address
Mar 16 15:14:31 [info ] handle_init_packet: [316] client initiated file download connection
Mar 16 15:14:31 [trace] conn_shutdown: [316] connection allready closed
Mar 16 15:14:31 [info ] file_send: [316] sending file "bnserver-WAR3.ini" of length 376
Mar 16 15:14:31 [debug] sd_tcpinput: [316] read returned -1 (closing connection)
Mar 16 15:14:31 [info ] conn_destroy: [316] closed file connection
Mar 16 15:14:36 [info ] _client_loginreqw3: [356] (W3) "D1scoveR" passed account check
Mar 16 15:14:36 [info ] _client_logonproofreq: [356] logon proof requested
Mar 16 15:14:36 [error] hash_set_str: got NULL str
Mar 16 15:14:36 [info ] _client_logonproofreq: [356] (W3) got wrong password for "D1scoveR"
Mar 16 15:15:12 [debug] guiOnClose: GUI wants server dead...
Mar 16 15:15:24 [info ] eventlog_startup: logging event levels: fatal,error,warn,info,debug,trace
Mar 16 15:15:24 [debug] give_up_root_privileges: about to give up root privileges
Mar 16 15:15:24 [info ] pvpgn_greeting: PvPGN BnetD Mod version 1.8.5 process 13132
Mar 16 15:15:24 [info ] storage_init: initializing storage layer (available drivers: file, sql, sql2)
Mar 16 15:15:25 [error] sql_mysql_init: error connecting to database (db said: 'Can't connect to MySQL server on '91.189.162.182' (10061)')
Mar 16 15:15:25 [error] sql_init: got error init db
Mar 16 15:15:25 [error] pre_server_startup: storage init failed
Mar 16 15:15:44 [info ] eventlog_startup: logging event levels: fatal,error,warn,info,debug,trace
Mar 16 15:15:44 [debug] give_up_root_privileges: about to give up root privileges
Mar 16 15:15:44 [info ] pvpgn_greeting: PvPGN BnetD Mod version 1.8.5 process 14000
Mar 16 15:15:44 [info ] storage_init: initializing storage layer (available drivers: file, sql, sql2)
Mar 16 15:15:45 [error] sql_mysql_init: error connecting to database (db said: 'Can't connect to MySQL server on '91.189.162.182' (10061)')
Mar 16 15:15:45 [error] sql_init: got error init db
Mar 16 15:15:45 [error] pre_server_startup: storage init failed

2

Re: Проблемы с сервом

Mar 16 15:15:25 [error] sql_mysql_init: error connecting to database (db said: 'Can't connect to MySQL server on '91.189.162.182' (10061)')
Mar 16 15:15:25 [error] sql_init: got error init db

3

Re: Проблемы с сервом

ну я так понимаю не может соедениться с б.д ??
если перезапустить серв все норм ......

4

Re: Проблемы с сервом

Может быть несоответствие рабочей версии мускуля с той, для которой был скомпилирован pvpgn.

Do not ask for support in PM.

5

Re: Проблемы с сервом

Дело в том , что раньше сервера работал пол года без проблем , потом перенесли на новую машину и такие проблемы

6

Re: Проблемы с сервом

У меня было такое 2 раза: из-за неправильной компиляции (неправильно поправил ошибку, из за которой не компилировалось), и из-за несоответствия версий мускуля (предыдущее сообщение).

Do not ask for support in PM.

7 (edited by Discover 19.03.2011 13:33)

Re: Проблемы с сервом

кстати , после компиляции такое стало !
а как узнать в чем у меня ошибка?
и какие версии мускула ?


мб это важно : такое случается то через час после включению , то через неделю . . . .

8

Re: Проблемы с сервом

Версию сервера mysql можешь посмотреть через

mysql -V

или через sql запрос

SHOW VARIABLES LIKE "%version%";

Компилируемую версию смотри в /pvpgn/src/mysql/mysql_version.h. Чтобы не было проблем, они должны совпадать. Изначально лучше посмотреть какая версия mysql установлена на сервере, и скачать заголовочные файлы для компиляции с www.mysql.com именно под эту версию.


Неважно через сколько происходит отключение - это может быть из-за разных причин и вполне допустимо. Главное то, что pvpgn не может сделать реконнект.

Ошибка у меня была при компиляции в windows в sql_mysql.c, я закомментировал где-то код (не помню где) и компиляция проходила успешно, но с таким же багом в работе сервера, как у тебя. Может быть у тебя и не из-за этого, нормальное решение этой ошибки здесь forums.pvpgn.org/index.php?topic … 50#msg4450

Do not ask for support in PM.

9

Re: Проблемы с сервом

google://10061 - порт мускуля закрыт.
Проверь, открыт ли он (ip:3306) телнетом или неткатом (nc -v 91.189.162.182 3306).

Пока открыт. Discover, вы там не в курсе, что мускул нежелательно в инет открывать? Если он не на локалхосте стоит, то желательно его фаером прикрыть.

По логам мне показалось, что ты рестартнул серв (Mar 16 15:15:12 [debug] guiOnClose: GUI wants server dead...), а потом началась переинициализация с реконнектом к БД. Хз, попробуй потестить порт в тот момент, когда реконнект фейлит.

Posts: 9

Pages 1

You must login or register to post a reply

Who now at forum

Currently view post: 1 guest, 0 registered users

forums.pvpgn.pro → [RU] Tech Support → Проблемы с сервом