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 fetchedGit 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.htop
  98       pkgs.vim
  99       pkgs.goaccess
 100       occ
 101     ];
 102
 103     # FIXME: doesn't work with httpd?
 104     security.acme.preliminarySelfsigned = true;
 105     security.acme.certs = {
 106       # FIXME: /!\ To create a new certificate, create it before using
 107       # it in httpd
 108       "eldiron" = {
 109         webroot = "/var/lib/acme/acme-challenge";
 110         email = "ismael@bouya.org";
 111         domain = "eldiron.immae.eu";
 112         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 113         postRun = ''
 114           systemctl reload httpd.service
 115         '';
 116         allowKeysForGroup = true;
 117         extraDomains = {
 118           "db-1.immae.eu" = null;
 119           "git.immae.eu" = null;
 120           "tools.immae.eu" = null;
 121           "connexionswing.immae.eu" = null;
 122           "sandetludo.immae.eu" = null;
 123           "cloud.immae.eu" = null;
 124           "ludivine.immae.eu" = null;
 125           "dev.aten.pro" = null;
 126           "piedsjaloux.immae.eu" = null;
 127           "chloe.immae.eu" = null;
 128         };
 129       };
 130       "ludivinecassal" = {
 131         webroot = "/var/lib/acme/acme-challenge";
 132         email = "ismael@bouya.org";
 133         domain = "ludivinecassal.com";
 134         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 135         postRun = ''
 136           systemctl reload httpd.service
 137         '';
 138         extraDomains = {
 139           "www.ludivinecassal.com" = null;
 140         };
 141       };
 142       "aten" = {
 143         webroot = "/var/lib/acme/acme-challenge";
 144         email = "ismael@bouya.org";
 145         domain = "aten.pro";
 146         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 147         postRun = ''
 148           systemctl reload httpd.service
 149         '';
 150         extraDomains = {
 151           "www.aten.pro" = null;
 152         };
 153       };
 154       "piedsjaloux" = {
 155         webroot = "/var/lib/acme/acme-challenge";
 156         email = "ismael@bouya.org";
 157         domain = "piedsjaloux.fr";
 158         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 159         postRun = ''
 160           systemctl reload httpd.service
 161         '';
 162         extraDomains = {
 163           "www.piedsjaloux.fr" = null;
 164         };
 165       };
 166       "chloe" = {
 167         webroot = "/var/lib/acme/acme-challenge";
 168         email = "ismael@bouya.org";
 169         domain = "osteopathe-cc.fr";
 170         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 171         postRun = ''
 172           systemctl reload httpd.service
 173         '';
 174         extraDomains = {
 175           "www.osteopathe-cc.fr" = null;
 176         };
 177       };
 178       "connexionswing" = {
 179         webroot = "/var/lib/acme/acme-challenge";
 180         email = "ismael@bouya.org";
 181         domain = "connexionswing.com";
 182         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
 183         postRun = ''
 184           systemctl reload httpd.service
 185         '';
 186         extraDomains = {
 187           "www.connexionswing.com" = null;
 188           "sandetludo.com" = null;
 189           "www.sandetludo.com" = null;
 190         };
 191       };
 192     };
 193
 194     services.openssh.extraConfig = ''
 195       AuthorizedKeysCommand     /etc/ssh/ldap_authorized_keys
 196       AuthorizedKeysCommandUser nobody
 197       '';
 198
 199     users.users.wwwrun.extraGroups = [ "gitolite" ];
 200
 201     users.users.gitolite.packages = let
 202       python-packages = python-packages: with python-packages; [
 203         simplejson
 204         urllib3
 205       ];
 206     in
 207       [
 208         (pkgs.python3.withPackages python-packages)
 209       ];
 210     # FIXME: after initial install, need to
 211     # (1) copy rc file (adjust gitolite_ldap_groups.sh)
 212     # (2) (mark old readonly and) sync repos except gitolite-admin
 213     #     rsync -av --exclude=gitolite-admin.git old:/var/lib/gitolite/repositories /var/lib/gitolite/
 214     #     chown -R gitolite:gitolite /var/lib/gitolite
 215     # (3) push force the gitolite-admin to new location (from external point)
 216     #     Don't use an existing key, it will take precedence over
 217     #     gitolite-admin
 218     # (4) su -u gitolite gitolite setup
 219     services.gitolite = {
 220       enable = true;
 221       # FIXME: key from ./ssh
 222       adminPubkey = "ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDXqRbiHw7QoHADNIEuo4nUT9fSOIEBMdJZH0bkQAxXyJFyCM1IMz0pxsHV0wu9tdkkr36bPEUj2aV5bkYLBN6nxcV2Y49X8bjOSCPfx3n6Own1h+NeZVBj4ZByrFmqCbTxUJIZ2bZKcWOFncML39VmWdsVhNjg0X4NBBehqXRIKr2gt3E/ESAxTYJFm0BnU0baciw9cN0bsRGqvFgf5h2P48CIAfwhVcGmPQnnAwabnosYQzRWxR0OygH5Kd8mePh6FheIRIigfXsDO8f/jdxwut8buvNIf3m5EBr3tUbTsvM+eV3M5vKGt7sk8T64DVtepTSdOOWtp+47ktsnHOMh immae@immae.eu";
 223     };
 224
 225     services.ympd = mypkgs.ympd.config // { enable = false; };
 226
 227     services.phpfpm = {
 228       # FIXME: move session files to separate dirs
 229       # /!\ phppackage is used in nextcloud configuation
 230       phpOptions = ''
 231         session.save_path = "/var/lib/php/sessions"
 232         session.gc_maxlifetime = 60*60*24*15
 233         session.cache_expire = 60*24*30
 234         ; For nextcloud
 235         extension=${pkgs.phpPackages.redis}/lib/php/extensions/redis.so
 236         ; For nextcloud
 237         extension=${pkgs.phpPackages.apcu}/lib/php/extensions/apcu.so
 238         ; For nextcloud
 239         zend_extension=${pkgs.php}/lib/php/extensions/opcache.so
 240         '';
 241       extraConfig = ''
 242         log_level = notice
 243         '';
 244       poolConfigs = {
 245         adminer = mypkgs.adminer.phpFpm.pool;
 246         connexionswing_dev = mypkgs.connexionswing_dev.phpFpm.pool;
 247         connexionswing_prod = mypkgs.connexionswing_prod.phpFpm.pool;
 248         ludivinecassal_dev = mypkgs.ludivinecassal_dev.phpFpm.pool;
 249         ludivinecassal_prod = mypkgs.ludivinecassal_prod.phpFpm.pool;
 250         piedsjaloux_dev = mypkgs.piedsjaloux_dev.phpFpm.pool;
 251         piedsjaloux_prod = mypkgs.piedsjaloux_prod.phpFpm.pool;
 252         chloe_dev = mypkgs.chloe_dev.phpFpm.pool;
 253         chloe_prod = mypkgs.chloe_prod.phpFpm.pool;
 254         aten_dev = mypkgs.aten_dev.phpFpm.pool;
 255         aten_prod = mypkgs.aten_prod.phpFpm.pool;
 256         nextcloud = mypkgs.nextcloud.phpFpm.pool;
 257         mantisbt = mypkgs.mantisbt.phpFpm.pool;
 258         ttrss = mypkgs.ttrss.phpFpm.pool;
 259         roundcubemail = mypkgs.roundcubemail.phpFpm.pool;
 260       };
 261     };
 262
 263     system.activationScripts = {
 264       connexionswing_dev  = mypkgs.connexionswing_dev.activationScript;
 265       connexionswing_prod = mypkgs.connexionswing_prod.activationScript;
 266       ludivinecassal_dev  = mypkgs.ludivinecassal_dev.activationScript;
 267       ludivinecassal_prod = mypkgs.ludivinecassal_prod.activationScript;
 268       piedsjaloux_dev     = mypkgs.piedsjaloux_dev.activationScript;
 269       piedsjaloux_prod    = mypkgs.piedsjaloux_prod.activationScript;
 270       chloe_dev  = mypkgs.chloe_dev.activationScript;
 271       chloe_prod = mypkgs.chloe_prod.activationScript;
 272       aten_dev  = mypkgs.aten_dev.activationScript;
 273       aten_prod = mypkgs.aten_prod.activationScript;
 274       nextcloud = mypkgs.nextcloud.activationScript;
 275       ttrss = mypkgs.ttrss.activationScript;
 276       roundcubemail = mypkgs.roundcubemail.activationScript;
 277       httpd = ''
 278         install -d -m 0755 /var/lib/acme/acme-challenge
 279         install -d -m 0750 -o wwwrun -g wwwrun /var/lib/php/sessions
 280         install -d -m 0750 -o wwwrun -g wwwrun /var/lib/php/sessions/adminer
 281         install -d -m 0750 -o wwwrun -g wwwrun /var/lib/php/sessions/mantisbt
 282         install -d -m 0750 -o wwwrun -g wwwrun /var/lib/php/sessions/ttrss
 283         '';
 284       redis = ''
 285         mkdir -p /run/redis
 286         chown redis /run/redis
 287         '';
 288       gitolite =
 289         assert checkEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
 290         let
 291         gitolite_ldap_groups = wrap {
 292           name = "gitolite_ldap_groups.sh";
 293           file = ./packages/gitolite_ldap_groups.sh;
 294           vars = {
 295             LDAP_PASS = builtins.getEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
 296           };
 297           paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.coreutils ];
 298         };
 299       in {
 300         deps = [ "users" ];
 301         text = ''
 302           if [ -d /var/lib/gitolite ]; then
 303             ln -sf ${gitolite_ldap_groups} /var/lib/gitolite/gitolite_ldap_groups.sh
 304             chmod g+rx /var/lib/gitolite
 305           fi
 306           if [ -f /var/lib/gitolite/projects.list ]; then
 307             chmod g+r /var/lib/gitolite/projects.list
 308           fi
 309         '';
 310       };
 311       # FIXME: initial sync
 312       goaccess = ''
 313         mkdir -p /var/lib/goaccess
 314         mkdir -p /var/lib/goaccess/aten.pro
 315         mkdir -p /var/lib/goaccess/ludivinecassal.com
 316         mkdir -p /var/lib/goaccess/piedsjaloux.fr
 317         mkdir -p /var/lib/goaccess/osteopathe-cc.fr
 318         mkdir -p /var/lib/goaccess/connexionswing.com
 319         '';
 320     };
 321
 322     environment.etc."ssh/ldap_authorized_keys" = let
 323       ldap_authorized_keys =
 324         assert checkEnv "NIXOPS_SSHD_LDAP_PASSWORD";
 325         wrap {
 326           name = "ldap_authorized_keys";
 327           file = ./ldap_authorized_keys.sh;
 328           vars = {
 329             LDAP_PASS = builtins.getEnv "NIXOPS_SSHD_LDAP_PASSWORD";
 330             GITOLITE_SHELL = "${pkgs.gitolite}/bin/gitolite-shell";
 331             ECHO = "${pkgs.coreutils}/bin/echo";
 332           };
 333           paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.gnused pkgs.coreutils ];
 334         };
 335     in {
 336       enable = true;
 337       mode = "0755";
 338       user = "root";
 339       source = ldap_authorized_keys;
 340     };
 341
 342     services.gitDaemon = {
 343       enable = true;
 344       user = "gitolite";
 345       group = "gitolite";
 346       basePath = "${mypkgs.git.web.varDir}/repositories";
 347     };
 348
 349     # FIXME: logrotate
 350     services.httpd = let
 351       withConf = domain: {
 352         enableSSL = true;
 353         sslServerCert = "/var/lib/acme/${domain}/cert.pem";
 354         sslServerKey = "/var/lib/acme/${domain}/key.pem";
 355         sslServerChain = "/var/lib/acme/${domain}/fullchain.pem";
 356         logFormat = "combinedVhost";
 357         listen = [ { ip = "*"; port = 443; } ];
 358       };
 359       apacheConfig = {
 360         gzip = {
 361           modules = [ "deflate" "filter" ];
 362           extraConfig = ''
 363             AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript
 364           '';
 365         };
 366         ldap = {
 367           modules = [ "ldap" "authnz_ldap" ];
 368           extraConfig = assert checkEnv "NIXOPS_HTTP_LDAP_PASSWORD"; ''
 369             <IfModule ldap_module>
 370               LDAPSharedCacheSize 500000
 371               LDAPCacheEntries 1024
 372               LDAPCacheTTL 600
 373               LDAPOpCacheEntries 1024
 374               LDAPOpCacheTTL 600
 375             </IfModule>
 376
 377             <Macro LDAPConnect>
 378               <IfModule authnz_ldap_module>
 379                 AuthLDAPURL          ldap://ldap.immae.eu:389/dc=immae,dc=eu
 380                 AuthLDAPBindDN       cn=httpd,ou=services,dc=immae,dc=eu
 381                 AuthLDAPBindPassword "${builtins.getEnv "NIXOPS_HTTP_LDAP_PASSWORD"}"
 382                 AuthType             Basic
 383                 AuthName             "Authentification requise (Acces LDAP)"
 384                 AuthBasicProvider    ldap
 385               </IfModule>
 386             </Macro>
 387
 388             <Macro Stats %{domain}>
 389               Alias /awstats /var/lib/goaccess/%{domain}
 390               <Directory /var/lib/goaccess/%{domain}>
 391                 DirectoryIndex index.html
 392                 AllowOverride None
 393                 Require all granted
 394               </Directory>
 395               <Location /awstats>
 396                 Use LDAPConnect
 397                 Require ldap-group cn=%{domain},ou=stats,cn=httpd,ou=services,dc=immae,dc=eu
 398               </Location>
 399             </Macro>
 400           '';
 401         };
 402         http2 = {
 403           modules = [ "http2" ];
 404           extraConfig = ''
 405             Protocols h2 http/1.1
 406           '';
 407         };
 408         customLog = {
 409           modules = [];
 410           extraConfig = ''
 411             LogFormat "%v:%p %h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combinedVhost
 412           '';
 413         };
 414       };
 415     in rec {
 416       enable = true;
 417       logPerVirtualHost = true;
 418       multiProcessingModule = "worker";
 419       adminAddr = "httpd@immae.eu";
 420       logFormat = "combinedVhost";
 421       extraModules = pkgs.lib.lists.unique (
 422         mypkgs.adminer.apache.modules ++
 423         mypkgs.nextcloud.apache.modules ++
 424         mypkgs.connexionswing_dev.apache.modules ++
 425         mypkgs.connexionswing_prod.apache.modules ++
 426         mypkgs.ludivinecassal_dev.apache.modules ++
 427         mypkgs.ludivinecassal_prod.apache.modules ++
 428         mypkgs.piedsjaloux_dev.apache.modules ++
 429         mypkgs.piedsjaloux_prod.apache.modules ++
 430         mypkgs.chloe_dev.apache.modules ++
 431         mypkgs.chloe_prod.apache.modules ++
 432         mypkgs.aten_dev.apache.modules ++
 433         mypkgs.aten_prod.apache.modules ++
 434         mypkgs.ympd.apache.modules ++
 435         mypkgs.git.web.apache.modules ++
 436         mypkgs.mantisbt.apache.modules ++
 437         mypkgs.ttrss.apache.modules ++
 438         mypkgs.roundcubemail.apache.modules ++
 439         pkgs.lib.lists.flatten (pkgs.lib.attrsets.mapAttrsToList (n: v: v.modules) apacheConfig) ++
 440         [ "macro" ]);
 441       extraConfig = builtins.concatStringsSep "\n"
 442         (pkgs.lib.attrsets.mapAttrsToList (n: v: v.extraConfig) apacheConfig);
 443       virtualHosts = [
 444         (withConf "eldiron" // {
 445           hostName = "eldiron.immae.eu";
 446           documentRoot = ./www;
 447           extraConfig = ''
 448             DirectoryIndex index.htm
 449             '';
 450         })
 451         (withConf "eldiron" // {
 452           hostName = "db-1.immae.eu";
 453           documentRoot = null;
 454           extraConfig = builtins.concatStringsSep "\n" [
 455             mypkgs.adminer.apache.vhostConf
 456           ];
 457         })
 458         (withConf "eldiron" // {
 459           hostName = "tools.immae.eu";
 460           documentRoot = null;
 461           extraConfig = builtins.concatStringsSep "\n" [
 462             mypkgs.adminer.apache.vhostConf
 463             mypkgs.ympd.apache.vhostConf
 464             mypkgs.ttrss.apache.vhostConf
 465             mypkgs.roundcubemail.apache.vhostConf
 466           ];
 467         })
 468         (withConf "eldiron" // {
 469           hostName = "connexionswing.immae.eu";
 470           serverAliases = [ "sandetludo.immae.eu" ];
 471           documentRoot = mypkgs.connexionswing_dev.webRoot;
 472           extraConfig = builtins.concatStringsSep "\n" [
 473             mypkgs.connexionswing_dev.apache.vhostConf
 474           ];
 475         })
 476         (withConf "connexionswing" // {
 477           hostName = "connexionswing.com";
 478           serverAliases = [ "sandetludo.com" "www.connexionswing.com" "www.sandetludo.com" ];
 479           documentRoot = mypkgs.connexionswing_prod.webRoot;
 480           extraConfig = builtins.concatStringsSep "\n" [
 481             mypkgs.connexionswing_prod.apache.vhostConf
 482           ];
 483         })
 484         (withConf "eldiron" // {
 485           hostName = "ludivine.immae.eu";
 486           documentRoot = mypkgs.ludivinecassal_dev.webRoot;
 487           extraConfig = builtins.concatStringsSep "\n" [
 488             mypkgs.ludivinecassal_dev.apache.vhostConf
 489           ];
 490         })
 491         (withConf "ludivinecassal" // {
 492           hostName = "ludivinecassal.com";
 493           serverAliases = [ "www.ludivinecassal.com" ];
 494           documentRoot = mypkgs.ludivinecassal_prod.webRoot;
 495           extraConfig = builtins.concatStringsSep "\n" [
 496             mypkgs.ludivinecassal_prod.apache.vhostConf
 497           ];
 498         })
 499         (withConf "eldiron" // {
 500           hostName = "piedsjaloux.immae.eu";
 501           documentRoot = mypkgs.piedsjaloux_dev.webRoot;
 502           extraConfig = builtins.concatStringsSep "\n" [
 503             mypkgs.piedsjaloux_dev.apache.vhostConf
 504           ];
 505         })
 506         (withConf "piedsjaloux" // {
 507           hostName = "piedsjaloux.fr";
 508           serverAliases = [ "www.piedsjaloux.fr" ];
 509           documentRoot = mypkgs.piedsjaloux_prod.webRoot;
 510           extraConfig = builtins.concatStringsSep "\n" [
 511             mypkgs.piedsjaloux_prod.apache.vhostConf
 512           ];
 513         })
 514         (withConf "eldiron" // {
 515           hostName = "chloe.immae.eu";
 516           documentRoot = mypkgs.chloe_dev.webRoot;
 517           extraConfig = builtins.concatStringsSep "\n" [
 518             mypkgs.chloe_dev.apache.vhostConf
 519           ];
 520         })
 521         (withConf "chloe" // {
 522           hostName = "osteopathe-cc.fr";
 523           serverAliases = [ "www.osteopathe-cc.fr" ];
 524           documentRoot = mypkgs.chloe_prod.webRoot;
 525           extraConfig = builtins.concatStringsSep "\n" [
 526             mypkgs.chloe_prod.apache.vhostConf
 527           ];
 528         })
 529         (withConf "eldiron" // {
 530           hostName = "dev.aten.pro";
 531           documentRoot = mypkgs.aten_dev.webRoot;
 532           extraConfig = builtins.concatStringsSep "\n" [
 533             mypkgs.aten_dev.apache.vhostConf
 534           ];
 535         })
 536         (withConf "aten" // {
 537           hostName = "aten.pro";
 538           serverAliases = [ "www.aten.pro" ];
 539           documentRoot = mypkgs.aten_prod.webRoot;
 540           extraConfig = builtins.concatStringsSep "\n" [
 541             mypkgs.aten_prod.apache.vhostConf
 542           ];
 543         })
 544         (withConf "eldiron" // {
 545           hostName = "cloud.immae.eu";
 546           documentRoot = mypkgs.nextcloud.webRoot;
 547           extraConfig = builtins.concatStringsSep "\n" [
 548             mypkgs.nextcloud.apache.vhostConf
 549           ];
 550         })
 551         (withConf "eldiron" // {
 552           hostName = "git.immae.eu";
 553           documentRoot = mypkgs.git.web.webRoot;
 554           extraConfig = builtins.concatStringsSep "\n" [
 555             mypkgs.git.web.apache.vhostConf
 556             mypkgs.mantisbt.apache.vhostConf
 557           ] + ''
 558             RewriteEngine on
 559             RewriteCond %{REQUEST_URI}       ^/releases
 560             RewriteRule /releases(.*)        https://release.immae.eu$1 [P,L]
 561             '';
 562         })
 563         { # Should go last, default fallback
 564           listen = [ { ip = "*"; port = 80; } ];
 565           hostName = "redirectSSL";
 566           serverAliases = [ "*" ];
 567           enableSSL = false;
 568           logFormat = "combinedVhost";
 569           documentRoot = "/var/lib/acme/acme-challenge";
 570           extraConfig = ''
 571             RewriteEngine on
 572             RewriteCond "%{REQUEST_URI}"   "!^/\.well-known"
 573             RewriteRule ^(.+)              https://%{HTTP_HOST}$1  [R=301]
 574             # To redirect in specific "VirtualHost *:80", do
 575             #   RedirectMatch 301 ^/((?!\.well-known.*$).*)$ https://host/$1
 576             # rather than rewrite
 577             '';
 578         }
 579         ];
 580     };
 581
 582     security.pam.services = let
 583       pam_ldap = pkgs.pam_ldap;
 584       pam_ldap_mysql = assert checkEnv "NIXOPS_MYSQL_PAM_PASSWORD";
 585               pkgs.writeText "mysql.conf" ''
 586         host ldap.immae.eu
 587         base dc=immae,dc=eu
 588         binddn cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
 589         bindpw ${builtins.getEnv "NIXOPS_MYSQL_PAM_PASSWORD"}
 590         pam_filter memberOf=cn=users,cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
 591         '';
 592     in [
 593       {
 594         name = "mysql";
 595         text = ''
 596           # https://mariadb.com/kb/en/mariadb/pam-authentication-plugin/
 597           auth    required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
 598           account required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
 599           '';
 600       }
 601     ];
 602
 603     # FIXME: backup
 604     # Nextcloud: 14
 605     services.redis = rec {
 606       enable = true;
 607       bind = "127.0.0.1";
 608       unixSocket = "/run/redis/redis.sock";
 609       extraConfig = ''
 610         unixsocketperm 777
 611         maxclients 1024
 612         '';
 613     };
 614
 615     # FIXME: initial sync
 616     # FIXME: backup
 617     # FIXME: restart after pam
 618     # FIXME: pam access doesn’t work (because of php module)
 619     # FIXME: ssl
 620     services.mysql = rec {
 621       enable = true;
 622       package = pkgs.mariadb;
 623     };
 624
 625     # FIXME: initial sync
 626     # FIXME: backup
 627     # FIXME: ssl
 628     services.postgresql = rec {
 629       enable = true;
 630       package = pkgs.postgresql;
 631       enableTCPIP = true;
 632       extraConfig = ''
 633         max_connections = 100
 634         wal_level = logical
 635         shared_buffers = 128MB
 636         max_wal_size = 1GB
 637         min_wal_size = 80MB
 638         log_timezone = 'Europe/Paris'
 639         datestyle = 'iso, mdy'
 640         timezone = 'Europe/Paris'
 641         lc_messages = 'en_US.UTF-8'
 642         lc_monetary = 'en_US.UTF-8'
 643         lc_numeric = 'en_US.UTF-8'
 644         lc_time = 'en_US.UTF-8'
 645         default_text_search_config = 'pg_catalog.english'
 646         # ssl = on
 647         # ssl_cert_file = '/var/lib/acme/eldiron/fullchain.pem'
 648         # ssl_key_file = '/var/lib/acme/eldiron/key.pem'
 649         '';
 650       authentication = ''
 651         local   all     postgres                                ident
 652         local   all     all                                     md5
 653         host    all     all             samehost                md5
 654         host    all     all             178.33.252.96/32        md5
 655         host    all     all             188.165.209.148/32      md5
 656         #host   all     all             all                     pam
 657       '';
 658     };
 659
 660     services.cron = {
 661       enable = true;
 662       systemCronJobs = let
 663         stats = domain: conf: let
 664           d = pkgs.writeScriptBin "stats-${domain}" ''
 665             #!${pkgs.stdenv.shell}
 666             set -e
 667             shopt -s nullglob
 668             date_regex=$(LC_ALL=C date -d yesterday +'%d\/%b\/%Y')
 669             TMPFILE=$(mktemp)
 670             trap "rm -f $TMPFILE" EXIT
 671
 672             cat /var/log/httpd/access_log-${domain} | sed -n "/\\[$date_regex/ p" > $TMPFILE
 673             for i in /var/log/httpd/access_log-${domain}*.gz; do
 674               zcat "$i" | sed -n "/\\[$date_regex/ p" >> $TMPFILE
 675             done
 676             goaccess $TMPFILE --no-progress -o /var/lib/goaccess/${domain}/index.html -p ${conf}
 677             '';
 678           in "${d}/bin/stats-${domain}";
 679       # FIXME: running several goaccess simultaneously seems to be
 680       # bugged?
 681       in [
 682         "5 0 * * * root ${stats "aten.pro" ./packages/aten_goaccess.conf}"
 683         "6 0 * * * root ${stats "ludivinecassal.com" ./packages/ludivinecassal_goaccess.conf}"
 684         "7 0 * * * root ${stats "piedsjaloux.fr" ./packages/piedsjaloux_goaccess.conf}"
 685         "8 0 * * * root ${stats "osteopathe-cc.fr" ./packages/chloe_goaccess.conf}"
 686         "9 0 * * * root ${stats "connexionswing.com" ./packages/connexionswing_goaccess.conf}"
 687         ];
 688     };
 689
 690     systemd.services.tt-rss = {
 691       description = "Tiny Tiny RSS feeds update daemon";
 692       serviceConfig = {
 693         User = "wwwrun";
 694         ExecStart = "${pkgs.php}/bin/php ${mypkgs.ttrss.webRoot}/update.php --daemon";
 695         StandardOutput = "syslog";
 696         StandardError = "syslog";
 697         PermissionsStartOnly = true;
 698       };
 699
 700       wantedBy = [ "multi-user.target" ];
 701       requires = ["postgresql.service"];
 702       after = ["network.target" "postgresql.service"];
 703     };
 704   };
 705 }