📊 Monitoring Tool Setup with Uptime Kuma

📦 Docker Compose Configuration

This guide helps you set up Uptime Kuma, a powerful monitoring tool, using Docker Compose.

version: '3.8'
 
services:
  uptime-kuma:
    image: louislam/uptime-kuma:1
    ports:
      - "3001:3001"
    volumes:
      - ./uptime-data:/app/data
    restart: always
 
volumes:
  uptime-kuma:

📋 Steps to Deploy

1. Create the docker-compose.yml file:

   • Save the above YAML content into a file named docker-compose.yml.

2. Start the Uptime Kuma Container:

   docker-compose up -d

3. Access Uptime Kuma:

   • Open your browser and navigate to http://localhost:3001.

📧 Changing Email in Uptime Kuma Database

If you need to update the email address in the Uptime Kuma database, follow these steps:

🛠️ Steps to Update Email

1. Enter the Container:

   docker exec -it <container_id> /bin/bash

   Replace <container_id> with the actual container ID or name for your Uptime Kuma service.

2. Navigate to the Data Directory:

   cd /app/data/

3. Open the SQLite Database:

   sqlite3 kuma.db

4. View the user Table:

   sqlite> select * from user;

5. Check Table Information (Optional):

   sqlite> PRAGMA table_info(user);

6. Update the Email Address:

   sqlite> UPDATE user
      ...> SET username = '[email protected]'
      ...> WHERE id = 1;

7. Verify the Update:

   sqlite> select * from user;

📘 Example of SQL Commands

root@8147ac2999c1:/app/data# sqlite3 kuma.db 
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> select * from user;
1|[email protected]|$2a$10$slHE1FuTeBvlFaFQCqWkhOo4m3HTxvGtrslwmV4fFzd4lASjBgUc2|1|||0|
sqlite> UPDATE user
   ...> SET username = '[email protected]'
   ...> WHERE id = 1;
sqlite> select * from user;
1|[email protected]|$2a$10$slHE1FuTeBvlFaFQCqWkhOo4m3HTxvGtrslwmV4fFzd4lASjBgUc2|1|||0|

By following these steps, you can set up Uptime Kuma for monitoring and change the user email directly in the database. Happy monitoring! 🚀