virtual/eldiron.nix

   1 {
   2   network = {
   3     description = "Immae's network";
   4     enableRollback = true;
   5   };
   6
   7   eldiron = { config, pkgs, ... }:
   8     with import ../libs.nix;
   9     let
  10         mypkgs = pkgs.callPackage ./packages.nix {
  11           inherit checkEnv fetchedGitPrivate fetchedGithub;
  12         };
  13     in
  14   {
  15     nixpkgs.config.packageOverrides = oldpkgs: rec {
  16       gitolite = oldpkgs.gitolite.overrideAttrs(old: rec {
  17         name = "gitolite-${version}";
  18         version = "3.6.10";
  19         src = pkgs.fetchFromGitHub {
  20           owner = "sitaramc";
  21           repo = "gitolite";
  22           rev = "v${version}";
  23           sha256 = "0p2697mn6rwm03ndlv7q137zczai82n41aplq1g006ii7f12xy8h";
  24         };
  25       });
  26       gitweb = oldpkgs.gitweb.overrideAttrs(old: {
  27         installPhase = old.installPhase + ''
  28           cp -r ${./packages/gitweb} $out/gitweb-theme;
  29           '';
  30       });
  31       postgresql = postgresql111;
  32       postgresql111 = oldpkgs.postgresql100.overrideAttrs(old: rec {
  33         passthru = old.passthru // { psqlSchema = "11.0"; };
  34         name = "postgresql-11.1";
  35         src = pkgs.fetchurl {
  36           url = "mirror://postgresql/source/v11.1/${name}.tar.bz2";
  37           sha256 = "026v0sicsh7avzi45waf8shcbhivyxmi7qgn9fd1x0vl520mx0ch";
  38         };
  39       });
  40       mariadb = mariadbPAM;
  41       mariadbPAM = oldpkgs.mariadb.overrideAttrs(old: rec {
  42         cmakeFlags = old.cmakeFlags ++ [ "-DWITH_AUTHENTICATION_PAM=ON" ];
  43         buildInputs = old.buildInputs ++ [ pkgs.pam ];
  44       });
  45       goaccess = oldpkgs.goaccess.overrideAttrs(old: rec {
  46         name = "goaccess-${version}";
  47         version = "1.3";
  48         src = pkgs.fetchurl {
  49           url = "https://tar.goaccess.io/${name}.tar.gz";
  50           sha256 = "16vv3pj7pbraq173wlxa89jjsd279004j4kgzlrsk1dz4if5qxwc";
  51         };
  52         configureFlags = old.configureFlags ++ [ "--enable-tcb=btree" ];
  53         buildInputs = old.buildInputs ++ [ pkgs.tokyocabinet pkgs.bzip2 ];
  54       });
  55     };
  56
  57     networking = {
  58       firewall = {
  59         enable = true;
  60         allowedTCPPorts = [ 22 80 443 3306 5432 9418 ];
  61       };
  62     };
  63
  64     deployment = {
  65       targetEnv = "hetzner";
  66       hetzner = {
  67         #robotUser = "defined in HETZNER_ROBOT_USER";
  68         #robotPass = "defined in HETZNER_ROBOT_PASS";
  69         mainIPv4 = "176.9.151.89";
  70         partitions = ''
  71           clearpart --all --initlabel --drives=sda,sdb
  72
  73           part swap1 --recommended --label=swap1 --fstype=swap --ondisk=sda
  74           part swap2 --recommended --label=swap2 --fstype=swap --ondisk=sdb
  75
  76           part raid.1 --grow --ondisk=sda
  77           part raid.2 --grow --ondisk=sdb
  78
  79           raid / --level=1 --device=md0 --fstype=ext4 --label=root raid.1 raid.2
  80         '';
  81       };
  82     };
  83
  84     environment.systemPackages = let
  85       # FIXME: move it to nextcloud
  86       occ = pkgs.writeScriptBin "nextcloud-occ" ''
  87         #! ${pkgs.stdenv.shell}
  88         cd ${mypkgs.nextcloud.webRoot}
  89         NEXTCLOUD_CONFIG_DIR="${mypkgs.nextcloud.webRoot}/config" \
  90           exec \
  91           ${config.services.phpfpm.phpPackage}/bin/php \
  92           -c ${config.services.phpfpm.phpPackage}/etc/php.ini \
  93           occ $*
  94         '';
  95     in [
  96       pkgs.telnet
  97       pkgs.vim
  98       pkgs.goaccess
  99       occ
 100     ];
 101
 102     # FIXME: doesn't work with httpd?
 103     security.acme.preliminarySelfsigned = true;
 104     security.acme.certs = {
 105       # FIXME: /!\ To create a new certificate, create it before using
 106       # it in httpd
 107       "eldiron" = {
 108         webroot = "/var/lib/acme/acme-challenge";
 109         email = "ismael@bouya.org";
 110         domain = "eldiron.immae.eu";
 111         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 112         postRun = ''
 113           systemctl reload httpd.service
 114         '';
 115         extraDomains = {
 116           "db-1.immae.eu" = null;
 117           "git.immae.eu" = null;
 118           "tools.immae.eu" = null;
 119           "connexionswing.immae.eu" = null;
 120           "sandetludo.immae.eu" = null;
 121           "cloud.immae.eu" = null;
 122           "ludivine.immae.eu" = null;
 123           "dev.aten.pro" = null;
 124           "piedsjaloux.immae.eu" = null;
 125           "chloe.immae.eu" = null;
 126         };
 127       };
 128       "ludivinecassal" = {
 129         webroot = "/var/lib/acme/acme-challenge";
 130         email = "ismael@bouya.org";
 131         domain = "ludivinecassal.com";
 132         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 133         postRun = ''
 134           systemctl reload httpd.service
 135         '';
 136         extraDomains = {
 137           "www.ludivinecassal.com" = null;
 138         };
 139       };
 140       "aten" = {
 141         webroot = "/var/lib/acme/acme-challenge";
 142         email = "ismael@bouya.org";
 143         domain = "aten.pro";
 144         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 145         postRun = ''
 146           systemctl reload httpd.service
 147         '';
 148         extraDomains = {
 149           "www.aten.pro" = null;
 150         };
 151       };
 152       "piedsjaloux" = {
 153         webroot = "/var/lib/acme/acme-challenge";
 154         email = "ismael@bouya.org";
 155         domain = "piedsjaloux.fr";
 156         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 157         postRun = ''
 158           systemctl reload httpd.service
 159         '';
 160         extraDomains = {
 161           "www.piedsjaloux.fr" = null;
 162         };
 163       };
 164       "chloe" = {
 165         webroot = "/var/lib/acme/acme-challenge";
 166         email = "ismael@bouya.org";
 167         domain = "osteopathe-cc.fr";
 168         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 169         postRun = ''
 170           systemctl reload httpd.service
 171         '';
 172         extraDomains = {
 173           "www.osteopathe-cc.fr" = null;
 174         };
 175       };
 176       # "connexionswing" = {
 177       #   webroot = "/var/lib/acme/acme-challenge";
 178       #   email = "ismael@bouya.org";
 179       #   domain = "connexionswing.com";
 180       #   plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 181       #   postRun = ''
 182       #     systemctl reload httpd.service
 183       #   '';
 184       #   extraDomains = {
 185       #     "www.connexionswing.com" = null;
 186       #     "sandetludo.com" = null;
 187       #     "www.sandetludo.com" = null;
 188       #   };
 189       # };
 190     };
 191
 192     services.openssh.extraConfig = ''
 193       AuthorizedKeysCommand     /etc/ssh/ldap_authorized_keys
 194       AuthorizedKeysCommandUser nobody
 195       '';
 196
 197     users.users.wwwrun.extraGroups = [ "gitolite" ];
 198
 199     users.users.gitolite.packages = let
 200       python-packages = python-packages: with python-packages; [
 201         simplejson
 202         urllib3
 203       ];
 204     in
 205       [
 206         (pkgs.python3.withPackages python-packages)
 207       ];
 208     # FIXME: after initial install, need to
 209     # (1) copy rc file (adjust gitolite_ldap_groups.sh)
 210     # (2) (mark old readonly and) sync repos except gitolite-admin
 211     #     rsync -av --exclude=gitolite-admin.git old:/var/lib/gitolite/repositories /var/lib/gitolite/
 212     #     chown -R gitolite:gitolite /var/lib/gitolite
 213     # (3) push force the gitolite-admin to new location (from external point)
 214     #     Don't use an existing key, it will take precedence over
 215     #     gitolite-admin
 216     # (4) su -u gitolite gitolite setup
 217     services.gitolite = {
 218       enable = true;
 219       # FIXME: key from ./ssh
 220       adminPubkey = "ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDXqRbiHw7QoHADNIEuo4nUT9fSOIEBMdJZH0bkQAxXyJFyCM1IMz0pxsHV0wu9tdkkr36bPEUj2aV5bkYLBN6nxcV2Y49X8bjOSCPfx3n6Own1h+NeZVBj4ZByrFmqCbTxUJIZ2bZKcWOFncML39VmWdsVhNjg0X4NBBehqXRIKr2gt3E/ESAxTYJFm0BnU0baciw9cN0bsRGqvFgf5h2P48CIAfwhVcGmPQnnAwabnosYQzRWxR0OygH5Kd8mePh6FheIRIigfXsDO8f/jdxwut8buvNIf3m5EBr3tUbTsvM+eV3M5vKGt7sk8T64DVtepTSdOOWtp+47ktsnHOMh immae@immae.eu";
 221     };
 222
 223     services.ympd = mypkgs.ympd.config // { enable = true; };
 224
 225     services.phpfpm = {
 226       # /!\ phppackage is used in nextcloud configuation
 227       phpOptions = ''
 228         ; For nextcloud
 229         extension=${pkgs.phpPackages.redis}/lib/php/extensions/redis.so
 230         ; For nextcloud
 231         extension=${pkgs.phpPackages.apcu}/lib/php/extensions/apcu.so
 232         ; For nextcloud
 233         zend_extension=${pkgs.php}/lib/php/extensions/opcache.so
 234         '';
 235       extraConfig = ''
 236         log_level = notice
 237         '';
 238       poolConfigs = {
 239         adminer = mypkgs.adminer.phpFpm.pool;
 240         connexionswing_dev = mypkgs.connexionswing_dev.phpFpm.pool;
 241         connexionswing_prod = mypkgs.connexionswing_prod.phpFpm.pool;
 242         ludivinecassal_dev = mypkgs.ludivinecassal_dev.phpFpm.pool;
 243         ludivinecassal_prod = mypkgs.ludivinecassal_prod.phpFpm.pool;
 244         piedsjaloux_dev = mypkgs.piedsjaloux_dev.phpFpm.pool;
 245         piedsjaloux_prod = mypkgs.piedsjaloux_prod.phpFpm.pool;
 246         chloe_dev = mypkgs.chloe_dev.phpFpm.pool;
 247         chloe_prod = mypkgs.chloe_prod.phpFpm.pool;
 248         aten_dev = mypkgs.aten_dev.phpFpm.pool;
 249         aten_prod = mypkgs.aten_prod.phpFpm.pool;
 250         nextcloud = mypkgs.nextcloud.phpFpm.pool;
 251         mantisbt = mypkgs.mantisbt.phpFpm.pool;
 252       };
 253     };
 254
 255     system.activationScripts = {
 256       connexionswing_dev  = mypkgs.connexionswing_dev.activationScript;
 257       connexionswing_prod = mypkgs.connexionswing_prod.activationScript;
 258       ludivinecassal_dev  = mypkgs.ludivinecassal_dev.activationScript;
 259       ludivinecassal_prod = mypkgs.ludivinecassal_prod.activationScript;
 260       piedsjaloux_dev     = mypkgs.piedsjaloux_dev.activationScript;
 261       piedsjaloux_prod    = mypkgs.piedsjaloux_prod.activationScript;
 262       chloe_dev  = mypkgs.chloe_dev.activationScript;
 263       chloe_prod = mypkgs.chloe_prod.activationScript;
 264       aten_dev  = mypkgs.aten_dev.activationScript;
 265       aten_prod = mypkgs.aten_prod.activationScript;
 266       nextcloud = mypkgs.nextcloud.activationScript;
 267       httpd = ''
 268         install -d -m 0755 /var/lib/acme/acme-challenge
 269         '';
 270       redis = ''
 271         mkdir -p /run/redis
 272         chown redis /run/redis
 273         '';
 274       gitolite =
 275         assert checkEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
 276         let
 277         gitolite_ldap_groups = wrap {
 278           name = "gitolite_ldap_groups.sh";
 279           file = ./packages/gitolite_ldap_groups.sh;
 280           vars = {
 281             LDAP_PASS = builtins.getEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
 282           };
 283           paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.coreutils ];
 284         };
 285       in {
 286         deps = [ "users" ];
 287         text = ''
 288           if [ -d /var/lib/gitolite ]; then
 289             ln -sf ${gitolite_ldap_groups} /var/lib/gitolite/gitolite_ldap_groups.sh
 290             chmod g+rx /var/lib/gitolite
 291           fi
 292           if [ -f /var/lib/gitolite/projects.list ]; then
 293             chmod g+r /var/lib/gitolite/projects.list
 294           fi
 295         '';
 296       };
 297       # FIXME: initial sync
 298       goaccess = ''
 299         mkdir -p /var/lib/goaccess
 300         mkdir -p /var/lib/goaccess/aten.pro
 301         mkdir -p /var/lib/goaccess/ludivinecassal.com
 302         mkdir -p /var/lib/goaccess/piedsjaloux.fr
 303         mkdir -p /var/lib/goaccess/osteopathe-cc.fr
 304         '';
 305     };
 306
 307     environment.etc."ssh/ldap_authorized_keys" = let
 308       ldap_authorized_keys =
 309         assert checkEnv "NIXOPS_SSHD_LDAP_PASSWORD";
 310         wrap {
 311           name = "ldap_authorized_keys";
 312           file = ./ldap_authorized_keys.sh;
 313           vars = {
 314             LDAP_PASS = builtins.getEnv "NIXOPS_SSHD_LDAP_PASSWORD";
 315             GITOLITE_SHELL = "${pkgs.gitolite}/bin/gitolite-shell";
 316             ECHO = "${pkgs.coreutils}/bin/echo";
 317           };
 318           paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.gnused pkgs.coreutils ];
 319         };
 320     in {
 321       enable = true;
 322       mode = "0755";
 323       user = "root";
 324       source = ldap_authorized_keys;
 325     };
 326
 327     services.gitDaemon = {
 328       enable = true;
 329       user = "gitolite";
 330       group = "gitolite";
 331       basePath = "${mypkgs.git.web.varDir}/repositories";
 332     };
 333
 334     services.httpd = let
 335       withConf = domain: {
 336         enableSSL = true;
 337         sslServerCert = "/var/lib/acme/${domain}/cert.pem";
 338         sslServerKey = "/var/lib/acme/${domain}/key.pem";
 339         sslServerChain = "/var/lib/acme/${domain}/fullchain.pem";
 340         logFormat = "combinedVhost";
 341         listen = [ { ip = "*"; port = 443; } ];
 342       };
 343       apacheConfig = {
 344         gzip = {
 345           modules = [ "deflate" "filter" ];
 346           extraConfig = ''
 347             AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript
 348           '';
 349         };
 350         ldap = {
 351           modules = [ "ldap" "authnz_ldap" ];
 352           extraConfig = assert checkEnv "NIXOPS_HTTP_LDAP_PASSWORD"; ''
 353             <IfModule ldap_module>
 354               LDAPSharedCacheSize 500000
 355               LDAPCacheEntries 1024
 356               LDAPCacheTTL 600
 357               LDAPOpCacheEntries 1024
 358               LDAPOpCacheTTL 600
 359             </IfModule>
 360
 361             <Macro LDAPConnect>
 362               <IfModule authnz_ldap_module>
 363                 AuthLDAPURL          ldap://ldap.immae.eu:389/dc=immae,dc=eu
 364                 AuthLDAPBindDN       cn=httpd,ou=services,dc=immae,dc=eu
 365                 AuthLDAPBindPassword "${builtins.getEnv "NIXOPS_HTTP_LDAP_PASSWORD"}"
 366                 AuthType             Basic
 367                 AuthName             "Authentification requise (Acces LDAP)"
 368                 AuthBasicProvider    ldap
 369               </IfModule>
 370             </Macro>
 371
 372             <Macro Stats %{domain}>
 373               Alias /awstats /var/lib/goaccess/%{domain}
 374               <Directory /var/lib/goaccess/%{domain}>
 375                 DirectoryIndex index.html
 376                 AllowOverride None
 377                 Require all granted
 378               </Directory>
 379               <Location /awstats>
 380                 Use LDAPConnect
 381                 Require ldap-group cn=%{domain},ou=stats,cn=httpd,ou=services,dc=immae,dc=eu
 382               </Location>
 383             </Macro>
 384           '';
 385         };
 386         http2 = {
 387           modules = [ "http2" ];
 388           extraConfig = ''
 389             Protocols h2 http/1.1
 390           '';
 391         };
 392         customLog = {
 393           modules = [];
 394           extraConfig = ''
 395             LogFormat "%v:%p %h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combinedVhost
 396           '';
 397         };
 398       };
 399     in rec {
 400       enable = true;
 401       logPerVirtualHost = true;
 402       multiProcessingModule = "worker";
 403       adminAddr = "httpd@immae.eu";
 404       logFormat = "combinedVhost";
 405       extraModules = pkgs.lib.lists.unique (
 406         mypkgs.adminer.apache.modules ++
 407         mypkgs.nextcloud.apache.modules ++
 408         mypkgs.connexionswing_dev.apache.modules ++
 409         mypkgs.connexionswing_prod.apache.modules ++
 410         mypkgs.ludivinecassal_dev.apache.modules ++
 411         mypkgs.ludivinecassal_prod.apache.modules ++
 412         mypkgs.piedsjaloux_dev.apache.modules ++
 413         mypkgs.piedsjaloux_prod.apache.modules ++
 414         mypkgs.chloe_dev.apache.modules ++
 415         mypkgs.chloe_prod.apache.modules ++
 416         mypkgs.aten_dev.apache.modules ++
 417         mypkgs.aten_prod.apache.modules ++
 418         mypkgs.ympd.apache.modules ++
 419         mypkgs.git.web.apache.modules ++
 420         mypkgs.mantisbt.apache.modules ++
 421         pkgs.lib.lists.flatten (pkgs.lib.attrsets.mapAttrsToList (n: v: v.modules) apacheConfig) ++
 422         [ "macro" ]);
 423       extraConfig = builtins.concatStringsSep "\n"
 424         (pkgs.lib.attrsets.mapAttrsToList (n: v: v.extraConfig) apacheConfig);
 425       virtualHosts = [
 426         (withConf "eldiron" // {
 427           hostName = "eldiron.immae.eu";
 428           documentRoot = ./www;
 429           extraConfig = ''
 430             DirectoryIndex index.htm
 431             '';
 432         })
 433         (withConf "eldiron" // {
 434           hostName = "db-1.immae.eu";
 435           documentRoot = null;
 436           extraConfig = builtins.concatStringsSep "\n" [
 437             mypkgs.adminer.apache.vhostConf
 438           ];
 439         })
 440         (withConf "eldiron" // {
 441           hostName = "tools.immae.eu";
 442           documentRoot = null;
 443           extraConfig = builtins.concatStringsSep "\n" [
 444             mypkgs.adminer.apache.vhostConf
 445             mypkgs.ympd.apache.vhostConf
 446           ];
 447         })
 448         (withConf "eldiron" // {
 449           hostName = "connexionswing.immae.eu";
 450           serverAliases = [ "sandetludo.immae.eu" ];
 451           documentRoot = mypkgs.connexionswing_dev.webRoot;
 452           extraConfig = builtins.concatStringsSep "\n" [
 453             mypkgs.connexionswing_dev.apache.vhostConf
 454           ];
 455         })
 456         (withConf "eldiron" // {
 457           hostName = "ludivine.immae.eu";
 458           documentRoot = mypkgs.ludivinecassal_dev.webRoot;
 459           extraConfig = builtins.concatStringsSep "\n" [
 460             mypkgs.ludivinecassal_dev.apache.vhostConf
 461           ];
 462         })
 463         (withConf "ludivinecassal" // {
 464           hostName = "ludivinecassal.com";
 465           serverAliases = [ "www.ludivinecassal.com" ];
 466           documentRoot = mypkgs.ludivinecassal_prod.webRoot;
 467           extraConfig = builtins.concatStringsSep "\n" [
 468             mypkgs.ludivinecassal_prod.apache.vhostConf
 469           ];
 470         })
 471         (withConf "eldiron" // {
 472           hostName = "piedsjaloux.immae.eu";
 473           documentRoot = mypkgs.piedsjaloux_dev.webRoot;
 474           extraConfig = builtins.concatStringsSep "\n" [
 475             mypkgs.piedsjaloux_dev.apache.vhostConf
 476           ];
 477         })
 478         (withConf "piedsjaloux" // {
 479           hostName = "piedsjaloux.fr";
 480           serverAliases = [ "www.piedsjaloux.fr" ];
 481           documentRoot = mypkgs.piedsjaloux_prod.webRoot;
 482           extraConfig = builtins.concatStringsSep "\n" [
 483             mypkgs.piedsjaloux_prod.apache.vhostConf
 484           ];
 485         })
 486         (withConf "eldiron" // {
 487           hostName = "chloe.immae.eu";
 488           documentRoot = mypkgs.chloe_dev.webRoot;
 489           extraConfig = builtins.concatStringsSep "\n" [
 490             mypkgs.chloe_dev.apache.vhostConf
 491           ];
 492         })
 493         (withConf "chloe" // {
 494           hostName = "osteopathe-cc.fr";
 495           serverAliases = [ "www.osteopathe-cc.fr" ];
 496           documentRoot = mypkgs.chloe_prod.webRoot;
 497           extraConfig = builtins.concatStringsSep "\n" [
 498             mypkgs.chloe_prod.apache.vhostConf
 499           ];
 500         })
 501         (withConf "eldiron" // {
 502           hostName = "dev.aten.pro";
 503           documentRoot = mypkgs.aten_dev.webRoot;
 504           extraConfig = builtins.concatStringsSep "\n" [
 505             mypkgs.aten_dev.apache.vhostConf
 506           ];
 507         })
 508         (withConf "aten" // {
 509           hostName = "aten.pro";
 510           serverAliases = [ "www.aten.pro" ];
 511           documentRoot = mypkgs.aten_prod.webRoot;
 512           extraConfig = builtins.concatStringsSep "\n" [
 513             mypkgs.aten_prod.apache.vhostConf
 514           ];
 515         })
 516         (withConf "eldiron" // {
 517           hostName = "cloud.immae.eu";
 518           documentRoot = mypkgs.nextcloud.webRoot;
 519           extraConfig = builtins.concatStringsSep "\n" [
 520             mypkgs.nextcloud.apache.vhostConf
 521           ];
 522         })
 523         (withConf "eldiron" // {
 524           hostName = "git.immae.eu";
 525           documentRoot = mypkgs.git.web.webRoot;
 526           extraConfig = builtins.concatStringsSep "\n" [
 527             mypkgs.git.web.apache.vhostConf
 528             mypkgs.mantisbt.apache.vhostConf
 529           ] + ''
 530             RewriteEngine on
 531             RewriteCond %{REQUEST_URI}       ^/releases
 532             RewriteRule /releases(.*)        https://release.immae.eu$1 [P,L]
 533             '';
 534         })
 535         { # Should go last, default fallback
 536           listen = [ { ip = "*"; port = 80; } ];
 537           hostName = "redirectSSL";
 538           serverAliases = [ "*" ];
 539           enableSSL = false;
 540           logFormat = "combinedVhost";
 541           documentRoot = "/var/lib/acme/acme-challenge";
 542           extraConfig = ''
 543             RewriteEngine on
 544             RewriteCond "%{REQUEST_URI}"   "!^/\.well-known"
 545             RewriteRule ^(.+)              https://%{HTTP_HOST}$1  [R=301]
 546             # To redirect in specific "VirtualHost *:80", do
 547             #   RedirectMatch 301 ^/((?!\.well-known.*$).*)$ https://host/$1
 548             # rather than rewrite
 549             '';
 550         }
 551         ];
 552     };
 553
 554     security.pam.services = let
 555       pam_ldap = pkgs.pam_ldap;
 556       pam_ldap_mysql = assert checkEnv "NIXOPS_MYSQL_PAM_PASSWORD";
 557               pkgs.writeText "mysql.conf" ''
 558         host ldap.immae.eu
 559         base dc=immae,dc=eu
 560         binddn cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
 561         bindpw ${builtins.getEnv "NIXOPS_MYSQL_PAM_PASSWORD"}
 562         pam_filter memberOf=cn=users,cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
 563         '';
 564     in [
 565       {
 566         name = "mysql";
 567         text = ''
 568           # https://mariadb.com/kb/en/mariadb/pam-authentication-plugin/
 569           auth    required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
 570           account required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
 571           '';
 572       }
 573     ];
 574
 575     # FIXME: backup
 576     services.redis = rec {
 577       enable = true;
 578       bind = "127.0.0.1";
 579       unixSocket = "/run/redis/redis.sock";
 580       extraConfig = ''
 581         unixsocketperm 777
 582         maxclients 1024
 583         '';
 584     };
 585
 586     # FIXME: initial sync
 587     # FIXME: backup
 588     # FIXME: restart after pam
 589     # FIXME: pam access doesn’t work (because of php module)
 590     # FIXME: ssl
 591     services.mysql = rec {
 592       enable = true;
 593       package = pkgs.mariadb;
 594     };
 595
 596     # FIXME: initial sync
 597     # FIXME: backup
 598     # FIXME: ssl
 599     services.postgresql = rec {
 600       enable = true;
 601       package = pkgs.postgresql;
 602       enableTCPIP = true;
 603       extraConfig = ''
 604         max_connections = 100
 605         wal_level = logical
 606         shared_buffers = 128MB
 607         max_wal_size = 1GB
 608         min_wal_size = 80MB
 609         log_timezone = 'Europe/Paris'
 610         datestyle = 'iso, mdy'
 611         timezone = 'Europe/Paris'
 612         lc_messages = 'en_US.UTF-8'
 613         lc_monetary = 'en_US.UTF-8'
 614         lc_numeric = 'en_US.UTF-8'
 615         lc_time = 'en_US.UTF-8'
 616         default_text_search_config = 'pg_catalog.english'
 617         # ssl = on
 618         # ssl_cert_file = '/var/lib/acme/eldiron/fullchain.pem'
 619         # ssl_key_file = '/var/lib/acme/eldiron/key.pem'
 620         '';
 621       authentication = ''
 622         local   all     postgres                                ident
 623         local   all     all                                     md5
 624         host    all     all             samehost                md5
 625         host    all     all             178.33.252.96/32        md5
 626         host    all     all             188.165.209.148/32      md5
 627         #host   all     all             all                     pam
 628       '';
 629     };
 630
 631     services.cron = {
 632       enable = true;
 633       systemCronJobs = let
 634         stats = domain: conf: let
 635           d = pkgs.writeScriptBin "stats-${domain}" "${pkgs.gnused}/bin/sed -n '/\\['$(LC_ALL=C ${pkgs.coreutils}/bin/date -d yesterday +'%d\\/%b\\/%Y')'/ p' /var/log/httpd/access_log-${domain} | ${pkgs.goaccess}/bin/goaccess -o /var/lib/goaccess/${domain}/index.html -p ${conf}";
 636           in "${d}/bin/stats-${domain}";
 637       in [
 638         "5 0 * * * root ${stats "aten.pro" ./packages/aten_goaccess.conf}"
 639         "5 0 * * * root ${stats "ludivinecassal.com" ./packages/ludivinecassal_goaccess.conf}"
 640         "5 0 * * * root ${stats "piedsjaloux.fr" ./packages/piedsjaloux_goaccess.conf}"
 641         "5 0 * * * root ${stats "osteopathe-cc.fr" ./packages/chloe_goaccess.conf}"
 642         ];
 643     };
 644   };
 645 }