[perso/Immae/Config/Nix.git] / systems / eldiron / base.nix

{ config, pkgs, lib, php, name, secrets, ... }:
{
  # ssh-keyscan eldiron | nix-shell -p ssh-to-age --run ssh-to-age
  secrets.ageKeys = [ "age1dxr5lhvtnjssfaqpnf6qx80h8gfwkxg3tdf35m6n9wljmk7wadfs3kmahj" ];
  boot = {
    kernelModules = [ "kvm-intel" ];
    blacklistedKernelModules = [ "nvidiafb" ];
    loader.timeout = 1;
    loader.grub.devices = [ "/dev/sda" "/dev/sdc" ];
    kernel.sysctl = {
      # https://github.com/Netflix/security-bulletins/blob/master/advisories/third-party/2019-001.md
      "net.ipv4.tcp_sack" = 0;
    };
    supportedFilesystems = [ "zfs" ];
    kernelParams = ["zfs.zfs_arc_max=6442450944"];
    kernelPackages = config.boot.zfs.package.latestCompatibleLinuxPackages;
    initrd.availableKernelModules = [ "ahci" "sd_mod" ];
    initrd.secrets = {
      "/boot/pass.key" = "/boot/pass.key";
    };
  };
  services.udev.extraRules = ''
    ACTION=="add", SUBSYSTEM=="net", ATTR{address}=="c8:60:00:56:a0:88", NAME="eth0"
  '';
  nix.settings.max-jobs = 8;
  nixpkgs.config.permittedInsecurePackages = [
    "python-2.7.18.6" # for nagios-cli
    "nodejs-16.20.2" # for landing page building
  ];

  nixpkgs.overlays = [
    php.overlays.php
  ];
  powerManagement.cpuFreqGovernor = "powersave";

  security.acme.certs."${name}".postRun = builtins.concatStringsSep "\n" [
    (lib.optionalString config.services.websites.env.production.enable "/run/current-system/sw/bin/machinectl shell httpd-production /usr/bin/env systemctl reload httpd.service")
    (lib.optionalString config.services.websites.env.integration.enable "/run/current-system/sw/bin/machinectl shell httpd-integration /usr/bin/env systemctl reload httpd.service")
  ];

  fileSystems = {
    # pools:
    #     zpool: ashift=12
    #     zfast: ashift=12
    # zfs:
    #     zpool/: acltype=posixacl ; xattr=sa ; atime=off ; mountpoint=legacy
    #     zpool/root: encryption=on ; keyformat=passphrase ; keylocation=file:///boot/pass.key
    #     zpool/root/var: atime=on
    #     zfast/: acltype=posixacl ; xattr=sa ; atime=off ; mountpoint=legacy
    #     zfast/root: encryption=on ; keyformat=passphrase ; keylocation=file:///boot/pass.key
    #     zfast/root/etc: ø
    #     zfast/root/nix: ø
    #     zfast/root/tmp: async=disabled
    #     zfast/root/var: atime=on
    #     zfast/root/var/lib: ø
    #     zfast/root/var/lib/mysql: logbias=throughput ; atime=off ; primarycache=metadata
    #     zfast/root/var/lib/postgresql: recordsize=8K ; atime=off ; logbias=throughput
    #     zfast/root/var/lib/postgresql/11.0: ø
    #     zfast/root/var/lib/postgresql/11.0/pg_wal: ø
    "/"     = { fsType = "zfs"; device = "zpool/root"; };
    "/boot" = { fsType = "ext4"; device = "/dev/disk/by-uuid/e6bb18fb-ff56-4b5f-ae9f-e60d40dc0622"; };
    "/etc"  = { fsType = "zfs"; device = "zpool/root/etc"; };
    "/nix"  = { fsType = "zfs"; device = "zfast/root/nix"; };
    "/tmp"  = { fsType = "zfs"; device = "zfast/root/tmp"; };
    "/var"  = { fsType = "zfs"; device = "zpool/root/var"; };
    "/var/lib/mysql" = { fsType = "zfs"; device = "zfast/root/var/lib/mysql"; };
    "/var/lib/postgresql"             = { fsType = "zfs"; device = "zfast/root/var/lib/postgresql"; };
    "/var/lib/postgresql/11.0"        = { fsType = "zfs"; device = "zfast/root/var/lib/postgresql/11.0"; };
    "/var/lib/postgresql/11.0/pg_wal" = { fsType = "zfs"; device = "zfast/root/var/lib/postgresql/11.0/pg_wal"; };
  };
  swapDevices = [ { label = "swap1"; } { label = "swap2"; } ];
  hardware.enableRedistributableFirmware = true;

  services.zfs = {
    autoScrub = {
      enable = false;
    };
  };
  networking = {
    hostId = "8262ca33"; # generated with head -c4 /dev/urandom | od -A none -t x4
    firewall.enable = true;
    firewall.allowedTCPPorts = [ config.myEnv.ports.zrepl_flony ];
    # FIXME: on next reboot, remove the /27 and the localCommands
    interfaces."eth0".ipv4.addresses = pkgs.lib.flatten (pkgs.lib.attrsets.mapAttrsToList
      (n: ips: map (ip: { address = ip; prefixLength = 32; }) (ips.ip4 or []))
      (pkgs.lib.attrsets.filterAttrs (n: v: n != "main") config.hostEnv.ips))
      ++ [ { address = lib.head config.hostEnv.ips.main.ip4; prefixLength = 27; } ];
    interfaces."eth0".ipv6.addresses = pkgs.lib.flatten (pkgs.lib.attrsets.mapAttrsToList
      (n: ips: map (ip: { address = ip; prefixLength = (if n == "main" && ip == pkgs.lib.head ips.ip6 then 64 else 128); }) (ips.ip6 or []))
      config.hostEnv.ips);
    defaultGateway = "176.9.151.65";
    localCommands = ''
      # FIXME: Those commands were added by nixops and may not be
      # actually needed
      ip -6 addr add '2a01:4f8:160:3445::/64' dev 'eth0' || true
      ip -4 route change '176.9.151.64/27' via '176.9.151.65' dev 'eth0' || true
      ip -6 route add default via 'fe80::1' dev eth0 || true
    '';
    nameservers = [
      "213.133.98.98"
      "213.133.99.99"
      "213.133.100.100"
      "2a01:4f8:0:a0a1::add:1010"
      "2a01:4f8:0:a102::add:9999"
      "2a01:4f8:0:a111::add:9898"
    ];
  };

  imports = [
    secrets.nixosModules.users-config-eldiron
    ./databases
    ./databases/mariadb.nix
    ./databases/openldap
    ./databases/postgresql.nix
    ./databases/redis.nix


    ./monitoring.nix
    ./ejabberd
    ./buildbot
    ./coturn.nix
    ./dns.nix
    ./duply_backup.nix
    ./gemini
    ./gitolite
    ./mail
    ./websites
    ./webstats
    ./irc.nix
    ./pub
    ./tasks
    ./ftp.nix
    ./mpd.nix
    ./vpn
  ];

  myServices.buildbot.enable = true;
  myServices.databases.enable = true;
  myServices.gitolite.enable = true;
  myServices.monitoring.enable = true;
  myServices.irc.enable = true;
  myServices.pub.enable = true;
  myServices.tasks.enable = true;
  myServices.mpd.enable = true;
  myServices.dns.enable = true;
  myServices.websites.enable = true;
  myServices.gemini.enable = true;
  myServices.mail.enable = true;
  myServices.ejabberd.enable = true;
  myServices.vpn.enable = true;
  myServices.ftp.enable = true;

  myServices.chatonsProperties.hostings.infogerance = {
    file.datetime = "2022-08-27T18:50:00";
    hosting = {
      name = "Infogérance";
      description = "Administration de serveurs";
      website = "https://www.immae.eu/";
      logo = "https://assets.immae.eu/logo.jpg";
      type = "HOSTEDSERVER";
      status.level = "OK";
      status.description = "OK";
      registration.load = "OPEN";
      install.type = "PACKAGE";
    };
  };

  secrets.keys = {
    "ldap/pam_pgsql" = {
      user = "root";
      group = "root";
      permissions = "0400";
      text = ''
        database = immae
        user = immae_auth_read
        password = {{ .postgresql.immae_auth_read }}
        table = ldap_users
        user_column = login
        pw_type = function
        auth_query = SELECT (mechanism = 'SSHA' AND password = encode(digest( %p || salt, 'sha1'), 'hex')) FROM ldap_users WHERE login = %u OR login || '@' || realm = %u
        #pwd_query = WITH newsalt as (select gen_random_bytes(4)) UPDATE ldap_users SET password = encode(digest( %p || (SELECT * FROM newsalt), 'sha1'), 'hex'), salt = (SELECT * FROM newsalt), mechanism = 'SSHA' WHERE login = %u OR login || '@' || realm = %u
      '';
    };

    "zrepl_backup/identity" = {
      user = "root";
      group = "root";
      permissions = "0400";
      text = config.myEnv.zrepl_backup.ssh_key.private;
    };
    "zrepl/${name}.key" = {
      permissions = "0400";
      text = config.myEnv.zrepl_backup.certs."${name}".key;
      user = "root";
      group = "root";
    };
  } // builtins.listToAttrs (map (x: lib.attrsets.nameValuePair "zrepl/certificates/${x}.crt" {
    permissions = "0400";
    text = config.myEnv.zrepl_backup.certs."${x}".certificate;
    user = "root";
    group = "root";
  }) (builtins.attrNames config.myEnv.zrepl_backup.certs));

  programs.ssh.knownHosts.dilion = {
    extraHostNames = ["dilion.immae.eu"];
    publicKey = config.myEnv.servers.dilion.hostKey;
  };

  services.cron = {
    enable = true;
    mailto = "cron@immae.eu";
    systemCronJobs = [
      ''
        0 0 * * * root journalctl -q --since="25 hours ago" -u postfix -t postfix/smtpd -g "immae.eu.*Recipient address rejected"
        # Need a way to blacklist properly
        # 0 0 * * * root journalctl -q --since="25 hours ago" -u postfix -t postfix/smtpd -g "NOQUEUE:"
        0 0 * * * root journalctl -q --since="25 hours ago" -u postfix -t postfix/smtp -g "status=bounced"
      ''
    ];
  };

  environment.systemPackages = [ pkgs.bindfs ];

  environment.etc."mdadm.conf" = {
    enable = true;
    mode = "0644";
    user = "root";
    text = "MAILADDR ${config.myEnv.monitoring.email}";
  };

  systemd.services.zrepl.path = [ pkgs.openssh ];
  services.zrepl = {
    enable = true;
    settings = {
      jobs = [
        {
          type = "push";
          # must not change
          name = "backup-to-dilion";
          filesystems."zpool/root" = true;
          filesystems."zpool/root/etc" = true;
          filesystems."zpool/root/var<" = true;
          connect = {
            address = "dilion.immae.eu:19000";
            type = "tls";
            server_cn = "dilion";
            ca = config.secrets.fullPaths."zrepl/certificates/dilion.crt";
            cert = config.secrets.fullPaths."zrepl/certificates/eldiron.crt";
            key = config.secrets.fullPaths."zrepl/eldiron.key";
          };
          snapshotting = {
            type = "periodic";
            prefix = "zrepl_";
            interval = "1h";
            # hooks = [
            #   {
            #     type = "mysql-lock-tables";
            #     dsn = "${config.myEnv.zrepl_backup.mysql.user}:${config.myEnv.zrepl_backup.mysql.password}@tcp(localhost)/";
            #     filesystems."zpool/root/var" = true;
            #   }
            #   {
            #     type = "command";
            #     path = pkgs.writeScript "redis-dump" ''
            #       #!${pkgs.stdenv.shell}
            #       ${pkgs.redis}/bin/redis-cli bgsave
            #     '';
            #     err_is_fatal = false;
            #     filesystems."zpool/root/var" = true;
            #   }
            # ];
          };
          send.encrypted = true;
          pruning.keep_sender = [
            { type = "regex"; regex = "^manual_.*"; }
            { type = "grid"; grid = "24x1h | 7x1d | 4x7d | 6x30d"; regex = "^zrepl_.*"; }
          ];
          pruning.keep_receiver = [
            { type = "regex"; regex = "^manual_.*"; }
            { type = "grid"; grid = "6x4h | 7x1d | 4x7d | 6x30d"; regex = "^zrepl_.*"; }
          ];
        }
        {
          type = "source";
          # must not change
          name = "backup-to-wd-zpool";
          serve.type = "tls";
          serve.listen = ":${builtins.toString config.myEnv.ports.zrepl_flony}";
          serve.ca = config.secrets.fullPaths."zrepl/certificates/flony.crt";
          serve.cert = config.secrets.fullPaths."zrepl/certificates/eldiron.crt";
          serve.key = config.secrets.fullPaths."zrepl/eldiron.key";
          serve.client_cns = [ "flony" ];
          filesystems."zpool/root" = true;
          filesystems."zpool/root/etc" = true;
          filesystems."zpool/root/var<" = true;
          filesystems."zfast/root/var<" = true;
          send.encrypted = true;
          snapshotting.type = "manual";
        }
      ];
    };
  };

  environment.etc."fail2ban/filter.d/postgresql.conf".text = ''
    [Definition]
    failregex = <HOST> \S+ FATAL:  password authentication failed for user .+$
                <HOST> \S+ FATAL:  PAM authentication failed for user.+$
                <HOST> \S+ FATAL:  no pg_hba.conf entry for host.+$
  '';
  environment.etc."fail2ban/filter.d/mysqld-auth.local".text = ''
    [Definition]
    _daemon = mysql[-\w]*
  '';
  services.fail2ban.jails.dovecot = ''
    enabled = true
  '';
  services.fail2ban.jails.postfix-sasl = ''
    enabled = true
  '';
  services.fail2ban.jails.proftpd = ''
    enabled = true
  '';
  services.fail2ban.jails.postgresql = ''
    enabled = true
    port = 5432
    logpath  = %(syslog_daemon)s
    backend  = %(default_backend)s
    journalmatch = _SYSTEMD_UNIT=postgresql.service + _COMM=postgres
  '';
  services.fail2ban.jails.mysqld-auth = ''
    enabled = true
    journalmatch = _SYSTEMD_UNIT=mysql.service + _COMM=mysqld
  '';
  # This value determines the NixOS release with which your system is
  # to be compatible, in order to avoid breaking some software such as
  # database servers. You should change this only after NixOS release
  # notes say you should.
  # https://nixos.org/nixos/manual/release-notes.html
  system.stateVersion = "23.05"; # Did you read the comment?

  security.pam.services.ldap.text = ''
    # Authentication from ldap for pgsql
    auth      required   ${pkgs.pam_pgsql}/lib/security/pam_pgsql.so config_file=/var/secrets/ldap/pam_pgsql
    account   required   ${pkgs.pam_pgsql}/lib/security/pam_pgsql.so config_file=/var/secrets/ldap/pam_pgsql
  '';
  services.saslauthd = {
    enable = true;
    mechanism = "pam";
  };
  environment.etc."sasl2/slapd.conf".text = ''
    mech_list: plain
    pwcheck_method: saslauthd
    saslauthd_path: /run/saslauthd/mux
  '';
}
Commit	Line	Data
1a64deeb IB	1	{ config, pkgs, lib, php, name, secrets, ... }:
	2	{
	3	# ssh-keyscan eldiron \| nix-shell -p ssh-to-age --run ssh-to-age
	4	secrets.ageKeys = [ "age1dxr5lhvtnjssfaqpnf6qx80h8gfwkxg3tdf35m6n9wljmk7wadfs3kmahj" ];
	5	boot = {
	6	kernelModules = [ "kvm-intel" ];
	7	blacklistedKernelModules = [ "nvidiafb" ];
	8	loader.timeout = 1;
	9	loader.grub.devices = [ "/dev/sda" "/dev/sdc" ];
	10	kernel.sysctl = {
	11	# https://github.com/Netflix/security-bulletins/blob/master/advisories/third-party/2019-001.md
	12	"net.ipv4.tcp_sack" = 0;
	13	};
	14	supportedFilesystems = [ "zfs" ];
	15	kernelParams = ["zfs.zfs_arc_max=6442450944"];
	16	kernelPackages = config.boot.zfs.package.latestCompatibleLinuxPackages;
	17	initrd.availableKernelModules = [ "ahci" "sd_mod" ];
	18	initrd.secrets = {
	19	"/boot/pass.key" = "/boot/pass.key";
	20	};
	21	};
	22	services.udev.extraRules = ''
	23	ACTION=="add", SUBSYSTEM=="net", ATTR{address}=="c8:60:00:56:a0:88", NAME="eth0"
	24	'';
	25	nix.settings.max-jobs = 8;
	26	nixpkgs.config.permittedInsecurePackages = [
	27	"python-2.7.18.6" # for nagios-cli
	28	"nodejs-16.20.2" # for landing page building
	29	];
	30
	31	nixpkgs.overlays = [
	32	php.overlays.php
	33	];
	34	powerManagement.cpuFreqGovernor = "powersave";
	35
	36	security.acme.certs."${name}".postRun = builtins.concatStringsSep "\n" [
	37	(lib.optionalString config.services.websites.env.production.enable "/run/current-system/sw/bin/machinectl shell httpd-production /usr/bin/env systemctl reload httpd.service")
	38	(lib.optionalString config.services.websites.env.integration.enable "/run/current-system/sw/bin/machinectl shell httpd-integration /usr/bin/env systemctl reload httpd.service")
	39	];
	40
	41	fileSystems = {
	42	# pools:
	43	# zpool: ashift=12
	44	# zfast: ashift=12
	45	# zfs:
	46	# zpool/: acltype=posixacl ; xattr=sa ; atime=off ; mountpoint=legacy
	47	# zpool/root: encryption=on ; keyformat=passphrase ; keylocation=file:///boot/pass.key
	48	# zpool/root/var: atime=on
	49	# zfast/: acltype=posixacl ; xattr=sa ; atime=off ; mountpoint=legacy
	50	# zfast/root: encryption=on ; keyformat=passphrase ; keylocation=file:///boot/pass.key
	51	# zfast/root/etc: ø
	52	# zfast/root/nix: ø
	53	# zfast/root/tmp: async=disabled
	54	# zfast/root/var: atime=on
	55	# zfast/root/var/lib: ø
	56	# zfast/root/var/lib/mysql: logbias=throughput ; atime=off ; primarycache=metadata
	57	# zfast/root/var/lib/postgresql: recordsize=8K ; atime=off ; logbias=throughput
	58	# zfast/root/var/lib/postgresql/11.0: ø
	59	# zfast/root/var/lib/postgresql/11.0/pg_wal: ø
	60	"/" = { fsType = "zfs"; device = "zpool/root"; };
	61	"/boot" = { fsType = "ext4"; device = "/dev/disk/by-uuid/e6bb18fb-ff56-4b5f-ae9f-e60d40dc0622"; };
	62	"/etc" = { fsType = "zfs"; device = "zpool/root/etc"; };
	63	"/nix" = { fsType = "zfs"; device = "zfast/root/nix"; };
	64	"/tmp" = { fsType = "zfs"; device = "zfast/root/tmp"; };
65	"/var" = { fsType = "zfs"; device = "zpool/root/var"; };
66	"/var/lib/mysql" = { fsType = "zfs"; device = "zfast/root/var/lib/mysql"; };
67	"/var/lib/postgresql" = { fsType = "zfs"; device = "zfast/root/var/lib/postgresql"; };
68	"/var/lib/postgresql/11.0" = { fsType = "zfs"; device = "zfast/root/var/lib/postgresql/11.0"; };
69	"/var/lib/postgresql/11.0/pg_wal" = { fsType = "zfs"; device = "zfast/root/var/lib/postgresql/11.0/pg_wal"; };
70	};
71	swapDevices = [ { label = "swap1"; } { label = "swap2"; } ];
72	hardware.enableRedistributableFirmware = true;
73
74	services.zfs = {
75	autoScrub = {
76	enable = false;
77	};
78	};
79	networking = {
80	hostId = "8262ca33"; # generated with head -c4 /dev/urandom \| od -A none -t x4
81	firewall.enable = true;
82	firewall.allowedTCPPorts = [ config.myEnv.ports.zrepl_flony ];
83	# FIXME: on next reboot, remove the /27 and the localCommands
84	interfaces."eth0".ipv4.addresses = pkgs.lib.flatten (pkgs.lib.attrsets.mapAttrsToList
85	(n: ips: map (ip: { address = ip; prefixLength = 32; }) (ips.ip4 or []))
86	(pkgs.lib.attrsets.filterAttrs (n: v: n != "main") config.hostEnv.ips))
87	++ [ { address = lib.head config.hostEnv.ips.main.ip4; prefixLength = 27; } ];
88	interfaces."eth0".ipv6.addresses = pkgs.lib.flatten (pkgs.lib.attrsets.mapAttrsToList
89	(n: ips: map (ip: { address = ip; prefixLength = (if n == "main" && ip == pkgs.lib.head ips.ip6 then 64 else 128); }) (ips.ip6 or []))
90	config.hostEnv.ips);
91	defaultGateway = "176.9.151.65";
92	localCommands = ''
93	# FIXME: Those commands were added by nixops and may not be
94	# actually needed
95	ip -6 addr add '2a01:4f8:160:3445::/64' dev 'eth0' \|\| true
96	ip -4 route change '176.9.151.64/27' via '176.9.151.65' dev 'eth0' \|\| true
97	ip -6 route add default via 'fe80::1' dev eth0 \|\| true
98	'';
99	nameservers = [
100	"213.133.98.98"
101	"213.133.99.99"
102	"213.133.100.100"
103	"2a01:4f8:0:a0a1::add:1010"
104	"2a01:4f8:0:a102::add:9999"
105	"2a01:4f8:0:a111::add:9898"
106	];
107	};
108
109	imports = [
110	secrets.nixosModules.users-config-eldiron
111	./databases
112	./databases/mariadb.nix
113	./databases/openldap
114	./databases/postgresql.nix
115	./databases/redis.nix
116
117
118	./monitoring.nix
119	./ejabberd
120	./buildbot
121	./coturn.nix
122	./dns.nix
123	./duply_backup.nix
124	./gemini
125	./gitolite
126	./mail
127	./websites
128	./webstats
129	./irc.nix
130	./pub
131	./tasks
132	./ftp.nix
133	./mpd.nix
134	./vpn
135	];
136
137	myServices.buildbot.enable = true;
138	myServices.databases.enable = true;
139	myServices.gitolite.enable = true;
140	myServices.monitoring.enable = true;
141	myServices.irc.enable = true;
142	myServices.pub.enable = true;
143	myServices.tasks.enable = true;
144	myServices.mpd.enable = true;
145	myServices.dns.enable = true;
146	myServices.websites.enable = true;
147	myServices.gemini.enable = true;
148	myServices.mail.enable = true;
149	myServices.ejabberd.enable = true;
150	myServices.vpn.enable = true;
151	myServices.ftp.enable = true;
152
153	myServices.chatonsProperties.hostings.infogerance = {
154	file.datetime = "2022-08-27T18:50:00";
155	hosting = {
156	name = "Infogérance";
157	description = "Administration de serveurs";
158	website = "https://www.immae.eu/";
159	logo = "https://assets.immae.eu/logo.jpg";
160	type = "HOSTEDSERVER";
161	status.level = "OK";
162	status.description = "OK";
163	registration.load = "OPEN";
164	install.type = "PACKAGE";
165	};
166	};
167
1a64deeb IB	168	secrets.keys = {
	169	"ldap/pam_pgsql" = {
	170	user = "root";
	171	group = "root";
	172	permissions = "0400";
	173	text = ''
	174	database = immae
	175	user = immae_auth_read
	176	password = {{ .postgresql.immae_auth_read }}
	177	table = ldap_users
	178	user_column = login
	179	pw_type = function
	180	auth_query = SELECT (mechanism = 'SSHA' AND password = encode(digest( %p \|\| salt, 'sha1'), 'hex')) FROM ldap_users WHERE login = %u OR login \|\| '@' \|\| realm = %u
	181	#pwd_query = WITH newsalt as (select gen_random_bytes(4)) UPDATE ldap_users SET password = encode(digest( %p \|\| (SELECT * FROM newsalt), 'sha1'), 'hex'), salt = (SELECT * FROM newsalt), mechanism = 'SSHA' WHERE login = %u OR login \|\| '@' \|\| realm = %u
	182	'';
	183	};
	184
1a64deeb IB	185	"zrepl_backup/identity" = {
	186	user = "root";
	187	group = "root";
	188	permissions = "0400";
	189	text = config.myEnv.zrepl_backup.ssh_key.private;
	190	};
	191	"zrepl/${name}.key" = {
	192	permissions = "0400";
	193	text = config.myEnv.zrepl_backup.certs."${name}".key;
	194	user = "root";
	195	group = "root";
	196	};
	197	} // builtins.listToAttrs (map (x: lib.attrsets.nameValuePair "zrepl/certificates/${x}.crt" {
	198	permissions = "0400";
	199	text = config.myEnv.zrepl_backup.certs."${x}".certificate;
	200	user = "root";
	201	group = "root";
	202	}) (builtins.attrNames config.myEnv.zrepl_backup.certs));
	203
	204	programs.ssh.knownHosts.dilion = {
	205	extraHostNames = ["dilion.immae.eu"];
	206	publicKey = config.myEnv.servers.dilion.hostKey;
	207	};
	208
	209	services.cron = {
	210	enable = true;
	211	mailto = "cron@immae.eu";
	212	systemCronJobs = [
	213	''
	214	0 0 * * * root journalctl -q --since="25 hours ago" -u postfix -t postfix/smtpd -g "immae.eu.*Recipient address rejected"
	215	# Need a way to blacklist properly
	216	# 0 0 * * * root journalctl -q --since="25 hours ago" -u postfix -t postfix/smtpd -g "NOQUEUE:"
	217	0 0 * * * root journalctl -q --since="25 hours ago" -u postfix -t postfix/smtp -g "status=bounced"
	218	''
	219	];
	220	};
	221
	222	environment.systemPackages = [ pkgs.bindfs ];
	223
	224	environment.etc."mdadm.conf" = {
	225	enable = true;
	226	mode = "0644";
	227	user = "root";
	228	text = "MAILADDR ${config.myEnv.monitoring.email}";
	229	};
	230
	231	systemd.services.zrepl.path = [ pkgs.openssh ];
	232	services.zrepl = {
	233	enable = true;
	234	settings = {
	235	jobs = [
	236	{
	237	type = "push";
	238	# must not change
	239	name = "backup-to-dilion";
	240	filesystems."zpool/root" = true;
	241	filesystems."zpool/root/etc" = true;
	242	filesystems."zpool/root/var<" = true;
	243	connect = {
	244	address = "dilion.immae.eu:19000";
	245	type = "tls";
	246	server_cn = "dilion";
	247	ca = config.secrets.fullPaths."zrepl/certificates/dilion.crt";
	248	cert = config.secrets.fullPaths."zrepl/certificates/eldiron.crt";
249	key = config.secrets.fullPaths."zrepl/eldiron.key";
250	};
251	snapshotting = {
252	type = "periodic";
253	prefix = "zrepl_";
254	interval = "1h";
255	# hooks = [
256	# {
257	# type = "mysql-lock-tables";
258	# dsn = "${config.myEnv.zrepl_backup.mysql.user}:${config.myEnv.zrepl_backup.mysql.password}@tcp(localhost)/";
259	# filesystems."zpool/root/var" = true;
260	# }
261	# {
262	# type = "command";
263	# path = pkgs.writeScript "redis-dump" ''
264	# #!${pkgs.stdenv.shell}
265	# ${pkgs.redis}/bin/redis-cli bgsave
266	# '';
267	# err_is_fatal = false;
268	# filesystems."zpool/root/var" = true;
269	# }
270	# ];
271	};
272	send.encrypted = true;
273	pruning.keep_sender = [
274	{ type = "regex"; regex = "^manual_.*"; }
275	{ type = "grid"; grid = "24x1h \| 7x1d \| 4x7d \| 6x30d"; regex = "^zrepl_.*"; }
276	];
277	pruning.keep_receiver = [
278	{ type = "regex"; regex = "^manual_.*"; }
279	{ type = "grid"; grid = "6x4h \| 7x1d \| 4x7d \| 6x30d"; regex = "^zrepl_.*"; }
280	];
281	}
282	{
283	type = "source";
284	# must not change
285	name = "backup-to-wd-zpool";
286	serve.type = "tls";
287	serve.listen = ":${builtins.toString config.myEnv.ports.zrepl_flony}";
288	serve.ca = config.secrets.fullPaths."zrepl/certificates/flony.crt";
289	serve.cert = config.secrets.fullPaths."zrepl/certificates/eldiron.crt";
290	serve.key = config.secrets.fullPaths."zrepl/eldiron.key";
291	serve.client_cns = [ "flony" ];
292	filesystems."zpool/root" = true;
293	filesystems."zpool/root/etc" = true;
294	filesystems."zpool/root/var<" = true;
295	filesystems."zfast/root/var<" = true;
296	send.encrypted = true;
297	snapshotting.type = "manual";
298	}
299	];
300	};
301	};
302
303	environment.etc."fail2ban/filter.d/postgresql.conf".text = ''
304	[Definition]
305	failregex = <HOST> \S+ FATAL: password authentication failed for user .+$
306	<HOST> \S+ FATAL: PAM authentication failed for user.+$
307	<HOST> \S+ FATAL: no pg_hba.conf entry for host.+$
308	'';
309	environment.etc."fail2ban/filter.d/mysqld-auth.local".text = ''
310	[Definition]
311	_daemon = mysql[-\w]*
312	'';
313	services.fail2ban.jails.dovecot = ''
314	enabled = true
315	'';
316	services.fail2ban.jails.postfix-sasl = ''
317	enabled = true
318	'';
319	services.fail2ban.jails.proftpd = ''
320	enabled = true
321	'';
322	services.fail2ban.jails.postgresql = ''
323	enabled = true
324	port = 5432
325	logpath = %(syslog_daemon)s
326	backend = %(default_backend)s
327	journalmatch = _SYSTEMD_UNIT=postgresql.service + _COMM=postgres
328	'';
329	services.fail2ban.jails.mysqld-auth = ''
330	enabled = true
331	journalmatch = _SYSTEMD_UNIT=mysql.service + _COMM=mysqld
332	'';
333	# This value determines the NixOS release with which your system is
334	# to be compatible, in order to avoid breaking some software such as
335	# database servers. You should change this only after NixOS release
336	# notes say you should.
337	# https://nixos.org/nixos/manual/release-notes.html
338	system.stateVersion = "23.05"; # Did you read the comment?
339
340	security.pam.services.ldap.text = ''
341	# Authentication from ldap for pgsql
342	auth required ${pkgs.pam_pgsql}/lib/security/pam_pgsql.so config_file=/var/secrets/ldap/pam_pgsql
343	account required ${pkgs.pam_pgsql}/lib/security/pam_pgsql.so config_file=/var/secrets/ldap/pam_pgsql
344	'';
345	services.saslauthd = {
346	enable = true;
347	mechanism = "pam";
348	};
349	environment.etc."sasl2/slapd.conf".text = ''
350	mech_list: plain
351	pwcheck_method: saslauthd
352	saslauthd_path: /run/saslauthd/mux
353	'';
354	}