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