Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pterodactyl game panel SQL error #10

Closed
myxxmikeyxx opened this issue May 17, 2022 · 4 comments
Closed

pterodactyl game panel SQL error #10

myxxmikeyxx opened this issue May 17, 2022 · 4 comments

Comments

@myxxmikeyxx
Copy link

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
Copy link
Author

myxxmikeyxx commented May 17, 2022

I tried changing the network to this:
networks: default: ipam: config: - subnet: 172.20.0.0/16

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
Copy link
Author

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

@myxxmikeyxx
Copy link
Author

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
Copy link
Author

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?

@techno-tim techno-tim locked and limited conversation to collaborators May 18, 2022
@timothystewart6 timothystewart6 converted this issue into discussion #11 May 18, 2022

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant