[закрыто] Не подключается БД

[0]

Здравствуйте, у меня возникла проблема, не подключается БД, все данные вписал правильно.

 

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

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

[21:33:08] filterscripts = ""  (string)
[21:33:08] 
[21:33:08] Server Plugins
[21:33:08] --------------
[21:33:08]  Loading plugin: crashdetect
[21:33:08]   CrashDetect plugin 4.19
[21:33:08]   Loaded.
[21:33:08]  Loading plugin: mysql
[21:33:08]  >> plugin.mysql: R41-4 successfully loaded.
[21:33:08]   Loaded.
[21:33:08]  Loading plugin: sscanf
[21:33:08] 

[21:33:08]  ===============================

[21:33:08]       sscanf plugin loaded.     

[21:33:08]          Version:  2.8.2        

[21:33:08]    (c) 2012 Alex "Y_Less" Cole  

[21:33:08]  ===============================

[21:33:08]   Loaded.
[21:33:08]  Loading plugin: streamer
[21:33:08] 

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

[21:33:08]   Loaded.
[21:33:08]  Loading plugin: pawncmd
[21:33:08] Pawn.CMD plugin v3.1.4 by urShadow loaded
[21:33:08]   Loaded.
[21:33:08]  Loading plugin: pawnraknet
[21:33:08] Pawn.RakNet plugin v1.2.0 by urShadow loaded
[21:33:08]   Loaded.
[21:33:08]  Loading plugin: CRP
[21:33:08] 

[21:33:08] ______________________________________

[21:33:08]  Convert Rus To Pwn v0.1.1 loaded
[21:33:08] ______________________________________

[21:33:08]  By: Fro (c) Copyright <TBG> 2009-2011
[21:33:08] ______________________________________

[21:33:08]   Loaded.
[21:33:08]  Loading plugin: TOTP
[21:33:08] TOTP plugin v1.0.0 by Games loaded.
[21:33:08]   Loaded.
[21:33:08]  Loaded 8 plugins.

[21:33:08] 
[21:33:08] Filterscripts
[21:33:08] ---------------
[21:33:08]   Loaded 0 filterscripts.

[21:33:08]  
[21:33:08] --------------------------------------
[21:33:08]  Античит Nex-AC загружен!
[21:33:08]  Nex-AC: 1.9.37
[21:33:08]  Автор: Nexius
[21:33:08] --------------------------------------

[21:33:08] -> Динамических объектов: 20372
[21:33:08] -> Статических объектов: 167
[21:33:08] -> Видимых объектов (стример): 1000
[21:33:08] -> Количество транспорта: 355
[21:33:08] Number of vehicle models: 80

 

В чем может быть проблема?

[525]

@TakeshiR, а как вы определили, что не подключается?

[0]

Должно быть вот так 

Спойлер

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

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

[23:39:13] filterscripts = ""  (string)
[23:39:13] 
[23:39:13] Server Plugins
[23:39:13] --------------
[23:39:13]  Loading plugin: mysql
[23:39:13]  >> plugin.mysql: R41-4 successfully loaded.
[23:39:13]   Loaded.
[23:39:13]  Loading plugin: sscanf
[23:39:13] 

[23:39:13]  ===============================

[23:39:13]       sscanf plugin loaded.     

[23:39:13]          Version:  2.8.2        

[23:39:13]    (c) 2012 Alex "Y_Less" Cole  

[23:39:13]  ===============================

[23:39:13]   Loaded.
[23:39:13]  Loading plugin: streamer
[23:39:13] 

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

[23:39:13]   Loaded.
[23:39:13]  Loading plugin: pawncmd
[23:39:13] Pawn.CMD plugin v3.1.4 by urShadow loaded
[23:39:13]   Loaded.
[23:39:13]  Loading plugin: pawnraknet
[23:39:13] Pawn.RakNet plugin v1.2.0 by urShadow loaded
[23:39:13]   Loaded.
[23:39:13]  Loading plugin: CRP
[23:39:13] 

[23:39:13] ______________________________________

[23:39:13]  Convert Rus To Pwn v0.1.1 loaded
[23:39:13] ______________________________________

