Problema conectare DB

RazDanh · August 18, 2017

Salut, am o problema. E prima data cand scriu aici si sper ca cineva sa imi ofere o mana de ajutor, multumesc mult. Acum sa incep, am gasit pe net gamemodul frz gaming rpg. Problema este ca orice as face nu se conecteaza la baza de date ca sa imi pot face cont. Cu pawno in gamemod am facut configurarea cu baza, mai exact am modificat comanda asta

// ONGAMEMODEINIT
public OnGameModeInit()
{
	mysql_log(LOG_ERROR, LOG_TYPE_TEXT);
	//SQL = mysql_connect("localhost", "root", "baza4", "");
 SQL = mysql_connect("localhost", "root", "baza4", "");

Din pacate tot nu vrea sa se conecteze... In server log am asta


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

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

[11:00:08] filterscripts = ""  (string)
[11:00:08] 
[11:00:08] Server Plugins
[11:00:08] --------------
[11:00:08]  Loading plugin: sscanf
[11:00:08] 

[11:00:08]  ===============================

[11:00:08]       sscanf plugin loaded.     

[11:00:08]          Version:  2.8.1        

[11:00:08]    (c) 2012 Alex "Y_Less" Cole  

[11:00:08]  ===============================

[11:00:08]   Loaded.
[11:00:08]  Loading plugin: streamer
[11:00:08] 

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

[11:00:08]   Loaded.
[11:00:08]  Loading plugin: mysql
[11:00:08]  >> plugin.mysql: R38 successfully loaded.
[11:00:08]   Loaded.
[11:00:08]  Loading plugin: crashdetect
[11:00:08]   CrashDetect must be loaded before 'streamer.DLL'
[11:00:09]   Failed.
[11:00:09]  Loaded 3 plugins.

[11:00:09] 
[11:00:09] Ban list
[11:00:09] --------
[11:00:09]  Loaded: samp.ban
[11:00:09] 
[11:00:09] 
[11:00:09] Filterscripts
[11:00:09] ---------------
[11:00:09]   Loaded 0 filterscripts.

[11:00:09]  
[11:00:09]  
[11:00:09]  
[11:00:09]  ======================================= 
[11:00:09]  |                                     | 
[11:00:09]  |        YSI version 3.09.0684        | 
[11:00:09]  |        By Alex "Y_Less" Cole        | 
[11:00:09]  |                                     | 
[11:00:09]  ======================================= 
[11:00:09]  
[11:00:09] -mSelection- WARNING: Failed to load list: "components.txt"
[11:00:10] Houses: 0
[11:00:10] Bussines: 0
[11:00:10] Stuff Loaded
[11:00:10] Charity Loaded
[11:00:10] Turf: 0
[11:00:10] Papers: 0
[11:00:10] [Furniture Script]: 0 objects loaded.
[11:00:10] Dynamic Factions: 0
[11:00:10] Cars: 0
[11:00:11] Dealership Vehicles: 0
[11:00:11] Stock Loaded
[11:00:11] [Clans Script]: 0 clans loaded.
[11:00:11] [Graffiti Script]: 0 graffiti loaded.
[11:00:11] 2719 - Objects.
[11:00:11] 30 - Pickups.
[11:00:11] OnGameModeInit Loaded
[11:00:11] Script loaded - Frz-Gaming v1.3
[11:00:11] Number of vehicle models: 72
[11:00:11]  
[11:00:11]  ========================================== 
[11:00:11]  |                                        | 
[11:00:11]  |  A new version (v<html lan) of YSI is  | 
[11:00:11]  |            available from:             | 
[11:00:11]  |                                        | 
[11:00:11]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[11:00:11]  |                                        | 
[11:00:11]  ========================================== 
[11:00:11]  

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

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

[11:00:50] filterscripts = ""  (string)
[11:00:50] 
[11:00:50] Server Plugins
[11:00:50] --------------
[11:00:50]  Loading plugin: sscanf
[11:00:50] 

[11:00:50]  ===============================

[11:00:50]       sscanf plugin loaded.     

[11:00:50]          Version:  2.8.1        

[11:00:50]    (c) 2012 Alex "Y_Less" Cole  

[11:00:50]  ===============================

[11:00:50]   Loaded.
[11:00:50]  Loading plugin: streamer
[11:00:50] 

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

[11:00:50]   Loaded.
[11:00:50]  Loading plugin: mysql
[11:00:50]  >> plugin.mysql: R38 successfully loaded.
[11:00:50]   Loaded.
[11:00:50]  Loading plugin: crashdetect
[11:00:50]   CrashDetect must be loaded before 'streamer.DLL'
[11:00:51]   Failed.
[11:00:51]  Loaded 3 plugins.

[11:00:51] 
[11:00:51] Ban list
[11:00:51] --------
[11:00:51]  Loaded: samp.ban
[11:00:51] 
[11:00:51] 
[11:00:51] Filterscripts
[11:00:51] ---------------
[11:00:51]   Loaded 0 filterscripts.

[11:00:51]  
[11:00:51]  
[11:00:51]  
[11:00:51]  ======================================= 
[11:00:51]  |                                     | 
[11:00:51]  |        YSI version 3.09.0684        | 
[11:00:52]  |        By Alex "Y_Less" Cole        | 
[11:00:52]  |                                     | 
[11:00:52]  ======================================= 
[11:00:52]  
[11:00:52] -mSelection- WARNING: Failed to load list: "components.txt"
[11:00:52] Houses: 0
[11:00:52] Bussines: 0
[11:00:52] Stuff Loaded
[11:00:52] Charity Loaded
[11:00:52] Turf: 0
[11:00:52] Papers: 0
[11:00:52] [Furniture Script]: 0 objects loaded.
[11:00:53] Dynamic Factions: 0
[11:00:53] Cars: 0
[11:00:53] Dealership Vehicles: 0
[11:00:53] Stock Loaded
[11:00:53] [Clans Script]: 0 clans loaded.
[11:00:53] [Graffiti Script]: 0 graffiti loaded.
[11:00:53] 2719 - Objects.
[11:00:53] 30 - Pickups.
[11:00:53] OnGameModeInit Loaded
[11:00:53] Script loaded - Frz-Gaming v1.3
[11:00:53] Number of vehicle models: 72
[11:00:53]  
[11:00:53]  ========================================== 
[11:00:53]  |                                        | 
[11:00:53]  |  A new version (v<html lan) of YSI is  | 
[11:00:53]  |            available from:             | 
[11:00:53]  |                                        | 
[11:00:53]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[11:00:53]  |                                        | 
[11:00:53]  ========================================== 
[11:00:53]  
[11:01:44] [connection] 192.168.0.119:59745 requests connection cookie.
[11:01:45] Incoming connection: 192.168.0.119:59745 id: 0
[11:01:45] [join] RazDan has joined the server (0:192.168.0.119)
[11:02:02] [part] RazDan has left the server (0:2)

Si cam asta e. Vroiam sa iau neaparat scriptul asta pentru ca are cam ce caut eu, aici ma refer ca are implementat si cele doua tipuri de barbut etc... Problema e, de ce nu imi pot face cont? Precizez ca il rulez localhost, iar la alte gamemoduri nu am intampinat probleme, chiar un gamemode mai vechi de unde a plecat frz, merge bine dar nu are multe chestii. Va multumesc mult si astept orice sugestie, sunt incepator de tot.

AndreiB · August 19, 2017

Intra pe localhost/phpmyadmin si creeaza o baza cu numele baza4 si dai import la baza ta de date si gata

RazDanh · August 19, 2017

Acum 2 ore, AndreiB a spus:

Intra pe localhost/phpmyadmin si creeaza o baza cu numele baza4 si dai import la baza ta de date si gata

Multumesc pentru raspuns.

Am facut asta inainte sa imi zici, am uploadata fisierul .sql in baza de date si totul a mers ok

problema e in alta parte si inca nu imi pot da seama unde...

BuNiCu-RP · August 19, 2017

http://wiki.sa-mp.com/wiki/MySQL/R33#mysql_connect

RazDanh · August 19, 2017

Chiar acum, BuNiCu-RP a spus:

http://wiki.sa-mp.com/wiki/MySQL/R33#mysql_connect

Deci care e problema? Am linia de conectare la baza de date, adica linia

SQL = mysql_connect("localhost", "root", "baza4", "");

ce ar trebui sa modific?

KripToN. · August 19, 2017

Acum 2 ore, RazDanh a spus:
Deci care e problema? Am linia de conectare la baza de date, adica linia
SQL = mysql_connect("localhost", "root", "baza4", "");
ce ar trebui sa modific?

1.Intra in baza de date si verifica daca ai pus -- Database: `localhost`

2.Uite daca baza de date are numele de "baza4"

Edited August 19, 2017 by Th3FuK3R Channel
vreau

RazDanh · August 19, 2017

Acum 5 ore, Th3FuK3R Channel a spus:

1.Intra in baza de date si verifica daca ai pus -- Database: `localhost`

2.Uite daca baza de date are numele de "baza4"

am facut toate astea, nu vrea.

RazDanh · August 20, 2017

Ca un bonus, l-am urcat si pe host, la fel face

al3XXX · August 20, 2017

da-mi skype daca ai sa vb

RazDanh · August 20, 2017

Chiar acum, al3XXX a spus:

da-mi skype daca ai sa vb

Da, am, skype-ul este dany_kys

al3XXX · August 20, 2017

accepta

RazDanh · August 20, 2017

Acceptat demult Problema inca persista. Atat pe localhost cat si in pc

BiKode · August 21, 2017

// ONGAMEMODEINIT
public OnGameModeInit()
{
	mysql_log(LOG_ERROR, LOG_TYPE_TEXT);
	//SQL = mysql_connect("localhost", "root", "", "baza4"); //Ordinea posibila e IP/username/parola/DBname
 SQL = mysql_connect("localhost", "root", "", "baza4"); //La fel si aici

Ti-am corectat eu, posibil asta sa fie problema.

Si pune si tu un check sa vezi exact daca se conecteaza cum trb

#define LOCAL_HOST 				"127.0.0.1" //sau localhost
#define LOCAL_USER 				"root"
#define LOCAL_PASS 				""
#define LOCAL_DB 				"baza4"

forward ConnectMySQL();
public ConnectMySQL()
{

 	NumeGamemode=mysql_connect( LOCAL_HOST, LOCAL_USER, LOCAL_DB, LOCAL_PASS );

    if(mysql_ping(NumeGamemode) == 1)
    {
        mysql_debug(NumeGamemode);
	    printf("[MYSQL]:first Connection to `DATABASE` succesful! || %d",NumeGamemode);
	}
	else
	{
 	  mysql_close(NumeGamemode);
	  printf("[MYSQL]: [ERROR]:first Connection to `DATABASE` failed!");
	  NumeGamemode=mysql_connect( LOCAL_HOST, LOCAL_USER, LOCAL_DB, LOCAL_PASS );
      if(mysql_ping(NumeGamemode) == 1)
	     {
	        mysql_debug(NumeGamemode);
		    printf("[MYSQL]:second Connection to `DATABASE` succesful! || %d",NumeGamemode);
	 	 }
	 	 else printf("[MYSQL]: [ERROR]:second Connection to `DATABASE` failed!");

	}
	return 1;
}

Edited August 21, 2017 by BiKode

RazDanh · August 21, 2017

Acum 7 ore, BiKode a spus:


// ONGAMEMODEINIT
public OnGameModeInit()
{
	mysql_log(LOG_ERROR, LOG_TYPE_TEXT);
	//SQL = mysql_connect("localhost", "root", "", "baza4"); //Ordinea posibila e IP/username/parola/DBname
 SQL = mysql_connect("localhost", "root", "", "baza4"); //La fel si aici

Ti-am corectat eu, posibil asta sa fie problema.

Si pune si tu un check sa vezi exact daca se conecteaza cum trb


#define LOCAL_HOST 				"127.0.0.1" //sau localhost
#define LOCAL_USER 				"root"
#define LOCAL_PASS 				""
#define LOCAL_DB 				"baza4"


forward ConnectMySQL();
public ConnectMySQL()
{

 	NumeGamemode=mysql_connect( LOCAL_HOST, LOCAL_USER, LOCAL_DB, LOCAL_PASS );

    if(mysql_ping(NumeGamemode) == 1)
    {
        mysql_debug(NumeGamemode);
	    printf("[MYSQL]:first Connection to `DATABASE` succesful! || %d",NumeGamemode);
	}
	else
	{
 	  mysql_close(NumeGamemode);
	  printf("[MYSQL]: [ERROR]:first Connection to `DATABASE` failed!");
	  NumeGamemode=mysql_connect( LOCAL_HOST, LOCAL_USER, LOCAL_DB, LOCAL_PASS );
      if(mysql_ping(NumeGamemode) == 1)
	     {
	        mysql_debug(NumeGamemode);
		    printf("[MYSQL]:second Connection to `DATABASE` succesful! || %d",NumeGamemode);
	 	 }
	 	 else printf("[MYSQL]: [ERROR]:second Connection to `DATABASE` failed!");

	}
	return 1;
}

Multumesc, problema era de la mysql.so, a trebuit sa il inlocuiesc.

BuNiCu-RP · August 22, 2017

#define mysql_host "localhost"
#define mysql_user "root"
#define mysql_password ""
#define mysql_database "baza4"

new handle;
forward MySQLConnect();

public MySQLConnect()
{
	handle = mysql_connect(mysql_host, mysql_user, mysql_database, mysql_password);

	if(handle && mysql_errno(handle) == 0)
	{
		printf("[MYSQL]: Connection to database (%s) was established!", mysql_database);
	}
	else
	{
		printf("[MYSQL]: Connection to database (%s) failed!", mysql_database);
		SendRconCommand("exit");
	}

	return 1;
}

Dupa ce modifici verifica server log.

Sign In

Problema conectare DB

Question

Link to comment

Share on other sites

14 answers to this question

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Similar Content

Recently Browsing 0 members

Important Information