I’ve decided to make a second Kanboard instance, so I could test a Taskwarrior-Kanboard sync plugin.
I’m starting almost from scratch, with a fresh repo with the Docker Compose file (below) modified from my “prod” version. However each time I try to login I get the “The username is required”/“The password is required” messages and the logs below (first FastCGI error is for reaching the login page, second for trying to login with admin/admin). I’ve tried to reset the password, but it didn’t work.
For unknown reasons Docker is creating the *_data
and *_plugin
folders with UID:GID 100:101 (which I may need to address later or just migrate to Podman or Proxmox). Yet if I’d be to change the ownership to the Docker user I’m welcomed with an error that the app’s data directory is not readable.
Attaching to kanboard-dev_kanboard_1
kanboard_1 | PHP message: [debug] Kanboard\Core\Controller\Runner::executeMiddleware"
kanboard_1 | PHP message: [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute"
kanboard_1 | PHP message: [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware"
kanboard_1 | PHP message: [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? LIMIT 1"
kanboard_1 | PHP message: [debug] SQL: param[1]: '7it1492nft3v9c9t4mjj3sqj7h'"
kanboard_1 | PHP message: [debug] SQL: query_duration=8.1062316894531E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=8.1062316894531E-5"
kanboard_1 | PHP message: [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings""
kanboard_1 | PHP message: [debug] SQL: query_duration=3.0040740966797E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00011110305786133"
kanboard_1 | PHP message: [debug] SQL: SELECT * FROM "actions""
kanboard_1 | PHP message: [debug] SQL: query_duration=2.9087066650391E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00014019012451172"
kanboard_1 | PHP message: [debug] SQL: SELECT * FROM "action_has_params""
kanboard_1 | PHP message: [debug] SQL: query_duration=2.7894973754883E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.0001680850982666"
kanboard_1 | PHP message: [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?"
kanboard_1 | PHP message: [debug] SQL: param[1]: '7it1492nft3v9c9t4mjj3sqj7h'"
kanboard_1 | PHP message: [debug] SQL: query_duration=2.5033950805664E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00019311904907227"
kanboard_1 | PHP message: [debug] SQL: INSERT INTO "sessions" ("id", "expire_at", "data") VALUES (:id, :expire_at, :data)"
kanboard_1 | PHP message: [debug] SQL: param[id]: '7it1492nft3v9c9t4mjj3sqj7h'"
kanboard_1 | PHP message: [debug] SQL: param[expire_at]: '1723668490'"
kanboard_1 | PHP message: [debug] SQL: param[data]: 'redirectAfterLogin|s:1:"/";'"
kanboard_1 | PHP message: [debug] SQL: query_duration=3.6954879760742E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00023007392883301"
kanboard_1 | PHP message: [debug] APP: nb_queries=6"
kanboard_1 | PHP message: [debug] APP: rendering_time=0.24332594871521"
kanboard_1 | PHP message: [debug] APP: memory_usage=3.09M"
kanboard_1 | PHP message: [debug] APP: uri=/"
kanboard_1 | PHP message: [debug] ###############################################"
kanboard_1 | 2024/08/14 20:24:10 [error] 15#15: *1 FastCGI sent in stderr: "PHP message: [debug] Kanboard\Core\Controller\Runner::executeMiddleware; PHP message: [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute; PHP message: [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware; PHP message: [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? LIMIT 1; PHP message: [debug] SQL: param[1]: '7it1492nft3v9c9t4mjj3sqj7h'; PHP message: [debug] SQL: query_duration=8.1062316894531E-5; PHP message: [debug] SQL: total_execution_time=8.1062316894531E-5; PHP message: [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings"; PHP message: [debug] SQL: query_duration=3.0040740966797E-5; PHP message: [debug] SQL: total_execution_time=0.00011110305786133; PHP message: [debug] SQL: SELECT * FROM "actions"; PHP message: [debug] SQL: query_duration=2.9087066650391E-5; PHP message: [debug] SQL: total_execution_time=0.00014019012451172; PHP message: [debug] SQL: SELECT * FROM "action_has_params"; PHP message: [debug] SQL: query_duration=2.7894973754883E-5; PHP message: [debug] SQL: total_execution_time=0.0001680850982666; PHP message: [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?; PHP message: [debug] SQL: param[1]: '7it1492nft3v9c9t4mjj3sqj7h'; PHP message: [debug] SQL: query_duration=2.5033950805664E-5; PHP message: [debug] SQL: total_execution_time=0.00019311904907227; PHP message: [debug] SQL: INSERT INTO "sessions" ("id", "expire_at", "data") VALUES (:id, :expire_at, :data); PHP message: [debug] SQL: param[id]: '7it1492nft3v9c9t4mjj3sqj7h'; PHP message: [debug] SQL: param[expire_at]: '1723668490'; PHP message: [debug] SQL: param[data]: 'redirectAfterLogin|s:1:"/";'; PHP message: [debug] SQL: query_duration=3.6954879760742E-5; PHP message: [debug] SQL: total_execution_time=0.00023007392883301; PHP message: [debug] APP: nb_queries=6; PHP message: [debug] APP: rendering_time=0.24332594871521; PHP message: [debug] APP:
kanboard_1 | PHP message: [debug] Kanboard\Core\Controller\Runner::executeMiddleware"
kanboard_1 | PHP message: [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute"
kanboard_1 | PHP message: [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware"
kanboard_1 | PHP message: [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\AuthController::login"
kanboard_1 | 2024/08/14 20:24:10 [error] 15#15: *1 FastCGI sent in stderr: "PHP message: [debug] Kanboard\Core\Controller\Runner::executeMiddleware; PHP message: [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute; PHP message: [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware; PHP message: [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\AuthController::login" while reading response header from upstream, client: ${CLIENT_IP}, server: localhost, request: "GET /login HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm.sock:", host: "${SERVER_IP}:58081"
kanboard_1 | PHP message: [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? LIMIT 1"
kanboard_1 | PHP message: [debug] SQL: param[1]: 'a5fsrakbell5spsdk78ladol9h'"
kanboard_1 | PHP message: [debug] SQL: query_duration=8.702278137207E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=8.702278137207E-5"
kanboard_1 | PHP message: [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings""
kanboard_1 | PHP message: [debug] SQL: query_duration=8.4161758422852E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00017118453979492"
kanboard_1 | PHP message: [debug] SQL: SELECT * FROM "actions""
kanboard_1 | PHP message: [debug] SQL: query_duration=7.9870223999023E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00025105476379395"
kanboard_1 | PHP message: [debug] SQL: SELECT * FROM "action_has_params""
kanboard_1 | PHP message: [debug] SQL: query_duration=5.5074691772461E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00030612945556641"
kanboard_1 | PHP message: [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?"
kanboard_1 | PHP message: [debug] SQL: param[1]: 'a5fsrakbell5spsdk78ladol9h'"
kanboard_1 | PHP message: [debug] SQL: query_duration=6.3896179199219E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00037002563476562"
kanboard_1 | PHP message: [debug] SQL: INSERT INTO "sessions" ("id", "expire_at", "data") VALUES (:id, :expire_at, :data)"
kanboard_1 | PHP message: [debug] SQL: param[id]: 'a5fsrakbell5spsdk78ladol9h'"
kanboard_1 | PHP message: [debug] SQL: param[expire_at]: '1723668490'"
kanboard_1 | PHP message: [debug] SQL: param[data]: 'csrf_key|s:64:"9b8d789323b65704175e5e326fd739e14cbda8ebefc2139cc5fb265e468291b2";'"
kanboard_1 | PHP message: [debug] SQL: query_duration=6.7949295043945E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00043797492980957"
kanboard_1 | PHP message: [debug] APP: nb_queries=6"
kanboard_1 | PHP message: [debug] APP: rendering_time=0.15036606788635"
kanboard_1 | PHP message: [debug] APP: memory_usage=1.21M"
kanboard_1 | PHP message: [debug] APP: uri=/login"
kanboard_1 | PHP message: [debug] ###############################################"
kanboard_1 | 2024/08/14 20:24:10 [error] 15#15: *1 FastCGI sent in stderr: "; PHP message: [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? LIMIT 1; PHP message: [debug] SQL: param[1]: 'a5fsrakbell5spsdk78ladol9h'; PHP message: [debug] SQL: query_duration=8.702278137207E-5; PHP message: [debug] SQL: total_execution_time=8.702278137207E-5; PHP message: [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings"; PHP message: [debug] SQL: query_duration=8.4161758422852E-5; PHP message: [debug] SQL: total_execution_time=0.00017118453979492; PHP message: [debug] SQL: SELECT * FROM "actions"; PHP message: [debug] SQL: query_duration=7.9870223999023E-5; PHP message: [debug] SQL: total_execution_time=0.00025105476379395; PHP message: [debug] SQL: SELECT * FROM "action_has_params"; PHP message: [debug] SQL: query_duration=5.5074691772461E-5; PHP message: [debug] SQL: total_execution_time=0.00030612945556641; PHP message: [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?; PHP message: [debug] SQL: param[1]: 'a5fsrakbell5spsdk78ladol9h'; PHP message: [debug] SQL: query_duration=6.3896179199219E-5; PHP message: [debug] SQL: total_execution_time=0.00037002563476562; PHP message: [debug] SQL: INSERT INTO "sessions" ("id", "expire_at", "data") VALUES (:id, :expire_at, :data); PHP message: [debug] SQL: param[id]: 'a5fsrakbell5spsdk78ladol9h'; PHP message: [debug] SQL: param[expire_at]: '1723668490'; PHP message: [debug] SQL: param[data]: 'csrf_key|s:64:"9b8d789323b65704175e5e326fd739e14cbda8ebefc2139cc5fb265e468291b2";'; PHP message: [debug] SQL: query_duration=6.7949295043945E-5; PHP message: [debug] SQL: total_execution_time=0.00043797492980957; PHP message: [debug] APP: nb_queries=6; PHP message: [debug] APP: rendering_time=0.15036606788635; PHP message: [debug] APP: memory_usage=1.21M; PHP message: [debug] APP: uri=/login; PHP message: [debug] ###############################################" while reading upstream, client: ${CLIENT_IP}, server: localhost, request: "GET /login HTTP/1.1",
kanboard_1 | PHP message: [debug] Kanboard\Core\Controller\Runner::executeMiddleware"
kanboard_1 | PHP message: [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute"
kanboard_1 | PHP message: [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware"
kanboard_1 | PHP message: [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\AuthController::check"
kanboard_1 | 2024/08/14 20:24:18 [error] 15#15: *1 FastCGI sent in stderr: "PHP message: [debug] Kanboard\Core\Controller\Runner::executeMiddleware; PHP message: [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute; PHP message: [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware; PHP message: [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\AuthController::check" while reading response header from upstream, client: ${CLIENT_IP}, server: localhost, request: "POST /?controller=AuthController&action=check HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm.sock:", host: "${SERVER_IP}:58081"
kanboard_1 | PHP message: [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? LIMIT 1"
kanboard_1 | PHP message: [debug] SQL: param[1]: 'bq90i0oo5gnla9lbljbi805l12'"
kanboard_1 | PHP message: [debug] SQL: query_duration=8.1062316894531E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=8.1062316894531E-5"
kanboard_1 | PHP message: [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings""
kanboard_1 | PHP message: [debug] SQL: query_duration=4.0054321289062E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00012111663818359"
kanboard_1 | PHP message: [debug] SQL: SELECT * FROM "actions""
kanboard_1 | PHP message: [debug] SQL: query_duration=4.7922134399414E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00016903877258301"
kanboard_1 | PHP message: [debug] SQL: SELECT * FROM "action_has_params""
kanboard_1 | PHP message: [debug] SQL: query_duration=3.504753112793E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00020408630371094"
kanboard_1 | PHP message: [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?"
kanboard_1 | PHP message: [debug] SQL: param[1]: 'bq90i0oo5gnla9lbljbi805l12'"
kanboard_1 | PHP message: [debug] SQL: query_duration=3.7908554077148E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00024199485778809"
kanboard_1 | PHP message: [debug] SQL: INSERT INTO "sessions" ("id", "expire_at", "data") VALUES (:id, :expire_at, :data)"
kanboard_1 | PHP message: [debug] SQL: param[id]: 'bq90i0oo5gnla9lbljbi805l12'"
kanboard_1 | PHP message: [debug] SQL: param[expire_at]: '1723668498'"
kanboard_1 | PHP message: [debug] SQL: param[data]: 'csrf_key|s:64:"9604a15996c427266b3b1b989bca5c6813611ae63fcfc01c417cec6da0b3cac4";hasRememberMe|b:0;'"
kanboard_1 | PHP message: [debug] SQL: query_duration=5.4121017456055E-5"
kanboard_1 | PHP message: [debug] SQL: total_execution_time=0.00029611587524414"
kanboard_1 | PHP message: [debug] APP: nb_queries=6"
kanboard_1 | PHP message: [debug] APP: rendering_time=0.13861417770386"
kanboard_1 | PHP message: [debug] APP: memory_usage=1.09M"
kanboard_1 | PHP message: [debug] APP: uri=/?controller=AuthController&action=check"
kanboard_1 | PHP message: [debug] ###############################################"
kanboard_1 | 2024/08/14 20:24:18 [error] 15#15: *1 FastCGI sent in stderr: "; PHP message: [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? LIMIT 1; PHP message: [debug] SQL: param[1]: 'bq90i0oo5gnla9lbljbi805l12'; PHP message: [debug] SQL: query_duration=8.1062316894531E-5; PHP message: [debug] SQL: total_execution_time=8.1062316894531E-5; PHP message: [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings"; PHP message: [debug] SQL: query_duration=4.0054321289062E-5; PHP message: [debug] SQL: total_execution_time=0.00012111663818359; PHP message: [debug] SQL: SELECT * FROM "actions"; PHP message: [debug] SQL: query_duration=4.7922134399414E-5; PHP message: [debug] SQL: total_execution_time=0.00016903877258301; PHP message: [debug] SQL: SELECT * FROM "action_has_params"; PHP message: [debug] SQL: query_duration=3.504753112793E-5; PHP message: [debug] SQL: total_execution_time=0.00020408630371094; PHP message: [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?; PHP message: [debug] SQL: param[1]: 'bq90i0oo5gnla9lbljbi805l12'; PHP message: [debug] SQL: query_duration=3.7908554077148E-5; PHP message: [debug] SQL: total_execution_time=0.00024199485778809; PHP message: [debug] SQL: INSERT INTO "sessions" ("id", "expire_at", "data") VALUES (:id, :expire_at, :data); PHP message: [debug] SQL: param[id]: 'bq90i0oo5gnla9lbljbi805l12'; PHP message: [debug] SQL: param[expire_at]: '1723668498'; PHP message: [debug] SQL: param[data]: 'csrf_key|s:64:"9604a15996c427266b3b1b989bca5c6813611ae63fcfc01c417cec6da0b3cac4";hasRememberMe|b:0;'; PHP message: [debug] SQL: query_duration=5.4121017456055E-5; PHP message: [debug] SQL: total_execution_time=0.00029611587524414; PHP message: [debug] APP: nb_queries=6; PHP message: [debug] APP: rendering_time=0.13861417770386; PHP message: [debug] APP: memory_usage=1.09M; PHP message: [debug] APP: uri=/?controller=AuthController&action=check; PHP message: [debug] ###############################################" while reading upstream, client: ${CLIENT_IP}
version: '2'
services:
kanboard:
image: kanboard/kanboard:latest
ports:
- "58081:80"
- "54443:443"
volumes:
- kanboard_data:/var/www/app/data
- kanboard_plugins:/var/www/app/plugins
- kanboard_ssl:/etc/nginx/ssl
environment:
- PLUGIN_INSTALLER=true
- VIRTUAL_HOST=kanboard-dev.neofarelka.dzw:4443
volumes:
kanboard_data:
driver: local
kanboard_plugins:
driver: local
kanboard_ssl:
driver: local