Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

v2 beta - embedded mariadb fails to initialise #5279

Closed
1 task done
high3eam opened this issue Oct 29, 2024 · 24 comments Β· Fixed by #5283
Closed
1 task done

v2 beta - embedded mariadb fails to initialise #5279

high3eam opened this issue Oct 29, 2024 · 24 comments Β· Fixed by #5283
Labels
bug Something isn't working releaseblocker blocking bugs encountered with a new release

Comments

@high3eam
Copy link

high3eam commented Oct 29, 2024

πŸ“‘ I have found these related issues/pull requests

none

πŸ›‘οΈ Security Policy

Description

Tried to create a new docker based uptime kuma instance with embedded mariadb, but mariadb cannot initialise properly and goes into start and stop loop.

πŸ‘Ÿ Reproduction steps

Create a new uptime kuma instance with docker using this docker compose file:

services:
    uptime-kuma:
        image: louislam/uptime-kuma:beta
        container_name: uptime-kuma
        volumes:
          - ./uptime-kuma-data:/app/data
        ports:
          - 3001:3001
        restart: unless-stopped

πŸ‘€ Expected behavior

Uptime Kuma would finalise the initialisation of the embedded mariadb

πŸ˜“ Actual Behavior

start and stop loop of mariadb

🐻 Uptime-Kuma Version

2.0.0-beta.0

πŸ’» Operating System and Arch

Debian 12.7 amd64

🌐 Browser

Edge v130

πŸ–₯️ Deployment Environment

  • Runtime:
  • Database:
  • Filesystem used to store the database on:
  • number of monitors: 0

πŸ“ Relevant log output

Docker compose log output (click to expand)
uptime-kuma  | Welcome to Uptime Kuma
uptime-kuma  | Your Node.js version: 20.18.0
uptime-kuma  | 2024-10-29T20:56:12Z [SERVER] INFO: Env: production
uptime-kuma  | 2024-10-29T20:56:13Z [SERVER] INFO: Uptime Kuma Version: 2.0.0-beta.0
uptime-kuma  | 2024-10-29T20:56:13Z [SERVER] INFO: Loading modules
uptime-kuma  | 2024-10-29T20:56:14Z [SERVER] INFO: Creating express and socket.io instance
uptime-kuma  | 2024-10-29T20:56:14Z [SERVER] INFO: Server Type: HTTP
uptime-kuma  | 2024-10-29T20:56:14Z [SERVER] INFO: Data Dir: ./data/
uptime-kuma  | 2024-10-29T20:56:14Z [SETUP-DATABASE] INFO: db-config.json is not found or invalid: ENOENT: no such file or directory, open 'data/db-config.json'
uptime-kuma  | 2024-10-29T20:56:14Z [SETUP-DATABASE] INFO: Starting Setup Database on 3001
uptime-kuma  | 2024-10-29T20:56:14Z [SETUP-DATABASE] INFO: Open http://localhost:3001 in your browser
uptime-kuma  | 2024-10-29T20:56:14Z [SETUP-DATABASE] INFO: Waiting for user action...
uptime-kuma  | Request /setup-database-info
uptime-kuma  | Request /setup-database-info
uptime-kuma  | Request /setup-database-info
uptime-kuma  | Request /setup-database-info
uptime-kuma  | Request /setup-database-info
uptime-kuma  | Request /setup-database-info
uptime-kuma  | 2024-10-29T20:56:26Z [SETUP-DATABASE] INFO: Database is configured, close the setup-database server and start the main server now.
uptime-kuma  | 2024-10-29T20:56:26Z [SETUP-DATABASE] INFO: The setup-database server is closed
uptime-kuma  | 2024-10-29T20:56:26Z [DB] INFO: Database Type: embedded-mariadb
uptime-kuma  | 2024-10-29T20:56:26Z [MARIADB] INFO: Embedded MariaDB: /app/data/mariadb is not found, create one now.
uptime-kuma  | 2024-10-29T20:56:28Z [MARIADB] INFO: Embedded MariaDB: mysql_install_db done:Installing MariaDB/MySQL system tables in '/app/data/mariadb' ...
uptime-kuma  | OK
uptime-kuma  |
uptime-kuma  | To start mariadbd at boot time you have to copy
uptime-kuma  | support-files/mariadb.service to the right place for your system
uptime-kuma  |
uptime-kuma  |
uptime-kuma  | Two all-privilege accounts were created.
uptime-kuma  | One is root@localhost, it has no password, but you need to
uptime-kuma  | be system 'root' user to connect. Use, for example, sudo mysql
uptime-kuma  | The second is node@localhost, it has no password either, but
uptime-kuma  | you need to be the system 'node' user to connect.
uptime-kuma  | After connecting you can set the password, if you would need to be
uptime-kuma  | able to connect as any of these users with a password and without sudo
uptime-kuma  |
uptime-kuma  | See the MariaDB Knowledgebase at https://mariadb.com/kb
uptime-kuma  |
uptime-kuma  | You can start the MariaDB daemon with:
uptime-kuma  | cd '/usr' ; /usr/bin/mariadb-safe --datadir='/app/data/mariadb'
uptime-kuma  |
uptime-kuma  | You can test the MariaDB daemon with mysql-test-run.pl
uptime-kuma  | cd '/usr/share/mysql/mysql-test' ; perl mariadb-test-run.pl
uptime-kuma  |
uptime-kuma  | Please report any problems at https://mariadb.org/jira
uptime-kuma  |
uptime-kuma  | The latest information about MariaDB is available at https://mariadb.org/.
uptime-kuma  |
uptime-kuma  | Consider joining MariaDB's strong and vibrant community:
uptime-kuma  | https://mariadb.org/get-involved/
uptime-kuma  |
uptime-kuma  |
uptime-kuma  | 2024-10-29T20:56:28Z [MARIADB] INFO: Embedded MariaDB: /app/data/run/mariadb is not found, create one now.
uptime-kuma  | 2024-10-29T20:56:28Z [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma  | 2024-10-29T20:56:28Z [MARIADB] INFO: Stopped Embedded MariaDB: 1
uptime-kuma  | 2024-10-29T20:56:28Z [MARIADB] INFO: Try to restart Embedded MariaDB as it is not stopped by user
uptime-kuma  | 2024-10-29T20:56:28Z [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Stopped Embedded MariaDB: 1
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Try to restart Embedded MariaDB as it is not stopped by user
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Stopped Embedded MariaDB: 1
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Try to restart Embedded MariaDB as it is not stopped by user
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Waiting for Embedded MariaDB to start...
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Stopped Embedded MariaDB: 1
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Try to restart Embedded MariaDB as it is not stopped by user
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma  | 2024-10-29T20:56:29Z [MARIADB] INFO: Waiting for Embedded MariaDB to start...
uptime-kuma  | 2024-10-29T20:56:30Z [MARIADB] INFO: Stopped Embedded MariaDB: 1
@high3eam high3eam added the bug Something isn't working label Oct 29, 2024
@CommanderStorm CommanderStorm added the releaseblocker blocking bugs encountered with a new release label Oct 29, 2024
@c3p0vsr2d2
Copy link

c3p0vsr2d2 commented Oct 30, 2024

same error on previous 2 or 3 nightlies.
Sorry, was too lazy to report it.

@louislam
Copy link
Owner

louislam commented Oct 30, 2024

Is it rootless image? If yes:

⚠️ If file permission is not set correctly, Uptime Kuma will run into startup issues. You should set the data directory to node:node (1001:1001) user.

@c3p0vsr2d2
Copy link

c3p0vsr2d2 commented Oct 30, 2024

I am not using rootless, but there was also this recent change to remove USER node from the docker build file.
Will retry with 1001:1001 set.

@c3p0vsr2d2
Copy link

2.0.0-beta.0 (not the rootless image) has same issue with embedded mariadb initialization.
data directory set to root permissions
Logs show:

2024-10-29T20:56:43-07:00 [MARIADB] INFO: Stopped Embedded MariaDB: 1
2024-10-29T20:56:43-07:00 [MARIADB] INFO: Try to restart Embedded MariaDB as it is not stopped by user
2024-10-29T20:56:43-07:00 [MARIADB] INFO: Starting Embedded MariaDB
2024-10-29T20:56:43-07:00 [MARIADB] INFO: Waiting for Embedded MariaDB to start...
2024-10-29T20:56:43-07:00 [MARIADB] INFO: Waiting for Embedded MariaDB to start...
2024-10-29T20:56:43-07:00 [MARIADB] INFO: Waiting for Embedded MariaDB to start...
...

@louislam
Copy link
Owner

@high3eam @c3p0vsr2d2 I just enabled MariaDB log to console. You could try the nightly2 image.

@high3eam
Copy link
Author

@louislam I get this log output with nightly2 (non-rootless):

Nightly2 log
uptime-kuma  | Welcome to Uptime Kuma
uptime-kuma  | Your Node.js version: 20.18.0
uptime-kuma  | 2024-10-30T08:53:01Z [SERVER] INFO: Env: production
uptime-kuma  | 2024-10-30T08:53:02Z [SERVER] INFO: Uptime Kuma Version: 2.0.0-beta.0-nightly-20241030074209
uptime-kuma  | 2024-10-30T08:53:02Z [SERVER] INFO: Loading modules
uptime-kuma  | 2024-10-30T08:53:03Z [SERVER] INFO: Creating express and socket.io instance
uptime-kuma  | 2024-10-30T08:53:03Z [SERVER] INFO: Server Type: HTTP
uptime-kuma  | 2024-10-30T08:53:03Z [SERVER] INFO: Data Dir: ./data/
uptime-kuma  | 2024-10-30T08:53:03Z [SETUP-DATABASE] INFO: db-config.json is not found or invalid: ENOENT: no such file or directory, open 'data/db-config.json'
uptime-kuma  | 2024-10-30T08:53:03Z [SETUP-DATABASE] INFO: Starting Setup Database on 3001
uptime-kuma  | 2024-10-30T08:53:03Z [SETUP-DATABASE] INFO: Open http://localhost:3001 in your browser
uptime-kuma  | 2024-10-30T08:53:03Z [SETUP-DATABASE] INFO: Waiting for user action...
uptime-kuma  | Request /setup-database-info
uptime-kuma  | 2024-10-30T08:53:14Z [SETUP-DATABASE] INFO: Database is configured, close the setup-database server and start the main server now.
uptime-kuma  | 2024-10-30T08:53:14Z [SETUP-DATABASE] INFO: The setup-database server is closed
uptime-kuma  | 2024-10-30T08:53:14Z [DB] INFO: Database Type: embedded-mariadb
uptime-kuma  | 2024-10-30T08:53:14Z [MARIADB] INFO: Embedded MariaDB: /app/data/mariadb is not found, create one now.
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: Embedded MariaDB: mysql_install_db done:Installing MariaDB/MySQL system tables in '/app/data/mariadb' ...
uptime-kuma  | OK
uptime-kuma  |
uptime-kuma  | To start mariadbd at boot time you have to copy
uptime-kuma  | support-files/mariadb.service to the right place for your system
uptime-kuma  |
uptime-kuma  |
uptime-kuma  | Two all-privilege accounts were created.
uptime-kuma  | One is root@localhost, it has no password, but you need to
uptime-kuma  | be system 'root' user to connect. Use, for example, sudo mysql
uptime-kuma  | The second is node@localhost, it has no password either, but
uptime-kuma  | you need to be the system 'node' user to connect.
uptime-kuma  | After connecting you can set the password, if you would need to be
uptime-kuma  | able to connect as any of these users with a password and without sudo
uptime-kuma  |
uptime-kuma  | See the MariaDB Knowledgebase at https://mariadb.com/kb
uptime-kuma  |
uptime-kuma  | You can start the MariaDB daemon with:
uptime-kuma  | cd '/usr' ; /usr/bin/mariadb-safe --datadir='/app/data/mariadb'
uptime-kuma  |
uptime-kuma  | You can test the MariaDB daemon with mysql-test-run.pl
uptime-kuma  | cd '/usr/share/mysql/mysql-test' ; perl mariadb-test-run.pl
uptime-kuma  |
uptime-kuma  | Please report any problems at https://mariadb.org/jira
uptime-kuma  |
uptime-kuma  | The latest information about MariaDB is available at https://mariadb.org/.
uptime-kuma  |
uptime-kuma  | Consider joining MariaDB's strong and vibrant community:
uptime-kuma  | https://mariadb.org/get-involved/
uptime-kuma  |
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: Embedded MariaDB: /app/data/run/mariadb is not found, create one now.
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: mariadbd: Can't create file '/app/data/mariadb-error.log' (errno: 13 "Permission denied")
uptime-kuma  | 2024-10-30  8:53:15 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 86
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: Number of transaction pools: 1
uptime-kuma  | 2024-10-30  8:53:15 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
uptime-kuma  | 2024-10-30  8:53:15 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 95
uptime-kuma  | 2024-10-30  8:53:15 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: Completed initialization of buffer pool
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: End of log at LSN=46996
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: 128 rollback segments are active.
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: log sequence number 46996; transaction id 14
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] Plugin 'FEEDBACK' is disabled.
uptime-kuma  | 2024-10-30  8:53:15 0 [Note] InnoDB: Loading buffer pool(s) from /app/data/mariadb/ib_buffer_pool
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] InnoDB: Buffer pool(s) load completed at 241030  8:53:15
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [Note] Server socket created on IP: '127.0.0.1'.
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:15Z [MARIADB] INFO: 2024-10-30  8:53:15 0 [ERROR] Can't start server : Bind on unix socket: Permission denied
uptime-kuma  | 2024-10-30  8:53:15 0 [ERROR] Do you already have another server running on socket: /app/data/run/mariadb/mysqld.sock ?
uptime-kuma  | 2024-10-30  8:53:15 0 [ERROR] Aborting
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: Stopped Embedded MariaDB: 1
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] ERROR: Try to restart Embedded MariaDB as it is not stopped by user
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: mariadbd: Can't create file '/app/data/mariadb-error.log' (errno: 13 "Permission denied")
uptime-kuma  | 2024-10-30  8:53:16 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 97
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: Number of transaction pools: 1
uptime-kuma  | 2024-10-30  8:53:16 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
uptime-kuma  | 2024-10-30  8:53:16 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
uptime-kuma  | 2024-10-30  8:53:16 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 95
uptime-kuma  | 2024-10-30  8:53:16 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: Completed initialization of buffer pool
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: End of log at LSN=46996
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: 128 rollback segments are active.
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma  | 2024-10-30  8:53:16 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: log sequence number 46996; transaction id 14
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] Plugin 'FEEDBACK' is disabled.
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] InnoDB: Loading buffer pool(s) from /app/data/mariadb/ib_buffer_pool
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [Note] Server socket created on IP: '127.0.0.1'.
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: 2024-10-30  8:53:16 0 [ERROR] Can't start server : Bind on unix socket: Permission denied
uptime-kuma  | 2024-10-30  8:53:16 0 [ERROR] Do you already have another server running on socket: /app/data/run/mariadb/mysqld.sock ?
uptime-kuma  | 2024-10-30  8:53:16 0 [ERROR] Aborting
uptime-kuma  |
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] INFO: Stopped Embedded MariaDB: 1
uptime-kuma  | 2024-10-30T08:53:16Z [MARIADB] ERROR: Try to restart Embedded MariaDB as it is not stopped by user

