mysql

Iv0r_. Započeo Iv0r_.
pre 4 godine
2,107
pregleda
29
postova
Ova tema je zaključana. Samo moderatori i administratori mogu odgovarati.
Iv0r_.
Enforcer
pre 4 godine
Problem(error/warning): Nece da se poveze na bazu. Znaci, ja znam lepo da spojim bazu i da radi, i na svim modovima kad spajam radi, samo vamo nece, startam xampp, napravim bazu pod tim i tim imenom, prekopiram iz .sql fajla, ono radi, ucitalo je sve users, vehicles itd itd sve na phpmyadmin radi, međutim, kada se starta samp-server.exe, pise ne uspesna konekcija.
Deo skripte:
Vaš odgovor

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):
VNeuspesna konekcija srv_1086281_EeA@91.134.193.97 -> srv_1086281_EeA
[npc:join] TrainDriver has joined the server (999:127.0.0.1)
[npc:join] Vojnik_1 has joined the server (998:127.0.0.1)
[npc:join] Vojnik_2 has joined the server (997:127.0.0.1)
[npc:join] Vojnik_3 has joined the server (996:127.0.0.1)
[npc:join] Vojnik_4 has joined the server (995:127.0.0.1)
[npc:join] Vojnik_5 has joined the server (994:127.0.0.1)
[npc:join] Kapetan has joined the server (993:127.0.0.1)
[npc:join] Vojnik_6 has joined the server (992:127.0.0.1)
[npc:join] Vojnik_7 has joined the server (991:127.0.0.1)
AntiCheat ocitan!
Statistika servera ocitana!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!

Gamemode ucitan!
      KURAC Gaming Community

Number of vehicle models: 2

Slika/video ingame problema(obavezno ako je ingame problem): znate vec koji je mod 😄
D1NO
Crime Lord
pre 4 godine
"Neuspesna konekcija"
Gle, na PHP-u nazovi bazu kako si je u skripti definisao, importraj .sql fajl, izmjeni ime, pass, host i to u skripti.Definisi kako je i na PHP-u
Ako pokreces na localhostu ovo, upali XAMPP postavi, i localhost definiraj
Iv0r_.
Enforcer
pre 4 godine
ɴᴏᴅɪ wrote on December 1, 2021, 8:33 pm:
"Neuspesna konekcija"
Gle, na PHP-u nazovi bazu kako si je u skripti definisao, importraj .sql fajl, izmjeni ime, pass, host i to u skripti.Definisi kako je i na PHP-u
Ako pokreces na localhostu ovo, upali XAMPP postavi, i localhost definiraj

non stop izbacuje neuspesna konekcija.
Kreiram databazu na php, idem sql, prebacim sve sto pise tamo u sql, i onda idem import. i onda pokrecem ? Ili
D1NO
Crime Lord
pre 4 godine
Iv0r_. wrote on December 1, 2021, 10:20 pm:
non stop izbacuje neuspesna konekcija.
Kreiram databazu na php, idem sql, prebacim sve sto pise tamo u sql, i onda idem import. i onda pokrecem ? Ili

gle, ja ne znam sta ti paste-as i to.Ali najlakse je da kreiras bazu i importas .sql file ili ti ga samu bazu
Iv0r_.
Enforcer
pre 4 godine
%u0274%u1D0F%u1D05%u026A wrote on December 2, 2021, 3:32 pm:
gle, ja ne znam sta ti paste-as i to.Ali najlakse je da kreiras bazu i importas .sql file ili ti ga samu bazu

Napravio sam, izadje ovo.
Konekcija uspesna root@localhost -> kurac
[npc:join] Vojnik_1 has joined the server (999:127.0.0.1)
[npc:join] Vojnik_2 has joined the server (998:127.0.0.1)
[npc:join] Vojnik_3 has joined the server (997:127.0.0.1)
[npc:join] Vojnik_4 has joined the server (996:127.0.0.1)
[npc:join] Vojnik_5 has joined the server (995:127.0.0.1)
[npc:join] Kapetan has joined the server (994:127.0.0.1)
[npc:join] Vojnik_6 has joined the server (993:127.0.0.1)
[npc:join] Vojnik_7 has joined the server (992:127.0.0.1)
AntiCheat ocitan!
Statistika servera ocitana!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
KURAC - dadada.com
DEVELOPER: IVOR
v1.0 - UCITAVANJE...
Number of vehicle models: 0

