Users

users@lists.roundcube.net

5 participants
2944 discussions

IMAP support for sort criteria
by Henrik Maaß 29 May '14

29 May '14

Dear all, I want to sort my mails by size, in the old roundcube version it worked without problems, now it seems, that the IMAP server doesn't support the new command. I only use Roundcube online, usually I work with thunderbird and its still working there. I do not know what IMAP server software is used for my system and I do not know how to get to know about it. Who could tell me, what to do now? Thank you, Henrik Am 27.05.2014 17:48, schrieb Thomas Bruederli: > Hello Henrik > > Thanks for your feedback! Sorting by size generally works but it > requires support from the IMAP server. Roundcube sends the IMAP > command "UID SORT (SIZE) US-ASCII ALL" to fetch the messages headers > for listing. Do you know what IMAP server software is used for your > system? It's possible that it one doesn't support this sort criteria > and falls back to arrival date. > > For further questions, please subscribe and post to our users mailing > list: http://lists.roundcube.net > > Kind regards, > Thomas > > > > On Tue, May 27, 2014 at 4:12 PM, Henrik Maaß <maass(a)abl-ev.de> wrote: >> Dear all, >> >> thank you for your work of creating a new version of Roundcube. I already >> have expirienced some helpfull features already. >> >> Maybe you know already, that sorting by size doesn't work yet in this new >> version I use through https://webmail.webspaceconfig.de/ >> >> If I try to sort it by size, the mails are still sorted by date anyhow. >> I hope, this was useful for you. >> >> Ciao, Henrik >> >> -- >> Henrik Maaß >> Weinbergstr. 6 >> 37217 Witzenhausen >> 05542 500267 >> 0160 8217015 >> >> www.abl-ev.de/junge-abl (Junge Arbeitsgemeinschaft bäuerliche >> Landwirtschaft) >> >> www.goodfoodgoodfarming.eu (Kampagne für eine ökologisch-soziale >> Agrarpolitik) >> >> www.nyelenieurope.net (Bewegung für Ernährungssouveränität) >> -- Henrik Maaß Weinbergstr. 6 37217 Witzenhausen 05542 500267 0160 8217015 www.abl-ev.de/junge-abl (Junge Arbeitsgemeinschaft bäuerliche Landwirtschaft) www.goodfoodgoodfarming.eu (Kampagne für eine ökologisch-soziale Agrarpolitik) www.nyelenieurope.net (Bewegung für Ernährungssouveränität)

3 3

idle_timeout plugin
by Valentina Dondi 28 May '14

28 May '14

Hi, I have installed roundcube 1.0 on ubuntu server 12.04 and then I've added plugin manager and idle timeout plugin. I have configured the idle timeout plugin following the guide but it doesn't work; is that a known issue? And how can I solve this problem? Thanks Valentina valentina dondi | system administrator vdondi(a)enter.it | +39 02 25514 | | fax +39 02 25514 303 [cid:753d36d1ac564a40a5204314116d6705] enter | internet service provider via stefanardo da vimercate 28 | 20128 Milano tel +39 02 25514 300 [Cloudup]<http://www.openstackday.it/>

1 0

Re: [RCU] Attaching files is not working for me, what am I missing?
by Ralph Seichter 27 May '14

27 May '14

On 27.05.14 20:15, Reindl Harald wrote: > your *webserver* is unstable and *crashs* Yes, I can see that a process terminates unexpectedly. I am trying to figure out why that is. > that is *not* a roundcube problem as you can see Errors like the one I reported only occur in combination with Roundcube so far, so I asked how to better debug this. I am not trying to pass blame. I'd be happy if it was just me having messed up some settings or suchlike. That would make things much easier. > suhosin.session.encrypt: OK > don't do that! I did not. Gentoo masks dev-php/suhosin for all PHP versions > 5.3, and Suhosin is not installed here. That I verified, and I do not know why Roundcube reports otherwise. Incidentally, the Roundcube installer lists suhosin.session.encrypt in a section "The following settings are required to run Roundcube". > what PHP version? > what distribution? As stated in my original mail, PHP 5.5.12 on Gentoo Linux (with a Kernel 3.14.3 to be precise, I can list specific library versions on request). > what extensions are loaded? > bytecode-cacxhe? which? with what configuration? The only active extension seems to be Zend OPcache v7.0.4-dev, at least from what I can see. > GET RID OF SUHOSIN ON RECENT PHP You have been keeping up that friendly tone of yours for years now, and still you have not had an infarction? You're a lucky guy. ;-) -R

