#Databases tab problem

13 messages · Page 1 of 1 (latest)

mortal breach
#

Hi,

I've just installed and configured PhpMyAdmin, it works fine. Except that when I create a database on my Pterodactyl server, I get an error saying that there has been a problem, the database is created on PMA but is not displayed in my "databases" tab on Pterodactyl (error 500 in Console). No error in the pterodactyl logs.

Thank you in advance for your help.

grave minnow
#

If you're running in docker, look at the pins in #panel-in-docker for the hashid issue

mortal breach
grave minnow
#

Are you running the panel in docker ?

#

Because that doesn't look like you are

mortal breach
#

Ah, I don't think so, so it's normal that I can't find it.

junior harnessBOT
#

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

mortal breach
#

It returns no link pteropaste

#

I got this error when I restarted my VPS for testing.

[2024-12-07 20:07:01] production.NOTICE: A query exception was encountered while trying to load settings from the database: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select * from `settings`)
[2024-12-07 20:07:02] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select * from `settings` where `key` = app:telemetry:uuid limit 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 2002): SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select * from `settings` where `key` = app:telemetry:uuid limit 1) at /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760)
[stacktrace]
#0 /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Connection.php(899): Illuminate\\Database\\Connection->runQueryCallback()
#1 /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Connection.php(878): Illuminate\\Database\\Connection->tryAgainIfCausedByLostConnection()
#2 /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Connection.php(722): Illuminate\\Database\\Connection->handleQueryException()
#3 /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Connection.php(405): Illuminate\\Database\\Connection->run()
#4 /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2718): Illuminate\\Database\\Connection->select()
#5 /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2707): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3247): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Query\\Builder->onceWithColumns()
junior harnessBOT
#

🇫🇷 🥖 Bienvenue sur Internet, @mortal breach 🥖 🇫🇷

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

mortal breach