simjanos-dev
Backup Errors & No "Stats"
I was having this issue so I deleted the application and did a fresh install with new database, etc. Unfortunately, I am still having the exact same issues. When attempting to do a backup, I get an error: "An error has occurred while exporting your database."
On top of that, I am not seeing any statistics on book chapters (Total words, unique words, etc); I just get a perpetual "loading" animation across those fields.
I am not seeing any errors in horizon.log, below is from laravel.log:
[2025-04-13 19:25:19] production.ERROR: League\Flysystem\Filesystem::delete(): Argument #1 ($location) must be of type string, null given, called in /var/www/html/vendor/laravel/framework/src/Illuminate/Filesystem/FilesystemAdapter.php on line 513 {"userId":1,"exception":"[object] (TypeError(code: 0): League\Flysystem\Filesystem::delete(): Argument #1 ($location) must be of type string, null given, called in /var/www/html/vendor/laravel/framework/src/Illuminate/Filesystem/FilesystemAdapter.php on line 513 at /var/www/html/vendor/league/flysystem/src/Filesystem.php:84) [stacktrace] #0 /var/www/html/vendor/laravel/framework/src/Illuminate/Filesystem/FilesystemAdapter.php(513): League\Flysystem\Filesystem->delete(NULL) #1 /var/www/html/app/Services/BackupService.php(41): Illuminate\Filesystem\FilesystemAdapter->delete(Array) #2 /var/www/html/app/Services/BackupService.php(24): App\Services\BackupService->deleteOldBackups('linguacafe_') #3 /var/www/html/app/Console/Commands/CreateBackup.php(32): App\Services\BackupService->createBackup() #4 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\CreateBackup->handle() #5 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #6 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure)) #7 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure)) #8 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL) #9 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call(Array) #10 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\StringInput), Object(Illuminate\Console\OutputStyle)) #11 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\StringInput), Object(Illuminate\Console\OutputStyle)) #12 /var/www/html/vendor/symfony/console/Application.php(1047): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\StringInput), Object(Symfony\Component\Console\Output\BufferedOutput)) #13 /var/www/html/vendor/symfony/console/Application.php(316): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\CreateBackup), Object(Symfony\Component\Console\Input\StringInput), Object(Symfony\Component\Console\Output\BufferedOutput)) #14 /var/www/html/vendor/symfony/console/Application.php(167): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\StringInput), Object(Symfony\Component\Console\Output\BufferedOutput)) #15 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(162): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\StringInput), Object(Symfony\Component\Console\Output\BufferedOutput)) #16 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(423): Illuminate\Console\Application->call('app:create-back...', Array, NULL) #17 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(357): Illuminate\Foundation\Console\Kernel->call('app:create-back...') #18 /var/www/html/app/Http/Controllers/BackupController.php(12): Illuminate\Support\Facades\Facade::__callStatic('call', Array) #19 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\Http\Controllers\BackupController->createBackup() #20 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\BackupController), 'createBackup') #21 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\Routing\Route->runController() #22 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\Routing\Route->run() #23 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/html/app/Http/Middleware/AdminMiddleware.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\AdminMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/AuthenticateSession.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Session\Middleware\AuthenticateSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #30 /var/www/html/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(64): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #36 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #37 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest(Object(Illuminate\Http\Request), Object(Illuminate\Session\Store), Object(Closure)) #38 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #39 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(75): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #45 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #46 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #47 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #48 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #49 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #52 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure)) #53 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #55 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #59 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #60 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #61 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure)) #62 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #63 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #64 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #65 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #66 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #67 /var/www/html/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #68 {main} "} 192.168.86.78 - - [13/Apr/2025:14:25:19 -0500] "GET /backups/create HTTP/1.1" 500 1284 "http://192.168.86.29:9191/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36" 127.0.0.1 - - [13/Apr/2025:14:25:24 -0500] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.62 (Debian) PHP/8.2.28 (internal dummy connection)"
I just wanted to post this issue, I am encountered the same issue with lacking statistics, upgrading to the beta version did not help. I even have an "importing" message
I just wanted to post this issue, I am encountered the same issue with lacking statistics, upgrading to the beta version did not help. I even have an "importing" message
Are you having the same issues with backups?
Are you having the same issues with backups?
Just tested it, backups are working fine
Hi!
@TheNomad11 @giuseppebaldi
I could recreate the database iissue by removing MAX_SAVED_BACKUPS: 14 from the docker compose file.
Did you replace the docker-compose.yml file with the new version when you updated to v0.14? If you didn't, this could cause the other issues as well, because 6001 port was added for websockets, which is used to "stream" word counts for chapters.
I just updated again with the new docker-compose.yml file and that did fix the backup issue. I was able to create a backup and verified that it was in the backups folder. Perhaps adding MAX_SAVED_BACKUPS: 14 fixed that? Still no stats though. If I go to IP:6001 I get a page that says "Not found." I am not sure if that's normal or not.
One note, I did have to change the port for redis in my docker compose file, I had another redis container on that port and it seemed to be causing some issues. I changed this to - "6377:6379" but did not change REDIS_PORT: 6379. Could that cause an issue? In the redis logs I see the below, so it seems to be working fine.
1:M 14 Apr 2025 00:21:59.005 * 100 changes in 300 seconds. Saving...
1:M 14 Apr 2025 00:21:59.005 * Background saving started by pid 22
22:C 14 Apr 2025 00:21:59.488 * DB saved on disk
22:C 14 Apr 2025 00:21:59.489 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
1:M 14 Apr 2025 00:21:59.507 * Background saving terminated with success
In my webserver log I see this, which I assume means websockets is running correctly:
2025-04-14 00:13:12,302 INFO supervisord started with pid 1
2025-04-14 00:13:13,304 INFO spawned: 'apache2' with pid 13
2025-04-14 00:13:13,305 INFO spawned: 'backup' with pid 14
2025-04-14 00:13:13,306 INFO spawned: 'horizon' with pid 15
2025-04-14 00:13:13,307 INFO spawned: 'websockets' with pid 16
2025-04-14 00:13:14,745 INFO success: apache2 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-04-14 00:13:14,745 INFO success: backup entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-04-14 00:13:14,745 INFO success: horizon entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-04-14 00:13:14,745 INFO success: websockets entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
No change after using the new docker compose file. Maybe there is a nginx issue? Could you provide a nginx reverse proxy example? I could not find anything in the documentation
EDIT: The statistics for the whole book seem to work fine, but not for the chapters
It seems to be a websocket issue. From the logs:
INFO Starting server on 0.0.0.0:6001.
INFO Starting server on 0.0.0.0:6001.
In Connection.php line 813:
SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select *
from `cache` where `key` = linguacafe_cache_laravel:reverb:restart limit 1
)
In Connector.php line 65:
SQLSTATE[HY000] [2002] Connection refused
INFO Starting server on 0.0.0.0:6001.
I have no idea, is it a nginx issue? Do you have the same error or any idea how to fix it @giuseppebaldi ?
It looks like we have the same problem but potentially different causes, I don't know. I am not having the same websocket error you're having, in fact, I don't seem to have any errors in my container logs. I tried recreating the whole stack from scratch because I didn't have this problem when I first installed it, but immediately had the same issue. I've tried the new compose file and, like you, that didn't seem to have any effect. Not sure what to do next honestly.
One note, I did have to change the port for redis in my docker compose file, I had another redis container on that port and it seemed to be causing some issues. I changed this to - "6377:6379" but did not change REDIS_PORT: 6379. Could that cause an issue?
Yes, you should add REDIS_PORT=6379 to your .env file.
Maybe there is a nginx issue? Could you provide a nginx reverse proxy example? I could not find anything in the documentation
I don't think I use nginx or other revers proxy anywhere.
If I go to IP:6001 I get a page that says "Not found." I am not sure if that's normal or not.
It is normal. 6001 port is used for websockets. It sends data to your browser without needing to refresh the pages. I think it is used at 2 places: loading data for chapters in an opened book, and importing a dictionary. You can test if it works the easiest if you try to import a larger dictionary. If you see the progress bar going, it is working.
I have an idea what could have happened for both of you. Importing happens in the background, and the import jobs are stored in redis. If you start an import, but the redis server does not work, then the importing never starts. In this case if you fixed the redis server, it will be empty, but the chapters are still marked as "importing" in the database, and they are stuck. There is already a ticket for it: #404.
If this is the case, and you can confirm that your redis server and websockets are working, you can fix this by changing chapter statuses in the database from unprocessed to failed, then clicking on the ... button on the opened book page, and clicking Retry failed imports.
This would only fix this very specific issue, where the chapters have the yellow/orange importing state next to them. On the images where chapters are not being imported, but still not getting their data streamed in I don't know what causes the issue, but it will be redis/websockets.
After a reinstallation, I think it may have something to do with this, some sort of permission error in redis: 174:C 19 Apr 2025 21:18:54.054 # Failed opening the temp RDB file temp-174.rdb (in server root dir /data) for saving: Permission denied 1:M 19 Apr 2025 21:18:54.155 # Background saving error
My linguacafe directory has folder with different owners & groups. Some are owned by a "docker-user" I created and some are owned by user 999, they are all in group 999. I changed them all to 999:999 but I am not sure that fixed it, I still get hung up on importing new chapters. What's a better fix for this? What should the folder permissions be?
Ok, I finally fixed this. I did a fresh install, after containers were created but not started yet I did CHMOD -R 777 on the entire directory, made sure there was not a single error in any log, then started up the containers. It appears I am good now. Just for good measure, I made sure I could create a backup.
I now get
In Connection.php line 813:
SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select *
from `cache` where `key` = linguacafe_cache_laravel:reverb:restart limit 1
)
In Connector.php line 65:
SQLSTATE[HY000] [2002] Connection refused
Maybe I also need to make a clean installl
EDIT: Same issue with new install, the errior messages disappeard though, maybe I should try another server or go back to v13 which worked fine...
@TheNomad11
Are you using the default docker setup, or something custom? Can you please post your docker-compose.yml file?
Sorry for the late responses, been busy last few weeks.
Hi @simjanos-dev thanks and sorry for the trouble, you have enough things to do, and it might anyway boil down to my own stupidity....
I use the standard compose file, but maybe i messed something up, I also tried using an .env file without luck
name: linguacafe
networks:
linguacafe:
driver: bridge
services:
webserver:
image: ghcr.io/simjanos-dev/linguacafe-webserver:${VERSION:-latest}
container_name: linguacafe-webserver
restart: unless-stopped
depends_on:
mysql:
condition: service_healthy
volumes:
- ./storage:/var/www/html/storage
- ./docker/supervisor-horizon.conf:/etc/supervisor/conf.d/horizon.conf
- ./docker/supervisor-websockets.conf:/etc/supervisor/conf.d/websockets.conf
environment:
DB_DATABASE: ${DB_DATABASE:-linguacafe}
DB_USERNAME: ${DB_USERNAME:-linguacafe}
DB_PASSWORD: ${DB_PASSWORD:-linguacafe}
DB_HOST: ${DB_HOST:-linguacafe-database}
DB_PORT: ${DB_PORT:-3306}
BACKUP_INTERVAL: "59 23 * * *"
MAX_SAVED_BACKUPS: 14
ports:
- "6001:6001"
- "${PORT:-9191}:80"
networks:
- linguacafe
extra_hosts:
- "host.docker.internal:host-gateway"
mysql:
image: mysql:8.0
container_name: linguacafe-database
restart: unless-stopped
tty: true
healthcheck:
test: ["CMD", 'mysqladmin', 'ping', '-h', 'localhost', '-u', 'root', '-p$MYSQL_ROOT_PASSWORD']
interval: 10s
timeout: 5s
retries: 10
volumes:
- ./database:/var/lib/mysql
environment:
MYSQL_DATABASE: ${DB_DATABASE:-linguacafe}
MYSQL_USER: ${DB_USERNAME:-linguacafe}
MYSQL_PASSWORD: ${DB_PASSWORD:-linguacafe}
MYSQL_ROOT_PASSWORD: ${DB_ROOT_PASSWORD:-linguacafe}
SERVICE_NAME: linguacafe-database
command: mysqld --general-log=1 --general-log-file=/var/lib/mysql/general-log.log
networks:
- linguacafe
redis:
image: redis:7.2-alpine
container_name: linguacafe-redis
restart: unless-stopped
volumes:
- ./cache:/data
ports:
- "6379:6379"
environment:
REDIS_PASSWORD: linguacafe
REDIS_PORT: 6379
REDIS_DATABASES: 16
networks:
- linguacafe
python:
container_name: linguacafe-python-service
command: "python3 /app/tokenizer.py"
restart: unless-stopped
tty: true
image: ghcr.io/simjanos-dev/linguacafe-python-service:${VERSION:-latest}
environment:
PYTHONPATH: "/var/www/html/storage/app/model"
volumes:
- ./storage:/var/www/html/storage
networks:
- linguacafe
platform: ${PLATFORM:-}
Out of curiosity i sometimes used the .emv file
#VERSION=
DB_CONNECTION=mysql
DB_HOST=linguacafe-database
DB_PORT=3306
DB_DATABASE=linguacafe
DB_USERNAME=linguacafe
DB_PASSWORD=linguacafe
#DB_ROOT_PASSWORD=linguacafe
One note I would like to make: when accessing the application from the local ip and port the book/chapter stats show up just fine but when trying to access through a custom domain it shows the screen where it looks like the stats are constantly loading. No big deal but thought I would mention in case there's an easy fix to address that behavior (not sure why it would be different but it is).
yeah, same for me @giuseppebaldi that means probably that's a reverse proxy issue. something must be changed related to websockets maybe?
With help from Chatgpt I found the solution. If you use a nginx reverse proxy you have to add this in the server block:
location /app {
proxy_pass http://127.0.0.1:6001;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
}
and maybe also
location /socket.io/ {
proxy_pass http://127.0.0.1:6001;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
}
restart nginx and problem solved (at least for stuff you will add and edit from now on)!
Glad you got that fixed. I am not using nginx so your solution won't help me. I am just accessing through a cloudflare tunnel. I am seeing websocket errors in the browser console so I know that's the issue but I have no idea how to fix this via cloudflare.
Not sure that it won't help you. The thing is that /app (and not /ws as in other applications) is relevant and port 6001.
Here's the Caddy solution:
linguacafe.example.com {
reverse_proxy /app* linguacafe-webserver:6001
reverse_proxy linguacafe-webserver:80
}
Finally got around to this and was able to fix it (honestly, shoutout to Gemini for the assistance). Just in case anyone else runs into this issue, in the end, all it took was creating another public hostname in Cloudflare, pointing it port 6001 and path = app.