search

techno-tim / launchpad

A collection of quick starters for ansible, kubernetes, docker, linux, windows, and more. Great for HomeLabs!
https://technotim.live
1.47k stars 480 forks source link

pterodactyl game panel SQL error #10

Closed myxxmikeyxx closed 2 years ago

myxxmikeyxx commented 2 years ago

After running the docker compose I run the command you have for making a user: docker-compose run --rm panel php artisan p:user:mak

I am getting

Connection.php line 692: SQLSTATE[HY000] [1045] Access denied for user 'pterodactyl'@'172.20.0.5' (using password: YES) (SQL: select * from information_schema.tables where table_schema = panel and table_name = migrations and table_type = 'BASE T ABLE')

And Both In PDOConnection.php line 39: In Exception.php line 18: are giving the error: SQLSTATE[HY000] [1045] Access denied for user 'pterodactyl'@'172.20.0.5' (using password: YES)

I saw that it is looking for an IP of 172.20.0.5 but when I check all the container IP's with docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' $(docker ps -q)

I get this list of IP's: 172.20.0.4 172.20.0.2 172.20.0.3

How can I set the IP for the database in the Docker-Compose file. I found this but I don't understand it: Link

myxxmikeyxx commented 2 years ago

I tried changing the network to this: `networks: default: ipam: config:

I then changed the database to: services: database: image: mariadb:10.5 networks: default: ipv4_address: 172.20.0.5

Now I'm not getting the connection error I'm getting: No letsencrypt email is set Checking database status. nc: bad address 'database' Waiting for database connection...

After running docker compose run --rm panel php artisan p:user:mak

The new IP's list are: 172.20.0.3 172.20.0.5 172.20.0.2

myxxmikeyxx commented 2 years ago

I changed the IP of the database to 172.20.0.5 but now its trying to connect on 172.20.0.4

myxxmikeyxx commented 2 years ago

I tried changing the IP by running docker run -d --ip="172.20.0.4" mariadb:10.5 But now when I run the make account command it is asking for 172.20.0.5 again

myxxmikeyxx commented 2 years ago

I have resorted to running it directly on ubuntu using this site and the script for install: https://www.ghostcap.com/install-pterodactyl-panel/ The script walks you through the whole process, could this be used for the panel and wings setup in docker?