Raised This Month: $61 Target: $400
 15% 

MySQL stop working


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
YoUrEnD
Member
Join Date: Nov 2015
Location: Germany
Old 11-30-2023 , 16:03   MySQL stop working
Reply With Quote #1

As title says MySQL stoped working.
all plugins that uses MySQL dont load and all plugins send the same error

Code:
Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'DB_USER'@'xxxx:xxxx:xxxx:xxxx:xxx:xxxx:xxxx:xxx' (using password: YES) in /var/www/html/bans/includes/adodb/drivers/adodb-mysqli.inc.php on line 124

Fatal error: mysqli error: [1045: Access denied for user 'DB_USER'@'xxxx:xxxx:xxxx:xxxx:xxx:xxxx:xxxx:xxx' (using password: YES)] in CONNECT(DB_HOST, '****', '****', DB_NAME) in /var/www/html/bans/includes/adodb/adodb-errorhandler.inc.php on line 79
I didnt changed anything. I checked all configs and nothing changed. i also created a complete new Database and a new user with all permissions but i get the same error.

Every server startet calling this error after the daily game server restarts.
Tomorrorw morning i try a root server restart.


Edit: I got a temp fix. I added % to the MySQL whitelist. the Serverip is still still in there too but didnt work anymore for unknown reasons
__________________
Counter-Strike Source Server
https://high-devil-force.de

Last edited by YoUrEnD; 12-01-2023 at 00:56.
YoUrEnD is offline
oqyh
Senior Member
Join Date: May 2019
Location: United Arab Emirates
Old 12-01-2023 , 13:58   Re: MySQL stop working
Reply With Quote #2

Quote:
Originally Posted by YoUrEnD View Post
As title says MySQL stoped working.
all plugins that uses MySQL dont load and all plugins send the same error

Code:
Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'DB_USER'@'xxxx:xxxx:xxxx:xxxx:xxx:xxxx:xxxx:xxx' (using password: YES) in /var/www/html/bans/includes/adodb/drivers/adodb-mysqli.inc.php on line 124

Fatal error: mysqli error: [1045: Access denied for user 'DB_USER'@'xxxx:xxxx:xxxx:xxxx:xxx:xxxx:xxxx:xxx' (using password: YES)] in CONNECT(DB_HOST, '****', '****', DB_NAME) in /var/www/html/bans/includes/adodb/adodb-errorhandler.inc.php on line 79
I didnt changed anything. I checked all configs and nothing changed. i also created a complete new Database and a new user with all permissions but i get the same error.

Every server startet calling this error after the daily game server restarts.
Tomorrorw morning i try a root server re


Edit: I got a temp fix. I added % to the MySQL whitelist. the Serverip is still still in there too but didnt work anymore for unknown reasons

nothing to do with plugin

plugin cant reach ur mysql with following error [Access denied for user]
im sure you want to want PC 1[Game Server] connect to PC2[MySQL] ?

which machine you using for MySQL
__________________
.:[ >> My Plugins << ]:.

My discord : oqyh
oqyh is offline
YoUrEnD
Member
Join Date: Nov 2015
Location: Germany
Old 12-02-2023 , 09:03   Re: MySQL stop working
Reply With Quote #3

Rented RootServer try to reach MySQL Database from rented Webspace Server.

It worket for years and suddenly stopt working.
And by setting the option to let pass everyone in MySQL ip whitelist everything works again but makes the whitelist useless.
__________________
Counter-Strike Source Server
https://high-devil-force.de
YoUrEnD is offline
oqyh
Senior Member
Join Date: May 2019
Location: United Arab Emirates
Old 12-03-2023 , 06:12   Re: MySQL stop working
Reply With Quote #4

Quote:
Originally Posted by YoUrEnD View Post
Rented RootServer try to reach MySQL Database from rented Webspace Server.

It worket for years and suddenly stopt working.
And by setting the option to let pass everyone in MySQL ip whitelist everything works again but makes the whitelist useless.
set it to % work for you means

you dont have issue on firewall

you dont have issue on bind-address local

my guess is you put wrong ip in whitelist

try ask Rented RootServer whats the ip of the game server

my question:

-is rented rootserver with root control of ubuntu/windows terminal or just game config control
-is rented Webspace Server you have is control by phpmyadmin or machine terminal
__________________
.:[ >> My Plugins << ]:.

My discord : oqyh
oqyh is offline
YoUrEnD
Member
Join Date: Nov 2015
Location: Germany
Old 12-05-2023 , 22:58   Re: MySQL stop working
Reply With Quote #5

"I" got the problem fixed.
it was not a wrong IP i got that ip for years in this list.
I wrote the Support of the MySQL Hoster.
One day later they wrote me "try again now" so i just removed the "%" and restartet the gameservers and everything works fine again. (btw on rootserver i have controll with Debian. i installed the gameserver by myself. and webspace just controll with phpmyadmin and to solve the problem i needed to "flush-hosts" but had not the permission to do this.)
__________________
Counter-Strike Source Server
https://high-devil-force.de
YoUrEnD is offline
oqyh
Senior Member
Join Date: May 2019
Location: United Arab Emirates
Old 12-06-2023 , 22:27   Re: MySQL stop working
Reply With Quote #6

Quote:
Originally Posted by YoUrEnD View Post
"I" got the problem fixed.
it was not a wrong IP i got that ip for years in this list.
I wrote the Support of the MySQL Hoster.
One day later they wrote me "try again now" so i just removed the "%" and restartet the gameservers and everything works fine again. (btw on rootserver i have controll with Debian. i installed the gameserver by myself. and webspace just controll with phpmyadmin and to solve the problem i needed to "flush-hosts" but had not the permission to do this.)
I'm glad to hear that

good luck
__________________
.:[ >> My Plugins << ]:.

My discord : oqyh
oqyh is offline
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

Forum Jump


All times are GMT -4. The time now is 18:29.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode