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