Помогите

[CreyV]

Смотрите значит всё так вот вам ошибки


----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[16:49:34] rcon_password = "changeme" (string)
[16:49:34]
[16:49:34] Server Plugins
[16:49:34] --------------
[16:49:34] Loading plugin: AntiDDoS_Guard.so
[16:49:34] AntiDDoS Guard Error: Initialization failed (Invalid bind IP: 10.11.0.1)
[16:49:34] Failed.
[16:49:34] Loading plugin: crashdetect.so
[16:49:34] CrashDetect v4.18.1 is OK.
[16:49:34] Loaded.
[16:49:34] Loading plugin: mysql.so
[16:49:34] Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)
[16:49:34] Loading plugin: mysql_static.so
[16:49:34] >> plugin.mysql: R39-6 successfully loaded.
[16:49:34] Loaded.
[16:49:34] Loading plugin: pawncmd.so
[16:49:34] Pawn.CMD plugin v3.1.3 by urShadow loaded
[16:49:34] Loaded.
[16:49:34] Loading plugin: pawnraknet.so
[16:49:34] Pawn.RakNet plugin v1.0.2 by urShadow loaded
[16:49:34] Loaded.
[16:49:34] Loading plugin: regex.so
[16:49:34]


[16:49:34] ______________________________________


[16:49:34] Regular Expression Plugin v0.2.1 loaded
[16:49:34] ______________________________________


[16:49:34] By: Fro (c) Copyright <TBG> 2009-2011
[16:49:34] ______________________________________


[16:49:34] Loaded.
[16:49:34] Loading plugin: sscanf.so
[16:49:34]

[16:49:34] ===============================

[16:49:34] sscanf plugin loaded.

[16:49:34] Version: 2.8.3

[16:49:34] (c) 2018 Alex "Y_Less" Cole

[16:49:34] ===============================

[16:49:34] Loaded.
[16:49:34] Loading plugin: streamer.so
[16:49:34]

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[16:49:34] Loaded.
[16:49:34] Loading plugin: pawnraknet.so
[16:49:34] Pawn.RakNet plugin v1.0.2 by urShadow loaded
[16:49:34] Loaded.
[16:49:34] Loaded 8 plugins.

[16:49:34]
[16:49:34] Filterscripts
[16:49:34] ---------------
[16:49:34] Loading filterscript 'mapfix.amx'...
[16:49:34] Unable to load filterscript 'mapfix.amx'.
[16:49:34] Loading filterscript 'online.amx'...
[16:49:34] [debug] Run time error 19: "File or function is not found"
[16:49:34] [debug] PB_RegisterBot
[16:49:34] Loaded 1 filterscripts.

[16:49:34]
[16:49:34] --------------------------------------
[16:49:34] Античит Nex-AC загружен!
[16:49:34] Версия античита: 1.9.51
[16:49:34] Автор: Nexius
[16:49:34] Coздaтeль кoпии мoдa WАNТЕD СНАNNЕL [vк.соm/wаntеd_сhаnnеl]
[16:49:34] --------------------------------------

[16:49:34] Coздaтeль кoпии мoдa WАNТЕD СНАNNЕL [vк.соm/wаntеd_сhаnnеl]
[16:49:34] Подключиться к базе не удалось
[16:49:34] ++
[16:49:34] [debug] Run time error 19: "File or function is not found"
[16:49:34] [debug] PB_RegisterBot
[16:49:34] Number of vehicle models: 98
[16:49:34] [Pawn.CMD] n_PC_RegAlias: alias 'sp' is occupied
[16:50:37] [connection] 93.125.71.74:14112 requests connection cookie.
[16:50:37] [connection] incoming connection: 93.125.71.74:14112 id: 0
[16:50:38] [join] Stas_Fedorovich has joined the server (0:93.125.71.74)
[16:50:38] [debug] Run time error 19: "File or function is not found"
[16:50:38] [debug] PB_RegisterBot
[16:50:38] Coздaтeль кoпии мoдa WАNТЕD СНАNNЕL [vк.соm/wаntеd_сhаnnеl]
[16:50:38] sscanf warning: String buffer overflow.
[16:50:38] sscanf warning: String buffer overflow.
[16:50:40] [connection] 217.66.159.83:18518 requests connection cookie.
[16:50:40] [connection] incoming connection: 217.66.159.83:18518 id: 1
[16:50:41] [join] Maksim_Podovinnikov has joined the server (1:217.66.159.83)
[16:50:41] [debug] Run time error 19: "File or function is not found"
[16:50:41] [debug] PB_RegisterBot
[16:50:41] Coздaтeль кoпии мoдa WАNТЕD СНАNNЕL [vк.соm/wаntеd_сhаnnеl]
[16:50:42] sscanf warning: String buffer overflow.
[16:50:42] sscanf warning: String buffer overflow.
[16:51:00] > Игрок Maksim_Podovinnikov был кикнут с сервера. [ID: 1][IP: 217.66.159.83]
[16:51:00] [debug] Run time error 19: "File or function is not found"
[16:51:00] [debug] PB_RegisterBot
[16:51:00] [debug] Run time error 19: "File or function is not found"
[16:51:00] [debug] PB_RegisterBot
[16:51:00] [part] Maksim_Podovinnikov has left the server (1:2)
[16:51:08] > Игрок Stas_Fedorovich был кикнут с сервера. [ID: 0][IP: 93.125.71.74]
[16:51:08] [debug] Run time error 19: "File or function is not found"
[16:51:08] [debug] PB_RegisterBot
[16:51:08] [debug] Run time error 19: "File or function is not found"
[16:51:08] [debug] PB_RegisterBot
[16:51:08] [part] Stas_Fedorovich has left the server (0:2)
[16:56:21] [connection] 217.66.159.83:21659 requests connection cookie.
[16:56:21] [connection] incoming connection: 217.66.159.83:21659 id: 0
[16:56:24] [join] Maksim_Podovinnikov has joined the server (0:217.66.159.83)
[16:56:24] [debug] Run time error 19: "File or function is not found"
[16:56:24] [debug] PB_RegisterBot
[16:56:24] Coздaтeль кoпии мoдa WАNТЕD СНАNNЕL [vк.соm/wаntеd_сhаnnеl]
[16:56:25] sscanf warning: String buffer overflow.
[16:56:25] sscanf warning: String buffer overflow.
[16:56:38] > Игрок Maksim_Podovinnikov был кикнут с сервера. [ID: 0][IP: 217.66.159.83]
[16:56:38] [debug] Run time error 19: "File or function is not found"
[16:56:38] [debug] PB_RegisterBot
[16:56:38] [debug] Run time error 19: "File or function is not found"
[16:56:38] [debug] PB_RegisterBot
[16:56:38] [part] Maksim_Podovinnikov has left the server (0:2)

Вот вам Посмотреть вложение 248039Проверил все данные верны Так что же не так? вот вам еще и файл базы данных https://drive.google.com/file/d/1MWW3hqwbe5-2PZiX9J4qwRminAwYrJrR/view?usp=drive_link

 

[Cocolemunto.]

как минимум

Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)

нет файла libmysqlclient.so в папке plugins

 

[CreyV]

как минимум

нет файла libmysqlclient.so в папке plugins

Привет, а как его создать? И что должно быть внутри?

 

[Cocolemunto.]

Привет, а как его создать? И что должно быть внутри?

скачать.
*кликабельно*

 

[CreyV]

скачать.
*кликабельно*

А можно от тебя поэтапный гайд просто смотрю в инете не могу найти а если нахожу вижу что mysql переменовать нуууууу вообще сомнительно

 

[Cocolemunto.]

