#500 | Server Error

1 messages · Page 1 of 1 (latest)

turbid vale
#

I have forgot the password I setup for the mysql so I reset it and now I get error 500 is there a way to modify the user password in the files for the server to work?

iron ravine
#

You need to update the database credentials in your .env file

ocean perchBOT
#

The env file can be found at /var/www/pterodactyl/.env. Files starting with a . in Linux are hidden so it may not show up in file browsers by default. You can open it directly with nano /var/www/pterodactyl/.env

turbid vale
ocean perchBOT
#

You'll need to grab the error logs from the Panel. The following command uploads the last 150 lines of this day's log to our pastebin and provides a link you can share.
tail -n 150 /var/www/pterodactyl/storage/logs/laravel-$(date +%F).log | nc pteropaste.com 99

turbid vale
ocean perchBOT
#

I have found the following for: https://pteropaste.com/nqi84zp4wqn7
🇫🇷 🥖 Bienvenue sur Internet, @turbid vale 🥖 🇫🇷

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

iron ravine
#

Restart pteroq so it can get the updated config and hopefully stop spewing errors into the log, then try accessing the panel again.
If it still errors, get fresh logs

ocean perchBOT
#

Easy!

systemctl restart pteroq
turbid vale
#

still not

ocean perchBOT
#

I have found the following for: https://pteropaste.com/lo8deaof6zqi
🇫🇷 🥖 Bienvenue sur Internet, @turbid vale 🥖 🇫🇷

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

turbid vale
#

ok got it fixed