search

linuxserver / docker-bookstack

A Docker container for the BookStack documentation wiki
GNU General Public License v3.0
725 stars 105 forks source link

Cannot login with the default user and password - Issue also to create a new admin user inside of the Docker #205

Closed jpquinta closed 5 months ago

jpquinta commented 5 months ago

Is there an existing issue for this?

Current Behavior

This is the error msg that I got when we use the "admin@admin.com" and "password":

image

After analyzing the log file of the "laravel.log" this is the msg that is presented:

image

If we try to create a new user with admin rights like this one:

image

We get this lines:

image

What can be? I'm using the latest version..... Thank you JP

Expected Behavior

No response

Steps To Reproduce

  1. Execute the config of docker-compose.yml that I'm sharing and see the behavior

Environment

- OS: Windows 11 Pro
- How docker service was installed: Docker Desktop v4.27.1

CPU architecture

x86-64

Docker creation

---
version: "2"
services:
  bookstack:
    image: lscr.io/linuxserver/bookstack:latest
    container_name: bookstack
    environment:
      - PUID=1000
      - PGID=1000
      - APP_URL=http://localhost:6827
      - DB_HOST=bookstack_db
      - DB_PORT=3306
      - DB_USER=bookstack
      - DB_PASS=12345abc
      - DB_DATABASE=bookstackapp
    volumes:
      - ./bookstack_app_data:/config
    ports:
      - 6827:80
    restart: unless-stopped
    depends_on:
      - bookstack_db
  bookstack_db:
    image: lscr.io/linuxserver/mariadb:latest
    container_name: bookstack_db
    environment:
      - PUID=1000
      - PGID=1000
      - MYSQL_ROOT_PASSWORD=12345abc
      - TZ=Europe/Lisbon
      - MYSQL_DATABASE=bookstackapp
      - MYSQL_USER=bookstack
      - MYSQL_PASSWORD=12345abc
    volumes:
      - ./bookstack_db_data:/config
    restart: unless-stopped

Container logs

