Problem(error/warning): Neuspjesna konekcija na mysql
Deo skripte:
Pawno Code: [Izaberi]
Vaš odgovor
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):
Pawno Code: [Izaberi]
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[11:07:32] filterscripts = "" (string)
[11:07:32]
[11:07:32] Server Plugins
[11:07:32] --------------
[11:07:32] Loading plugin: sscanf.so
[11:07:32]
[11:07:32] ===============================
[11:07:32] sscanf plugin loaded.
[11:07:32] Version: 2.8.3
[11:07:32] (c) 2018 Alex "Y_Less" Cole
[11:07:32] ===============================
[11:07:32] Loaded.
[11:07:32] Loading plugin: mysql.so
[11:07:32] >> plugin.mysql: R41-4 successfully loaded.
[11:07:32] Loaded.
[11:07:32] Loading plugin: pawncmd.so
[11:07:32] Pawn.CMD plugin v3.1.2 by urShadow loaded
[11:07:32] Loaded.
[11:07:32] Loading plugin: streamer.so
[11:07:32]
*** Streamer Plugin v2.9.5 by Incognito loaded ***
[11:07:32] Loaded.
[11:07:32] Loading plugin: pawnraknet.so
[11:07:32] [Pawn.RakNet] plugin v1.5.1 loading...
[11:07:32] [Pawn.RakNet]
| Pawn.RakNet 1.5.1 | 2016 - 2021
|--------------------------------
| Author and maintainer: katursis
| Compiled: Sep 26 2021 at 08:32:38
|--------------------------------------------------------------
| Repository: https://github.com/katursis/Pawn.RakNet
|--------------------------------------------------------------
| Wiki: https://github.com/katursis/Pawn.RakNet/wiki
[11:07:32] Loaded.
[11:07:32] Loading plugin: pawnregex.so
[11:07:32] [Pawn.Regex] plugin v1.2.3 loading...
[11:07:32] [Pawn.Regex]
| Pawn.Regex 1.2.3 | 2016 - 2021
|--------------------------------
| Author and maintainer: katursis
| Compiled: Sep 26 2021 at 08:30:36
|--------------------------------------------------------------
| Repository: https://github.com/katursis/Pawn.Regex
[11:07:32] Loaded.
[11:07:32] Loading plugin: timerfix.so
[11:07:32] >> TimerFix v1.7 successfully loaded.
[11:07:32] Loaded.
[11:07:32] Loading plugin: SKY.so
[11:07:32] Loaded.
[11:07:32] Loaded 8 plugins.
[11:07:32]
[11:07:32] Filterscripts
[11:07:32] ---------------
[11:07:32] Loaded 0 filterscripts.
[11:07:32]
[11:07:32] (SQL - tmpStructure): Konekcija sa [u18868_Gq4eOfTs23@185.213.174.139 -> s18868_lg_db] je neuspesna.
[11:07:32] (MODE - tmpStructure): Started version [v1.0.0] on 'Windows'.
[11:07:32]
[11:07:32] Number of vehicle models: 0
Slika/video ingame problema(obavezno ako je ingame problem): link slike
evo log
[pawn][09/01/22 11:07:32] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1045 'Access denied for user 'u18868_Gq4eOfTs23'
@'nl3.optiklink.com' (using password: YES)'
[/pawn]
poz
Pogresni podatci?
Citat: // Keno poslato Septembar 02, 2022, 21:48:32 POSLE PODNE
nisu pogresni provjerio sam
posalji da pogledamo kako si ih definisao i to
Citat: // Keno poslato Septembar 02, 2022, 21:48:32 POSLE PODNE
nisu pogresni provjerio sam
Kako si provjerio? Mozda je nl3.optiklink.com samo za phpmyadmin.
Probaj host da zamenis sa localhost posto radi sigurnosti mnogi admini zabrane externe konekcije.
#define MYSQL_HOST "nl3.optiklink.com"
#define MYSQL_USER "username tvoj sa optiklinka"
#define MYSQL_PASS "password sa optiklink database configurationa"
#define MYSQL_DB "ime baze kako si je kreirao na optiklinku"
i obavezno koristi mysql mysql_static.so plugin. za optiklink.
Neaktivna tema... Lock...