@louislam
Copy link
Owner

[ERROR] Can't start server : Bind on unix socket: Permission denied

That is strange... Have to find a way to 100% reproduce this. I cannot reproduce it on my Linux machine.

@N0Klu3
Copy link

N0Klu3 commented Oct 30, 2024

I have this same issue, its a fresh install of Bookworm on RPi5, running Portainer.
Compose:

version: '3.3'
services:
  uptime-kuma:
    image: louislam/uptime-kuma:beta
    container_name: uptime-kuma
    volumes:
      - uptime-kuma:/app/data
    ports:
      - "3005:3001"
    restart: unless-stopped

volumes:
  uptime-kuma:

I get the exact same:

[MARIADB] INFO: Try to restart Embedded MariaDB as it is not stopped by user
[MARIADB] INFO: Starting Embedded MariaDB
[MARIADB] INFO: Waiting for Embedded MariaDB to start...

This was a fresh install of UK not a migration.
My migration funnily did work just fine on another RPi5 system.

EDIT
Ironically switching to beta-rootless gets it started and working fine with Embedded MariaDB
Did the builds get switched by any chance?
The notes say: Unable to use embedded MariaDB, you will need to use external MariaDB.
But seems to work better than the 'beta' build?

This is using beta-rootless

2024-10-30T22:35:58Z [MARIADB] INFO: Embedded MariaDB: /app/data/run/mariadb is not found, create one now.
2024-10-30T22:35:58Z [MARIADB] INFO: Starting Embedded MariaDB
2024-10-30T22:35:58Z [MARIADB] INFO: Embedded MariaDB is ready for connections
2024-10-30T22:35:59Z [MARIADB] INFO: Embedded MariaDB started
2024-10-30T22:35:59Z [MARIADB] INFO: Creating basic tables for MariaDB
2024-10-30T22:36:00Z [MARIADB] INFO: Created basic tables for MariaDB
2024-10-30T22:36:00Z [SERVER] INFO: Connected to the database
2024-10-30T22:36:00Z [MIGRATION] INFO: Migration server is running on http://localhost:3001
2024-10-30T22:36:00Z [DB] INFO: Migrating Aggregate Table
2024-10-30T22:36:00Z [DB] INFO: Getting list of unique monitors
2024-10-30T22:36:00Z [DB] INFO: Clearing non-important heartbeats
2024-10-30T22:36:00Z [DB] INFO: No data to migrate

@louislam the above might help?

@louislam
Copy link
Owner

louislam commented Oct 31, 2024

Bookworm on RPi5

