1 { lib, pkgs, config, myconfig, mylibs, ... }:
3 cfg = config.services.myDatabases;
5 options.services.myDatabases = {
7 enable = lib.mkOption {
10 description = "Whether to enable mariadb database";
11 type = lib.types.bool;
16 config = lib.mkIf cfg.enable {
17 nixpkgs.overlays = [ (self: super: rec {
19 mariadbPAM = super.mariadb.overrideAttrs(old: rec {
20 cmakeFlags = old.cmakeFlags ++ [ "-DWITH_AUTHENTICATION_PAM=ON" ];
21 buildInputs = old.buildInputs ++ [ self.pam ];
25 networking.firewall.allowedTCPPorts = [ 3306 ];
27 # for adminer, ssl is implemented with mysqli only, which is
28 # currently disabled because it’s not compatible with pam.
29 # Thus we need to generate two users for each 'remote': one remote
30 # with SSL, and one localhost without SSL.
31 # User identified by LDAP:
32 # CREATE USER foo@% IDENTIFIED VIA pam USING 'mysql' REQUIRE SSL;
33 # CREATE USER foo@localhost IDENTIFIED VIA pam USING 'mysql';
34 services.mysql = rec {
35 enable = cfg.mariadb.enable;
36 package = pkgs.mariadb;
38 ssl_ca = ${pkgs.cacert}/etc/ssl/certs/ca-bundle.crt
39 ssl_key = /var/lib/acme/mysql/key.pem
40 ssl_cert = /var/lib/acme/mysql/fullchain.pem
44 security.acme.certs."mysql" = config.services.myCertificates.certConfig // {
47 plugins = [ "fullchain.pem" "key.pem" "account_key.json" ];
48 domain = "db-1.immae.eu";
50 systemctl restart mysql.service
57 mycnf = pkgs.writeText "my.cnf" ''
60 password = ${myconfig.env.databases.mysql.systemUsers.root}
64 30 1,13 * * * root ${pkgs.mariadb}/bin/mysqldump --defaults-file=${mycnf} --all-databases > /var/lib/mysql/backup.sql
69 security.pam.services = let
70 pam_ldap = "${pkgs.pam_ldap}/lib/security/pam_ldap.so";
71 pam_ldap_mysql = with myconfig.env.databases.mysql.pam;
72 pkgs.writeText "mysql.conf" ''
73 host ${myconfig.env.ldap.host}
74 base ${myconfig.env.ldap.base}
84 # https://mariadb.com/kb/en/mariadb/pam-authentication-plugin/
85 auth required ${pam_ldap} config=${pam_ldap_mysql}
86 account required ${pam_ldap} config=${pam_ldap_mysql}