- Users - Roundcube mailing lists

Minimum SQL Privileges Required
by Matthew J Black 02 May '25

02 May '25

Hi All, I am enquiring as to the *minimum* privileges required by the RoundCube user to access the backend SQL (MariaDB) Server. Yes, I am aware that the Wiki says (on the Installation page) to use `GRANT ALL PRIVILEGES`, as do all of the On-Line Tutorials scattered across the Web. However, that is a *massive* security hole, especially if the backend server is *not* the same as the web server hosting RoundCube. Surely, for example, the RoundCube User does *not* need the ability to create other users or tables, drop the backend database, or grant privileges to other users. Thus, I am enquiring what *are* the *minimum* privileges required? I am going to assume - and please correct me if I am wrong - that the *required* privileges are: * DELETE, INSERT, SELECT, and UPDATE If this information is available on-line, could someone please point me in the correct direction - if not, could one of the devs and/or one of the experienced RoundCube users please let me know this information - thank you. Thanks in advance Cheers Dulux-Oz -- PEREGRINE I.T. Pty Ltd Signature ================================================== *Matthew J BLACK* M.Inf.Tech.(Data Comms) MBA B.Sc. MACS (Snr), CP, IP3P When you want it done /right/ – the first time! Phone: +61 4 0411 0089 Email: matthew(a)peregrineit.net <mailto:matthew@peregrineit.net> Web: www.peregrineit.net <http://www.peregrineit.net> View Matthew J BLACK’s profile on LinkedIn <https://au.linkedin.com/in/mjblack> This Email is intended only for the addressee. Its use is limited to that intended by the author at the time and it is not to be distributed without the author’s consent. You must not use or disclose the contents of this Email, or add the sender’s Email address to any database, list, or mailing list unless you are expressly authorised to do so. Unless otherwise stated, PEREGRINE I.T. Pty Ltd accepts no liability for the contents of this Email except where subsequently confirmed in writing. The opinions expressed in this Email are those of the author and do not necessarily represent the views of PEREGRINE I.T. Pty Ltd. This Email is confidential and may be subject to a claim of legal privilege. If you have received this Email in error, please notify the author and delete this message immediately.

3 3

Re: Minimum SQL Privileges Required
by Matthew J Black 02 May '25

02 May '25

That's a great idea (& one I was aware of - thanks) but that doesn't answer my question :-) Unless you are implying that my assumption was correct (ie DELETE, INSERT, SELECT, and UPDATE ). On 2/5/25 18:37, Reindl Harald (privat) wrote: > you can specifiy even two users to seperate read-only and writes > > $rcmail_config['db_dsnw'] = > 'mysqli://roundcube_rw:*****@127.0.0.1:3306/roundcube_db'; > $rcmail_config['db_dsnr'] = > 'mysqli://roundcube_ro:*****@127.0.0.1:3306/roundcube_db'; > > Am 02.05.25 um 10:00 schrieb Matthew J Black: >> Hi All, >> >> I am enquiring as to the *minimum* privileges required by the >> RoundCube user to access the backend SQL (MariaDB) Server. >> >> Yes, I am aware that the Wiki says (on the Installation page) to use >> `GRANT ALL PRIVILEGES`, as do all of the On-Line Tutorials scattered >> across the Web. However, that is a *massive* security hole, >> especially if the backend server is *not* the same as the web server >> hosting RoundCube. Surely, for example, the RoundCube User does *not* >> need the ability to create other users or tables, drop the backend >> database, or grant privileges to other users. >> >> Thus, I am enquiring what *are* the *minimum* privileges required? >> >> I am going to assume - and please correct me if I am wrong - that the >> *required* privileges are: >> >> * DELETE, INSERT, SELECT, and UPDATE >> >> If this information is available on-line, could someone please point >> me in the correct direction - if not, could one of the devs and/or >> one of the experienced RoundCube users please let me know this >> information - thank you. -- PEREGRINE I.T. Pty Ltd Signature ================================================== *Matthew J BLACK* M.Inf.Tech.(Data Comms) MBA B.Sc. MACS (Snr), CP, IP3P When you want it done /right/ – the first time! Phone: +61 4 0411 0089 Email: matthew(a)peregrineit.net <mailto:matthew@peregrineit.net> Web: www.peregrineit.net <http://www.peregrineit.net> View Matthew J BLACK’s profile on LinkedIn <https://au.linkedin.com/in/mjblack> This Email is intended only for the addressee. Its use is limited to that intended by the author at the time and it is not to be distributed without the author’s consent. You must not use or disclose the contents of this Email, or add the sender’s Email address to any database, list, or mailing list unless you are expressly authorised to do so. Unless otherwise stated, PEREGRINE I.T. Pty Ltd accepts no liability for the contents of this Email except where subsequently confirmed in writing. The opinions expressed in this Email are those of the author and do not necessarily represent the views of PEREGRINE I.T. Pty Ltd. This Email is confidential and may be subject to a claim of legal privilege. If you have received this Email in error, please notify the author and delete this message immediately.