i nista kasnije ne loada. P.S ovo vise nije 2.0 ovo je 1.0 ona prva.
Starto XAMPP, kreirao novu databazu, usao u nju, onda import, ubacio .sql fajl, ceko 1min, pisalo ono zeleno kao sve radi. Udjem vidim sve racuni, vozila itd itd... Startam samp-server.exe, pise ono gore ucitano i to. I nece nista poslije tog. Udjem na srw i uvijek je Server closed the connection ili dole one levo i desno strelice... Svaki drugi mod od MYSQL radi samo ovaj nece, svaki radi samo ovaj ne...
D1NO
Crime Lord
pre 4 godine
Log?Crashdetect?
Exnas.pwn
Godfather
pre 4 godine
Pa sve ti bukvalno pise, nisu tacni podatci za login na mysql bazu. Jesi compile mod ?
Iv0r_.
Enforcer
pre 4 godine
__vedran.xyz77 wrote on December 3, 2021, 12:56 am:
Pa sve ti bukvalno pise, nisu tacni podatci za login na mysql bazu. Jesi compile mod ?

naravno 😄
Iv0r_.
Enforcer
pre 4 godine
__vedran.xyz77 wrote on December 3, 2021, 12:56 am:
Pa sve ti bukvalno pise, nisu tacni podatci za login na mysql bazu. Jesi compile mod ?

Jesu... tocni su.. Pogledaj...
Ovako je definisano u skripti...
//=================================[ MySql ]====================================

#define kucni

#if defined kucni
    #define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DB "kurac"
#else
    #define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DB "kurac"
#endif

new _dbConnector, sql_str[ 128 ];

//==================================[ Igraci ]==================================

Otisao sam napravit novu bazu u mysql phpmyadmin i kliknio Novo -> kurac -> otisao import -> kliknio na pregledaj i štiklirao mod -> I onda je pisalo ono zeleno, desno vidim sve kreirano -> Pokrenem samp-server.exe i pise ovo.
Quote
----------
Loaded log file: "server_log.txt".
----------

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

filterscripts = ""  (string)

Server Plugins
--------------
Loading plugin: sscanf

===============================

      sscanf plugin loaded.

        Version:  2.8.1

  (c) 2012 Alex "Y_Less" Cole

===============================

  Loaded.
Loading plugin: crashdetect
  CrashDetect v4.17 is OK.
  Loaded.
Loading plugin: pawnraknet
Pawn.RakNet plugin v1.3.0 by urShadow has been loaded
  Loaded.
Loading plugin: mysql
>> plugin.mysql: R39-5 successfully loaded.
  Loaded.
Loading plugin: streamer

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

  Loaded.
Loading plugin: FCNPC

-------------------------------------------------
    FCNPC - Fully Controllable NPC v2.0.0
            Windows SA-MP 0.3.7 R2
          Jan  2 2019 at 23:09:26

  Author:      OrMisicL (2013 - 2015)
  Continued by: ziggi    (2016 - present)

  See full credits in the README.md file
-------------------------------------------------

Loading...

-------------------------------------------------
  ColAndreasv1.4.0

  Created By:
    Chris42O
    Slice
    Pottus
-------------------------------------------------

Loading...
ColAndreas v1.4.0 Loaded.
  Loaded.
Loading plugin: SKY
  Loaded.
Loading plugin: pawncmd
Pawn.CMD plugin v3.2.0 by urShadow has been loaded
  Loaded.
Loaded 8 plugins.

Started server on port: 7777, with maxplayers: 1000 lanmode is OFF.

Filterscripts
---------------
  Loaded 0 filterscripts.

No collision data found.

=======================================
|                                    |
|        YSI version 4.00.0001        |
|        By Alex "Y_Less" Cole        |
|                                    |
=======================================

--------------------------------------
Anticheat Nex-AC loaded!
Anticheat version: 1.9.49
Author: Nexius
--------------------------------------