1. Возможно не подключен include <a_mysql>
2. Есть вероятность, что по какой либо причине у вас нету инклюда в папке pawno (ваш мод - pawno - include - закиньте версию инклюда, который соответствует версии вашего плагина.)
3. Наиболее распространённая причина появления данной ошибки : отсутствует mysql_static.so в папке plugins. При установки с официального гитхаба проекта (https://github.com/pBlueG/SA-MP-MySQL/releases) выбираешь архив
mysql-R41-4-Debian-static.tar.gz", от туда вытаскиваете файл "mysql" из папки plugins, переименовываете как "mysql_static.so" и закидываете в папку "plugins" в корне вашего сервера.

 

[CreyV]

1. Незнаю как проверить где. В моде подключил павно
2. Вот скрины

И вот 2

3. Вот файлы в плагинс

Так что не так?

 

[Cocolemunto.]

1. Незнаю как проверить где. В моде подключил павно
2. Вот скрины Посмотреть вложение 248093И вот 2
Посмотреть вложение 248094

3. Вот файлы в плагинс
Посмотреть вложение 248095

Так что не так?

Покажи server.cfg

 

[CreyV]

Покажи server.cfg

87echo Executing Server Config...
lanmode 0
rcon_password
maxplayers 1000
hostname YOUTUBE RP | BETA TEST!
gamemode0 youtube
filterscripts
announce 1
bind 194.93.2.226
port 6626
query 1
weburl
maxnpc 0
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
plugins crashdetect.so streamer.so mysql_static.so pawncmd.so regex.so SKY.so sscanf.so


А так же проверил бинд всё верно и порт тоже

 

[dsaf1]

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

 

[CreyV]

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

Ты пришёл помогать? Если да так помогай.

 

[Cocolemunto.]

87echo Executing Server Config...
lanmode 0
rcon_password
maxplayers 1000
hostname YOUTUBE RP | BETA TEST!
gamemode0 youtube
filterscripts
announce 1
bind 194.93.2.226
port 6626
query 1
weburl
maxnpc 0
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
plugins crashdetect.so streamer.so mysql_static.so pawncmd.so regex.so SKY.so sscanf.so


А так же проверил бинд всё верно и порт тоже

в plugins напиши еще mysql.so pawnbots.so pawnraknet.so

 

[CreyV]

в plugins напиши еще mysql.so pawnbots.so pawnraknet.so

Изменил вот код
87echo Executing Server Config...
lanmode 0
rcon_password
maxplayers 1000
hostname YOUTUBE RP | BETA TEST!
gamemode0 youtube
filterscripts
announce 1
bind 194.93.2.226
port 6626
query 1
weburl
maxnpc 0
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
plugins crashdetect.so streamer.so mysql_static.so pawncmd.so regex.so SKY.so sscanf.so mysql.so pawnbots.so pawnraknet.so

Чёт не робит

текст с сервера лог


----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[15:50:40] rcon_password = "changeme" (string)
[15:50:40] filterscripts = "" (string)
[15:50:40] weburl = "www.sa-mp.com" (string)
[15:50:40]
[15:50:40] Server Plugins
[15:50:40] --------------
[15:50:40] Loading plugin: crashdetect.so
[15:50:40] CrashDetect v4.15.1 is OK.
[15:50:40] Loaded.
[15:50:40] Loading plugin: streamer.so
[15:50:40]

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[15:50:40] Loaded.
[15:50:40] Loading plugin: mysql_static.so
[15:50:40] >> plugin.mysql: R37 successfully loaded.
[15:50:40] Loaded.
[15:50:40] Loading plugin: pawncmd.so
[15:50:40] Pawn.CMD plugin v3.1.2 by urShadow loaded
[15:50:40] Loaded.
[15:50:40] Loading plugin: regex.so
[15:50:40]


[15:50:40] ______________________________________


[15:50:40] Regular Expression Plugin v0.2.1 loaded
[15:50:40] ______________________________________


[15:50:40] By: Fro (c) Copyright <TBG> 2009-2011
[15:50:40] ______________________________________


[15:50:40] Loaded.
[15:50:40] Loading plugin: SKY.so
[15:50:40] Loaded.
[15:50:40] Loading plugin: sscanf.so
[15:50:40]

[15:50:40] ===============================

[15:50:40] sscanf plugin loaded.

[15:50:40] (c) 2009 Alex "Y_Less" Cole

[15:50:40] 0.3d-R2 500 Players "dnee"

[15:50:40] ===============================

[15:50:40] Loaded.
[15:50:40] Loading plugin: mysql.so
[15:50:40] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[15:50:40] Loading plugin: pawnbots.so
[15:50:40] Pawn.Bots plugin v0.2.1 by urShadow loaded
[15:50:40] Loaded.
[15:50:40] Loading plugin: pawnraknet.so
[15:50:40] Pawn.RakNet plugin v1.0.2 by urShadow loaded
[15:50:40] Loaded.
[15:50:40] Loaded 9 plugins.

[15:50:40]
[15:50:40] Filterscripts
[15:50:40] ---------------
[15:50:40] Loaded 0 filterscripts.

[15:50:40]
[15:50:40] --------------------------------------
[15:50:40] Античит Nex-AC загружен!
[15:50:40] Версия античита: 1.9.51
[15:50:40] Автор: Nexius
[15:50:40] --------------------------------------

[15:50:40] OnGameo
[15:50:40] Подключиться к базе не удалось!
[15:50:40] Number of vehicle models: 99
[15:52:14] [connection] 93.125.71.74:60436 requests connection cookie.
[15:52:15] [connection] incoming connection: 93.125.71.74:60436 id: 0
[15:52:15] [join] Stas_Fedorovich has joined the server (0:93.125.71.74)
[15:52:15] sscanf warning: String buffer overflow.
[15:52:15] sscanf warning: String buffer overflow.
[15:52:45] > Игрок Stas_Fedorovich был кикнут с сервера. [ID: 0][IP: 93.125.71.74]
[15:52:45] [part] Stas_Fedorovich has left the server (0:2)

Что делать?

 

[capasso]

Изменил вот код
87echo Executing Server Config...
lanmode 0
rcon_password
maxplayers 1000
hostname YOUTUBE RP | BETA TEST!
gamemode0 youtube
filterscripts
announce 1
bind 194.93.2.226
port 6626
query 1
weburl
maxnpc 0
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
plugins crashdetect.so streamer.so mysql_static.so pawncmd.so regex.so SKY.so sscanf.so mysql.so pawnbots.so pawnraknet.so

Чёт не робит

Посмотреть вложение 248114
Посмотреть вложение 248115
Посмотреть вложение 248116



текст с сервера лог


----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[15:50:40] rcon_password = "changeme" (string)
[15:50:40] filterscripts = "" (string)
[15:50:40] weburl = "www.sa-mp.com" (string)
[15:50:40]
[15:50:40] Server Plugins
[15:50:40] --------------
[15:50:40] Loading plugin: crashdetect.so
[15:50:40] CrashDetect v4.15.1 is OK.
[15:50:40] Loaded.
[15:50:40] Loading plugin: streamer.so
[15:50:40]

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[15:50:40] Loaded.
[15:50:40] Loading plugin: mysql_static.so
[15:50:40] >> plugin.mysql: R37 successfully loaded.
[15:50:40] Loaded.
[15:50:40] Loading plugin: pawncmd.so
[15:50:40] Pawn.CMD plugin v3.1.2 by urShadow loaded
[15:50:40] Loaded.
[15:50:40] Loading plugin: regex.so
[15:50:40]


[15:50:40] ______________________________________


[15:50:40] Regular Expression Plugin v0.2.1 loaded
[15:50:40] ______________________________________


[15:50:40] By: Fro (c) Copyright <TBG> 2009-2011
[15:50:40] ______________________________________


[15:50:40] Loaded.
[15:50:40] Loading plugin: SKY.so
[15:50:40] Loaded.
[15:50:40] Loading plugin: sscanf.so
[15:50:40]

[15:50:40] ===============================

[15:50:40] sscanf plugin loaded.

[15:50:40] (c) 2009 Alex "Y_Less" Cole

[15:50:40] 0.3d-R2 500 Players "dnee"

[15:50:40] ===============================

[15:50:40] Loaded.
[15:50:40] Loading plugin: mysql.so
[15:50:40] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[15:50:40] Loading plugin: pawnbots.so
[15:50:40] Pawn.Bots plugin v0.2.1 by urShadow loaded
[15:50:40] Loaded.
[15:50:40] Loading plugin: pawnraknet.so
[15:50:40] Pawn.RakNet plugin v1.0.2 by urShadow loaded
[15:50:40] Loaded.
[15:50:40] Loaded 9 plugins.

[15:50:40]
[15:50:40] Filterscripts
[15:50:40] ---------------
[15:50:40] Loaded 0 filterscripts.

[15:50:40]
[15:50:40] --------------------------------------
[15:50:40] Античит Nex-AC загружен!
[15:50:40] Версия античита: 1.9.51
[15:50:40] Автор: Nexius
[15:50:40] --------------------------------------

[15:50:40] OnGameo
[15:50:40] Подключиться к базе не удалось!
[15:50:40] Number of vehicle models: 99
[15:52:14] [connection] 93.125.71.74:60436 requests connection cookie.
[15:52:15] [connection] incoming connection: 93.125.71.74:60436 id: 0
[15:52:15] [join] Stas_Fedorovich has joined the server (0:93.125.71.74)
[15:52:15] sscanf warning: String buffer overflow.
[15:52:15] sscanf warning: String buffer overflow.
[15:52:45] > Игрок Stas_Fedorovich был кикнут с сервера. [ID: 0][IP: 93.125.71.74]
[15:52:45] [part] Stas_Fedorovich has left the server (0:2)

Что делать?

mysql_connect ищи в моде и подключи БД

 

[CreyV]

mysql_connect ищи в моде и подключи БД

Привет вот коды
#define sqlhost "127.0.0.1" // Адрес хоста
#define sqluser "user45*28" // Имя пользователя
#define sqlpass "jSK0x*L*LdqE" // Пароль
#define sqldb "user45*28" // Имя Базы данных

вот еще код
CreateMySQLConnection(sqlhost, sqluser, sqldb, sqlpass); // База данных номер 1
return true;

и вот еще

stock CreateMySQLConnection(host[], user[], db[], pass[])
{
connects = mysql_connect(host, user, db, pass);
if(mysql_errno()==0)
{
print("------- БД Youtube RP -----");
printf("Подключение к базе успешно!");
}
else
{
print("--------- БД Youtube RP -------");
printf("Подключиться к базе не удалось!");

Что не так? Я пробыл в третем варианте и sql добавлял и без sql что не так?