modules/private/websites/tools/tools/kanboard.nix

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