Posts: 1,498
Threads: 110
Joined: Aug 2013
mysql_log
Code:
[12:21:12] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'hidden'@'IPHIDDEN' (using password: YES)
[12:21:13] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'hidden'@'IPHIDDEN' (using password: YES)
this happens on my localhost when I want to login lol
I have 3 connections done to mysql server.
From FS
From GM
From my UCP (website)
Would that be an issue? my main server isn't affected only localhost.
I unload FS> I can login
I load FS> I can't login
They use different tables.
Posts: 457
Threads: 7
Joined: Jul 2017
Quote:
Originally Posted by Crystallize
mysql_log
Code:
[12:21:12] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'hidden'@'IPHIDDEN' (using password: YES)
[12:21:13] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'hidden'@'IPHIDDEN' (using password: YES)
this happens on my localhost when I want to login lol
I have 3 connections done to mysql server.
From FS
From GM
From my UCP (website)
Would that be an issue? my main server isn't affected only localhost.
|
Disable firewall, and check if the connection is allowed to localhost (mysql server allow more than 1 connection), check the user login's
Posts: 1,498
Threads: 110
Joined: Aug 2013
Quote:
Originally Posted by XeonMaster
Disable firewall, and check if the connection is allowed to localhost (mysql server allow more than 1 connection), check the user login's
|
I unload FS I can login.
I load FS I can't login.
What the issue could be? The FS is not affiliated with main gm it uses different tables&db
Posts: 457
Threads: 7
Joined: Jul 2017
Quote:
Originally Posted by Crystallize
I unload FS I can login.
I load FS I can't login.
What the issue could be? The FS is not affiliated with main gm it uses different tables only same database.
|
it might be the FS and gamemode use same handle, Mysql Handle is an Id (number) not something special
so i guess you need to set it manualy (spell ;-
like that
OnGamemode:
PHP Code:
new MySQL:Database = 0;
OnFilterScript:
PHP Code:
new MySQL:Handle = 1;
OnAnythingElse
PHP Code:
new MySQL:Handle = (int anything else ^)
Posts: 1,498
Threads: 110
Joined: Aug 2013
my onfsinit
my mysql variable (i set it as you said or maybe I got it wrong?
Posts: 457
Threads: 7
Joined: Jul 2017
Quote:
Originally Posted by Crystallize
my onfsinit
Code:
mysql=mysql_connect(--); //Connecting to mysql database
my mysql variable (i set it as you said or maybe I got it wrong?
|
what mysql plugin you are using?
if you use R40+ you should put MySQL: tag to be
Code:
new MySQL:mysql = 1;
Posts: 1,506
Threads: 13
Joined: Jun 2015
Please hide your credentials + (Above poster) He's using R39 and no need to quote his every post.
Posts: 1,498
Threads: 110
Joined: Aug 2013
Quote:
Originally Posted by Logic_
Please hide your credentials + (Above poster) He's using R39 and no need to quote his every post.
|
I'm a fucking idiot but I will delete it anyways its a test db wont be useful in next 5 mins.
And yes im using r39 if im not mistaken lol
Posts: 1,506
Threads: 13
Joined: Jun 2015
The main question arises why are you using the FS, you can integrate it in your script.
Posts: 457
Threads: 7
Joined: Jul 2017
Quote:
Originally Posted by Logic_
Please hide your credentials + (Above poster) He's using R39 and no need to quote his every post.
|
no, he is using R40 based on mysql_connect that he used
Quote:
password and database parameters swapped in mysql_connect:
Code:
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DATABASE, MYSQL_PASSWORD);
becomes
Code:
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE);
|
so you should put MySQL: tag on the variable @Crystallize
EDIT: i did saw the Database in last of params on mysql_connect if im not mistaken