#DB issue

7 messages · Page 1 of 1 (latest)

bronze fog
#

can this time some kid not post about getting hacked? lol

unique brook
#

[2023-10-07 21:45:47] production.NOTICE: A query exception was encountered while trying to load settings from the database: SQLSTATE[HY000] [1045] Access denied for user 'pterodactyl'@'localhost' (using password: YES) (SQL: select * from settings)
[2023-10-07 21:45:47] production.ERROR: SQLSTATE[HY000] [1045] Access denied for user 'pterodactyl'@'localhost' (using password: YES) (SQL: select * from nodes where (daemon_token_id = S4sPEnhZ7bJFhpHM) limit 1) {"exception":"[object] (Illuminate\Database\QueryException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'pterodactyl'@'localhost' (using password: YES) (SQL: select * from nodes where (daemon_token_id = S4sPEnhZ7bJFhpHM) limit 1) at /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760)

summer sleetBOT
#

🇫🇷 🥖 Bienvenue sur Internet, @unique brook 🥖 🇫🇷

Your database is refusing the Panel's attempts to connect to it. This can be for a number of different reasons so I'll let a human double check, but here are some ideas.

  1. Is your MySQL instance running? systemctl status mysql(hopefully not down the road)
  2. Is the user you're trying to connect with authorized to access the given database from this IP address?
  3. Did you correctly give that user permission to even access that database?
  4. Do you have a Firewall that is blocking connections?
  5. Is your MySQL instance bound to 127.0.0.1 or localhost and you're trying to connect from outside the server?
  6. Does the user have GRANT permissions if you're trying to use them to create a new database for a server?
  7. Have special characters in your password? Make sure DB_PASSWORD in your .env file is enclosed in double quotes

Here is some additional documentation to help you out: https://pterodactyl.io/tutorials/mysql_setup.html

unique brook
#

@bronze fog '

bronze fog
#

systemctl status mysql
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset:>
Active: active (running) since Sat 2023-10-07 20:52:19 UTC; 13h ago
Process: 750 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=ex>
Main PID: 846 (mysqld)
Status: "Server is operational"
Tasks: 39 (limit: 9248)
Memory: 431.7M
CPU: 5min 10.501s
CGroup: /system.slice/mysql.service
└─846 /usr/sbin/mysqld

Oct 07 20:52:18 vps-2f89 systemd[1]: Starting MySQL Community Server...
Oct 07 20:52:19 vps-2f89 systemd[1]: Started MySQL Community Server.

#

Something happened after creating a new database on the same linux machine