1 0

Bouncing emails
by doreen.imagezone＠gmail.com 01 May '25

01 May '25

What can i do not to get bouncing emails on Gmail to the corporate email on round cube . If all SPF, DKIM & DMARC records have been corrected and validated. The server host has said i consult will the mail service provider whose round cube. How do i go about this?

3 2

Size of compose/reply pop up window
by Michael Heydekamp 30 Apr '25

30 Apr '25

Recently the default size of the compose/reply pop up window changed to an awkward size. I can manually adjust it but I can't figure out how to save it to the initial default size. I thought it was a Firefox issue at first but it appears to be isolated to this webmail. Any suggestions? Deleted cookies of the relevant domain, that didn't help. Roundube 1.6.6, Win10 Pro, FF 128.10.0esr (The text above was copied from a post in the Roundcube forum from Jan 2018, which received no response at all. See https://www.roundcubeforum.net/index.php?topic=24695.msg67347#msg67347) Cheers, -- Michael Heydekamp Co-Admin freexp.de Düsseldorf/Germany

1 0

SMTP Configuration
by White, Phil 20 Apr '25

20 Apr '25

Hi All Apologies for what must be a rather basic question -- but I've hit a brick wall in getting Roundcube working. Can anyone please help identify what is wrong? Going to the installer -- /installer/index.php?_step=3, everything appears configured correctly. Crucially, the 'Test SMTP config' and 'Test IMAP config' sections work without error. The test email sent is received at the intended destination. However, when logged in to an IMAP account, I am unable to send any email. The attempt gives the error: "SMTP Error (): Authentication failed." My SMTP server is on the same box as Roundcube. It accepts email submission via SMTP on ports 25, 465, and 587, although I could probably look at other methods (pipe, socket,...) For clients on the local network, no authentication is necessary, although I permit this if a client issues an AUTH command (because I use it for testing). For example, the following command works: swaks --server 192.168.123.254:465 --tls-on-connect --to whitepj(a)mydomain.co.uk --auth-user test_user --auth-password user_password --auth PLAIN My Roundcube configuration has been through several edits based on suggestions from the web. It is currently: $config['smtp_host'] = '192.168.123.254:25'; $config['smtp_auth_type'] = null; Roundcube version is 1.6.10 In Errors.log, I get the following: [20-Apr-2025 10:06:40 +0000]: <gln3hk80> PHP Error: SMTP server does not support authentication (POST /?_task=mail&_unlock=loading1745143624474&_framed=1&_action=send) [20-Apr-2025 10:06:40 +0000]: <gln3hk80> SMTP Error: Authentication failure: test message SIZE 8388608 8BITMIME DSN ETRN VRFY EXPN PIPELINING PIPECONNECT CHUNKING STARTTLS PRDR HELP (Code: 250) in /<...snip...>/htdocs/program/lib/Roundcube/rcube.php on line 1795 (POST /?_task=mail&_unlock=loading1745143624474&_framed=1&_action=send) Many thanks. Phil

2 3

limit e-mail adresses
by Jugendbewerb FF Kirchbach 10 Apr '25

10 Apr '25

Hallo, weiß jemand, ob es bei Roundcube eine Obergrenze für die Anzahl von Mailadressen beim Versenden von E-Mails gibt? does anyone know if Roundcube has an upper limit for number of e-mail addresses when sending e-mails? Danke Raimund

2 1

Please Help! :)
by bdm.global＠rbnapply.com 08 Apr '25

08 Apr '25

Hello, I need assistance/help. My mailbox is perpetually at capacity (currently at 96%), despite having deleted nearly all of my sent and received emails. Could you please help me with this issue? Thank you, Gordan.

4 3

Error600 with identities
by Matthias Schmidt 05 Apr '25

05 Apr '25

Hello, I changed database from an old mySQL to MariaDB10.5 on macOS I set up roundcube from scratch. Now in indentities I get an error 600 and the inbox is empty, so mails are not listed. I note a login on the server, nothing more. btw, the forum is not reachable for me. cheers and all the best Matthias