@N0Klu3 Thanks for your hints! I just reproduce this issue on my Pi4 too.

@N0Klu3
Copy link

N0Klu3 commented Oct 31, 2024

Bookworm on RPi5

@N0Klu3 Thanks for your hints! I just reproduce this issue on my Pi4 too.

Can you confirm that beta-rootless should not have Embedded MariaDB working? As it seems to work just fine?
Or maybe I just misunderstood the upgrade notes?

If it does work, why use non-root over root? Seems like if it works, running it as beta-rootless would be the better options no?

@louislam
Copy link
Owner

louislam commented Oct 31, 2024

Bookworm on RPi5

@N0Klu3 Thanks for your hints! I just reproduce this issue on my Pi4 too.

Can you confirm that beta-rootless should not have Embedded MariaDB working? As it seems to work just fine? Or maybe I just misunderstood the upgrade notes?

If it does work, why use non-root over root? Seems like if it works, running it as beta-rootless would be the better options no?

Since I implemented this feature last year, the migration guide which I prepared recently was wrong. (I just updated) It should work on both the rootless and the root images.

Actually all issues are probably related to the file permissions. I try my best to handle it smoothly for everyone.

beta-rootless should have better security if you don't need Docker monitors via docker.sock.

@N0Klu3
Copy link

N0Klu3 commented Oct 31, 2024

Since I implemented this feature last year, the migration guide which I prepared recently was wrong. (I just updated) It should work on both the rootless and the root images.

Actually all issues probably the file permissions. I try my best to handle it smoothly for everyone.

beta-rootless should have better security if you don't need Docker monitors via docker.sock.

Perfect thank you!
beta-rootless it is then :)

@louislam louislam linked a pull request Oct 31, 2024 that will close this issue
@c3p0vsr2d2
Copy link

none of the latest root/rootless images work for me.
tried both the latest nighly2 and beta tagged images.
is there a v2 image that does not have this issue?

@louislam
Copy link
Owner

louislam commented Nov 2, 2024

It seems that I have fixed the issue in the nightly2, anyone would like to help to confirm that? Thanks.

docker pull louislam/uptime-kuma:nightly2
docker pull louislam/uptime-kuma:nightly2-rootless

@homelab-alpha
Copy link
Contributor

homelab-alpha commented Nov 2, 2024

It seems that I have fixed the issue in the nightly2, anyone would like to help to confirm that? Thanks.

docker pull louislam/uptime-kuma:nightly2
docker pull louislam/uptime-kuma:nightly2-rootless

I tested nightly2 and still have the problem with the built-in MariaDB.

πŸ‘Ÿ Reproduction steps:

Here is the docker-compose.yml file (click to expand)

---
networks:
  uptime-kuma-beta_net:
    attachable: false
    internal: false
    external: false
    name: uptime-kuma-beta
    driver: bridge
    ipam:
      driver: default
      config:
        - subnet: 172.20.3.0/24
          ip_range: 172.20.3.0/24
          gateway: 172.20.3.1
    driver_opts:
      com.docker.network.bridge.default_bridge: "false"
      com.docker.network.bridge.enable_icc: "true"
      com.docker.network.bridge.enable_ip_masquerade: "true"
      com.docker.network.bridge.host_binding_ipv4: "0.0.0.0"
      com.docker.network.bridge.name: "uptime-kuma"
      com.docker.network.driver.mtu: "1500"
    labels:
      com.uptime-kuma-beta.network.description: "is an isolated bridge network."

services:
  uptime-kuma-beta_app:
    restart: unless-stopped
    logging:
      driver: "json-file"
      options:
        max-size: "1M"
        max-file: "2"
    stop_grace_period: 1m
    container_name: uptime-kuma-beta
    image: louislam/uptime-kuma:nightly2
    pull_policy: if_not_present
    volumes:
      - /docker/uptime-kuma-beta/app:/app/data
      - /var/run/docker.sock:/var/run/docker.sock:ro
      - /usr/local/share/ca-certificates:/app/data/docker-tls
    environment:
      PUID: "1000"
      PGID: "1000"
      TZ: Europe/Amsterdam
      # NODE_EXTRA_CA_CERTS: /app/data/docker-tls/demo.cert # This is a demo certificate.
    domainname: status.local
    hostname: status
    networks:
      uptime-kuma-beta_net:
        ipv4_address: 172.20.3.3
    ports:
      - "3001:3001/tcp" # HTTP
      - "3001:3001/udp" # HTTP
    security_opt:
      - no-new-privileges:true
    labels:
      com.docker.compose.project: "uptime-kuma-beta"
      com.uptime-kuma-beta.description:
        "is an self-hosted monitoring tool that allows you to monitor uptime,
        status, and notifications for various services and domains."
    healthcheck:
      disable: true

🐻 Uptime-Kuma Version
Version: nightly2

πŸ’» Operating System and Arch
Ubuntu Server 24.04.1 LTS (GNU/Linux 6.8.0-48-generic x86_64)

🌐 Browser
Brave version 1.71.121 (Chromium: 130.0.6723.91) (Official Build) (64-bit)

πŸ–₯️ Deployment Environment
Runtime: Docker version 26.1.0, build 9714adc
Runtime: docker-compose version 1.29.2, build unknown
Runtime: Portainer Business Edition version 2.21.4
Database: MariaDB (embedded)
Filesystem used for the database: Linux/ext4 on an SSD
Number of monitors: 0

Relevant log output (click to expand)

β”Œβ”€β”€(homelab-alpha@test-server)-[/docker/uptime-kuma-beta]
└─$sudo docker-compose up --remove-orphans
Creating network "uptime-kuma-beta" with driver "bridge"
Pulling uptime-kuma-beta_app (louislam/uptime-kuma:nightly2)...
nightly2: Pulling from louislam/uptime-kuma
a480a496ba95: Pull complete
07574ed847ca: Pull complete
2291004efc7a: Pull complete
b991b65dcbd5: Pull complete
2816f5bc428c: Pull complete
759a9d6de00b: Pull complete
c5c931bca37c: Pull complete
17a6f85699e8: Pull complete
e21f8cdf23aa: Pull complete
57a18d7aff9b: Pull complete
f3ce267d0ae9: Pull complete
9b65c38c4fbd: Pull complete
23079134dd94: Pull complete
e6a053232f55: Pull complete
e4105961c628: Pull complete
Digest: sha256:88584b62bb2f543de161f31d0a323b508c09728731a8e483fd8c17212d8bdccd
Status: Downloaded newer image for louislam/uptime-kuma:nightly2
Creating uptime-kuma-beta ... done
Attaching to uptime-kuma-beta
uptime-kuma-beta        | Welcome to Uptime Kuma
uptime-kuma-beta        | Your Node.js version: 20.18.0
uptime-kuma-beta        | 2024-11-02T12:06:50+01:00 [SERVER] INFO: Env: production
uptime-kuma-beta        | 2024-11-02T12:06:51+01:00 [SERVER] INFO: Uptime Kuma Version: 2.0.0-beta.0-nightly-20241102095533
uptime-kuma-beta        | 2024-11-02T12:06:51+01:00 [SERVER] INFO: Loading modules
uptime-kuma-beta        | 2024-11-02T12:06:51+01:00 [SERVER] INFO: Creating express and socket.io instance
uptime-kuma-beta        | 2024-11-02T12:06:51+01:00 [SERVER] INFO: Server Type: HTTP
uptime-kuma-beta        | 2024-11-02T12:06:51+01:00 [SERVER] INFO: Data Dir: ./data/
uptime-kuma-beta        | 2024-11-02T12:06:51+01:00 [SETUP-DATABASE] INFO: db-config.json is not found or invalid: ENOENT: no such file or directory, open 'data/db-config.json'
uptime-kuma-beta        | 2024-11-02T12:06:51+01:00 [SETUP-DATABASE] INFO: Starting Setup Database on 3001
uptime-kuma-beta        | 2024-11-02T12:06:51+01:00 [SETUP-DATABASE] INFO: Open http://localhost:3001 in your browser
uptime-kuma-beta        | 2024-11-02T12:06:51+01:00 [SETUP-DATABASE] INFO: Waiting for user action...
uptime-kuma-beta        | Request /setup-database-info
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [SETUP-DATABASE] INFO: Database is configured, close the setup-database server and start the main server now.
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [SETUP-DATABASE] INFO: The setup-database server is closed
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [DB] INFO: Database Type: embedded-mariadb
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 18
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: The first data file './ibdata1' did not exist. A new tablespace will be created!
uptime-kuma-beta        | 2024-11-02 12:07:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: Number of transaction pools: 1
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 2
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: Completed initialization of buffer pool
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: Setting file './ibdata1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: File './ibdata1' size is now 12.000MiB.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: Doublewrite buffer not found: creating new
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: 128 rollback segments are active.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] InnoDB: log sequence number 0; transaction id 3
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] Plugin 'FEEDBACK' is disabled.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [Note] Server socket created on IP: '127.0.0.1'.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:34+01:00 [MARIADB] INFO: 2024-11-02 12:07:34 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
uptime-kuma-beta        | 2024-11-02 12:07:34 0 [ERROR] Aborting
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: Stopped Embedded MariaDB: 1
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] ERROR: Try to restart Embedded MariaDB as it is not stopped by user
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 34
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: Number of transaction pools: 1
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
uptime-kuma-beta        | 2024-11-02 12:07:35 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 0
uptime-kuma-beta        | 2024-11-02 12:07:35 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: Completed initialization of buffer pool
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: End of log at LSN=36397
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: 128 rollback segments are active.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma-beta        | 2024-11-02 12:07:35 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: log sequence number 36397; transaction id 4
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: Loading buffer pool(s) from /app/data/mariadb/ib_buffer_pool
uptime-kuma-beta        | 2024-11-02 12:07:35 0 [Note] Plugin 'FEEDBACK' is disabled.
uptime-kuma-beta        | 2024-11-02 12:07:35 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] InnoDB: Buffer pool(s) load completed at 241102 12:07:35
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [Note] Server socket created on IP: '127.0.0.1'.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-02T12:07:35+01:00 [MARIADB] INFO: 2024-11-02 12:07:35 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
uptime-kuma-beta        | 2024-11-02 12:07:35 0 [ERROR] Aborting
uptime-kuma-beta        |
^CGracefully stopping... (press Ctrl+C again to force)
Stopping uptime-kuma-beta ... done