1 0

Attaching files is not working for me, what am I missing?
by Ralph Seichter 27 May '14

27 May '14

Hello list, I can't seem to get attaching files to work (Roundcube 1.0.1, Gentoo Linux, Apache 2.4.9, PHP 5.5.12). Whenever I click "attach a file", select a file and then click "upload", Apache logs messages like these: [core:notice] [pid 9155:tid 140489408571264] AH00052: child pid 9482 exit signal Aborted (6) [core:notice] [pid 9155:tid 140489408571264] AH00052: child pid 9493 exit signal Aborted (6) *** Error in `/usr/sbin/apache2': free(): invalid pointer: 0x00007fc60035f9a8 *** I made sure that $config['temp_dir'] points to a directory writeable by the Apache user. PHP settings ensure that file uploads are allowed. Roundcube reports file_uploads: OK session.auto_start: OK zend.ze1_compatibility_mode: OK mbstring.func_overload: OK suhosin.session.encrypt: OK magic_quotes_runtime: OK magic_quotes_sybase: OK I wonder how to better debug this problem to figure out what I am doing wrong here. Can you guys help me with this? -R

1 0

Re: [RCU] users Digest, Vol 83, Issue 11
by Ricardo Adolfo Sánchez Arboleda 27 May '14

27 May '14