2024-02-01 22:16:09 bookstack_db  | [migrations] started
2024-02-01 22:16:10 bookstack     | [migrations] started
2024-02-01 22:16:09 bookstack_db  | [migrations] no migrations found
2024-02-01 22:16:10 bookstack     | [migrations] 01-nginx-site-confs-default: skipped
2024-02-01 22:16:10 bookstack     | [migrations] 02-default-location: skipped
2024-02-01 22:16:10 bookstack     | [migrations] done
2024-02-01 22:16:10 bookstack_db  | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack     | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack     | 
2024-02-01 22:16:10 bookstack_db  | 
2024-02-01 22:16:10 bookstack     |       ██╗     ███████╗██╗ ██████╗
2024-02-01 22:16:10 bookstack     |       ██║     ██╔════╝██║██╔═══██╗
2024-02-01 22:16:10 bookstack_db  |       ██╗     ███████╗██╗ ██████╗
2024-02-01 22:16:10 bookstack_db  |       ██║     ██╔════╝██║██╔═══██╗
2024-02-01 22:16:10 bookstack_db  |       ██║     ███████╗██║██║   ██║
2024-02-01 22:16:10 bookstack     |       ██║     ███████╗██║██║   ██║
2024-02-01 22:16:10 bookstack_db  |       ██║     ╚════██║██║██║   ██║
2024-02-01 22:16:10 bookstack     |       ██║     ╚════██║██║██║   ██║
2024-02-01 22:16:10 bookstack_db  |       ███████╗███████║██║╚██████╔╝
2024-02-01 22:16:10 bookstack_db  |       ╚══════╝╚══════╝╚═╝ ╚═════╝
2024-02-01 22:16:10 bookstack_db  | 
2024-02-01 22:16:10 bookstack     |       ███████╗███████║██║╚██████╔╝
2024-02-01 22:16:10 bookstack_db  |    Brought to you by linuxserver.io
2024-02-01 22:16:10 bookstack     |       ╚══════╝╚══════╝╚═╝ ╚═════╝
2024-02-01 22:16:10 bookstack     | 
2024-02-01 22:16:10 bookstack_db  | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack     |    Brought to you by linuxserver.io
2024-02-01 22:16:10 bookstack     | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack     | 
2024-02-01 22:16:10 bookstack_db  | 
2024-02-01 22:16:10 bookstack     | To support LSIO projects visit:
2024-02-01 22:16:10 bookstack_db  | To support LSIO projects visit:
2024-02-01 22:16:10 bookstack_db  | https://www.linuxserver.io/donate/
2024-02-01 22:16:10 bookstack_db  | 
2024-02-01 22:16:10 bookstack_db  | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack_db  | GID/UID
2024-02-01 22:16:10 bookstack_db  | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack     | https://www.linuxserver.io/donate/
2024-02-01 22:16:10 bookstack     | 
2024-02-01 22:16:10 bookstack_db  | 
2024-02-01 22:16:10 bookstack     | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack_db  | User UID:    1000
2024-02-01 22:16:10 bookstack     | GID/UID
2024-02-01 22:16:10 bookstack     | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack     | 
2024-02-01 22:16:10 bookstack     | User UID:    1000
2024-02-01 22:16:10 bookstack_db  | User GID:    1000
2024-02-01 22:16:10 bookstack_db  | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack     | User GID:    1000
2024-02-01 22:16:10 bookstack     | ───────────────────────────────────────
2024-02-01 22:16:10 bookstack     | 
2024-02-01 22:16:10 bookstack_db  | 
2024-02-01 22:16:11 bookstack_db  | cp: not replacing '/config/custom.cnf'
2024-02-01 22:16:11 bookstack     | using keys found in /config/keys
2024-02-01 22:16:12 bookstack_db  | [custom-init] No custom files found, skipping...
2024-02-01 22:16:11 bookstack     | App Key found - setting variable for seds
2024-02-01 22:16:11 bookstack     | Running config - DB_HOST set
2024-02-01 22:16:12 bookstack     | Waiting for DB to be available
2024-02-01 22:16:22 bookstack     | 
2024-02-01 22:16:12 bookstack_db  | 240201 22:16:12 mysqld_safe Logging to '/config/databases/17216b65dd6f.err'.
2024-02-01 22:16:22 bookstack     |    INFO  Running migrations.  
2024-02-01 22:16:12 bookstack_db  | 240201 22:16:12 mysqld_safe Starting mariadbd daemon with databases from /config/databases
2024-02-01 22:16:22 bookstack     | 
2024-02-01 22:16:15 bookstack_db  | Connection to localhost (127.0.0.1) 3306 port [tcp/mysql] succeeded!
2024-02-01 22:16:22 bookstack     |   2019_07_07_112515_add_template_support ........................... 35ms FAIL
2024-02-01 22:16:15 bookstack_db  | [ls.io-init] done.
2024-02-01 22:16:22 bookstack     | 
2024-02-01 22:16:22 bookstack     |    Illuminate\Database\QueryException 
2024-02-01 22:16:22 bookstack     | 
2024-02-01 22:16:22 bookstack     |   SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'template' (SQL: alter table `pages` add `template` tinyint(1) not null default '0')
2024-02-01 22:16:22 bookstack     | 
2024-02-01 22:16:22 bookstack     |   at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
2024-02-01 22:16:22 bookstack     |     756▕         // If an exception occurs when attempting to run a query, we'll format the error
2024-02-01 22:16:22 bookstack     |     757▕         // message to include the bindings with SQL, which will make this exception a
2024-02-01 22:16:22 bookstack     |     758▕         // lot more helpful to the developer instead of just the database's errors.
2024-02-01 22:16:22 bookstack     |     759▕         catch (Exception $e) {
2024-02-01 22:16:22 bookstack     |   ➜ 760▕             throw new QueryException(
2024-02-01 22:16:22 bookstack     |     761▕                 $query, $this->prepareBindings($bindings), $e
2024-02-01 22:16:22 bookstack     |     762▕             );
2024-02-01 22:16:22 bookstack     |     763▕         }
2024-02-01 22:16:22 bookstack     |     764▕     }
2024-02-01 22:16:22 bookstack     | 
2024-02-01 22:16:22 bookstack     |       +9 vendor frames 
2024-02-01 22:16:22 bookstack     |   10  /app/www/database/migrations/2019_07_07_112515_add_template_support.php:17
2024-02-01 22:16:22 bookstack     |       Illuminate\Support\Facades\Facade::__callStatic()
2024-02-01 22:16:22 bookstack     | 
2024-02-01 22:16:22 bookstack     |       +25 vendor frames 
2024-02-01 22:16:22 bookstack     |   36  /app/www/artisan:35
2024-02-01 22:16:22 bookstack     |       Illuminate\Foundation\Console\Kernel::handle()
2024-02-01 22:16:23 bookstack     | **** The following active confs have different version dates than the samples that are shipped. ****
2024-02-01 22:16:23 bookstack     | **** This may be due to user customization or an update to the samples. ****
2024-02-01 22:16:23 bookstack     | **** You should compare the following files to the samples in the same folder and update them. ****
2024-02-01 22:16:23 bookstack     | **** Use the link at the top of the file to view the changelog. ****
2024-02-01 22:16:23 bookstack     | ┌────────────┬────────────┬────────────────────────────────────────────────────────────────────────┐
2024-02-01 22:16:23 bookstack     | │  old date  │  new date  │ path                                                                   │
2024-02-01 22:16:23 bookstack     | ├────────────┼────────────┼────────────────────────────────────────────────────────────────────────┤
2024-02-01 22:16:23 bookstack     | │ 2023-04-13 │ 2023-12-25 │ /config/nginx/site-confs/default.conf                                  │
2024-02-01 22:16:23 bookstack     | └────────────┴────────────┴────────────────────────────────────────────────────────────────────────┘
2024-02-01 22:16:23 bookstack     | [custom-init] No custom files found, skipping...
2024-02-01 22:16:23 bookstack     | [ls.io-init] done.
github-actions[bot] commented 5 months ago

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

