Dev

dev@lists.roundcube.net

4292 discussions

plugin install with SQL and database prefix
by Sébastien BLAISOT 05 Jan '20

05 Jan '20

Hi dear roundcube community, First of all, I wish you all a happy new year. I am the maintainer of the automatic_addressbook plugin (or at least I used to be, as I don't have much time for it now, and I would be happy to have it integrated in roundcube default plugins if you want, but that's an other story) . I regularly get issues from users regarding database prefix when installing the plugin. I understand this is complicated to handle when installing manually, but it seems to also be the case when using composer (At least I got reports about failed SQL statements when installing with composer) As far as I can see, SQL statements in roundcube codebase have no prefix, as my sql statements in my plugin. How are database prefix handled when installing roundcube? How are they handled when installing a plugin with composer? (ok, I found how, see below) I have 2 concerns: - One is table creation (CREATE TABLE statements), on which prefix should added. Is that handled automatically by composer? (It seems to be the case) - The second one is foreign keys that reference roundcube standard tables like REFERENCES `users`(`user_id`) which should be changed to REFERENCES `PREFIX_users`(`user_id`). Is that automatically handled by composer at plugin installation? (It seems to be the missing one) Is there any documentation for plugin coders on how to properly handle plugins databases with references to standard roundcube databases regarding database prefix? As far as I can see here: https://github.com/roundcube/plugin-installer/blob/0.1.6/src/bin/rcubeinitd… This problem is already handled for CREATE DATABASE statements and for CREATE SEQUENCE statements but not for REFERENCES statements as used in the automatic_addressbook plugin here: - https://github.com/sblaisot/automatic_addressbook/blob/master/SQL/mysql.ini… - https://github.com/sblaisot/automatic_addressbook/blob/master/SQL/postgres.… I should be able to propose a PR on plugin_installer for that. Is there something more I need to be aware of before coding? Best regards and keep making such a good webmail! Sebastien

2 1

Automated in-browser tests
by Aleksander Machniak 03 Jan '20

03 Jan '20

