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