Open alfureu opened 5 days ago
simjanos-dev
commented
5 days ago Will take a look at this later when I have time. Did it happen after you updated?
Deleting linguacafe/storage/app/model folder may fix this issue (you will have to install your languages again).
alfureu
commented
5 days ago Thanks @simjanos-dev
It was a fresh install, and I do not have the said model folder:
simjanos-dev
commented
5 days ago The problem is with the python container or folder permissions. Can you please copy the python logs as well?
alfureu
commented
5 days ago This is all I see:
Bottle v0.12.25 server starting up (using WSGIRefServer())...
Listening on http://0.0.0.0:8678/
Hit Ctrl-C to quit.
Bottle v0.12.25 server starting up (using WSGIRefServer())...
Listening on http://0.0.0.0:8678/
Hit Ctrl-C to quit.Can you please copy your storage/logs/laravel.log file here?
alfureu
commented
5 days ago [2024-06-28 09:13:18] local.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = linguacafe and table_name = migrations and table_type = 'BASE TABLE') {"exception":"[object] (Illuminate\\Datab>[stacktrace] #0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(784): Illuminate\\Database\\Connection->runQueryCallback('select * from i...', Array, Object(Closure))
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(763): Illuminate\\Database\\Connection->tryAgainIfCausedByLostConnection(Object(Illuminate\\Database\\QueryException), 'select * from i...', Array, Object(Closure))
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(674): Illuminate\\Database\\Connection->handleQueryException(Object(Illuminate\\Database\\QueryException), 'select * from i...', Array, Object(Closure))
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(359): Illuminate\\Database\\Connection->run('select * from i...', Array, Object(Closure))
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(43): Illuminate\\Database\\Connection->select('select * from i...', Array)
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php(169): Illuminate\\Database\\Schema\\MySqlBuilder->hasTable('migrations')
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(673): Illuminate\\Database\\Migrations\\DatabaseMigrationRepository->repositoryExists()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\\Database\\Migrations\\Migrator->repositoryExists()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(78): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->prepareDatabase()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(606): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(77): Illuminate\\Database\\Migrations\\Migrator->usingConnection(NULL, Object(Closure))
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)
#17 /var/www/html/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(120): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#19 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#20 /var/www/html/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\>#21 /var/www/html/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#24 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#25 {main}
[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(70): PDO->__construct('mysql:host=ling...', 'linguacafe', Object(SensitiveParameterValue), Array)
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(100): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=ling...', 'linguacafe', 'linguacafe', Array)
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(49): Illuminate\\Database\\Connectors\\Connector->tryAgainIfCausedByLostConnection(Object(PDOException), 'mysql:host=ling...', 'linguacafe', 'linguacafe', Array)
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=ling...', Array, Array)
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)
#5 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1064): call_user_func(Object(Closure))
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1100): Illuminate\\Database\\Connection->getPdo()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(442): Illuminate\\Database\\Connection->getReadPdo()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): Illuminate\\Database\\Connection->getPdoForSelect(true)
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select * from i...', Array)
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(784): Illuminate\\Database\\Connection->runQueryCallback('select * from i...', Array, Object(Closure))
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(763): Illuminate\\Database\\Connection->tryAgainIfCausedByLostConnection(Object(Illuminate\\Database\\QueryException), 'select * from i...', Array, Object(Closure))
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(674): Illuminate\\Database\\Connection->handleQueryException(Object(Illuminate\\Database\\QueryException), 'select * from i...', Array, Object(Closure))
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(359): Illuminate\\Database\\Connection->run('select * from i...', Array, Object(Closure))
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(43): Illuminate\\Database\\Connection->select('select * from i...', Array)
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php(169): Illuminate\\Database\\Schema\\MySqlBuilder->hasTable('migrations')
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(673): Illuminate\\Database\\Migrations\\DatabaseMigrationRepository->repositoryExists()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\\Database\\Migrations\\Migrator->repositoryExists()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(78): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->prepareDatabase()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(606): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(77): Illuminate\\Database\\Migrations\\Migrator->usingConnection(NULL, Object(Closure))
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)
#28 /var/www/html/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(120): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#30 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#31 /var/www/html/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\>#32 /var/www/html/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#34 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#35 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#36 {main}
"}I suspect this might be some uid/gid issues, no? wouldn't it be better to have them set as environment variables for the docker-compose file?
simjanos-dev
commented
5 days ago For some reason it cannot connect to the databese, or something went wrong with the migration. Havent seen this issue before.
Since its a fresh install, what if you stop linguacafe, delete the database docker volume, and start it again?
simjanos-dev
commented
5 days ago I suspect this might be some uid/gid issues, no?
I said it might be a permission issue, because this type of problem usually happens if the python service does not work correctly, which happened either due to permissions, or some python related problems with the storage/app/model folder where the language models are installed.
But based on your docker logs, the python service works without any issues.
alfureu
commented
5 days ago Same issue:
alfur@XXX:/volume1/Docker/linguacafe $ docker-compose up
[+] Running 3/2
✔ Container linguacafe-py Created 0.1s
✔ Container linguacafe_db Created 0.1s
✔ Container linguacafe_webserver Created 0.1s
Attaching to linguacafe-py, linguacafe_db, linguacafe_webserver
linguacafe_db | 2024-06-28 20:15:07+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.37-1.el9 started.
linguacafe_db | 2024-06-28 20:15:08+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
linguacafe_db | 2024-06-28 20:15:08+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.37-1.el9 started.
linguacafe_db | 2024-06-28 20:15:08+00:00 [Note] [Entrypoint]: Initializing database files
linguacafe_db | 2024-06-28T20:15:08.403195Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
linguacafe_db | 2024-06-28T20:15:08.403215Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
linguacafe_db | 2024-06-28T20:15:08.405800Z 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.
linguacafe_db | 2024-06-28T20:15:08.406032Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.37) initializing of server in progress as process 81
linguacafe_db | 2024-06-28T20:15:08.418430Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
linguacafe_db | 2024-06-28T20:15:10.566185Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
linguacafe-py | Bottle v0.12.25 server starting up (using WSGIRefServer())...
linguacafe-py | Listening on http://0.0.0.0:8678/
linguacafe-py | Hit Ctrl-C to quit.
linguacafe-py |
linguacafe_db | 2024-06-28T20:15:15.505684Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
linguacafe_db | 2024-06-28 20:15:26+00:00 [Note] [Entrypoint]: Database files initialized
linguacafe_db | 2024-06-28 20:15:26+00:00 [Note] [Entrypoint]: Starting temporary server
linguacafe_db | mysqld will log errors to /var/lib/mysql/bb32094e5b71.err
linguacafe_db | mysqld is running as pid 133
linguacafe_db | 2024-06-28 20:15:27+00:00 [Note] [Entrypoint]: Temporary server started.
linguacafe_db | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
linguacafe_db | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
linguacafe_db | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
linguacafe_db | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
linguacafe_db | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
linguacafe_db | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
linguacafe_db | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
linguacafe_db | 2024-06-28 20:15:31+00:00 [Note] [Entrypoint]: Creating database linguacafe
linguacafe_db | 2024-06-28 20:15:31+00:00 [Note] [Entrypoint]: Creating user linguacafe
linguacafe_db | 2024-06-28 20:15:31+00:00 [Note] [Entrypoint]: Giving user linguacafe access to schema linguacafe
linguacafe_db |
linguacafe_db | 2024-06-28 20:15:31+00:00 [Note] [Entrypoint]: Stopping temporary server
linguacafe_db | 2024-06-28 20:15:38+00:00 [Note] [Entrypoint]: Temporary server stopped
linguacafe_db |
linguacafe_db | 2024-06-28 20:15:38+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
linguacafe_db |
linguacafe_db | 2024-06-28T20:15:38.611167Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
linguacafe_db | 2024-06-28T20:15:38.611183Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
linguacafe_db | 2024-06-28T20:15:38.852281Z 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.
linguacafe_db | 2024-06-28T20:15:38.854740Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37) starting as process 1
linguacafe_db | 2024-06-28T20:15:39.015765Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
linguacafe_db | 2024-06-28T20:15:39.579482Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
linguacafe_db | 2024-06-28T20:15:39.910799Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
linguacafe_db | 2024-06-28T20:15:39.910856Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
linguacafe_db | 2024-06-28T20:15:39.916789Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
linguacafe_db | 2024-06-28T20:15:39.945353Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
linguacafe_db | 2024-06-28T20:15:39.945591Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.37' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied
linguacafe_webserver | Folder created: ./storage/app/dictionaries
linguacafe_webserver | Folder created: ./storage/app/fonts
linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied
linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied
linguacafe_webserver | Folder created: ./storage/app/images/book_images
linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied
linguacafe_webserver | Folder created: ./storage/app/public
linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied
linguacafe_webserver | Folder created: ./storage/app/temp/dictionaries
linguacafe_webserver | mkdir: cannot create directory './storage/framework': Permission denied
linguacafe_webserver | Folder created: ./storage/framework/cache/data
linguacafe_webserver | mkdir: cannot create directory './storage/framework': Permission denied
linguacafe_webserver | Folder created: ./storage/framework/sessions
linguacafe_webserver | mkdir: cannot create directory './storage/framework': Permission denied
linguacafe_webserver | Folder created: ./storage/framework/testing
linguacafe_webserver | Folder created: ./storage/framework/views
linguacafe_webserver | mkdir: cannot create directory './storage/framework': Permission denied
linguacafe_webserver | mkdir: cannot create directory './storage/logs': Permission denied
linguacafe_webserver | Folder created: ./storage/logs
linguacafe_webserver | Migration table created successfully.
linguacafe_webserver | Migrating: 2014_10_12_000000_create_users_table
linguacafe_webserver | Migrated: 2014_10_12_000000_create_users_table (241.45ms)
linguacafe_webserver | Migrating: 2014_10_12_100000_create_password_resets_table
linguacafe_webserver | Migrated: 2014_10_12_100000_create_password_resets_table (139.38ms)
linguacafe_webserver | Migrating: 2019_08_19_000000_create_failed_jobs_table
linguacafe_webserver | Migrated: 2019_08_19_000000_create_failed_jobs_table (63.98ms)
linguacafe_webserver | Migrating: 2021_08_12_122344_create_encountered_words_table
linguacafe_webserver | Migrated: 2021_08_12_122344_create_encountered_words_table (48.76ms)
linguacafe_webserver | Migrating: 2021_08_12_190128_create_lessons_table
linguacafe_webserver | Migrated: 2021_08_12_190128_create_lessons_table (53.10ms)
linguacafe_webserver | Migrating: 2021_08_12_224441_create_courses_table
linguacafe_webserver | Migrated: 2021_08_12_224441_create_courses_table (28.16ms)
linguacafe_webserver | Migrating: 2021_08_15_202138_create_daily_read_words_table
linguacafe_webserver | Migrated: 2021_08_15_202138_create_daily_read_words_table (59.77ms)
linguacafe_webserver | Migrating: 2021_08_26_204900_create_sentences_table
linguacafe_webserver | Migrated: 2021_08_26_204900_create_sentences_table (28.00ms)
linguacafe_webserver | Migrating: 2021_08_26_220126_create_sentence_collections_table
linguacafe_webserver | Migrated: 2021_08_26_220126_create_sentence_collections_table (30.16ms)
linguacafe_webserver | Migrating: 2021_08_31_211300_modify_daily_read_words
linguacafe_webserver | Migrated: 2021_08_31_211300_modify_daily_read_words (162.24ms)
linguacafe_webserver | Migrating: 2021_11_19_170554_modify_users_table
linguacafe_webserver | Migrated: 2021_11_19_170554_modify_users_table (24.96ms)
linguacafe_webserver | Migrating: 2021_11_21_192040_modify_encountered_words_table
linguacafe_webserver | Migrated: 2021_11_21_192040_modify_encountered_words_table (29.52ms)
linguacafe_webserver | Migrating: 2021_11_23_102115_modify_lessons_table
linguacafe_webserver | Migrated: 2021_11_23_102115_modify_lessons_table (25.71ms)
linguacafe_webserver | Migrating: 2021_11_29_120834_modify_sentences_table
linguacafe_webserver | Migrated: 2021_11_29_120834_modify_sentences_table (146.27ms)
linguacafe_webserver | Migrating: 2021_11_29_121028_modify_sentence_collections_table
linguacafe_webserver | Migrated: 2021_11_29_121028_modify_sentence_collections_table (39.47ms)
linguacafe_webserver | Migrating: 2022_03_27_000631_modify_encountered_words_table_2
linguacafe_webserver | Migrated: 2022_03_27_000631_modify_encountered_words_table_2 (19.05ms)
linguacafe_webserver | Migrating: 2022_04_19_093156_modify_encountered_words_table_3
linguacafe_webserver | Migrated: 2022_04_19_093156_modify_encountered_words_table_3 (56.25ms)
linguacafe_webserver | Migrating: 2022_04_20_143750_modify_daily_achivements_table
linguacafe_webserver | Migrated: 2022_04_20_143750_modify_daily_achivements_table (38.53ms)
linguacafe_webserver | Migrating: 2022_04_21_073315_modify_lessons_table_2
linguacafe_webserver | Migrated: 2022_04_21_073315_modify_lessons_table_2 (27.02ms)
linguacafe_webserver | Migrating: 2022_04_21_083651_modify_courses_table
linguacafe_webserver | Migrated: 2022_04_21_083651_modify_courses_table (22.18ms)
linguacafe_webserver | Migrating: 2022_08_08_141517_create_phrases_table
linguacafe_webserver | Migrated: 2022_08_08_141517_create_phrases_table (25.53ms)
linguacafe_webserver | Migrating: 2022_08_08_195931_modify_lessons_table_3
linguacafe_webserver | Migrated: 2022_08_08_195931_modify_lessons_table_3 (229.59ms)
linguacafe_webserver | Migrating: 2022_09_22_093049_modify_encountered_words_table_4
linguacafe_webserver | Migrated: 2022_09_22_093049_modify_encountered_words_table_4 (81.96ms)
linguacafe_webserver | Migrating: 2022_09_22_110938_modify_lessons_table_4
linguacafe_webserver | Migrated: 2022_09_22_110938_modify_lessons_table_4 (148.33ms)
linguacafe_webserver | Migrating: 2022_09_22_145039_modify_courses_table_2
linguacafe_webserver | Migrated: 2022_09_22_145039_modify_courses_table_2 (87.78ms)
linguacafe_webserver | Migrating: 2022_10_16_224918_modify_encountered_words_table_5
linguacafe_webserver | Migrated: 2022_10_16_224918_modify_encountered_words_table_5 (28.34ms)
linguacafe_webserver | Migrating: 2022_10_17_173958_create_dictionary_table
linguacafe_webserver | Migrated: 2022_10_17_173958_create_dictionary_table (195.53ms)
linguacafe_webserver | Migrating: 2022_10_26_120324_modify_flash_card_collections_table
linguacafe_webserver | Migrated: 2022_10_26_120324_modify_flash_card_collections_table (36.86ms)
linguacafe_webserver | Migrating: 2022_10_26_161222_modify_courses_table_3
linguacafe_webserver | Migrated: 2022_10_26_161222_modify_courses_table_3 (21.66ms)
linguacafe_webserver | Migrating: 2022_10_26_161249_modify_lessons_table_5
linguacafe_webserver | Migrated: 2022_10_26_161249_modify_lessons_table_5 (42.32ms)
linguacafe_webserver | Migrating: 2022_10_27_110219_modify_phrases_table
linguacafe_webserver | Migrated: 2022_10_27_110219_modify_phrases_table (30.55ms)
linguacafe_webserver | Migrating: 2022_11_13_175608_create_kanji_dictionary_table
linguacafe_webserver | Migrated: 2022_11_13_175608_create_kanji_dictionary_table (52.87ms)
linguacafe_webserver | Migrating: 2022_11_19_143628_create_kanji_radicals_dictionary_table
linguacafe_webserver | Migrated: 2022_11_19_143628_create_kanji_radicals_dictionary_table (49.18ms)
linguacafe_webserver | Migrating: 2022_11_24_231401_modify_encountered_words_table_6
linguacafe_webserver | Migrated: 2022_11_24_231401_modify_encountered_words_table_6 (48.90ms)
linguacafe_webserver | Migrating: 2022_11_25_050008_modify_phrases_table_2
linguacafe_webserver | Migrated: 2022_11_25_050008_modify_phrases_table_2 (89.51ms)
linguacafe_webserver | Migrating: 2023_01_04_104425_create_goals_table
linguacafe_webserver | Migrated: 2023_01_04_104425_create_goals_table (32.16ms)
linguacafe_webserver | Migrating: 2023_01_04_151157_create_goal_achievements_table
linguacafe_webserver | Migrated: 2023_01_04_151157_create_goal_achievements_table (79.72ms)
linguacafe_webserver | Migrating: 2023_07_12_154142_create_lesson_words_table
linguacafe_webserver | Migrated: 2023_07_12_154142_create_lesson_words_table (196.71ms)
linguacafe_webserver | Migrating: 2023_07_12_231056_modify_lessons_table_6
linguacafe_webserver | Migrated: 2023_07_12_231056_modify_lessons_table_6 (39.10ms)
linguacafe_webserver | Migrating: 2023_07_15_150342_create_example_sentences_table
linguacafe_webserver | Migrated: 2023_07_15_150342_create_example_sentences_table (32.69ms)
linguacafe_webserver | Migrating: 2023_10_04_142329_create_media_player_caches_table
linguacafe_webserver | Migrated: 2023_10_04_142329_create_media_player_caches_table (52.16ms)
linguacafe_webserver | Migrating: 2023_10_24_203916_rename_dictionary_tables
linguacafe_webserver | Migrated: 2023_10_24_203916_rename_dictionary_tables (258.96ms)
linguacafe_webserver | Migrating: 2023_10_24_230927_create_dictionaries_table
linguacafe_webserver | Migrated: 2023_10_24_230927_create_dictionaries_table (43.79ms)
linguacafe_webserver | Migrating: 2023_10_30_135730_modify_jmdict_table
linguacafe_webserver | Migrated: 2023_10_30_135730_modify_jmdict_table (193.97ms)
linguacafe_webserver | Migrating: 2023_10_31_133948_create_deepl_caches_table
linguacafe_webserver | Migrated: 2023_10_31_133948_create_deepl_caches_table (27.90ms)
linguacafe_webserver | Migrating: 2023_10_31_161411_create_settings_table
linguacafe_webserver | Migrated: 2023_10_31_161411_create_settings_table (26.75ms)
linguacafe_webserver | Migrating: 2023_11_01_224016_modify_users_table_2
linguacafe_webserver | Migrated: 2023_11_01_224016_modify_users_table_2 (22.63ms)
linguacafe_webserver | Migrating: 2023_11_19_011027_modify_lessons_table_7
linguacafe_webserver | Migrated: 2023_11_19_011027_modify_lessons_table_7 (50.28ms)
linguacafe_webserver | Migrating: 2023_11_19_011052_delete_lesson_words_table
linguacafe_webserver | Migrated: 2023_11_19_011052_delete_lesson_words_table (16.44ms)
linguacafe_webserver | Migrating: 2023_12_30_180040_modify_phrases_table_3
linguacafe_webserver | Migrated: 2023_12_30_180040_modify_phrases_table_3 (26.66ms)
linguacafe_webserver | Migrating: 2024_02_02_095635_modify_lessons_table_8
linguacafe_webserver | Migrated: 2024_02_02_095635_modify_lessons_table_8 (23.15ms)
linguacafe_webserver | Migrating: 2024_03_23_180915_modify_dictionaries_table
linguacafe_webserver | Migrated: 2024_03_23_180915_modify_dictionaries_table (93.26ms)
linguacafe_webserver | Migrating: 2024_03_23_182401_modify_deepl_caches_table
linguacafe_webserver | Migrated: 2024_03_23_182401_modify_deepl_caches_table (44.16ms)
linguacafe_webserver | Migrating: 2024_04_21_201440_reset_selected_language
linguacafe_webserver | Migrated: 2024_04_21_201440_reset_selected_language (3.74ms)
linguacafe_webserver | Migrating: 2024_04_21_203540_modify_users_table_3
linguacafe_webserver | Migrated: 2024_04_21_203540_modify_users_table_3 (28.18ms)
linguacafe_webserver | Migrating: 2024_05_04_073049_create_font_types_table
linguacafe_webserver | Migrated: 2024_05_04_073049_create_font_types_table (26.66ms)
linguacafe_webserver | Migrating: 2024_05_25_142502_modify_dictionaries_table_2
linguacafe_webserver | Migrated: 2024_05_25_142502_modify_dictionaries_table_2 (24.63ms)
linguacafe_webserver | Migrating: 2024_05_28_214957_rename_lessons_table
linguacafe_webserver | Migrated: 2024_05_28_214957_rename_lessons_table (31.08ms)
linguacafe_webserver | Migrating: 2024_05_29_004911_delete_media_player_caches_table
linguacafe_webserver | Migrated: 2024_05_29_004911_delete_media_player_caches_table (16.10ms)
linguacafe_webserver | Migrating: 2024_05_29_194006_modify_encountered_words_table_7
linguacafe_webserver | Migrated: 2024_05_29_194006_modify_encountered_words_table_7 (26.07ms)
linguacafe_webserver | Migrating: 2024_05_29_232455_delete_flashcard_tables
linguacafe_webserver | Migrated: 2024_05_29_232455_delete_flashcard_tables (31.75ms)
linguacafe_webserver | Seeding: Database\Seeders\SettingsSeeder
linguacafe_webserver | Seeded: Database\Seeders\SettingsSeeder (81.85ms)
linguacafe_webserver | Seeding: Database\Seeders\DictionarySeeder
linguacafe_webserver | Seeded: Database\Seeders\DictionarySeeder (4.83ms)
linguacafe_webserver | Seeding: Database\Seeders\FontTypeSeeder
linguacafe_webserver | Seeded: Database\Seeders\FontTypeSeeder (24.77ms)
linguacafe_webserver | Database seeding completed successfully.
linguacafe_webserver | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.53.0.4. Set the 'ServerName' directive globally to suppress this message
linguacafe_webserver | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.53.0.4. Set the 'ServerName' directive globally to suppress this message
linguacafe_webserver | [Fri Jun 28 20:15:53.744147 2024] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.59 (Debian) PHP/8.2.20 configured -- resuming normal operations
linguacafe_webserver | [Fri Jun 28 20:15:53.744207 2024] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
linguacafe_webserver | 10.0.10.4 - - [28/Jun/2024:20:16:10 +0000] "GET / HTTP/1.1" 500 112269 "-" "Mozilla/5.0 (Windows NT 10.0; rv:127.0) Gecko/20100101 Firefox/127.0"This ends up in the following screen on the ip:9191
simjanos-dev
commented
5 days ago This is weird. You do have permission issues, just different than I thought. And this is a completely different error message than before.
What operating system do you use, and how did you set it up?
If you run it on linux, I would try shutting down the server, running: sudo chmod 777 ./linguacafe from the parent directory, deleting the volume again, and trying again.
(Changing permissions should not be required on linux systems.)
alfureu
commented
5 days ago I do not have permission issues, just my docker instances run under different uid/gid than the user, hence the suggestion above...
alfureu
commented
5 days ago If you run it on linux, I would try shutting down the server, running:
sudo chmod 777 ./linguacafefrom the parent directory, deleting the volume again, and trying again.
did this, same result
simjanos-dev
commented
5 days ago linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied linguacafe_webserver | Folder created: ./storage/app/dictionaries linguacafe_webserver | Folder created: ./storage/app/fonts linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied linguacafe_webserver | Folder created: ./storage/app/images/book_images linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied linguacafe_webserver | Folder created: ./storage/app/public linguacafe_webserver | mkdir: cannot create directory './storage/app': Permission denied linguacafe_webserver | Folder created: ./storage/app/temp/dictionaries linguacafe_webserver | mkdir: cannot create directory './storage/framework': Permission denied linguacafe_webserver | Folder created: ./storage/framework/cache/data linguacafe_webserver | mkdir: cannot create directory './storage/framework': Permission denied linguacafe_webserver | Folder created: ./storage/framework/sessions linguacafe_webserver | mkdir: cannot create directory './storage/framework': Permission denied linguacafe_webserver | Folder created: ./storage/framework/testing linguacafe_webserver | Folder created: ./storage/framework/views linguacafe_webserver | mkdir: cannot create directory './storage/framework': Permission denied linguacafe_webserver | mkdir: cannot create directory './storage/logs': Permission denied linguacafe_webserver | Folder created: ./storage/logs
Sorry, I'm not very good at docker. I just used it to set up a basic install and update process with it, and since that sergiolaverde0 worked on all the improvements (which I am very thankful for).
@sergiolaverde0 Can you please help out with this issue?
alfureu
commented
5 days ago One more thing from the stack&trace:
UnexpectedValueException:
There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied
at /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php:219
at Monolog\Handler\StreamHandler->createDir('/var/www/html/storage/logs/laravel.log')
(/var/www/html/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php:135)
at Monolog\Handler\StreamHandler->write(array('message' => 'There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied', 'context' => array('exception' => object(UnexpectedValueException)), 'level' => 400, 'level_name' => 'ERROR', 'channel' => 'local', 'datetime' => object(DateTimeImmutable), 'extra' => array(), 'formatted' => '[2024-06-28 22:38:21] local.ERROR: There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied {"exception":"[object] (UnexpectedValueException(code: 0): There is no existing directory at \\"/var/www/html/storage/logs\\" and it could not be created: Permission denied at /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php:219)[stacktrace]#0 /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php(135): Monolog\\\\Handler\\\\StreamHandler->createDir(\'/var/www/html/s...\')#1 /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php(48): Monolog\\\\Handler\\\\StreamHandler->write(Array)#2 /var/www/html/vendor/monolog/monolog/src/Monolog/Logger.php(399): Monolog\\\\Handler\\\\AbstractProcessingHandler->handle(Array)#3 /var/www/html/vendor/monolog/monolog/src/Monolog/Logger.php(650): Monolog\\\\Logger->addRecord(400, \'There is no exi...\', Array)#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Log/Logger.php(181): Monolog\\\\Logger->error(\'There is no exi...\', Array)#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Log/Logger.php(94): Illuminate\\\\Log\\\\Logger->writeLog(\'error\', \'There is no exi...\', Array)#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Log/LogManager.php(590): Illuminate\\\\Log\\\\Logger->error(\'There is no exi...\', Array)#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Exceptions/Handler.php(247): Illuminate\\\\Log\\\\LogManager->error(\'There is no exi...\', Array)#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(415): Illuminate\\\\Foundation\\\\Exceptions\\\\Handler->report(Object(UnexpectedValueException))#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(113): Illuminate\\\\Foundation\\\\Http\\\\Kernel->reportException(Object(UnexpectedValueException))#10 /var/www/html/public/index.php(51): Illuminate\\\\Foundation\\\\Http\\\\Kernel->handle(Object(Illuminate\\\\Http\\\\Request))#11 {main}"} '))
(/var/www/html/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php:48)
at Monolog\Handler\AbstractProcessingHandler->handle(array('message' => 'There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied', 'context' => array('exception' => object(UnexpectedValueException)), 'level' => 400, 'level_name' => 'ERROR', 'channel' => 'local', 'datetime' => object(DateTimeImmutable), 'extra' => array(), 'formatted' => '[2024-06-28 22:38:21] local.ERROR: There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied {"exception":"[object] (UnexpectedValueException(code: 0): There is no existing directory at \\"/var/www/html/storage/logs\\" and it could not be created: Permission denied at /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php:219)[stacktrace]#0 /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php(135): Monolog\\\\Handler\\\\StreamHandler->createDir(\'/var/www/html/s...\')#1 /var/www/html/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php(48): Monolog\\\\Handler\\\\StreamHandler->write(Array)#2 /var/www/html/vendor/monolog/monolog/src/Monolog/Logger.php(399): Monolog\\\\Handler\\\\AbstractProcessingHandler->handle(Array)#3 /var/www/html/vendor/monolog/monolog/src/Monolog/Logger.php(650): Monolog\\\\Logger->addRecord(400, \'There is no exi...\', Array)#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Log/Logger.php(181): Monolog\\\\Logger->error(\'There is no exi...\', Array)#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Log/Logger.php(94): Illuminate\\\\Log\\\\Logger->writeLog(\'error\', \'There is no exi...\', Array)#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Log/LogManager.php(590): Illuminate\\\\Log\\\\Logger->error(\'There is no exi...\', Array)#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Exceptions/Handler.php(247): Illuminate\\\\Log\\\\LogManager->error(\'There is no exi...\', Array)#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(415): Illuminate\\\\Foundation\\\\Exceptions\\\\Handler->report(Object(UnexpectedValueException))#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(113): Illuminate\\\\Foundation\\\\Http\\\\Kernel->reportException(Object(UnexpectedValueException))#10 /var/www/html/public/index.php(51): Illuminate\\\\Foundation\\\\Http\\\\Kernel->handle(Object(Illuminate\\\\Http\\\\Request))#11 {main}"} '))
(/var/www/html/vendor/monolog/monolog/src/Monolog/Logger.php:399)
at Monolog\Logger->addRecord(400, 'There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied', array('exception' => object(UnexpectedValueException)))
(/var/www/html/vendor/monolog/monolog/src/Monolog/Logger.php:650)
at Monolog\Logger->error('There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied', array('exception' => object(UnexpectedValueException)))
(/var/www/html/vendor/laravel/framework/src/Illuminate/Log/Logger.php:181)
at Illuminate\Log\Logger->writeLog('error', 'There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied', array('exception' => object(UnexpectedValueException)))
(/var/www/html/vendor/laravel/framework/src/Illuminate/Log/Logger.php:94)
at Illuminate\Log\Logger->error('There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied', array('exception' => object(UnexpectedValueException)))
(/var/www/html/vendor/laravel/framework/src/Illuminate/Log/LogManager.php:590)
at Illuminate\Log\LogManager->error('There is no existing directory at "/var/www/html/storage/logs" and it could not be created: Permission denied', array('exception' => object(UnexpectedValueException)))
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Exceptions/Handler.php:247)
at Illuminate\Foundation\Exceptions\Handler->report(object(UnexpectedValueException))
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php:165)
at Illuminate\Foundation\Bootstrap\HandleExceptions->handleException(object(UnexpectedValueException)) obviously your script cannot create the folders/files for some reason...
simjanos-dev
commented
5 days ago Did you create an empty storage directory next to the docker-compose.yml file? Read it again, you did.
sergiolaverde0
commented
5 days ago I suspect this might be some uid/gid issues, no? wouldn't it be better to have them set as environment variables for the docker-compose file?
Probably, but we also want to be as ready-to-go as possible since many of our users are not very tech savvy and unfamiliar with docker. Our users are language learners, and only a few are recurrent selfhosters .
Does it work for you if you add PUID and GUID to the environment section of both containers and set them to the right values?
Edit:
If you run it on linux, I would try shutting down the server, running: sudo chmod 777 ./linguacafe from the parent directory, deleting the volume again, and trying again.
I think it might work by deleting the storage folder, recreating it and running chmod 777 -R ./storage from the linguacafe directory before starting the containers. But that's not a nice solution.
simjanos-dev
commented
1 day ago Someone has the same issue as this, I asked him to comment it here. I would need a lot of time to figure it out. I don't think anything permission/docker related changed in the last update. We have hundreds of downloads, and these 2 are the only errors I know of.
@alfureu What distro do you use?
I'll try to test it when I'll have the time.
simjanos-dev
commented
1 day ago He cannot login to github. Here are his logs. He is using arch linux. It is a fresh install, but did use it before without any issues on the same distro.
2024-07-02 21:49:06 linguacafe-python-service | Bottle v0.12.25 server starting up (using WSGIRefServer())...
2024-07-02 21:49:06 linguacafe-python-service | Listening on http://0.0.0.0:8678/
2024-07-02 21:49:06 linguacafe-python-service | Hit Ctrl-C to quit.
2024-07-02 21:49:06 linguacafe-python-service |
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/app': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/app/dictionaries
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/app': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/app/fonts
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/app': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/app/images/book_images
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/app': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/app/public
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/app': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/app/temp/dictionaries
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/framework': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/framework/cache/data
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/framework': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/framework/sessions
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/framework': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/framework/testing
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/framework': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/framework/views
2024-07-02 21:49:23 linguacafe-webserver | mkdir: cannot create directory './storage/logs': Permission denied
2024-07-02 21:49:23 linguacafe-webserver | Folder created: ./storage/logs
2024-07-02 21:49:24 linguacafe-webserver |
2024-07-02 21:49:24 linguacafe-webserver | In StreamHandler.php line 219:
2024-07-02 21:49:24 linguacafe-webserver |
2024-07-02 21:49:24 linguacafe-webserver | There is no existing directory at "/var/www/html/storage/logs" and it could
2024-07-02 21:49:24 linguacafe-webserver | not be created: Permission denied
2024-07-02 21:49:24 linguacafe-webserver |
2024-07-02 21:49:24 linguacafe-webserver |
2024-07-02 21:49:24 linguacafe-webserver | Seeding: Database\Seeders\SettingsSeeder
2024-07-02 21:49:24 linguacafe-webserver |
2024-07-02 21:49:24 linguacafe-webserver | In StreamHandler.php line 219:
2024-07-02 21:49:24 linguacafe-webserver |
2024-07-02 21:49:24 linguacafe-webserver | There is no existing directory at "/var/www/html/storage/logs" and it could
2024-07-02 21:49:24 linguacafe-webserver | not be created: Permission denied
2024-07-02 21:49:24 linguacafe-webserver |
2024-07-02 21:49:24 linguacafe-webserver |
2024-07-02 21:49:25 linguacafe-webserver | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.4. Set the 'ServerName' directive globally to suppress this message
2024-07-02 21:49:25 linguacafe-webserver | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.4. Set the 'ServerName' directive globally to suppress this message
2024-07-02 21:49:25 linguacafe-webserver | [Tue Jul 02 19:49:25.105152 2024] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.59 (Debian) PHP/8.2.20 configured -- resuming normal operations
2024-07-02 21:49:25 linguacafe-webserver | [Tue Jul 02 19:49:25.105204 2024] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
2024-07-02 21:49:44 linguacafe-webserver | 172.18.0.1 - - [02/Jul/2024:19:49:44 +0000] "GET / HTTP/1.1" 500 112269 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
2024-07-02 21:49:45 linguacafe-webserver | 172.18.0.1 - - [02/Jul/2024:19:49:45 +0000] "GET / HTTP/1.1" 500 112269 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
2024-07-02 21:49:50 linguacafe-webserver | 172.18.0.1 - - [02/Jul/2024:19:49:50 +0000] "GET / HTTP/1.1" 500 112269 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
2024-07-02 21:51:32 linguacafe-webserver | 172.18.0.1 - - [02/Jul/2024:19:51:31 +0000] "GET / HTTP/1.1" 500 112269 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
2024-07-02 21:51:32 linguacafe-webserver | 172.18.0.1 - - [02/Jul/2024:19:51:32 +0000] "GET / HTTP/1.1" 500 112269 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
2024-07-02 21:51:33 linguacafe-webserver | 172.18.0.1 - - [02/Jul/2024:19:51:33 +0000] "GET / HTTP/1.1" 500 112269 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
2024-07-02 21:52:26 linguacafe-webserver | 172.18.0.1 - - [02/Jul/2024:19:52:26 +0000] "GET / HTTP/1.1" 500 112269 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0"
2024-07-02 21:49:03 linguacafe-database | 2024-07-02 19:49:03+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.37-1.el9 started.
2024-07-02 21:49:03 linguacafe-database | 2024-07-02 19:49:03+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-07-02 21:49:03 linguacafe-database | 2024-07-02 19:49:03+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.37-1.el9 started.
2024-07-02 21:49:03 linguacafe-database | 2024-07-02 19:49:03+00:00 [Note] [Entrypoint]: Initializing database files
2024-07-02 21:49:03 linguacafe-database | 2024-07-02T19:49:03.797234Z 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.
2024-07-02 21:49:03 linguacafe-database | 2024-07-02T19:49:03.797944Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.37) initializing of server in progress as process 81
2024-07-02 21:49:03 linguacafe-database | 2024-07-02T19:49:03.820117Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-02 21:49:05 linguacafe-database | 2024-07-02T19:49:05.416718Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-02 21:49:08 linguacafe-database | 2024-07-02T19:49:08.535127Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2024-07-02 21:49:19 linguacafe-database | 2024-07-02 19:49:19+00:00 [Note] [Entrypoint]: Database files initialized
2024-07-02 21:49:19 linguacafe-database | 2024-07-02 19:49:19+00:00 [Note] [Entrypoint]: Starting temporary server
2024-07-02 21:49:19 linguacafe-database | mysqld will log errors to /var/lib/mysql/bbe3145d3d1b.err
2024-07-02 21:49:20 linguacafe-database | mysqld is running as pid 133
2024-07-02 21:49:20 linguacafe-database | 2024-07-02 19:49:20+00:00 [Note] [Entrypoint]: Temporary server started.
2024-07-02 21:49:20 linguacafe-database | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-07-02 21:49:22 linguacafe-database | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
2024-07-02 21:49:22 linguacafe-database | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
2024-07-02 21:49:22 linguacafe-database | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
2024-07-02 21:49:28 linguacafe-database | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
2024-07-02 21:49:28 linguacafe-database | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
2024-07-02 21:49:28 linguacafe-database | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2024-07-02 21:49:28 linguacafe-database | 2024-07-02 19:49:28+00:00 [Note] [Entrypoint]: Creating database linguacafe
2024-07-02 21:49:28 linguacafe-database | 2024-07-02 19:49:28+00:00 [Note] [Entrypoint]: Creating user linguacafe
2024-07-02 21:49:28 linguacafe-database | 2024-07-02 19:49:28+00:00 [Note] [Entrypoint]: Giving user linguacafe access to schema linguacafe
2024-07-02 21:49:28 linguacafe-database |
2024-07-02 21:49:28 linguacafe-database | 2024-07-02 19:49:28+00:00 [Note] [Entrypoint]: Stopping temporary server
2024-07-02 21:49:32 linguacafe-database | 2024-07-02 19:49:32+00:00 [Note] [Entrypoint]: Temporary server stopped
2024-07-02 21:49:32 linguacafe-database |
2024-07-02 21:49:32 linguacafe-database | 2024-07-02 19:49:32+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
2024-07-02 21:49:32 linguacafe-database |
2024-07-02 21:49:32 linguacafe-database | 2024-07-02T19:49:32.205445Z 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.
2024-07-02 21:49:32 linguacafe-database | 2024-07-02T19:49:32.208006Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37) starting as process 1
2024-07-02 21:49:32 linguacafe-database | 2024-07-02T19:49:32.222799Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-02 21:49:32 linguacafe-database | 2024-07-02T19:49:32.389354Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-02 21:49:32 linguacafe-database | 2024-07-02T19:49:32.619523Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-07-02 21:49:32 linguacafe-database | 2024-07-02T19:49:32.619618Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-07-02 21:49:32 linguacafe-database | 2024-07-02T19:49:32.625893Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-07-02 21:49:32 linguacafe-database | 2024-07-02T19:49:32.651101Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-07-02 21:49:32 linguacafe-database | 2024-07-02T19:49:32.651173Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.37' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
I wonder how many versions ago was "before".
I assume they did create the storage folder before starting the container for the first time, since that requirement is fairly recent and is needed to have the process run as non-root. If they didn't, docker automatically created one with root ownership, and it must be deleted and recreated manually (or chown-ed) to have the right permissions.
Have them run this commands from inside their linguacafe folder: ls -lR. Output should look like this:
.:
total 4
drwxr-xr-x 1 999 root 660 jun 11 18:32 database
-rw-r--r-- 1 desktop desktop 1746 jun 11 17:29 docker-compose.yml
drwxr-xr-x 1 desktop desktop 32 jun 11 17:36 storage
./database:
total 101424
-rw-r----- 1 999 999 1579 jun 11 17:36 618efadd5f3b.err
-rw-r----- 1 999 999 56 jun 11 17:36 auto.cnf
-rw-r----- 1 999 999 2943842 jun 11 17:36 binlog.000001
-rw-r----- 1 999 999 64399 jun 11 18:32 binlog.000002
-rw-r----- 1 999 999 32 jun 11 17:36 binlog.index
-rw------- 1 999 999 1705 jun 11 17:36 ca-key.pem
-rw-r--r-- 1 999 999 1112 jun 11 17:36 ca.pem
-rw-r--r-- 1 999 999 1112 jun 11 17:36 client-cert.pem
-rw------- 1 999 999 1705 jun 11 17:36 client-key.pem
-rw-r----- 1 999 999 13361934 jun 11 17:37 general-log.log
-rw-r----- 1 999 999 196608 jun 11 17:38 '#ib_16384_0.dblwr'
-rw-r----- 1 999 999 8585216 jun 11 17:36 '#ib_16384_1.dblwr'
-rw-r----- 1 999 999 5198 jun 11 18:32 ib_buffer_pool
-rw-r----- 1 999 999 12582912 jun 11 18:32 ibdata1
drwxr-x--- 1 999 999 888 jun 11 18:32 '#innodb_redo'
drwxr-x--- 1 999 999 0 jun 11 18:32 '#innodb_temp'
drwxr-x--- 1 999 999 704 jun 11 17:36 linguacafe
drwxr-x--- 1 999 999 178 jun 11 17:36 mysql
-rw-r----- 1 999 999 32505856 jun 11 17:37 mysql.ibd
lrwxrwxrwx 1 999 999 27 jun 11 17:36 mysql.sock -> /var/run/mysqld/mysqld.sock
drwxr-x--- 1 999 999 5032 jun 11 17:36 performance_schema
-rw------- 1 999 999 1705 jun 11 17:36 private_key.pem
-rw-r--r-- 1 999 999 452 jun 11 17:36 public_key.pem
-rw-r--r-- 1 999 999 1112 jun 11 17:36 server-cert.pem
-rw------- 1 999 999 1705 jun 11 17:36 server-key.pem
drwxr-x--- 1 999 999 28 jun 11 17:36 sys
-rw-r----- 1 999 999 16777216 jun 11 17:38 undo_001
-rw-r----- 1 999 999 16777216 jun 11 17:38 undo_002
ls: cannot open directory './database/#innodb_redo': Permission denied
ls: cannot open directory './database/#innodb_temp': Permission denied
ls: cannot open directory './database/linguacafe': Permission denied
ls: cannot open directory './database/mysql': Permission denied
ls: cannot open directory './database/performance_schema': Permission denied
ls: cannot open directory './database/sys': Permission denied
./storage:
total 0
drwxr-xr-x 1 desktop desktop 66 jun 11 17:36 app
drwxr-xr-x 1 desktop desktop 50 jun 11 17:36 framework
drwxr-xr-x 1 desktop desktop 22 jun 11 17:36 logs
./storage/app:
total 0
drwxr-xr-x 1 desktop desktop 0 jun 11 17:36 dictionaries
drwxr-xr-x 1 desktop desktop 0 jun 11 17:36 fonts
drwxr-xr-x 1 desktop desktop 22 jun 11 17:36 images
drwxr-xr-x 1 desktop desktop 0 jun 11 17:36 public
drwxr-xr-x 1 desktop desktop 24 jun 11 17:36 tempHe used the latest version. He forgot to create the storage directory, ran docker system prune after stopping the containers, and installed it again after creating the storage directory. Same error.
simjanos-dev
commented
1 day ago He ran the command.
oben@oben-pc ~/Linguacafe> ls -lR (base)
.:
total 272616
drwxr-xr-x 8 100998 oben 4096 2. Jul 21:49 database/
-rw-r--r-- 1 oben oben 2082 2. Jul 21:48 docker-compose.yml
-rwxrwxr-x 1 oben oben 279141282 2. Jul 20:44 linguacafe-backup.sql*
drwxr-xr-x 2 oben oben 4096 2. Jul 21:44 storage/
./database:
total 113616
-rw-r----- 1 100998 100998 56 2. Jul 21:49 auto.cnf
-rw-r----- 1 100998 100998 1579 2. Jul 21:49 bbe3145d3d1b.err
-rw-r----- 1 100998 100998 2943843 2. Jul 21:49 binlog.000001
-rw-r----- 1 100998 100998 157 2. Jul 21:49 binlog.000002
-rw-r----- 1 100998 100998 32 2. Jul 21:49 binlog.index
-rw------- 1 100998 100998 1705 2. Jul 21:49 ca-key.pem
-rw-r--r-- 1 100998 100998 1112 2. Jul 21:49 ca.pem
-rw-r--r-- 1 100998 100998 1112 2. Jul 21:49 client-cert.pem
-rw------- 1 100998 100998 1705 2. Jul 21:49 client-key.pem
-rw-r----- 1 100998 100998 13302163 2. Jul 23:35 general-log.log
-rw-r----- 1 100998 100998 196608 2. Jul 21:51 '#ib_16384_0.dblwr'
-rw-r----- 1 100998 100998 8585216 2. Jul 21:49 '#ib_16384_1.dblwr'
-rw-r----- 1 100998 100998 5603 2. Jul 21:49 ib_buffer_pool
-rw-r----- 1 100998 100998 12582912 2. Jul 21:49 ibdata1
-rw-r----- 1 100998 100998 12582912 2. Jul 21:49 ibtmp1
drwxr-x--- 2 100998 100998 4096 2. Jul 21:49 '#innodb_redo'/
drwxr-x--- 2 100998 100998 4096 2. Jul 21:49 '#innodb_temp'/
drwxr-x--- 2 100998 100998 4096 2. Jul 21:49 linguacafe/
drwxr-x--- 2 100998 100998 4096 2. Jul 21:49 mysql/
-rw-r----- 1 100998 100998 32505856 2. Jul 21:49 mysql.ibd
lrwxrwxrwx 1 100998 100998 27 2. Jul 21:49 mysql.sock -> /var/run/mysqld/mysqld.sock
drwxr-x--- 2 100998 100998 4096 2. Jul 21:49 performance_schema/
-rw------- 1 100998 100998 1705 2. Jul 21:49 private_key.pem
-rw-r--r-- 1 100998 100998 452 2. Jul 21:49 public_key.pem
-rw-r--r-- 1 100998 100998 1112 2. Jul 21:49 server-cert.pem
-rw------- 1 100998 100998 1705 2. Jul 21:49 server-key.pem
drwxr-x--- 2 100998 100998 4096 2. Jul 21:49 sys/
-rw-r----- 1 100998 100998 16777216 2. Jul 21:51 undo_001
-rw-r----- 1 100998 100998 16777216 2. Jul 21:51 undo_002
ls: cannot open directory './database/#innodb_redo': Permission denied
ls: cannot open directory './database/#innodb_temp': Permission denied
ls: cannot open directory './database/linguacafe': Permission denied
ls: cannot open directory './database/mysql': Permission denied
ls: cannot open directory './database/performance_schema': Permission denied
ls: cannot open directory './database/sys': Permission denied
./storage:
total 0I want to check the output of ' cat /etc/subuidandcat /etc/subgid` since those large id numbers are a bit of a red flag, and it might be related to the way docker desktop specifically handles file sharing. Have them follow the instructions in the link if the files don't exist or don't like this:
desktop:100000:65536
dockremap:100000000:100000001 #optional
franzmondlichtmann
commented
1 day ago Hey I was the person in question Linguacafe was typing with. Here are my outputs:
cat /etc/subuid oben:100000:65536 cat /etc/subgid oben:100000:65536
sergiolaverde0
commented
15 hours ago To be honest I don't know what is causing this. Your proposal of setting the uid/gid on the compose file is sound, so try setting them to the values of your user and make sure you do so for both containers:
environment:
- PUID=1000
- PGID=1000Then delete the storage folder and create it again, and start the containers.
Whenever I try to change/add languages, the frontend does nothing:
logs: