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
|
{ env, kanboard, config }:
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."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', '${env.ldap.filter}');
define('LDAP_GROUP_ADMIN_DN', '${env.ldap.admin_dn}');
?>
'';
};
webRoot = kanboard { kanboard_config = config.secrets.fullPaths."webapps/tools-kanboard"; };
apache = rec {
user = "wwwrun";
group = "wwwrun";
modules = [ "proxy_fcgi" ];
root = webRoot;
vhostConf = socket: ''
Alias /kanboard "${root}"
<Directory "${root}">
DirectoryIndex index.php
AllowOverride All
Options FollowSymlinks
Require all granted
<FilesMatch "\.php$">
SetHandler "proxy:unix:${socket}|fcgi://localhost"
</FilesMatch>
</Directory>
<DirectoryMatch "${root}/data">
Require all denied
</DirectoryMatch>
'';
};
phpFpm = rec {
serviceDeps = [ "postgresql.service" "openldap.service" ];
basedir = builtins.concatStringsSep ":" [ webRoot varDir config.secrets.fullPaths."webapps/tools-kanboard" ];
pool = {
"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";
};
};
}
|
