Please help me fix my Panel. | Pterodactyl® | Page 1

gloomy tree Jun 12, 2024, 9:38 PM

#

So I tried setting up mySQL and ran into an issue. I could not create the database called 'panel' as described in the instructions because it already existed. The Bot told me to delete it and that's what I did. Now the Panel isn't accessible anymore and wings is apparently also offline. I'm super worried as I had many Private servers on there. Advice would be appreciated!

#

'Could not open input file: artisan'

odd crystalBOT Jun 12, 2024, 9:41 PM

#

@gloomy tree; you must be in the panel directory (usually /var/www/pterodactyl) to run artisan commands.

gloomy tree Jun 12, 2024, 9:42 PM

#

I get this issue when running php artisan up

  SQLSTATE[HY000] [1045] Access denied for user 'pterodactyl'@'localhost' (using password: YES) (Connection: mysql, SQL: select * from information_schema.tables where table_schema = panel and table_name = migrations and table_type = '
  BASE TABLE')


In Connector.php line 65:

  SQLSTATE[HY000] [1045] Access denied for user 'pterodactyl'@'localhost' (using password: YES)```

odd crystalBOT Jun 12, 2024, 9:42 PM

#

🇫🇷 🥖 Bienvenue sur Internet, @gloomy tree 🥖 🇫🇷

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.

Is your MySQL instance running? systemctl status mysql(hopefully not down the road)
Is the user you're trying to connect with authorized to access the given database from this IP address?
Did you correctly give that user permission to even access that database?
Do you have a Firewall that is blocking connections?
Is your MySQL instance bound to 127.0.0.1 or localhost and you're trying to connect from outside the server?
Does the user have GRANT permissions if you're trying to use them to create a new database for a server?
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

gloomy tree Jun 12, 2024, 9:43 PM

#

My Panel says 503 | Service Unavailable

odd crystalBOT Jun 12, 2024, 9:43 PM

#

@gloomy tree! Your Panel appears to be in maintenance mode should you receive 503 service unavailable errors. Should you be performing a Panel update, please return back to the documentation and do it again, since you've missed steps.

Otherwise, you can type php artisan up in the web root directory, by default at /var/www/pterodactyl.

gloomy tree Jun 12, 2024, 9:46 PM

#

When running: systemctl status mysql
I get this Error:

Jun 12 21:42:51 instance-20221017-1516 mariadbd[919]: 2024-06-12 21:42:51 309 [Warning] Access denied for user 'pterodactyl'@'localhost' (using password: YES)
Jun 12 21:42:51 instance-20221017-1516 mariadbd[919]: 2024-06-12 21:42:51 310 [Warning] Access denied for user 'pterodactyl'@'localhost' (using password: YES)
Jun 12 21:42:53 instance-20221017-1516 mariadbd[919]: 2024-06-12 21:42:53 311 [Warning] Access denied for user 'pterodactyl'@'localhost' (using password: YES)
Jun 12 21:42:55 instance-20221017-1516 mariadbd[919]: 2024-06-12 21:42:55 312 [Warning] Access denied for user 'pterodactyl'@'localhost' (using password: YES)
Jun 12 21:42:58 instance-20221017-1516 mariadbd[919]: 2024-06-12 21:42:58 313 [Warning] Access denied for user 'pterodactyl'@'localhost' (using password: YES)
Jun 12 21:43:00 instance-20221017-1516 mariadbd[919]: 2024-06-12 21:43:00 314 [Warning] Access denied for user 'pterodactyl'@'localhost' (using password: YES)
Jun 12 21:43:01 instance-20221017-1516 mariadbd[919]: 2024-06-12 21:43:01 315 [Warning] Access denied for user 'pterodactyl'@'localhost' (using password: YES)
Jun 12 21:43:01 instance-20221017-1516 mariadbd[919]: 2024-06-12 21:43:01 316 [Warning] Access denied for user 'pterodactyl'@'localhost' (using password: YES)
Jun 12 21:43:08 instance-20221017-1516 mariadbd[919]: 2024-06-12 21:43:08 317 [Warning] Access denied for user 'pterodactyl'@'localhost' (using password: YES)

molten badger Jun 13, 2024, 5:57 AM

#

gloomy tree So I tried setting up mySQL and ran into an issue. I could not create the databa...

Why would you try to create the panel database when you already had the panel installed ?

gloomy tree Jun 13, 2024, 5:58 AM

#

Because I thought that is the way to make databases for individual servers. Needed one for luckperms :( won’t do again

#

How do I fix this?

molten badger Jun 13, 2024, 5:59 AM

#

https://pterodactyl.io/tutorials/mysql_setup.html#creating-a-database-host-for-nodes is what you should have been following

Setting up MySQL | Pterodactyl

Pterodactyl is an open-source game server management panel built with PHP, React, and Go. Designed with security in mind, Pterodactyl runs all game servers in isolated Docker containers while exposing a beautiful and intuitive UI to end users.

molten badger Jun 13, 2024, 6:00 AM

#

gloomy tree How do I fix this?

You've deleted your panel database, If you don't have a backup then you probably should reinstall everything at this point.

gloomy tree Jun 13, 2024, 6:11 AM

#

Okay :)

gloomy tree Jun 13, 2024, 6:12 AM

#

molten badger You've deleted your panel database, If you don't have a backup then you probably...

Oh, I have also a wings instance running on this server. This should be fine, right? „Only“ the panel is broken?

#

YEEES

#

Okay, I’m currently not at home, I’m at work currently. What do I do with the recovered files then?

#

Or how do I get them from the Linux server to my Home pc?

#

Ah, so I’m recovering the gameservers?

#

Any Idea how to transfer the files?

#

Would this be fine? Or would it f up the panel even more?

https://blogs.oracle.com/research/post/how-to-transfer-files-between-your-local-computer-and-the-cloud

gloomy tree Jun 13, 2024, 2:26 PM

#

Those are the files, right?

#

yes

#

I'm packing them in a zip rn

#

zip -r /var/lib/pterodactyl/exfil.zip /var/lib/pterodactyl would this work? I'm a bit scared

#

oh, no manual entry for zip

#

I'll install it

#

I got quite a lot of files, I'll tell when I downloaded the zip

gloomy tree Jun 13, 2024, 2:55 PM

#

@tardy lotus I got the files on my home pc now

#

I was supposed to get the files from /var/lib/pterodactyl/ right?

#

saved the whole /pterodactyl folderfrom lib

#

no files to download from www/pterodactyl?

#

looks good?

#

looks good.

#

now the rm command?

#

as root

#

are those important?

#

Can there be anythin important if I didn't install any plugins for pteo?

#

ok. Didn't modify the fe

#

rm: cannot remove '/var/lib/pterodactyl': Directory not empty

#

ok

#

had to close ftp client

#

i executed the rf but these stayed

#

ahh

#

worked

#

eh

#

yes

#

from start on?

#

ok

#

also the install composer thingsß

#

?

#

ok, thanks!

#Please help me fix my Panel.