nixops/modules/websites/tools/tools/kanboard.nix

   1 { lib, env, fetchedGithub, writeText, stdenv, fetchurl }:
   2 rec {
   3   varDir = "/var/lib/kanboard";
   4   activationScript = {
   5     deps = [ "wrappers" ];
   6     text = ''
   7       install -m 0755 -o ${apache.user} -g ${apache.group} -d ${varDir}/data
   8       install -m 0750 -o ${apache.user} -g ${apache.group} -d ${varDir}/phpSessions
   9       install -TDm644 ${webRoot}/dataold/.htaccess ${varDir}/data/.htaccess
  10       install -TDm644 ${webRoot}/dataold/web.config ${varDir}/data/web.config
  11     '';
  12   };
  13   config = writeText "config.php" ''
  14     <?php
  15     define('MAIL_FROM', 'kanboard@immae.eu');
  16
  17     define('DB_DRIVER', 'postgres');
  18     define('DB_USERNAME', '${env.postgresql.user}');
  19     define('DB_PASSWORD', '${env.postgresql.password}');
  20     define('DB_HOSTNAME', '${env.postgresql.socket}');
  21     define('DB_NAME', '${env.postgresql.database}');
  22
  23     define('LDAP_AUTH', true);
  24     define('LDAP_SERVER', '${env.ldap.host}');
  25     define('LDAP_START_TLS', true);
  26
  27     define('LDAP_BIND_TYPE', 'proxy');
  28     define('LDAP_USERNAME', '${env.ldap.dn}');
  29     define('LDAP_PASSWORD', '${env.ldap.password}');
  30     define('LDAP_USER_BASE_DN', '${env.ldap.base}');
  31     define('LDAP_USER_FILTER', '(&(memberOf=cn=users,cn=kanboard,ou=services,dc=immae,dc=eu)(uid=%s))');
  32     define('LDAP_GROUP_ADMIN_DN', 'cn=admins,cn=kanboard,ou=services,dc=immae,dc=eu');
  33     ?>
  34     '';
  35   webRoot = stdenv.mkDerivation (fetchedGithub ./kanboard.json // rec {
  36     dontBuild = true;
  37     installPhase = ''
  38       cp -a . $out
  39       ln -s ${config} $out/config.php
  40       mv $out/data $out/dataold
  41       ln -s ${varDir}/data $out/data
  42       '';
  43   });
  44   apache = rec {
  45     user = "wwwrun";
  46     group = "wwwrun";
  47     modules = [ "proxy_fcgi" ];
  48     webappName = "tools_kanboard";
  49     root = "/run/current-system/webapps/${webappName}";
  50     vhostConf = ''
  51     Alias /kanboard "${root}"
  52     <Directory "${root}">
  53       DirectoryIndex index.php
  54       AllowOverride All
  55       Options FollowSymlinks
  56       Require all granted
  57
  58       <FilesMatch "\.php$">
  59         SetHandler "proxy:unix:${phpFpm.socket}|fcgi://localhost"
  60       </FilesMatch>
  61     </Directory>
  62     <DirectoryMatch "${root}/data">
  63       Require all denied
  64     </DirectoryMatch>
  65       '';
  66   };
  67   phpFpm = rec {
  68     basedir = builtins.concatStringsSep ":" [ webRoot varDir config ];
  69     socket = "/var/run/phpfpm/kanboard.sock";
  70     pool = ''
  71       listen = ${socket}
  72       user = ${apache.user}
  73       group = ${apache.group}
  74       listen.owner = ${apache.user}
  75       listen.group = ${apache.group}
  76       pm = ondemand
  77       pm.max_children = 60
  78       pm.process_idle_timeout = 60
  79
  80       ; Needed to avoid clashes in browser cookies (same domain)
  81       php_value[session.name] = KanboardPHPSESSID
  82       php_admin_value[open_basedir] = "${basedir}:/tmp"
  83       php_admin_value[session.save_path] = "${varDir}/phpSessions"
  84       '';
  85   };
  86 }