docker-compose & Exposed Ports

I unfortunately also have a problem connecting. In docker-compose.yml a have the following setup:

      POSTGRES_DB: ${POSTGRES_DB:-app}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-none}
      POSTGRES_USER: ${POSTGRES_USER:-symfony}

Now, when I run the command psql --user=symfony --port=49153 --host=127.0.0.1 --password app and give the password, I get the error:

psql: error: connection to server at "127.0.0.1", port 49153 failed: FATAL:  password authentication failed for user "symfony"

However, when I use the command docker-compose exec database psql --user app --password app and give the password, I do get in which makes no sense to me. Could you please demystify?

by the way, symfony console doctrine:database:create gives the following error:

An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 49154 failed: FATAL:  password authentication failed for user "app"

Hello, i have a problem when i run this command
psql --user=app --port=52439 --host=127.0.0.1 --password app, the result is :

psql: The term 'psql' is not recognized as a name of a cmdlet, function, script file, or executable program.
Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

Docker is running on Windows 11, if i execute
docker-compose ps, the result is :

NAME                     COMMAND                  SERVICE             STATUS              PORTS
mixed_vinyl-database-1   "docker-entrypoint.s…"   database            running             0.0.0.0:52439->5432/tcp

What is doing to resolve this mistake ?

Thanks,
Laurent

Hey Laurent-G,

It seems like you're missing that psql command installed locally, though the error message is a bit weird to me. Do you have psql installed locally? You should have it installed to be able to connect to the DB from Docker. On my Mac when I execute psql --version it shows me psql (PostgreSQL) 14.5 (Homebrew), IIRC I installed the PostgreSQL via Brew package manager locally and it brought me that psql command. If you don't have PostgreSQL installed locally - try to install it first. But brew is specific for Mac, you should find a way to install PostgreSQL on Windows.

Of if you don't want to (or cannot) install it locally - see the next chapter where we execute that psql command directly from the Docker container.

Cheers!

Thanks Victor for your answer.

i don't have installed psql locally. I'm going to see for install psql on my windows system.
i already saw in the next chapter the command to execute psql from Docker container and it's work very good.

Thanks a lot,
Laurent

Hey Laurent-G,

Glad that executing it from the Docker container works for you, thanks for confirming! I bet you just need to install PostgreSQL and it will bring that psql command into your system automatically. Or you can just ignore it and execute it directly from the Docker container - that's the benefit of having Docker ;)

Cheers!

Is there a version of this with a mysql container. Tried using Postgres's but getting data from an existing mysql database to the Postgres container is too hard

figured it out (lost a lot of time because of the stupid ! at the start of the !ChangeMe! password......)

1. change the DATABASE_URL in the .env file to the mysql one.
2. remove the !ChangeMe! password docker-compose doesn't like it when it tries to create a mysql container
3. comment out the the postgres lines in the docker-compose.yml (From the services: tag to the end)
4. Add the following lines to your docker-compose.yml

services:
  database:
    container_name: database
    image: mysql:8.0
    command: --default-authentication-plugin=mysql_native_password
    environment:
      MYSQL_ROOT_PASSWORD: yoursecretrootpassword
      MYSQL_DATABASE: yourdbname
      MYSQL_USER: app
      MYSQL_PASSWORD: yourpasswd   <-- the one you used in the .env file
    ports:
      - '3306:3306'
    volumes:
      - ./mysql:/var/lib/mysql`

Hey Red,

I'm happy to see you were able to find the solution! And thanks for sharing it with others :)

Cheers!

Hi, running command "docker-compose exec database psql --username symfony --password app" I'm prompted for a password, which I enter (to match the one in the docker compose file which is !ChangeMe! but then... it just hangs. Cursor flashes, but no response at all. I can connect to the database successfully using DBeaver (a GUI database client), it connects and can see the database fine. This is what I see at the terminal:
`$ docker-compose exec database psql --username app --password app
Password: !ChangeMe!

`

Hey Mark,

Hm, could you change that "!ChangeMe!" password in .env files to something without special chars, I guess that the exclamation char (!) may cause issues. And then restart the server and try to connect with the new credentials.

Cheers!

Hi and thanks for this new tutorial!

I've an error when I run docker-compose exec database psql --username symfony --password app:
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "symfony" does not exist

Am I missing something?

OS: Linux Mint 20.3 Cinnamon 5.2.7
Kernel: 5.4.0-124-generic
Docker version 20.10.17, build 100c70
docker-compose version 1.28.6, build 5db8d86f

Hey Thomas A.!

Oh sheesh - try this instead - changing "symfony" to "app":

docker-compose exec database psql --username app --password app

Explanation: RIGHT after recording, the recipe was updated - you probably have the new version https://github.com/symfony/...

Let me know if that helps - we'll need to add a note about it :).

Cheers!