Can't run migrations with Docker: php version mismatch

@Sinnbeck That didn't work. Or, the command was executed, but an error was thrown. Instead of keep trying to make sail work, at the moment I prefer trying another way, like valet, or even maybe just mamp pro..

@stratboy Thats. Fair. Let me know if you pick up docker later. I use it daily and its cool :)

@stratboy I can see you still want to get this working. If you share the error, it will be easier to help

@stratboy have you viewed some of the docker videos.

@jlrdw No, I didn't see there were docker videos. I'll watch them for sure thank you

@Sinnbeck Hi, yes, I was able to solve at least the php problem. Now when I run sail artisan migrate, I get:

   Illuminate\Database\QueryException 

  SQLSTATE[HY000] [1045] Access denied for user 'sail'@'172.23.0.7' (using password: YES) (SQL: select * from information_schema.tables where table_schema = testsite4 and table_name = migrations and table_type = 'BASE TABLE')

@stratboy Great. Have you changed the data at any point since your installed sail? If so, then the credentials are wrong.

Try this

sail down -v
sail build --no-cache
sail up -d

@Sinnbeck doesn't work. So I checked the db:

docker-compose exec mysql bash
mysql -u sail -p # doesn't work
mysql -u root -p # it works, without password
show databases; # it properly shows testsite4
use mysql;
select user, host from user;

+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| healthchecker    | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+

No sail user here.

@stratboy Can you show your docker-compose.yml file? :)

@Sinnbeck

# 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'
        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:
            - mysql
            - redis
            - meilisearch
            - selenium
    mysql:
        image: 'mysql/mysql-server:8.0'
        ports:
            - '${FORWARD_DB_PORT:-3306}:3306'
        environment:
            MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ROOT_HOST: "%"
            MYSQL_DATABASE: '${DB_DATABASE}'
            MYSQL_USER: '${DB_USERNAME}'
            MYSQL_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ALLOW_EMPTY_PASSWORD: 1
        volumes:
            - 'sailmysql:/var/lib/mysql'
        networks:
            - sail
        healthcheck:
            test: ["CMD", "mysqladmin", "ping", "-p${DB_PASSWORD}"]
            retries: 3
            timeout: 5s
    redis:
        image: 'redis:alpine'
        ports:
            - '${FORWARD_REDIS_PORT:-6379}:6379'
        volumes:
            - 'sailredis:/data'
        networks:
            - sail
        healthcheck:
            test: ["CMD", "redis-cli", "ping"]
            retries: 3
            timeout: 5s
    meilisearch:
        image: 'getmeili/meilisearch:latest'
        platform: linux/x86_64
        ports:
            - '${FORWARD_MEILISEARCH_PORT:-7700}:7700'
        volumes:
            - 'sailmeilisearch:/data.ms'
        networks:
            - sail
        healthcheck:
            test: ["CMD", "wget", "--no-verbose", "--spider",  "http://localhost:7700/health"]
            retries: 3
            timeout: 5s
    mailhog:
        image: 'mailhog/mailhog:latest'
        ports:
            - '${FORWARD_MAILHOG_PORT:-1025}:1025'
            - '${FORWARD_MAILHOG_DASHBOARD_PORT:-8025}:8025'
        networks:
            - sail
    selenium:
        image: 'selenium/standalone-chrome'
        volumes:
            - '/dev/shm:/dev/shm'
        networks:
            - sail
networks:
    sail:
        driver: bridge
volumes:
    sailmysql:
        driver: local
    sailredis:
        driver: local
    sailmeilisearch:
        driver: local

@stratboy Great. Can you show your local .env file for the DB_ stuff?

@Sinnbeck shown below. Should I maybe manually add the user (create user)? But if yes, where can I fine the host IP informations? Is the IP fixed/static for each container?

@Sinnbeck

DB_CONNECTION=mysql
DB_HOST=mysql
DB_PORT=3306
DB_DATABASE=testsite4
DB_USERNAME=sail
DB_PASSWORD=

@stratboy It should be automatically added when your create container the first time. It creates a volume where the data is saved. I honestly cant think of reason why deleting the volume didn't work. I google a bit and people tend to agree that the solution I suggested is how you rebuild it.

https://stackoverflow.com/a/65607826/1305117

@Sinnbeck I know, but here doesn't work. Probably I'll go back to mamp or valet. Quite disappointed though (not with you all, obviously, but with Laravel), because Docker is currently presented as the easier, zero config solution. It's not, not in every case. I found several posts on google about people struggling with my very same issues (and stil I didn't find any solution anyway). So I should study Docker from the inside, which definitely it's not what's supposed to be done by a guy trying to learn Laravel (and not Docker). It's simply a pity, in my own opition..

@Sinnbeck Hi! I finally managed to get it working. I really don't know what was the problem. I just tried to completely delete the container and reinstall everything again on another folder, starting again with curl -s "https://laravel.build/example-app" | bash and all went fine for now, migrations included.

Thank you anyway for all your support.

@stratboy sweet. Good to hear :)

@martinbean What do you mean? I click the cli from php image in Docker, but when running migrations I get the same error above.

@stratboy Because the version of PHP in a Docker image might be different to the version of PHP installed on your computer, hence the version mismatch error.

@martinbean ok but I was doing it from the container. Anyway, by resetting a few thing I got php right, now I have a problem with db access :)