1 { lib, pkgs, config, ... }:
3 adminer = pkgs.callPackage ../commons/adminer.nix {};
4 cfg = config.myServices.websites.naturaloutil.production;
5 varDir = "/var/lib/ftp/jerome";
6 env = config.myEnv.websites.jerome;
8 options.myServices.websites.naturaloutil.production.enable = lib.mkEnableOption "enable Naturaloutil's website";
10 config = lib.mkIf cfg.enable {
11 services.webstats.sites = [ { name = "naturaloutil.immae.eu"; } ];
13 security.acme2.certs."ftp".extraDomains."naturaloutil.immae.eu" = null;
16 dest = "webapps/prod-naturaloutil";
22 $mysql_user = '${env.mysql.user}' ;
23 $mysql_server = '${env.mysql.host}' ;
24 $mysql_base = '${env.mysql.database}' ;
25 $mysql_password = '${env.mysql.password}' ;
28 ${if env.mysql.host != "localhost" then ''
29 mysqli_options ($db, MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);
30 $db->ssl_set(NULL, NULL, "${pkgs.cacert}/etc/ssl/certs/ca-bundle.crt", NULL, NULL);
32 $database = connect_db($db, $mysql_server, $mysql_base, $mysql_user, $mysql_password);
36 system.activationScripts.naturaloutil = {
39 install -m 0755 -o wwwrun -g wwwrun -d /var/lib/php/sessions/naturaloutil
42 systemd.services.phpfpm-jerome.after = lib.mkAfter [ "mysql.service" ];
43 systemd.services.phpfpm-jerome.wants = [ "mysql.service" ];
44 services.phpfpm.pools.jerome = {
45 listen = "/run/phpfpm/naturaloutil.sock";
54 pm.process_idle_timeout = 60
56 env[BDD_CONNECT] = "/var/secrets/webapps/prod-naturaloutil"
57 php_admin_value[open_basedir] = "/var/lib/php/sessions/naturaloutil:/var/secrets/webapps/prod-naturaloutil:${varDir}:/tmp"
58 php_admin_value[session.save_path] = "/var/lib/php/sessions/naturaloutil"
60 phpOptions = config.services.phpfpm.phpOptions + ''
61 extension=${pkgs.php}/lib/php/extensions/mysqli.so
64 services.websites.env.production.modules = adminer.apache.modules ++ [ "proxy_fcgi" ];
65 services.websites.env.production.vhostConfs.naturaloutil = {
66 certName = "naturaloutil";
67 certMainHost = "naturaloutil.immae.eu";
68 hosts = ["naturaloutil.immae.eu" ];
71 adminer.apache.vhostConf
73 Use Stats naturaloutil.immae.eu
74 ServerAdmin ${env.server_admin}
75 ErrorLog "${varDir}/logs/error_log"
76 CustomLog "${varDir}/logs/access_log" combined
79 SetHandler "proxy:unix:/run/phpfpm/naturaloutil.sock|fcgi://localhost"
82 <Directory ${varDir}/logs>
87 DirectoryIndex index.php index.htm index.html
88 Options Indexes FollowSymLinks MultiViews Includes