β”Œβ”€β”€(homelab-alpha@test-server)-[/docker/uptime-kuma-beta]
└─$ sudo docker-compose down
Removing uptime-kuma-beta ... done
Removing network uptime-kuma-beta

@CommanderStorm CommanderStorm pinned this issue Nov 2, 2024
@high3eam
Copy link
Author

high3eam commented Nov 2, 2024

The error changed but I also still have an issue with the embedded mariadb after repulling nightly2 on my Debian 12 amd64 host to try a fresh install:

Docker Compose Log
 uptime-kuma  | Welcome to Uptime Kuma
uptime-kuma  | Your Node.js version: 20.18.0
uptime-kuma  | 2024-11-02T12:30:26Z [SERVER] INFO: Env: production
uptime-kuma  | 2024-11-02T12:30:27Z [SERVER] INFO: Uptime Kuma Version: 2.0.0-beta.0-nightly-20241102095533
uptime-kuma  | 2024-11-02T12:30:27Z [SERVER] INFO: Loading modules
uptime-kuma  | 2024-11-02T12:30:27Z [SERVER] INFO: Creating express and socket.io instance
uptime-kuma  | 2024-11-02T12:30:27Z [SERVER] INFO: Server Type: HTTP
uptime-kuma  | 2024-11-02T12:30:27Z [SERVER] INFO: Data Dir: ./data/
uptime-kuma  | 2024-11-02T12:30:27Z [SETUP-DATABASE] INFO: db-config.json is not found or invalid: ENOENT: no such file or directory, open 'data/db-config.json'
uptime-kuma  | 2024-11-02T12:30:28Z [SETUP-DATABASE] INFO: Starting Setup Database on 3001
uptime-kuma  | 2024-11-02T12:30:28Z [SETUP-DATABASE] INFO: Open http://localhost:3001 in your browser
uptime-kuma  | 2024-11-02T12:30:28Z [SETUP-DATABASE] INFO: Waiting for user action...
uptime-kuma  | Request /setup-database-info
uptime-kuma  | 2024-11-02T12:30:41Z [SETUP-DATABASE] INFO: Database is configured, close the setup-database server and start the main server now.
uptime-kuma  | 2024-11-02T12:30:41Z [SETUP-DATABASE] INFO: The setup-database server is closed
uptime-kuma  | 2024-11-02T12:30:41Z [DB] INFO: Database Type: embedded-mariadb
uptime-kuma  | 2024-11-02T12:30:41Z [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma  | 2024-11-02T12:30:41Z [MARIADB] INFO: 2024-11-02 12:30:41 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 30
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:41Z [MARIADB] INFO: 2024-11-02 12:30:41 0 [Note] InnoDB: The first data file './ibdata1' did not exist. A new tablespace will be created!
uptime-kuma  | 2024-11-02 12:30:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:41Z [MARIADB] INFO: 2024-11-02 12:30:41 0 [Note] InnoDB: Number of transaction pools: 1
uptime-kuma  | 2024-11-02 12:30:41 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:41Z [MARIADB] INFO: 2024-11-02 12:30:41 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
uptime-kuma  | 2024-11-02 12:30:41 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 95
uptime-kuma  | 2024-11-02 12:30:41 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:41Z [MARIADB] INFO: 2024-11-02 12:30:41 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Completed initialization of buffer pool
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Setting file './ibdata1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma  | 2024-11-02 12:30:42 0 [Note] InnoDB: File './ibdata1' size is now 12.000MiB.
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Doublewrite buffer not found: creating new
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: 128 rollback segments are active.
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma  | 2024-11-02 12:30:42 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: log sequence number 0; transaction id 3
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] Plugin 'FEEDBACK' is disabled.
uptime-kuma  | 2024-11-02 12:30:42 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
uptime-kuma  | 2024-11-02 12:30:42 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] Server socket created on IP: '127.0.0.1'.
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
uptime-kuma  | 2024-11-02 12:30:42 0 [ERROR] Aborting
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: Stopped Embedded MariaDB: 1
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] ERROR: Try to restart Embedded MariaDB as it is not stopped by user
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 49
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Number of transaction pools: 1
uptime-kuma  | 2024-11-02 12:30:42 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
uptime-kuma  | 2024-11-02 12:30:42 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
uptime-kuma  | 2024-11-02 12:30:42 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 95
uptime-kuma  | 2024-11-02 12:30:42 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Completed initialization of buffer pool
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: End of log at LSN=36397
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: 128 rollback segments are active.
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: log sequence number 36397; transaction id 4
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Loading buffer pool(s) from /app/data/mariadb/ib_buffer_pool
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] Plugin 'FEEDBACK' is disabled.
uptime-kuma  | 2024-11-02 12:30:42 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] InnoDB: Buffer pool(s) load completed at 241102 12:30:42
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [Note] Server socket created on IP: '127.0.0.1'.
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: 2024-11-02 12:30:42 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
uptime-kuma  | 2024-11-02 12:30:42 0 [ERROR] Aborting
uptime-kuma  |
uptime-kuma  | 2024-11-02T12:30:42Z [MARIADB] INFO: Stopped Embedded MariaDB: 1

@louislam
Copy link
Owner

louislam commented Nov 2, 2024

@homelab-alpha @high3eam Thanks, I also could reproduce on my another linux.

@louislam
Copy link
Owner

louislam commented Nov 5, 2024

i think i found the problem, the mariadb did not initiatized correctly.

Free feel to try again the nightly build, but ./data/mariadb have to be deleted before start.

@homelab-alpha
Copy link
Contributor

i think i found the problem, the mariadb did not initiatized correctly.

Free feel to try again the nightly build, but ./data/mariadb have to be deleted before start.

I can confirm that it is working now. See the logs.

I have a question:

I noticed the comment in server/embedded-mariadb.js saying:

"Check the owner of the MariaDB directory, and change it if necessary."

This suggests setting the owner to UID 1000 and GID 1000.

However, not all systems start with UID 1000 and GID 1000. For example:

  • Ubuntu Server 24.04.1 LTS (GNU/Linux 6.8.0-48-generic x86_64) starts with UID 1000 and GID 1000.
  • Ubuntu Server 24.04.1 LTS (GNU/Linux 6.8.0-1013-raspi aarch64) starts with UID 1001 and GID 1001.

I might be wrong, but I'll also test it today on a Raspberry Pi 4 with Ubuntu Server 24.04.1 LTS (GNU/Linux 6.8.0-1013-raspi aarch64).

I'll let you know the outcome.

πŸ‘Ÿ Reproduction steps:

Here is the docker-compose.yml file (click to expand)

---
networks:
  uptime-kuma-beta_net:
    attachable: false
    internal: false
    external: false
    name: uptime-kuma-beta
    driver: bridge
    ipam:
      driver: default
      config:
        - subnet: 172.20.3.0/24
          ip_range: 172.20.3.0/24
          gateway: 172.20.3.1
    driver_opts:
      com.docker.network.bridge.default_bridge: "false"
      com.docker.network.bridge.enable_icc: "true"
      com.docker.network.bridge.enable_ip_masquerade: "true"
      com.docker.network.bridge.host_binding_ipv4: "0.0.0.0"
      com.docker.network.bridge.name: "uptime-kuma"
      com.docker.network.driver.mtu: "1500"
    labels:
      com.uptime-kuma-beta.network.description: "is an isolated bridge network."

