Enhancement #2902

Upgrade Roundcubemail to the current version of epel : 1.0.2-1.el6

Added by stephane de Labrusse almost 7 years ago. Updated over 6 years ago.

Status:CLOSEDStart date:
Priority:NormalDue date:
Assignee:-% Done:

100%

Category:nethserver-roundcubemail
Target version:v6.5
Resolution: NEEDINFO:No

Description

Hi All

The version of roundcubemail is not up to date and could be upgraded to the epel version (1.0.2-1.el6)

What it doesn't work when you use the epel version

-mysql db initialisation
sh: /usr/share/doc/roundcubemail-1.0.2/SQL/mysql.initial.sql: No such file or directory
-the config files are different between 0.9 and 1.0 and must be rewritten
all need to be in config.inc.php and start by example '$config['xxxx'] =' instead of '$rcmail_config['xxxxxxxxx']='
you don't need anymore 'main.inc.php' and 'db.inc.php'

moreover I saw that roundcube is strictly limited to the local network in its apache configuration, a db setting could allow it, or a panel box could do the trick also.

The main feature really interesting with the epel version is the plugin repository


Related issues

Related to NethServer 6 - Enhancement #2886: Roundcube webmail access from the Internet CLOSED

Associated revisions

Revision 4cbc60f9
Added by Giacomo Sanchietti almost 7 years ago

Merge branch 'stephdl-b2902'. Refs #2902

Revision 727db99c
Added by Giacomo Sanchietti almost 7 years ago

config template: add support for LDAP addressbook. Refs #2902

Revision 9b4084ff
Added by Giacomo Sanchietti almost 7 years ago

Merge branch 'stephdl-b2902'. Refs #2902

Revision a5309512
Added by Alessandro Polidori over 6 years ago

Fix private access. Refs #2902

Revision 28009b8e
Added by Giacomo Sanchietti over 6 years ago

httpd template: remove useless vars. Refs #2902

History

#1 Updated by Filippo Carletti almost 7 years ago

moreover I saw that roundcube is strictly limited to the local network in its apache configuration, a db setting could allow it, or a panel box could do the trick also.

I think that it's the same issue:
http://dev.nethserver.org/issues/2886

#2 Updated by stephane de Labrusse almost 7 years ago

Hi filipo

Indeed you shoot in first :), but that roundcube version should be updated.

#3 Updated by Giacomo Sanchietti almost 7 years ago

#4 Updated by Giacomo Sanchietti almost 7 years ago

  • Category set to nethserver-roundcubemail
  • Status changed from NEW to TRIAGED
  • % Done changed from 0 to 20

#5 Updated by stephane de Labrusse almost 7 years ago

Could I try to have a go on this upgrade ?

#6 Updated by stephane de Labrusse almost 7 years ago

I have started to work on it

https://github.com/stephdl/nethserver-roundcubemail

what it lacks to do

-finish the ldap address book, I have some differences between sme and neth and it doesn't work, probably need helps.
-create a composer script to install/upgrade plugins
-some plugins could be incorporated by default (carddav,managesieve,markasjunk,openpgp)
-cut the long template config.inc.php in several other files shorter
-probably other ideas :)
EDIT :
It needs also
-a https forced redirection
-maybe a dependency to nethserver-mail-server, that's funny a roundcubemail without postfix/imap/smtp -> thoughts ?

#7 Updated by stephane de Labrusse almost 7 years ago

http://mirror.de-labrusse.fr/nethserver/nethserver-roundcubemail/

I have done a pull-merge request on github, but I'm not fine with this procedure so I would share the srpm and the rpm

#8 Updated by Giacomo Sanchietti almost 7 years ago

  • Status changed from TRIAGED to ON_DEV
  • Assignee set to stephane de Labrusse
  • Target version set to v6.5
  • % Done changed from 20 to 30

I have started to work on it

Thank you!

-finish the ldap address book, I have some differences between sme and neth and it doesn't work, probably need helps.

Ok!

-create a composer script to install/upgrade plugins

Do we need this?

-some plugins could be incorporated by default (carddav,managesieve,markasjunk,openpgp)

Agree, the most important is managesieve. To mark as junk, you can simply move the mail to the junkmail folder.

-cut the long template config.inc.php in several other files shorter

Agree.

It needs also
-a https forced redirection

Agree, I saw the commit, it looks fine to me.

-maybe a dependency to nethserver-mail-server, that's funny a roundcubemail without postfix/imap/smtp -> thoughts ?