Thanks for answering Timo [...] Ip.xxx.xxx.xxx / webmail / installer / index.php? _Step = 3 SMTP Sender: rasa996412(a)gmail.com IMAP Server: gmail.com Port: 143 I can only send mail to my gmail account and what I need is to receive and / or send to my domain name; well: ricardoasa(a)ingenierasa.org ::: Kev change this IMAP :::::: $ Rcmail_config ['default_host'] = 'ssl :/ / imap.gmail.com: 993'; / / TCP port connections used for IMAP $ Rcmail_config ['default_port'] = 143; by $ rcmail_config ['default_host'] = 'ssl :/ / imap.gmail.com'; / / TCP port connections used for IMAP $ rcmail_config ['default_port'] = 993; Unchanged, send email. But if I send mail to this account ricardoasa(a)ingenierasa.org having my domain name. Not receive ..? Note: what I want is that my server allows WebmailRoundcube receive mail with this account ricardoasa(a)ingenierasa.org *Saludes;* rasa. 2014-05-26 5:00 GMT-05:00 <users-request(a)lists.roundcube.net>: > Send users mailing list submissions to > users(a)lists.roundcube.net > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.roundcube.net/mailman/listinfo/users > or, via email, send a message with subject or body 'help' to > users-request(a)lists.roundcube.net > > You can reach the person managing the list at > users-owner(a)lists.roundcube.net > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of users digest..." > > > Today's Topics: > > 1. Re: Order of folders cluttered (A.L.E.C) > 2. I do not receive mail (Ricardo Adolfo S?nchez Arboleda) > 3. Re: I do not receive mail (Timo Brandt) > 4. Re: I do not receive mail (kev(a)xithing.com) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 25 May 2014 12:07:26 +0200 > From: "A.L.E.C" <alec(a)alec.pl> > To: users(a)lists.roundcube.net > Subject: Re: [RCU] Order of folders cluttered > Message-ID: <5381C0DE.6090706(a)alec.pl> > Content-Type: text/plain; charset=UTF-8 > > On 05/23/2014 10:33 PM, Michael Heydekamp wrote: >> I don't know how that happened, but all of a sudden the order my mail >> folders is totally f*cked up (e.g. the Trash folder being the very last of >> all folders rather than one of the special folders at the top of the folder >> list). >> >> Because of this incident I realized that I don't know if and how to change >> the order of folders at all (apart from manually fiddling around with >> settings in the database). > > Git-master? That might be related to > https://github.com/roundcube/roundcubemail/commit/693612d396ede5c7ed8dc36e7… > but it works for me. What operating system? What PHP version? What UI > language (locale)? > > -- > Aleksander 'A.L.E.C' Machniak > LAN Management System Developer [http://lms.org.pl] > Roundcube Webmail Developer [http://roundcube.net] > --------------------------------------------------- > PGP: 19359DC1 @@ GG: 2275252 @@ WWW: http://alec.pl > > > ------------------------------ > > Message: 2 > Date: Sun, 25 May 2014 16:11:44 -0500 > From: Ricardo Adolfo S?nchez Arboleda <rasa996412(a)gmail.com> > To: users(a)lists.roundcube.net > Subject: [RCU] I do not receive mail > Message-ID: > <CAE=ryQ_=CkNmQkkA_A2OxmKct+mOiaG92odPk6unaGdUegFDqg(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > In Debian Wheezy more Roundcube Webmail 0.9.5 installed I ; these identities : > This ricardoasa(a)ingenierasa.org account that has my domain name I can > send email, but not receive . > get error : > Subject Delivery Status Notification ( Failure) > SubsystemAdd contact sender Mail Delivery > Recipient rasa996412(a)gmail.comAdd contact > Date Today 15:12 > > Delivery to the following recipient failed permanently : > > ricardoasa(a)ingenierasa.org > > Technical details of permanent failure: > Google tried to deliver your message , but it was rejected by the > server for the recipient domain ingenierasa.org by ingenierasa.org . [ > 190,146,204,168 ] . > > The Error That the other server returned was: > <ricardoasa(a)ingenierasa.org> 554 5.7.1 : Relay access denied > > ----- Original message ----- > > DKIM -Signature : v = 1; a = rsa- sha256 ; c = relaxed / relaxed ; > d = gmail.com ; s = 20120113 ; > h = mime -version : date : message -id : subject: from: to: > content -type ; > bh = oC/TZVePwdcItXZup20dZLw4pOkA6HJIdqgNqLFqh6w = ; > b = 098peNl8crbovGenvQtRD0gvdxVFPnjShnnDeXHELDecTsP8GcwRIx1WkpJ7WxjnbM > lFGSoLtDbPbSpmStHTZBBwThk12jN7q4Oy +2 ba4N0Q6THEbbQdk4d0pXF3f6lBCjwHKf > nTsAk1Xs7xL +8 + n + xikECQSpTSMla56 > FYgX1pnIVfXiKOj7D5Flee95H8noFyfuyq7ca > 5p8g5/afC0dXbVYcAEnIFSwEyiZs8xVSsgu1rbOslIiZY8e5s + XHBXHelyANKKbR3K5v > pF1Gp1XYn3NINkxJqG1Mag7uRsvrNlWLX2JkLWI0 + ZrYtdFcii83gZVf2u48FM35EHzs > vRwA == > MIME -Version: 1.0 > X - Received : by 10.182.158.73 with SMTP id ws9mr15830603obb.14.1401048753762 ; > Sun , 25 May 2014 13:12:33 -0700 (PDT ) > Received : by 10.182.199.97 with HTTP; Sun , 25 May 2014 13:12:33 -0700 (PDT ) > Date: Sun , 25 May 2014 15:12:33 -0500 > Message- ID : <CAE=ryQ8F0gOvvVgAWsLs=GJSBN_q8tNFXJ0OLFHAE+3jdURSJw(a)mail.gmail.com> > Subject : test2 > >From : ? = ISO- 8859-1 Q = Ricardo_Adolfo_S E1nchez_Arboleda = > <rasa996412(a)gmail.com> ? > To : ? = ISO- 8859-1 Q = ricardo_adolfo_s E1nchez_arboleda = > <ricardoasa(a)ingenierasa.org> ? > Content- Type : text / plain ; charset = ISO- 8859-1 > IMAP ::: ::: > $ rcmail_config [' default_host '] = ' ssl :/ / imap.gmail.com : 993 '; > / / TCP port connections used for IMAP > $ rcmail_config [' default_port '] = 143; > SMTP ::: ::: > $ rcmail_config [' smtp_server '] =''; > / / SMTP port (default is 25 , use 587 or 465 for STARTTLS for the > / / Deprecated SMTP over SSL (aka SMTPS ) ) > $ rcmail_config [' smtp_port '] = 25 ; > > [ ... ] Edit where to send and receive mail with my domain name and > avoid this error. > > Thank you, > > > *Saludes;* > > rasa. > > > ------------------------------ > > Message: 3 > Date: Sun, 25 May 2014 23:21:27 +0200 > From: Timo Brandt <mail(a)timo-brandt.de> > To: Roundcube Users mailing list <users(a)lists.roundcube.net> > Subject: Re: [RCU] I do not receive mail > Message-ID: > <ae50b1a7-7c97-4c32-be5b-d35f0dea8411(a)katmail.1gravity.com> > Content-Type: text/plain; charset="utf-8" > > Its a configuration problem with your Mailserver. It tells you, that this email was rejected because you using a mail relay. > > Which mailserver did you use? > > Timo > > > > ---------------------- > Timo Brandt > Postfach 1115 > 37615 Bodenwerder > > Hausanschrift: > Timo Brandt > Unter der Alpke 2 > 37619 Bodenwerder > > Tel.: 05533/938103 (18-22 Uhr) > Fax.:05533/9381039 > Mobil: 0162/2475066 (05-22 Uhr) > eMail: mail(a)timo-brandt.de > > Skype: timo.brandt > ICQ: 307603660 > > > -------- Original-Nachricht -------- > Von: "Ricardo Adolfo S?nchez Arboleda" <rasa996412(a)gmail.com> > Gesendet: Sun May 25 23:11:44 MESZ 2014 > An: users(a)lists.roundcube.net > Betreff: [RCU] I do not receive mail > > In Debian Wheezy more Roundcube Webmail 0.9.5 installed I ; these identities : > This ricardoasa(a)ingenierasa.org account that has my domain name I can > send email, but not receive . > get error : > Subject Delivery Status Notification ( Failure) > SubsystemAdd contact sender Mail Delivery > Recipient rasa996412(a)gmail.comAdd contact > Date Today 15:12 > > Delivery to the following recipient failed permanently : > > ricardoasa(a)ingenierasa.org > > Technical details of permanent failure: > Google tried to deliver your message , but it was rejected by the > server for the recipient domain ingenierasa.org by ingenierasa.org . [ > 190,146,204,168 ] . > > The Error That the other server returned was: > <ricardoasa(a)ingenierasa.org> 554 5.7.1 : Relay access denied > > ----- Original message ----- > > DKIM -Signature : v = 1; a = rsa- sha256 ; c = relaxed / relaxed ; > d = gmail.com ; s = 20120113 ; > h = mime -version : date : message -id : subject: from: to: > content -type ; > bh = oC/TZVePwdcItXZup20dZLw4pOkA6HJIdqgNqLFqh6w = ; > b = 098peNl8crbovGenvQtRD0gvdxVFPnjShnnDeXHELDecTsP8GcwRIx1WkpJ7WxjnbM > lFGSoLtDbPbSpmStHTZBBwThk12jN7q4Oy +2 ba4N0Q6THEbbQdk4d0pXF3f6lBCjwHKf > nTsAk1Xs7xL +8 + n + xikECQSpTSMla56 > FYgX1pnIVfXiKOj7D5Flee95H8noFyfuyq7ca > 5p8g5/afC0dXbVYcAEnIFSwEyiZs8xVSsgu1rbOslIiZY8e5s + XHBXHelyANKKbR3K5v > pF1Gp1XYn3NINkxJqG1Mag7uRsvrNlWLX2JkLWI0 + ZrYtdFcii83gZVf2u48FM35EHzs > vRwA == > MIME -Version: 1.0 > X - Received : by 10.182.158.73 with SMTP id ws9mr15830603obb.14.1401048753762 ; > Sun , 25 May 2014 13:12:33 -0700 (PDT ) > Received : by 10.182.199.97 with HTTP; Sun , 25 May 2014 13:12:33 -0700 (PDT ) > Date: Sun , 25 May 2014 15:12:33 -0500 > Message- ID : <CAE=ryQ8F0gOvvVgAWsLs=GJSBN_q8tNFXJ0OLFHAE+3jdURSJw(a)mail.gmail.com> > Subject : test2 > >From : ? = ISO- 8859-1 Q = Ricardo_Adolfo_S E1nchez_Arboleda = > <rasa996412(a)gmail.com> ? > To : ? = ISO- 8859-1 Q = ricardo_adolfo_s E1nchez_arboleda = > <ricardoasa(a)ingenierasa.org> ? > Content- Type : text / plain ; charset = ISO- 8859-1 > IMAP ::: ::: > $ rcmail_config [' default_host '] = ' ssl :/ / imap.gmail.com : 993 '; > / / TCP port connections used for IMAP > $ rcmail_config [' default_port '] = 143; > SMTP ::: ::: > $ rcmail_config [' smtp_server '] =''; > / / SMTP port (default is 25 , use 587 or 465 for STARTTLS for the > / / Deprecated SMTP over SSL (aka SMTPS ) ) > $ rcmail_config [' smtp_port '] = 25 ; > > [ ... ] Edit where to send and receive mail with my domain name and > avoid this error. > > Thank you, > > > *Saludes;* > > rasa. > _______________________________________________ > Roundcube Users mailing list > users(a)lists.roundcube.net > http://lists.roundcube.net/mailman/listinfo/users >

