+++ /dev/null
-{ lib, pkgs, config, ... }:
-let
- adminer = pkgs.callPackage ../commons/adminer.nix { inherit config; };
- cfg = config.myServices.websites.jerome.naturaloutil;
- varDir = "/var/lib/ftp/jerome";
- env = config.myEnv.websites.jerome;
- apacheUser = config.services.httpd.Prod.user;
- apacheGroup = config.services.httpd.Prod.group;
- secretsPath = config.secrets.fullPaths."websites/jerome/naturaloutil";
-in {
- options.myServices.websites.jerome.naturaloutil.enable = lib.mkEnableOption "enable Jerome Naturaloutil's website";
-
- config = lib.mkIf cfg.enable {
- services.webstats.sites = [ { name = "naturaloutil.immae.eu"; } ];
-
- security.acme.certs."ftp".extraDomains."naturaloutil.immae.eu" = null;
-
- secrets.keys."websites/jerome/naturaloutil" = {
- user = apacheUser;
- group = apacheGroup;
- permissions = "0400";
- text = ''
- <?php
- $mysql_user = '${env.mysql.user}' ;
- $mysql_server = '${env.mysql.host}' ;
- $mysql_base = '${env.mysql.database}' ;
- $mysql_password = '${env.mysql.password}' ;
- //connect to db
- $db = mysqli_init();
- ${if env.mysql.host != "localhost" then ''
- mysqli_options ($db, MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);
- $db->ssl_set(NULL, NULL, "${pkgs.cacert}/etc/ssl/certs/ca-bundle.crt", NULL, NULL);
- '' else ""}
- $database = connect_db($db, $mysql_server, $mysql_base, $mysql_user, $mysql_password);
- ?>
- '';
- };
- system.activationScripts.jerome_naturaloutil = {
- deps = [ "httpd" ];
- text = ''
- install -m 0755 -o ${apacheUser} -g ${apacheGroup} -d /var/lib/php/sessions/jerome_naturaloutil
- '';
- };
- systemd.services.phpfpm-jerome_naturaloutil.after = lib.mkAfter [ "mysql.service" ];
- systemd.services.phpfpm-jerome_naturaloutil.wants = [ "mysql.service" ];
- services.phpfpm.pools.jerome_naturaloutil = {
- user = apacheUser;
- group = apacheGroup;
- settings = {
- "listen.owner" = apacheUser;
- "listen.group" = apacheGroup;
-
- "pm" = "ondemand";
- "pm.max_children" = "5";
- "pm.process_idle_timeout" = "60";
-
- "php_admin_value[open_basedir]" = "/var/lib/php/sessions/jerome_naturaloutil:${secretsPath}:${varDir}:/tmp";
- "php_admin_value[session.save_path]" = "/var/lib/php/sessions/jerome_naturaloutil";
- };
- phpEnv = {
- BDD_CONNECT = secretsPath;
- };
- phpPackage = pkgs.php72;
- };
- services.websites.env.production.modules = adminer.apache.modules ++ [ "proxy_fcgi" ];
- services.websites.env.production.vhostConfs.jerome_naturaloutil = {
- certName = "jerome";
- certMainHost = "naturaloutil.immae.eu";
- hosts = ["naturaloutil.immae.eu" ];
- root = varDir;
- extraConfig = [
- (adminer.apache.vhostConf null)
- ''
- Use Stats naturaloutil.immae.eu
- ServerAdmin ${env.server_admin}
- ErrorLog "${varDir}/logs/error_log"
- CustomLog "${varDir}/logs/access_log" combined
-
- <FilesMatch "\.php$">
- SetHandler "proxy:unix:${config.services.phpfpm.pools.jerome_naturaloutil.socket}|fcgi://localhost"
- </FilesMatch>
-
- <Directory ${varDir}/logs>
- AllowOverride None
- Require all denied
- </Directory>
- <Directory ${varDir}>
- DirectoryIndex index.php index.htm index.html
- Options Indexes FollowSymLinks MultiViews Includes
- AllowOverride None
- Require all granted
- </Directory>
- ''
- ];
- };
- };
-}