]> git.donarmstrong.com Git - roundcube.git/blob - debian/roundcube-core.postinst
Fix MySQL indexes if upgrading from 0.5-2 or lesser. Closes: #610725.
[roundcube.git] / debian / roundcube-core.postinst
1 #!/bin/sh
2 # postinst script for roundcube
3 #
4 # see: dh_installdeb(1)
5
6 set -e
7
8 . /usr/share/debconf/confmodule
9 . /usr/share/dbconfig-common/dpkg/postinst 
10 dbc_generate_include=php:/etc/roundcube/debian-db.php
11 dbc_generate_include_owner="www-data:www-data"
12 dbc_generate_include_perms="640"
13 dbc_dbfile_owner="www-data:www-data"
14 dbc_dbfile_perms="0660"
15 dbc_dbuser=roundcube
16 dbc_dbname=roundcube
17
18 dbc_go roundcube $@
19
20 lighttpd_install() {
21         if [ ! -f /etc/lighttpd/conf-available/50-roundcube.conf ] ; then
22                 if [ ! -x /usr/sbin/lighty-enable-mod ] ; then
23                         echo "Lighttpd not installed, skipping"
24                 else
25                         ln -s /etc/roundcube/lighttpd.conf /etc/lighttpd/conf-available/50-roundcube.conf
26                         lighty-enable-mod roundcube
27                 fi
28         fi
29 }
30
31 apache_install() {
32         webserver=$1
33         if [ -d /etc/$webserver/conf.d ] && [ ! -e /etc/$webserver/conf.d/roundcube ]; then
34                ln -s /etc/roundcube/apache.conf /etc/$webserver/conf.d/roundcube
35         fi
36 }
37
38
39 case "$1" in
40     configure)
41
42         # We try to fix an incomplete upgrade (see #610725)
43         if [ -n "$2" ] && dpkg --compare-versions "$2" le 0.5-2; then
44             db_get roundcube/dbconfig-upgrade || true
45             if [ x"$RET" = x"true" ]; then
46                 # Ok, we may need to do some upgrade steps. Let's get
47                 # database parameters
48                 eval `sed -n 's/^\$\(.*\);$/\1/p' /etc/roundcube/debian-db.php`
49                 if [ x"$dbtype" = x"mysql" ]; then
50                     echo "Fixing MySQL indexes (you can ignore errors)..."
51                     MYSQLARGS="-f -u $dbuser -p$dbpass $dbname"
52                     [ -z "$dbserver" ] || MYSQLARGS="-h $dbserver $MYSQLARGS"
53                     [ -z "$dbport" ] || MYSQLARGS="-P $dbport $MYSQLARGS"
54                     cat <<EOF | mysql $MYSQLARGS || true
55 ALTER TABLE \`messages\` ADD INDEX \`index_index\` (\`user_id\`, \`cache_key\`, \`idx\`);
56 ALTER TABLE \`session\` CHANGE \`vars\` \`vars\` MEDIUMTEXT NOT NULL;
57 ALTER TABLE \`contacts\`ADD INDEX \`user_contacts_index\` (\`user_id\`,\`email\`);
58 EOF
59                 fi
60             fi
61         fi
62
63         CONFFILE=/etc/roundcube/main.inc.php
64         touch $CONFFILE.ucftmp
65         chmod 640 $CONFFILE.ucftmp
66
67         db_get roundcube/hosts || true
68         hosts="$RET"
69         if [ "$hosts" != "" ]; then
70             hosts="array(\"$(echo $hosts | sed 's/ /\",\"/g')\")"
71         else
72             hosts="''"
73         fi
74
75         db_get roundcube/language || true
76         language="$RET"
77
78         # Get current 3DES key from /etc/roundcube/main.inc.php
79         [ -f /etc/roundcube/main.inc.php ] && {
80             deskey=$(sed -n "s+^\$rcmail_config\['des_key'\] = '\(.*\)';\$+\1+p" \
81                 /etc/roundcube/main.inc.php)
82         }
83         # If this is the default key, forget it !
84         [ "$deskey" = "rcmail-!24ByteDESkey*Str" ] && unset deskey
85         # Generate a new one
86         while [ -z "$deskey" ]; do
87             deskey=$(dd if=/dev/urandom bs=1 count=200 2> /dev/null | \
88                 tr -c -d '[A-Za-z0-9]' | sed -n 's/\(.\{24\}\).*/\1/p')
89         done
90
91         # Put hosts, language and key in main.inc.php
92         cat /usr/share/roundcube/main.inc.php.dist | \
93             sed -e "s+^\(\$rcmail_config\['default_host'\] = \)''\(;\)\$+\1${hosts}\2+" \
94                 -e "s+^\(\$rcmail_config\['des_key'\] = '\).*\(';\)\$+\1$deskey\2+" \
95                 -e "s+^\(\$rcmail_config\['language'\] = \).*\(;\)\$+\1'${language}'\2+" >> $CONFFILE.ucftmp
96
97         ucf --debconf-ok $CONFFILE.ucftmp $CONFFILE
98         chown root:www-data $CONFFILE
99         rm -f $CONFFILE.ucftmp
100         
101         # Handle webserver reconfiguration/restart ; stolen from zabbix package
102         db_get roundcube/reconfigure-webserver || true
103         webservers="$RET"
104         restart=""
105
106         for webserver in $webservers; do
107             webserver=${webserver%,}
108             if [ "$webserver" = "lighttpd" ] ; then
109                 lighttpd_install
110             else
111                 apache_install $webserver
112             fi
113             test -x /usr/sbin/$webserver || continue
114             restart="$restart $webserver"
115         done
116
117         db_get roundcube/restart-webserver || true
118         res="$RET"
119         db_stop || true
120         if [ "$res" = "true" ]; then
121             for webserver in $restart; do
122                 webserver=${webserver%,}
123                 # Redirection of 3 is needed because Debconf uses it and it might
124                 # be inherited by webserver. See bug #446324.
125                 if [ -x /usr/sbin/invoke-rc.d ]; then
126                     invoke-rc.d $webserver reload 3>/dev/null || true
127                 else
128                     /etc/init.d/$webserver reload 3>/dev/null || true
129                 fi
130             done
131         fi
132
133         chown -R www-data:adm /var/log/roundcube
134         chmod -R 750 /var/log/roundcube
135         chown -R www-data:www-data /var/lib/roundcube/temp
136         chmod -R 750 /var/lib/roundcube/temp
137
138     ;;
139
140     abort-upgrade|abort-remove|abort-deconfigure)
141     ;;
142
143     *)
144         echo "postinst called with unknown argument \`$1'" >&2
145         exit 1
146     ;;
147 esac
148
149
150 #DEBHELPER#
151
152 exit 0
153
154