Fix MySQL indexes if upgrading from 0.5-2 or lesser. Closes: #610725.

[roundcube.git] / debian / roundcube-core.postinst

diff --git a/debian/roundcube-core.postinst b/debian/roundcube-core.postinst
index c1968a65e6c55dbd9687c6513b986a726dfa7931..f4e2a8273a9cf551480fd564f46e099c43c821c8 100644 (file)
--- a/debian/roundcube-core.postinst
+++ b/debian/roundcube-core.postinst
@@ -39,6 +39,27 @@ apache_install() {
 case "$1" in
     configure)
 
+       # We try to fix an incomplete upgrade (see #610725)
+       if [ -n "$2" ] && dpkg --compare-versions "$2" le 0.5-2; then
+           db_get roundcube/dbconfig-upgrade || true
+           if [ x"$RET" = x"true" ]; then
+               # Ok, we may need to do some upgrade steps. Let's get
+               # database parameters
+               eval `sed -n 's/^\$\(.*\);$/\1/p' /etc/roundcube/debian-db.php`
+               if [ x"$dbtype" = x"mysql" ]; then
+                   echo "Fixing MySQL indexes (you can ignore errors)..."
+                   MYSQLARGS="-f -u $dbuser -p$dbpass $dbname"
+                   [ -z "$dbserver" ] || MYSQLARGS="-h $dbserver $MYSQLARGS"
+                   [ -z "$dbport" ] || MYSQLARGS="-P $dbport $MYSQLARGS"
+                   cat <<EOF | mysql $MYSQLARGS || true
+ALTER TABLE \`messages\` ADD INDEX \`index_index\` (\`user_id\`, \`cache_key\`, \`idx\`);
+ALTER TABLE \`session\` CHANGE \`vars\` \`vars\` MEDIUMTEXT NOT NULL;
+ALTER TABLE \`contacts\`ADD INDEX \`user_contacts_index\` (\`user_id\`,\`email\`);
+EOF
+               fi
+           fi
+       fi
+
        CONFFILE=/etc/roundcube/main.inc.php
        touch $CONFFILE.ucftmp
        chmod 640 $CONFFILE.ucftmp