Konekcija uspesna root@localhost -> kurac
[npc:join] Vojnik_1 has joined the server (999:127.0.0.1)
[npc:join] Vojnik_2 has joined the server (998:127.0.0.1)
[npc:join] Vojnik_3 has joined the server (997:127.0.0.1)
[npc:join] Vojnik_4 has joined the server (996:127.0.0.1)
[npc:join] Vojnik_5 has joined the server (995:127.0.0.1)
[npc:join] Kapetan has joined the server (994:127.0.0.1)
[npc:join] Vojnik_6 has joined the server (993:127.0.0.1)
[npc:join] Vojnik_7 has joined the server (992:127.0.0.1)
AntiCheat ocitan!
Statistika servera ocitana!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
Stari parovi kladionice, ucitani!
KURAC OGC - USKORO
DEVELOPER: Ivor
v1.0 - UCITAVANJE...
Number of vehicle models: 0
70 firmi
9 auto salona
0 hotela
IP requests connection cookie.
55 aktora
42 kapija
Plate
112 kontejnera
5 platformi
46 farmi
20 bankomata
24 gps lokacija
Luka_Hrsak
Underboss
pre 4 godine
Iv0r_. wrote on December 3, 2021, 11:52 am:
Jesu... tocni su.. Pogledaj...
Ovako je definisano u skripti...
//=================================[ MySql ]====================================

#define kucni

#if defined kucni
    #define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DB "kurac"
#else
    #define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DB "kurac"
#endif

new _dbConnector, sql_str[ 128 ];

//==================================[ Igraci ]==================================

Otisao sam napravit novu bazu u mysql phpmyadmin i kliknio Novo -> kurac -> otisao import -> kliknio na pregledaj i štiklirao mod -> I onda je pisalo ono zeleno, desno vidim sve kreirano -> Pokrenem samp-server.exe i pise ovo.


Pa sad bi prema svemu moralo da radi, povezan si na bazu, nemas query errore vise, jesi pokusao sad da udes?
Iv0r_.
Enforcer
pre 4 godine
Ghetoven wrote on December 3, 2021, 12:13 pm:
Pa sad bi prema svemu moralo da radi, povezan si na bazu, nemas query errore vise, jesi pokusao sad da udes?

Ne radi.. pustim da ucita ovo ono
Kad dodje do
Udjem i nakon 10 sec pise server closed the connection
D1NO
Crime Lord
pre 4 godine
Iv0r_. wrote on December 3, 2021, 12:35 pm:
Ne radi.. pustim da ucita ovo ono
Kad dodje do
Udjem i nakon 10 sec pise server closed the connection

Sacekaj da sve ucita, i u mene na MW modu ucita org i tek nakon nekoliko ucita dalje...
Luka_Hrsak
Underboss
pre 4 godine
Mozda imas nepotpunu bazu ili nesto. pokusaj ovako da uploadas bazu https://www.youtube.com/watch?v=7WUw9J3Xs8Q , ako nece posalji ovamo bazu preko pastebina da vidimo
Iv0r_.
Enforcer
pre 4 godine
Ghetoven wrote on December 3, 2021, 12:39 pm:
Mozda imas nepotpunu bazu ili nesto. pokusaj ovako da uploadas bazu https://www.youtube.com/watch?v=7WUw9J3Xs8Q , ako nece posalji ovamo bazu preko pastebina da vidimo

moze 😄 poslat cu nije problem.
ɴᴏᴅɪ wrote on December 3, 2021, 12:38 pm:
Sacekaj da sve ucita, i u mene na MW modu ucita org i tek nakon nekoliko ucita dalje...

Meni ucitava 18 organizacija i stoji ? Ocel bit nesto kasnije..
Luka_Hrsak
Underboss
pre 4 godine
Iv0r_. wrote on December 3, 2021, 1:08 pm:
moze 😄 poslat cu nije problem.Meni ucitava 18 organizacija i stoji ? Ocel bit nesto kasnije..


moguce je i da je ukljucen debug kod mysqla ? jer nekad davno imo sam isti problem xD pogledaj imas li pod OnGamemodeInit mysql_log(LOG_ERROR | LOG_WARNING); (ovo je za Blueg 39-6), posto zna da se desi da bude i debug pa ti pokazuje detaljno sva ucitavanja i sve

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava