数据分析挖掘之如何知道谁最先关注查看最新文章

有什么用

数据分析用于决策, 辅助决策

怎么用/背景

前文讲到 Docker搭建站点统计程序Matomo, 使用数据库管理软件即可对访问的数据进行定制化个性化的查询, 来满足各种管理和分析需求

相关内容

实现方法

1. 下载安装 dbeaver

2. Connect to database

3. Matomo部署时采用的mariadb底层数据库

1. 新建查询

select * FROM matomo_log_visit

where visit_entry_idaction_url in (

select idaction FROM matomo_log_action WHERE name like ‘%20260108%’)

ORDER BY visit_last_action_time DESC

1. 没有如页面统计那样的记录, 说明时spider的访问

​

分析软件切换去umami

mkdir umami && mkdir umami-db-data && cd umami

version: "3.9"
services:
  umami:
    image: ghcr.io/umami-software/umami:latest
    ports:
      - "8114:3000"
    environment:
      DATABASE_URL: postgresql://umami:umami20260109@db:5432/umami
      APP_SECRET: replace-me-20260109
      DISABLE_UPDATES: 1
      DISABLE_TELEMETRY: 1
      ENABLE_TEST_CONSOLE: 1
      FAVICON_URL: https://www.carlzeng.com/images/favicon-32x32-next.png
      GEO_DATABASE_URL: https://raw.githubusercontent.com/GitSquared/node-geolite2-redist/master/redist/GeoLite2-City.tar.gz
    depends_on:
      db:
        condition: service_healthy
    init: true
    restart: always
    healthcheck:
      test: ["CMD-SHELL", "curl http://localhost:8114/api/heartbeat"]
      interval: 5s
      timeout: 5s
      retries: 5
  db:
    image: postgres:15-alpine
    ports:
      - "5434:5432"
    environment:
      POSTGRES_DB: umami
      POSTGRES_USER: umami
      POSTGRES_PASSWORD: umami20260109
    volumes:
      - umami-db-data:/var/lib/postgresql/data
    restart: always
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U $${POSTGRES_USER} -d $${POSTGRES_DB}"]
      interval: 5s
      timeout: 5s
      retries: 5
volumes:
  umami-db-data:

Umami系统在首次部署完成后，会自动生成以下默认账户信息：. 用户名：admin; 密码：umami

nc -vz 192.168.6.117 5432                                                       
nc: connectx to 192.168.6.117 port 5432 (tcp) failed: Connection refused 

配置MAC本地downloads中的GeoLite2-City_20231128.tar.gz, 到 GEO_DATABASE_URL

https://github.com/umami-software/umami/discussions/3855

防火墙关闭了

Connection to 192.168.6.117:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
Connection refused

添加ports: -5434:5432

把端口在docker-compose中映射出来后; 可以连接访问

灵感来源

Docker搭建站点统计程序Matomo