sail sqlite file not found

@rodrigo.pedra The absolute weirdest part is "db/databse.sqlite" worked to do a sail artisan migrate but from the browser I get an error saying the file was not found. So sail was able to resolve the network but docker container was not able to find the correct path. Then I changed it back to "../db/database.sqlite" and that worked.

@chucklin72

Well, if you can share it is the base absolute path, inside docker, it will be easier to help.

Also you can try providing the absolute path to the database fie, which from the configuration you shared so far would be:

DB_DATABASE="/root/db/database.sqlite"

With no dots, or relative paths.

@rodrigo.pedra

# For more information: https://laravel.com/docs/sail
version: '3'
services:
    laravel.test:
        build:
            context: ./vendor/laravel/sail/runtimes/8.1
            dockerfile: Dockerfile
            args:
                WWWGROUP: '${WWWGROUP}'
        image: sail-8.1/app
        extra_hosts:
            - 'host.docker.internal:host-gateway'
        ports:
            - '${APP_PORT:-80}:80'
            - '${VITE_PORT:-5173}:${VITE_PORT:-5173}'
        environment:
            WWWUSER: '${WWWUSER}'
            LARAVEL_SAIL: 1
            XDEBUG_MODE: '${SAIL_XDEBUG_MODE:-off}'
            XDEBUG_CONFIG: '${SAIL_XDEBUG_CONFIG:-client_host=host.docker.internal}'
        volumes:
            - '.:/var/www/html'

        networks:
            - sail
        depends_on:
            - sqlite3
    mailhog:
        image: 'mailhog/mailhog:latest'
        ports:
            - '${FORWARD_MAILHOG_PORT:-1025}:1025'
            - '${FORWARD_MAILHOG_DASHBOARD_PORT:-8025}:8025'
        networks:
            - sail
    sqlite3:
        image: nouchka/sqlite3:latest
        stdin_open: true
        tty: true
        volumes:
            - './db/:/root/db/'
networks:
    sail:
        driver: bridge
volumes:
    sqlite3:
        driver: local

@rodrigo.pedra with /root/db/database.sqlite it doesnt work in the app nor artisan.

I made docker-compose.yml

    sqlite3:
        image: nouchka/sqlite3:latest
        stdin_open: true
        tty: true
        volumes:
            - '/var/www/html/db/:/root/db/'

that seems to work.

@rodrigo.pedra thanks! That gave me something else to try that worked.

    sqlite3:
        image: nouchka/sqlite3:latest
        stdin_open: true
        tty: true
        volumes:
            - '/var/www/html/db/:/root/db/'

also set DB_DATABASE = "/var/www/html/db/database.sqlite" in .env

@chucklin72 try

DB_DATABASE=./db/database.sqlite

Illuminate\Database\Connectors\SQLiteConnector uses PHP's realpath() function to find the absolute path.

I thought using the absolute path from within the docker volume should work, the code above is trying to resolve from your local path

Wait a minute... you are downloading a different image for sqlite... does it create a new volume?

That is why /root/db/ is not available on the web/application container.

Why are you spinning up a different container just for SQLite?

If your PHP's image inside your web/application container have the php-sqlite module installed, sqlite is then embedded in PHP.

Do as a regular Laravel application, create the file ./database/database.sqlite inside your project's directory, and you should be good to go.

If you really want to use a folder name ./db/ inside your project's structure, just create the /db/ directory and a blank file named database.sqlite inside of it.

The blank file must exist before migrating. in Linux/macOS you can use the touch CLI command to create a blank file.

Then you can even remove this nouchka/sqlite3 container from your docker-compose file.