]> git.immae.eu Git - perso/Immae/Config/Nix.git/blame - virtual/eldiron.nix
projects / perso / Immae / Config / Nix.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Move each php session to a private destination
[perso/Immae/Config/Nix.git] / virtual / eldiron.nix
CommitLineData
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
712ccefd 10 mypkgs = pkgs.callPackage ./packages.nix {
5c101474 11 inherit checkEnv fetchedGitPrivate fetchedGithub;
5c101474 12 };
ab5d04b8
IB		 13 in
14 {
91493dc0 15 nixpkgs.config.packageOverrides = oldpkgs: rec {
c5aaa64a
IB		 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 });
712ccefd
IB		 26 gitweb = oldpkgs.gitweb.overrideAttrs(old: {
27 installPhase = old.installPhase + ''
28 cp -r ${./packages/gitweb} $out/gitweb-theme;
29 '';
30 });
91493dc0
IB		 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 });
6f0d92b4
IB		 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 });
91493dc0
IB		 55 };
56
a1bb33c4
IB		 57 networking = {
58 firewall = {
59 enable = true;
7611e4e2 60 allowedTCPPorts = [ 22 80 443 3306 5432 9418 ];
a1bb33c4
IB		 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
66b5bbf6
IB		 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 [
ce6ee3b8 96 pkgs.telnet
beeed847 97 pkgs.htop
ce6ee3b8 98 pkgs.vim
6f0d92b4 99 pkgs.goaccess
66b5bbf6 100 occ
ce6ee3b8
IB		 101 ];
102
6bd6d033
IB		 103 # FIXME: doesn't work with httpd?
104 security.acme.preliminarySelfsigned = true;
a1bb33c4 105 security.acme.certs = {
6bd6d033
IB		 106 # FIXME: /!\ To create a new certificate, create it before using
107 # it in httpd
a1bb33c4
IB		 108 "eldiron" = {
109 webroot = "/var/lib/acme/acme-challenge";
110 email = "ismael@bouya.org";
111 domain = "eldiron.immae.eu";
e379fd29
IB		 112 plugins = [ "cert.pem" "chain.pem" "fullchain.pem" "full.pem" "key.pem" "account_key.json" ];
113 postRun = ''
e273ef92 114 systemctl reload httpd.service
e379fd29 115 '';
beeed847 116 allowKeysForGroup = true;
a1bb33c4
IB		 117 extraDomains = {
118 "db-1.immae.eu" = null;
1b81e079 119 "git.immae.eu" = null;
e379fd29 120 "tools.immae.eu" = null;
65fe7543
IB		 121 "connexionswing.immae.eu" = null;
122 "sandetludo.immae.eu" = null;
66b5bbf6 123 "cloud.immae.eu" = null;
e42ba74f 124 "ludivine.immae.eu" = null;
6c672f34 125 "dev.aten.pro" = null;
34e2fd14 126 "piedsjaloux.immae.eu" = null;
7d8b50d3 127 "chloe.immae.eu" = null;
e42ba74f
IB		 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;
a1bb33c4
IB		 140 };
141 };
6c672f34
IB		 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 };
34e2fd14
IB		 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 };
6bd6d033
IB		 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 };
e273ef92
IB		 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 # };
a1bb33c4
IB		 192 };
193
5566d26d
IB		 194 services.openssh.extraConfig = ''
195 AuthorizedKeysCommand /etc/ssh/ldap_authorized_keys
196 AuthorizedKeysCommandUser nobody
197 '';
198
cf80b4f2
IB		 199 users.users.wwwrun.extraGroups = [ "gitolite" ];
200
19def671
IB		 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 ];
5566d26d
IB		 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
beeed847 225 services.ympd = mypkgs.ympd.config // { enable = false; };
a05f8abe 226
58d1a782 227 services.phpfpm = {
beeed847 228 # FIXME: move session files to separate dirs
66b5bbf6
IB		 229 # /!\ phppackage is used in nextcloud configuation
230 phpOptions = ''
c8e019b6
IB		 231 session.save_path = "/var/lib/php/sessions"
232 session.gc_maxlifetime = 60*60*24*15
233 session.cache_expire = 60*24*30
66b5bbf6
IB		 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
ec9ff2b8
IB		 238 ; For nextcloud
239 zend_extension=${pkgs.php}/lib/php/extensions/opcache.so
66b5bbf6 240 '';
58d1a782
IB		 241 extraConfig = ''
242 log_level = notice
243 '';
244 poolConfigs = {
27e22b76 245 adminer = mypkgs.adminer.phpFpm.pool;
65fe7543 246 connexionswing_dev = mypkgs.connexionswing_dev.phpFpm.pool;
e273ef92 247 connexionswing_prod = mypkgs.connexionswing_prod.phpFpm.pool;
e42ba74f
IB		 248 ludivinecassal_dev = mypkgs.ludivinecassal_dev.phpFpm.pool;
249 ludivinecassal_prod = mypkgs.ludivinecassal_prod.phpFpm.pool;
34e2fd14
IB		 250 piedsjaloux_dev = mypkgs.piedsjaloux_dev.phpFpm.pool;
251 piedsjaloux_prod = mypkgs.piedsjaloux_prod.phpFpm.pool;
7d8b50d3
IB		 252 chloe_dev = mypkgs.chloe_dev.phpFpm.pool;
253 chloe_prod = mypkgs.chloe_prod.phpFpm.pool;
6c672f34
IB		 254 aten_dev = mypkgs.aten_dev.phpFpm.pool;
255 aten_prod = mypkgs.aten_prod.phpFpm.pool;
66b5bbf6 256 nextcloud = mypkgs.nextcloud.phpFpm.pool;
50d8fa14 257 mantisbt = mypkgs.mantisbt.phpFpm.pool;
58d1a782
IB		 258 };
259 };
260
65fe7543
IB		 261 system.activationScripts = {
262 connexionswing_dev = mypkgs.connexionswing_dev.activationScript;
e273ef92 263 connexionswing_prod = mypkgs.connexionswing_prod.activationScript;
e42ba74f 264 ludivinecassal_dev = mypkgs.ludivinecassal_dev.activationScript;
34e2fd14
IB		 265 ludivinecassal_prod = mypkgs.ludivinecassal_prod.activationScript;
266 piedsjaloux_dev = mypkgs.piedsjaloux_dev.activationScript;
267 piedsjaloux_prod = mypkgs.piedsjaloux_prod.activationScript;
7d8b50d3
IB		 268 chloe_dev = mypkgs.chloe_dev.activationScript;
269 chloe_prod = mypkgs.chloe_prod.activationScript;
6c672f34
IB		 270 aten_dev = mypkgs.aten_dev.activationScript;
271 aten_prod = mypkgs.aten_prod.activationScript;
66b5bbf6 272 nextcloud = mypkgs.nextcloud.activationScript;
5dd28b43
IB		 273 httpd = ''
274 install -d -m 0755 /var/lib/acme/acme-challenge
c8e019b6
IB		 275 install -d -m 0750 -o wwwrun -g wwwrun /var/lib/php/sessions
276 install -d -m 0750 -o wwwrun -g wwwrun /var/lib/php/sessions/adminer
277 install -d -m 0750 -o wwwrun -g wwwrun /var/lib/php/sessions/mantisbt
5dd28b43 278 '';
60f67ae3
IB		 279 redis = ''
280 mkdir -p /run/redis
281 chown redis /run/redis
282 '';
5566d26d 283 gitolite =
5c101474 284 assert checkEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
5566d26d 285 let
5c101474 286 gitolite_ldap_groups = wrap {
5566d26d
IB		 287 name = "gitolite_ldap_groups.sh";
288 file = ./packages/gitolite_ldap_groups.sh;
289 vars = {
290 LDAP_PASS = builtins.getEnv "NIXOPS_GITOLITE_LDAP_PASSWORD";
291 };
292 paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.coreutils ];
293 };
294 in {
295 deps = [ "users" ];
296 text = ''
297 if [ -d /var/lib/gitolite ]; then
298 ln -sf ${gitolite_ldap_groups} /var/lib/gitolite/gitolite_ldap_groups.sh
cf80b4f2
IB		 299 chmod g+rx /var/lib/gitolite
300 fi
301 if [ -f /var/lib/gitolite/projects.list ]; then
302 chmod g+r /var/lib/gitolite/projects.list
5566d26d
IB		 303 fi
304 '';
305 };
6bd6d033 306 # FIXME: initial sync
6f0d92b4
IB		 307 goaccess = ''
308 mkdir -p /var/lib/goaccess
309 mkdir -p /var/lib/goaccess/aten.pro
34e2fd14
IB		 310 mkdir -p /var/lib/goaccess/ludivinecassal.com
311 mkdir -p /var/lib/goaccess/piedsjaloux.fr
6bd6d033 312 mkdir -p /var/lib/goaccess/osteopathe-cc.fr
6f0d92b4 313 '';
5566d26d
IB		 314 };
315
316 environment.etc."ssh/ldap_authorized_keys" = let
317 ldap_authorized_keys =
5c101474
IB		 318 assert checkEnv "NIXOPS_SSHD_LDAP_PASSWORD";
319 wrap {
5566d26d
IB		 320 name = "ldap_authorized_keys";
321 file = ./ldap_authorized_keys.sh;
322 vars = {
323 LDAP_PASS = builtins.getEnv "NIXOPS_SSHD_LDAP_PASSWORD";
324 GITOLITE_SHELL = "${pkgs.gitolite}/bin/gitolite-shell";
325 ECHO = "${pkgs.coreutils}/bin/echo";
326 };
327 paths = [ pkgs.openldap pkgs.stdenv.shellPackage pkgs.gnugrep pkgs.gnused pkgs.coreutils ];
328 };
329 in {
330 enable = true;
331 mode = "0755";
332 user = "root";
333 source = ldap_authorized_keys;
65fe7543
IB		 334 };
335
7611e4e2
IB		 336 services.gitDaemon = {
337 enable = true;
338 user = "gitolite";
339 group = "gitolite";
340 basePath = "${mypkgs.git.web.varDir}/repositories";
341 };
342
beeed847 343 # FIXME: logrotate
58d1a782 344 services.httpd = let
b7cd7e4b 345 withConf = domain: {
58d1a782 346 enableSSL = true;
5dd28b43 347 sslServerCert = "/var/lib/acme/${domain}/cert.pem";
58d1a782
IB		 348 sslServerKey = "/var/lib/acme/${domain}/key.pem";
349 sslServerChain = "/var/lib/acme/${domain}/fullchain.pem";
b7cd7e4b
IB		 350 logFormat = "combinedVhost";
351 listen = [ { ip = "*"; port = 443; } ];
58d1a782 352 };
94818b75
IB		 353 apacheConfig = {
354 gzip = {
355 modules = [ "deflate" "filter" ];
356 extraConfig = ''
357 AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript
358 '';
359 };
360 ldap = {
361 modules = [ "ldap" "authnz_ldap" ];
5c101474 362 extraConfig = assert checkEnv "NIXOPS_HTTP_LDAP_PASSWORD"; ''
94818b75
IB		 363 <IfModule ldap_module>
364 LDAPSharedCacheSize 500000
365 LDAPCacheEntries 1024
366 LDAPCacheTTL 600
367 LDAPOpCacheEntries 1024
368 LDAPOpCacheTTL 600
369 </IfModule>
370
371 <Macro LDAPConnect>
372 <IfModule authnz_ldap_module>
373 AuthLDAPURL ldap://ldap.immae.eu:389/dc=immae,dc=eu
374 AuthLDAPBindDN cn=httpd,ou=services,dc=immae,dc=eu
375 AuthLDAPBindPassword "${builtins.getEnv "NIXOPS_HTTP_LDAP_PASSWORD"}"
376 AuthType Basic
377 AuthName "Authentification requise (Acces LDAP)"
378 AuthBasicProvider ldap
379 </IfModule>
380 </Macro>
6f0d92b4
IB		 381
382 <Macro Stats %{domain}>
383 Alias /awstats /var/lib/goaccess/%{domain}
384 <Directory /var/lib/goaccess/%{domain}>
385 DirectoryIndex index.html
386 AllowOverride None
387 Require all granted
388 </Directory>
389 <Location /awstats>
390 Use LDAPConnect
391 Require ldap-group cn=%{domain},ou=stats,cn=httpd,ou=services,dc=immae,dc=eu
392 </Location>
393 </Macro>
94818b75
IB		 394 '';
395 };
b7cd7e4b
IB		 396 http2 = {
397 modules = [ "http2" ];
398 extraConfig = ''
399 Protocols h2 http/1.1
400 '';
401 };
402 customLog = {
403 modules = [];
404 extraConfig = ''
6f0d92b4 405 LogFormat "%v:%p %h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combinedVhost
b7cd7e4b
IB		 406 '';
407 };
94818b75 408 };
58d1a782 409 in rec {
a1bb33c4 410 enable = true;
58d1a782
IB		 411 logPerVirtualHost = true;
412 multiProcessingModule = "worker";
413 adminAddr = "httpd@immae.eu";
b7cd7e4b 414 logFormat = "combinedVhost";
25fd1d16
IB		 415 extraModules = pkgs.lib.lists.unique (
416 mypkgs.adminer.apache.modules ++
66b5bbf6 417 mypkgs.nextcloud.apache.modules ++
65fe7543 418 mypkgs.connexionswing_dev.apache.modules ++
e273ef92 419 mypkgs.connexionswing_prod.apache.modules ++
e42ba74f
IB		 420 mypkgs.ludivinecassal_dev.apache.modules ++
421 mypkgs.ludivinecassal_prod.apache.modules ++
34e2fd14
IB		 422 mypkgs.piedsjaloux_dev.apache.modules ++
423 mypkgs.piedsjaloux_prod.apache.modules ++
7d8b50d3
IB		 424 mypkgs.chloe_dev.apache.modules ++
425 mypkgs.chloe_prod.apache.modules ++
6c672f34
IB		 426 mypkgs.aten_dev.apache.modules ++
427 mypkgs.aten_prod.apache.modules ++
5f3e023d 428 mypkgs.ympd.apache.modules ++
cf80b4f2 429 mypkgs.git.web.apache.modules ++
50d8fa14 430 mypkgs.mantisbt.apache.modules ++
94818b75
IB		 431 pkgs.lib.lists.flatten (pkgs.lib.attrsets.mapAttrsToList (n: v: v.modules) apacheConfig) ++
432 [ "macro" ]);
433 extraConfig = builtins.concatStringsSep "\n"
434 (pkgs.lib.attrsets.mapAttrsToList (n: v: v.extraConfig) apacheConfig);
58d1a782 435 virtualHosts = [
b7cd7e4b 436 (withConf "eldiron" // {
58d1a782 437 hostName = "eldiron.immae.eu";
1d4ccb2c
IB		 438 documentRoot = ./www;
439 extraConfig = ''
440 DirectoryIndex index.htm
441 '';
58d1a782 442 })
b7cd7e4b 443 (withConf "eldiron" // {
58d1a782
IB		 444 hostName = "db-1.immae.eu";
445 documentRoot = null;
27e22b76 446 extraConfig = builtins.concatStringsSep "\n" [
1bb2ff2c 447 mypkgs.adminer.apache.vhostConf
27e22b76 448 ];
58d1a782 449 })
b7cd7e4b 450 (withConf "eldiron" // {
e379fd29
IB		 451 hostName = "tools.immae.eu";
452 documentRoot = null;
453 extraConfig = builtins.concatStringsSep "\n" [
1bb2ff2c 454 mypkgs.adminer.apache.vhostConf
a05f8abe 455 mypkgs.ympd.apache.vhostConf
e379fd29
IB		 456 ];
457 })
b7cd7e4b 458 (withConf "eldiron" // {
65fe7543
IB		 459 hostName = "connexionswing.immae.eu";
460 serverAliases = [ "sandetludo.immae.eu" ];
461 documentRoot = mypkgs.connexionswing_dev.webRoot;
462 extraConfig = builtins.concatStringsSep "\n" [
463 mypkgs.connexionswing_dev.apache.vhostConf
464 ];
465 })
e42ba74f
IB		 466 (withConf "eldiron" // {
467 hostName = "ludivine.immae.eu";
468 documentRoot = mypkgs.ludivinecassal_dev.webRoot;
469 extraConfig = builtins.concatStringsSep "\n" [
470 mypkgs.ludivinecassal_dev.apache.vhostConf
471 ];
472 })
473 (withConf "ludivinecassal" // {
474 hostName = "ludivinecassal.com";
475 serverAliases = [ "www.ludivinecassal.com" ];
476 documentRoot = mypkgs.ludivinecassal_prod.webRoot;
477 extraConfig = builtins.concatStringsSep "\n" [
478 mypkgs.ludivinecassal_prod.apache.vhostConf
479 ];
480 })
34e2fd14
IB		 481 (withConf "eldiron" // {
482 hostName = "piedsjaloux.immae.eu";
483 documentRoot = mypkgs.piedsjaloux_dev.webRoot;
484 extraConfig = builtins.concatStringsSep "\n" [
485 mypkgs.piedsjaloux_dev.apache.vhostConf
486 ];
487 })
488 (withConf "piedsjaloux" // {
489 hostName = "piedsjaloux.fr";
490 serverAliases = [ "www.piedsjaloux.fr" ];
491 documentRoot = mypkgs.piedsjaloux_prod.webRoot;
492 extraConfig = builtins.concatStringsSep "\n" [
493 mypkgs.piedsjaloux_prod.apache.vhostConf
494 ];
495 })
7d8b50d3
IB		 496 (withConf "eldiron" // {
497 hostName = "chloe.immae.eu";
498 documentRoot = mypkgs.chloe_dev.webRoot;
499 extraConfig = builtins.concatStringsSep "\n" [
500 mypkgs.chloe_dev.apache.vhostConf
501 ];
502 })
6bd6d033 503 (withConf "chloe" // {
7d8b50d3
IB		 504 hostName = "osteopathe-cc.fr";
505 serverAliases = [ "www.osteopathe-cc.fr" ];
506 documentRoot = mypkgs.chloe_prod.webRoot;
507 extraConfig = builtins.concatStringsSep "\n" [
508 mypkgs.chloe_prod.apache.vhostConf
509 ];
510 })
6c672f34
IB		 511 (withConf "eldiron" // {
512 hostName = "dev.aten.pro";
513 documentRoot = mypkgs.aten_dev.webRoot;
514 extraConfig = builtins.concatStringsSep "\n" [
515 mypkgs.aten_dev.apache.vhostConf
516 ];
517 })
518 (withConf "aten" // {
519 hostName = "aten.pro";
520 serverAliases = [ "www.aten.pro" ];
521 documentRoot = mypkgs.aten_prod.webRoot;
522 extraConfig = builtins.concatStringsSep "\n" [
523 mypkgs.aten_prod.apache.vhostConf
524 ];
525 })
b7cd7e4b 526 (withConf "eldiron" // {
66b5bbf6
IB		 527 hostName = "cloud.immae.eu";
528 documentRoot = mypkgs.nextcloud.webRoot;
529 extraConfig = builtins.concatStringsSep "\n" [
530 mypkgs.nextcloud.apache.vhostConf
531 ];
532 })
b7cd7e4b 533 (withConf "eldiron" // {
cf80b4f2
IB		 534 hostName = "git.immae.eu";
535 documentRoot = mypkgs.git.web.webRoot;
536 extraConfig = builtins.concatStringsSep "\n" [
537 mypkgs.git.web.apache.vhostConf
50d8fa14 538 mypkgs.mantisbt.apache.vhostConf
cf80b4f2
IB		 539 ] + ''
540 RewriteEngine on
541 RewriteCond %{REQUEST_URI} ^/releases
542 RewriteRule /releases(.*) https://release.immae.eu$1 [P,L]
543 '';
544 })
58d1a782
IB		 545 { # Should go last, default fallback
546 listen = [ { ip = "*"; port = 80; } ];
547 hostName = "redirectSSL";
548 serverAliases = [ "*" ];
549 enableSSL = false;
b7cd7e4b 550 logFormat = "combinedVhost";
58d1a782
IB		 551 documentRoot = "/var/lib/acme/acme-challenge";
552 extraConfig = ''
553 RewriteEngine on
554 RewriteCond "%{REQUEST_URI}" "!^/\.well-known"
555 RewriteRule ^(.+) https://%{HTTP_HOST}$1 [R=301]
556 # To redirect in specific "VirtualHost *:80", do
557 # RedirectMatch 301 ^/((?!\.well-known.*$).*)$ https://host/$1
558 # rather than rewrite
559 '';
560 }
561 ];
562 };
563
dedf591d
IB		 564 security.pam.services = let
565 pam_ldap = pkgs.pam_ldap;
5c101474 566 pam_ldap_mysql = assert checkEnv "NIXOPS_MYSQL_PAM_PASSWORD";
6cd8d6ce 567 pkgs.writeText "mysql.conf" ''
dedf591d
IB		 568 host ldap.immae.eu
569 base dc=immae,dc=eu
570 binddn cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
571 bindpw ${builtins.getEnv "NIXOPS_MYSQL_PAM_PASSWORD"}
572 pam_filter memberOf=cn=users,cn=mysql,cn=pam,ou=services,dc=immae,dc=eu
573 '';
574 in [
575 {
576 name = "mysql";
577 text = ''
578 # https://mariadb.com/kb/en/mariadb/pam-authentication-plugin/
579 auth required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
580 account required ${pam_ldap}/lib/security/pam_ldap.so config=${pam_ldap_mysql}
581 '';
582 }
583 ];
584
60f67ae3 585 # FIXME: backup
beeed847 586 # Nextcloud: 14
60f67ae3
IB		 587 services.redis = rec {
588 enable = true;
589 bind = "127.0.0.1";
590 unixSocket = "/run/redis/redis.sock";
591 extraConfig = ''
592 unixsocketperm 777
593 maxclients 1024
594 '';
595 };
596
dedf591d
IB		 597 # FIXME: initial sync
598 # FIXME: backup
599 # FIXME: restart after pam
600 # FIXME: pam access doesn’t work (because of php module)
27e22b76 601 # FIXME: ssl
dedf591d
IB		 602 services.mysql = rec {
603 enable = true;
91493dc0 604 package = pkgs.mariadb;
dedf591d
IB		 605 };
606
a1bb33c4 607 # FIXME: initial sync
dedf591d 608 # FIXME: backup
27e22b76 609 # FIXME: ssl
a1bb33c4
IB		 610 services.postgresql = rec {
611 enable = true;
91493dc0 612 package = pkgs.postgresql;
a1bb33c4
IB		 613 enableTCPIP = true;
614 extraConfig = ''
615 max_connections = 100
616 wal_level = logical
617 shared_buffers = 128MB
618 max_wal_size = 1GB
619 min_wal_size = 80MB
620 log_timezone = 'Europe/Paris'
621 datestyle = 'iso, mdy'
622 timezone = 'Europe/Paris'
623 lc_messages = 'en_US.UTF-8'
624 lc_monetary = 'en_US.UTF-8'
625 lc_numeric = 'en_US.UTF-8'
626 lc_time = 'en_US.UTF-8'
627 default_text_search_config = 'pg_catalog.english'
628 # ssl = on
629 # ssl_cert_file = '/var/lib/acme/eldiron/fullchain.pem'
630 # ssl_key_file = '/var/lib/acme/eldiron/key.pem'
631 '';
632 authentication = ''
633 local all postgres ident
634 local all all md5
50d8fa14 635 host all all samehost md5
a1bb33c4
IB		 636 host all all 178.33.252.96/32 md5
637 host all all 188.165.209.148/32 md5
638 #host all all all pam
639 '';
640 };
6f0d92b4
IB		 641
642 services.cron = {
643 enable = true;
644 systemCronJobs = let
6bd6d033
IB		 645 stats = domain: conf: let
646 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}";
647 in "${d}/bin/stats-${domain}";
6f0d92b4
IB		 648 in [
649 "5 0 * * * root ${stats "aten.pro" ./packages/aten_goaccess.conf}"
2f2b578b 650 "5 0 * * * root ${stats "ludivinecassal.com" ./packages/ludivinecassal_goaccess.conf}"
34e2fd14 651 "5 0 * * * root ${stats "piedsjaloux.fr" ./packages/piedsjaloux_goaccess.conf}"
6bd6d033 652 "5 0 * * * root ${stats "osteopathe-cc.fr" ./packages/chloe_goaccess.conf}"
6f0d92b4
IB		 653 ];
654 };
a1bb33c4
IB		 655 };
656}
My infrastructure configuration