SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Gamemode Scripts

Reply
 
Thread Tools Display Modes
Old 16/06/2019, 02:23 PM   #161
Min99
Big Clucker
 
Min99's Avatar
 
Join Date: Aug 2014
Location: Your girlfriend's house
Posts: 139
Reputation: 8
Default Re: Small County Roleplay | DYNAMIC | 0.3.7 | MYSQL R39 | ENG | Unique Script

Dunno why i can't get it to connect mysql.

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

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

[22:23:18]
[22:23:18] Server Plugins
[22:23:18] --------------
[22:23:18] Loading plugin: mysql
[22:23:18] >> plugin.mysql: R39-2 successfully loaded.
[22:23:18] Loaded.
[22:23:18] Loading plugin: sscanf
[22:23:18]

[22:23:18] ===============================

[22:23:18] sscanf plugin loaded.

[22:23:18] (c) 2009 Alex "******" Cole

[22:23:18] 0.3d-R2 500 Players "dnee"

[22:23:18] ===============================

[22:23:18] Loaded.
[22:23:18] Loading plugin: crashdetect
[22:23:18] CrashDetect v4.13 is OK.
[22:23:18] Loaded.
[22:23:18] Loading plugin: streamer
[22:23:18] Loaded.
[22:23:18] Loading plugin: Whirlpool
[22:23:18]
[22:23:18] ==================
[22:23:18]
[22:23:18] Whirlpool loaded
[22:23:18]
[22:23:18] ==================
[22:23:18]
[22:23:18] Loaded.
[22:23:18] Loaded 5 plugins.

[22:23:18]
[22:23:18] Filterscripts
[22:23:18] ---------------
[22:23:18] Loaded 0 filterscripts.