1 0

I do not receive mail
by Ricardo Adolfo Sánchez Arboleda 26 May '14

26 May '14

In Debian Wheezy more Roundcube Webmail 0.9.5 installed I ; these identities : This ricardoasa(a)ingenierasa.org account that has my domain name I can send email, but not receive . get error : Subject Delivery Status Notification ( Failure) SubsystemAdd contact sender Mail Delivery Recipient rasa996412(a)gmail.comAdd contact Date Today 15:12 Delivery to the following recipient failed permanently : ricardoasa(a)ingenierasa.org Technical details of permanent failure: Google tried to deliver your message , but it was rejected by the server for the recipient domain ingenierasa.org by ingenierasa.org . [ 190,146,204,168 ] . The Error That the other server returned was: <ricardoasa(a)ingenierasa.org> 554 5.7.1 : Relay access denied ----- Original message ----- DKIM -Signature : v = 1; a = rsa- sha256 ; c = relaxed / relaxed ; d = gmail.com ; s = 20120113 ; h = mime -version : date : message -id : subject: from: to: content -type ; bh = oC/TZVePwdcItXZup20dZLw4pOkA6HJIdqgNqLFqh6w = ; b = 098peNl8crbovGenvQtRD0gvdxVFPnjShnnDeXHELDecTsP8GcwRIx1WkpJ7WxjnbM lFGSoLtDbPbSpmStHTZBBwThk12jN7q4Oy +2 ba4N0Q6THEbbQdk4d0pXF3f6lBCjwHKf nTsAk1Xs7xL +8 + n + xikECQSpTSMla56 FYgX1pnIVfXiKOj7D5Flee95H8noFyfuyq7ca 5p8g5/afC0dXbVYcAEnIFSwEyiZs8xVSsgu1rbOslIiZY8e5s + XHBXHelyANKKbR3K5v pF1Gp1XYn3NINkxJqG1Mag7uRsvrNlWLX2JkLWI0 + ZrYtdFcii83gZVf2u48FM35EHzs vRwA == MIME -Version: 1.0 X - Received : by 10.182.158.73 with SMTP id ws9mr15830603obb.14.1401048753762 ; Sun , 25 May 2014 13:12:33 -0700 (PDT ) Received : by 10.182.199.97 with HTTP; Sun , 25 May 2014 13:12:33 -0700 (PDT ) Date: Sun , 25 May 2014 15:12:33 -0500 Message- ID : <CAE=ryQ8F0gOvvVgAWsLs=GJSBN_q8tNFXJ0OLFHAE+3jdURSJw(a)mail.gmail.com> Subject : test2 >From : ? = ISO- 8859-1 Q = Ricardo_Adolfo_S E1nchez_Arboleda = <rasa996412(a)gmail.com> ? To : ? = ISO- 8859-1 Q = ricardo_adolfo_s E1nchez_arboleda = <ricardoasa(a)ingenierasa.org> ? Content- Type : text / plain ; charset = ISO- 8859-1 IMAP ::: ::: $ rcmail_config [' default_host '] = ' ssl :/ / imap.gmail.com : 993 '; / / TCP port connections used for IMAP $ rcmail_config [' default_port '] = 143; SMTP ::: ::: $ rcmail_config [' smtp_server '] =''; / / SMTP port (default is 25 , use 587 or 465 for STARTTLS for the / / Deprecated SMTP over SSL (aka SMTPS ) ) $ rcmail_config [' smtp_port '] = 25 ; [ ... ] Edit where to send and receive mail with my domain name and avoid this error. Thank you, *Saludes;* rasa.

