root/trunk/midgard/tools/midrepository/dbinstall.in

#!/bin/sh

OCWD=`pwd`

if test "`perl -e 'print $>'`" != "0"; then
  echo $0 must be run as root
  exit 1
fi

echo Creating blobs...
if test "@INSTALL@" = "new"; then
    for i in @BLOBROOT@/blobs_@STAGING_DB@ @BLOBROOT@/blobs_@LIVE_DB@ @BLOBROOT@/blobs_@CENTRALSTAGING_DB@ @BLOBROOT@/blobs_@CENTRALLIVE_DB@;
      do mkdir -p $i;
      if test -d $i ; then
      cd $i
      tar xfz "$OCWD/blobs.tar.gz"
      chown -R @APACHE_USER@ *
      chgrp -R @APACHE_GROUP@ *
      chmod -R 2771 `find -type d`
      chmod -R 0664 `find -type f`
      cd $OCWD
    fi;
    done;
else 
      if test -d @BLOBROOT@/blobs_@CONVERT_DB@ ; then
       for i in @BLOBROOT@/blobs_@STAGING_DB@ @BLOBROOT@/blobs_@LIVE_DB@ @BLOBROOT@/blobs_@CENTRALSTAGING_DB@ @BLOBROOT@/blobs_@CENTRALLIVE_DB@;
         do cp -a @BLOBROOT@/blobs_@CONVERT_DB@ $i; 
        chown -R @APACHE_USER@ $i;
        chgrp -R @APACHE_GROUP@ $i;
        done; 
      else 
       exit "Can't find blobs to convert at @BLOBROOT@/blobs_@CONVERT_DB@";
      fi
fi


if test "@INSTALL@" = "new"; then
  echo Creating Midgard database...
  mysqladmin --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" create @STAGING_DB@
  mysql --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" @STAGING_DB@ < midgarddb
  echo Creating BLOBs...
  tar xfz blobs.tar.gz -C @STAGING_BLOBDIR@
  chown -R @APACHE_USER@.@APACHE_GROUP@ @STAGING_BLOBDIR@/*
  chmod -R 2771 `find @STAGING_BLOBDIR@ -type d`
  chmod -R 0664 `find @STAGING_BLOBDIR@ -type f`
else
  mysqldump --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" @CONVERT_DB@ > dbdump
  mysqladmin --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" create @STAGING_DB@
  mysql @STAGING_DB@ < dbdump
  if ! ./database-upgrade; then
    echo
    echo Database is not up to date, or database-upgrade did not run
    echo correctly. Please run database-upgrade manually
    exit
  fi
fi

echo Updating MySQL database...
mysql --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" mysql < mysql-user.sql >/dev/null 2>/dev/null
mysql --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" mysql < mysql-db.sql >/dev/null 2>/dev/null


# create spool dirs
mkdir -p /var/spool/mgd
cd /var/spool/mgd
tar xfz "$OCWD/spooldirs.tar.gz"
chown -R @APACHE_USER@ *
chgrp -R @APACHE_GROUP@ *
chmod -R 2771 `find $i`;
cd $OCWD

# create cache dirs
for i in @STAGING_CACHEDIR@ @LIVE_CACHEDIR@ @CENTRALSTAGING_CACHEDIR@ @CENTRALLIVE_CACHEDIR@;
do mkdir -p $i;
chown @APACHE_USER@ $i;
chown @APACHE_GROUP@ $i;
chmod 2771 $i;
done;

# create scripts directory
mkdir -p @WORKFLOW@;
mkdir @WORKFLOW@/tmp
mkdir @WORKFLOW@/bin
mkdir @WORKFLOW@/lib
mkdir @WORKFLOW@/etc
mkdir @WORKFLOW@/cvs
mkdir @WORKFLOW@/cvsrepos
cp workflow.xml vcstaging.conf vclive.conf centralstaging.conf centrallive.conf @WORKFLOW@/etc
cp *.php @WORKFLOW@/lib
cp clients/* @WORKFLOW@/bin
# create repligard configuration
chown -R @APACHE_USER@ *;
chown -R @APACHE_GROUP@ *;
cd $OCWD;

# insert objects needed for vc + wf

repligard -a -c @WORKFLOW@/etc/vcstaging.conf -i support.xml

# clone db
echo Clone database...
mysqldump --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" @STAGING_DB@ > dbdump
for i in @LIVE_DB@ @CENTRALSTAGING_DB@ @CENTRALLIVE_DB@;
do mysqladmin --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" create $i
mysql --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" $i < dbdump;
done

rm dbdump;

chown -R @APACHE_USER@ @WORKFLOW@;
chgrp -R @APACHE_GROUP@ @WORKFLOW@;

# create meta db & cvs
echo Create meta db and cvs...
if test "@INSTALL@" = "convert"; then
  mysqladmin --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" create @META_DB@
  mysql --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" @META_DB@ < global.sql
  sed /midgard-data.conf/d < @SYSCONFDIR@/httpd.conf > httpd.conf
  echo "Include $OCWD/midgard-workflow.conf" >> httpd.conf
  apachectl stop
  sleep 5
  apachectl start
  sleep 5
  @WORKFLOW@/bin/call-migrate.php
  apachectl stop
else
  mysqladmin --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" create @META_DB@
  mysql --user="@DB_ADMIN_USER@" --password="@DB_ADMIN_PASSWORD@" --host="@DB_HOST@" @META_DB@ < metadb
  cd @WORKFLOW@
  tar xfz $OCWD/cvs.tar.gz 
  cd $OCWD
fi

chown -R @APACHE_USER@ @WORKFLOW@;
chgrp -R @APACHE_GROUP@ @WORKFLOW@;

if ! grep "bin/everymin.php" /etc/crontab &> /dev/null; then
  echo "0-59 * * * * @APACHE_USER@ @WORKFLOW@/bin/everymin.php >> /tmp/everymin.log 2>&1" >> /etc/crontab
  echo Notice: @WORKFLOW@/bin/everymin.php has been added to /etc/crontab. Please restart crond.
fi

echo "*** Install succeeded! ***"
echo Do the following to complete the installation:
echo - Add @WORKFLOW@ to the PHP config variable \"include_path\"
echo - Include / merge midgard-workflow.conf into your apache config and reload apache.