Provenances user - CPNV-ES-MAS3-X/LibreNMS-Containerization GitHub Wiki
Se connecter à l'instance sql en local
sudo mysql
Inspection de la table user
use mysql;
show columns from user;
select host,user from user;
output:
MariaDB [mysql]> select host,user from user;
+-----------+-------------+
| Host | User |
+-----------+-------------+
| % | test |
| % | test2 |
| localhost | librenms |
| localhost | mariadb.sys |
| localhost | mysql |
| localhost | root |
+-----------+-------------+
6 rows in set (0.002 sec)
Nous avons a présent la liste de tous les utilisateurs
Pour afficher ses privilèges:
#<user>@<host>
show grants for librenms@localhost;
output
+-----------------------------------------------------------------------------------------------------------------+
| Grants for librenms@localhost |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `librenms`@`localhost` IDENTIFIED BY PASSWORD '*0F3704CF78312459ABAEBE40557BFF7BFCB0A3EC' |
| GRANT ALL PRIVILEGES ON `librenms`.* TO `librenms`@`localhost` |
+-----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.001 sec)
Créons l'user librenms sur la bd docker afin que le serveur librenms puisse s'y connecter et manipuler la base
Créer un nouvel utilisateur en utilisant le hash du mot de passe.
#<user>@<host>
create user [email protected] identified by password '*0F3704CF78312459ABAEBE40557BFF7BFCB0A3EC'
Application des droits d'accès et privilèges
GRANT USAGE ON librenms.* TO [email protected] IDENTIFIED BY PASSWORD '*0F3704CF78312459ABAEBE40557BFF7BFCB0A3EC';
GRANT ALL PRIVILEGES ON `librenms`.* TO `librenms`@`10.10.10.32`;
Appliquer les changements de privileges
flush privileges;
Modifier les credentials inscrit sous le fichier .env
...
DB_HOST=10.10.10.179
DB_DATABASE=librenms
DB_USERNAME=librenms
DB_PASSWORD=Pa$$w0rd
...