added a friendly postinstall script to shorten install time

scorpion · Mar 24, 2013 · d77b6da · d77b6da
1 parent 4fefb6c
commit d77b6da
Show file tree

Hide file tree

Showing 7 changed files with 452 additions and 8 deletions.
diff --git a/Makefile.in b/Makefile.in
@@ -109,3 +109,8 @@ distclean-am: clean-am
 key:
 	dd if=/dev/urandom bs=56 count=1 of=piler.key
 
+postinstall:
+	@sh util/postinstall.sh $(RUNNING_USER) $(RUNNING_GROUP) $(sysconfdir) $(localstatedir)
+
+
+
diff --git a/etc/sphinx.conf → etc/sphinx.conf.in b/etc/sphinx.conf → etc/sphinx.conf.in
@@ -5,10 +5,10 @@
 source base
 {
    type = mysql
-   sql_host = localhost
-   sql_db = piler
-   sql_user = piler
-   sql_pass = piler
+   sql_host = MYSQL_HOSTNAME
+   sql_db = MYSQL_DATABASE
+   sql_user = MYSQL_USERNAME
+   sql_pass = MYSQL_PASSWORD
 }
 
 source main : base

diff --git a/src/config.h b/src/config.h
@@ -13,7 +13,7 @@
 
 #define VERSION "0.1.23-master-branch"
 
-#define BUILD 782
+#define BUILD 783
 
 #define HOSTID "mailarchiver"
 

