Unable to connect to DB in laravel

Question

php artisan migrate works, but I can migrate, but when I try to retrieve a record with eloquent, I get the following error The environment is docker.

SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5433? (SQL: select * from "reservaions")

.env

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5433
DB_DATABASE=root
DB_USERNAME=root
DB_PASSWORD=pass

docker-compose.yml

  # PostgreSQL
  db:
    image: postgres:9.6
    container_name: myapp-db
    environment:
      POSTGRES_DB: root
      POSTGRES_USER: root
      POSTGRES_PASSWORD: pass
    ports:
      - "5433:5432"
    volumes:
      - ./docker/db/:/docker-entrypoint-initdb.d

controller

 public function getReservations()
    {
        $reservations = Reservaion::all();
        return $reservations;
    }

model

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Reservaion extends Model
{
}

The strange thing is that the DB client tools and migrations have been successful. Why does it fail when accessing the DB from the controller via the model? Thanks.

Maksim · Accepted Answer · 2021-08-10 16:16:06Z

2

In docker-compose you can reach services by their names. Than, in your case, DB_HOST=db

Why work?

Because you have Postgres installed on you computer (not docker) and when you migrate from console - your DB host can connect to 127.0.0.1

For future - work with artisan from docker php service: docker-compose exec {PHP_SERVICE} bash

edited Aug 10, 2021 at 16:16

answered Aug 10, 2021 at 16:07

Maksim

2,9672 gold badges20 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Maksim Over a year ago

oh sorry, edited - host is not pgsql, it's db, copy paste is evil :)

youkichi Over a year ago

Thank you. I solved the problem by writing the container name of docker-db in .env.

Maksim Over a year ago

Yes, service name OR container name

Collectives™ on Stack Overflow

Unable to connect to DB in laravel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related