TL;DR: We have Roundcube in-browser tests on Travis. I rewrote old Selenium-based tests created long time ago. These were not working and I guess no one payed attention to them. Now, it should be easier and better in many ways. New code uses Laravel's Dusk (and Facebook/WebDriver) with PHPUnit which is a nice and powerful framework for functional testing. This means: - setting up testing environment is very easy, - writing tests is simpler and we can do much more, - thanks to SQLite and GreenMail software you don't need a real IMAP/SMTP nor database server, you also don't need a HTTP server, - we test Elastic only, and we test all modes desktop/tablet/phone. - via Travis tests are executed on every commit and pull request. Which technicly means you don't even need PHP to write tests, just write code and do a pull request ;). Now, I would love to see pull requests coming that add some more in-browser tests. If you'd like to give it a go, I propose to start with Preferences UI tests. There's Settings/Preferences/General.php file you can use as a base for testing other Preferences sections. See also tests/Browser/README.md Happy New Year everybody! -- Aleksander Machniak Kolab Groupware Developer [https://kolab.org] Roundcube Webmail Developer [https://roundcube.net] ---------------------------------------------------- PGP: 19359DC1 # Blog: https://kolabian.wordpress.com

1 0

Update 1.4.2 released
by Thomas Bruederli 02 Jan '20

02 Jan '20

Dear subscribers We start the year 2020 with the second service release to update the brand new Roundcube Webmail version 1.4. It contains fixes and improvements reported since the release of version 1.4.0. See the full changelog in the release notes on the Github download page [1]. This release is considered stable and we recommend to update all productive installations of Roundcube with this version. Download it from https://roundcube.net/download. Please do backup your data before updating. Happy New Year everybody! Alec & Thomas [1] https://github.com/roundcube/roundcubemail/releases/tag/1.4.2

1 0

Update 1.4.1 released
by Thomas Bruederli 22 Nov '19

22 Nov '19

Dear subscribers Short time after the release of the stable version 1.4.0 of Roundcube Webmail we already publish the first service release. With the recent release we missed to mention a few breaking changes since the last stable version 1.3. We apologize for this and are now clarifying and correcting these: Breaking changes ---------------- (since 1.3.x) * new defaults for smtp_* config options: Upon many requests and in order to get closer to the default setup of most SMTP servers, we changed the defaults as follows: // SMTP port (default is 587) $config[‘smtp_port’] = 587; // SMTP username (if required). %u will use the current username for login $config[‘smtp_user’] = ‘%u’; // SMTP password (if required). %p will use the current user’s password for login $config[‘smtp_pass’] = ‘%p’; * changed default password_charset to UTF-8: Because of many complaints, we decided to choose a more sane default that covers most setups and configurations. * login page returning 401 Unauthorized status: The new behavior that Roundcube 1.4 returns a 401 status code if the client is not authenticated apparently was very unexpected and lead to monitoring problems. Despite not having mentioned that change in the release notes, we now partly reverted it so that 401 is only returned on login failures but not on the first request to Roundcube which by definition is unauthorized. Besides these three major concerns we heard from your much appreciated feedback, we fixed a number of nasty bugs that sneaked into the 1.4.0 release. See the full changelog in the release notes on the Github download page [1]. This release is considered stable and we recommend to update all productive installations of Roundcube with this version. Download it from roundcube.net [2]. Please do backup your data before updating. We'd also like to thank Phil for his steady efforts to keep our website up-to-date. Your work is much appreciated! Best, Thomas & Alec [1] https://github.com/roundcube/roundcubemail/releases/tag/1.4.1 [2] https://roundcube.net/download

1 0

Roundcube Webmail 1.4.0 - Elastic released
by Thomas Bruederli 10 Nov '19

10 Nov '19

Dear subscribers It's a big honor for me to announce the final release of the long awaited major version 1.4 of Roundcube webmail. After more than two years of hard work by Alec and other volunteer contributors, Roundcube finally gets the responsive skin with full mobile device support - the Elastic. In addition to the new UI we introduce these new features: * Email Resent (Bounce) feature * Improved [Mailvelope](https://www.mailvelope.com) integration * Support for Redis and Memcached cache * Support for SMTPUTF8 and GSSAPI Plus numerous improvements and bug fixes collected from your precious feedback as well as updates to recent versions of 3rd party libraries like jQuery and TinyMCE. See the full changelog in the release notes on the Github download page [1]. The new Elastic theme, which is the new default skin, is built with LESS and of course the sources are included. They allow a certain degree of customization by adjusting some colors and variables using the `_styles.less` and `_variables.less` files. Please consider customizing your Roundcube installation in order to make phishing [2] harder. You'll find guidance in the README.md file inside the skin folder. This release is considered stable and we encourage you to update your productive installations after carefully testing the upgrade scenario and preparing your users to the significant changes in their webmail UI. Download it from https://roundcube.net/download. With the release of Roundcube 1.4.0, the previous stable release branches 1.3.x and 1.2.x will change into LTS low maintenance mode which means they will only receive important security updates but no longer any regular improvement updates. The 1.1.x series is no longer supported and maintained. Kind regards, Thomas [1] https://github.com/roundcube/roundcubemail/releases/tag/1.4.0 [2] https://roundcube.net/news/2019/10/28/phishing-alert

1 0

Schema change practices in roundcube
by Atalay Karatay 20 Oct '19

20 Oct '19

Dear developers from roundcube, I'm a student at the University of Applied Sciences in Regensburg (Germany). Currently I'm working on my master's thesis, contributing to a research project in the field quantitative software engineering. By mining the software histories of popular open source projects, we want to get insight about current development practices and challenges. Our main focus here is to understand the co-evolution/change-coupling of software artifacts, especially in the case of database-related changes. Since there are hardly works or established tools considering the co-evolution of schema and the code accessing it, we are investigating this topic. As roundcube is one major project in the open-source-community and is also supporting several databases, I have some questions: We found out that schema related changes were often committed together - across all databases . So in your case, some schema-changes were done for mssql, mysql, oracle, postgres and sqlite simultaneously. 1) Could you describe the common process of introducing these schema changes or do you have a manual for that? 2) Is there any tool in use, which supports this process automatically or is it done manually? 3) How much time is consumed when introducing schema changes in your project? 4) Which problems occur when changing the schema? Hopefully you can spend some time to answer these questions, I would be very grateful. Best regards Atalay Karatay

1 0

preferences in users table
by soumitri＠iitk.ac.in 19 Sep '19

19 Sep '19

Hello All, Can some one give me some light on the preferences column and if i want to modify how should i do it. I tried following command, but failed(no error, but no result too). # ./moduserprefs.sh --user='xyz' plugin.hotkeys.mapping_list --delete --type=string # ./moduserprefs.sh --user='xyz' plugin.hotkeys.mapping_list --delete Although i guess a brief structure from the below layout from preference column, but not in exact. Any reference document for this. Thanks for this nice OSS and any help. ============================ preferences: a:18: {s:27:"plugin.hotkeys.mapping_list";a:92: {i:0;a:7: {s:7:"profile";s:10:"cor.bosman";s:7:"command";s:23:"plugin.hotkeys.activate";s:7:"context";s:3:"any";s:7:"comment";s:30:"activate hotkeys plugin dialog";s:6:"script";s:0:"";s:3:"key";s:7:"shift+/";s:6:"source";s:8:"external";} i:91;a:7: {s:7:"profile";s:16:"andrei.pozolotin";s:7:"command";s:16:"#compose-subject";s:7:"context";s:9:"mail_edit";s:7:"comment";s:23:"focus: select 'subject'";s:6:"script";s:23:"top.$(command).focus();";s:3:"key";s:5:"alt+3";s:6:"source";s:6:"custom";} } s:16:"message_sort_col"; s:4:"date"; s:18:"message_sort_order"; s:4:"DESC"; s:9:"lastlogin"; a:4:{s:4:"from";s:12:"172.27.17.45";s:4:"date";s:10:"1567942038";s:3:"geo";s:12:"IITK network";s:7:"timeout";i:10;} s:44:"plugin.contextmenu_folder.collect_predefined"; a:2:{s:10:"INBOX/Sort"; a:3:{s:4:"mbox";s:10:"INBOX/Sort";s:6:"action";s:7:"default";s:12:"created_msec";i:0;} s:9:"Sent/Sort";a:3:{s:4:"mbox";s:9:"Sent/Sort";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}} s:41:"plugin.contextmenu_folder.collect_special"; a:5:{s:5:"INBOX";a:3:{s:4:"mbox";s:5:"INBOX";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}s:12:"INBOX.Drafts";a:3:{s:4:"mbox";s:12:"INBOX.Drafts";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}s:10:"INBOX.Sent";a:3:{s:4:"mbox";s:10:"INBOX.Sent";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}s:10:"INBOX.Junk";a:3:{s:4:"mbox";s:10:"INBOX.Junk";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}s:11:"INBOX.Trash";a:3:{s:4:"mbox";s:11:"INBOX.Trash";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}} s:22:"plugin.hotkeys.profile";s:5:"linux"; s:15:"per_folder_sort";a:2:{s:5:"INBOX";s:9:"date_DESC";s:12:"INBOX.Drafts";s:9:"date_DESC";} s:11:"search_mods";a:4:{s:1:"*";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}s:10:"INBOX.Sent";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:12:"INBOX.Drafts";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:5:"INBOX";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}} s:9:"list_cols";a:10:{i:0;s:7:"threads";i:1; s:5:"chbox";i:2; s:7:"subject";i:3; s:4:"date";i:4; s:4:"size";i:5; s:6:"status";i:6; s:4:"flag";i:7; s:10:"attachment";i:8; s:4:"from";i:9;s:2:"to";} s:31:"plugin.hotkeys.reset_to_default";b:0; s:11:"client_hash"; s:32:"badfa0036e5cdedeffa0aa2b0f341011"; s:11:"drafts_mbox"; s:12:"INBOX.Drafts"; s:9:"junk_mbox"; s:10:"INBOX.Junk"; s:9:"sent_mbox"; s:10:"INBOX.Sent"; s:10:"trash_mbox"; s:11:"INBOX.Trash"; s:15:"namespace_fixed";b:1; s:7:"filters"; a:1: {i:0;a:4: {s:10:"whatfilter";s:7:"subject";s:12:"searchstring";s:6:"[SPAM]";s:10:"destfolder";s:10:"INBOX.Junk";s:8:"messages";s:3:"all";} } ===================== -- Sincerely, Soumitri Mishra

2 2

Error When trying to update from the last git to version 1.4 rc2
by Fabián Burbano Gutiérrez 19 Sep '19

19 Sep '19

Dear: When trying to update from the last git to version 1.4 rc2, I get this message: ERROR: Target installation already in version 1.4-git. I don't know if it's the expected behavior and an update is impossible in that scenario. Maybe I should install from scratch? Or maybe I should report an incident? Thank you -- Fabián Burbano Gutiérrez

2 2

Roundcube Webmail 1.4 Release Candidate 2
by Thomas Bruederli 17 Sep '19

17 Sep '19

Dear subscribers We just published the long awaited second release candidate for the next major version 1.4 of Roundcube webmail. Many fixes, improvements and final touches have gone into this since the first release candidate was published. Check the Changelog [1] for a complete list of changes. We waited for some promised contributions which unfortunately never arrived but we now feel confident to call the new Elastic skin complete and ready to be officially released. As we’re moving towards the final release, we strongly encourage everybody to customize the Elastic skin using the _styles.less and _variables.less files to blend into your corporate design. You’ll find guidance for customization in the README.md file inside the skin folder. Rolling out a new and significantly different user interface should be carefully planned and we recommend to prepare your users for the change. Therefore the Elastic theme is not set to be the default theme. Adjust your config in order to enable it by default or let your users switch themselves in the user settings. Please note that the Classic skin will no longer be maintained and completely removed in future releases. Within the 1.4 release series, the Classic skin remains part of the package but it will not receive new features that were added to the Larry or Elastic themes. This is still a preview release and we recommend to test it on a separate environment. And don’t forget to backup your data before installing it. Download it from https://roundcube.net/download and keep on submitting bugs and send us your feedback. Best, Alec & Thomas [1] https://github.com/roundcube/roundcubemail/releases/tag/1.4-rc2

1 0

Roundcube Webmail 1.3.10 released
by Thomas Bruederli 29 Aug '19

29 Aug '19

Dear subscribers We proudly announce the next service release to update the stable version 1.3. It contains fixes to several bugs backported from the master branch including minor security fixes around CSS and HTML cleanup. See the full changelog in the release notes on the Github download page [1]. This release is considered stable and we recommend to update all productive installations of Roundcube with this version. Download it from https://roundcube.net/download. Best, Alec & Thomas [1] https://github.com/roundcube/roundcubemail/releases/tag/1.3.10

1 0

← Newer
1
2
3
4
5
6
7
8
...
430
Older →

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev