X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=vm_hosted;h=df6f6dbd6564cea3df16c9e6fa6ac2d0c727ff0d;hb=30fcfa9a18a93d1447059a759c5c62a4d6d55e06;hp=9a0e5a413cf2868f03ffef8752f19e20f094fd32;hpb=e86042475d1c0ec31f78a44ffea293607cbfb809;p=lhc%2Fateliers.git diff --git a/vm_hosted b/vm_hosted index 9a0e5a4..df6f6db 100755 --- a/vm_hosted +++ b/vm_hosted @@ -511,7 +511,7 @@ rule_gitolite_configure () { --shell /bin/false \ --system sudo adduser git git-data - sudo install -d -m 770 -o git -g git \ + sudo install -d -m 750 -o git -g git \ /etc/gitolite \ /home/git/etc \ /home/git/etc/ssh @@ -546,7 +546,7 @@ rule_gitolite_configure () { \$GL_CONF = "\$GL_ADMINDIR/conf/gitolite.conf"; \$GL_CONF_COMPILED = "\$GL_ADMINDIR/conf/gitolite.conf.pm"; #\$GL_GET_MEMBERSHIPS_PGM = "/usr/local/bin/expand-ldap-user-to-groups" - \$GL_GITCONFIG_KEYS = "hooks\\..* repo\\..*"; + \$GL_GITCONFIG_KEYS = "gitweb\\..* hooks\\..*"; #\$GL_HOSTNAME = "git.$vm_domainname"; # NOTE: read doc/mirroring.mkd COMPLETELY before setting this. #\$GL_HTTP_ANON_USER = "mob"; @@ -717,28 +717,84 @@ rule_mysql_configure () { --disabled-password \ --group \ --home /home/mysql/data \ + --no-create-home \ --shell /bin/false \ --system sudo usermod --home /home/mysql mysql sudo adduser mysql mysql-data - sudo install -m 640 -o mysql -g mysql \ - "$tool"/etc/mysql/my.cnf \ - /etc/mysql/my.cnf sudo install -d -m 751 -o mysql -g mysql \ /home/mysql - sudo install -d -m 750 -o mysql-data -g mysql-data \ - /home/mysql/data - if test ! -d /home/mysql/data + sudo rm -rf /etc/mysql + sudo install -d -m 750 -o mysql -g mysql \ + /etc/mysql \ + /etc/mysql/conf.d \ + /home/mysql/etc + sudo ln -fns \ + /etc/mysql \ + /home/mysql/etc/mysql + sudo install -m 644 -o mysql -g mysql \ + "$tool"/etc/mysql/my.cnf \ + /etc/mysql/my.cnf + if sudo test ! -d /home/mysql/data then + sudo install -d -m 750 -o mysql -g mysql-data \ + /home/mysql/data sudo -u mysql mysql_install_db \ - --no-defaults \ - --datadir=/home/mysql/data + --datadir=/home/mysql/data \ + --no-defaults fi sudo service tmpfs restart + sudo insserv -r mysql + sudo chmod ugo-x /etc/init.d/mysql case $(sudo sv status mysql || true) in - (run:*) sudo sv restart mysql + (''|run:*|*"s, normally up;"*) + rule runit_sv_restart mysql + while case $(sudo inotifywait -e create -- /run/mysqld/sock/) in + ("/run/mysqld/sock/ CREATE mysql") false;; + (*) true;; + esac + do true; done + ( + cd / + # NOTE: + # - ajoute l'accès par socket Unix à mysql + # - ajoute les droits de super-utilisateur à mysql + # - supprime l'accès par mot-de-passe à root + # - supprime les bases de données de l'utilisateurice anonyme + # - supprime l'utilisateurice anonyme + # NOTE: mémo : + # GRANT USAGE ON *.* TO 'root'@'*' IDENTIFIED WITH auth_socket; + # CREATE USER 'root'@'localhost' IDENTIFIED WITH auth_socket; + # UPDATE mysql.user SET Password='' WHERE user='root'; + # DELETE FROM mysql.user WHERE user = 'root' AND host NOT IN ('localhost', '127.0.0.1', '::1'); + sudo mysql -u root --batch --verbose <<-EOF + DELETE FROM mysql.user WHERE user = 'root' and plugin = ''; + GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'localhost' IDENTIFIED WITH auth_socket; + UPDATE mysql.user SET grant_priv='Y',super_priv='Y' WHERE user='mysql'; + DELETE FROM mysql.db WHERE user = ''; + DELETE FROM mysql.user WHERE user = ''; + FLUSH PRIVILEGES; + EOF + ) + ;; esac } +rule_mysql_db_add () { # SYNTAX: $user $db + sudo -u mysql mysql --batch <<-EOF + DROP DATABASE IF EXISTS $db; + CREATE DATABASE $db CHARACTER SET utf8 COLLATE utf8_general_ci; + GRANT ALL PRIVILEGES ON $base.* TO '$user'@'localhost' IDENTIFIED WITH auth_socket; + FLUSH PRIVILEGES; + EOF + } +rule_mysql_user_add () { # SYNTAX: $user + sudo mysql -u mysql --batch <<-EOF || true + DROP USER '$user'@'localhost'; + EOF + sudo mysql -u mysql --batch <<-EOF + CREATE USER '$user'@'localhost' IDENTIFIED WITH auth_socket; + EOF + } rule_network_configure () { sudo install -m 644 -o root -g root /dev/stdin /etc/hostname <<-EOF $vm @@ -748,6 +804,10 @@ rule_network_configure () { $(cat /etc/hosts) 127.0.0.1 $vm_fqdn $vm EOF + sudo install -m 644 -o root -g root /dev/stdin /etc/resolv.conf <<-EOF + search ${vm_host#*.} + nameserver ${vm_host_nameserver} + EOF sudo install -m 644 -o root -g root /dev/stdin /etc/network/interfaces <<-EOF auto lo iface lo inet loopback @@ -780,34 +840,6 @@ rule_network_configure () { pre-down ip address delete $vm_ipv4/32 dev \$IFACE EOF } -rule_www_configure () { - rule adduser www \ - --disabled-login \ - --disabled-password \ - --group \ - --home /home/www \ - --shell /bin/false \ - --system - rule adduser log-www \ - --disabled-login \ - --disabled-password \ - --group \ - --home /home/www/log \ - --shell /bin/false \ - --system - #sudo adduser www www-data - sudo adduser www log-www - #sudo adduser log log-www - usermod --home /home/www/pub www-data - sudo install -d -m 751 -o www -g www \ - /home/www - sudo install -d -m 750 -o www -g www \ - /home/www/etc - sudo install -d -m 1771 -o www-data -g www-data \ - /home/www/pub - sudo install -d -m 1771 -o log-www -g log-www \ - /home/www/log - } rule_nginx_configure () { local -; set +f rule apt_get_install nginx @@ -881,7 +913,9 @@ rule_nginx_configure () { done rule apt_get_install spawn-fcgi fcgiwrap sudo insserv --remove fcgiwrap + sudo chmod ugo-x /etc/init.d/fcgiwrap #sudo insserv --remove nginx + #sudo chmod ugo-x /etc/init.d/nginx rule tmpfs_configure sudo service php5-fpm restart # NOTE: relance les processus du pool @@ -889,6 +923,49 @@ rule_nginx_configure () { # de leurs groupes supplémentaires. sudo service nginx restart } +rule_nsd3_configure () { # NOTE: DNS autoritaire uniquement + local -; set +f + rule apt_get_install nsd m4 + sudo rm -rf \ + /etc/nsd3/zone.d + sudo install -d -m 750 -o root -g nsd \ + /etc/nsd3/zone.d + { + cat <<-EOF + server: + ip-address: $vm_ipv4 + ip4-only: yes + EOF + cat "$tool"/etc/nsd3/nsd.conf + local conf + for conf in "$tool"/etc/nsd3/zone.d/*.conf + do conf=${conf#"$tool"/etc/nsd3/zone.d/} + local domain=${conf%.conf} + if test -e "$tool"/etc/nsd3/zone.d/"$domain".zone.m4 + then m4 \ + --define=ZONE_DOMAIN=$domain \ + --define=ZONE_SERIAL=$(cd "$tool" && git log -1 --format="%ct" -- etc/nsd3/zone.d/"$domain".zone.m4) \ + --define=VM_IP4=$vm_ipv4 \ + "$tool"/etc/nsd3/zone.d/"$domain".zone.m4 + else cat "$tool"/etc/nsd3/zone.d/"$domain".zone + fi | + sudo install -m 440 -o root -g nsd /dev/stdin \ + /etc/nsd3/zone.d/"$domain".zone + sudo install -m 440 -o root -g nsd \ + "$tool"/etc/nsd3/zone.d/"$conf" \ + /etc/nsd3/zone.d/"$conf" + cat <<-EOF + zone: + name: $domain + zonefile: /etc/nsd3/zone.d/$domain.zone + EOF + done + } | + sudo install -m 640 -o root -g nsd /dev/stdin \ + /etc/nsd3/nsd.conf + sudo nsdc rebuild + sudo service nsd3 restart + } rule_php5_fpm_configure () { local -; set +f rule apt_get_install \ @@ -990,8 +1067,8 @@ rule_php5_fpm_configure () { sudo install -m 664 -o php5 -g php5 \ "$tool"/etc/php5/fpm/php.ini \ /etc/php5/fpm/php.ini - case $(sudo sv status php5-"$pool") in - (run:*) sudo sv restart php5-"$pool" + case $(sudo sv status php5-"$pool" || true) in + (''|run:*) rule runit_sv_restart php5-"$pool" esac done rule tmpfs_configure @@ -1088,21 +1165,211 @@ rule_postfix_configure () { sudo service postfix restart } rule_postgresql_configure () { + # DOC: http://wiki.postgresql.org/wiki/Shared_Database_Hosting rule apt_get_install postgresql-9.1 - if [ ! -d /var/lib/postgresql/9.1/ ]; then - pg_createcluster -u postgres --start 9.1 main - fi - sudo install -m 660 -o root -g root \ - "$tool"/etc/postgresql/9.1/main/postgresql.conf \ - /etc/postgresql/9.1/main/postgresql.conf - sudo service postgresql restart + rule adduser postgres \ + --disabled-login \ + --disabled-password \ + --group \ + --home /home/postgresql \ + --shell /bin/false \ + --system + rule adduser postgres-data \ + --disabled-login \ + --disabled-password \ + --group \ + --home /home/postgresql/data \ + --no-create-home \ + --shell /bin/false \ + --system + sudo usermod --home /home/postgresql postgres + sudo adduser postgres postgres-data + sudo rm -rf \ + /etc/postgresql + sudo install -d -m 1751 -o postgres -g postgres-data \ + /home/postgresql \ + /home/postgresql/etc \ + /etc/postgresql \ + /etc/postgresql/9.1 \ + /etc/postgresql/9.1/main + sudo ln -fns \ + /etc/postgresql \ + /home/postgresql/etc/postgresql + sudo install -d -m 2770 -o postgres -g log-postgres \ + /home/postgresql/log \ + /home/postgresql/log/9.1 \ + /home/postgresql/log/9.1/main + sudo service tmpfs restart + if sudo test ! -d /home/postgresql/data + then + sudo install -d -m 750 -o postgres -g postgres \ + /home/postgresql/data + ( + cd / + sudo -u postgres pg_createcluster \ + --datadir=/home/postgresql/data \ + --logfile=/home/postgresql/log/9.1/main/cluster.log \ + --socketdir=/run/postgresql \ + 9.1 main + ) + fi + sudo install -m 770 -o postgres -g postgres /dev/stdin \ + /etc/postgresql/9.1/main/pg_hba.conf <<-EOF + local all postgres peer + local all all peer + EOF + sudo install -m 640 -o postgres -g postgres-data \ + "$tool"/etc/postgresql/9.1/main/postgresql.conf \ + /etc/postgresql/9.1/main/postgresql.conf + sudo insserv -r postgresql + sudo chmod ugo-x /etc/init.d/postgresql + case $(sudo sv status postgres || true) in + (''|run:*|*"s, normally up;"*) + rule runit_sv_restart postgres + while case $(sudo inotifywait -e create -- /run/postgresql/) in + ("/run/postgresql/ CREATE .s.PGSQL.5432") false;; + (*) true;; + esac + do true; done + ( + cd / + # NOTE: supprime l'accès au schéma public depuis public, + # de sorte à ce que les différents utilisateurices + # ne voient pas leurs bases de données entre-elleux ; + sudo -u postgres psql template1 -a -f - <<-EOF + \set ON_ERROR_STOP on + REVOKE ALL ON DATABASE template1 FROM public; + REVOKE ALL ON SCHEMA public FROM public; + GRANT ALL ON SCHEMA public TO postgres; + EOF + # NOTE: ajoute le support de PL/PGSQL s'il ne l'est pas déjà. + sudo -u postgres psql template1 -a -f - <<-EOF + \set ON_ERROR_STOP on + CREATE OR REPLACE FUNCTION create_language_plpgsql() + RETURNS BOOLEAN AS \$\$ + CREATE LANGUAGE plpgsql; + SELECT TRUE; + \$\$ LANGUAGE SQL; + SELECT CASE WHEN NOT ( + SELECT TRUE AS exists + FROM pg_language + WHERE lanname = 'plpgsql' + UNION + SELECT FALSE AS exists + ORDER BY exists DESC + LIMIT 1 + ) + THEN + create_language_plpgsql() + ELSE + FALSE + END AS plpgsql_created; + DROP FUNCTION create_language_plpgsql(); + EOF + # NOTE: supprime l'accès à la liste des bases données + # et utilisateurices depuis public. + sudo -u postgres psql template1 -a -f - <<-EOF + \set ON_ERROR_STOP on + REVOKE ALL ON pg_auth_members FROM public; + REVOKE ALL ON pg_authid FROM public; + REVOKE ALL ON pg_database FROM public; + REVOKE ALL ON pg_group FROM public; + REVOKE ALL ON pg_roles FROM public; + REVOKE ALL ON pg_settings FROM public; + REVOKE ALL ON pg_tablespace FROM public; + REVOKE ALL ON pg_user FROM public; + EOF + ) + ;; + esac + } +rule_postgresql_db_add () { # SYNTAX: $db $db_user + local db="$1" db_user="$2" + sudo -u postgres psql template1 -a -f - <<-EOF + \set ON_ERROR_STOP on + DO LANGUAGE plpgsql \$\$ + BEGIN + IF NOT EXISTS ( + SELECT * + FROM pg_catalog.pg_roles + WHERE rolname = '${db}_role' + LIMIT 1 + ) THEN + CREATE ROLE ${db}_role + NOCREATEDB + NOCREATEROLE + NOINHERIT + NOLOGIN + NOSUPERUSER; + END IF; + IF NOT EXISTS ( + SELECT * + FROM pg_catalog.pg_user + WHERE usename = '$db_user' + LIMIT 1 + ) THEN + CREATE ROLE $db_user + LOGIN + NOCREATEDB + NOCREATEROLE + NOINHERIT + NOSUPERUSER; + END IF; + END; + \$\$; + EOF + case $(sudo -u postgres psql template1 -t -c \ + "SELECT datname FROM pg_catalog.pg_database WHERE datname = '$db' LIMIT 1") in + (" $db") true;; + (*) + sudo -u postgres psql template1 -a -f - <<-EOF + \set ON_ERROR_STOP on + CREATE DATABASE $db WITH OWNER=$db_user; + EOF + ;; + esac + sudo -u postgres psql template1 -a -f - <<-EOF + \set ON_ERROR_STOP on + GRANT ${db}_role TO $db_user; + REVOKE ALL ON DATABASE $db FROM public; + EOF + } +rule_postgresql_db_user_add () { # SYNTAX: $db $user + local db="$1" user="$2" + sudo -u postgres psql template1 -a -f - <<-EOF + \set ON_ERROR_STOP on + DO LANGUAGE plpgsql \$\$ + BEGIN + IF NOT EXISTS ( + SELECT * + FROM pg_catalog.pg_user + WHERE usename = '$user' + LIMIT 1 + ) THEN + CREATE ROLE $user + LOGIN + NOCREATEDB + NOCREATEROLE + NOINHERIT + NOSUPERUSER; + END IF; + END; + \$\$; + GRANT USAGE ON SCHEMA public TO $user; + GRANT CONNECT,TEMPORARY ON DATABASE $db TO $user; + GRANT $db TO $user; + EOF } rule_openerp_configure () { sudo install -m 660 -o root -g root /dev/stdin /etc/apt/sources.list.d/openerp.list <<-EOF - deb http://nightly.openerp.com/trunk/nightly/deb/ ./ + deb http://nightly.openerp.com/7.0/nightly/deb/ ./ EOF + sudo install -d -m 1777 -o root -g root \ + /etc/openerp sudo apt-get update - rule apt_get_install openerp + rule apt_get_install openerp --force-yes + # XXX: --force-yes car les paquets de nightly.openerp.com + # ne sont pas signés par OpenPGP.. } rule_postgrey_configure () { rule apt_get_install postgrey @@ -1119,43 +1386,64 @@ rule_procmail_configure () { "$tool"/etc/skel/etc/mail/delivery.procmailrc \ /etc/skel/etc/mail/delivery.procmailrc } -rule_runit_configure () { +rule_runit_configure () { # SYNTAX: $service rule apt_get_install runit local -; set +f for sv in ${1-/etc/service/*} # NOTE: stoppe les services en retenant leur status de départ - do sv=$(basename "$sv") + do sv=${sv##*/} local sv_hash=$(printf %s "$sv" | sha1sum | cut -f 1 -d ' ') local sv_status IFS= read -r sv_status_$sv_hash <<-EOF - $(sudo sv status "$sv") + $(sudo sv status "$sv" || true) EOF sudo rm -f /etc/service/"$sv" done - for sv in ${1-"$tool"/etc/sv/*} + set -$- ${1-"$tool"/etc/sv/*} + while test -n "$*" # NOTE: configure et (re-)démarre les services - do sv=$(basename "$sv") - local sv_hash=$(printf %s "$sv" | sha1sum | cut -f 1 -d ' ') - sudo install -d -m 770 -o root -g root \ - /etc/sv/"$sv" - sudo install -m 770 -o root -g root \ - "$tool"/etc/sv/"$sv"/run \ - /etc/sv/"$sv"/run - if test -e "$tool"/etc/sv/"$sv"/log/run - then + do local first=yes + for sv in "$@" + do sv=${sv##*/} + case $first in + (yes) shift $#; first=;; + esac + local sv_hash=$(printf %s "$sv" | sha1sum | cut -f 1 -d ' ') sudo install -d -m 770 -o root -g root \ - /etc/sv/"$sv"/log + /etc/sv/"$sv" sudo install -m 770 -o root -g root \ - "$tool"/etc/sv/"$sv"/log/run \ - /etc/sv/"$sv"/log/run - fi - test ! -r "$tool"/etc/sv/"$sv"/configure.sh || - . "$tool"/etc/sv/"$sv"/configure.sh - sudo ln -fns ../sv/"$sv" /etc/service/"$sv" - eval local sv_status=\"\${sv_status_$sv_hash-}\" - case $sv_status in - ("") true;; - (run:*) sudo sv restart "$sv";; + "$tool"/etc/sv/"$sv"/run \ + /etc/sv/"$sv"/run + if test -e "$tool"/etc/sv/"$sv"/log/run + then + sudo install -d -m 770 -o root -g root \ + /etc/sv/"$sv"/log + sudo install -m 770 -o root -g root \ + "$tool"/etc/sv/"$sv"/log/run \ + /etc/sv/"$sv"/log/run + fi + local continue= + test ! -r "$tool"/etc/sv/"$sv"/configure.sh || + . "$tool"/etc/sv/"$sv"/configure.sh + case $continue in + (yes) continue;; + esac + sudo ln -fns ../sv/"$sv" /etc/service/"$sv" + eval local sv_status=\"\${sv_status_$sv_hash-}\" + case $sv_status in + ("") true;; + (fail:*) sleep 1 && sudo sv start "$sv";; + (run:*) rule runit_sv_restart "$sv";; + esac + done + done + } +rule_runit_sv_restart () { # SYNTAX: $sv + local sv="$1" + while true + do case $(sudo sv restart "$sv") in + ("fail: $sv: runsv not running") sleep 1;; + (*) break;; esac done } @@ -1269,14 +1557,30 @@ rule_time_configure () { rule dpkg_reconfigure tzdata rule apt_get_install ntp } +rule_unbound_configure () { + sudo apt-get install unbound m4 + sudo install -m 644 -o root -g root /dev/stdin /etc/resolv.conf <<-EOF + search ${vm_host#*.} + nameserver 127.0.0.1 + #nameserver ${vm_host_nameserver} + EOF + sudo install -m 440 -o unbound -g unbound \ + "$tool"/etc/unbound/named.cache \ + /etc/unbound/named.cache + m4 \ + --define=OUTGOING_INTERFACE=$vm_ipv4 \ + <"$tool"/etc/unbound/unbound.conf | + sudo install -m 440 -o unbound -g unbound /dev/stdin \ + /etc/unbound/unbound.conf + sudo service unbound restart + } rule_user_add () { # SYNTAX: $user - rule user_configure - local user=$1 - rule adduser "$user" --disabled-password + local user="$1"; shift + rule adduser "$user" --disabled-password "$@" # NOTE: le mot-de-passe doit être initialisé par l'utilisateur à l'aide de passwd-init . eval local home\; home="~$user" sudo adduser "$user" users - sudo install -m 640 -o root -g root \ + sudo install -m 640 -o "$user" -g "$user" \ "$tool"/var/pub/ssh/"$user".key \ "$home"/etc/ssh/authorized_keys local key; local -; set +f @@ -1304,7 +1608,9 @@ rule_user_configure () { LAST_UID=29999 LETTERHOMES=no NAME_REGEX="^[a-z][-a-z0-9_]*\$" - QUOTAUSER="" # TODO: init + QUOTAUSER="" + # TODO: configure a template user (with edquota or setquota) + # and indicate their user name in the QUOTAUSER variable. SETGID_HOME=no SKEL=/etc/skel SKEL_IGNORE_REGEX="dpkg-(old|new|dist|save)" @@ -1353,6 +1659,12 @@ rule_user_configure () { sudo install -m 644 -o root -g root \ "$tool"/etc/screenrc \ /etc/screenrc + local sh; local -; set +f + for sh in "$tool"/etc/user.d/*/configure.sh + do sh=${sh#"$tool"/etc/user.d/} + local user="${sh%/configure.sh}" + . "$tool"/etc/user.d/"$sh" + done } rule_user_admin_add () { # SYNTAX: $user rule user_configure @@ -1395,6 +1707,34 @@ rule_user_root_configure () { do sudo gpg --import "$key" done } +rule_www_configure () { + rule adduser www \ + --disabled-login \ + --disabled-password \ + --group \ + --home /home/www \ + --shell /bin/false \ + --system + rule adduser log-www \ + --disabled-login \ + --disabled-password \ + --group \ + --home /home/www/log \ + --shell /bin/false \ + --system + #sudo adduser www www-data + sudo adduser www log-www + #sudo adduser log log-www + usermod --home /home/www/pub www-data + sudo install -d -m 751 -o www -g www \ + /home/www + sudo install -d -m 750 -o www -g www \ + /home/www/etc + sudo install -d -m 1771 -o www-data -g www-data \ + /home/www/pub + sudo install -d -m 1771 -o log-www -g log-www \ + /home/www/log + } rule_configure () { rule apt_configure rule git_configure @@ -1415,6 +1755,7 @@ rule_configure () { rule php5_fpm_configure rule nginx_configure #rule apache2_configure + rule nsd3_configure rule runit_configure }