Frappe Insights app - Installation Issues

 

Issue 1: mysqlclient Compilation Error During bench get-app

Insights depends on ibis-framework[mysql], which requires the mysqlclient Python package—a C extension that needs MariaDB development headers.

The Error

During the Docker build:

text

Trying pkg-config --exists libmariadb
Command 'pkg-config --exists libmariadb' returned non-zero exit status 127.
/bin/sh: 1: pkg-config: not found
Exception: Can not find valid pkg-config name.
Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually

This happened because the base frappe/erpnext image lacks pkg-config and MariaDB dev packages.

The Fix

I updated my Containerfile to install the necessities as root:

text

USER root
RUN apt-get update && \
    apt-get install -y --no-install-recommends \
    libmariadb-dev \
    build-essential \
    && rm -rf /var/lib/apt/lists/*

USER frappe

# Set env vars to skip pkg-config
ENV MYSQLCLIENT_CFLAGS="-I/usr/include/mariadb"
ENV MYSQLCLIENT_LDFLAGS="-L/usr/lib -lmariadb"

This forces mysqlclient to build from source using explicit paths, keeping the image lean (no pkg-config needed). Rebuild the image, and the bench get-app step succeeds.

Issue 2: NumPy Baseline Optimization Error During bench install-app

After getting the app, running bench --site site.name install-app insights failed with:

RuntimeError: NumPy was built with baseline optimizations: (X86_V2) but your machine doesn't support: (X86_V2).

NumPy 2.0+ (here v2.4.1) requires x86-64-v2 features (SSE4.2, SSSE3, POPCNT), but my VM didn't expose them.

The Cause

Proxmox VM default CPU type (kvm64 or similar) emulates a minimal CPU without passing through host features. My Xeon Silver 4510 supports these, but the guest OS didn't see them (grep sse4_2 /proc/cpuinfo returned nothing).

The Fix

In Proxmox UI:

• Shut down VM.
• Hardware > Processor > Edit > Type: Set to host. 
• Or, change the machine type to q35 (which I did not try)

This passes through the real CPU capabilities. No more NumPy error!