1. Proof-of-Concept Streamlit App
-
Minimal
app.py:
-
Lists
.xlsx files in the folder
-
Dropdown to select one file
-
Loads with pandas/openpyxl
-
Displays the DataFrame in Streamlit
-
Governance reminders: IGC, DQ, Lineage
-
Sidebar filters: Im_ID, Typ, GSC
2. Air-gapped RHEL8 Environment Challenges
-
Environment: RHEL8 box (
virtca8) behind nginx reverse-proxy, no Internet
-
Pip wheelhouse attempt:
-
Built on Windows, transferred to RHEL
-
ABI/platform mismatches (Windows vs manylinux tags, Python 3.12 vs 3.6)
-
Resolved with
pip3 download ... --platform manylinux2014_x86_64 --abi cp36m --python-version 3.6
-
Included NumPy explicitly (manylinux2014)
3. Simplification Paths Explored
-
Containerization: Docker/Podman app to sidestep pip-wheel issues
-
Ansible proposal:
-
Install system RPMs (
python3, pandas, openpyxl) via dnf
-
Copy single Streamlit wheel and install offline with
pip
-
Deploy as a
systemd service across RHEL6/RHEL8 hosts (Ye Olde Boxes, Sh1re, Sh0re, virtca8)
4. Re-focus & Next Steps
-
Decision: Drop complex pip-wheel approach for this side project
-
Local PoC: Keep simple Streamlit app locally under full control
-
Plan Ansible automation for:
-
MediaWiki on Sh1re
-
Bugzilla & FileZilla hosts
-
Basic hardening & package installs on Ye Olde Boxes (RHEL 6.4)