1 { lib, pkgs, config, ... }:
3 adminer = pkgs.callPackage ../commons/adminer.nix { inherit config; };
4 cfg = config.myServices.websites.jerome.naturaloutil;
5 varDir = "/var/lib/ftp/jerome";
6 env = config.myEnv.websites.jerome;
7 apacheUser = config.services.httpd.Prod.user;
8 apacheGroup = config.services.httpd.Prod.group;
9 secretsPath = config.secrets.fullPaths."websites/jerome/naturaloutil";
11 options.myServices.websites.jerome.naturaloutil.enable = lib.mkEnableOption "enable Jerome Naturaloutil's website";
13 config = lib.mkIf cfg.enable {
14 services.webstats.sites = [ { name = "naturaloutil.immae.eu"; } ];
16 security.acme.certs."ftp".extraDomains."naturaloutil.immae.eu" = null;
18 secrets.keys."websites/jerome/naturaloutil" = {
24 $mysql_user = '${env.mysql.user}' ;
25 $mysql_server = '${env.mysql.host}' ;
26 $mysql_base = '${env.mysql.database}' ;
27 $mysql_password = '${env.mysql.password}' ;
30 ${if env.mysql.host != "localhost" then ''
31 mysqli_options ($db, MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);
32 $db->ssl_set(NULL, NULL, "${pkgs.cacert}/etc/ssl/certs/ca-bundle.crt", NULL, NULL);
34 $database = connect_db($db, $mysql_server, $mysql_base, $mysql_user, $mysql_password);
38 system.activationScripts.jerome_naturaloutil = {
41 install -m 0755 -o ${apacheUser} -g ${apacheGroup} -d /var/lib/php/sessions/jerome_naturaloutil
44 systemd.services.phpfpm-jerome_naturaloutil.after = lib.mkAfter [ "mysql.service" ];
45 systemd.services.phpfpm-jerome_naturaloutil.wants = [ "mysql.service" ];
46 services.phpfpm.pools.jerome_naturaloutil = {
50 "listen.owner" = apacheUser;
51 "listen.group" = apacheGroup;
54 "pm.max_children" = "5";
55 "pm.process_idle_timeout" = "60";
57 "php_admin_value[open_basedir]" = "/var/lib/php/sessions/jerome_naturaloutil:${secretsPath}:${varDir}:/tmp";
58 "php_admin_value[session.save_path]" = "/var/lib/php/sessions/jerome_naturaloutil";
61 BDD_CONNECT = secretsPath;
63 phpPackage = pkgs.php72;
65 services.websites.env.production.modules = adminer.apache.modules ++ [ "proxy_fcgi" ];
66 services.websites.env.production.vhostConfs.jerome_naturaloutil = {
68 certMainHost = "naturaloutil.immae.eu";
69 hosts = ["naturaloutil.immae.eu" ];
72 (adminer.apache.vhostConf null)
74 Use Stats naturaloutil.immae.eu
75 ServerAdmin ${env.server_admin}
76 ErrorLog "${varDir}/logs/error_log"
77 CustomLog "${varDir}/logs/access_log" combined
80 SetHandler "proxy:unix:${config.services.phpfpm.pools.jerome_naturaloutil.socket}|fcgi://localhost"
83 <Directory ${varDir}/logs>
88 DirectoryIndex index.php index.htm index.html
89 Options Indexes FollowSymLinks MultiViews Includes