PmaControl logo PmaControl
  • Home
  • PmaControl
    • AI Agents 13 on-premise agents
    • Plans Community, Cloud, On-Premise, Premium
    • Documentation Guides, API, architecture
    • Clients 28+ companies
    • FAQ 25 questions / 7 categories
    Databases
    • MariaDB 30 articles
    • MySQL 10 articles
    • Galera Cluster 6 articles
    • MaxScale 3 articles
    • ProxySQL 2 articles
    • Amazon Aurora MySQL 0 article
    • Azure Database 0 article
    • ClickHouse 0 article
    • GCP CloudSQL 0 article
    • Percona Server 0 article
    • SingleStore 0 article
    • TiDB 0 article
    • Vitess 0 article
    Solutions
    • Support 24×7 MariaDB & MySQL emergencies
    • Observabilité SQL Monitoring, alerts, topology
    • Haute disponibilité Replication, failover, Galera
    • Disaster Recovery Backup, restore, RPO/RTO
    • Sécurité & conformité Audit, GDPR, SOC2
    • Migration & upgrade Zero downtime, pt-osc, gh-ost
  • Plans
  • Resources
    • Documentation Technical guides & API
    • FAQ 25 frequently asked questions
    • Testimonials Client feedback & use cases
    • Blog Articles & insights
    • Roadmap Upcoming features
    Areas of expertise
    • Observabilité SQL Monitoring, alerts, Dot3 topology
    • Haute disponibilité Replication, failover, Galera
    • Sécurité & conformité Audit, GDPR, SOC2, ISO 27001
    • Disaster Recovery Backup, restore, RPO/RTO
    • Performance & optimisation Digests, EXPLAIN, tuning
    • Migration & upgrade Zero downtime, pt-osc
    Quick links
    • GitHub Wiki 26 pages — install, engine, plugins
    • Source code Official GitHub repository
    • Support 24×7 MariaDB & MySQL emergencies
    • Book a demo 30 min — real architecture
  • Support 24×7
  • Book a demo
Book a demo
🇫🇷 FR Français 🇬🇧 EN English 🇵🇱 PL Polski 🇷🇺 RU Русский 🇨🇳 ZH 中文
Documentation › Installation & déploiement

Installation & déploiement

Prerequisites

  • Debian 10, 11 or 12 / Ubuntu 18.04 or 20.04 server
  • PHP 7.4+ with extensions: mysqli, curl, json, mbstring, xml, ssh2
  • MariaDB 10.3+ or MySQL 5.7+ (for the PmaControl internal database)
  • Apache2 or Nginx with mod_rewrite
  • Git, nmap (optional for autodiscovery)
  • Graphviz (for Dot3 topology generation)

Quick installation

# Cloner le dépôt
git clone https://github.com/PmaControl/PmaControl.git /srv/www/pmacontrol

# Créer la base de données
mysql -e "CREATE DATABASE pmacontrol CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;"
mysql -e "CREATE USER 'pmacontrol'@'localhost' IDENTIFIED BY 'votre_mot_de_passe';"
mysql -e "GRANT ALL ON pmacontrol.* TO 'pmacontrol'@'localhost';"

# Configurer la connexion
cp /srv/www/pmacontrol/configuration/db.config.ini.php.example /srv/www/pmacontrol/configuration/db.config.ini.php
# Éditez le fichier avec vos identifiants

# Lancer le wizard d'installation
php /srv/www/pmacontrol/glial install init
The Install::init() wizard creates all necessary tables, configures default settings and deploys the complete SQL schema (162 tables).

Database configuration

The configuration/db.config.ini.php file contains the connections:

[pmacontrol]
driver=mysql
hostname=127.0.0.1
port=3306
user=pmacontrol
password=votre_mot_de_passe
database=pmacontrol
ssl=0
timeout=1

To regenerate this file:

php /srv/www/pmacontrol/glial mysql refreshConfig

SSH key deployment

PmaControl uses ED25519 SSH keys to connect to remote servers (hardware collection, disk space, etc.).

# Générer une clef SSH
php /srv/www/pmacontrol/glial deployRsaKey generate

# Déployer sur un serveur
php /srv/www/pmacontrol/glial deployRsaKey deploy [id_serveur]

# Tester la connexion
php /srv/www/pmacontrol/glial deployRsaKey test [id_serveur]
SSH keys are stored in the ssh_key table. ED25519 type is recommended for its security and compactness.

Update

# Mettre à jour le code
cd /srv/www/pmacontrol && git pull

# Appliquer les patches SQL
php /srv/www/pmacontrol/glial upgrade needUpgrade
php /srv/www/pmacontrol/glial upgrade executePatch

The update system (Upgrade.php) automatically detects SQL patches to apply by comparing the current version with available patches in sql/patch/.

Apache configuration

<VirtualHost *:80>
    ServerName pmacontrol.votre-domaine.com
    DocumentRoot /srv/www/pmacontrol/App/Webroot

    <Directory /srv/www/pmacontrol/App/Webroot>
        AllowOverride All
        Require all granted
    </Directory>

    ErrorLog ${APACHE_LOG_DIR}/pmacontrol_error.log
    CustomLog ${APACHE_LOG_DIR}/pmacontrol_access.log combined
</VirtualHost>

Enable mod_rewrite: a2enmod rewrite && systemctl restart apache2

On this page
  • Prerequisites
  • Quick installation
  • Database configuration
  • SSH key deployment
  • Update
  • Apache configuration
Next page →
PmaControl
+33 6 63 28 27 47 contact@pmacontrol.com
Legal notice GitHub Contact
Do not wait for an incident to understand your architecture. © 2014-2026 PmaControl — 68Koncept