services:
  uptime-kuma-beta_app:
    restart: unless-stopped
    logging:
      driver: "json-file"
      options:
        max-size: "1M"
        max-file: "2"
    stop_grace_period: 1m
    container_name: uptime-kuma-beta
    image: louislam/uptime-kuma:nightly2
    pull_policy: if_not_present
    volumes:
      - /docker/uptime-kuma-beta/app:/app/data
      - /var/run/docker.sock:/var/run/docker.sock:ro
      - /usr/local/share/ca-certificates:/app/data/docker-tls
    environment:
      PUID: "1000"
      PGID: "1000"
      TZ: Europe/Amsterdam
      # NODE_EXTRA_CA_CERTS: /app/data/docker-tls/demo.cert # This is a demo certificate.
    domainname: status.local
    hostname: status
    networks:
      uptime-kuma-beta_net:
        ipv4_address: 172.20.3.3
    ports:
      - "3001:3001/tcp" # HTTP
      - "3001:3001/udp" # HTTP
    security_opt:
      - no-new-privileges:true
    labels:
      com.docker.compose.project: "uptime-kuma-beta"
      com.uptime-kuma-beta.description:
        "is an self-hosted monitoring tool that allows you to monitor uptime,
        status, and notifications for various services and domains."
    healthcheck:
      disable: true

🐻 Uptime-Kuma
Version: nightly2

πŸ’» Operating System and Arch
Ubuntu Server 24.04.1 LTS (GNU/Linux 6.8.0-48-generic x86_64)

🌐 Browser
Brave version 1.71.121 (Chromium: 130.0.6723.91) (Official Build) (64-bit)

πŸ–₯️ Deployment Environment
Runtime: Docker version 26.1.0, build 9714adc
Runtime: docker-compose version 1.29.2, build unknown
Runtime: Portainer Business Edition version 2.21.4
Database: MariaDB (embedded)
Filesystem used for the database: Linux/ext4 on an SSD
Number of monitors: 1

πŸ“ Relevant log output (click to expand)

β”Œβ”€β”€(homelab-alpha@test-server)-[/docker/uptime-kuma-beta]
└─$ sudo docker-compose up --remove-orphans
Creating network "uptime-kuma-beta" with driver "bridge"
Pulling uptime-kuma-beta_app (louislam/uptime-kuma:nightly2)...
nightly2: Pulling from louislam/uptime-kuma
a480a496ba95: Pull complete
07574ed847ca: Pull complete
2291004efc7a: Pull complete
b991b65dcbd5: Pull complete
2816f5bc428c: Pull complete
759a9d6de00b: Pull complete
c5c931bca37c: Pull complete
17a6f85699e8: Pull complete
e21f8cdf23aa: Pull complete
57a18d7aff9b: Pull complete
f3ce267d0ae9: Pull complete
9b65c38c4fbd: Pull complete
23079134dd94: Pull complete
4ae42a5df533: Pull complete
a1216be29832: Pull complete
Digest: sha256:8cdeb88a5aae07eab7410d8749b2cc4151e675c2e7cd6f9d2a5809ff8d09a68d
Status: Downloaded newer image for louislam/uptime-kuma:nightly2
Creating uptime-kuma-beta ... done
Attaching to uptime-kuma-beta
uptime-kuma-beta        | Welcome to Uptime Kuma
uptime-kuma-beta        | Your Node.js version: 20.18.0
uptime-kuma-beta        | 2024-11-05T07:47:11+01:00 [SERVER] INFO: Env: production
uptime-kuma-beta        | 2024-11-05T07:47:12+01:00 [SERVER] INFO: Uptime Kuma Version: 2.0.0-beta.0-nightly-20241104172634
uptime-kuma-beta        | 2024-11-05T07:47:12+01:00 [SERVER] INFO: Loading modules
uptime-kuma-beta        | 2024-11-05T07:47:12+01:00 [SERVER] INFO: Creating express and socket.io instance
uptime-kuma-beta        | 2024-11-05T07:47:12+01:00 [SERVER] INFO: Server Type: HTTP
uptime-kuma-beta        | 2024-11-05T07:47:12+01:00 [SERVER] INFO: Data Dir: ./data/
uptime-kuma-beta        | 2024-11-05T07:47:12+01:00 [SETUP-DATABASE] INFO: db-config.json is not found or invalid: ENOENT: no such file or directory, open 'data/db-config.json'
uptime-kuma-beta        | 2024-11-05T07:47:12+01:00 [SETUP-DATABASE] INFO: Starting Setup Database on 3001
uptime-kuma-beta        | 2024-11-05T07:47:12+01:00 [SETUP-DATABASE] INFO: Open http://localhost:3001 in your browser
uptime-kuma-beta        | 2024-11-05T07:47:12+01:00 [SETUP-DATABASE] INFO: Waiting for user action...
uptime-kuma-beta        | Request /setup-database-info
uptime-kuma-beta        | 2024-11-05T07:47:21+01:00 [SETUP-DATABASE] INFO: Database is configured, close the setup-database server and start the main server now.
uptime-kuma-beta        | 2024-11-05T07:47:21+01:00 [SETUP-DATABASE] INFO: The setup-database server is closed
uptime-kuma-beta        | 2024-11-05T07:47:21+01:00 [DB] INFO: Database Type: embedded-mariadb
uptime-kuma-beta        | 2024-11-05T07:47:21+01:00 [MARIADB] INFO: Embedded MariaDB: /app/data/mariadb is not found, create one now.
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: Embedded MariaDB: mysql_install_db done:Installing MariaDB/MySQL system tables in '/app/data/mariadb' ...
uptime-kuma-beta        | OK
uptime-kuma-beta        |
uptime-kuma-beta        | To start mariadbd at boot time you have to copy
uptime-kuma-beta        | support-files/mariadb.service to the right place for your system
uptime-kuma-beta        |
uptime-kuma-beta        |
uptime-kuma-beta        | Two all-privilege accounts were created.
uptime-kuma-beta        | One is root@localhost, it has no password, but you need to
uptime-kuma-beta        | be system 'root' user to connect. Use, for example, sudo mysql
uptime-kuma-beta        | The second is node@localhost, it has no password either, but
uptime-kuma-beta        | you need to be the system 'node' user to connect.
uptime-kuma-beta        | After connecting you can set the password, if you would need to be
uptime-kuma-beta        | able to connect as any of these users with a password and without sudo
uptime-kuma-beta        |
uptime-kuma-beta        | See the MariaDB Knowledgebase at https://mariadb.com/kb
uptime-kuma-beta        |
uptime-kuma-beta        | You can start the MariaDB daemon with:
uptime-kuma-beta        | cd '/usr' ; /usr/bin/mariadb-safe --datadir='/app/data/mariadb'
uptime-kuma-beta        |
uptime-kuma-beta        | You can test the MariaDB daemon with mysql-test-run.pl
uptime-kuma-beta        | cd '/usr/share/mysql/mysql-test' ; perl mariadb-test-run.pl
uptime-kuma-beta        |
uptime-kuma-beta        | Please report any problems at https://mariadb.org/jira
uptime-kuma-beta        |
uptime-kuma-beta        | The latest information about MariaDB is available at https://mariadb.org/.
uptime-kuma-beta        |
uptime-kuma-beta        | Consider joining MariaDB s strong and vibrant community:
uptime-kuma-beta        | https://mariadb.org/get-involved/
uptime-kuma-beta        |
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: Embedded MariaDB: /app/data/run is not found, create one now.
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 77
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: Number of transaction pools: 1
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
uptime-kuma-beta        | 2024-11-05  7:47:22 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 0
uptime-kuma-beta        | 2024-11-05  7:47:22 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: Completed initialization of buffer pool
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: End of log at LSN=45502
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: 128 rollback segments are active.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma-beta        | 2024-11-05  7:47:22 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: log sequence number 45502; transaction id 14
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: Loading buffer pool(s) from /app/data/mariadb/ib_buffer_pool
uptime-kuma-beta        | 2024-11-05  7:47:22 0 [Note] Plugin 'FEEDBACK' is disabled.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] InnoDB: Buffer pool(s) load completed at 241105  7:47:22
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] Server socket created on IP: '127.0.0.1'.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: 2024-11-05  7:47:22 0 [Note] mariadbd: ready for connections.
uptime-kuma-beta        | Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/app/data/run/mariadb.sock'  port: 3306  Debian 12
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T07:47:22+01:00 [MARIADB] INFO: Embedded MariaDB is ready for connections
uptime-kuma-beta        | 2024-11-05T07:47:23+01:00 [MARIADB] INFO: Embedded MariaDB started
uptime-kuma-beta        | 2024-11-05T07:47:23+01:00 [MARIADB] INFO: Creating basic tables for MariaDB
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [MARIADB] INFO: Created basic tables for MariaDB
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [SERVER] INFO: Connected to the database
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [MIGRATION] INFO: Migration server is running on http://localhost:3001
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [DB] INFO: Migrating Aggregate Table
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [DB] INFO: Getting list of unique monitors
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [DB] INFO: Clearing non-important heartbeats
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [DB] INFO: No data to migrate
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [SERVER] INFO: JWT secret is not found, generate one.
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [SERVER] INFO: Stored JWT secret into database
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [SERVER] INFO: No user, need setup
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [SERVICES] INFO: Starting nscd
uptime-kuma-beta        | 2024-11-05T07:47:24+01:00 [SERVER] INFO: Listening on 3001
uptime-kuma-beta        | 2024-11-05T07:47:25+01:00 [SOCKET] INFO: New polling connection, IP = 192.168.30.2
uptime-kuma-beta        | 2024-11-05T07:47:25+01:00 [SERVER] INFO: Redirect to setup page
uptime-kuma-beta        | 2024-11-05T07:47:32+01:00 [AUTH] INFO: Login by username + password. IP=192.168.30.2
uptime-kuma-beta        | 2024-11-05T07:47:32+01:00 [RATE-LIMIT] INFO: remaining requests: 19
uptime-kuma-beta        | 2024-11-05T07:47:32+01:00 [AUTH] INFO: Successfully logged in user Uptime-Kuma. IP=192.168.30.2
uptime-kuma-beta        | 2024-11-05T07:47:50+01:00 [MANAGE] INFO: Resume Monitor: 1 User ID: 1
uptime-kuma-beta        | 2024-11-05T07:47:50+01:00 [MONITOR] INFO: Added Monitor: 1 User ID: 1
^CGracefully stopping... (press Ctrl+C again to force)
Stopping uptime-kuma-beta ... done

