+roundcube (0.2~stable-1) unstable; urgency=low
+
+ * New upstream version. Closes: #503573, #504570.
+ + Add SQL update scripts for this new release and for
+ 0.2~alpha. Remove copy of SQL upgrade script from debian/rules.
+ + Remove patch for CVE-2008-5620 which is now fixed upstream.
+ + Remove patch correcting a vulnerability in html2text.php.
+ + Remove patch fixing login issue. This is fixed upstream.
+ + Remove patch setting the default backend to db instead of mdb2:
+ this is not possible any more. We depend on php-mdb2 now.
+ + Update patch to use packaged tinymce.
+ * Upload to unstable since Lenny is out.
+ * Apply fix for XSS issue (CVE-2009-0413). Closes: #514179.
+ * Remove hack to update a SQLite table for an upgrade from a quite old
+ version of roundcube.
+ * Fix pending l10n issues:
+ + Update English debconf template. Closes: #473794.
+ + Add Swedish translation thanks to Martin Bagge. Closes: #508752.
+ * Fix debian/copyright to make lintian happy.
+
+ -- Vincent Bernat <bernat@debian.org> Sun, 15 Feb 2009 16:18:58 +0100
+
roundcube (0.2~alpha-4) experimental; urgency=low
* Add missing ${misc:Depends} to make Lintian happy.
Priority: extra
Maintainer: Debian Roundcube Maintainers <pkg-roundcube-maintainers@lists.alioth.debian.org>
Uploaders: Vincent Bernat <bernat@debian.org>, Romain Beauxis <toots@rastageeks.org>
-Build-Depends: debhelper (>= 5), quilt, patchutils (>= 0.2.25), cdbs (>= 0.4.27), po-debconf
+Build-Depends: cdbs (>= 0.4.23-1.1), debhelper (>= 5), quilt, patchutils (>= 0.2.25), cdbs (>= 0.4.27), po-debconf
Homepage: http://www.roundcube.net/
Standards-Version: 3.8.0
Vcs-Svn: svn://svn.debian.org/svn/pkg-roundcube/roundcube
Package: roundcube-core
Architecture: all
-Depends: dbconfig-common, debconf | debconf-2.0, apache2 | lighttpd | httpd, php5, php5-mcrypt, php5-gd, roundcube-db, php-db, php-auth, php-net-smtp, php-net-socket, php-mail-mime (>= 1.5.0), ucf, tinymce (>= 3), ${misc:Depends}, libmagic1
+Depends: dbconfig-common, debconf | debconf-2.0, apache2 | lighttpd | httpd, php5, php5-mcrypt, php5-gd, roundcube-db, php-mdb2, php-auth, php-net-smtp, php-net-socket, php-mail-mime (>= 1.5.0), ucf, tinymce (>= 3), ${misc:Depends}, libmagic1
Replaces: roundcube
Conflicts: roundcube (<< 0.1~rc2-2)
Description: skinnable AJAX based webmail solution for IMAP servers
Package: roundcube
Architecture: all
Depends: roundcube-sqlite | roundcube-db, roundcube-core (= ${source:Version}), ${misc:Depends}
-Description: skinnable AJAX based webmail solution for IMAP servers
+Description: skinnable AJAX based webmail solution for IMAP servers - metapackage
RoundCube Webmail is a browser-based multilingual IMAP client with an
application-like user interface. It provides full functionality
expected from an e-mail client, including MIME support, address book,
Package: roundcube-mysql
Architecture: all
-Depends: php5-mysql, mysql-client | virtual-mysql-client, ${misc:Depends}
+Depends: php-mdb2-driver-mysql, mysql-client | virtual-mysql-client, ${misc:Depends}
Suggests: mysql-server
Provides: roundcube-db
Description: metapackage providing MySQL dependencies for RoundCube
Package: roundcube-pgsql
Architecture: all
-Depends: php5-pgsql, postgresql-client, ${misc:Depends}
+Depends: php-mdb2-driver-pgsql, postgresql-client-8.1 | postgresql-client, ${misc:Depends}
Suggests: postgresql-server
Provides: roundcube-db
Description: metapackage providing PostgreSQL dependencies for RoundCube
Package: roundcube-sqlite
Architecture: all
-Depends: php5-sqlite, sqlite, ${misc:Depends}
+Depends: php-mdb2-driver-sqlite, sqlite, ${misc:Depends}
Provides: roundcube-db
Description: metapackage providing sqlite dependencies for RoundCube
This package provides sqlite dependencies for RoundCube Webmail, a
Package: roundcube-core
Architecture: all
-Depends: dbconfig-common, debconf | debconf-2.0, apache2 | lighttpd | httpd, php5, php5-mcrypt, php5-gd, roundcube-db, php-db, php-auth, php-net-smtp, php-net-socket, php-mail-mime (>= 1.5.0), ucf, tinymce (>= 3), ${misc:Depends}, libmagic1
+Depends: dbconfig-common, debconf | debconf-2.0, apache2 | lighttpd | httpd, php5, php5-mcrypt, php5-gd, roundcube-db, php-mdb2, php-auth, php-net-smtp, php-net-socket, php-mail-mime (>= 1.5.0), ucf, tinymce (>= 3), ${misc:Depends}, libmagic1
Replaces: roundcube
Conflicts: roundcube (<< 0.1~rc2-2)
Description: skinnable AJAX based webmail solution for IMAP servers
Package: roundcube
Architecture: all
Depends: roundcube-sqlite | roundcube-db, roundcube-core (= ${source:Version}), ${misc:Depends}
-Description: skinnable AJAX based webmail solution for IMAP servers
+Description: skinnable AJAX based webmail solution for IMAP servers - metapackage
RoundCube Webmail is a browser-based multilingual IMAP client with an
application-like user interface. It provides full functionality
expected from an e-mail client, including MIME support, address book,
Package: roundcube-mysql
Architecture: all
-Depends: php5-mysql, mysql-client | virtual-mysql-client, ${misc:Depends}
+Depends: php-mdb2-driver-mysql, mysql-client | virtual-mysql-client, ${misc:Depends}
Suggests: mysql-server
Provides: roundcube-db
Description: metapackage providing MySQL dependencies for RoundCube
Package: roundcube-pgsql
Architecture: all
-Depends: php5-pgsql, postgresql-client-8.1 | postgresql-client, ${misc:Depends}
+Depends: php-mdb2-driver-pgsql, postgresql-client-8.1 | postgresql-client, ${misc:Depends}
Suggests: postgresql-server
Provides: roundcube-db
Description: metapackage providing PostgreSQL dependencies for RoundCube
Package: roundcube-sqlite
Architecture: all
-Depends: php5-sqlite, sqlite, ${misc:Depends}
+Depends: php-mdb2-driver-sqlite, sqlite, ${misc:Depends}
Provides: roundcube-db
Description: metapackage providing sqlite dependencies for RoundCube
This package provides sqlite dependencies for RoundCube Webmail, a
License: GPL
RoundCube may be redistributed under the terms of the GNU GPL, Version
-2, found on Debian systems in the file /usr/share/common-licenses/GPL
+2, found on Debian systems in the file /usr/share/common-licenses/GPL-2
The file index.php incorrectly states that it is BSD licensed. This
was a mistake and this was changed in SVN:
- lib/magic is an autogenerated file. We don't ship it and use the
one from libmagic1 instead. Here is the license:
- Copyright (C) 1985-1995 Ian F. Darwin
- Copyright (C) 1994-2008 Christos Zoulas <christos@zoulas.com>
+ Copyright © 1985-1995 Ian F. Darwin
+ Copyright © 1994-2008 Christos Zoulas <christos@zoulas.com>
This software is not subject to any export provision of the United
States Department of Commerce, and may be exported to any country or
All other licenses can be found in the corresponding source file.
-The Debian packaging is (C) 2007, Vincent Bernat <bernat@luffy.cx> and
-is licensed under the GPL, see `/usr/share/common-licenses/GPL'.
+The Debian packaging is © 2007, Vincent Bernat <bernat@luffy.cx> and
+is licensed under the GPL, see `/usr/share/common-licenses/GPL-2'.
+++ /dev/null
-Fix CVE-2008-5620 which was caused by insufficient input sanitizing for quota bar.
-
-diff --git a/bin/quotaimg.php b/bin/quotaimg.php
-index 354f4eb..4e73c21 100644
---- a/bin/quotaimg.php
-+++ b/bin/quotaimg.php
-@@ -18,10 +18,10 @@
-
- */
-
--$used = ((isset($_GET['u']) && !empty($_GET['u'])) || $_GET['u']=='0')?(int)$_GET['u']:'??';
--$quota = ((isset($_GET['q']) && !empty($_GET['q'])) || $_GET['q']=='0')?(int)$_GET['q']:'??';
--$width = empty($_GET['w']) ? 100 : (int)$_GET['w'];
--$height = empty($_GET['h']) ? 14 : (int)$_GET['h'];
-+$used = isset($_GET['u']) ? intval($_GET['u']) : '??';
-+$quota = isset($_GET['q']) ? intval($_GET['q']) : '??';
-+$width = empty($_GET['w']) ? 100 : min(300, intval($_GET['w']));
-+$height = empty($_GET['h']) ? 14 : min(50, intval($_GET['h']));
-
- /**
- * Quota display
-@@ -159,7 +159,7 @@ function genQuota($used, $total, $width, $height)
- }
-
- $quota_width = $quota / 100 * $width;
-- imagefilledrectangle($im, $border, 0, $quota, $height-2*$border, $fill);
-+ imagefilledrectangle($im, $border, 0, $quota_width, $height-2*$border, $fill);
-
- $string = $quota . '%';
- $mid = floor(($width-(strlen($string)*imagefontwidth($font)))/2)+1;
-@@ -178,6 +178,12 @@ function genQuota($used, $total, $width, $height)
- imagedestroy($im);
- }
-
--genQuota($used, $quota, $width, $height);
-+if ($width > 1 && $height > 1) {
-+ genQuota($used, $quota, $width, $height);
-+}
-+else {
-+ header("HTTP/1.0 404 Not Found");
-+}
-+
- exit;
- ?>
-\ No newline at end of file
--- /dev/null
+Fix CVE-2009-0413 by handling carefully background attribute.
+--- roundcubemail/CHANGELOG (revision 2242)
++++ roundcubemail/CHANGELOG (revision 2245)
+@@ -1,4 +1,8 @@
+ CHANGELOG RoundCube Webmail
+ ---------------------------
++
++2009/01/20 (thomasb)
++----------
++- Fix XSS vulnerability through background attributes as reported by Julien Cayssol
+
+ 2009/01/18 (alec)
+--- roundcubemail/program/lib/washtml.php (revision 1811)
++++ roundcubemail/program/lib/washtml.php (revision 2245)
+@@ -81,5 +81,5 @@
+
+ /* Allowed HTML attributes */
+- static $html_attribs = array('name', 'class', 'title', 'alt', 'width', 'height', 'align', 'nowrap', 'col', 'row', 'id', 'rowspan', 'colspan', 'cellspacing', 'cellpadding', 'valign', 'bgcolor', 'color', 'border', 'bordercolorlight', 'bordercolordark', 'face', 'marginwidth', 'marginheight', 'axis', 'border', 'abbr', 'char', 'charoff', 'clear', 'compact', 'coords', 'vspace', 'hspace', 'cellborder', 'size', 'lang', 'dir', 'background');
++ static $html_attribs = array('name', 'class', 'title', 'alt', 'width', 'height', 'align', 'nowrap', 'col', 'row', 'id', 'rowspan', 'colspan', 'cellspacing', 'cellpadding', 'valign', 'bgcolor', 'color', 'border', 'bordercolorlight', 'bordercolordark', 'face', 'marginwidth', 'marginheight', 'axis', 'border', 'abbr', 'char', 'charoff', 'clear', 'compact', 'coords', 'vspace', 'hspace', 'cellborder', 'size', 'lang', 'dir');
+
+ /* State for linked objects in HTML */
+@@ -161,13 +161,13 @@
+ $value = $node->getAttribute($key);
+ if(isset($this->_html_attribs[$key]) ||
+- ($key == 'href' && preg_match('/^(http|https|ftp|mailto):.*/i', $value)))
++ ($key == 'href' && preg_match('/^(http|https|ftp|mailto):.+/i', $value)))
+ $t .= ' ' . $key . '="' . htmlspecialchars($value, ENT_QUOTES) . '"';
+ else if($key == 'style' && ($style = $this->wash_style($value)))
+ $t .= ' style="' . $style . '"';
+- else if($key == 'src' && strtolower($node->tagName) == 'img') { //check tagName anyway
++ else if($key == 'background' || ($key == 'src' && strtolower($node->tagName) == 'img')) { //check tagName anyway
+ if($src = $this->config['cid_map'][$value]) {
+ $t .= ' ' . $key . '="' . htmlspecialchars($src, ENT_QUOTES) . '"';
+ }
+- else if(preg_match('/^(http|https|ftp):.*/i', $value)) {
++ else if(preg_match('/^(http|https|ftp):.+/i', $value)) {
+ if($this->config['allow_remote'])
+ $t .= ' ' . $key . '="' . htmlspecialchars($value, ENT_QUOTES) . '"';
+@@ -175,5 +175,5 @@
+ $this->extlinks = true;
+ if ($this->config['blocked_src'])
+- $t .= ' src="' . htmlspecialchars($this->config['blocked_src'], ENT_QUOTES) . '"';
++ $t .= ' ' . $key . '="' . htmlspecialchars($this->config['blocked_src'], ENT_QUOTES) . '"';
+ }
+ }
+++ /dev/null
-Fix a vulnerability due to the use of "e" option of preg_replace.
-
---- roundcube-0.2~alpha/program/lib/html2text.php 2008-04-12 15:54:45.000000000 +0200
-+++ roundcube-0.2~alpha/program/lib/html2text.php 2008-12-13 14:21:44.000000000 +0100
-@@ -99,6 +99,22 @@
- */
- var $width = 70;
-
-+ /**
-+ * List of preg* regular expression patterns to search for
-+ * and replace using callback function.
-+ *
-+ * @var array $callback_search
-+ * @access public
-+ */
-+ var $callback_search = array(
-+ '/<(h)[123456][^>]*>(.*?)<\/h[123456]>/i', // H1 - H3
-+ '/<(b)[^>]*>(.*?)<\/b>/i', // <b>
-+ '/<(strong)[^>]*>(.*?)<\/strong>/i', // <strong>
-+ '/<(a) [^>]*href=("|\')([^"\']+)\2[^>]*>(.*?)<\/a>/i',
-+ // <a href="">
-+ '/<(th)[^>]*>(.*?)<\/th>/i', // <th> and </th>
-+ );
-+
- /**
- * List of preg* regular expression patterns to search for,
- * used in conjunction with $replace.
-@@ -112,12 +128,8 @@
- "/[\n\t]+/", // Newlines and tabs
- '/<script[^>]*>.*?<\/script>/i', // <script>s -- which strip_tags supposedly has problems with
- //'/<!-- .* -->/', // Comments -- which strip_tags might have problem a with
-- '/<a [^>]*href=("|\')([^"\']+)\1[^>]*>(.+?)<\/a>/ie', // <a href="">
-- '/<h[123][^>]*>(.+?)<\/h[123]>/ie', // H1 - H3
-- '/<h[456][^>]*>(.+?)<\/h[456]>/ie', // H4 - H6
- '/<p[^>]*>/i', // <P>
- '/<br[^>]*>/i', // <br>
-- '/<b[^>]*>(.+?)<\/b>/ie', // <b>
- '/<i[^>]*>(.+?)<\/i>/i', // <i>
- '/(<ul[^>]*>|<\/ul>)/i', // <ul> and </ul>
- '/(<ol[^>]*>|<\/ol>)/i', // <ol> and </ol>
-@@ -126,7 +138,6 @@
- '/(<table[^>]*>|<\/table>)/i', // <table> and </table>
- '/(<tr[^>]*>|<\/tr>)/i', // <tr> and </tr>
- '/<td[^>]*>(.+?)<\/td>/i', // <td> and </td>
-- '/<th[^>]*>(.+?)<\/th>/ie', // <th> and </th>
- '/ /i',
- '/"/i',
- '/>/i',
-@@ -161,12 +172,8 @@
- ' ', // Newlines and tabs
- '', // <script>s -- which strip_tags supposedly has problems with
- //'', // Comments -- which strip_tags might have problem a with
-- '$this->_build_link_list("\\2", "\\3")', // <a href="">
-- "strtoupper(\"\n\n\\1\n\n\")", // H1 - H3
-- "ucwords(\"\n\n\\1\n\")", // H4 - H6
- "\n\n", // <P>
- "\n", // <br>
-- 'strtoupper("\\1")', // <b>
- '_\\1_', // <i>
- "\n\n", // <ul> and </ul>
- "\n\n", // <ol> and </ol>
-@@ -175,7 +182,6 @@
- "\n\n", // <table> and </table>
- "\n", // <tr> and </tr>
- "\t\t\\1\n", // <td> and </td>
-- "strtoupper(\"\t\t\\1\n\")", // <th> and </th>
- ' ',
- '"',
- '>',
-@@ -379,6 +385,7 @@
-
- // Run our defined search-and-replace
- $text = preg_replace($this->search, $this->replace, $text);
-+ $text = preg_replace_callback($this->callback_search, array('html2text', '_preg_callback'), $text);
-
- // Strip any other HTML tags
- $text = strip_tags($text, $this->allowed_tags);
-@@ -446,6 +453,44 @@
-
- return $display . ' [' . ($index+1) . ']';
- }
-+
-+ /**
-+ * Callback function for preg_replace_callback use.
-+ *
-+ * @param array PREG matches
-+ * @return string
-+ * @access private
-+ */
-+ function _preg_callback($matches)
-+ {
-+ switch($matches[1])
-+ {
-+ case 'b':
-+ case 'strong':
-+ return $this->_strtoupper($matches[2]);
-+ case 'hr':
-+ return $this->_strtoupper("\t\t". $matches[2] ."\n");
-+ case 'h':
-+ return $this->_strtoupper("\n\n". $matches[2] ."\n\n");
-+ case 'a':
-+ return $this->_build_link_list($matches[3], $matches[4]);
-+ }
-+ }
-+
-+ /**
-+ * Strtoupper multibyte wrapper function
-+ *
-+ * @param string
-+ * @return string
-+ * @access private
-+ */
-+ function _strtoupper($str)
-+ {
-+ if (function_exists('mb_strtoupper'))
-+ return mb_strtoupper($str);
-+ else
-+ return strtoupper($str);
-+ }
- }
-
- ?>
-\ Pas de fin de ligne à la fin du fichier.
+++ /dev/null
-Fix login redirection.
-
---- a/program/include/rcmail.php~ 2008-06-07 21:33:07.000000000 +0200
-+++ a/program/include/rcmail.php 2008-06-22 13:36:57.000000000 +0200
-@@ -474,7 +474,7 @@
- public function autoselect_host()
- {
- $default_host = $this->config->get('default_host');
-- $host = !empty($default_host) ? get_input_value('_host', RCUBE_INPUT_POST) : $default_host;
-+ $host = isset($_POST['_host']) ? get_input_value('_host', RCUBE_INPUT_POST) : $default_host;
-
- if (is_array($host)) {
- list($user, $domain) = explode('@', get_input_value('_user', RCUBE_INPUT_POST));
--- /dev/null
+Log failed logins.
+--- roundcube-0.1.1/index.php 2008-11-11 18:17:37.939438895 +0900
++++ roundcube-0.1.1-secured/index.php 2008-11-11 18:01:06.000000000 +0900
+@@ -101,6 +101,9 @@
+ }
+ else {
+ $OUTPUT->show_message($IMAP->error_code < -1 ? 'imaperror' : 'loginfailed', 'warning');
++ if($IMAP->error_code != -1){
++ file_put_contents('php://stderr',"[".strftime("%c")."] [roundcube] [client ".$_SERVER['REMOTE_ADDR']."] failed login attempt.\n");
++ }
+ $RCMAIL->kill_session();
+ }
+ }
dbconfig-common_support.patch
correct_install_path.patch
use_packaged_tinymce.patch
-use-db-backend.patch
correct-magic-path.patch
-fix_login.patch
-dont-use-preg-e-option.patch
-cve-2008-5620.patch
+cve-2009-0413.patch
+++ /dev/null
-Use db backend since mdb2 is not yet available in Debian.
-
---- roundcubemail-0.1-dep/config/db.inc.php.dist~ 2008-03-03 22:32:15.000000000 +0100
-+++ roundcubemail-0.1-dep/config/db.inc.php.dist 2008-03-05 21:07:28.000000000 +0100
-@@ -27,7 +27,7 @@
- $rcmail_config['db_dsnr'] = '';
-
- // database backend to use (only db or mdb2 are supported)
--$rcmail_config['db_backend'] = 'mdb2';
-+$rcmail_config['db_backend'] = 'db';
-
- // maximum length of a query in bytes
- $rcmail_config['db_max_length'] = 512000; // 500K
Use tinymce from tinycme package instead of the shipped one.
-Index: roundcube-0.1~rc2/program/steps/mail/sendmail.inc
-===================================================================
---- a/program/steps/mail/sendmail.inc~ 2008-04-30 10:21:42.000000000 +0200
-+++ a/program/steps/mail/sendmail.inc 2008-06-22 13:51:33.000000000 +0200
-@@ -74,7 +74,7 @@
-
- $last_img_pos = 0;
-
-- $searchstr = 'program/js/tiny_mce/plugins/emotions/images/';
-+ $searchstr = 'program/js/tiny_mce/plugins/emotions/img/';
-
- // keep track of added images, so they're only added once
- $included_images = array();
--- roundcube-0.1~rc2.orig/program/steps/mail/sendmail.inc 2007-11-26 11:42:36.000000000 +0100
+++ roundcube-0.1~rc2/program/steps/mail/sendmail.inc 2007-11-26 11:44:04.000000000 +0100
-@@ -108,7 +108,7 @@
- if (! in_array($image_name, $included_images))
- {
- // add the image to the MIME message
-- $img_file = INSTALL_PATH . '/' . $searchstr . $image_name;
-+ $img_file = '/usr/share/tinymce/www/plugins/emotions/img/' . $image_name;
-- if(! $mime_message->addHTMLImage($img_file, 'image/gif', '', true, '_' . $image_name))
-+ if(! $mime_message->addHTMLImage($img_file, 'image/gif', '', true, $image_name))
- $OUTPUT->show_message("emoticonerror", 'error');
+@@ -123,7 +123,7 @@
---- a/program/steps/mail/sendmail.inc~ 2008-04-30 10:21:42.000000000 +0200
-+++ a/program/steps/mail/sendmail.inc 2008-06-22 14:10:24.000000000 +0200
-@@ -102,7 +102,7 @@
- array_push($included_images, $image_name);
- }
+ // sanitize image name so resulting attachment doesn't leave images dir
+ $image_name = preg_replace('/[^a-zA-Z0-9_\.\-]/i','',$image_name);
+- $img_file = INSTALL_PATH . '/' . $searchstr . $image_name;
++ $img_file = '/usr/share/tinymce/www/plugins/emotions/img/' . $image_name;
-- $body = $body_pre . 'cid:_' . $image_name . $body_post;
-+ $body = $body_pre . $img_file . $body_post;
-
- $last_img_pos = $pos2;
- }
+ if (! in_array($image_name, $included_images))
+ {
msgstr ""
"Project-Id-Version: ar\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-18 15:29+0300\n"
"Last-Translator: Ossama M. Khayat <okhayat@yahoo.com>\n"
"Language-Team: Arabic <support@arabeyes.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "الرجاء اختيار خادم IMAP الذي يجب استخدامه مع RoundCube."
#. Type: string
msgstr ""
"Project-Id-Version: roundcube\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-09 13:03+0100\n"
"Last-Translator: Miroslav Kure <kurem@debian.cz>\n"
"Language-Team: Czech <debian-l10n-czech@lists.debian.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "Vyberte prosím IMAP server, který se má s RoundCube použít."
#. Type: string
msgstr ""
"Project-Id-Version: roundcube 0.1-3\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-07 19:08+0100\n"
"Last-Translator: Helge Kreutzmann <debian@helgefjell.de>\n"
"Language-Team: de <debian-l10n-german@lists.debian.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr ""
"Bitte wählen Sie den IMAP-Server aus, der mit RoundCube verwendet werden "
"soll."
msgstr ""
"Project-Id-Version: roundcube_0.1~rc1~dfsg-1\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-04-01 18:21+0200\n"
"Last-Translator: Carlos Galisteo <cgalisteo@k-rolus.net>\n"
"Language-Team: <debian-l10n-spanish@lists.debian.org>\n"
msgid ""
"RoundCube supports any web server supported by PHP, however only Apache 2 "
"and lighttpd can be configured automatically."
-msgstr "RoundCube funciona con cualquier servidor web que soporte PHP, sin embargo sólo se configuran automáticamente Apache 2 y lighttpd."
-
+msgstr ""
+"RoundCube funciona con cualquier servidor web que soporte PHP, sin embargo "
+"sólo se configuran automáticamente Apache 2 y lighttpd."
#. Type: multiselect
#. Description
msgid ""
"Please select the web server(s) that should be configured automatically for "
"RoundCube."
-msgstr "Seleccione el/los servidor/es web que debe/n configurarse automáticamente para RoundCube."
+msgstr ""
+"Seleccione el/los servidor/es web que debe/n configurarse automáticamente "
+"para RoundCube."
#. Type: boolean
#. Description
msgid ""
"In order to activate the new configuration, the reconfigured web server(s) "
"have to be restarted."
-msgstr "Debe/n reiniciarse el/los servidor/es web para activar la nueva configuración."
+msgstr ""
+"Debe/n reiniciarse el/los servidor/es web para activar la nueva "
+"configuración."
#. Type: string
#. Description
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "Seleccione el/los servidor/es IMAP que se usará/n con RoundCube."
#. Type: string
"If this is left blank, a text box will be displayed at login. Entering a "
"space-separated list of hosts will display a pull-down menu. Entering a "
"single host will enforce using this host."
-msgstr "Se mostrará un campo al autenticarse que el usuario podrá rellenar si deja este campo en blanco. Si proporciona una lista de equipos separados por espacios, se mostrará un menú desplegable. Si proporciona un único nombre de equipo se forzará el uso de este equipo."
+msgstr ""
+"Se mostrará un campo al autenticarse que el usuario podrá rellenar si deja "
+"este campo en blanco. Si proporciona una lista de equipos separados por "
+"espacios, se mostrará un menú desplegable. Si proporciona un único nombre de "
+"equipo se forzará el uso de este equipo."
#. Type: string
#. Description
#: ../templates:4001
msgid ""
"To use SSL connections, please enter host names as 'ssl://hostname:993'."
-msgstr "Escriba los nombres de sistema como «ssl://hostname:9993» si desea usar conexiones SSL."
+msgstr ""
+"Escriba los nombres de sistema como «ssl://hostname:9993» si desea usar "
+"conexiones SSL."
#. Type: select
#. Description
"However, the default language will be used for the login screen and the "
"first connection of users."
msgstr ""
-"Sin embargo, el idioma predeterminado se usará en la pantalla de autenticación "
-"y en la primera conexión de los usuarios."
+"Sin embargo, el idioma predeterminado se usará en la pantalla de "
+"autenticación y en la primera conexión de los usuarios."
msgstr ""
"Project-Id-Version: roundcube-eu\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-14 09:03+0100\n"
"Last-Translator: Piarres Beobide <pi@beobide.net>\n"
"Language-Team: Euskara <Librezale@librezale.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "Mesedez hautatu RoundCube-rekin erabiliko den IMAP zerbitzaria."
#. Type: string
msgstr ""
"Project-Id-Version: roundcube_0.1~rc2-4\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-08 00:45+0200\n"
"Last-Translator: Esko Arajärvi <edu@iki.fi>\n"
"Language-Team: Finnish <debian-l10n-finnish@lists.debian.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "Valitse IMAP-palvelimet, joita käytetään RoundCuben kanssa."
#. Type: string
msgstr ""
"Project-Id-Version: roundcube-0.1~rc1~dfsg-1\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-08 11:24+0100\n"
"Last-Translator: Vincent Bernat <bernat@luffy.cx>\n"
"Language-Team: French <debian-l10n-french@lists.debian.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "Veuillez choisir le serveur IMAP que doit utiliser RoundCube."
#. Type: string
msgstr ""
"Project-Id-Version: roundcube\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-07 16:27+0000\n"
"Last-Translator: Jacobo Tarrio <jtarrio@debian.org>\n"
"Language-Team: Galician <proxecto@trasno.net>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "Escolla o servidor IMAP que se debería empregar con RoundCube."
#. Type: string
msgstr ""
"Project-Id-Version: roundcube 0.1 italian debconf templates\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-08 12:09+0100\n"
"Last-Translator: Luca Monducci <luca.mo@tiscali.it>\n"
"Language-Team: Italian <debian-l10n-italian@lists.debian.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "Scegliere il server IMAP che deve essere usato con RoundCube."
#. Type: string
msgstr ""
"Project-Id-Version: roundcube\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-09 14:12+0000\n"
"Last-Translator: Miguel Figueiredo <elmig@debianpt.org>\n"
"Language-Team: Portuguese <traduz@debianpt.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr ""
"Por favor escolha o servidor IMAP que deve ser utilizado com o RoundCube."
msgstr ""
"Project-Id-Version: roundcube 0.1-3\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-07 16:44+0300\n"
"Last-Translator: Yuri Kozlov <kozlov.y@gmail.com>\n"
"Language-Team: Russian <debian-l10n-russian@lists.debian.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "Укажите сервер IMAP, который нужно использовать с RoundCube."
#. Type: string
msgstr ""
"Project-Id-Version: \n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-05-15 17:59+0100\n"
"Last-Translator: Ivan Masár <helix84@centrum.sk>\n"
"Language-Team: Slovak <sk-i18n@lists.linux.sk>\n"
#. Type: multiselect
#. Description
#: ../templates:2002
-msgid "RoundCube supports any web server supported by PHP, however only Apache 2 and lighttpd can be configured automatically."
-msgstr "RoundCube podporuje akýkoľvek webový server, ktorý podporuje PHP, avšak iba Apache 2 a lighttpd je možné nastaviť automaticky."
+msgid ""
+"RoundCube supports any web server supported by PHP, however only Apache 2 "
+"and lighttpd can be configured automatically."
+msgstr ""
+"RoundCube podporuje akýkoľvek webový server, ktorý podporuje PHP, avšak iba "
+"Apache 2 a lighttpd je možné nastaviť automaticky."
#. Type: multiselect
#. Description
#: ../templates:2002
-msgid "Please select the web server(s) that should be configured automatically for RoundCube."
-msgstr "Prosím, vyberte, ktoré webové servery sa majú nastaviť automaticky pre RoundCube."
+msgid ""
+"Please select the web server(s) that should be configured automatically for "
+"RoundCube."
+msgstr ""
+"Prosím, vyberte, ktoré webové servery sa majú nastaviť automaticky pre "
+"RoundCube."
#. Type: boolean
#. Description
#. Type: boolean
#. Description
#: ../templates:3001
-msgid "In order to activate the new configuration, the reconfigured web server(s) have to be restarted."
-msgstr "Aby sa aktivovala nové konfigurácia, nastavené webové servery je potrebné reštartovať."
+msgid ""
+"In order to activate the new configuration, the reconfigured web server(s) "
+"have to be restarted."
+msgstr ""
+"Aby sa aktivovala nové konfigurácia, nastavené webové servery je potrebné "
+"reštartovať."
#. Type: string
#. Description
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "Prosím, vyberte, ktorý IMAP server sa má použiť s RoundCube."
#. Type: string
#. Description
#: ../templates:4001
-msgid "If this is left blank, a text box will be displayed at login. Entering a space-separated list of hosts will display a pull-down menu. Entering a single host will enforce using this host."
-msgstr "Ak toto pole necháte prázdne, pri prihlásení sa zobrazí textové pole. Ak zadáte zoznam strojov oddelených čiarkami, zobrazí sa roletová ponuka. Ak zadáte jeden stroj, vynúti sa použitie tohto stroja."
+msgid ""
+"If this is left blank, a text box will be displayed at login. Entering a "
+"space-separated list of hosts will display a pull-down menu. Entering a "
+"single host will enforce using this host."
+msgstr ""
+"Ak toto pole necháte prázdne, pri prihlásení sa zobrazí textové pole. Ak "
+"zadáte zoznam strojov oddelených čiarkami, zobrazí sa roletová ponuka. Ak "
+"zadáte jeden stroj, vynúti sa použitie tohto stroja."
#. Type: string
#. Description
#: ../templates:4001
-msgid "To use SSL connections, please enter host names as 'ssl://hostname:993'."
-msgstr "Aby ste mohli používať SSL spojenia, zadajte prosím názvy strojov v tvare 'ssl://nazovstroja:993'."
+msgid ""
+"To use SSL connections, please enter host names as 'ssl://hostname:993'."
+msgstr ""
+"Aby ste mohli používať SSL spojenia, zadajte prosím názvy strojov v tvare "
+"'ssl://nazovstroja:993'."
#. Type: select
#. Description
#. Type: select
#. Description
#: ../templates:5001
-msgid "However, the default language will be used for the login screen and the first connection of users."
-msgstr "Avšak štandardný jazyk sa použije na prihlasovacej obrazovke a pri prvom prihlásení používateľa."
-
+msgid ""
+"However, the default language will be used for the login screen and the "
+"first connection of users."
+msgstr ""
+"Avšak štandardný jazyk sa použije na prihlasovacej obrazovke a pri prvom "
+"prihlásení používateľa."
--- /dev/null
+# translation of roundcube.po to swedish
+# Copyright (C) YEAR THE PACKAGE'S COPYRIGHT HOLDER
+# This file is distributed under the same license as the PACKAGE package.
+#
+# Martin Bagge <brother@bsnet.se>, 2008.
+msgid ""
+msgstr ""
+"Project-Id-Version: roundcube\n"
+"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
+"PO-Revision-Date: 2008-12-15 00:54+0100\n"
+"Last-Translator: Martin Bagge <brother@bsnet.se>\n"
+"Language-Team: swedish <debian-l10n-swedish@lists.debian.org>\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"X-Generator: KBabel 1.11.4\n"
+
+#. Type: multiselect
+#. Choices
+#: ../templates:2001
+msgid "apache2"
+msgstr "apache2"
+
+#. Type: multiselect
+#. Choices
+#: ../templates:2001
+msgid "lighttpd"
+msgstr "lighttpd"
+
+#. Type: multiselect
+#. Description
+#: ../templates:2002
+msgid "Web server(s) to configure automatically:"
+msgstr "Webservrar som ska ställas in automatiskt:"
+
+#. Type: multiselect
+#. Description
+#: ../templates:2002
+msgid ""
+"RoundCube supports any web server supported by PHP, however only Apache 2 "
+"and lighttpd can be configured automatically."
+msgstr ""
+"Roundcube kan köras på alla webbservrar som stödje PHP, dock kan bara Apache "
+"2 och lighttpd ställas in automatiskt."
+
+#. Type: multiselect
+#. Description
+#: ../templates:2002
+msgid ""
+"Please select the web server(s) that should be configured automatically for "
+"RoundCube."
+msgstr ""
+"Ange den eller de webbservrar som ska ställas in automatiskt för RoundCube."
+
+#. Type: boolean
+#. Description
+#: ../templates:3001
+msgid "Should the webserver(s) be restarted now?"
+msgstr "Ska webbservern/-servrarna startas om nu?"
+
+#. Type: boolean
+#. Description
+#: ../templates:3001
+msgid ""
+"In order to activate the new configuration, the reconfigured web server(s) "
+"have to be restarted."
+msgstr "För att aktivera de nya inställningarna måste webbservern startas om."
+
+#. Type: string
+#. Description
+#: ../templates:4001
+msgid "IMAP server(s) used with RoundCube:"
+msgstr "IMAP-värd/-ar som ska användas med RoundCube:"
+
+#. Type: string
+#. Description
+#: ../templates:4001
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
+msgstr "Ange IMAP-servern som ska användas med RoundCube:"
+
+#. Type: string
+#. Description
+#: ../templates:4001
+msgid ""
+"If this is left blank, a text box will be displayed at login. Entering a "
+"space-separated list of hosts will display a pull-down menu. Entering a "
+"single host will enforce using this host."
+msgstr ""
+"Om detta fält lämnas tomt kommer en textruta att visas vid inloggningsrutan. "
+"Ange en mellanslagsseparerad lista med värdar för att visa en "
+"rullgardinsmeny. Genom att endast ange en värd kommer endast denna att kunna "
+"användas."
+
+#. Type: string
+#. Description
+#: ../templates:4001
+msgid ""
+"To use SSL connections, please enter host names as 'ssl://hostname:993'."
+msgstr ""
+"För att använda säker anslutning (SSL) ang värdnamnet i formen 'ssl://"
+"värdnamn:933'."
+
+#. Type: select
+#. Description
+#: ../templates:5001
+msgid "Default language:"
+msgstr "Standardspråk:"
+
+#. Type: select
+#. Description
+#: ../templates:5001
+msgid "Please choose the default language for RoundCube."
+msgstr "Ange standardspråk för RoundCube."
+
+#. Type: select
+#. Description
+#: ../templates:5001
+msgid "This choice can be overridden by individual users in their preferences."
+msgstr "Detta språk kan ändras för varje användare i deras egna inställingar."
+
+#. Type: select
+#. Description
+#: ../templates:5001
+msgid ""
+"However, the default language will be used for the login screen and the "
+"first connection of users."
+msgstr ""
+"Tänk på att standardspråket kommer att användas för inloggningsrutan och "
+"första gången en användare ansluter."
msgstr ""
"Project-Id-Version: roundcube 0.1-3\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: 2008-03-07 19:05+0530\n"
"Last-Translator: Dr.T.Vasudevan <agnihot3@gmail.com>\n"
"Language-Team: Tamil <ubuntu>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+#, fuzzy
+#| msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr "ரவ்ண்ட்க்யூப் உடன் பயன்படுத்த வேண்டிய ஐமாப் சேவையகம்(கங்கள்) ஐ தேர்ந்தெடுக்கவும்."
#. Type: string
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: roundcube@packages.debian.org\n"
-"POT-Creation-Date: 2008-03-05 22:12+0100\n"
+"POT-Creation-Date: 2009-02-15 17:05+0100\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
#. Type: string
#. Description
#: ../templates:4001
-msgid "Please select the IMAP server that should be used with RoundCube."
+msgid "Please select the IMAP server(s) that should be used with RoundCube."
msgstr ""
#. Type: string
case "$1" in
configure)
- # From 0.1-beta2.2 to 0.1-rc1, a column was added to table
- # `identities'. For MySQL and PostgreSQL, this is handled by
- # dbconfig-common but for sqlite, there is no way to add a
- # column to a table. Therefore, we dump here the table and add
- # the column.
- [ "$dbc_upgrade" = "true" ] && {
- case "$dbc_dbtype" in
- sqlite)
- db="${dbc_basepath}/${dbc_dbname}"
- # OK, we need to check if the table contains html_signature
- if ! sqlite "$db" '.schema identities' | grep -q html_signature; then
- # We need to add it
- echo -n "Need to upgrade 'identities' table in $db... "
- upgrade_tmp=$(mktemp -t roundcube.sqlite.XXXXXXXXXX)
- (
- cat <<EOF
-BEGIN TRANSACTION;
-DROP TABLE identities;
-CREATE TABLE identities (
- identity_id integer NOT NULL PRIMARY KEY,
- user_id integer NOT NULL default '0',
- del tinyint NOT NULL default '0',
- standard tinyint NOT NULL default '0',
- name varchar(128) NOT NULL default '',
- organization varchar(128) default '',
- email varchar(128) NOT NULL default '',
- "reply-to" varchar(128) NOT NULL default '',
- bcc varchar(128) NOT NULL default '',
- signature text NOT NULL default '',
- html_signature tinyint NOT NULL default '0'
-);
-
-CREATE INDEX ix_identities_user_id ON identities(user_id);
-
-EOF
- # We dump and keep only inserts
- sqlite "$db" '.dump identities' | \
- awk '/^INSERT INTO/ {start = 1} {if (start == 1) print}' | \
- head -n -2 | \
- sed 's/^\(INSERT INTO identities \)/\1(identity_id, user_id, del, standard, name, organization, email, "reply-to", bcc, signature) /'
- echo 'COMMIT;' ) > $upgrade_tmp
- sqlite "$db" < $upgrade_tmp
- rm $upgrade_tmp
- echo "OK"
- fi
- ;;
- *)
- # Do nothing
- ;;
- esac
- }
-
CONFFILE=/etc/roundcube/main.inc.php
touch $CONFFILE.ucftmp
chmod 640 $CONFFILE.ucftmp
install -m 0644 $(CURDIR)/SQL/mysql.initial.sql $(CURDIR)/debian/roundcube-core/usr/share/dbconfig-common/data/roundcube/install/mysql
install -m 0644 $(CURDIR)/SQL/postgres.initial.sql $(CURDIR)/debian/roundcube-core/usr/share/dbconfig-common/data/roundcube/install/pgsql
install -m 0644 $(CURDIR)/SQL/sqlite.initial.sql $(CURDIR)/debian/roundcube-core/usr/share/dbconfig-common/data/roundcube/install/sqlite
- # Database upgrade from latest versions
- install -m 0644 $(CURDIR)/SQL/postgres.update.sql $(CURDIR)/debian/roundcube-core/usr/share/dbconfig-common/data/roundcube/upgrade/pgsql/0.1.1-1
- install -m 0644 $(CURDIR)/SQL/mysql.update.sql $(CURDIR)/debian/roundcube-core/usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.1.1-1
- install -m 0644 $(CURDIR)/SQL/sqlite.update.sql $(CURDIR)/debian/roundcube-core/usr/share/dbconfig-common/data/roundcube/upgrade/sqlite/0.1.1-1
# Old database upgrades
cp -r $(CURDIR)/debian/sql/* $(CURDIR)/debian/roundcube-core/usr/share/dbconfig-common/data/roundcube/upgrade/.
--- /dev/null
+-- RoundCube Webmail update script for MySQL databases
+-- Updates from version 0.1-stable to 0.1.1
+
+TRUNCATE TABLE `messages`;
+
+ALTER TABLE `messages`
+ DROP INDEX `idx`,
+ DROP INDEX `uid`;
+
+ALTER TABLE `cache`
+ DROP INDEX `cache_key`,
+ DROP INDEX `session_id`,
+ ADD INDEX `user_cache_index` (`user_id`,`cache_key`);
+
+ALTER TABLE `users`
+ ADD INDEX `username_index` (`username`),
+ ADD INDEX `alias_index` (`alias`);
--- /dev/null
+-- Updates from version 0.1.1
+
+ALTER TABLE `identities`
+ MODIFY `signature` text,
+ MODIFY `bcc` varchar(128) NOT NULL DEFAULT '',
+ MODIFY `reply-to` varchar(128) NOT NULL DEFAULT '',
+ MODIFY `organization` varchar(128) NOT NULL DEFAULT '',
+ MODIFY `name` varchar(128) NOT NULL,
+ MODIFY `email` varchar(128) NOT NULL;
+
--- /dev/null
+-- Updates from version 0.2-alpha
+
+ALTER TABLE `messages`
+ ADD INDEX `created_index` (`created`);
+
+-- Updates from version 0.2-beta (InnoDB only)
+
+ALTER TABLE `cache`
+ DROP `session_id`;
+
+ALTER TABLE `session`
+ ADD INDEX `changed_index` (`changed`);
+
+ALTER TABLE `cache`
+ ADD INDEX `created_index` (`created`);
+
+ALTER TABLE `users`
+ CHANGE `language` `language` varchar(5);
--- /dev/null
+-- RoundCube Webmail update script for Postgres databases
+-- Updates from version 0.1-stable to 0.1.1
+
+CREATE INDEX cache_user_id_idx ON cache (user_id, cache_key);
+CREATE INDEX contacts_user_id_idx ON contacts (user_id);
+CREATE INDEX identities_user_id_idx ON identities (user_id);
+
+CREATE INDEX users_username_id_idx ON users (username);
+CREATE INDEX users_alias_id_idx ON users (alias);
+
+-- added ON DELETE/UPDATE actions
+ALTER TABLE messages DROP CONSTRAINT messages_user_id_fkey;
+ALTER TABLE messages ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE identities DROP CONSTRAINT identities_user_id_fkey;
+ALTER TABLE identities ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE contacts DROP CONSTRAINT contacts_user_id_fkey;
+ALTER TABLE contacts ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE cache DROP CONSTRAINT cache_user_id_fkey;
+ALTER TABLE cache ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
+
--- /dev/null
+-- Updates from version 0.2-alpha
+
+CREATE INDEX messages_created_idx ON messages (created);
+
+-- Updates from version 0.2-beta
+
+ALTER TABLE cache DROP session_id;
+
+CREATE INDEX session_changed_idx ON session (changed);
+CREATE INDEX cache_created_idx ON "cache" (created);
+
+ALTER TABLE users ALTER "language" DROP NOT NULL;
+ALTER TABLE users ALTER "language" DROP DEFAULT;
+
+ALTER TABLE identities ALTER del TYPE smallint;
+ALTER TABLE identities ALTER standard TYPE smallint;
+ALTER TABLE contacts ALTER del TYPE smallint;
+ALTER TABLE messages ALTER del TYPE smallint;
--- /dev/null
+-- RoundCube Webmail update script for SQLite databases
+-- Updates from version 0.1-stable to 0.1.1
+
+DROP TABLE messages;
+
+CREATE TABLE messages (
+ message_id integer NOT NULL PRIMARY KEY,
+ user_id integer NOT NULL default '0',
+ del tinyint NOT NULL default '0',
+ cache_key varchar(128) NOT NULL default '',
+ created datetime NOT NULL default '0000-00-00 00:00:00',
+ idx integer NOT NULL default '0',
+ uid integer NOT NULL default '0',
+ subject varchar(255) NOT NULL default '',
+ "from" varchar(255) NOT NULL default '',
+ "to" varchar(255) NOT NULL default '',
+ "cc" varchar(255) NOT NULL default '',
+ "date" datetime NOT NULL default '0000-00-00 00:00:00',
+ size integer NOT NULL default '0',
+ headers text NOT NULL,
+ structure text
+);
+
+CREATE INDEX ix_messages_user_cache_uid ON messages(user_id,cache_key,uid);
+
+CREATE INDEX ix_users_username ON users(username);
+CREATE INDEX ix_users_alias ON users(alias);
+
--- /dev/null
+-- Updates from version 0.2-alpha
+
+CREATE INDEX ix_messages_created ON messages (created);
+
+-- Updates from version 0.2-beta
+
+CREATE INDEX ix_session_changed ON session (changed);
+CREATE INDEX ix_cache_created ON cache (created);
Type: string
Default:
_Description: IMAP server(s) used with RoundCube:
- Please select the IMAP server that should be used with RoundCube.
+ Please select the IMAP server(s) that should be used with RoundCube.
.
If this is left blank, a text box will be displayed at
login. Entering a space-separated list of hosts will display a