jpquinta commented 5 months ago

I would like to update with the following log (this is the first log when start for the first time the container):

2024-02-01 23:14:22 bookstack_db | [migrations] started 2024-02-01 23:14:22 bookstack_db | [migrations] no migrations found 2024-02-01 23:14:22 bookstack_db | ─────────────────────────────────────── 2024-02-01 23:14:22 bookstack_db | 2024-02-01 23:14:22 bookstack_db | ██╗ ███████╗██╗ ██████╗ 2024-02-01 23:14:22 bookstack_db | ██║ ██╔════╝██║██╔═══██╗ 2024-02-01 23:14:22 bookstack_db | ██║ ███████╗██║██║ ██║ 2024-02-01 23:14:22 bookstack_db | ██║ ╚════██║██║██║ ██║ 2024-02-01 23:14:22 bookstack_db | ███████╗███████║██║╚██████╔╝ 2024-02-01 23:14:22 bookstack_db | ╚══════╝╚══════╝╚═╝ ╚═════╝ 2024-02-01 23:14:22 bookstack_db | 2024-02-01 23:14:22 bookstack_db | Brought to you by linuxserver.io 2024-02-01 23:14:22 bookstack_db | ─────────────────────────────────────── 2024-02-01 23:14:22 bookstack_db | 2024-02-01 23:14:22 bookstack_db | To support LSIO projects visit: 2024-02-01 23:14:22 bookstack_db | https://www.linuxserver.io/donate/ 2024-02-01 23:14:22 bookstack_db | 2024-02-01 23:14:22 bookstack_db | ─────────────────────────────────────── 2024-02-01 23:14:22 bookstack_db | GID/UID 2024-02-01 23:14:22 bookstack_db | ─────────────────────────────────────── 2024-02-01 23:14:22 bookstack_db | 2024-02-01 23:14:22 bookstack_db | User UID: 1000 2024-02-01 23:14:22 bookstack_db | User GID: 1000 2024-02-01 23:14:22 bookstack_db | ─────────────────────────────────────── 2024-02-01 23:14:22 bookstack_db | 2024-02-01 23:14:22 bookstack_db | Setting Up Initial Databases 2024-02-01 23:14:22 bookstack_db | Installing MariaDB/MySQL system tables in '/config/databases' ... 2024-02-01 23:14:29 bookstack_db | 2024-02-01 23:14:29 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory") 2024-02-01 23:14:22 bookstack | [migrations] started 2024-02-01 23:14:22 bookstack | [migrations] 01-nginx-site-confs-default: executing... 2024-02-01 23:14:22 bookstack | [migrations] 01-nginx-site-confs-default: succeeded 2024-02-01 23:14:23 bookstack | [migrations] 02-default-location: executing... 2024-02-01 23:14:23 bookstack | [migrations] 02-default-location: succeeded 2024-02-01 23:14:23 bookstack | [migrations] done 2024-02-01 23:14:23 bookstack | ─────────────────────────────────────── 2024-02-01 23:14:23 bookstack | 2024-02-01 23:14:23 bookstack | ██╗ ███████╗██╗ ██████╗ 2024-02-01 23:14:23 bookstack | ██║ ██╔════╝██║██╔═══██╗ 2024-02-01 23:14:23 bookstack | ██║ ███████╗██║██║ ██║ 2024-02-01 23:14:23 bookstack | ██║ ╚════██║██║██║ ██║ 2024-02-01 23:14:23 bookstack | ███████╗███████║██║╚██████╔╝ 2024-02-01 23:14:23 bookstack | ╚══════╝╚══════╝╚═╝ ╚═════╝ 2024-02-01 23:14:23 bookstack | 2024-02-01 23:14:23 bookstack | Brought to you by linuxserver.io 2024-02-01 23:14:23 bookstack | ─────────────────────────────────────── 2024-02-01 23:14:23 bookstack | 2024-02-01 23:14:23 bookstack | To support LSIO projects visit: 2024-02-01 23:14:23 bookstack | https://www.linuxserver.io/donate/ 2024-02-01 23:14:23 bookstack | 2024-02-01 23:14:23 bookstack | ─────────────────────────────────────── 2024-02-01 23:14:23 bookstack | GID/UID 2024-02-01 23:14:23 bookstack | ─────────────────────────────────────── 2024-02-01 23:14:23 bookstack | 2024-02-01 23:14:23 bookstack | User UID: 1000 2024-02-01 23:14:23 bookstack | User GID: 1000 2024-02-01 23:14:23 bookstack | ─────────────────────────────────────── 2024-02-01 23:14:23 bookstack | 2024-02-01 23:14:24 bookstack | Setting resolver to 127.0.0.11 2024-02-01 23:14:24 bookstack | Setting worker_processes to 16 2024-02-01 23:14:29 bookstack | generating self-signed keys in /config/keys, you can replace these with your own keys if required 2024-02-01 23:14:29 bookstack | .............+++++++++++++++++++++++++++++++++++++++...+...+...............+...+.....+.........+...+..........+.....+.......+.....+...+.........+....+.................+.......+.....+++++++++++++++++++++++++++++++++++++++.....+...+..........+.........+..+...+.+..+...+.........+.+......+...+...+........+.........+.+..+...+....+...+........+.+..................+.....+..........+.....+.+....................+..........+...........+...+.+......+...+..+...+............+...............+.+.....+.......+.....+.+.....+.........+...+...+....+............+......+...+.....+................+...+..+......+.......+...+...+..............+.............+.....+....+........+.............+..+.+..+....+..................+...+...+.........+...............+........+...+.......+.........+...+...+.........+.....+...+.+.....+.........+................+.....+.........+..........+..+......+...+....+......+.....+....+..+.+...+...........+......+...+....+........+....+...+...........+............+....+........+...+...+....+......+.....+.+.....+.+........+.+......+..+...+.........+...............+....+..+.......+..+....+.........+.....+...+...+.......+...+..+..........+...+.....+......+....+........................+...+............+...+..+................+..+....+......+...+...........+...+.+......+.....+.+..+...+...+.+......+..+......++++++ 2024-02-01 23:14:29 bookstack | ...+.....+......+....+...+........+....+...+..+.+..+.+.....+++++++++++++++++++++++++++++++++++++++..............+......+.............+......+......+.........+..+....+.....+.........+......+.+.....+.........+...+..........+..+.+.....+...+.........+++++++++++++++++++++++++++++++++++++++..+....+...+...+......+...+......+..+...+.+...........+...+....+...........+...............+.......+..............+.+..............++++++ 2024-02-01 23:14:29 bookstack | ----- 2024-02-01 23:14:32 bookstack | Generating BookStack app key for first run 2024-02-01 23:14:35 bookstack | App Key set to base64:Yd3rDyITfm5hVopNpaRQw3Lx32Fmqy95ie7PHuXd9mg= you can modify the file to update /config/BOOKSTACK_APP_KEY.txt 2024-02-01 23:14:35 bookstack | Running config - DB_HOST set 2024-02-01 23:14:35 bookstack | Insert DB_PORT='3306' into /config/www/.env 2024-02-01 23:14:37 bookstack | APP_URL in /config/www/.env is being updated from https://example.com to http://localhost:6827 2024-02-01 23:14:37 bookstack | If this is an existing install, you should run the following line from your host terminal to update the database URL entries: 2024-02-01 23:14:37 bookstack | **** 2024-02-01 23:14:37 bookstack | docker exec -it bookstack php /app/www/artisan bookstack:update-url https://example.com http://localhost:6827 2024-02-01 23:14:37 bookstack | **** 2024-02-01 23:14:37 bookstack | Waiting for DB to be available 2024-02-01 23:14:56 bookstack_db | OK 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | To start mariadbd at boot time you have to copy 2024-02-01 23:14:56 bookstack_db | support-files/mariadb.service to the right place for your system 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! 2024-02-01 23:14:56 bookstack_db | To do so, start the server, then issue the following command: 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | '/usr/bin/mariadb-secure-installation' 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | which will also give you the option of removing the test 2024-02-01 23:14:56 bookstack_db | databases and anonymous user created by default. This is 2024-02-01 23:14:56 bookstack_db | strongly recommended for production servers. 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | See the MariaDB Knowledgebase at https://mariadb.com/kb 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | You can start the MariaDB daemon with: 2024-02-01 23:14:56 bookstack_db | cd '/usr' ; /usr/bin/mariadb-safe --datadir='/config/databases' 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | You can test the MariaDB daemon with mysql-test-run.pl 2024-02-01 23:14:56 bookstack_db | cd '/usr/mysql-test' ; perl mariadb-test-run.pl 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | Please report any problems at https://mariadb.org/jira 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | The latest information about MariaDB is available at https://mariadb.org/. 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | Consider joining MariaDB's strong and vibrant community: 2024-02-01 23:14:56 bookstack_db | https://mariadb.org/get-involved/ 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 0 [Warning] Setting lower_case_table_names=2 because file system for /config/databases/ is case insensitive 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 0 [Note] Starting MariaDB 10.11.6-MariaDB-log source revision fecd78b83785d5ae96f2c6ff340375be803cd299 as process 186 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 0 [Note] InnoDB: Compressed tables use zlib 1.3.1 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 0 [Note] InnoDB: Number of transaction pools: 1 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2024-02-01 23:14:56 bookstack_db | 2024-02-01 23:14:56 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) 2024-02-01 23:14:57 bookstack_db | 2024-02-01 23:14:57 0 [Note] InnoDB: Using Linux native AIO 2024-02-01 23:14:57 bookstack_db | 2024-02-01 23:14:57 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB 2024-02-01 23:14:57 bookstack_db | 2024-02-01 23:14:57 0 [Note] InnoDB: Completed initialization of buffer pool 2024-02-01 23:14:57 bookstack_db | 2024-02-01 23:14:57 0 [Note] InnoDB: Buffered log writes (block size=512 bytes) 2024-02-01 23:14:57 bookstack_db | 2024-02-01 23:14:57 0 [Note] InnoDB: End of log at LSN=46846 2024-02-01 23:14:58 bookstack_db | 2024-02-01 23:14:58 0 [Note] InnoDB: 128 rollback segments are active. 2024-02-01 23:14:58 bookstack_db | 2024-02-01 23:14:58 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2024-02-01 23:14:58 bookstack_db | 2024-02-01 23:14:58 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2024-02-01 23:14:58 bookstack_db | 2024-02-01 23:14:58 0 [Note] InnoDB: log sequence number 46846; transaction id 14 2024-02-01 23:14:58 bookstack_db | 2024-02-01 23:14:58 0 [Note] Plugin 'FEEDBACK' is disabled. 2024-02-01 23:14:58 bookstack_db | 2024-02-01 23:14:58 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool 2024-02-01 23:14:58 bookstack_db | 2024-02-01 23:14:58 0 [Note] InnoDB: Buffer pool(s) load completed at 240201 23:14:58 2024-02-01 23:14:58 bookstack_db | 2024-02-01 23:14:58 0 [Note] Server socket created on IP: '0.0.0.0'. 2024-02-01 23:14:58 bookstack_db | 2024-02-01 23:14:58 0 [Note] Server socket created on IP: '::'. 2024-02-01 23:14:59 bookstack_db | 2024-02-01 23:14:59 0 [Note] mariadbd: ready for connections. 2024-02-01 23:14:59 bookstack_db | Version: '10.11.6-MariaDB-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Alpine Linux 2024-02-01 23:15:00 bookstack_db | 2024-02-01 23:15:00 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: 'bookstack.bookstackazuredeployment_default' (This connection closed normally without authentication) 2024-02-01 23:15:00 bookstack_db | 2024-02-01 23:15:00 0 [Note] mariadbd (initiated by: root[root] @ localhost []): Normal shutdown 2024-02-01 23:15:00 bookstack_db | 2024-02-01 23:15:00 0 [Note] InnoDB: FTS optimize thread exiting. 2024-02-01 23:15:01 bookstack_db | 2024-02-01 23:15:01 0 [Note] InnoDB: Starting shutdown... 2024-02-01 23:15:01 bookstack_db | 2024-02-01 23:15:01 0 [Note] InnoDB: Dumping buffer pool(s) to /config/databases/ib_buffer_pool 2024-02-01 23:15:01 bookstack_db | 2024-02-01 23:15:01 0 [Note] InnoDB: Buffer pool(s) dump completed at 240201 23:15:01 2024-02-01 23:15:01 bookstack_db | 2024-02-01 23:15:01 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" 2024-02-01 23:15:01 bookstack_db | 2024-02-01 23:15:01 0 [Note] InnoDB: Shutdown completed; log sequence number 46846; transaction id 16 2024-02-01 23:15:01 bookstack_db | 2024-02-01 23:15:01 0 [Note] mariadbd: Shutdown complete 2024-02-01 23:15:01 bookstack_db | 2024-02-01 23:15:01 bookstack_db | Database Setup Completed 2024-02-01 23:15:03 bookstack_db | [custom-init] No custom files found, skipping... 2024-02-01 23:15:03 bookstack_db | 240201 23:15:03 mysqld_safe Logging to '/config/databases/22df07851f03.err'. 2024-02-01 23:15:03 bookstack_db | 240201 23:15:03 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2024-02-01 23:15:05 bookstack_db | Connection to localhost (127.0.0.1) 3306 port [tcp/mysql] succeeded! 2024-02-01 23:15:05 bookstack_db | [ls.io-init] done. 2024-02-01 23:15:07 bookstack | 2024-02-01 23:15:07 bookstack | INFO Preparing database.
2024-02-01 23:15:07 bookstack | 2024-02-01 23:15:07 bookstack | Creating migration table ........................................ 250ms DONE 2024-02-01 23:15:07 bookstack | 2024-02-01 23:15:07 bookstack | INFO Running migrations.
2024-02-01 23:15:07 bookstack | 2024-02-01 23:15:07 bookstack | 2014_10_12_000000_create_users_table ............................ 240ms DONE 2024-02-01 23:15:08 bookstack | 2014_10_12_100000_create_password_resets_table .................. 240ms DONE 2024-02-01 23:15:08 bookstack | 2015_07_12_114933_create_books_table ............................. 72ms DONE 2024-02-01 23:15:08 bookstack | 2015_07_12_190027_create_pages_table ............................. 45ms DONE 2024-02-01 23:15:08 bookstack | 2015_07_13_172121_create_images_table ............................ 42ms DONE 2024-02-01 23:15:08 bookstack | 2015_07_27_172342_create_chapters_table .......................... 38ms DONE 2024-02-01 23:15:08 bookstack | 2015_08_08_200447_add_users_to_entities ......................... 412ms DONE 2024-02-01 23:15:08 bookstack | 2015_08_09_093534_create_page_revisions_table .................... 38ms DONE 2024-02-01 23:15:08 bookstack | 2015_08_16_142133_create_activities_table ........................ 72ms DONE 2024-02-01 23:15:11 bookstack | 2015_08_29_105422_add_roles_and_permissions ................... 2,845ms DONE 2024-02-01 23:15:13 bookstack | 2015_08_30_125859_create_settings_table ....................... 1,640ms DONE 2024-02-01 23:15:13 bookstack | 2015_08_31_175240_add_search_indexes .............................. 0ms DONE 2024-02-01 23:15:13 bookstack | 2015_09_04_165821_create_social_accounts_table .................. 254ms DONE 2024-02-01 23:15:14 bookstack | 2015_09_05_164707_add_email_confirmation_table .................. 905ms DONE 2024-02-01 23:15:14 bookstack | 2015_11_21_145609_create_views_table ............................. 69ms DONE 2024-02-01 23:15:18 bookstack | 2015_11_26_221857_add_entity_indexes .......................... 3,930ms DONE 2024-02-01 23:15:18 bookstack | 2015_12_05_145049_fulltext_weighting .............................. 0ms DONE 2024-02-01 23:15:18 bookstack | 2015_12_07_195238_add_image_upload_types ........................ 238ms DONE 2024-02-01 23:15:19 bookstack | 2015_12_09_195748_add_user_avatars .............................. 188ms DONE 2024-02-01 23:15:19 bookstack | 2016_01_11_210908_add_external_auth_to_users .................... 721ms DONE 2024-02-01 23:15:20 bookstack | 2016_02_25_184030_add_slug_to_revisions ......................... 478ms DONE 2024-02-01 23:15:21 bookstack | 2016_02_27_120329_update_permissions_and_roles .................. 772ms DONE 2024-02-01 23:15:22 bookstack | 2016_02_28_084200_add_entity_access_controls .................. 1,497ms DONE 2024-02-01 23:15:22 bookstack | 2016_03_09_203143_add_page_revision_types ....................... 199ms DONE 2024-02-01 23:15:23 bookstack | 2016_03_13_082138_add_page_drafts ............................... 324ms DONE 2024-02-01 23:15:23 bookstack | 2016_03_25_123157_add_markdown_support .......................... 163ms DONE 2024-02-01 23:15:23 bookstack | 2016_04_09_100730_add_view_permissions_to_roles ................. 156ms DONE 2024-02-01 23:15:26 bookstack | 2016_04_20_192649_create_joint_permissions_table .............. 2,684ms DONE 2024-02-01 23:15:27 bookstack | 2016_05_06_185215_create_tags_table ........................... 1,504ms DONE 2024-02-01 23:15:28 bookstack | 2016_07_07_181521_add_summary_to_page_revisions ................. 117ms DONE 2024-02-01 23:15:29 bookstack | 2016_09_29_101449_remove_hidden_roles ........................... 965ms DONE 2024-02-01 23:15:29 bookstack | 2016_10_09_142037_create_attachments_table ...................... 299ms DONE 2024-02-01 23:15:29 bookstack | 2017_01_21_163556_create_cache_table ............................ 213ms DONE 2024-02-01 23:15:29 bookstack | 2017_01_21_163602_create_sessions_table ......................... 227ms DONE 2024-02-01 23:15:30 bookstack | 2017_03_19_091553_create_search_index_table ..................... 740ms DONE 2024-02-01 23:15:30 bookstack | 2017_04_20_185112_add_revision_counts ........................... 342ms DONE 2024-02-01 23:15:30 bookstack | 2017_07_02_152834_update_db_encoding_to_ut8mb4 .................... 0ms DONE 2024-02-01 23:15:31 bookstack | 2017_08_01_130541_create_comments_table ......................... 268ms DONE 2024-02-01 23:15:31 bookstack | 2017_08_29_102650_add_cover_image_display ........................ 57ms DONE 2024-02-01 23:15:31 bookstack | 2018_07_15_173514_add_role_external_auth_id ..................... 202ms DONE 2024-02-01 23:15:33 bookstack | 2018_08_04_115700_create_bookshelves_table .................... 1,687ms DONE 2024-02-01 23:15:34 bookstack | 2019_07_07_112515_add_template_support ........................ 1,301ms FAIL 2024-02-01 23:15:34 bookstack | 2024-02-01 23:15:34 bookstack | Illuminate\Database\QueryException 2024-02-01 23:15:34 bookstack | 2024-02-01 23:15:34 bookstack | SQLSTATE[HY000] [2002] Connection refused (SQL: alter table pages add index pages_template_index(template)) 2024-02-01 23:15:34 bookstack | 2024-02-01 23:15:34 bookstack | at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 2024-02-01 23:15:34 bookstack | 756▕ // If an exception occurs when attempting to run a query, we'll format the error 2024-02-01 23:15:34 bookstack | 757▕ // message to include the bindings with SQL, which will make this exception a 2024-02-01 23:15:34 bookstack | 758▕ // lot more helpful to the developer instead of just the database's errors. 2024-02-01 23:15:34 bookstack | 759▕ catch (Exception $e) { 2024-02-01 23:15:34 bookstack | ➜ 760▕ throw new QueryException( 2024-02-01 23:15:34 bookstack | 761▕ $query, $this->prepareBindings($bindings), $e 2024-02-01 23:15:34 bookstack | 762▕ ); 2024-02-01 23:15:34 bookstack | 763▕ } 2024-02-01 23:15:34 bookstack | 764▕ } 2024-02-01 23:15:34 bookstack | 2024-02-01 23:15:34 bookstack | +18 vendor frames 2024-02-01 23:15:34 bookstack | 19 /app/www/database/migrations/2019_07_07_112515_add_template_support.php:17 2024-02-01 23:15:34 bookstack | Illuminate\Support\Facades\Facade::__callStatic() 2024-02-01 23:15:34 bookstack | 2024-02-01 23:15:34 bookstack | +25 vendor frames 2024-02-01 23:15:34 bookstack | 45 /app/www/artisan:35 2024-02-01 23:15:34 bookstack | Illuminate\Foundation\Console\Kernel::handle() 2024-02-01 23:15:35 bookstack | [custom-init] No custom files found, skipping... 2024-02-01 23:15:35 bookstack | [ls.io-init] done.

Thank you

j0nnymoe commented 5 months ago

Your issue might be due to using a windows host, we've had reports of this before with no solution : https://github.com/linuxserver/docker-bookstack/issues/125

jpquinta commented 5 months ago

Thank you, for the tip. Solved the issue 👍

JP