[23:39:13]  By: Fro (c) Copyright <TBG> 2009-2011
[23:39:13] ______________________________________

[23:39:13]   Loaded.
[23:39:13]  Loading plugin: TOTP
[23:39:13] TOTP plugin v1.0.0 by Games loaded.
[23:39:13]   Loaded.
[23:39:13]  Loaded 7 plugins.

[23:39:13] 
[23:39:13] Filterscripts
[23:39:13] ---------------
[23:39:13]   Loaded 0 filterscripts.

[23:39:13]  
[23:39:13] --------------------------------------
[23:39:13]  Античит Nex-AC загружен!
[23:39:13]  Nex-AC: 1.9.37
[23:39:13]  Автор: Nexius
[23:39:13] --------------------------------------

[23:39:18] -> Динамических объектов: 20372
[23:39:18] -> Статических объектов: 167
[23:39:18] -> Видимых объектов (стример): 1000
[23:39:18] -> Количество транспорта: 355
[23:39:18] Number of vehicle models: 80
[23:39:18] [LOADED_CARS]: 234, заняло времени: 242 мс
[23:39:18] [LOADED_BUSINESS]: 106, заняло времени: 91 мс
[23:39:18] [LOADED_VOTE]: Данные в базе не найдены
[23:39:18] [LOADED_ENTERS]: 73, времени потрачено: 33 мс
[23:39:18] [LOADED_ENTERS]: Данные в базе не найдены
[23:39:18] [PHONE]: Всего загружено: 1. Потрачено: 0 мс.
[23:39:18] [LOADED_HOUSES]: 430, времени потрачено: 230 мс
[23:39:18] [Загружено комнат в хостеле]: <0>. Потрачено: <0 ms>.
[23:39:18] [Загружены склады мафий]: Потрачено: <0 ms>.
[23:39:18] [BANDS LOADED]: Потрачено: <0 ms>.
[23:39:18] [Загружено гангзон]: <105>. Потрачено: <23 ms>.
[23:39:18] [Загружено банкоматов]: <10>. Потрачено: <11 ms>.
[23:39:18] [Загружено остальное]: Потрачено: <4 ms>.
[23:39:18] [LOADED_GARBAGE]: 0, заняло времени: 1 мс
[23:39:18] Номеров загружено: 21
[23:39:18] [LOADED GARAGE]: 153, заняло времени 52 мс

 

 

 

 

 

вот еще лог

[19:04:41] [WARNING] mysql_connect: no password specified (C:\Users\Илья\Desktop\Maryland\gamemodes\gm.pwn:394 -> ..\source\lib\mdialog.inc:348 -> ..\source\lib\nex-ac.inc:2834 -> ..\source\lib\sscanf2.inc:204)
[19:04:49] [WARNING] mysql_connect: no password specified (C:\Users\Илья\Desktop\Maryland\gamemodes\gm.pwn:394 -> ..\source\lib\mdialog.inc:348 -> ..\source\lib\nex-ac.inc:2834 -> ..\source\lib\sscanf2.inc:204)
[19:04:49] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060'
[19:04:49] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060'
[19:04:49] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060'
[19:04:49] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060'
[19:04:49] [ERROR] mysql_tquery: callback error: callback "StartServerVote" does not exist (C:\Users\Илья\Desktop\Maryland\gamemodes\gm.pwn:394 -> ..\source\lib\mdialog.inc:348 -> ..\source\lib\nex-ac.inc:2834 -> ..\source\lib\sscanf2.inc:204)

 

Отредактировано 8 марта, 2019 пользователем Shakoladka

[5]

@TakeshiR В pawno найди строки

#define SQL_HOST 						"host"
#define SQL_USER 						"database или user"
#define SQL_DB 							"database или user"
#define SQL_PASS 						"пароль"

#define LOCAL_SQL_HOST      			"host"
#define LOCAL_SQL_USER      			"database или user"
#define LOCAL_SQL_DB      				"database или user"
#define LOCAL_SQL_PASS      			"пароль"

и поменяй на свои значения с хостинга.

_______________________________

upd:

если нету этих строк, а такое может быть, то зайди в папку с модом

scriptfiles - там будет mysql_connect, туда впиши свои значения с хостинга