1 0

Support for Roundcube webmail on smartphone
by Charles-Henri Blanchard 28 Mar '25

28 Mar '25

Hello, Do you provide support for Roundcube webmail on smartphones ? Kind regards, Charles-Henri Blanchard Tél : +33604050054

2 1

debugging slow responsive web interface
by Marc 02 Mar '25

02 Mar '25

I have two roundcube web interfaces running on the same webserver. One of them has a slow responding UI, I already compared the config files. One is connected to a different mail server, but a regular imap client is just fast with that server. How should I go about debugging this?

3 2

Tool for admin batch operations
by Nicolas George 25 Feb '25

25 Feb '25

Hi. I am looking for a tool to perform some admin operations on the Roundcube database: - batch export of users' address books; - add a identity to a user; - … including a user who has never logged in; - delete or alter an identity. OwnCloud / NextCloud have “occ”, I am hoping Roundcube has something similar that I have not yet managed to find. Otherwise I shall start working on it. Thanks in advance. -- Nicolas George, responsable adjoint du Pôle numérique, pédagogique et scientifique, École normale supérieure

1 0

Update 1.6.10 released
by Aleksander Machniak 08 Feb '25

08 Feb '25

This is the next service release to update the stable version 1.6. Here's the full changelog: - IMAP: Partial support for ANNOTATE-EXPERIMENT-1 extension (RFC 5257) - OAuth: Support standard authentication with short-living password received with OIDC token (#9530) - Fix PHP warnings (#9616, #9611) - Fix whitespace handling in vCard line continuation (#9637) - Fix current script state after initial scripts creation in managesieve_kolab_master mode - Fix rcube_imap::get_vendor() result (and PHP warning) on Zimbra server (#9650) - Fix regression causing inline SVG images to be missing in mail preview (#9644) - Fix plugin "virtuser_file" to handle backward slashes in username (#9668) - Fix PHP fatal error when parsing some malformed BODYSTRUCTURE responses (#9689) - Fix insert_or_update() and reading database server config on PostgreSQL (#9710) - Fix Oauth issues with use_secure_urls=true (#9722) - Fix handling of binary mail parts (e.g. PDF) encoded with quoted-printable (#9728) - Fix links in comments and config to https:// where available (#9759, #9756) - Fix decoding of attachment names encoded using both RFC2231 and RFC2047 standards (#9725) This version is considered stable and we recommend to update all productive installations of Roundcube with it. Please do backup your data before updating! https://github.com/roundcube/roundcubemail/releases/tag/1.6.10 Please do backup your data before updating! -- Alec

1 0

Installation on windows 10
by Dave 07 Feb '25

07 Feb '25

Hi All I used to use Roundcube when I registered my domain Hallnet1.uk with Gandi .net. Since moving away from Gandi I have not found as good a user interface. Can you suggest how to register and use Roundcube via a browser or install it as a stand alone email client on my windows 10 pro pc. Any and all help will be agreat help thanks in advance David

3 2

Re: Users Digest, Vol 201, Issue 1
by info＠ilmaterasso.eu 04 Feb '25

04 Feb '25

1 0

sexyadultdirectory Website
by natoma7531＠eluxeer.com 03 Feb '25

03 Feb '25

sexyadultdirectory website brings you the best free porn in incredible quality and variety for your satisfaction. The web is very useful if you are looking for lesbian porn, Asian porn, or beautiful Indian girls. It is a website that has a lot of potentials and that you should visit to enjoy the best porn online. https://www.sexyadultdirectory.com/

1 0

c72592fc593a10e7af7b4f1619da983019a55f5a
by mathan＠thekingsberry.com 03 Feb '25

03 Feb '25

1 0

Unsuscribe
by Giorgio Grossi 25 Jan '25

25 Jan '25

Thanks G.Grossi >

1 0

Unsuscribe.
by Giorgio Grossi 25 Jan '25

25 Jan '25

G.Grossi

1 0

Duplicated Accounts
by Bob Puff 24 Jan '25

24 Jan '25

Hello, I have an existing Roundcube mail system that I want to turn into a strictly mail system, and have another host be the Roundcube webmail interface. I've got the new host pointing to the old one successfully, and I copied over the MySQL roundcube database (both versions of Roundcube are the same). I've run into two issues: 1. The mail_host column in the users table was "localhost", but now wants to be the IP address of the mail server. Ok, I can update all those, no problem, so I think this is solved. 2. A user can log in as username & password, or username(a)domain.com & password. However, these create unique users in the users table, and thus have independent settings. How do I make Roundcube treat username and username(a)domain.com the same? There is only one domain that is handled by this system. I have: $config['mail_domain'] = 'domain.com'; Is there something else I need to modify? Bob

