with import ../libs.nix; with nixpkgs_unstable; let connexionswing = { environment ? "dev" }: rec { varDir = "/var/lib/connexionswing_${environment}"; envName= lib.strings.toUpper environment; configRoot = # FIXME: spool emails in prod for when immae.eu is down? assert checkEnv "NIXOPS_CONNEXIONSWING_${envName}_MYSQL_PASSWORD"; assert checkEnv "NIXOPS_CONNEXIONSWING_${envName}_MYSQL_USER"; assert checkEnv "NIXOPS_CONNEXIONSWING_${envName}_MYSQL_NAME"; assert checkEnv "NIXOPS_CONNEXIONSWING_${envName}_SECRET"; assert checkEnv "NIXOPS_CONNEXIONSWING_${envName}_EMAIL"; pkgs.writeText "parameters.yml" '' # This file is auto-generated during the composer install parameters: database_host: db-1.immae.eu database_port: null database_name: ${builtins.getEnv "NIXOPS_CONNEXIONSWING_${envName}_MYSQL_NAME"} database_user: ${builtins.getEnv "NIXOPS_CONNEXIONSWING_${envName}_MYSQL_USER"} database_password: ${builtins.getEnv "NIXOPS_CONNEXIONSWING_${envName}_MYSQL_PASSWORD"} mailer_transport: smtp mailer_host: mail.immae.eu mailer_user: null mailer_password: null subscription_email: ${builtins.getEnv "NIXOPS_CONNEXIONSWING_${envName}_EMAIL"} allow_robots: true secret: ${builtins.getEnv "NIXOPS_CONNEXIONSWING_${envName}_SECRET"} ''; phpFpm = rec { socket = "/var/run/phpfpm/connexionswing-${environment}.sock"; pool = '' listen = ${socket} user = ${apache.user} group = ${apache.group} listen.owner = ${apache.user} listen.group = ${apache.group} php_admin_value[upload_max_filesize] = 20M php_admin_value[post_max_size] = 20M ;php_admin_flag[log_errors] = on php_admin_value[open_basedir] = "${configRoot}:${webappDir}:${varDir}:/tmp" ${if environment == "dev" then '' pm = ondemand pm.max_children = 5 pm.process_idle_timeout = 60 env[SYMFONY_DEBUG_MODE] = "yes" '' else '' pm = dynamic pm.max_children = 20 pm.start_servers = 2 pm.min_spare_servers = 1 pm.max_spare_servers = 3 ''}''; }; apache = { user = "wwwrun"; group = "wwwrun"; modules = [ "proxy_fcgi" ]; vhostConf = '' SetHandler "proxy:unix:${phpFpm.socket}|fcgi://localhost" Options FollowSymLinks AllowOverride None Require all granted Options FollowSymLinks AllowOverride None Require all granted ${if environment == "dev" then '' Use LDAPConnect Require ldap-group cn=connexionswing.immae.eu,cn=httpd,ou=services,dc=immae,dc=eu ErrorDocument 401 "" Options Indexes FollowSymLinks MultiViews Includes AllowOverride None Require all granted DirectoryIndex app_dev.php Options -MultiViews RewriteEngine On RewriteCond %{REQUEST_URI}::$1 ^(/.+)/(.*)::\2$ RewriteRule ^(.*) - [E=BASE:%1] # Maintenance script RewriteCond %{DOCUMENT_ROOT}/maintenance.php -f RewriteCond %{SCRIPT_FILENAME} !maintenance.php RewriteRule ^.*$ %{ENV:BASE}/maintenance.php [R=503,L] ErrorDocument 503 /maintenance.php # Sets the HTTP_AUTHORIZATION header removed by Apache RewriteCond %{HTTP:Authorization} . RewriteRule ^ - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}] RewriteCond %{ENV:REDIRECT_STATUS} ^$ RewriteRule ^app_dev\.php(?:/(.*)|$) %{ENV:BASE}/$1 [R=301,L] # If the requested filename exists, simply serve it. # We only want to let Apache serve files and not directories. RewriteCond %{REQUEST_FILENAME} -f RewriteRule ^ - [L] # Rewrite all other queries to the front controller. RewriteRule ^ %{ENV:BASE}/app_dev.php [L] '' else ""} ''; }; activationScript = { deps = [ "wrappers" ]; text = '' install -m 0755 -o ${apache.user} -g ${apache.group} -d ${varDir} \ ${varDir}/medias \ ${varDir}/uploads \ ${varDir}/var if [ ! -f "${varDir}/currentWebappDir" -o \ "${webappDir}" != "$(cat ${varDir}/currentWebappDir 2>/dev/null)" ]; then pushd ${webappDir} > /dev/null $wrapperDir/sudo -u wwwrun ./bin/console --env=${environment} cache:clear --no-warmup popd > /dev/null echo -n "${webappDir}" > ${varDir}/currentWebappDir fi ''; }; webappDir = pkgs.stdenv.mkDerivation (fetchedGitPrivate ./connexionswing_master.json // rec { # FIXME: can we do better than symlink? # FIXME: imagick optional # FIXME: initial sync # FIXME: backup buildPhase = '' export GIT_SSL_CAINFO=${pkgs.cacert}/etc/ssl/certs/ca-bundle.crt export SSL_CERT_FILE=${pkgs.cacert}/etc/ssl/certs/ca-bundle.crt ln -sf ../../../../../${varDir}/{medias,uploads} web/images/ ln -sf ${configRoot} app/config/parameters.yml ${if environment == "dev" then "php bin/composer install" else '' SYMFONY_ENV=prod php bin/composer install --no-dev ./bin/console assetic:dump --env=prod --no-debug ''} rm -rf var ln -sf ../../../../../${varDir}/var var ''; installPhase = '' cp -a . $out ''; buildInputs = [ pkgs.php pkgs.git pkgs.cacert ]; }); webRoot = "${webappDir}/web"; }; adminer = rec { webRoot = pkgs.stdenv.mkDerivation rec { version = "4.7.0"; name = "adminer-${version}"; src = pkgs.fetchurl { url = "https://www.adminer.org/static/download/${version}/${name}.php"; sha256 = "1qq2g7rbfh2vrqfm3g0bz0qs057b049n0mhabnsbd1sgnpvnc5z7"; }; phases = "installPhase"; installPhase = '' mkdir -p $out cp $src $out/index.php ''; }; phpFpm = rec { socket = "/var/run/phpfpm/adminer.sock"; pool = '' listen = ${socket} user = ${apache.user} group = ${apache.group} listen.owner = ${apache.user} listen.group = ${apache.group} pm = ondemand pm.max_children = 5 pm.process_idle_timeout = 60 ;php_admin_flag[log_errors] = on php_admin_value[open_basedir] = "${webRoot}:/tmp" ''; }; apache = { user = "wwwrun"; group = "wwwrun"; modules = [ "proxy_fcgi" ]; vhostConf = '' Alias /adminer ${webRoot} DirectoryIndex = index.php SetHandler "proxy:unix:${phpFpm.socket}|fcgi://localhost" ''; }; nginxConf = { alias = webRoot; index = "index.php"; extraConfig = '' include ${pkgs.nginx}/conf/fastcgi.conf; fastcgi_split_path_info ^(.+?\.php)(/.*)$; fastcgi_param HTTP_PROXY ""; fastcgi_param SCRIPT_FILENAME ${webRoot}/index.php; fastcgi_pass unix:${phpFpm.socket}; fastcgi_index index.php; fastcgi_intercept_errors on; ''; }; }; ympd = rec { config = { webPort = "localhost:18001"; mpd = { host = "malige.home.immae.eu"; port = 6600; }; }; apache = { vhostConf = '' Use LDAPConnect Require ldap-group cn=users,cn=mpd,ou=services,dc=immae,dc=eu Require local RedirectMatch permanent "^/mpd$" "/mpd/" ProxyPass http://${config.webPort}/ ProxyPassReverse http://${config.webPort}/ ProxyPreserveHost on ProxyPass ws://${config.webPort}/ws ''; }; }; in { inherit adminer; inherit ympd; connexionswing_dev = connexionswing { environment = "dev"; }; connexionswing_prod = connexionswing { environment = "prod"; }; }