virtual/eldiron.nix

   1 {
   2   network = {
   3     description = "Immae's network";
   4     enableRollback = true;
   5   };
   6
   7   eldiron = { config, pkgs, ... }:
   8     let mypkgs = import ./packages.nix;
   9         mylibs = import ../libs.nix;
  10     in
  11   {
  12     networking = {
  13       firewall = {
  14         enable = true;
  15         allowedTCPPorts = [ 22 80 443 3306 5432 9418 ];
  16       };
  17     };
  18
  19     deployment = {
  20       targetEnv = "hetzner";
  21       hetzner = {
  22         #robotUser = "defined in HETZNER_ROBOT_USER";
  23         #robotPass = "defined in HETZNER_ROBOT_PASS";
  24         mainIPv4 = "176.9.151.89";
  25         partitions = ''
  26           clearpart --all --initlabel --drives=sda,sdb
  27
  28           part swap1 --recommended --label=swap1 --fstype=swap --ondisk=sda
  29           part swap2 --recommended --label=swap2 --fstype=swap --ondisk=sdb
  30
  31           part raid.1 --grow --ondisk=sda
  32           part raid.2 --grow --ondisk=sdb
  33
  34           raid / --level=1 --device=md0 --fstype=ext4 --label=root raid.1 raid.2
  35         '';
  36       };
  37     };
  38
  39     environment.systemPackages = let
  40       # FIXME: move it to nextcloud
  41       occ = pkgs.writeScriptBin "nextcloud-occ" ''
  42         #! ${pkgs.stdenv.shell}
  43         cd ${mypkgs.nextcloud.webRoot}
  44         NEXTCLOUD_CONFIG_DIR="${mypkgs.nextcloud.webRoot}/config" \
  45           exec \
  46           ${config.services.phpfpm.phpPackage}/bin/php \
  47           -c ${config.services.phpfpm.phpPackage}/etc/php.ini \
  48           occ $*
  49         '';
  50     in [
  51       pkgs.telnet
  52       pkgs.vim
  53       occ
  54     ];
  55
  56     security.acme.certs = {
  57       "eldiron" = {
  58         webroot = "/var/lib/acme/acme-challenge";
  59         email = "ismael@bouya.org";
  60         domain = "eldiron.immae.eu";
  61         plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
  62         postRun = ''
  63           systemctl reload httpd.service
  64         '';
  65         extraDomains = {
  66           "db-1.immae.eu" = null;
  67           "git.immae.eu" = null;
  68           "tools.immae.eu" = null;
  69           "connexionswing.immae.eu" = null;
  70           "sandetludo.immae.eu" = null;
  71           "cloud.immae.eu" = null;
  72         };
  73       };
  74       # "connexionswing" = {
  75       #   webroot = "/var/lib/acme/acme-challenge";
  76       #   email = "ismael@bouya.org";
  77       #   domain = "connexionswing.com";
  78       #   plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
  79       #   postRun = ''
  80       #     systemctl reload httpd.service
  81       #   '';
  82       #   extraDomains = {
  83       #     "www.connexionswing.com" = null;
  84       #     "sandetludo.com" = null;
  85       #     "www.sandetludo.com" = null;
  86       #   };
  87       # };
  88     };
  89
  90     services.openssh.extraConfig = ''
  91       AuthorizedKeysCommand     /etc/ssh/ldap_authorized_keys
  92       AuthorizedKeysCommandUser nobody
  93       '';
  94
  95     users.users.wwwrun.extraGroups = [ "gitolite" ];
  96
  97     users.users.gitolite.packages = let
  98       python-packages = python-packages: with python-packages; [
  99         simplejson
 100         urllib3
 101       ];
 102     in
 103       [
 104         (pkgs.python3.withPackages python-packages)
 105       ];
 106     # FIXME: after initial install, need to
 107     # (1) copy rc file (adjust gitolite_ldap_groups.sh)
 108     # (2) (mark old readonly and) sync repos except gitolite-admin
 109     #     rsync -av --exclude=gitolite-admin.git old:/var/lib/gitolite/repositories /var/lib/gitolite/
 110     #     chown -R gitolite:gitolite /var/lib/gitolite
 111     # (3) push force the gitolite-admin to new location (from external point)
 112     #     Don't use an existing key, it will take precedence over
 113     #     gitolite-admin
 114     # (4) su -u gitolite gitolite setup
 115     services.gitolite = {
 116       enable = true;
 117       # FIXME: key from ./ssh
 118       adminPubkey = "ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDXqRbiHw7QoHADNIEuo4nUT9fSOIEBMdJZH0bkQAxXyJFyCM1IMz0pxsHV0wu9tdkkr36bPEUj2aV5bkYLBN6nxcV2Y49X8bjOSCPfx3n6Own1h+NeZVBj4ZByrFmqCbTxUJIZ2bZKcWOFncML39VmWdsVhNjg0X4NBBehqXRIKr2gt3E/ESAxTYJFm0BnU0baciw9cN0bsRGqvFgf5h2P48CIAfwhVcGmPQnnAwabnosYQzRWxR0OygH5Kd8mePh6FheIRIigfXsDO8f/jdxwut8buvNIf3m5EBr3tUbTsvM+eV3M5vKGt7sk8T64DVtepTSdOOWtp+47ktsnHOMh immae@immae.eu";
 119     };
 120
 121     services.ympd = mypkgs.ympd.config // { enable = true; };
 122
 123     services.phpfpm = {
 124       # /!\ phppackage is used in nextcloud configuation
 125       phpOptions = ''
 126         ; For nextcloud
 127         extension=${pkgs.phpPackages.redis}/lib/php/extensions/redis.so
 128         ; For nextcloud
 129         extension=${pkgs.phpPackages.apcu}/lib/php/extensions/apcu.so
 130         '';
 131       extraConfig = ''
 132         log_level = notice
 133         '';
 134       poolConfigs = {
 135         adminer = mypkgs.adminer.phpFpm.pool;
 136         connexionswing_dev = mypkgs.connexionswing_dev.phpFpm.pool;
 137         connexionswing_prod = mypkgs.connexionswing_prod.phpFpm.pool;
 138         nextcloud = mypkgs.nextcloud.phpFpm.pool;
 139         mantisbt = mypkgs.mantisbt.phpFpm.pool;
 140       };
 141     };
 142
 143     system.activationScripts = {
 144       connexionswing_dev  = mypkgs.connexionswing_dev.activationScript;
 145       connexionswing_prod = mypkgs.connexionswing_prod.activationScript;
 146       nextcloud = mypkgs.nextcloud.activationScript;
 147       httpd = ''
 148         install -d -m 0755 /var/lib/acme/acme-challenge
 149         '';
 150       redis = ''
 151         mkdir -p /run/redis
 152         chown redis /run/redis
 153         '';
 154       gitolite =
 155         assert mylibs.checkEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
 156         let
 157         gitolite_ldap_groups = mylibs.wrap {
 158           name = "gitolite_ldap_groups.sh";
 159           file = ./packages/gitolite_ldap_groups.sh;
 160           vars = {
 161             LDAP_PASS = builtins.getEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
 162           };
 163           paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.coreutils ];
 164         };
 165       in {
 166         deps = [ "users" ];
 167         text = ''
 168           if [ -d /var/lib/gitolite ]; then
 169             ln -sf ${gitolite_ldap_groups} /var/lib/gitolite/gitolite_ldap_groups.sh
 170             chmod g+rx /var/lib/gitolite
 171           fi
 172           if [ -f /var/lib/gitolite/projects.list ]; then
 173             chmod g+r /var/lib/gitolite/projects.list
 174           fi
 175         '';
 176       };
 177     };
 178
 179     environment.etc."ssh/ldap_authorized_keys" = let
 180       ldap_authorized_keys =
 181         assert mylibs.checkEnv "NIXOPS_SSHD_LDAP_PASSWORD";
 182         mylibs.wrap {
 183           name = "ldap_authorized_keys";
 184           file = ./ldap_authorized_keys.sh;
 185           vars = {
 186             LDAP_PASS = builtins.getEnv "NIXOPS_SSHD_LDAP_PASSWORD";
 187             GITOLITE_SHELL = "${pkgs.gitolite}/bin/gitolite-shell";
 188             ECHO = "${pkgs.coreutils}/bin/echo";
 189           };
 190           paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.gnused pkgs.coreutils ];
 191         };
 192     in {
 193       enable = true;
 194       mode = "0755";
 195       user = "root";
 196       source = ldap_authorized_keys;
 197     };
 198
 199     services.gitDaemon = {
 200       enable = true;
 201       user = "gitolite";
 202       group = "gitolite";
 203       basePath = "${mypkgs.git.web.varDir}/repositories";
 204     };
 205
 206     services.httpd = let
 207       withSSL = domain: {
 208         enableSSL = true;
 209         sslServerCert = "/var/lib/acme/${domain}/cert.pem";
 210         sslServerKey = "/var/lib/acme/${domain}/key.pem";
 211         sslServerChain = "/var/lib/acme/${domain}/fullchain.pem";
 212       };
 213       apacheConfig = {
 214         gzip = {
 215           modules = [ "deflate" "filter" ];
 216           extraConfig = ''
 217             AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript
 218           '';
 219         };
 220         ldap = {
 221           modules = [ "ldap" "authnz_ldap" ];
 222           extraConfig = assert mylibs.checkEnv "NIXOPS_HTTP_LDAP_PASSWORD"; ''
 223             <IfModule ldap_module>
 224               LDAPSharedCacheSize 500000
 225               LDAPCacheEntries 1024
 226               LDAPCacheTTL 600
 227               LDAPOpCacheEntries 1024
 228               LDAPOpCacheTTL 600
 229             </IfModule>
 230
 231             <Macro LDAPConnect>
 232               <IfModule authnz_ldap_module>
 233                 AuthLDAPURL          ldap://ldap.immae.eu:389/dc=immae,dc=eu
 234                 AuthLDAPBindDN       cn=httpd,ou=services,dc=immae,dc=eu
 235                 AuthLDAPBindPassword "${builtins.getEnv "NIXOPS_HTTP_LDAP_PASSWORD"}"
 236                 AuthType             Basic
 237                 AuthName             "Authentification requise (Acces LDAP)"
 238                 AuthBasicProvider    ldap
 239               </IfModule>
 240             </Macro>
 241           '';
 242         };
 243       };
 244     in rec {
 245       enable = true;
 246       logPerVirtualHost = true;
 247       multiProcessingModule = "worker";
 248       adminAddr = "httpd@immae.eu";
 249       # FIXME: http2
 250       # FIXME: voir les autres modules:
 251       #    authz_core_module
 252       #    reqtimeout_module
 253       #    http2_module
 254       #    version_module
 255       #    proxy_connect_module
 256       #    proxy_ftp_module
 257       #    proxy_scgi_module
 258       #    proxy_ajp_module
 259       #    proxy_balancer_module
 260       #    proxy_express_module
 261       #    lbmethod_byrequests_module
 262       #    lbmethod_bytraffic_module
 263       #    lbmethod_bybusyness_module
 264       #    lbmethod_heartbeat_module
 265
 266       extraModules = pkgs.lib.lists.unique (
 267         mypkgs.adminer.apache.modules ++
 268         mypkgs.nextcloud.apache.modules ++
 269         mypkgs.connexionswing_dev.apache.modules ++
 270         mypkgs.connexionswing_prod.apache.modules ++
 271         mypkgs.ympd.apache.modules ++
 272         mypkgs.git.web.apache.modules ++
 273         mypkgs.mantisbt.apache.modules ++
 274         pkgs.lib.lists.flatten (pkgs.lib.attrsets.mapAttrsToList (n: v: v.modules) apacheConfig) ++
 275         [ "macro" ]);
 276       extraConfig = builtins.concatStringsSep "\n"
 277         (pkgs.lib.attrsets.mapAttrsToList (n: v: v.extraConfig) apacheConfig);
 278       virtualHosts = [
 279         (withSSL "eldiron" // {
 280           listen = [ { ip = "*"; port = 443; } ];
 281           hostName = "eldiron.immae.eu";
 282           documentRoot = ./www;
 283           extraConfig = ''
 284             DirectoryIndex index.htm
 285             '';
 286         })
 287         (withSSL "eldiron" // {
 288           listen = [ { ip = "*"; port = 443; } ];
 289           hostName = "db-1.immae.eu";
 290           documentRoot = null;
 291           extraConfig = builtins.concatStringsSep "\n" [
 292             mypkgs.adminer.apache.vhostConf
 293           ];
 294         })
 295         (withSSL "eldiron" // {
 296           listen = [ { ip = "*"; port = 443; } ];
 297           hostName = "tools.immae.eu";
 298           documentRoot = null;
 299           extraConfig = builtins.concatStringsSep "\n" [
 300             mypkgs.adminer.apache.vhostConf
 301             mypkgs.ympd.apache.vhostConf
 302           ];
 303         })
 304         (withSSL "eldiron" // {
 305           listen = [ { ip = "*"; port = 443; } ];
 306           hostName = "connexionswing.immae.eu";
 307           serverAliases = [ "sandetludo.immae.eu" ];
 308           documentRoot = mypkgs.connexionswing_dev.webRoot;
 309           extraConfig = builtins.concatStringsSep "\n" [
 310             mypkgs.connexionswing_dev.apache.vhostConf
 311           ];
 312         })
 313         (withSSL "eldiron" // {
 314           listen = [ { ip = "*"; port = 443; } ];
 315           hostName = "cloud.immae.eu";
 316           documentRoot = mypkgs.nextcloud.webRoot;
 317           extraConfig = builtins.concatStringsSep "\n" [
 318             mypkgs.nextcloud.apache.vhostConf
 319           ];
 320         })
 321         (withSSL "eldiron" // {
 322           listen = [ { ip = "*"; port = 443; } ];
 323           hostName = "git.immae.eu";
 324           documentRoot = mypkgs.git.web.webRoot;
 325           extraConfig = builtins.concatStringsSep "\n" [
 326             mypkgs.git.web.apache.vhostConf
 327             mypkgs.mantisbt.apache.vhostConf
 328           ] + ''
 329             RewriteEngine on
 330             RewriteCond %{REQUEST_URI}       ^/releases
 331             RewriteRule /releases(.*)        https://release.immae.eu$1 [P,L]
 332             '';
 333         })
 334         { # Should go last, default fallback
 335           listen = [ { ip = "*"; port = 80; } ];
 336           hostName = "redirectSSL";
 337           serverAliases = [ "*" ];
 338           enableSSL = false;
 339           documentRoot = "/var/lib/acme/acme-challenge";
 340           extraConfig = ''
 341             RewriteEngine on
 342             RewriteCond "%{REQUEST_URI}"   "!^/\.well-known"
 343             RewriteRule ^(.+)              https://%{HTTP_HOST}$1  [R=301]
 344             # To redirect in specific "VirtualHost *:80", do
 345             #   RedirectMatch 301 ^/((?!\.well-known.*$).*)$ https://host/$1
 346             # rather than rewrite
 347             '';
 348         }
 349         ];
 350     };
 351
 352     security.pam.services = let
 353       pam_ldap = pkgs.pam_ldap;
 354       pam_ldap_mysql = assert mylibs.checkEnv "NIXOPS_MYSQL_PAM_PASSWORD";
 355               pkgs.writeText "mysql.conf" ''
 356         host ldap.immae.eu
 357         base dc=immae,dc=eu
 358         binddn cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
 359         bindpw ${builtins.getEnv "NIXOPS_MYSQL_PAM_PASSWORD"}
 360         pam_filter memberOf=cn=users,cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
 361         '';
 362     in [
 363       {
 364         name = "mysql";
 365         text = ''
 366           # https://mariadb.com/kb/en/mariadb/pam-authentication-plugin/
 367           auth    required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
 368           account required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
 369           '';
 370       }
 371     ];
 372
 373     # FIXME: backup
 374     services.redis = rec {
 375       enable = true;
 376       bind = "127.0.0.1";
 377       unixSocket = "/run/redis/redis.sock";
 378       extraConfig = ''
 379         unixsocketperm 777
 380         maxclients 1024
 381         '';
 382     };
 383
 384     # FIXME: initial sync
 385     # FIXME: backup
 386     # FIXME: restart after pam
 387     # FIXME: pam access doesn’t work (because of php module)
 388     # FIXME: ssl
 389     services.mysql = rec {
 390       enable = true;
 391       package = pkgs.mariadb.overrideAttrs(old: rec {
 392         cmakeFlags = old.cmakeFlags ++ [ "-DWITH_AUTHENTICATION_PAM=ON" ];
 393         buildInputs = old.buildInputs ++ [ pkgs.pam ];
 394       });
 395     };
 396
 397     # FIXME: initial sync
 398     # FIXME: backup
 399     # FIXME: ssl
 400     services.postgresql = rec {
 401       enable = true;
 402       package = pkgs.postgresql100.overrideAttrs(old: rec {
 403         passthru = old.passthru // { psqlSchema = "11.0"; };
 404         name = "postgresql-11.1";
 405         src = pkgs.fetchurl {
 406           url = "mirror://postgresql/source/v11.1/${name}.tar.bz2";
 407           sha256 = "026v0sicsh7avzi45waf8shcbhivyxmi7qgn9fd1x0vl520mx0ch";
 408         };
 409       });
 410       enableTCPIP = true;
 411       extraConfig = ''
 412         max_connections = 100
 413         wal_level = logical
 414         shared_buffers = 128MB
 415         max_wal_size = 1GB
 416         min_wal_size = 80MB
 417         log_timezone = 'Europe/Paris'
 418         datestyle = 'iso, mdy'
 419         timezone = 'Europe/Paris'
 420         lc_messages = 'en_US.UTF-8'
 421         lc_monetary = 'en_US.UTF-8'
 422         lc_numeric = 'en_US.UTF-8'
 423         lc_time = 'en_US.UTF-8'
 424         default_text_search_config = 'pg_catalog.english'
 425         # ssl = on
 426         # ssl_cert_file = '/var/lib/acme/eldiron/fullchain.pem'
 427         # ssl_key_file = '/var/lib/acme/eldiron/key.pem'
 428         '';
 429       authentication = ''
 430         local   all     postgres                                ident
 431         local   all     all                                     md5
 432         host    all     all             samehost                md5
 433         host    all     all             178.33.252.96/32        md5
 434         host    all     all             188.165.209.148/32      md5
 435         #host   all     all             all                     pam
 436       '';
 437     };
 438   };
 439 }