BullCull
Дебютант
Всем привет, я новичок в скриптинге всего 2 недели так вот у меня на сервере вырос онлайн до 150 человек
ну как понимаете сервер не выдержал нагрузки без базы данных вот я начал копать по форумам гейммоды с mysql нашел, то что нужно так вот я все сделал правильно создал базу данных указал в pawno(mysql_settings.ini) юзер название бд и тд правильно залил в localhost базу данных сервер формата bd.sql(Пример) все я запустил сервер на windows все работает отлично можно сказать на ура! И вот я протестировал мод начал загружать на Linux при загрузке на хостинг все загрузилось хорошо я в server.cfg->plugins все плагины указал .so(я умею)перезапустил сервер он гейммод unknown смотрю консоль вот такая ерунда тип не удалось подкл к базе данных а на Windows все работало. Прошу помочь так как уже 4 дня незнаю ответа все перерыскал и этого не нашел всем кто даст ответы которые помогут дам +сы
Это так на всяких случай:
Мой хост worldhosts.ru(не пиар)
База данных: localhost DENWER
Вот лог сервера
ну как понимаете сервер не выдержал нагрузки без базы данных вот я начал копать по форумам гейммоды с mysql нашел, то что нужно так вот я все сделал правильно создал базу данных указал в pawno(mysql_settings.ini) юзер название бд и тд правильно залил в localhost базу данных сервер формата bd.sql(Пример) все я запустил сервер на windows все работает отлично можно сказать на ура! И вот я протестировал мод начал загружать на Linux при загрузке на хостинг все загрузилось хорошо я в server.cfg->plugins все плагины указал .so(я умею)перезапустил сервер он гейммод unknown смотрю консоль вот такая ерунда тип не удалось подкл к базе данных а на Windows все работало. Прошу помочь так как уже 4 дня незнаю ответа все перерыскал и этого не нашел всем кто даст ответы которые помогут дам +сы
Это так на всяких случай:
Мой хост worldhosts.ru(не пиар)
База данных: localhost DENWER
Вот лог сервера
Started server on (Мой ип), with maxplayers: 200 lanmode is OFF.
pen shared object file: No such file or directory)
[10:22:54] Loading plugin: crashdetect.so
[10:22:54] CrashDetect v4.10 is OK.
[10:22:54] Loaded.
[10:22:54] Loading plugin: antiattack.so
[10:22:54] Anti-Attack plugin by BJIADOKC loaded.
[10:22:54] Loaded.
[10:22:54] Loading plugin: jit.so
[10:22:54] Failed (plugins/jit.so: cannot open shared object file: No such file or directory)
[10:22:54] Loaded 7 plugins.
[10:22:54]
[10:22:54] Ban list
[10:22:54] --------
[10:22:54] Loaded: samp.ban
[10:22:54]
[10:22:54]
[10:22:54] Filterscripts
[10:22:54] ---------------
[10:22:54] Loading filterscript 'yom_buttons.amx'...
[10:22:54] *** Streamer Plugin: Warning: Include file version (0x26105) does not match plugin version (0x27002) (script might need to be recompiled with the latest include file)
[10:22:54] Loading filterscript 'pockets.amx'...
[10:22:54] FS SCRIPT LOAD
[10:22:54] Loaded 2 filterscripts.
[10:22:54] [debug] Run time error 19: "File or function is not found"
[10:22:54] [debug] sql_debug
[10:22:54] [debug] sql_connect
[10:22:54] [debug] sql_set_charset
[10:22:54] [debug] sql_query
[10:22:54] [debug] sql_num_rows
[10:22:54] [debug] sql_fetch_row
[10:22:54] [debug] sql_next_row
[10:22:54] [debug] sql_free_result
[10:22:54] [debug] sql_disconnect
[10:22:54] [debug] sql_get_field_assoc_int
[10:22:54] [debug] sql_get_field_assoc
[10:22:54] [debug] sql_escape_string
[10:22:54] [debug] sql_insert_id
[10:22:54] [debug] sql_get_field_int
[10:22:54] [debug] sql_get_field_ex
[10:22:54] [debug] sql_get_field_int_ex
[10:22:54] [debug] sql_affected_rows
[10:22:54] [debug] sql_get_field
[10:22:54] [debug] sql_get_field_assoc_int_ex
[10:22:54] [debug] sql_get_field_assoc_ex
[10:22:54] [debug] sql_get_field_assoc_float_ex
[10:22:54] [debug] sql_get_field_float
[10:22:54] [debug] sql_get_field_float_ex
[10:22:54] [debug] Run time error 19: "File or function is not found"
[10:22:54] [debug] sql_debug
[10:22:54] [debug] sql_connect
[10:22:54] [debug] sql_set_charset
[10:22:54] [debug] sql_query
[10:22:54] [debug] sql_num_rows
[10:22:54] [debug] sql_fetch_row
[10:22:54] [debug] sql_next_row
[10:22:54] [debug] sql_free_result
[10:22:54] [debug] sql_disconnect
[10:22:54] [debug] sql_get_field_assoc_int
[10:22:54] [debug] sql_get_field_assoc
[10:22:54] [debug] sql_escape_string
[10:22:54] [debug] sql_insert_id
[10:22:54] [debug] sql_get_field_int
[10:22:54] [debug] sql_get_field_ex
[10:22:54] [debug] sql_get_field_int_ex
[10:22:54] [debug] sql_affected_rows
[10:22:54] [debug] sql_get_field
[10:22:54] [debug] sql_get_field_assoc_int_ex
[10:22:54] [debug] sql_get_field_assoc_ex
[10:22:54] [debug] sql_get_field_assoc_float_ex
[10:22:54] [debug] sql_get_field_float
[10:22:54] [debug] sql_get_field_float_ex
[10:22:54] Script[gamemodes/new.amx]: Run time error 19: "File or function is not found"
[10:22:54] Number of vehicle models: 0
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7, (C)2005-2015 SA-MP Team
[10:24:13]
[10:24:13] Server Plugins
[10:24:13] --------------
[10:24:13] Loading plugin: streamer.so
[10:24:13]
*** Streamer Plugin v2.7 by Incognito loaded ***
[10:24:13] Loaded.
[10:24:13] Loading plugin: sscanf.so
[10:24:13]
[10:24:13] ===============================
[10:24:13] sscanf plugin loaded.
[10:24:13] Version: 2.8.1
[10:24:13] (c) 2012 Alex "Y_Less" Cole
[10:24:13] ===============================
[10:24:13] Loaded.
[10:24:13] Loading plugin: mysql.so
[10:24:13] Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)
[10:24:13] Loading plugin: sql.so
[10:24:13] >> SQL plugin v2.6 successfully loaded.
[10:24:13] + MySQL support is enabled.
[10:24:13] Loaded.
[10:24:13] Loaded 3 plugins.
[10:24:13]
[10:24:13] Ban list
[10:24:13] --------
[10:24:13] Loaded: samp.ban
[10:24:13]
[10:24:13]
[10:24:13] Filterscripts
[10:24:13] ---------------
[10:24:13] Loading filterscript 'yom_buttons.amx'...
[10:24:13] *** Streamer Plugin: Warning: Include file version (0x26105) does not match plugin version (0x27002) (script might need to be recompiled with the latest include file)
[10:24:13] Loading filterscript 'pockets.amx'...
[10:24:13] FS SCRIPT LOAD
[10:24:13] Loaded 2 filterscripts.
[10:24:13] Script[gamemodes/new.amx]: Run time error 19: "File or function is not found"
[10:24:13] Number of vehicle models: 0
[14:14:57] [connection] 178.234.212.17:63266 requests connection cookie.
[14:14:58] Incoming connection: 178.234.212.17:63266 id: 0
[14:14:59] [join] Nikita_Lukov has joined the server (0:178.234.212.17)
[14:15:52] [part] Nikita_Lukov has left the server (0:0)
[14:16:05] [connection] 178.234.212.17:62442 requests connection cookie.
[14:16:05] Incoming connection: 178.234.212.17:62442 id: 0
[14:16:06] [join] Nikita_Lukov has joined the server (0:178.234.212.17)
[14:19:28] [part] Nikita_Lukov has left the server (0:1)
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7, (C)2005-2015 SA-MP Team
[19:20:22]
[19:20:22] Server Plugins
[19:20:22] --------------
[19:20:22] Loading plugin: streamer.so
[19:20:22]
*** Streamer Plugin v2.7 by Incognito loaded ***
[19:20:22] Loaded.
[19:20:22] Loading plugin: sscanf.so
[19:20:22]
[19:20:22] ===============================
[19:20:22] sscanf plugin loaded.
[19:20:22] Version: 2.8.1
[19:20:22] (c) 2012 Alex "Y_Less" Cole
[19:20:22] ===============================
[19:20:22] Loaded.
[19:20:22] Loading plugin: regex.so
[19:20:22]
[19:20:22] ______________________________________
[19:20:22] Regular Expression Plugin v0.2.1 loaded
[19:20:22] ______________________________________
[19:20:22] By: Fro (c) Copyright 2009-2011
[19:20:22] ______________________________________
[19:20:22] Loaded.
[19:20:22] Loading plugin: PointToPoint.so
[19:20:22] PointToPoint Plugin Loaded.
[19:20:22] Loaded.
[19:20:22] Loading plugin: sql.so
[19:20:22] >> SQL plugin v2.6 successfully loaded.
[19:20:22] + MySQL support is enabled.
[19:20:22] Loaded.
[19:20:22] Loading plugin: mysql.so
[19:20:22] Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)
[19:20:22] Loading plugin: FileFunctions.so
[19:20:22] Loaded.
[19:20:22] Loading plugin: iTD.so
[19:20:22] Failed (plugins/iTD.so: cannot open shared object file: No such file or directory)
[19:20:22] Loading plugin: crashdetect.so
[19:20:22] CrashDetect v4.10 is OK.
[19:20:22] Loaded.
[19:20:22] Loading plugin: antiattack.so
[19:20:22] Anti-Attack plugin by BJIADOKC loaded.
[19:20:22] Loaded.
[19:20:22] Loading plugin: jit.so
[19:20:22] Failed (plugins/jit.so: cannot open shared object file: No such file or directory)
[19:20:22] Loaded 8 plugins.
[19:20:22]
[19:20:22] Ban list
[19:20:22] --------
[19:20:22] Loaded: samp.ban
[19:20:22]
[19:20:22]
[19:20:22] Filterscripts
[19:20:22] ---------------
[19:20:22] Loading filterscript 'yom_buttons.amx'...
[19:20:22] *** Streamer Plugin: Warning: Include file version (0x26105) does not match plugin version (0x27002) (script might need to be recompiled with the latest include file)
[19:20:22] Loading filterscript 'pockets.amx'...
[19:20:22] FS SCRIPT LOAD
[19:20:22] Loaded 2 filterscripts.
[19:20:22]
[19:20:22]
[19:20:22]
[19:20:22] =======================================
[19:20:22] | |
[19:20:22] | YSI version 1.06.0002 |
[19:20:22] | By Alex "Y_Less" Cole |
[19:20:22] | |
[19:20:22] =======================================
[19:20:22]
[19:20:22] [plugin.sql][warning] Natives::sql_debug: Switching the log levels to (0, 3)...
[19:20:22] [plugin.sql][warning] Natives::sql_connect: Connection (conn->id = 1) failed! (error = 2002, Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
[19:20:22] Не удалось подключиться к MySQL
[19:20:22] Number of vehicle models: 0
pen shared object file: No such file or directory)
[10:22:54] Loading plugin: crashdetect.so
[10:22:54] CrashDetect v4.10 is OK.
[10:22:54] Loaded.
[10:22:54] Loading plugin: antiattack.so
[10:22:54] Anti-Attack plugin by BJIADOKC loaded.
[10:22:54] Loaded.
[10:22:54] Loading plugin: jit.so
[10:22:54] Failed (plugins/jit.so: cannot open shared object file: No such file or directory)
[10:22:54] Loaded 7 plugins.
[10:22:54]
[10:22:54] Ban list
[10:22:54] --------
[10:22:54] Loaded: samp.ban
[10:22:54]
[10:22:54]
[10:22:54] Filterscripts
[10:22:54] ---------------
[10:22:54] Loading filterscript 'yom_buttons.amx'...
[10:22:54] *** Streamer Plugin: Warning: Include file version (0x26105) does not match plugin version (0x27002) (script might need to be recompiled with the latest include file)
[10:22:54] Loading filterscript 'pockets.amx'...
[10:22:54] FS SCRIPT LOAD
[10:22:54] Loaded 2 filterscripts.
[10:22:54] [debug] Run time error 19: "File or function is not found"
[10:22:54] [debug] sql_debug
[10:22:54] [debug] sql_connect
[10:22:54] [debug] sql_set_charset
[10:22:54] [debug] sql_query
[10:22:54] [debug] sql_num_rows
[10:22:54] [debug] sql_fetch_row
[10:22:54] [debug] sql_next_row
[10:22:54] [debug] sql_free_result
[10:22:54] [debug] sql_disconnect
[10:22:54] [debug] sql_get_field_assoc_int
[10:22:54] [debug] sql_get_field_assoc
[10:22:54] [debug] sql_escape_string
[10:22:54] [debug] sql_insert_id
[10:22:54] [debug] sql_get_field_int
[10:22:54] [debug] sql_get_field_ex
[10:22:54] [debug] sql_get_field_int_ex
[10:22:54] [debug] sql_affected_rows
[10:22:54] [debug] sql_get_field
[10:22:54] [debug] sql_get_field_assoc_int_ex
[10:22:54] [debug] sql_get_field_assoc_ex
[10:22:54] [debug] sql_get_field_assoc_float_ex
[10:22:54] [debug] sql_get_field_float
[10:22:54] [debug] sql_get_field_float_ex
[10:22:54] [debug] Run time error 19: "File or function is not found"
[10:22:54] [debug] sql_debug
[10:22:54] [debug] sql_connect
[10:22:54] [debug] sql_set_charset
[10:22:54] [debug] sql_query
[10:22:54] [debug] sql_num_rows
[10:22:54] [debug] sql_fetch_row
[10:22:54] [debug] sql_next_row
[10:22:54] [debug] sql_free_result
[10:22:54] [debug] sql_disconnect
[10:22:54] [debug] sql_get_field_assoc_int
[10:22:54] [debug] sql_get_field_assoc
[10:22:54] [debug] sql_escape_string
[10:22:54] [debug] sql_insert_id
[10:22:54] [debug] sql_get_field_int
[10:22:54] [debug] sql_get_field_ex
[10:22:54] [debug] sql_get_field_int_ex
[10:22:54] [debug] sql_affected_rows
[10:22:54] [debug] sql_get_field
[10:22:54] [debug] sql_get_field_assoc_int_ex
[10:22:54] [debug] sql_get_field_assoc_ex
[10:22:54] [debug] sql_get_field_assoc_float_ex
[10:22:54] [debug] sql_get_field_float
[10:22:54] [debug] sql_get_field_float_ex
[10:22:54] Script[gamemodes/new.amx]: Run time error 19: "File or function is not found"
[10:22:54] Number of vehicle models: 0
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7, (C)2005-2015 SA-MP Team
[10:24:13]
[10:24:13] Server Plugins
[10:24:13] --------------
[10:24:13] Loading plugin: streamer.so
[10:24:13]
*** Streamer Plugin v2.7 by Incognito loaded ***
[10:24:13] Loaded.
[10:24:13] Loading plugin: sscanf.so
[10:24:13]
[10:24:13] ===============================
[10:24:13] sscanf plugin loaded.
[10:24:13] Version: 2.8.1
[10:24:13] (c) 2012 Alex "Y_Less" Cole
[10:24:13] ===============================
[10:24:13] Loaded.
[10:24:13] Loading plugin: mysql.so
[10:24:13] Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)
[10:24:13] Loading plugin: sql.so
[10:24:13] >> SQL plugin v2.6 successfully loaded.
[10:24:13] + MySQL support is enabled.
[10:24:13] Loaded.
[10:24:13] Loaded 3 plugins.
[10:24:13]
[10:24:13] Ban list
[10:24:13] --------
[10:24:13] Loaded: samp.ban
[10:24:13]
[10:24:13]
[10:24:13] Filterscripts
[10:24:13] ---------------
[10:24:13] Loading filterscript 'yom_buttons.amx'...
[10:24:13] *** Streamer Plugin: Warning: Include file version (0x26105) does not match plugin version (0x27002) (script might need to be recompiled with the latest include file)
[10:24:13] Loading filterscript 'pockets.amx'...
[10:24:13] FS SCRIPT LOAD
[10:24:13] Loaded 2 filterscripts.
[10:24:13] Script[gamemodes/new.amx]: Run time error 19: "File or function is not found"
[10:24:13] Number of vehicle models: 0
[14:14:57] [connection] 178.234.212.17:63266 requests connection cookie.
[14:14:58] Incoming connection: 178.234.212.17:63266 id: 0
[14:14:59] [join] Nikita_Lukov has joined the server (0:178.234.212.17)
[14:15:52] [part] Nikita_Lukov has left the server (0:0)
[14:16:05] [connection] 178.234.212.17:62442 requests connection cookie.
[14:16:05] Incoming connection: 178.234.212.17:62442 id: 0
[14:16:06] [join] Nikita_Lukov has joined the server (0:178.234.212.17)
[14:19:28] [part] Nikita_Lukov has left the server (0:1)
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7, (C)2005-2015 SA-MP Team
[19:20:22]
[19:20:22] Server Plugins
[19:20:22] --------------
[19:20:22] Loading plugin: streamer.so
[19:20:22]
*** Streamer Plugin v2.7 by Incognito loaded ***
[19:20:22] Loaded.
[19:20:22] Loading plugin: sscanf.so
[19:20:22]
[19:20:22] ===============================
[19:20:22] sscanf plugin loaded.
[19:20:22] Version: 2.8.1
[19:20:22] (c) 2012 Alex "Y_Less" Cole
[19:20:22] ===============================
[19:20:22] Loaded.
[19:20:22] Loading plugin: regex.so
[19:20:22]
[19:20:22] ______________________________________
[19:20:22] Regular Expression Plugin v0.2.1 loaded
[19:20:22] ______________________________________
[19:20:22] By: Fro (c) Copyright 2009-2011
[19:20:22] ______________________________________
[19:20:22] Loaded.
[19:20:22] Loading plugin: PointToPoint.so
[19:20:22] PointToPoint Plugin Loaded.
[19:20:22] Loaded.
[19:20:22] Loading plugin: sql.so
[19:20:22] >> SQL plugin v2.6 successfully loaded.
[19:20:22] + MySQL support is enabled.
[19:20:22] Loaded.
[19:20:22] Loading plugin: mysql.so
[19:20:22] Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)
[19:20:22] Loading plugin: FileFunctions.so
[19:20:22] Loaded.
[19:20:22] Loading plugin: iTD.so
[19:20:22] Failed (plugins/iTD.so: cannot open shared object file: No such file or directory)
[19:20:22] Loading plugin: crashdetect.so
[19:20:22] CrashDetect v4.10 is OK.
[19:20:22] Loaded.
[19:20:22] Loading plugin: antiattack.so
[19:20:22] Anti-Attack plugin by BJIADOKC loaded.
[19:20:22] Loaded.
[19:20:22] Loading plugin: jit.so
[19:20:22] Failed (plugins/jit.so: cannot open shared object file: No such file or directory)
[19:20:22] Loaded 8 plugins.
[19:20:22]
[19:20:22] Ban list
[19:20:22] --------
[19:20:22] Loaded: samp.ban
[19:20:22]
[19:20:22]
[19:20:22] Filterscripts
[19:20:22] ---------------
[19:20:22] Loading filterscript 'yom_buttons.amx'...
[19:20:22] *** Streamer Plugin: Warning: Include file version (0x26105) does not match plugin version (0x27002) (script might need to be recompiled with the latest include file)
[19:20:22] Loading filterscript 'pockets.amx'...
[19:20:22] FS SCRIPT LOAD
[19:20:22] Loaded 2 filterscripts.
[19:20:22]
[19:20:22]
[19:20:22]
[19:20:22] =======================================
[19:20:22] | |
[19:20:22] | YSI version 1.06.0002 |
[19:20:22] | By Alex "Y_Less" Cole |
[19:20:22] | |
[19:20:22] =======================================
[19:20:22]
[19:20:22] [plugin.sql][warning] Natives::sql_debug: Switching the log levels to (0, 3)...
[19:20:22] [plugin.sql][warning] Natives::sql_connect: Connection (conn->id = 1) failed! (error = 2002, Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
[19:20:22] Не удалось подключиться к MySQL
[19:20:22] Number of vehicle models: 0
Последнее редактирование модератором:
