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

   1 { env, kanboard, config }:
   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."webapps/tools-kanboard" = {
  17     user = apache.user;
  18     group = apache.group;
  19     permissions = "0400";
  20     text = ''
  21       <?php
  22       define('MAIL_FROM', 'kanboard@tools.immae.eu');
  23
  24       define('DB_DRIVER', 'postgres');
  25       define('DB_USERNAME', '${env.postgresql.user}');
  26       define('DB_PASSWORD', '${env.postgresql.password}');
  27       define('DB_HOSTNAME', '${env.postgresql.socket}');
  28       define('DB_NAME', '${env.postgresql.database}');
  29
  30       define('DATA_DIR', '${varDir}');
  31       define('LDAP_AUTH', true);
  32       define('LDAP_SERVER', '${env.ldap.host}');
  33       define('LDAP_START_TLS', true);
  34
  35       define('LDAP_BIND_TYPE', 'proxy');
  36       define('LDAP_USERNAME', '${env.ldap.dn}');
  37       define('LDAP_PASSWORD', '${env.ldap.password}');
  38       define('LDAP_USER_BASE_DN', '${env.ldap.base}');
  39       define('LDAP_USER_FILTER', '${env.ldap.filter}');
  40       define('LDAP_GROUP_ADMIN_DN', '${env.ldap.admin_dn}');
  41       ?>
  42       '';
  43   };
  44   webRoot = kanboard { kanboard_config = config.secrets.fullPaths."webapps/tools-kanboard"; };
  45   apache = rec {
  46     user = "wwwrun";
  47     group = "wwwrun";
  48     modules = [ "proxy_fcgi" ];
  49     root = webRoot;
  50     vhostConf = socket: ''
  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:${socket}|fcgi://localhost"
  60       </FilesMatch>
  61     </Directory>
  62     <DirectoryMatch "${root}/data">
  63       Require all denied
  64     </DirectoryMatch>
  65       '';
  66   };
  67   phpFpm = rec {
  68     serviceDeps = [ "postgresql.service" "openldap.service" ];
  69     basedir = builtins.concatStringsSep ":" [ webRoot varDir config.secrets.fullPaths."webapps/tools-kanboard" ];
  70     pool = {
  71       "listen.owner" = apache.user;
  72       "listen.group" = apache.group;
  73       "pm" = "ondemand";
  74       "pm.max_children" = "60";
  75       "pm.process_idle_timeout" = "60";
  76
  77       # Needed to avoid clashes in browser cookies (same domain)
  78       "php_value[session.name]" = "KanboardPHPSESSID";
  79       "php_admin_value[open_basedir]" = "${basedir}:/tmp";
  80       "php_admin_value[session.save_path]" = "${varDir}/phpSessions";
  81     };
  82   };
  83 }