3 2

problem with font size
by choban 30 Dec '24

30 Dec '24

In Roundcube web e-mail software 1.66, how do you display all 3 columns and have the font size so it is readable? I can increase the font by using the CTRL key and my mouse scroll bar, but if I do that, I will lose one column. If I show all 3 columns by using the CTRL key and my mouse scroll bar the font size is too small for me to read.

2 1

How to contact the email service prodiver
by marketing＠143communications.co.zw 20 Dec '24

20 Dec '24

Hi, I need to help getting in touch with the email service provider here. I need to confirm if I'm receiving emails from someone. It's really important

3 3

「help」Inquire about the Rouncube filter setting
by Gao Meihui (高美慧) 08 Nov '24

08 Nov '24

Dear Roundcue, I hope this message finds you well. I would like to inquire about the filter settings in Roundcube. Specifically, I am interested in whether it is possible to set up a filter exclusion for specific days and times. For example, I would like to exclude the filter during the time period of 4:00 - 4:30 AM on the second and fourth Thursday of each month. Could you kindly confirm if this can be achieved, and if so, how to configure such a setting? If possible, I would appreciate it if you could reply by next Tuesday. Thank you for your time and support. I look forward to your response. Best regards, Gao meihui

2 1

OAuth login button not showing
by Antonin VERRIER 16 Oct '24

16 Oct '24

Hello, I'm trying to set up Rouncube for OAuth authentication but I'm probably missing something trivial, because the button for OAuth login doesn't even show on the login page. I'm using Docker image roundcube/roundcubemail:latest Here are the contents of the config file inside the container : /var/www/html/config/config.docker.inc.php ----- <?php $config['db_dsnw'] = 'mysql://[LOGIN]:[PASS]@mariadb.[DOMAIN.TLD]:3306/roundcube'; $config['db_dsnr'] = ''; $config['imap_host'] = 'tls://mail.[DOMAIN.TLD]:143'; $config['smtp_host'] = 'tls://mail.[DOMAIN.TLD]:587'; $config['username_domain'] = ''; $config['temp_dir'] = '/tmp/roundcube-temp'; $config['skin'] = 'elastic'; $config['request_path'] = '/'; $config['plugins'] = array_filter(array_unique(array_merge($config['plugins'], ['archive', 'zipdownload']))); include('/var/roundcube/config/oauth2.inc.php'); ----- /var/roundcube/config/oauth2.inc.php ----- <?php $config['oauth_provider'] = 'generic'; $config['oauth_provider_name'] = '[DOMAIN.TLD]'; $config['oauth_client_id'] = '[CLIENT_ID]'; $config['oauth_client_secret'] = '[CLIENT_SECRET]'; $config['oauth_config_uri'] = 'https://auth.[DOMAIN.TLD]/.well-known/openid-configuration'; $config['oauth_issuer'] = null; $config['oauth_jwks_uri'] = null; $config['oauth_auth_uri'] = "https://auth.[DOMAIN.TLD]/oauth2/authorize"; $config['oauth_pkce'] = 'S256'; $config['oauth_token_uri'] = null; $config['oauth_identity_uri'] = null; $config['oauth_logout_uri'] = null; $config['oauth_timeout'] = 10; $config['oauth_verify_peer'] = true; $config['oauth_scope'] = "email profile openid"; $config['oauth_auth_parameters'] = []; $config['oauth_identity_fields'] = null; $config['oauth_login_redirect'] = true; $config['oauth_debug'] = false; $config['oauth_cache'] = 'db'; $config['oauth_cache_ttl'] = '8h'; $config['oauth_user_create_map'] = [ 'user_name' => ['name'], 'user_email' => ['email'], 'language' => ['locale'], ]; $config['oauth_password_claim'] = null; ----- What am I missing? Thanks

1 0

problem receiving email
by Kim Martin-Long 25 Sep '24

25 Sep '24

Hello, I just set up my domain email. I am able to send out email just fine from the webmail client within Roundcube, but I cannot receive any. What's up? Thanks, Kim -

2 1

Configuration
by info＠similandaytrip.com 24 Sep '24

24 Sep '24

Hello. We would like to know what damn happen in our mail. Please we sant normal like before Thank you

3 2

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Users