Right: we can add nethserver-mail-server as dependency so directory is automatically included.

#9 Updated by stephane de Labrusse almost 7 years ago

Hi All

I agree that the composer script is a bit border line about stability, I would prefer that the sysadmin use it on his own.

I have done a new version with :

-Upgrade to roundcubemail 1.0.2-1 - Bug #2902 [NethServer]
-A dependency to nethserver-mail-server
-Managesieve as a default plugin
-Now you can add a plugin with a db command : config setprop roundecubemail PluginList plugin1,plugin2,plugin3 ; signal-event nethserver-roundcubemail-update
-You can restrict access to the local network (default : public) - Bug #2886 [NethServer] :

 config setprop roundcubemail access private ; signal-event nethserver-roundcubemail-update

-Config.inc.php is now templated with several files
-New templates.metadata for protecting Config.inc.php (0640 root/apache)

the list of rpm of epel is :

roundcubemail                           noarch  1.0.2-1.el6  epel     3.4 M
php-pear-Auth-SASL                noarch 1.0.6-1.el6 epel 16 k
php-pear-Mail-Mime noarch 1.8.4-1.el6 epel 40 k
php-pear-Mail-mimeDecode noarch 1.5.5-1.el6 epel 17 k
php-pear-Net-IDNA2 noarch 0.1.1-3.el6 epel 24 k
php-pear-Net-SMTP noarch 1.6.1-1.el6 epel 22 k
php-pear-Net-Sieve noarch 1.3.3-1.el6 epel 19 k
php-pear-Net-Socket noarch 1.0.10-1.el6 epel 12 k
php-mcrypt x86_64 5.3.3-3.el6 epel 19 k
libmcrypt x86_64 2.5.8-9.el6 epel 96 k

The work is available by the pull-request on github or here by srpm : http://mirror.de-labrusse.fr/nethserver/nethserver-roundcubemail/

#10 Updated by Giacomo Sanchietti almost 7 years ago

  • Status changed from ON_DEV to MODIFIED
  • % Done changed from 30 to 60

Merged from Github to master.

#11 Updated by stephane de Labrusse almost 7 years ago

I would record this bug http://dev.nethserver.org/issues/2511#note-13 for saving a ldap addressbook

#12 Updated by stephane de Labrusse almost 7 years ago

I have corrected some issue with the ldap address book and some adjustments. Changes are available on Github with a pull request.

#13 Updated by Giacomo Sanchietti almost 7 years ago

Merged from Github to master.

#14 Updated by Giacomo Sanchietti almost 7 years ago

  • Assignee changed from stephane de Labrusse to Giacomo Sanchietti

#15 Updated by Giacomo Sanchietti almost 7 years ago

  • Status changed from MODIFIED to ON_QA
  • Assignee deleted (Giacomo Sanchietti)
  • % Done changed from 60 to 70
Package in nethserver-testing:
  • nethserver-roundcubemail-1.0.1-22.0git9b4084ff.ns6.noarch.rpm
  • nethserver-roundcubemail-1.0.1-23.0gitca883716.ns6.noarch.rpm
  • libmcrypt-2.5.8-9.el6.x86_64.rpm
  • php-mcrypt-5.3.3-3.el6.x86_64.rpm
  • php-pear-Auth-SASL-1.0.6-1.el6.noarch.rpm
  • php-pear-Mail-Mime-1.8.4-1.el6.noarch.rpm
  • php-pear-Mail-mimeDecode-1.5.5-1.el6.noarch.rpm
  • php-pear-Net-IDNA2-0.1.1-3.el6.noarch.rpm
  • php-pear-Net-Sieve-1.3.3-1.el6.noarch.rpm
  • php-pear-Net-Socket-1.0.10-1.el6.noarch.rpm
  • roundcubemail-1.0.2-1.el6.noarch.rpm
Test case 1
  • On a clean machine install nethserver-mail-server
  • Create a user and enable mail service for it
  • Install the old package
  • Update the package with this one and check all is working fine
Test case 2
  • On a clean machine install nethserver-mail-server
  • Install the new package: nethserver-mail-server and nethserver-directory must be automatically installed
  • Create two users and enable mail service for them
  • Check the LDAP phonebook works fine
Test case 3
  • From test case 2
  • Restrict access to local networks:
    config setprop roundcubemail access private 
    signal-event nethserver-roundcubemail-update
    
  • Check roundcube is not reachable from outer network
Test case 4
  • Try to disable all plugins
    config setprop roundcubemail Pluginlist  
    signal-event nethserver-roundcubemail-update
    
  • Check managesive and markasjunk are no more enabled

