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

更新于 分类于 阅读次数： 阅读时长 ≈ 10 分钟

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

有什么用

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

怎么用/背景

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

相关内容

实现方法

  1. 下载安装 dbeaver

  2. Connect to database

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

    image-20260109110022407

  3. 新建查询

    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

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

​

分析软件切换去umami

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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

1
2
3

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中映射出来后; 可以连接访问

image-20260109170009829

GEOIP_DB

GEOIP_DB: /app/geo/GeoLite2-City.mmdb

如何安装mmdbinspect

mmdblookup：安装 libmaxminddb 后，在终端运行命令查询指定 IP：
mmdblookup

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
brew install libmaxminddb 

HOMEBREW_NO_AUTO_UPDATE=1 brew install libmaxminddb

mmdblookup

  *ERROR: You must provide a filename with --file

  mmdblookup --file /path/to/file.mmdb --ip 1.2.3.4 [path to lookup]

  This application accepts the following options:

      --file (-f)     The path to the MMDB file. Required.

      --ip (-i)       The IP address to look up. Required.

      --verbose (-v)  Turns on verbose output. Specifically, this causes this
                      application to output the database metadata.

      --version       Print the program's version number and exit.

      --help (-h -?)  Show usage information.

image-20260801123256055

上传到umami的目录下:

1
2
3
4
5
mkdir geoip 
#上传文件GeoLite2-City.mmdb
cd geoip
root@debian12:~/umami/geoip# ls
GeoLite2-City.mmdb  GeoLite2-Country.mmdb

更新docker-compose.yaml

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
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
      GEOIP_DB: /app/geoip/GeoLite2-City.mmdb
    volumes:
      - ./geoip:/app/geoip
    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:

重启了docker-compose以后

umami的后台还是无法显示: Region 和 City

尴尬..

改成: Put it in geo/GeoLite2-City.mmdb

GeoIP DB : unable to build with docker, behind an HTTP-PROXY #3327

GEO_DATABASE_URL

20260802 怀疑又被AI代沟里去了; GEOIP_DB这个在docker中根本是无效的, 还是得用:

GEO_DATABASE_URL: https://c.carlzeng.com/GeoLite2-City.mmdb

重启了docker-compose以后

umami的后台还是无法显示: Region 和 City

又尴尬..

放弃umami, 切换回到Matomo

灵感来源

Docker搭建站点统计程序Matomo

(请输入关键字以后回车，检索内容涵盖全局站点)

个性化需求沟通 扫客服加V加群：