[22:23:18]
[22:23:18]
[22:23:18]
[22:23:18] =======================================
[22:23:18] | |
[22:23:18] | YSI version 4.00.0001 |
[22:23:18] | By Alex "******" Cole |
[22:23:18] | |
[22:23:18] =======================================
[22:23:18]
[22:23:19] ------------------------------------------------------------------------------
[22:23:19] [MYSQL]: ERROR: Connection to `scrp`@'127.0.0.1' failed!
[22:23:19] ------------------------------------------------------------------------------
[22:23:19] 22:23:00
[22:23:19] Filterscript 'Mapping.amx' loaded.
[22:23:19] ------------------------------------------------------------------------------
[22:23:19] | Small County Roleplay - Started! |
[22:23:19] ------------------------------------------------------------------------------
[22:23:19] Number of vehicle models: 0
What i only changed in connection.
Quote:
#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DB "scrp"
Here mysql.log
Code:
[22:26:36] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[22:26:36] [DEBUG] mysql_errno - connection: 1
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Settings` LIMIT 1", callback: "LoadSettings", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Houses` ORDER BY SQLID ASC", callback: "Load_Houses", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Business` ORDER BY SQLID ASC", callback: "Load_Businesses", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Objects`", callback: "LoadObjects", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Icons` ORDER BY SQLID ASC", callback: "LoadIcons", format: "(null)"
[22:26:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:26:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `ServerVehicles` ORDER BY SQLID ASC", callback: "LoadVehicles", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FactionVehicles` ORDER BY SQLID ASC", callback: "LoadFactionVehicles", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Factions` ORDER BY SQLID ASC", callback: "LoadFactions", format: "(null)"
[22:26:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:26:36] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[22:26:36] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[22:26:36] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
__________________


----------------------------
Searching for admin/helper for your community/server ?
I have experience being admin/helper.
You can contact me via pm or on my Discord: Minx#1999

----------------------------


-----------------------------
Play Game and Cash out Money! It's Easy and 100% Free!
-----------------------------
Min99 is offline   Reply With Quote
Old 16/06/2019, 02:26 PM   #162
SytonicX
Big Clucker
 
Join Date: Dec 2016
Posts: 114
Reputation: 17
Default Re: Small County Roleplay | DYNAMIC | 0.3.7 | MYSQL R39 | ENG | Unique Script

Try re-naming the SQL_HOST "127.0.0.1" to this "localhost" and double check the name of your database.
__________________
SA:MP Mapper
SytonicX is offline   Reply With Quote
Old 16/06/2019, 02:32 PM   #163
Min99
Big Clucker
 
Min99's Avatar
 
Join Date: Aug 2014
Location: Your girlfriend's house
Posts: 139
Reputation: 8
Default Re: Small County Roleplay | DYNAMIC | 0.3.7 | MYSQL R39 | ENG | Unique Script

Quote:
Originally Posted by SytonicX View Post
Try re-naming the SQL_HOST "127.0.0.1" to this "localhost" and double check the name of your database.
Still the same.

here is mysql.log
Code:
[22:31:59] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[22:31:59] [DEBUG] mysql_errno - connection: 1
[22:31:59] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Settings` LIMIT 1", callback: "LoadSettings", format: "(null)"
[22:31:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:31:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
Y SQLID ASC", callback: "Load_Houses", format: "(null)"
[22:31:59] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Business` ORDER BY SQLID ASC", callback: "Load_Businesses", format: "(null)"
[22:31:59] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Objects`", callback: "LoadObjects", format: "(null)"
[22:31:59] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Icons` ORDER BY SQLID ASC", callback: "LoadIcons", format: "(null)"
[22:31:59] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `ServerVehicles` ORDER BY SQLID ASC", callback: "LoadVehicles", format: "(null)"
[22:31:59] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FactionVehicles` ORDER BY SQLID ASC", callback: "LoadFactionVehicles", format: "(null)"
[22:31:59] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Factions` ORDER BY SQLID ASC", callback: "LoadFactions", format: "(null)"
[22:31:59] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[22:31:59] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[22:31:59] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
And the database is right 'scrp'.
Tried having a password seeing the log it was denied(even before having password) yet still the same result above.


Also confuse looking at the same log even after changing the connection host to localhost.
Code:
----------
Loaded log file: "server_log.txt".
----------

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

[22:37:29] 
[22:37:29] Server Plugins
[22:37:29] --------------
[22:37:29]  Loading plugin: mysql
[22:37:29]  >> plugin.mysql: R39-2 successfully loaded.
[22:37:29]   Loaded.
[22:37:29]  Loading plugin: sscanf
[22:37:29] 

[22:37:29]  ===============================

[22:37:29]       sscanf plugin loaded.     

[22:37:29]    (c) 2009 Alex "******" Cole

[22:37:29]    0.3d-R2 500 Players "dnee"

[22:37:29]  ===============================

[22:37:29]   Loaded.
[22:37:29]  Loading plugin: crashdetect
[22:37:29]   CrashDetect v4.13 is OK.
[22:37:29]   Loaded.
[22:37:29]  Loading plugin: streamer
[22:37:30]   Loaded.
[22:37:30]  Loading plugin: Whirlpool
[22:37:30]  
[22:37:30]  ==================
[22:37:30]  
[22:37:30]   Whirlpool loaded
[22:37:30]  
[22:37:30]  ==================
[22:37:30]  
[22:37:30]   Loaded.
[22:37:30]  Loaded 5 plugins.

[22:37:30] 
[22:37:30] Filterscripts
[22:37:30] ---------------
[22:37:30]   Loaded 0 filterscripts.

[22:37:30]  
[22:37:30]  
[22:37:30]  
[22:37:30]  ======================================= 
[22:37:30]  |                                     | 
[22:37:30]  |        YSI version 4.00.0001        | 
[22:37:30]  |        By Alex "******" Cole        | 
[22:37:30]  |                                     | 
[22:37:30]  ======================================= 
[22:37:30]  
[22:37:30] ------------------------------------------------------------------------------
[22:37:30] [MYSQL]: ERROR: Connection to `scrp`@'127.0.0.1' failed!
[22:37:30] ------------------------------------------------------------------------------
[22:37:30] 22:37:00
[22:37:30]   Filterscript 'Mapping.amx' loaded.
[22:37:30] ------------------------------------------------------------------------------
[22:37:30] |                       Small County Roleplay - Started!						|
[22:37:30] ------------------------------------------------------------------------------
[22:37:30] Number of vehicle models: 0
__________________


----------------------------
Searching for admin/helper for your community/server ?
I have experience being admin/helper.
You can contact me via pm or on my Discord: Minx#1999

----------------------------


-----------------------------
Play Game and Cash out Money! It's Easy and 100% Free!
-----------------------------
Min99 is offline   Reply With Quote
Old 16/06/2019, 02:39 PM   #164
SytonicX
Big Clucker
 
Join Date: Dec 2016
Posts: 114
Reputation: 17
Default Re: Small County Roleplay | DYNAMIC | 0.3.7 | MYSQL R39 | ENG | Unique Script

You are using a password, but you didn't identify the password inside your script.
You have to add the password so the mysql can access your database.

Quote:
[22:31:59] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
Code:
#define SQL_PASS ""
__________________
SA:MP Mapper
SytonicX is offline   Reply With Quote
Old 16/06/2019, 02:50 PM   #165
Min99
Big Clucker
 
Min99's Avatar
 
Join Date: Aug 2014
Location: Your girlfriend's house
Posts: 139
Reputation: 8
Default Re: Small County Roleplay | DYNAMIC | 0.3.7 | MYSQL R39 | ENG | Unique Script

Quote:
Originally Posted by SytonicX View Post
You are using a password, but you didn't identify the password inside your script.
You have to add the password so the mysql can access your database.



Code:
#define SQL_PASS ""
here's the thing.
I didn't.
So i tried using it when you ask to changed it to localhost yet here i am.


Well great, now for no freaking reason gets access denied for when i try to open phpmyadmin.
I'm using XAMPP btw.
__________________


----------------------------
Searching for admin/helper for your community/server ?
I have experience being admin/helper.
You can contact me via pm or on my Discord: Minx#1999

----------------------------


-----------------------------
Play Game and Cash out Money! It's Easy and 100% Free!
-----------------------------
Min99 is offline   Reply With Quote
Old 16/06/2019, 03:23 PM   #166
AlexHood129
Little Clucker
 
Join Date: Dec 2017
Posts: 10
Reputation: 0
Default Re: Small County Roleplay | DYNAMIC | 0.3.7 | MYSQL R39 | ENG | Unique Script

Quote:
Originally Posted by Min99 View Post
Dunno why i can't get it to connect mysql.



What i only changed in connection.


Here mysql.log
Code:
[22:26:36] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[22:26:36] [DEBUG] mysql_errno - connection: 1
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Settings` LIMIT 1", callback: "LoadSettings", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Houses` ORDER BY SQLID ASC", callback: "Load_Houses", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Business` ORDER BY SQLID ASC", callback: "Load_Businesses", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Objects`", callback: "LoadObjects", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Icons` ORDER BY SQLID ASC", callback: "LoadIcons", format: "(null)"
[22:26:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:26:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `ServerVehicles` ORDER BY SQLID ASC", callback: "LoadVehicles", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `FactionVehicles` ORDER BY SQLID ASC", callback: "LoadFactionVehicles", format: "(null)"
[22:26:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Factions` ORDER BY SQLID ASC", callback: "LoadFactions", format: "(null)"
[22:26:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:26:36] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[22:26:36] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[22:26:36] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
Rename "127.0.0.1" to "localhost" and don't forgot to open the XAMPP and start Apache and MySQL, If it doesn't work still, the problem is you haven't uploaded the sql.

Code:
 
#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_DB "database name u created"
#define SQL_PASS ""
AlexHood129 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 11:53 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.