#16 Updated by Alessandro Polidori over 6 years ago

  • Assignee set to Alessandro Polidori

#17 Updated by Alessandro Polidori over 6 years ago

Test case 1

Ok, after the update roundcube continues to work correctly.
The url are:

https://_server/webmail
https://_server/roundcubemail

#18 Updated by Alessandro Polidori over 6 years ago

  • Assignee deleted (Alessandro Polidori)

#19 Updated by Alessandro Polidori over 6 years ago

  • Assignee set to Alessandro Polidori

#20 Updated by Alessandro Polidori over 6 years ago

Test case 2

  • On a clean machine install nethserver-mail-server
    Installed package is: nethserver-mail-server-1.8.2-1.ns6.noarch
  • Install the new package: nethserver-mail-server and nethserver-directory must be automatically installed
    yum --enablerepo=nethserver-testing install nethserver-roundcubemail

    nethserver-roundcubemail-1.0.1-23.0gitca883716.ns6.noarch has been installed

The following has been installed in the first step:

nethserver-directory-2.0.4-1.ns6.noarch
nethserver-mail-server-1.8.2-1.ns6.noarch

  • Create two users and enable mail service for them
  • Check the LDAP phonebook works fine
Ok it works.
  1. login to roundecubemail
  2. open the phonebook
  3. select "Public LDAP Address book"
  4. the contacts are: "System administrator" and two new users

#21 Updated by Alessandro Polidori over 6 years ago

  • Status changed from ON_QA to TRIAGED
  • Assignee deleted (Alessandro Polidori)
  • % Done changed from 70 to 20

Test Case 3
Failed.
The /etc/httpd/conf.d/roundcubemail.conf has:

<Directory /usr/share/roundcubemail/>
    Order Deny,Allow
    Deny from all
    Allow from 127.0.0.1 192.168.5.0/255.255.255.0 0.0.0.0/0.0.0.0
</Directory>

because there is the 0.0.0.0 trusted network.
So the roundcubemail is accessible from all interfaces.
If I manually remove the trusted network using the web interface, the roundcubemail template is not expanded.

#22 Updated by Alessandro Polidori over 6 years ago

  • Status changed from TRIAGED to ON_DEV
  • Assignee set to Alessandro Polidori
  • % Done changed from 20 to 30

#23 Updated by Alessandro Polidori over 6 years ago

  • Status changed from ON_DEV to MODIFIED
  • Assignee deleted (Alessandro Polidori)
  • % Done changed from 30 to 60

#24 Updated by Alessandro Polidori over 6 years ago

  • Status changed from MODIFIED to ON_QA
  • % Done changed from 60 to 70
Package in nethserver-testing:
  • nethserver-roundcubemail-1.0.1-24.0gita5309512.ns6.noarch.rpm
  • nethserver-roundcubemail-1.0.1-25.0git28009b8e.ns6.noarch.rpm

#25 Updated by Giacomo Sanchietti over 6 years ago

  • Assignee set to Giacomo Sanchietti

#26 Updated by Giacomo Sanchietti over 6 years ago

  • Status changed from ON_QA to VERIFIED
  • Assignee deleted (Giacomo Sanchietti)
  • % Done changed from 70 to 90

Test case 3: VERIFIED

  • Networks inside the "Remote Access" tabs are excluded from @Allow# directory of httpd configuration

Test case 4: VERIFIED

  • Changes to PluginsList are reflected inside the UI

#27 Updated by Giacomo Sanchietti over 6 years ago

  • Status changed from VERIFIED to CLOSED
  • % Done changed from 90 to 100
Released in nethserver-updates:
  • nethserver-roundcubemail-1.1.0-1.ns6.noarch.rpm
  • libmcrypt-2.5.8-9.el6.x86_64.rpm
  • php-mcrypt-5.3.3-3.el6.x86_64.rpm
  • php-pear-Auth-SASL-1.0.6-1.el6.noarch.rpm
  • php-pear-Mail-Mime-1.8.4-1.el6.noarch.rpm
  • php-pear-Mail-mimeDecode-1.5.5-1.el6.noarch.rpm
  • php-pear-Net-IDNA2-0.1.1-3.el6.noarch.rpm
  • php-pear-Net-Sieve-1.3.3-1.el6.noarch.rpm
  • php-pear-Net-Socket-1.0.10-1.el6.noarch.rpm
  • roundcubemail-1.0.3-1.el6.noarch.rpm

Also available in: Atom PDF