3 2

Update 1.0.1 out now
by Thomas Bruederli 23 May '14

23 May '14

Dear Roundcube users We can proudly announce the first service release to update the stable version 1.0 of Roundcube webmail. It contains some important bug fixes and improvements, primarily a fix for the unintentional redirect from the compose page in Google Chrome which likely started to appear after a recent Chrome update. It's considered stable and we recommend to update all productive installations of Roundcube with this version. Download it from http://roundcube.net/download, see the full changelog here: http://trac.roundcube.net/wiki/Changelog Please note that the update includes a small MySQL database schema change, thus make sure you run the update script. Kind regards, Thomas

5 6

Plugin password error - driver chpasswd
by Daniel Lopez 23 May '14

23 May '14

Hello, I Install roundcubemail using EPEL repository: # wget http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm # rpm -ivh epel-release-6-8.noarch.rpm # yum install roundcubemail I have the following settings: CentOS 6.4 Apache 2.2.15 PHP 5.3.3 MySQL 5.1.69 Roundcube Webmail 0.9.5 Plugin password 3.2 Users are not saved in the database, are stored in the operating system: /etc/passwd /etc/shadow cat /etc/roundcubemail/main.inc.php $rcmail_config['default_host'] = 'domain.com'; $rcmail_config['plugins'] = array(password); cat /usr/share/roundcubemail/plugins/password/config.inc.php $rcmail_config['password_driver'] = 'chpasswd'; cat /etc/sudoers apache ALL=NOPASSWD: /usr/sbin/chpasswd When I try to save the password change displays the message: an error has occurred, it can not save the new password cat /var/log/roundcubemail/errors PHP Error: Password plugin: Unable to execute sudo /usr/sbin/chpasswd 2> /dev/null in /usr/share/roundcubemail/plugins/password/drivers/chpasswd.php on line 32 (POST /mail/?_task=settings&_action=plugin.password-save?_task=&_action=) please help to find the error Daniel Lopez