β”Œβ”€β”€(homelab-alpha@test-server)-[/docker/uptime-kuma-beta]
└─$ sudo docker-compose down
Removing uptime-kuma-beta ... done
Removing network uptime-kuma-beta

β”Œβ”€β”€(homelab-alpha@test-server)-[/docker/uptime-kuma-beta]
└─$ cd app && clear && tree -aAcDgpRu

[drwxr-xr-x root     root     Nov  5 07:48]  .
β”œβ”€β”€ [drwxr-xr-x root     root     Nov  5 07:47]  docker-tls
β”œβ”€β”€ [drwxr-xr-x root     root     Nov  5 07:47]  screenshots
β”œβ”€β”€ [drwxr-xr-x root     root     Nov  5 07:47]  upload
β”œβ”€β”€ [-rw-r--r-- root     root     Nov  5 07:47]  db-config.json
β”œβ”€β”€ [-rw-r--r-- root     root     Nov  5 07:48]  error.log
β”œβ”€β”€ [drwxr-xr-x homelab-alpha homelab-alpha Nov  5 07:48]  mariadb
β”‚   β”œβ”€β”€ [drwx------ homelab-alpha homelab-alpha Nov  5 07:47]  mysql
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  columns_priv.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  columns_priv.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  columns_priv.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  column_stats.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  column_stats.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  column_stats.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  db.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  db.opt
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  event.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  event.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  event.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  func.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  func.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  func.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  general_log.CSM
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  general_log.CSV
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  general_log.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  global_priv.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  gtid_slave_pos.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_category.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_keyword.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_relation.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_topic.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  index_stats.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  index_stats.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  index_stats.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  innodb_index_stats.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  innodb_table_stats.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  plugin.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  plugin.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  plugin.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  proc.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  procs_priv.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  procs_priv.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  procs_priv.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  proxies_priv.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  roles_mapping.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  roles_mapping.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  roles_mapping.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  servers.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  servers.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  servers.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  slow_log.CSM
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  slow_log.CSV
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  slow_log.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  tables_priv.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  tables_priv.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  table_stats.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  table_stats.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  table_stats.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_leap_second.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_leap_second.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_leap_second.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_name.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_name.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_name.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_transition.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_transition.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_transition.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_transition_type.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_transition_type.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  time_zone_transition_type.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  transaction_registry.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  user.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  db.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  db.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  global_priv.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  global_priv.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  gtid_slave_pos.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_category.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_category.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_keyword.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_keyword.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_relation.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_relation.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_topic.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  help_topic.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  proc.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  proc.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  proxies_priv.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  proxies_priv.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  tables_priv.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  transaction_registry.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  innodb_index_stats.ibd
β”‚   β”‚   └── [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  innodb_table_stats.ibd
β”‚   β”œβ”€β”€ [drwx------ homelab-alpha homelab-alpha Nov  5 07:47]  performance_schema
β”‚   β”‚   └── [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  db.opt
β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  multi-master.info
β”‚   β”œβ”€β”€ [-rw-r--r-- root     root     Nov  5 07:47]  mysql_upgrade_info
β”‚   β”œβ”€β”€ [drwx------ homelab-alpha homelab-alpha Nov  5 07:47]  sys
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  db.opt
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  host_summary_by_file_io.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  host_summary_by_file_io_type.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  host_summary_by_stages.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  host_summary_by_statement_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  host_summary_by_statement_type.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  host_summary.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  innodb_buffer_stats_by_schema.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  innodb_buffer_stats_by_table.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  innodb_lock_waits.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  io_by_thread_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  io_global_by_file_by_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  io_global_by_file_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  io_global_by_wait_by_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  io_global_by_wait_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  latest_file_io.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  memory_by_host_by_current_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  memory_by_thread_by_current_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  memory_by_user_by_current_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  memory_global_by_current_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  memory_global_total.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  metrics.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  processlist.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  ps_check_lost_instrumentation.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  schema_auto_increment_columns.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  schema_index_statistics.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  schema_object_overview.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  schema_redundant_indexes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  schema_table_lock_waits.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  schema_table_statistics.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  schema_table_statistics_with_buffer.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  schema_tables_with_full_table_scans.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  schema_unused_indexes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  session.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  session_ssl_status.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  statement_analysis.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  statements_with_errors_or_warnings.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  statements_with_full_table_scans.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  statements_with_runtimes_in_95th_percentile.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  statements_with_sorting.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  statements_with_temp_tables.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  sys_config.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  sys_config.MAD
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  sys_config.MAI
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  user_summary_by_file_io.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  user_summary_by_file_io_type.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  user_summary_by_stages.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  user_summary_by_statement_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  user_summary_by_statement_type.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  user_summary.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  version.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  wait_classes_global_by_avg_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  wait_classes_global_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  waits_by_host_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  waits_by_user_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  waits_global_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024host_summary_by_file_io.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024host_summary_by_file_io_type.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024host_summary_by_stages.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024host_summary_by_statement_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024host_summary_by_statement_type.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024host_summary.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024innodb_buffer_stats_by_schema.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024innodb_buffer_stats_by_table.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024innodb_lock_waits.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024io_by_thread_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024io_global_by_file_by_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024io_global_by_file_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024io_global_by_wait_by_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024io_global_by_wait_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024latest_file_io.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024memory_by_host_by_current_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024memory_by_thread_by_current_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024memory_by_user_by_current_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024memory_global_by_current_bytes.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024memory_global_total.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  [email protected]
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024ps_digest_95th_percentile_by_avg_us.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024ps_digest_avg_latency_distribution.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024ps_schema_table_statistics_io.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024schema_flattened_keys.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024schema_index_statistics.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024schema_table_lock_waits.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024schema_table_statistics.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024schema_table_statistics_with_buffer.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024schema_tables_with_full_table_scans.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  [email protected]
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024statement_analysis.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024statements_with_errors_or_warnings.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024statements_with_full_table_scans.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024statements_with_runtimes_in_95th_percentile.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024statements_with_sorting.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024statements_with_temp_tables.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024user_summary_by_file_io.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024user_summary_by_file_io_type.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024user_summary_by_stages.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024user_summary_by_statement_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024user_summary_by_statement_type.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024user_summary.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024wait_classes_global_by_avg_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024wait_classes_global_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024waits_by_host_by_latency.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024waits_by_user_by_latency.frm
β”‚   β”‚   └── [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  x@0024waits_global_by_latency.frm
β”‚   β”œβ”€β”€ [drwx------ homelab-alpha homelab-alpha Nov  5 07:47]  test
β”‚   β”‚   └── [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  db.opt
β”‚   β”œβ”€β”€ [drwx------ homelab-alpha homelab-alpha Nov  5 07:47]  kuma
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  db.opt
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  docker_host.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  group.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  incident.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  maintenance_status_page.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  monitor_group.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  monitor_maintenance.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  notification.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  proxy.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  user.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  api_key.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  heartbeat.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  knex_migrations.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  knex_migrations_lock.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  maintenance.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  monitor.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  monitor_notification.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  monitor_tag.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  monitor_tls_info.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  notification_sent_history.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  remote_browser.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  setting.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  stat_daily.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  stat_hourly.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  stat_minutely.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  status_page_cname.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  status_page.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:47]  tag.frm
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  api_key.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  docker_host.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  group.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  heartbeat.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  incident.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  knex_migrations.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  knex_migrations_lock.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  maintenance.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  maintenance_status_page.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  monitor_group.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  monitor.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  monitor_maintenance.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  monitor_notification.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  monitor_tag.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  monitor_tls_info.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  notification.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  notification_sent_history.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  proxy.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  remote_browser.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  setting.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  stat_daily.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  stat_hourly.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  stat_minutely.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  status_page_cname.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  status_page.ibd
β”‚   β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  tag.ibd
β”‚   β”‚   └── [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  user.ibd
β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  aria_log.00000001
β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  aria_log_control
β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  ib_buffer_pool
β”‚   β”œβ”€β”€ [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  ibdata1
β”‚   └── [-rw-rw---- homelab-alpha homelab-alpha Nov  5 07:48]  ib_logfile0
└── [drwxr-xr-x homelab-alpha homelab-alpha Nov  5 07:48]  run

11 directories, 258 files

β”Œβ”€β”€(homelab-alpha@test-server)-[/docker/uptime-kuma-beta/app]
└─$

@louislam
Copy link
Owner

louislam commented Nov 5, 2024

This suggests setting the owner to UID 1000 and GID 1000.

I think it is OK, because it is the UID/GID of the node user inside the Debian container, not refer to the host user. And this feature is only for someone who used Docker. Non-docker have to setup their MariaDB separately.

Thank you for your testing!

@homelab-alpha
Copy link
Contributor

This suggests setting the owner to UID 1000 and GID 1000.

I think it is OK, because it is the UID/GID of the node user inside the Debian container, not refer to the host user. And this feature is only for someone who used Docker. Non-docker have to setup their MariaDB separately.

Thank you for your testing!

Thank you for the clarification!

I’ll still go ahead and test it today on the Raspberry Pi 4. I’ll let you know how it goes.

@homelab-alpha
Copy link
Contributor

@louislam I can also confirm that it works with a Raspberry Pi 4 (4GB) running aarch64.

As expected, the UID/GID for the persistent MariaDB storage outside the container is set to UID/GID 1000.

While I don't think this is a significant issue, would it be possible to set the UID/GID as global variables so that they match the UID/GID of the host server itself, rather than the container? Or is that not feasible, or perhaps not practical?

πŸ‘Ÿ Reproduction steps:

Here is the docker-compose.yml file (click to expand)

---
networks:
  uptime-kuma-beta_net:
    attachable: false
    internal: false
    external: false
    name: uptime-kuma-beta
    driver: bridge
    ipam:
      driver: default
      config:
        - subnet: 172.20.3.0/24
          ip_range: 172.20.3.0/24
          gateway: 172.20.3.1
    driver_opts:
      com.docker.network.bridge.default_bridge: "false"
      com.docker.network.bridge.enable_icc: "true"
      com.docker.network.bridge.enable_ip_masquerade: "true"
      com.docker.network.bridge.host_binding_ipv4: "0.0.0.0"
      com.docker.network.bridge.name: "uptime-kuma"
      com.docker.network.driver.mtu: "1500"
    labels:
      com.uptime-kuma-beta.network.description: "is an isolated bridge network."

services:
  uptime-kuma-beta_app:
    restart: unless-stopped
    logging:
      driver: "json-file"
      options:
        max-size: "1M"
        max-file: "2"
    stop_grace_period: 1m
    container_name: uptime-kuma-beta
    image: louislam/uptime-kuma:nightly2
    pull_policy: if_not_present
    volumes:
      - /docker/uptime-kuma-beta/app:/app/data
      - /var/run/docker.sock:/var/run/docker.sock:ro
      - /usr/local/share/ca-certificates:/app/data/docker-tls
    environment:
      PUID: "1001"
      PGID: "1001"
      TZ: Europe/Amsterdam
      # NODE_EXTRA_CA_CERTS: /app/data/docker-tls/demo.cert # This is a demo certificate.
    domainname: status.local
    hostname: status
    networks:
      uptime-kuma-beta_net:
        ipv4_address: 172.20.3.3
    ports:
      - "3001:3001/tcp" # HTTP
      - "3001:3001/udp" # HTTP
    security_opt:
      - no-new-privileges:true
    labels:
      com.docker.compose.project: "uptime-kuma-beta"
      com.uptime-kuma-beta.description:
        "is an self-hosted monitoring tool that allows you to monitor uptime,
        status, and notifications for various services and domains."
    healthcheck:
      disable: true

🐻 Uptime-Kuma

Version: 2.0.0-beta.0

πŸ’» Operating System and Architecture

Ubuntu Server 24.04.1 LTS (GNU/Linux 6.8.0-1013-raspi aarch64)

🌐 Browser

Brave version 1.71.121 (Chromium: 130.0.6723.91) (Official Build) (64-bit)

πŸ–₯️ Deployment Environment

  • Runtime: Docker version 27.3.1, build ce12230
  • Runtime: docker-compose version 1.29.2, build unknown
  • Runtime: Portainer Business Edition version 2.21.4
  • Database: MariaDB (embedded)
  • Filesystem used for the database: Linux/ext4 on an SSD
  • Number of monitors: 1
πŸ“ Relevant log output (click to expand)

β”Œβ”€β”€(homelab-alpha@test-server)-[/docker/uptime-kuma-beta]
└─$ sudo docker-compose up --remove-orphans
Creating network "uptime-kuma-beta" with driver "bridge"
Pulling uptime-kuma-beta_app (louislam/uptime-kuma:nightly2)...
nightly2: Pulling from louislam/uptime-kuma
83d624c4be2d: Pull complete
d0ddb100d04a: Pull complete
652558b6f357: Pull complete
4fa70539adf7: Pull complete
da4e90507537: Pull complete
3ca7158c0c88: Pull complete
2336bf5e0775: Pull complete
b59fbe4bc9e2: Pull complete
1cac3c6a4baa: Pull complete
4cccc2aa5be7: Pull complete
65ec69f952b9: Pull complete
6ebe175334bb: Pull complete
23079134dd94: Pull complete
83f87e616a83: Pull complete
c2b4b7a31e24: Pull complete
Digest: sha256:87ad383f586f9251eb6b644c45f2af3480f205d349b8bfa54c755fce323ee1b0
Status: Downloaded newer image for louislam/uptime-kuma:nightly2
Creating uptime-kuma-beta ... done
Attaching to uptime-kuma-beta
uptime-kuma-beta        | Welcome to Uptime Kuma
uptime-kuma-beta        | Your Node.js version: 20.18.0
uptime-kuma-beta        | 2024-11-05T12:59:06+01:00 [SERVER] INFO: Env: production
uptime-kuma-beta        | 2024-11-05T12:59:09+01:00 [SERVER] INFO: Uptime Kuma Version: 2.0.0-beta.0-nightly-20241105100618
uptime-kuma-beta        | 2024-11-05T12:59:09+01:00 [SERVER] INFO: Loading modules
uptime-kuma-beta        | 2024-11-05T12:59:11+01:00 [SERVER] INFO: Creating express and socket.io instance
uptime-kuma-beta        | 2024-11-05T12:59:11+01:00 [SERVER] INFO: Server Type: HTTP
uptime-kuma-beta        | 2024-11-05T12:59:11+01:00 [SERVER] INFO: Data Dir: ./data/
uptime-kuma-beta        | 2024-11-05T12:59:11+01:00 [SETUP-DATABASE] INFO: db-config.json is not found or invalid: ENOENT: no such file or directory, open 'data/db-config.json'
uptime-kuma-beta        | 2024-11-05T12:59:11+01:00 [SETUP-DATABASE] INFO: Starting Setup Database on 3001
uptime-kuma-beta        | 2024-11-05T12:59:11+01:00 [SETUP-DATABASE] INFO: Open http://localhost:3001 in your browser
uptime-kuma-beta        | 2024-11-05T12:59:11+01:00 [SETUP-DATABASE] INFO: Waiting for user action...
uptime-kuma-beta        | Request /setup-database-info
uptime-kuma-beta        | 2024-11-05T12:59:15+01:00 [SETUP-DATABASE] INFO: Database is configured, close the setup-database server and start the main server now.
uptime-kuma-beta        | 2024-11-05T12:59:15+01:00 [SETUP-DATABASE] INFO: The setup-database server is closed
uptime-kuma-beta        | 2024-11-05T12:59:15+01:00 [DB] INFO: Database Type: embedded-mariadb
uptime-kuma-beta        | 2024-11-05T12:59:15+01:00 [MARIADB] INFO: Embedded MariaDB: /app/data/mariadb is not found, create one now.
uptime-kuma-beta        | 2024-11-05T12:59:19+01:00 [MARIADB] INFO: Embedded MariaDB: mysql_install_db done:Installing MariaDB/MySQL system tables in '/app/data/mariadb' ...
uptime-kuma-beta        | OK
uptime-kuma-beta        |
uptime-kuma-beta        | To start mariadbd at boot time you have to copy
uptime-kuma-beta        | support-files/mariadb.service to the right place for your system
uptime-kuma-beta        |
uptime-kuma-beta        |
uptime-kuma-beta        | Two all-privilege accounts were created.
uptime-kuma-beta        | One is root@localhost, it has no password, but you need to
uptime-kuma-beta        | be system 'root' user to connect. Use, for example, sudo mysql
uptime-kuma-beta        | The second is node@localhost, it has no password either, but
uptime-kuma-beta        | you need to be the system 'node' user to connect.
uptime-kuma-beta        | After connecting you can set the password, if you would need to be
uptime-kuma-beta        | able to connect as any of these users with a password and without sudo
uptime-kuma-beta        |
uptime-kuma-beta        | See the MariaDB Knowledgebase at https://mariadb.com/kb
uptime-kuma-beta        |
uptime-kuma-beta        | You can start the MariaDB daemon with:
uptime-kuma-beta        | cd '/usr' ; /usr/bin/mariadb-safe --datadir='/app/data/mariadb'
uptime-kuma-beta        |
uptime-kuma-beta        | You can test the MariaDB daemon with mysql-test-run.pl
uptime-kuma-beta        | cd '/usr/share/mysql/mysql-test' ; perl mariadb-test-run.pl
uptime-kuma-beta        |
uptime-kuma-beta        | Please report any problems at https://mariadb.org/jira
uptime-kuma-beta        |
uptime-kuma-beta        | The latest information about MariaDB is available at https://mariadb.org/.
uptime-kuma-beta        |
uptime-kuma-beta        | Consider joining MariaDB s strong and vibrant community:
uptime-kuma-beta        | https://mariadb.org/get-involved/
uptime-kuma-beta        |
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:19+01:00 [MARIADB] INFO: Embedded MariaDB: /app/data/run is not found, create one now.
uptime-kuma-beta        | 2024-11-05T12:59:19+01:00 [MARIADB] INFO: Starting Embedded MariaDB
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 76
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: Number of transaction pools: 1
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: Using ARMv8 crc32 instructions
uptime-kuma-beta        | 2024-11-05 12:59:20 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
uptime-kuma-beta        | 2024-11-05 12:59:20 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 95
uptime-kuma-beta        | 2024-11-05 12:59:20 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: Completed initialization of buffer pool
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: End of log at LSN=46950
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: 128 rollback segments are active.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
uptime-kuma-beta        | 2024-11-05 12:59:20 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: log sequence number 46950; transaction id 14
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: Loading buffer pool(s) from /app/data/mariadb/ib_buffer_pool
uptime-kuma-beta        | 2024-11-05 12:59:20 0 [Note] Plugin 'FEEDBACK' is disabled.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] Server socket created on IP: '127.0.0.1'.
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] InnoDB: Buffer pool(s) load completed at 241105 12:59:20
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: 2024-11-05 12:59:20 0 [Note] mariadbd: ready for connections.
uptime-kuma-beta        | Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/app/data/run/mariadb.sock'  port: 3306  Debian 12
uptime-kuma-beta        |
uptime-kuma-beta        | 2024-11-05T12:59:20+01:00 [MARIADB] INFO: Embedded MariaDB is ready for connections
uptime-kuma-beta        | 2024-11-05T12:59:21+01:00 [MARIADB] INFO: Embedded MariaDB started
uptime-kuma-beta        | 2024-11-05T12:59:21+01:00 [MARIADB] INFO: Creating basic tables for MariaDB
uptime-kuma-beta        | 2024-11-05T12:59:25+01:00 [MARIADB] INFO: Created basic tables for MariaDB
uptime-kuma-beta        | 2024-11-05T12:59:25+01:00 [SERVER] INFO: Connected to the database
uptime-kuma-beta        | 2024-11-05T12:59:26+01:00 [MIGRATION] INFO: Migration server is running on http://localhost:3001
uptime-kuma-beta        | 2024-11-05T12:59:26+01:00 [DB] INFO: Migrating Aggregate Table
uptime-kuma-beta        | 2024-11-05T12:59:26+01:00 [DB] INFO: Getting list of unique monitors
uptime-kuma-beta        | 2024-11-05T12:59:26+01:00 [DB] INFO: Clearing non-important heartbeats
uptime-kuma-beta        | 2024-11-05T12:59:26+01:00 [DB] INFO: No data to migrate
uptime-kuma-beta        | 2024-11-05T12:59:26+01:00 [SERVER] INFO: JWT secret is not found, generate one.
uptime-kuma-beta        | 2024-11-05T12:59:26+01:00 [SERVER] INFO: Stored JWT secret into database
uptime-kuma-beta        | 2024-11-05T12:59:26+01:00 [SERVER] INFO: No user, need setup
uptime-kuma-beta        | 2024-11-05T12:59:27+01:00 [SERVICES] INFO: Starting nscd
uptime-kuma-beta        | 2024-11-05T12:59:27+01:00 [SERVER] INFO: Listening on 3001
uptime-kuma-beta        | 2024-11-05T12:59:29+01:00 [SOCKET] INFO: New polling connection, IP = 192.168.30.2
uptime-kuma-beta        | 2024-11-05T12:59:29+01:00 [SERVER] INFO: Redirect to setup page
uptime-kuma-beta        | 2024-11-05T12:59:42+01:00 [AUTH] INFO: Login by username + password. IP=192.168.30.2
uptime-kuma-beta        | 2024-11-05T12:59:42+01:00 [RATE-LIMIT] INFO: remaining requests: 19
uptime-kuma-beta        | 2024-11-05T12:59:43+01:00 [AUTH] INFO: Successfully logged in user uptime-kuma. IP=192.168.30.2
uptime-kuma-beta        | 2024-11-05T13:00:00+01:00 [MANAGE] INFO: Resume Monitor: 1 User ID: 1
uptime-kuma-beta        | 2024-11-05T13:00:00+01:00 [MONITOR] INFO: Added Monitor: 1 User ID: 1
uptime-kuma-beta        | 2024-11-05T13:00:05+01:00 [RATE-LIMIT] INFO: remaining requests: 19
^CGracefully stopping... (press Ctrl+C again to force)
Stopping uptime-kuma-beta ... done

β”Œβ”€β”€(homelab-alpha@test-server)-[/docker/uptime-kuma-beta]
└─$ sudo docker-compose down
Removing uptime-kuma-beta ... done
Removing network uptime-kuma-beta

β”Œβ”€β”€(homelab-alpha@test-server)-[/docker/uptime-kuma-beta]
└─$ cd app && clear && tree -aAcDgpRu

[drwxr-xr-x root     root     Nov  5 13:00]  .
β”œβ”€β”€ [drwxr-xr-x root     root     Nov  5 12:59]  docker-tls
β”œβ”€β”€ [drwxr-xr-x root     root     Nov  5 12:59]  screenshots
β”œβ”€β”€ [drwxr-xr-x root     root     Nov  5 12:59]  upload
β”œβ”€β”€ [-rw-r--r-- root     root     Nov  5 12:59]  db-config.json
β”œβ”€β”€ [-rw-r--r-- root     root     Nov  5 13:00]  error.log
β”œβ”€β”€ [drwxr-xr-x 1000     1000     Nov  5 13:00]  mariadb
β”‚   β”œβ”€β”€ [drwx------ 1000     1000     Nov  5 12:59]  mysql  [error opening dir]
β”‚   β”œβ”€β”€ [drwx------ 1000     1000     Nov  5 12:59]  performance_schema  [error opening dir]
β”‚   β”œβ”€β”€ [-rw-r--r-- root     root     Nov  5 12:59]  mysql_upgrade_info
β”‚   β”œβ”€β”€ [drwx------ 1000     1000     Nov  5 12:59]  sys  [error opening dir]
β”‚   β”œβ”€β”€ [drwx------ 1000     1000     Nov  5 12:59]  test  [error opening dir]
β”‚   β”œβ”€β”€ [-rw-rw---- 1000     1000     Nov  5 12:59]  multi-master.info
β”‚   β”œβ”€β”€ [drwx------ 1000     1000     Nov  5 12:59]  kuma  [error opening dir]
β”‚   β”œβ”€β”€ [-rw-rw---- 1000     1000     Nov  5 13:00]  ib_buffer_pool
β”‚   β”œβ”€β”€ [-rw-rw---- 1000     1000     Nov  5 13:00]  ibdata1
β”‚   β”œβ”€β”€ [-rw-rw---- 1000     1000     Nov  5 13:00]  aria_log.00000001
β”‚   β”œβ”€β”€ [-rw-rw---- 1000     1000     Nov  5 13:00]  aria_log_control
β”‚   └── [-rw-rw---- 1000     1000     Nov  5 13:00]  ib_logfile0
└── [drwxr-xr-x 1000     1000     Nov  5 13:00]  run

@louislam
Copy link
Owner

louislam commented Nov 5, 2024

Thanks, I merge the pr now.

would it be possible to set the UID/GID as global variables so that they match the UID/GID of the host server itself

I think it is not possible at the moment, because it used MariaDB's default initialization which only root and node users can login the embedded MariaDB.

@homelab-alpha
Copy link
Contributor

Thanks, I merge the pr now.

would it be possible to set the UID/GID as global variables so that they match the UID/GID of the host server itself

I think it is not possible at the moment, because it used MariaDB's default initialization which only root and node users can login the embedded MariaDB.

That's good to know. In that case, I will only use the external MariaDB from now on. Keep up the good work! πŸ‘

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working releaseblocker blocking bugs encountered with a new release
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants