modules/private/websites/florian/app.nix

   1 { lib, pkgs, config,  ... }:
   2 let
   3   adminer = pkgs.callPackage ../commons/adminer.nix { inherit config; };
   4   secrets = config.myEnv.websites.tellesflorian.integration;
   5   cfg = config.myServices.websites.florian.app;
   6   ftpRoot = "/var/lib/florian_app";
   7   phpRoot = "${ftpRoot}/php";
   8   webRoot = "${phpRoot}/web";
   9   varDir = "${ftpRoot}/var";
  10   packagePath = "/var/lib/ftp/release.immae.eu/buildbot/Florian";
  11   branch = "stabilo_dev";
  12 in {
  13   options.myServices.websites.florian.app.enable = lib.mkEnableOption "enable Florian's app in integration";
  14
  15   config = lib.mkIf cfg.enable {
  16     services.phpfpm.pools.florian_app = {
  17       user = config.services.httpd.Inte.user;
  18       group = config.services.httpd.Inte.group;
  19       settings = {
  20         "listen.owner" = config.services.httpd.Inte.user;
  21         "listen.group" = config.services.httpd.Inte.group;
  22         "php_admin_value[open_basedir]" = builtins.concatStringsSep ":" [
  23           ftpRoot
  24           config.secrets.fullPaths."websites/florian/app"
  25           "/tmp"
  26         ];
  27         "php_admin_value[session.save_handler]" = "redis";
  28         "php_admin_value[session.save_path]" = "'unix:///run/redis-php-sessions/redis.sock?persistent=1&prefix=Florian:App:'";
  29         "php_admin_value[upload_max_filesize]" = "20M";
  30         "php_admin_value[post_max_size]" = "20M";
  31         #"php_admin_flag[log_errors]" = "on";
  32         "pm" = "ondemand";
  33         "pm.max_children" = "5";
  34         "pm.process_idle_timeout" = "60";
  35       };
  36       phpEnv = {
  37         SYMFONY_DEBUG_MODE = "\"yes\"";
  38       };
  39       phpPackage = pkgs.php72.withExtensions({ enabled, all }: enabled ++ [all.redis]);
  40     };
  41     systemd.services."phpfpm-florian_app" = {
  42       after = lib.mkAfter ["mysql.service"];
  43       wants = ["mysql.service"];
  44       path = lib.mkAfter [ pkgs.gnutar pkgs.gzip pkgs.php72 ];
  45       preStart = let
  46         script = pkgs.writeScriptBin "florian-app-pre" ''
  47           #! ${pkgs.stdenv.shell}
  48
  49           [ -f ${packagePath}/${branch}.tar.gz ] || exit 1
  50
  51           cd ${ftpRoot}
  52           if ! [ -f .tarball_sum ] || ! sha256sum -c .tarball_sum; then
  53             tar -xf ${packagePath}/${branch}.tar.gz --one-top-level=php_new
  54             if [ -d php ]; then
  55               mv php php_old
  56             fi
  57             mv php_new php
  58           fi
  59           cd php
  60           rm -rf var/{logs,cache}
  61           ln -sf ${varDir}/{logs,cache,sessions} var/
  62           ln -sf ${config.secrets.fullPaths."websites/florian/app"} app/config/parameters.yml
  63           SYMFONY_ENV=dev ./bin/console --env=dev cache:clear --no-warmup
  64           sha256sum ${packagePath}/${branch}.tar.gz > ${ftpRoot}/.tarball_sum
  65         '';
  66       in
  67         "/run/wrappers/bin/sudo -u ${config.services.httpd.Inte.user} ${script}/bin/florian-app-pre";
  68       postStart = let
  69         script = pkgs.writeScriptBin "florian-app-post" ''
  70           #! ${pkgs.stdenv.shell}
  71
  72           cd ${ftpRoot}
  73           if [ -d php_old ]; then
  74             rm -rf php_old
  75           fi
  76         '';
  77       in
  78         "/run/wrappers/bin/sudo -u ${config.services.httpd.Inte.user} ${script}/bin/florian-app-post";
  79       serviceConfig.TimeoutStartSec="infinity";
  80     };
  81     services.filesWatcher.phpfpm-florian_app = {
  82       restart = true;
  83       paths = [ "${packagePath}/${branch}.tar.gz" ];
  84     };
  85
  86     system.activationScripts.florian_app = {
  87       deps = ["users"];
  88       text = ''
  89         install -m 0700 -o ${config.services.httpd.Inte.user} -g ${config.services.httpd.Inte.group} -d ${ftpRoot}
  90       '';
  91     };
  92
  93     secrets.keys = {
  94       "websites/florian/app_passwords" = {
  95         user = config.services.httpd.Inte.user;
  96         group = config.services.httpd.Inte.group;
  97         permissions = "0400";
  98         text = ''
  99           invite:${secrets.invite_passwords}
 100         '';
 101       };
 102       "websites/florian/app" = {
 103         user = config.services.httpd.Inte.user;
 104         group = config.services.httpd.Inte.group;
 105         permissions = "0400";
 106         text = ''
 107           # This file is auto-generated during the composer install
 108           parameters:
 109             database_host: ${secrets.mysql.host}
 110             database_port: ${secrets.mysql.port}
 111             database_name: ${secrets.mysql.database}
 112             database_user: ${secrets.mysql.user}
 113             database_password: ${secrets.mysql.password}
 114             mailer_transport: smtp
 115             mailer_host: 127.0.0.1
 116             mailer_user: null
 117             mailer_password: null
 118             secret: ${secrets.secret}
 119         '';
 120       };
 121     };
 122
 123     services.websites.env.integration.modules = adminer.apache.modules;
 124     services.websites.env.integration.vhostConfs.florian_app = {
 125       certName    = "integration";
 126       addToCerts  = true;
 127       hosts       = [ "app.tellesflorian.com" ];
 128       root        = webRoot;
 129       extraConfig = [
 130         ''
 131         <FilesMatch "\.php$">
 132           SetHandler "proxy:unix:${config.services.phpfpm.pools.florian_app.socket}|fcgi://localhost"
 133         </FilesMatch>
 134
 135         <Location />
 136           AuthBasicProvider file ldap
 137           Use LDAPConnect
 138           Require ldap-group   cn=app.tellesflorian.com,cn=httpd,ou=services,dc=immae,dc=eu
 139
 140           AuthUserFile "${config.secrets.fullPaths."websites/florian/app_passwords"}"
 141           Require user "invite"
 142
 143           ErrorDocument 401 "<html><meta http-equiv=\"refresh\" content=\"0;url=https://tellesflorian.com\"></html>"
 144         </Location>
 145
 146         <Directory ${webRoot}>
 147           Options Indexes FollowSymLinks MultiViews Includes
 148           AllowOverride None
 149           Require all granted
 150
 151           DirectoryIndex app_dev.php
 152
 153           <IfModule mod_negotiation.c>
 154           Options -MultiViews
 155           </IfModule>
 156
 157           <IfModule mod_rewrite.c>
 158             RewriteEngine On
 159
 160             RewriteCond %{REQUEST_URI}::$1 ^(/.+)/(.*)::\2$
 161             RewriteRule ^(.*) - [E=BASE:%1]
 162
 163             # Maintenance script
 164             RewriteCond %{DOCUMENT_ROOT}/maintenance.php -f
 165             RewriteCond %{SCRIPT_FILENAME} !maintenance.php
 166             RewriteRule ^.*$ %{ENV:BASE}/maintenance.php [R=503,L]
 167             ErrorDocument 503 /maintenance.php
 168
 169             # Sets the HTTP_AUTHORIZATION header removed by Apache
 170             RewriteCond %{HTTP:Authorization} .
 171             RewriteRule ^ - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
 172
 173             RewriteCond %{ENV:REDIRECT_STATUS} ^$
 174             RewriteRule ^app_dev\.php(?:/(.*)|$) %{ENV:BASE}/$1 [R=301,L]
 175
 176             # If the requested filename exists, simply serve it.
 177             # We only want to let Apache serve files and not directories.
 178             RewriteCond %{REQUEST_FILENAME} -f
 179             RewriteRule ^ - [L]
 180
 181             # Rewrite all other queries to the front controller.
 182             RewriteRule ^ %{ENV:BASE}/app_dev.php [L]
 183           </IfModule>
 184
 185         </Directory>
 186         ''
 187         (adminer.apache.vhostConf null)
 188       ];
 189     };
 190   };
 191 }