День добрый дамы и господа, вчера мне пришла в голову идея арендовать игровой сервер на хостинге advens, поинтересовавшись че у них там за ОС, сказали шо стоит Debian 9.6 x64
Ну думаю, возьму, а там глянем.
И сразу же столкнулся с проблемой, что сервер тупо не включался.
Чекаю server_log, там вот такое:
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[22:22:43] filterscripts = "" (string)
[22:22:43]
[22:22:43] Server Plugins
[22:22:43] --------------
[22:22:43] Loading plugin: timerfix.so
[22:22:43] Timer Fix plugin v1.06 by KashCherry loaded.
[22:22:43] Loaded.
[22:22:43] Loading plugin: rustext.so
[22:22:43]
[22:22:43] ---------------
[22:22:43] rustext 2.0.7
[22:22:43] Author: ziggi
[22:22:43] ---------------
[22:22:43]
[22:22:43] Loaded.
[22:22:43] Loading plugin: mysql_static.so
[22:22:43] >> plugin.mysql: R41-4 successfully loaded.
[22:22:43] Loaded.
[22:22:43] Loading plugin: sscanf.so
[22:22:43]
[22:22:43] ===============================
[22:22:43] sscanf plugin loaded.
[22:22:43] Version: 2.8.3
[22:22:43] (c) 2018 Alex "Y_Less" Cole
[22:22:43] ===============================
[22:22:43] Loaded.
[22:22:43] Loading plugin: streamer.so
[22:22:43]
*** Streamer Plugin v2.9.4 by Incognito loaded ***
[22:22:43] Loaded.
[22:22:43] Loading plugin: pawncmd.so
[22:22:43] Pawn.CMD plugin v3.2.0 by urShadow has been loaded
[22:22:43] Loaded.
[22:22:43] Loaded 6 plugins.
[22:22:43]
[22:22:43] Filterscripts
[22:22:43] ---------------
[22:22:43] Loaded 0 filterscripts.
[22:22:43] MapFix by Nexius v3.8.4 loaded (include version).
[22:22:43]
[22:22:43] --------------------------------------
[22:22:43] Античит Nex-AC загружен!
[22:22:43] Версия античита: 1.9.41
[22:22:43] Автор: Nexius
[22:22:43] Modification rakcheat by f0Re3t
[22:22:43] --------------------------------------
[22:22:43] [MySQL]: Подключение к базе данных успешно.
[22:22:43] [Античит] Загружено 72 настроек античита за 0.000000 секунд
[22:22:43] -------------------------------------------------------------------------
[22:22:43] - Gamemode by Kurama & Jackins loaded, created date - 28.06.2017, 23:15 -
[22:22:43] - Возобновление разработки - 28.05.18 & 13.10.18; San Fierro Stories -
[22:22:43] - vk.com/sf_stories.official -
[22:22:43] -------------------------------------------------------------------------
[22:22:43] Number of vehicle models: 0
Вроде как ошибок нет, решил глянуть логи MySQL (версия кстати, R41-4)
errors.log
[12/11/18 02:16:55] [log-core] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
log-core.log
[12/10/18 22:22:43] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -145010688)
[12/10/18 22:32:13] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/10/18 22:42:09] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 28)
[12/10/18 22:52:07] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -145362944)
[12/10/18 23:03:59] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/10/18 23:08:05] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -145731584)
[12/10/18 23:17:06] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -145465344)
[12/10/18 23:32:03] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/10/18 23:42:00] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/10/18 23:51:58] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/11/18 00:03:54] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -143458304)
[12/11/18 00:07:56] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -145317888)
[12/11/18 00:16:57] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -143207223)
[12/11/18 00:31:56] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/11/18 00:41:57] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/11/18 00:51:57] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/11/18 01:03:53] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -145678336)
[12/11/18 01:07:55] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -144027648)
[12/11/18 01:16:57] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/11/18 01:31:56] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/11/18 01:41:56] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -143839232)
[12/11/18 01:51:56] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
[12/11/18 02:03:53] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -143273984)
[12/11/18 02:07:53] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: -146030592)
[12/11/18 02:16:55] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 33)
До этого я сидел на хостинге MyArena и 1game (украинский хостинг)
Но так как MyArena не имеет нужного функционала, а 1game не имеет свободных нодов для игрового сервера - пришлось взять новый хост. Ну и вот сходу такая проблема.
Подключение в моде происходит таким образом
new MySQLOpt:option_id = mysql_init_options(); mysql_set_option(option_id, AUTO_RECONNECT, true); mysql_set_option(option_id, MULTI_STATEMENTS, true); mysql_connect_id = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, option_id); switch(mysql_errno()) { case 0: { mysql_tquery(mysql_connect_id, !"SET CHARACTER SET 'utf8'", "", ""); mysql_tquery(mysql_connect_id, !"SET NAMES 'utf8'", "", ""); mysql_tquery(mysql_connect_id, !"SET character_set_client = 'cp1251'", "", ""); mysql_tquery(mysql_connect_id, !"SET character_set_connection = 'cp1251'", "", ""); mysql_tquery(mysql_connect_id, !"SET character_set_results = 'cp1251'", "", ""); mysql_tquery(mysql_connect_id, !"SET SESSION collation_connection = 'utf8_general_ci'", "", ""); /*Система актеров*/ mysql_tquery(mysql_connect_id, !"SELECT * FROM `actors`", "ActorsLoad_CallBack", ""); /*Система пикапов*/ mysql_tquery(mysql_connect_id, !"SELECT * FROM `enters`", "EnterLoad_CallBack", ""); mysql_log(ERROR | WARNING); } default: printf("[MySQL]: Подключение к базе данных не удалось. Неизвестная ошибка. Код ошибки: [%i]", mysql_errno()); }
Список подключаемых плагинов
PHP код:
plugins timerfix.so rustext.so mysql_static.so sscanf.so streamer.so pawncmd.so
Вот еще список инклудов (не, ну мало ли)