Konekcija

Započeo keenoo, Septembar 01, 2022, 20:09:42 POSLE PODNE

prethodna tema - sledeća tema

0 članova i 2 gostiju pregledaju ovu temu.

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 [[email protected] -> 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
Poslednja Izmena: Septembar 01, 2022, 20:17:00 POSLE PODNE od // Keno

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]




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.