MySQL Error. - 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: MySQL Error. (/showthread.php?tid=653401)
+- 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: MySQL Error. (/showthread.php?tid=653401)
MySQL Error. - Hassyy - 03.05.2018
Hello dears.
How can i fix this? i'm using CZ cnr gamemode And Ultra-h host.
Quote:
|
[20:50:38] Server Plugins [20:50:38] -------------- [20:50:38] Loading plugin: crashdetect.so [20:50:38] CrashDetect v4.15.1 is OK. [20:50:38] Loaded. [20:50:38] Loading plugin: streamer.so [20:50:38] Loaded. [20:50:38] Loading plugin: mysql.so [20:50:38] SA:MP MySQL Plugin v2.1.1 Loaded. [20:50:38] Loaded. [20:50:38] [MySQL] Thread running. Threadsafe: Yes. [20:50:38] Loading plugin: socket.so [20:50:38] Socket plugin v0.2b loaded. [20:50:38] Loaded. [20:50:38] Loading plugin: MapAndreas.so [20:50:38] Loaded. [20:50:38] Loading plugin: audio.so [20:50:38] *** Audio Plugin v0.5 R2 by Incognito loaded *** [20:50:38] Loaded. [20:50:38] Loading plugin: mysql_static.so [20:50:38] SA:MP MySQL Plugin v2.1.1 Loaded. [20:50:38] Loaded. [20:50:38] Loading plugin: libRegEx.so [20:50:38] [MySQL] Thread running. Threadsafe: Yes. [20:50:38] [20:50:38] ------------------------------ [20:50:38] | [20:50:38] | -> Regular Expression Plugin v0.2 [20:50:38] | -> Using Oniguruma v5.9.1 [20:50:38] | [20:50:38] ------ © 2014, Koala ------- [20:50:38] [20:50:38] Loaded. [20:50:38] Loading plugin: whirlpool.so [20:50:38] [20:50:38] ================== [20:50:38] [20:50:38] Whirlpool loaded [20:50:38] [20:50:38] ================== [20:50:38] [20:50:38] Loaded. [20:50:38] Loading plugin: libRegEx_static.so [20:50:38] [20:50:38] ------------------------------ [20:50:38] | [20:50:38] | -> Regular Expression Plugin v0.2 [20:50:38] | -> Using Oniguruma v5.9.5 [20:50:38] | [20:50:38] ------ © 2014, Koala ------- [20:50:38] [20:50:38] Loaded. [20:50:38] Loading plugin: sscanf.so [20:50:38] [20:50:38] =============================== [20:50:38] sscanf plugin loaded. [20:50:38] Version: 2.8.1 [20:50:38] © 2012 Alex "******" Cole [20:50:38] =============================== [20:50:38] Loaded. [20:50:38] Loaded 11 plugins. [20:50:38] [20:50:38] Filterscripts [20:50:38] --------------- [20:50:38] Loading filterscript 'UltraHost.amx'... [20:50:38] Loading filterscript 'gps.amx'... [20:50:38] -------------------------------------- [20:50:38] GPS System Loaded [20:50:38] 0, -2438.551025, 741.183044, 35.107868, Supa Save [20:50:38] 1, -1795.019897, 576.496948, 35.166793, VIP Lounge [20:50:38] 2, -1927.602294, 261.575897, 40.718589, Vehicle Dealership SF [20:50:38] 3, -2621.093017, 217.150161, 4.283658, Ammunation [20:50:38] 4, -2632.546142, 619.860168, 14.132818, Hospital [20:50:38] 5, -1890.214599, 813.722656, 35.422653, Job Center [20:50:38] 6, -1777.782958, 1201.687133, 24.803468, Bomb Shop [20:50:38] 7, -1566.389892, 1170.356201, 7.187500, Mini-Games [20:50:38] 8, -1508.060424, 923.515014, 6.869043, San Fierro Bank [20:50:38] 12, -1424.326660, -292.509002, 14.148400, Airport SF [20:50:38] GPS System Loaded... [20:50:38] -------------------------------------- [20:50:38] Loading filterscript 'shouryamaps.amx'... [20:50:38] Loading filterscript 'antirapidfire.amx'... [20:50:38] Loading filterscript 'vehiclename.amx'... [20:50:38] -------------------------------------- [20:50:38] Loaded Vehicle Names v1.1 [20:50:38] by biltong [20:50:38] -------------------------------------- [20:50:38] Loading filterscript 'Helmet.amx'... [20:50:38] Loading filterscript 'FarmerJob.amx'... [20:50:38] ---------------------------- [20:50:38] Farmer Job FS Made by Virusa1 [20:50:38] ---------------------------- [20:50:38] Loaded 7 filterscripts. [20:50:38] [20:50:38] [20:50:38] [20:50:38] ======================================= [20:50:38] | | [20:50:38] | YSI version 3.09.0684 | [20:50:38] | By Alex "******" Cole | [20:50:38] | | [20:50:38] ======================================= [20:50:38] [20:50:38] [MySQL] Error (0): Failed to connect. Access denied for user 'server_142'@'localhost' to database 'server_142'. [20:50:38] Failed to connect. Access denied for user 'server_142'@'localhost' to database 'server_142'. [20:50:38] Loading Vehicles [20:50:38] (1) Loaded! Owner: 24 [20:50:38] (2) Loaded! Owner: 24 [20:50:38] (3) Loaded! Owner: 24 [20:50:38] (4) Loaded! Owner: 24 [20:50:38] (5) Loaded! Owner: 24 [20:50:38] (6) Loaded! Owner: 24 [20:50:38] (7) Loaded! Owner: 24 [20:50:38] (  Loaded! Owner: 110781[20:50:38] (9) Loaded! Owner: 110781 [20:50:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'server_142'@'localhost' to database 'server_142'. [20:50:38] Function: mysql_query called when not connected to any database. Access denied for user 'server_142'@'localhost' to database 'server_142'. [20:50:38] ----------------------------------- [20:50:38] Cops and Robbers, by shourya |
Re: MySQL Error. - Terzic - 03.05.2018
Your database settings are not set properly.
Re: MySQL Error. - Hassyy - 03.05.2018
Quote:
|
Originally Posted by Terzic
 Your database settings are not set properly.
|
Re: MySQL Error. - kovac - 03.05.2018
Use 127.0.0.1 instead of localhost
Re: MySQL Error. - ItsRobinson - 03.05.2018
I had this error a long, long time ago and it was just that I had the password and username the wrong way around.
Код:
mysql_connect("localhost", /*"USERNAME"*/, "server_142", /*"PASSWORD"*/);
Re: MySQL Error. - Hassyy - 04.05.2018
Quote:
|
Originally Posted by kovac
Use 127.0.0.1 instead of localhost
|
Quote:
|
public OnGameModeInit() { profileStuff(); f_init(); connection = mysql_init(LOG_ONLY_ERRORS, 1); mysql_connect("127.0.0.1", "server_142", "dontknow", "server_142", connection, 1); |
Re: MySQL Error. - Hassyy - 04.05.2018
Quote:
|
Originally Posted by Hassyy
Bro check my setting but it still not working!
|
Re: MySQL Error. - kovac - 04.05.2018
As far as I know, Ultra-H's databases are named like server_142_DATABASENAME.
You need to create a new database ( I guess it's done through CP > MySQL > Create new database )
PHP код:
// At the top of your gamemode
new MySQL: Database;
#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "server_142"
#define MYSQL_PASS "PASSWORD"
#define MYSQL_DATABASE "server_142_DATABASENAME"
PHP код:
// OnGameModeInit
new MySQLOpt: option_id = mysql_init_options();
mysql_set_option(option_id, AUTO_RECONNECT, true); // We will set that option to automatically reconnect on timeouts.
Database = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DATABASE, option_id);
if(Database == MYSQL_INVALID_HANDLE || mysql_errno(Database) != 0) // Checking if the database connection is invalid to shutdown.
{
print("MySQL Database: Connection to database failed!");
SendRconCommand("exit");
return 1;
}
else
print("MySQL Database: Successfully connected.");
Re: MySQL Error. - Hassyy - 04.05.2018
Quote:
|
Originally Posted by kovac
As far as I know, Ultra-H's databases are named like server_142_DATABASENAME.
You need to create a new database ( I guess it's done through CP > MySQL > Create new database ) PHP код:
PHP код:
|