1 0

Re: [RCU] Testing Roundcube 1.0.x
by Steve Perkins 22 May '14

22 May '14

Surely the whole point about a test/staging system is any glitches won't impact on the production system. Mixing them the way you suggest would mean any problems with the test system would also impact the live one. Would this not be self defeating ? Sent from MyPhone David Carter <dpc22(a)cam.ac.uk> wrote: >We expect to upgrade from Roundcube 0.9.5 to 1.0.x over the summer >vacation (my management chain and I prefer not to make substantial >changes during the academic year). > >Something that I would like to do if possible is have a period of >parallel running so that people can kick the tires and make sure that >our small collection of local plugins and our local skin are working >correctly for a few days or weeks before we commit to running the new >version. > >I can of course dump and restore the existing Roundcube database to >build a completely independent Roundcube 1.0.1 test system off to one >side, away from the production servers. > >However if I look at the handful of database upgrade steps from 0.9.5 to >1.0.1, the only significant change would appear to be the attached >renaming of sequences (we aren't using any of the cache tables). > > .../SQL/postgres/2013042700.sql : > > ALTER SEQUENCE user_ids RENAME TO users_seq; > ALTER TABLE users ALTER COLUMN user_id SET DEFAULT >nextval('users_seq'::text); > > ALTER SEQUENCE identity_ids RENAME TO identities_seq; > ALTER TABLE identities ALTER COLUMN identity_id SET DEFAULT >nextval('identities_seq'::text); > > ALTER SEQUENCE contact_ids RENAME TO contacts_seq; > ALTER TABLE contacts ALTER COLUMN contact_id SET DEFAULT >nextval('contacts_seq'::text); > > ALTER SEQUENCE contactgroups_ids RENAME TO contactgroups_seq; > ALTER TABLE contactgroups ALTER COLUMN contactgroup_id SET DEFAULT >nextval('contactgroups_seq'::text); > > ALTER SEQUENCE search_ids RENAME TO searches_seq; > ALTER TABLE searches ALTER COLUMN search_id SET DEFAULT >nextval('searches_seq'::text); > >These sequence names appear to be hard-wired in 1.0.1. > >However Roundcube 0.9.5 can be reconfigured to use any names, including >the names used by 1.0.1: > > // you can define specific sequence names used in PostgreSQL > $rcmail_config['db_sequence_users'] = 'users_seq'; > $rcmail_config['db_sequence_identities'] = 'identities_seq'; > $rcmail_config['db_sequence_contacts'] = 'contacts_seq'; > $rcmail_config['db_sequence_contactgroups'] = 'contactgroups_seq'; > $rcmail_config['db_sequence_searches'] = 'searches_seq'; > >A brief experiment on a test system suggests that I can safely switch >back and forth between Roundcube 0.9.5 and 1.0.1 with this single >configuration change at the 0.9.5 end. > >My question is whether this is a sensible thing to try and do. Are there >incompatible changes in the various preferences databases which aren't >reflected in the database schema? That would require an independent test >system. > >Thanks, > >-- >David Carter Email: >David.Carter(a)uis.cam.ac.uk >University of Cambridge, Phone: (01223) 334502 >Information Services, Fax: (01223) 334679 >7 J J Thomson Avenue, >Cambridge UK. CB3 0RB > >_______________________________________________ >Roundcube Users mailing list >users(a)lists.roundcube.net >http://lists.roundcube.net/mailman/listinfo/users