diff --git a/util/db-mysql-root.sql.in b/util/db-mysql-root.sql.in
@@ -0,0 +1,5 @@
+create database MYSQL_DATABASE character set 'utf8';
+grant all privileges on MYSQL_DATABASE.* to MYSQL_USERNAME@localhost identified by 'MYSQL_PASSWORD';
+flush privileges;
+
+
diff --git a/util/db-mysql.sql b/util/db-mysql.sql
@@ -1,6 +1,3 @@
-create database if not exists `piler` character set 'utf8';
-use `piler`;
-
 
 drop table if exists `sph_counter`;
 create table if not exists `sph_counter` (

diff --git a/util/postinstall.sh b/util/postinstall.sh
@@ -0,0 +1,283 @@
+#!/bin/sh
+
+
+INDEXER=`which indexer 2>/dev/null`
+SEARCHD=`which searchd 2>/dev/null`
+CRON_ORIG="/tmp/crontab.piler.orig"
+CRON_TMP="/tmp/crontab.piler"
+
+
+. ./util/utilfunc.sh
+
+
+preinstall_check() {
+   check_user root
+
+   if [ "x$INDEXER" = "x" ]; then "ERROR: cannot find sphinx indexer"; echo ""; exit ; fi
+
+   if [ "x$SEARCHD" = "x" ]; then "ERROR: cannot find sphinx searchd"; echo ""; exit 0; fi
+
+   if [ -f $KEYFILE ]; then echo "ERROR: found existing keyfile ($KEYFILE), aborting install"; echo ""; exit 0; fi
+}
+
+
+gather_webserver_data() {
+   askNonBlank "Please enter the path of your documentroot" "$DOCROOT"
+   DOCROOT=$response
+
+   if [ -d $DOCROOT ]; then echo "ERROR: vhost docroot should NOT exist, abroting install"; echo ""; exit 0; fi
+
+   askNonBlank "Please enter the webserver groupname" "$WWWGROUP"
+   WWWGROUP=$response
+}
+
+
+gather_mysql_account() {
+
+   askNonBlank "Please enter mysql hostname" "$MYSQL_HOSTNAME"
+   MYSQL_HOSTNAME=$response
+
+   askNonBlank "Please enter mysql database" "$MYSQL_DATABASE"
+   MYSQL_DATABASE=$response
+
+   askNonBlank "Please enter mysql user name" "$MYSQL_USERNAME"
+   MYSQL_USERNAME=$response
+
+   askNonBlankNoEcho "Please enter mysql password for $MYSQL_USERNAME" ""
+   MYSQL_PASSWORD=$response
+
+   askNonBlankNoEcho "Please enter mysql root password" ""
+   MYSQL_ROOT_PASSWORD=$response
+
+   s=`echo "use information_schema; select TABLE_NAME from TABLES where TABLE_SCHEMA='$MYSQL_DATABASE'" | mysql -h $MYSQL_HOSTNAME -u root --password=$MYSQL_ROOT_PASSWORD`
+   if [ $? -eq 0 ];
+   then
+      echo "mysql connection successful"; echo;
+      if [ `echo $s | grep -c metadata` -eq 1 ]; then echo "ERROR: Detected metadata table in $MYSQL_DATABASE. Aborting"; exit 0; fi
+   else
+      echo "ERROR: failed to connect to mysql";
+      gather_mysql_account
+   fi
+
+}
+
+
+gather_sphinx_data() {
+
+   if [ $INDEXER = "/usr/bin/indexer" ]; then SPHINXCFG="/etc/sphinx.conf"; fi
+
+   askNonBlank "Please enter the path of sphinx.conf" "$SPHINXCFG"
+   SPHINXCFG=$response
+}
+
+
+gather_smtp_relay_data() {
+   ask "Please enter smtp relay" "$SMARTHOST"
+   SMARTHOST=$response
+
+   askNonBlankNoEcho "Please enter smtp relay port" "$SMARTHOST_PORT"
+   SMARTHOST_PORT=$response
+}
+
+
+make_cron_entries() {
+
+   crontab -u $PILERUSER -l > $CRON_ORIG
+
+   grep PILERSTART $CRON_ORIG > /dev/null 2>&1
+   if [ $? != 0 ]; then
+      cat /dev/null > $CRON_ORIG
+   fi
+
+   grep PILEREND $CRON_ORIG > /dev/null 2>&1
+   if [ $? != 0 ]; then
+      cat /dev/null > $CRON_ORIG
+   fi
+
+
+   rm -f $CRON_TMP
+
+   echo ""
+   echo "### PILERSTART" >> $CRON_TMP
+   echo "*/5 * * * * LC_ALL=C mpstat | tail -1 | awk '{print $11}' > $LOCALSTATEDIR/piler/stat/cpu.stat" >> $CRON_TMP
+   echo "5,35 * * * * $INDEXER --quiet delta1 --rotate && sleep 2 && $INDEXER --quiet --merge main1 delta1 --merge-dst-range deleted 0 0 --rotate" >> $CRON_TMP
+   echo "*/15 * * * * $INDEXER --quiet tag1 --rotate" >> $CRON_TMP
+   echo "*/15 * * * * $INDEXER --quiet note1 --rotate" >> $CRON_TMP
+   echo "### PILEREND" >> $CRON_TMP
+}
+
+
+make_new_key() {
+   dd if=/dev/urandom bs=56 count=1 of=$KEYTMPFILE 2>/dev/null
+
+   if [ `stat -c '%s' $KEYTMPFILE` -ne 56 ]; then echo "could not read 56 bytes from /dev/urandom to $KEYTMPFILE"; exit 1; fi
+}
+
+
+show_summary() {
+   echo
+   echo
+   echo "INSTALLATION SUMMARY:"
+   echo
+
+   echo "piler user: $PILERUSER"
+   echo "keyfile: $KEYFILE"
+   echo
+
+   echo "mysql host: $MYSQL_HOSTNAME"
+   echo "mysql database: $MYSQL_DATABASE"
+   echo "mysql username: $MYSQL_USERNAME"
+   echo "mysql password: *******"
+   echo
+
+   echo "sphinx indexer: $INDEXER"
+   echo "sphinx config file: $SPHINXCFG"
+   echo
+
+   echo "vhost docroot: $DOCROOT"
+   echo "www group: $WWWGROUP"
+   echo
+
+   echo "smtp relay host: $SMARTHOST"
+   echo "smtp relay port: $SMARTHOST_PORT"
+   echo
+
+   echo "piler crontab:"
+   cat $CRON_TMP
+   echo; echo;
+
+   askYN "Correct? [Y/N]" "N"
+   if [ $response != "yes" ]; then
+      echo "Aborted."
+      exit
+   fi
+
+}
+
+
+execute_post_install_tasks() {
+
+   askYN "Continue and modify system? [Y/N]" "N"
+   if [ $response != "yes" ]; then
+      echo "Aborted."
+      exit
+   fi
+
+   echo;
+   echo -n "Creating mysql database... ";
+   sed -e "s%MYSQL_HOSTNAME%$MYSQL_HOSTNAMEg%" -e "s%MYSQL_DATABASE%$MYSQL_DATABASE%g" -e "s%MYSQL_USERNAME%$MYSQL_USERNAME%g" -e "s%MYSQL_PASSWORD%$MYSQL_PASSWORD%g" util/db-mysql-root.sql.in | mysql -h $MYSQL_HOSTNAME -u root --password=$MYSQL_ROOT_PASSWORD
+   mysql -h $MYSQL_HOSTNAME -u $MYSQL_USERNAME --password=$MYSQL_PASSWORD $MYSQL_DATABASE < util/db-mysql.sql
+   echo "Done."
+
+   echo -n "Overwriting sphinx configuration... ";
+   sed -e "s%MYSQL_HOSTNAME%$MYSQL_HOSTNAME%" -e "s%MYSQL_DATABASE%$MYSQL_DATABASE%" -e "s%MYSQL_USERNAME%$MYSQL_USERNAME%" -e "s%MYSQL_PASSWORD%$MYSQL_PASSWORD%" etc/sphinx.conf.in > etc/sphinx.conf
+   cp etc/sphinx.conf $SPHINXCFG
+   echo "Done."
+
+   echo -n "Initializing sphinx indices... ";
+   su $PILERUSER -c "indexer --all"
+   echo "Done."
+
+
+   echo -n "installing cron entries for $PILERUSER... "
+   crontab -u $PILERUSER $CRON_TMP
+   echo "Done."
+
+
+   echo -n "installing keyfile ($KEYTMPFILE) to $KEYFILE... "
+   cp $KEYTMPFILE $KEYFILE
+   chgrp $PILERUSER $KEYFILE
+   chmod 640 $KEYFILE
+   rm -f $KEYTMPFILE
+   echo "Done."
+
+   echo -n "Copying www files to $DOCROOT... "
+   mkdir -p $DOCROOT || exit 1
+
+   cp -R webui/* $DOCROOT
+   cp -R webui/.htaccess $DOCROOT
+   chmod 770 $DOCROOT/tmp
+   chgrp $WWWGROUP $DOCROOT/tmp
+
+   echo "<?php" > $DOCROOT/config-site.php
+   echo >> $DOCROOT/config-site.php
+
+   echo "\$config['SITE_NAME'] = '$HOSTNAME';" >> $DOCROOT/config-site.php
+   echo "\$config['SITE_URL'] = 'http://$HOSTNAME/';" >> $DOCROOT/config-site.php
+   echo "\$config['DIR_BASE'] = '$DOCROOT/';" >> $DOCROOT/config-site.php
+
+   echo >> $DOCROOT/config-site.php
+
+   echo "\$config['ENABLE_SYSLOG'] = 1;" >> $DOCROOT/config-site.php
+
+   echo >> $DOCROOT/config-site.php
+
+   echo "\$config['SMTP_DOMAIN'] = '$HOSTNAME';" >> $DOCROOT/config-site.php
+   echo "\$config['SMTP_FROMADDR'] = 'no-reply@$HOSTNAME';" >> $DOCROOT/config-site.php
+   echo "\$config['ADMIN_EMAIL'] = 'admin@$HOSTNAME';" >> $DOCROOT/config-site.php
+
+   echo >> $DOCROOT/config-site.php
+
+   echo "\$config['DB_DRIVER'] = 'mysql';" >> $DOCROOT/config-site.php
+   echo "\$config['DB_PREFIX'] = '';" >> $DOCROOT/config-site.php
+   echo "\$config['DB_HOSTNAME'] = '$MYSQL_HOSTNAME';" >> $DOCROOT/config-site.php
+   echo "\$config['DB_USERNAME'] = '$MYSQL_USERNAME';" >> $DOCROOT/config-site.php
+   echo "\$config['DB_PASSWORD'] = '$MYSQL_PASSWORD';" >> $DOCROOT/config-site.php
+   echo "\$config['DB_DATABASE'] = '$MYSQL_DATABASE';" >> $DOCROOT/config-site.php
+
+   echo >> $DOCROOT/config-site.php
+
+   echo "\$config['SMARTHOST'] = '$SMARTHOST';" >> $DOCROOT/config-site.php
+   echo "\$config['SMARTHOST_PORT'] = $SMARTHOST_PORT;" >> $DOCROOT/config-site.php
+
+   echo >> $DOCROOT/config-site.php
+
+   echo "?>" >> $DOCROOT/config-site.php
+
+   echo "Done."
+
+}
+
+
+clean_up_temp_stuff() {
+   rm -f $CRON_TMP
+
+   echo; echo "Done post installation tasks."; echo
+}
+
+
+load_default_values
+
+
+if [ $# -ne 4 ]; then usage; fi
+
+PILERUSER=$1
+PILERGROUP=$2
+SYSCONFDIR=$3
+LOCALSTATEDIR=$4
+
+
+#LOGFILE="/tmp/piler-install.log.$$"
+#touch $LOGFILE
+#chmod 600 $LOGFILE
+
+preinstall_check
+
+display_install_intro
+
+gather_webserver_data
+gather_mysql_account
+gather_sphinx_data
+gather_smtp_relay_data
+
+
+make_cron_entries
+make_new_key
+
+show_summary
+
+execute_post_install_tasks
+
+clean_up_temp_stuff
+
+