What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hello Guys, I'm getting an error while connecting database for my b2b shop i have attached an screen

U01J3GPTA1H
U01J3GPTA1H Posts: 43 πŸ§‘πŸ»β€πŸš€ - Cadet

Hello Guys,
I'm getting an error while connecting database for my b2b shop i have attached an screenshot of the error message. if anyone have any idea about this please suggest . Thanks

Comments

  • U01QH008X2Q
    U01QH008X2Q Posts: 1 πŸ§‘πŸ»β€πŸš€ - Cadet

    If you are using default shop and docker than take a look to deploy.dev.yml

    database:
        engine: postgres
        root:
            username: "root"
            password: "secret"
        endpoints:
            localhost:5432:
                protocol: tcp
    

    Default DB engine is postgres not MySQL and the password and username also differs from the one from screenshot. Assuming check settings in the config yml files for you setup.

  • yes, i also see that there is already a postgres connection

  • however, the password is correct for the eu-docker database

  • same config yaml file, different section:

  • this will give you access to the EU region’s database only

  • enough for most scenarios

  • U01LE4BMBK7
    U01LE4BMBK7 Posts: 241 πŸ§‘πŸ»β€πŸš€ - Cadet

    you're trying to connect to a mysql database on the postgres port 5432 πŸ€”

  • i guess he is actually using postgres, just a little mistake. is that correct, @U01J3GPTA1H?

  • U01J3GPTA1H
    U01J3GPTA1H Posts: 43 πŸ§‘πŸ»β€πŸš€ - Cadet

    Yes i am using postgres and following as you said above @UJN2JRU4F using these configuration

    database: eu-docker
    username: spryker
    password: secret
    

    and now i am getting an error

  • you did use the password secret ?

  • U01J3GPTA1H
    U01J3GPTA1H Posts: 43 πŸ§‘πŸ»β€πŸš€ - Cadet

    Yes

  • U01J3GPTA1H
    U01J3GPTA1H Posts: 43 πŸ§‘πŸ»β€πŸš€ - Cadet
    edited March 2021

    Thanks to all of you guys i got the solution
    docker/sdk clean-data && docker/sdk up --data && docker/sdk console q:w:s -v -s
    this works for me