2 1

Testing Roundcube 1.0.x
by David Carter 22 May '14

22 May '14

We expect to upgrade from Roundcube 0.9.5 to 1.0.x over the summer vacation (my management chain and I prefer not to make substantial changes during the academic year). Something that I would like to do if possible is have a period of parallel running so that people can kick the tires and make sure that our small collection of local plugins and our local skin are working correctly for a few days or weeks before we commit to running the new version. I can of course dump and restore the existing Roundcube database to build a completely independent Roundcube 1.0.1 test system off to one side, away from the production servers. However if I look at the handful of database upgrade steps from 0.9.5 to 1.0.1, the only significant change would appear to be the attached renaming of sequences (we aren't using any of the cache tables). .../SQL/postgres/2013042700.sql : ALTER SEQUENCE user_ids RENAME TO users_seq; ALTER TABLE users ALTER COLUMN user_id SET DEFAULT nextval('users_seq'::text); ALTER SEQUENCE identity_ids RENAME TO identities_seq; ALTER TABLE identities ALTER COLUMN identity_id SET DEFAULT nextval('identities_seq'::text); ALTER SEQUENCE contact_ids RENAME TO contacts_seq; ALTER TABLE contacts ALTER COLUMN contact_id SET DEFAULT nextval('contacts_seq'::text); ALTER SEQUENCE contactgroups_ids RENAME TO contactgroups_seq; ALTER TABLE contactgroups ALTER COLUMN contactgroup_id SET DEFAULT nextval('contactgroups_seq'::text); ALTER SEQUENCE search_ids RENAME TO searches_seq; ALTER TABLE searches ALTER COLUMN search_id SET DEFAULT nextval('searches_seq'::text); These sequence names appear to be hard-wired in 1.0.1. However Roundcube 0.9.5 can be reconfigured to use any names, including the names used by 1.0.1: // you can define specific sequence names used in PostgreSQL $rcmail_config['db_sequence_users'] = 'users_seq'; $rcmail_config['db_sequence_identities'] = 'identities_seq'; $rcmail_config['db_sequence_contacts'] = 'contacts_seq'; $rcmail_config['db_sequence_contactgroups'] = 'contactgroups_seq'; $rcmail_config['db_sequence_searches'] = 'searches_seq'; A brief experiment on a test system suggests that I can safely switch back and forth between Roundcube 0.9.5 and 1.0.1 with this single configuration change at the 0.9.5 end. My question is whether this is a sensible thing to try and do. Are there incompatible changes in the various preferences databases which aren't reflected in the database schema? That would require an independent test system. Thanks, -- David Carter Email: David.Carter(a)uis.cam.ac.uk University of Cambridge, Phone: (01223) 334502 Information Services, Fax: (01223) 334679 7 J J Thomson Avenue, Cambridge UK. CB3 0RB

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Users