[perso/Immae/Config/Nix.git] / virtual / eldiron.nix

{
  network = {
    description = "Immae's network";
    enableRollback = true;
  };

  eldiron = { config, pkgs, ... }:
    with import ../libs.nix;
    let
        mypkgs = nixpkgs_unstable.callPackage ./packages.nix {
          inherit checkEnv fetchedGitPrivate fetchedGithub;
          gitwebOverride = nixpkgs_unstable.gitweb.overrideAttrs(old: {
            installPhase = old.installPhase + ''
              cp -r ${./packages/gitweb} $out/gitweb-theme;
              '';
          });
        };
    in
  {
    # FIXME: they are not overriden in packages.nix
    # (see nix-store -q --tree /nix/var/nix/profiles/system)
    nixpkgs.config.packageOverrides = oldpkgs: rec {
      postgresql = postgresql111;
      postgresql111 = oldpkgs.postgresql100.overrideAttrs(old: rec {
        passthru = old.passthru // { psqlSchema = "11.0"; };
        name = "postgresql-11.1";
        src = pkgs.fetchurl {
          url = "mirror://postgresql/source/v11.1/${name}.tar.bz2";
          sha256 = "026v0sicsh7avzi45waf8shcbhivyxmi7qgn9fd1x0vl520mx0ch";
        };
      });
      mariadb = mariadbPAM;
      mariadbPAM = oldpkgs.mariadb.overrideAttrs(old: rec {
        cmakeFlags = old.cmakeFlags ++ [ "-DWITH_AUTHENTICATION_PAM=ON" ];
        buildInputs = old.buildInputs ++ [ pkgs.pam ];
      });
    };

    networking = {
      firewall = {
        enable = true;
        allowedTCPPorts = [ 22 80 443 3306 5432 9418 ];
      };
    };

    deployment = {
      targetEnv = "hetzner";
      hetzner = {
        #robotUser = "defined in HETZNER_ROBOT_USER";
        #robotPass = "defined in HETZNER_ROBOT_PASS";
        mainIPv4 = "176.9.151.89";
        partitions = ''
          clearpart --all --initlabel --drives=sda,sdb

          part swap1 --recommended --label=swap1 --fstype=swap --ondisk=sda
          part swap2 --recommended --label=swap2 --fstype=swap --ondisk=sdb

          part raid.1 --grow --ondisk=sda
          part raid.2 --grow --ondisk=sdb

          raid / --level=1 --device=md0 --fstype=ext4 --label=root raid.1 raid.2
        '';
      };
    };

    environment.systemPackages = let
      # FIXME: move it to nextcloud
      occ = pkgs.writeScriptBin "nextcloud-occ" ''
        #! ${pkgs.stdenv.shell}
        cd ${mypkgs.nextcloud.webRoot}
        NEXTCLOUD_CONFIG_DIR="${mypkgs.nextcloud.webRoot}/config" \
          exec \
          ${config.services.phpfpm.phpPackage}/bin/php \
          -c ${config.services.phpfpm.phpPackage}/etc/php.ini \
          occ $*
        '';
    in [
      pkgs.telnet
      pkgs.vim
      occ
    ];

    security.acme.certs = {
      "eldiron" = {
        webroot = "/var/lib/acme/acme-challenge";
        email = "ismael@bouya.org";
        domain = "eldiron.immae.eu";
        plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
        postRun = ''
          systemctl reload httpd.service
        '';
        extraDomains = {
          "db-1.immae.eu" = null;
          "git.immae.eu" = null;
          "tools.immae.eu" = null;
          "connexionswing.immae.eu" = null;
          "sandetludo.immae.eu" = null;
          "cloud.immae.eu" = null;
        };
      };
      # "connexionswing" = {
      #   webroot = "/var/lib/acme/acme-challenge";
      #   email = "ismael@bouya.org";
      #   domain = "connexionswing.com";
      #   plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
      #   postRun = ''
      #     systemctl reload httpd.service
      #   '';
      #   extraDomains = {
      #     "www.connexionswing.com" = null;
      #     "sandetludo.com" = null;
      #     "www.sandetludo.com" = null;
      #   };
      # };
    };

    services.openssh.extraConfig = ''
      AuthorizedKeysCommand     /etc/ssh/ldap_authorized_keys
      AuthorizedKeysCommandUser nobody
      '';

    users.users.wwwrun.extraGroups = [ "gitolite" ];

    users.users.gitolite.packages = let
      python-packages = python-packages: with python-packages; [
        simplejson
        urllib3
      ];
    in
      [
        (pkgs.python3.withPackages python-packages)
      ];
    # FIXME: after initial install, need to
    # (1) copy rc file (adjust gitolite_ldap_groups.sh)
    # (2) (mark old readonly and) sync repos except gitolite-admin
    #     rsync -av --exclude=gitolite-admin.git old:/var/lib/gitolite/repositories /var/lib/gitolite/
    #     chown -R gitolite:gitolite /var/lib/gitolite
    # (3) push force the gitolite-admin to new location (from external point)
    #     Don't use an existing key, it will take precedence over
    #     gitolite-admin
    # (4) su -u gitolite gitolite setup
    services.gitolite = {
      enable = true;
      # FIXME: key from ./ssh
      adminPubkey = "ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDXqRbiHw7QoHADNIEuo4nUT9fSOIEBMdJZH0bkQAxXyJFyCM1IMz0pxsHV0wu9tdkkr36bPEUj2aV5bkYLBN6nxcV2Y49X8bjOSCPfx3n6Own1h+NeZVBj4ZByrFmqCbTxUJIZ2bZKcWOFncML39VmWdsVhNjg0X4NBBehqXRIKr2gt3E/ESAxTYJFm0BnU0baciw9cN0bsRGqvFgf5h2P48CIAfwhVcGmPQnnAwabnosYQzRWxR0OygH5Kd8mePh6FheIRIigfXsDO8f/jdxwut8buvNIf3m5EBr3tUbTsvM+eV3M5vKGt7sk8T64DVtepTSdOOWtp+47ktsnHOMh immae@immae.eu";
    };

    services.ympd = mypkgs.ympd.config // { enable = true; };

    services.phpfpm = {
      # /!\ phppackage is used in nextcloud configuation
      phpOptions = ''
        ; For nextcloud
        extension=${pkgs.phpPackages.redis}/lib/php/extensions/redis.so
        ; For nextcloud
        extension=${pkgs.phpPackages.apcu}/lib/php/extensions/apcu.so
        '';
      extraConfig = ''
        log_level = notice
        '';
      poolConfigs = {
        adminer = mypkgs.adminer.phpFpm.pool;
        connexionswing_dev = mypkgs.connexionswing_dev.phpFpm.pool;
        connexionswing_prod = mypkgs.connexionswing_prod.phpFpm.pool;
        nextcloud = mypkgs.nextcloud.phpFpm.pool;
        mantisbt = mypkgs.mantisbt.phpFpm.pool;
      };
    };

    system.activationScripts = {
      connexionswing_dev  = mypkgs.connexionswing_dev.activationScript;
      connexionswing_prod = mypkgs.connexionswing_prod.activationScript;
      nextcloud = mypkgs.nextcloud.activationScript;
      httpd = ''
        install -d -m 0755 /var/lib/acme/acme-challenge
        '';
      redis = ''
        mkdir -p /run/redis
        chown redis /run/redis
        '';
      gitolite =
        assert checkEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
        let
        gitolite_ldap_groups = wrap {
          name = "gitolite_ldap_groups.sh";
          file = ./packages/gitolite_ldap_groups.sh;
          vars = {
            LDAP_PASS = builtins.getEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
          };
          paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.coreutils ];
        };
      in {
        deps = [ "users" ];
        text = ''
          if [ -d /var/lib/gitolite ]; then
            ln -sf ${gitolite_ldap_groups} /var/lib/gitolite/gitolite_ldap_groups.sh
            chmod g+rx /var/lib/gitolite
          fi
          if [ -f /var/lib/gitolite/projects.list ]; then
            chmod g+r /var/lib/gitolite/projects.list
          fi
        '';
      };
    };

    environment.etc."ssh/ldap_authorized_keys" = let
      ldap_authorized_keys =
        assert checkEnv "NIXOPS_SSHD_LDAP_PASSWORD";
        wrap {
          name = "ldap_authorized_keys";
          file = ./ldap_authorized_keys.sh;
          vars = {
            LDAP_PASS = builtins.getEnv "NIXOPS_SSHD_LDAP_PASSWORD";
            GITOLITE_SHELL = "${pkgs.gitolite}/bin/gitolite-shell";
            ECHO = "${pkgs.coreutils}/bin/echo";
          };
          paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.gnused pkgs.coreutils ];
        };
    in {
      enable = true;
      mode = "0755";
      user = "root";
      source = ldap_authorized_keys;
    };

    services.gitDaemon = {
      enable = true;
      user = "gitolite";
      group = "gitolite";
      basePath = "${mypkgs.git.web.varDir}/repositories";
    };

    services.httpd = let
      withSSL = domain: {
        enableSSL = true;
        sslServerCert = "/var/lib/acme/${domain}/cert.pem";
        sslServerKey = "/var/lib/acme/${domain}/key.pem";
        sslServerChain = "/var/lib/acme/${domain}/fullchain.pem";
      };
      apacheConfig = {
        gzip = {
          modules = [ "deflate" "filter" ];
          extraConfig = ''
            AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript
          '';
        };
        ldap = {
          modules = [ "ldap" "authnz_ldap" ];
          extraConfig = assert checkEnv "NIXOPS_HTTP_LDAP_PASSWORD"; ''
            <IfModule ldap_module>
              LDAPSharedCacheSize 500000
              LDAPCacheEntries 1024
              LDAPCacheTTL 600
              LDAPOpCacheEntries 1024
              LDAPOpCacheTTL 600
            </IfModule>

            <Macro LDAPConnect>
              <IfModule authnz_ldap_module>
                AuthLDAPURL          ldap://ldap.immae.eu:389/dc=immae,dc=eu
                AuthLDAPBindDN       cn=httpd,ou=services,dc=immae,dc=eu
                AuthLDAPBindPassword "${builtins.getEnv "NIXOPS_HTTP_LDAP_PASSWORD"}"
                AuthType             Basic
                AuthName             "Authentification requise (Acces LDAP)"
                AuthBasicProvider    ldap
              </IfModule>
            </Macro>
          '';
        };
      };
    in rec {
      enable = true;
      logPerVirtualHost = true;
      multiProcessingModule = "worker";
      adminAddr = "httpd@immae.eu";
      # FIXME: http2
      # FIXME: voir les autres modules:
      #    authz_core_module
      #    reqtimeout_module
      #    http2_module
      #    version_module
      #    proxy_connect_module
      #    proxy_ftp_module
      #    proxy_scgi_module
      #    proxy_ajp_module
      #    proxy_balancer_module
      #    proxy_express_module
      #    lbmethod_byrequests_module
      #    lbmethod_bytraffic_module
      #    lbmethod_bybusyness_module
      #    lbmethod_heartbeat_module

      extraModules = pkgs.lib.lists.unique (
        mypkgs.adminer.apache.modules ++
        mypkgs.nextcloud.apache.modules ++
        mypkgs.connexionswing_dev.apache.modules ++
        mypkgs.connexionswing_prod.apache.modules ++
        mypkgs.ympd.apache.modules ++
        mypkgs.git.web.apache.modules ++
        mypkgs.mantisbt.apache.modules ++
        pkgs.lib.lists.flatten (pkgs.lib.attrsets.mapAttrsToList (n: v: v.modules) apacheConfig) ++
        [ "macro" ]);
      extraConfig = builtins.concatStringsSep "\n"
        (pkgs.lib.attrsets.mapAttrsToList (n: v: v.extraConfig) apacheConfig);
      virtualHosts = [
        (withSSL "eldiron" // {
          listen = [ { ip = "*"; port = 443; } ];
          hostName = "eldiron.immae.eu";
          documentRoot = ./www;
          extraConfig = ''
            DirectoryIndex index.htm
            '';
        })
        (withSSL "eldiron" // {
          listen = [ { ip = "*"; port = 443; } ];
          hostName = "db-1.immae.eu";
          documentRoot = null;
          extraConfig = builtins.concatStringsSep "\n" [
            mypkgs.adminer.apache.vhostConf
          ];
        })
        (withSSL "eldiron" // {
          listen = [ { ip = "*"; port = 443; } ];
          hostName = "tools.immae.eu";
          documentRoot = null;
          extraConfig = builtins.concatStringsSep "\n" [
            mypkgs.adminer.apache.vhostConf
            mypkgs.ympd.apache.vhostConf
          ];
        })
        (withSSL "eldiron" // {
          listen = [ { ip = "*"; port = 443; } ];
          hostName = "connexionswing.immae.eu";
          serverAliases = [ "sandetludo.immae.eu" ];
          documentRoot = mypkgs.connexionswing_dev.webRoot;
          extraConfig = builtins.concatStringsSep "\n" [
            mypkgs.connexionswing_dev.apache.vhostConf
          ];
        })
        (withSSL "eldiron" // {
          listen = [ { ip = "*"; port = 443; } ];
          hostName = "cloud.immae.eu";
          documentRoot = mypkgs.nextcloud.webRoot;
          extraConfig = builtins.concatStringsSep "\n" [
            mypkgs.nextcloud.apache.vhostConf
          ];
        })
        (withSSL "eldiron" // {
          listen = [ { ip = "*"; port = 443; } ];
          hostName = "git.immae.eu";
          documentRoot = mypkgs.git.web.webRoot;
          extraConfig = builtins.concatStringsSep "\n" [
            mypkgs.git.web.apache.vhostConf
            mypkgs.mantisbt.apache.vhostConf
          ] + ''
            RewriteEngine on
            RewriteCond %{REQUEST_URI}       ^/releases
            RewriteRule /releases(.*)        https://release.immae.eu$1 [P,L]
            '';
        })
        { # Should go last, default fallback
          listen = [ { ip = "*"; port = 80; } ];
          hostName = "redirectSSL";
          serverAliases = [ "*" ];
          enableSSL = false;
          documentRoot = "/var/lib/acme/acme-challenge";
          extraConfig = ''
            RewriteEngine on
            RewriteCond "%{REQUEST_URI}"   "!^/\.well-known"
            RewriteRule ^(.+)              https://%{HTTP_HOST}$1  [R=301]
            # To redirect in specific "VirtualHost *:80", do
            #   RedirectMatch 301 ^/((?!\.well-known.*$).*)$ https://host/$1
            # rather than rewrite
            '';
        }
        ];
    };

    security.pam.services = let
      pam_ldap = pkgs.pam_ldap;
      pam_ldap_mysql = assert checkEnv "NIXOPS_MYSQL_PAM_PASSWORD";
              pkgs.writeText "mysql.conf" ''
        host ldap.immae.eu
        base dc=immae,dc=eu
        binddn cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
        bindpw ${builtins.getEnv "NIXOPS_MYSQL_PAM_PASSWORD"}
        pam_filter memberOf=cn=users,cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
        '';
    in [
      {
        name = "mysql";
        text = ''
          # https://mariadb.com/kb/en/mariadb/pam-authentication-plugin/
          auth    required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
          account required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
          '';
      }
    ];

    # FIXME: backup
    services.redis = rec {
      enable = true;
      bind = "127.0.0.1";
      unixSocket = "/run/redis/redis.sock";
      extraConfig = ''
        unixsocketperm 777
        maxclients 1024
        '';
    };

    # FIXME: initial sync
    # FIXME: backup
    # FIXME: restart after pam
    # FIXME: pam access doesn’t work (because of php module)
    # FIXME: ssl
    services.mysql = rec {
      enable = true;
      package = pkgs.mariadb;
    };

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