1 We are using pGina to login into windows using LDAP server. However, since we are using single account on
2 windows for all users (to decrease time needed for login since windows would create new account for 10
3 minutes) we need to somehow know real user id so we are using pGina mysql logger plugin.
5 sudo apt-get install mariadb-server
7 sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf # modify bind-address if needed
9 sudo systemctl restart mariadb
13 MariaDB [(none)]> create user 'pGina'@'%' identified by 'secret' ;
14 Query OK, 0 rows affected (0.001 sec)
16 MariaDB [(none)]> create database pGinaDB ;
17 Query OK, 1 row affected (0.000 sec)
19 MariaDB [(none)]> grant all on pGinaDB.* to pGina ;
20 Query OK, 0 rows affected (0.001 sec)
22 Now enable all required options in pgina and create tables.