server not connecting to mysql server - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: server not connecting to mysql server (/showthread.php?tid=647214)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: server not connecting to mysql server (/showthread.php?tid=647214)
server not connecting to mysql server - Hypex - 01.01.2018
Hi I'm having issues connecting to my mysql server im using wampp it worked fine before i've added more code to the script I'm not really sure what the issue is it doesnt give me any errors or anything it just doesnt send me the log saying if it connected or not to the server im using the lastest mysql plugin r41-4 im also using phoenix's easy-mysql include.
Before:
Quote:
|
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [19:10:47] filterscripts = "" (string) [19:10:47] [19:10:47] Server Plugins [19:10:47] -------------- [19:10:47] Loading plugin: mysql.dll [19:10:47] >> plugin.mysql: R41-4 successfully loaded. [19:10:47] Loaded. [19:10:47] Loading plugin: nativechecker.dll [19:10:47] Loaded. [19:10:47] Loading plugin: streamer.dll [19:10:47] *** Streamer Plugin v2.9.2 by Incognito loaded *** [19:10:47] Loaded. [19:10:47] Loading plugin: Whirlpool.dll [19:10:47] [19:10:47] ================== [19:10:47] [19:10:47] Whirlpool loaded [19:10:47] [19:10:47] ================== [19:10:47] [19:10:47] Loaded. [19:10:47] Loaded 4 plugins. [19:10:47] [19:10:47] Filterscripts [19:10:47] --------------- [19:10:47] Loaded 0 filterscripts. [19:10:48] AMX (23667336) loaded [19:10:48] [MYSQL] - NOTICE: Successfully connected to database! [19:10:48] ---------------------------------- [19:10:48] Test server [19:10:48] ---------------------------------- [19:10:48] Number of vehicle models: 0 |
Quote:
|
Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [15:52:11] filterscripts = "" (string) [15:52:11] [15:52:11] Server Plugins [15:52:11] -------------- [15:52:11] Loading plugin: mysql.dll [15:52:11] >> plugin.mysql: R41-4 successfully loaded. [15:52:11] Loaded. [15:52:11] Loading plugin: sscanf.dll [15:52:11] [15:52:11] =============================== [15:52:11] sscanf plugin loaded. [15:52:11] Version: 2.8.2 [15:52:11] © 2012 Alex "******" Cole [15:52:11] =============================== [15:52:11] Loaded. [15:52:11] Loading plugin: streamer.dll [15:52:11] *** Streamer Plugin v2.9.2 by Incognito loaded *** [15:52:11] Loaded. [15:52:11] Loading plugin: Whirlpool.dll [15:52:11] [15:52:11] ================== [15:52:11] [15:52:11] Whirlpool loaded [15:52:11] [15:52:11] ================== [15:52:11] [15:52:11] Loaded. [15:52:11] Loading plugin: nativechecker.dll [15:52:11] Loaded. [15:52:11] Loaded 5 plugins. [15:52:11] [15:52:11] Filterscripts [15:52:11] --------------- [15:52:11] Loaded 0 filterscripts. [15:52:11] AMX (19866176) loaded [15:52:11] ---------------------------------- [15:52:11] Test server [15:52:11] ---------------------------------- [15:52:11] Number of vehicle models: 0 |
Re: server not connecting to mysql server - MEW273 - 01.01.2018
The first step would be to add a print message to your script that will execute if the connection is not successful.
The code I use is similar to below:
Код:
ConnectSQLDatabase()
{
new MySQLOpt:options_id = mysql_init_options();
mysql_set_option(options_id, AUTO_RECONNECT, false);
SQL_HANDLE = mysql_connect(SQL_HOSTNAME, SQL_USERNAME, SQL_PASSWORD, SQL_DATABASE, options_id);
if(mysql_errno(SQL_HANDLE) != 0 || SQL_HANDLE == MYSQL_INVALID_HANDLE)
{
print("\n----------------------------------------------------");
print("[ERROR] Cannot establish connection to MySQL database!");
printf("[MYSQL] ERROR CODE: %d", mysql_errno(SQL_HANDLE));
print("----------------------------------------------------");
}
else
{
print("[MYSQL] Connection to MySQL database established successfully!");
}
return 1;
}
Re: server not connecting to mysql server - Hypex - 01.01.2018
It does have one check the first log.
Re: server not connecting to mysql server - MEW273 - 01.01.2018
Quote:
|
Originally Posted by Hypex
 It does have one check the first log.
|
Have a look through your MySQL log file as this should be giving you some form of error as to why a connection isn't being established.
Re: server not connecting to mysql server - Hypex - 01.01.2018
yes it warns me if it fails also but from the looks of it it doesnt even try to connect to it
I get this warning in log-core:received Windows console close event; shutting log-core down
I thought it would be my .net framework so I just downloaded 4.7 and rebooted but still doesnt try to connect to it.
It's like its not even loading the easy-mysql include.
Re: server not connecting to mysql server - MEW273 - 01.01.2018
Can you please post here the code that connects the database, and where it prints the success/fail messages.
You mentioned in your OP that this only started happening when you added some new code, what was the new code for? Did it change anything with your MySQL connection code?
Re: server not connecting to mysql server - Hypex - 01.01.2018
The code I added is non mysql related the easy-mysql include prints out the success/fail messages
Код:
#define SQL_Warning(%0) (printf("[MYSQL] - WARNING: " %0))
#define SQL_Error(%0) (printf("[MYSQL] - ERROR: " %0))
#define SQL_Notice(%0) (printf("[MYSQL] - NOTICE: " %0))
Код:
#define mysql_host "localhost" #define mysql_user "test1" #define mysql_db "release" #define mysql_pass "test123" #define mysql_debugging_enabled (true) #define SQL_PLAYERS_TABLE "Users"
Код:
SQL::Connect(mysql_host, mysql_user, mysql_pass, mysql_db);
Re: server not connecting to mysql server - MEW273 - 01.01.2018
Is there any other code under OnGameModeInit that could be preventing the connect function from being called?
Re: server not connecting to mysql server - Hypex - 01.01.2018
Unfortunetly no I have no idea why it's doing this as it worked fine a couple of days ago...
Re: server not connecting to mysql server - MEW273 - 01.01.2018
Quote:
|
Originally Posted by Hypex
Unfortunetly no I have no idea why it's doing this as it worked fine a couple of days ago...
|
Could you try placing the connect code somewhere else? Try placing it as the very first function to execute under OnGameModeInit:
Код:
OnGameModeInit()
{
SQL::Connect(mysql_host, mysql_user, mysql_pass, mysql_db);
// Other code below
}