Problem installing vito locally on Windows and Sail #51

mahemmati · 2023-09-17T14:53:06Z

mahemmati
Sep 17, 2023

Hi there ...
I proceeded Installation steps as in https://vitodeploy.com/introduction/installation.html#laravel-sail
And modified below values within my .env file:
DB_HOST=mysql
DB_USERNAME=sail
DB_PASSWORD=password
REDIS_HOST=redis
After starting sail, the app could not find the database as the php artisan migrate returns:
could not find driver (Connection: mysql, SQL: select * from information_schema.tables where table_schema = vito and table_name = migrations and table_type = 'BASE TABLE')
And the web request returns query exception as:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vito.sessions' doesn't exist (Connection: mysql, SQL: select * from sessions where /id = eqmRo70IomfyI36klpCDK0yBcWm6wNkMV41I80rH limit 1)`
Any Ideas?

Answered by saeedvaziry

Sep 17, 2023

Updated the documentation for sail and the env files in the root directory of the project.

View full answer

saeedvaziry · 2023-09-17T15:04:14Z

saeedvaziry
Sep 17, 2023
Maintainer

is mysql container is up after booting up the containers?

8 replies

saeedvaziry Sep 17, 2023
Maintainer

I wanted to see the mysql container's logs

mahemmati Sep 17, 2023
Author

This is mysql's logs:

2023-09-17 18:05:48 [Entrypoint] MySQL Docker Image 8.0.32-1.2.11-server
2023-09-17 18:05:48 [Entrypoint] Initializing database
2023-09-17 18:05:56 [Entrypoint] Database initialized
2023-09-17 18:06:01
2023-09-17 18:06:01 [Entrypoint] running /docker-entrypoint-initdb.d/10-create-testing-database.sh
2023-09-17 18:06:01
2023-09-17 18:06:03 [Entrypoint] Server shut down
2023-09-17 18:06:03
2023-09-17 18:06:03 [Entrypoint] MySQL init process done. Ready for start up.
2023-09-17 18:06:03
2023-09-17 18:06:03 [Entrypoint] Starting MySQL 8.0.32-1.2.11-server
2023-09-17 18:05:48 2023-09-17T14:35:48.940254Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-09-17 18:05:48 2023-09-17T14:35:48.940401Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.32) initializing of server in progress as process 17
2023-09-17 18:05:48 2023-09-17T14:35:48.952050Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-17 18:05:49 2023-09-17T14:35:49.474147Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-09-17 18:05:51 2023-09-17T14:35:51.691187Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2023-09-17 18:05:56 2023-09-17T14:35:56.592978Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-09-17 18:05:56 2023-09-17T14:35:56.594373Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 60
2023-09-17 18:05:56 2023-09-17T14:35:56.615128Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-17 18:05:56 2023-09-17T14:35:56.760266Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-09-17 18:05:57 2023-09-17T14:35:57.216486Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-09-17 18:05:57 2023-09-17T14:35:57.216582Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-09-17 18:05:57 2023-09-17T14:35:57.247541Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2023-09-17 18:05:57 2023-09-17T14:35:57.247741Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server - GPL.
2023-09-17 18:05:58 Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
2023-09-17 18:05:58 Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
2023-09-17 18:06:01 Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
2023-09-17 18:06:01 Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
2023-09-17 18:06:01 Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2023-09-17 18:06:01 mysql: [Warning] Using a password on the command line interface can be insecure.
2023-09-17 18:06:01 2023-09-17T14:36:01.300650Z 15 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.32).
2023-09-17 18:06:02 2023-09-17T14:36:02.973326Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-09-17 18:06:03 2023-09-17T14:36:03.542400Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-09-17 18:06:03 2023-09-17T14:36:03.543943Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1
2023-09-17 18:06:03 2023-09-17T14:36:03.559335Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-17 18:06:03 2023-09-17T14:36:03.720946Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-09-17 18:06:04 2023-09-17T14:36:04.108614Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-09-17 18:06:04 2023-09-17T14:36:04.108722Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-09-17 18:06:04 2023-09-17T14:36:04.145317Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-09-17 18:06:04 2023-09-17T14:36:04.145533Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.

saeedvaziry Sep 17, 2023
Maintainer

have you tried to delete the containers and volumes and boot them up again?

mahemmati Sep 17, 2023
Author

That's what I exactly did!! removing containers, images and volumes ... Also tried on a fresh WSL2

saeedvaziry Sep 17, 2023
Maintainer

Could be an issue with the dockerfile. Like missing pdo mysql driver.
Feel free to open an issue. Will check soon

saeedvaziry · 2023-09-17T16:08:59Z

saeedvaziry
Sep 17, 2023
Maintainer

Try this env file and remove volumes and containers and then run ./sail up again

APP_NAME=Vito
APP_ENV=local
APP_KEY=base64:GhKqR4XmNosJnuv+Lu2Q4FRIk7GyOw15ipL9njlnnC8=
APP_DEBUG=true
APP_URL=http://vito.test

LOG_CHANNEL=stack
LOG_LEVEL=debug

DB_CONNECTION=mysql
DB_HOST=mysql
DB_PORT=3306
DB_DATABASE=vito
DB_USERNAME=sail
DB_PASSWORD=password

BROADCAST_DRIVER=null
CACHE_DRIVER=redis
FILESYSTEM_DRIVER=local
QUEUE_CONNECTION=default
SESSION_DRIVER=database
SESSION_LIFETIME=120

MEMCACHED_HOST=127.0.0.1

REDIS_HOST=redis
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_MAILER=smtp
MAIL_HOST=mailhog
MAIL_PORT=1025
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS=null
MAIL_FROM_NAME="${APP_NAME}"

SENTRY_LARAVEL_DSN=

APP_SERVICE=vito

FORWARD_REDIS_PORT=2060
FORWARD_DB_PORT=2070
APP_PORT=2080
HMR_PORT=2090

0 replies

saeedvaziry · 2023-09-17T16:25:59Z

saeedvaziry
Sep 17, 2023
Maintainer

Updated the documentation for sail and the env files in the root directory of the project.

1 reply

mahemmati Sep 18, 2023
Author

Succeeded, Issue resolved.

Suggestion 1. let APP_URL=http://localhost in .env.sail since custom URL demands hosts.file modification in windows machines
Suggestion 2. In https://vitodeploy.com/introduction/installation.html#laravel-sail you may remove the "Fill the .env file and then" sentence since further in the docs, user is instructed to generate the APP_KEY and other env defaults work out of the box. So this may results in confusions.
Question 1. Why not to let the app port to be the conventional 80 out of the box?

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Problem installing vito locally on Windows and Sail #51

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 3 comments 9 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

Problem installing vito locally on Windows and Sail #51

mahemmati Sep 17, 2023

Replies: 3 comments · 9 replies

saeedvaziry Sep 17, 2023 Maintainer

saeedvaziry Sep 17, 2023 Maintainer

mahemmati Sep 17, 2023 Author

saeedvaziry Sep 17, 2023 Maintainer

mahemmati Sep 17, 2023 Author

saeedvaziry Sep 17, 2023 Maintainer

saeedvaziry Sep 17, 2023 Maintainer

saeedvaziry Sep 17, 2023 Maintainer

mahemmati Sep 18, 2023 Author

mahemmati
Sep 17, 2023

Replies: 3 comments 9 replies

saeedvaziry
Sep 17, 2023
Maintainer

saeedvaziry Sep 17, 2023
Maintainer

mahemmati Sep 17, 2023
Author

saeedvaziry Sep 17, 2023
Maintainer

mahemmati Sep 17, 2023
Author

saeedvaziry Sep 17, 2023
Maintainer

saeedvaziry
Sep 17, 2023
Maintainer

saeedvaziry
Sep 17, 2023
Maintainer

mahemmati Sep 18, 2023
Author