- Users - Roundcube mailing lists

line length
by mick crane 30 Sep '19

30 Sep '19

hello, Roundcube Webmail 1.4-rc1 here. Where can I set the line length to something like 70 characters and have compose sort it out for me so it starts a new line if I type more than that on one line ? regards mick -- Key ID 4BFEBB31

2 2

Addressbook not showing addresses
by TheCajun 26 Sep '19

26 Sep '19

Hi, I am running Fedora 30 1) At some point, and after some update, the autofill 'To' stopped working. The addressbook also does not show any of the existing entries made in Contacts. It shows the name and the group contact is in and that is all. Entering edit mode offers fields to enter information, but does not show existing addresses. They are in the MySQL database. I can see them there. 2) Where are the emails stored? I thought they would be under username/mail/. There are folders there, but none of the current emails are there. 3) Part of 2. I would like too archive all emails. I was hoping it would be as simple as copying the mail folder. Thank you, Durwin

2 1

Re: [RCU] Addressbook not showing addresses
by TheCajun 25 Sep '19

25 Sep '19

On 2019-09-25 11:00, Reindl Harald wrote: > Am 25.09.19 um 18:52 schrieb TheCajun: >> 3) Part of 2. I would like too archive all emails. I was hoping it >> would be as simple as copying the mail folder. > > you need to realize that roundcube is just a mail client like > Thunderbird, Outlook, Evolution.... Ok, 2 and 3 are resolved. I had forgotten I created a new user 'webmail' for this. I found the mail folder. Now for why the addresses do not show up in 'Contacts' as stated in Original email, item 1). -- .

1 0

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

17 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

1 0

error upgrading RC from 1.3.9 to 1.3.10
by Sophie Loewenthal 17 Sep '19

17 Sep '19

Hi, I had this error 1.3.9 to 1.3.10. …SNIP... composer.json-dist CHANGELOG README.md UPGRADING LICENSE INSTALL done. JavaScript dependencies installation skipped... Running update script at target... Executing database schema update. ERROR: could not find driverError 500: Error connecting to database: could not find driver All done. Is sqlite still supported?

1 1

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

16 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

New security plugin for Roundcube: GuardianKey Auth
by Gesiel Bernardes 13 Sep '19

13 Sep '19

Hi, I would like to share with you a new security plugin for Roundcube: GuardianKey Auth. GuardianKey is a solution to protect systems against authentication attacks (Brute force, phishing password, etc). It uses Artificial Intelligence to detect if access attempts are from legitimate users. You can notify your users, block or log the attempts. Currently it is free for up to 100 users. More information: https://guardiankey.io/products/guardiankey-for-roundcube/ https://plugins.roundcube.net/packages/guardiankey/guardiankey_auth

1 0

Determining which version was installed: Complete Framework or Dependent
by Sophie Loewenthal 05 Sep '19

05 Sep '19

Hi, I’d like to patch our RC install to 1.3.10, but have forgotten which version I installed before. How could I determine if Complete Framework or Dependent was installed? I looked in the Changelog Upgrading and Install files but nothing noted. Regards, Sophie

2 5

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

Truncated filenames of attachments
by Jorge 22 Aug '19

22 Aug '19

Hi All, I use Roundcube version 1.3.6 and I have problems with the attached files whose name is quite long (more than 90 characters). When downloading them the name is truncated to the first 91 characters and not including the extension, which is usually difficult to open correctly. For example: A23456789B23456789C23456789D23456789E23456789F23456789G23456789H23456789I23456789J23456789K23456789L23456789M23456789N23456789O23456789P23456789Q23456789.txt when downloading it RoundCube shows it to me as: A23456789B23456789C23456789D23456789E23456789F23456789G23456789H23456789I23456789J23456789K truncated to 91 characters and not including the extension. Has anyone had such problems? Is there any way to fix it? Jorge Colaccini --- El software de antivirus Avast ha analizado este correo electrónico en busca de virus. https://www.avast.com/antivirus

4 3

Roundcube, This content can not be displayed in a frame error
by David Mehler 12 Aug '19

12 Aug '19

Hello, Up until about half an hour ago I had a working roundcube installation running on php 7.3 and apache 2.4. I went in to tweak my X-Frame-Options headers among others in apache and now I'm getting the error this content can not be displayed in a frame. This is with ie11. Chrome isn't showing me messages either, but it isn't giving the error. Now I did have the webmail open in an ie tab during this working, but it was not logged in in fact I ignored it. I've sense put the option back to SAMEORIGIN, restarted both apache and php-fpm several times, refreshed the ie browser window, deleted temporary internet files, still getting the error. I've even gone in to defaults.inc.php (yes I know that's not standard practice) and changed x_frame_options from it's default of sameorigin to false, again restarted both apache and php-fpm as well as another ie refresh, still getting the error. I have not checked on another computer i'm not near one at the moment. Any ideas very welcome. Thanks. Dave.

2 1

Automatically insert address book source in message headers
by André Rodier 11 Aug '19

11 Aug '19

Hello all, I am actually writinghave written a milter with Python that can be useful, especially if you are using the Sieve filters. It is written for SOGo, but it should be very simple (even simpler) to translate into RoundCube address books. This is a very simple milter, written in Python, that do the following when a new message arrive. 1. Get the recipient uid "UID" from the email address. 2. Get the list of address books in the database for the user with uid "UID" 3. Search the sender email address in all the user's address books 4. If found at least one, add one header "X-AddressBook" which contains a list of all the address books found, with a prefixed syntax: X-AddressBook: "SOGo:Personnal, SOGo:Professional" So, in the case of RoundCube, the plugin would use RoundCube prefix, but the same principle. There are some limitations, of course, but it is still functional. - Once active, sieve filters should be simpler, no need to have a long list of from email address, just create an address book, and a put your contacts in it. - You can create a different automatic responder for each address book. - Because I am using this on Debian Stretch for now, I am using the available version of python-milter, which uses python2. When I will port this to buster, I will use the python3-milter package. I tried to made it compatible with version 3 as much as I could. - This is freshly new, and has not been tested in production yet. I am working on it. - You can test the behaviour using an SQLite database. Because my first idea was to use a global sqlite database synchronised with multiple address books, it was supposed to contain not the email address but a hash (sha256). - I am not a Python expert, and perhaps there are some errors in the code, but it should be readable. I had to disable a few pylint warnings, as I could not solve them at all, especially those related to the inherited class. - This is the first time I am writing a milter script, be indulgent. The code: https://github.com/progmaticltd/sogo-milters/blob/master/milter-abook/milte… I initially wrote this for HomeBox, I may add some documentation for the deployment if needed. Kind regards, André

1 1

managesieve-plugin closes connection before negotiation
by Florian Ruhnke (OiledAmoeba) 09 Aug '19

09 Aug '19

Hi, I do have an running dovecot-sieve installation. There is no problem to use it with rainloop or Thunderbird. But I can't get roundcube to work with sieve. Dovecot forces to initiate TLS before auth. SSL is disabled, only TLS 1.2+ is enabled. sieve-log of roundcube: [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> S: "IMPLEMENTATION" "Dovecot Pigeonhole" [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> S: "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate mime foreverypart extracttext imapsieve vnd.dovecot.imapsieve" [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> S: "NOTIFY" "mailto" [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> S: "SASL" "" [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> S: "STARTTLS" [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> S: "VERSION" "1.0" [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> S: OK "Doctor, your Tardis is ready." [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> C: STARTTLS [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> S: NO "Error in MANAGESIEVE command received by server." [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> C: LOGOUT [31-Jul-2019 16:24:29 +0200]: <fqn6h82s> S: OK "Begin TLS negotiation now." maillog (dovecot errors): Jul 31 16:24:29 mail dovecot: managesieve-login: Disconnected (no auth attempts in 0 secs): user=<>, rip=10.23.102.80, lip=10.23.102.251, TLS handshaking: SSL_accept() failed: error:1408F10B:SSL routines:ssl3_get_record:wrong version number, session=<rbUW4vqOC+MKF2ZQ> managesieve config.inc.php: $config['managesieve_port'] = 4190; $config['managesieve_host'] = 'mail.domain.tld'; $config['managesieve_auth_type'] = 'PLAIN'; $config['managesieve_auth_cid'] = null; $config['managesieve_auth_pw'] = null; $config['managesieve_usetls'] = true; //$config['managesieve_conn_options'] = null; $config['managesieve_conn_options'] = array( 'ssl' => array( 'verify_peer' => true, 'verify_peer_name' => true, 'allow_self_signed' => false, ), ); $config['managesieve_default'] = '/etc/dovecot/sieve/global'; $config['managesieve_script_name'] = 'managesieve'; $config['managesieve_mbox_encoding'] = 'UTF-8'; $config['managesieve_replace_delimiter'] = ''; $config['managesieve_disabled_extensions'] = array(); $config['managesieve_debug'] = true; $config['managesieve_kolab_master'] = false; $config['managesieve_filename_extension'] = '.sieve'; $config['managesieve_filename_exceptions'] = array(); $config['managesieve_domains'] = array(); $config['managesieve_vacation'] = 1; $config['managesieve_vacation_interval'] = 0; $config['managesieve_vacation_addresses_init'] = false; $config['managesieve_vacation_from_init'] = false; $config['managesieve_notify_methods'] = array('mailto'); $config['managesieve_raw_editor'] = true; The dovecot-log looks like roundcube is trying to initiate SSL3 but this is disabled. I think "Error in MANAGESIEVE command received by server." has to do with the deactivated SSL. Connecting to dovecot manually with gnutls-cli --starttls -p 4190 mail.domain.tld: Processed 306 CA certificate(s). Resolving 'mail.domain.tld:4190'... Connecting to '<IP>:4190'... - Simple Client Mode: "IMPLEMENTATION" "Dovecot Pigeonhole" "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate m ime foreverypart extracttext imapsieve vnd.dovecot.imapsieve" "NOTIFY" "mailto" "SASL" "" "STARTTLS" "VERSION" "1.0" OK "Doctor, your Tardis is ready." NO "Error in MANAGESIEVE command received by server." STARTTLS OK "Begin TLS negotiation now." *** Starting TLS handshake - Certificate type: X.509 - Got a certificate list of 2 certificates. - Certificate[0] info: - subject `CN=mail.domain.tld', issuer `CN=Let's Encrypt Authority X3,O=Let's Encrypt,C=US', serial 0x03c0d3d322307e5a997f654b435b56480773, RSA key 4096 bits, signed using RSA-SHA256, activated `2019-06-06 09:18:10 UTC', expires `2019-09-04 09:18:10 UTC', pin-sha256="8Sl17lWxWYSJcTcppQG4DLSBhEP/uRkZ5NTQfdkkoS4=" Public Key ID: sha1:62b08cf75ae6c45915db8d8c7bff6947788ac3b2 sha256:f12975ee55b1598489713729a501b80cb4818443ffb91919e4d4d07dd924a12e Public Key PIN: pin-sha256:8Sl17lWxWYSJcTcppQG4DLSBhEP/uRkZ5NTQfdkkoS4= - Certificate[1] info: - subject `CN=Let's Encrypt Authority X3,O=Let's Encrypt,C=US', issuer `CN=DST Root CA X3,O=Digital Signature Trust Co.', serial 0x0a0141420000015385736a0b85eca708, RSA key 2048 bits, signed using RSA-SHA256, activated `2016-03-17 16:40:46 UTC', expires `2021-03-17 16:40:46 UTC', pin-sha256="YLh1dUR9y6Kja30RrAn7JKnbQG/uEtLMkBgFF2Fuihg=" - Status: The certificate is trusted. - Description: (TLS1.3)-(ECDHE-SECP256R1)-(RSA-PSS-RSAE-SHA256)-(AES-256-GCM) - Options: "IMPLEMENTATION" "Dovecot Pigeonhole" "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate mime foreverypart extracttext imapsieve vnd.dovecot.imapsieve" "NOTIFY" "mailto" "SASL" "PLAIN LOGIN" "VERSION" "1.0" OK "TLS negotiation successful." LOGOUT OK "Logout completed." - Peer has closed the GnuTLS connection So, what do I have to do to get roundcube to talk to sieve?

2 2

error when enabling kolab calendar plugin, is there a fix?
by David Mehler 05 Aug '19

05 Aug '19

Hello, Trying to get kolab calendar plugin going with roundcube 1.3.9 and getting the following error, in the browser it's an error 500 in the log here's what I have, is there a fix? Thanks. Dave. #cat errors [05-Aug-2019 17:45:54 America/New_York] PHP Fatal error: Uncaught Error: Call to protected method rcmail_output_html::search_form() from context 'calendar_ui' in /usr/local/www/roundcube/plugins/calendar/lib/calendar_ui.php:795 Stack trace: #0 /usr/local/www/roundcube/program/include/rcmail_output_html.php(1145): calendar_ui->resources_search_form(Array) #1 [internal function]: rcmail_output_html->xml_command(Array) #2 /usr/local/www/roundcube/program/include/rcmail_output_html.php(1013): preg_replace_callback('/<roundcube:([-...', Array, '<roundcube:obje...') #3 /usr/local/www/roundcube/program/include/rcmail_output_html.php(634): rcmail_output_html->parse_xml('<roundcube:obje...') #4 /usr/local/www/roundcube/program/include/rcmail_output_html.php(488): rcmail_output_html->parse('calendar', false) #5 /usr/local/www/roundcube/plugins/calendar/calendar.php(333): rcmail_output_html->send('calendar.calend...') #6 /usr/local/www/roundcube/program/lib/Roundcube/rcube_plugin_api.php(493): calendar->calendar_view() #7 /usr/local/www/roundcube/index.php(295): rcube_plugin_ in /usr/local/www/roundcube/plugins/calendar/lib/calendar_ui.php on line 795

1 0

Configuring Classic for Desktop but Elastic for Phone?
by Philip Rhoades 05 Aug '19

05 Aug '19

People, Is there some way to do this? I want to stick with Classic for the Desktop because I think that is better suited but Elastic is obviously better for the phone - is there some way RCM can tell what the client is and choose the appropriate Skin? Thanks, Phil. -- Philip Rhoades PO Box 896 Cowra NSW 2794 Australia E-mail: phil(a)pricom.com.au

1 0

removing a roundcube enigma key
by David Mehler 04 Aug '19

04 Aug '19

Hello, I've got a new pgp key that I've imported with enigma. I'd now like to remove the old key, via enigma. I am not seeing how to do this. Can I get rid of the old key I know the ID via roundcube or if not can I do it via the CLI and then associate the new key ID with the profile? Thanks. Dave.

1 0

Lost Contacts Entries
by Mark Constable 04 Aug '19

04 Aug '19

Hi, I'm using 1.3.9 and recently switched my backend mailserver from an old server to a new server BUT the $config['default_host'] = 'ssl://mymail.server' setting remained exactly the same, only the IP for mymail.server was changed. I'd been caught out a few years ago when I changed default_host to a different IP and learnt the hard way and that doubled up with new user entries with the new IP and I think I sorted that out. This time the default_host setting is exactly the same. I did find a post that mentioned to run the bin/indexcontacts.sh script, which I did, and now the Contact labels and groups seem to be there but the actual contact content (name, email address etc) is missing. That contact content info looks like it's still in the database (obviously, I did not change or reinstall roundcube itself) but something to do with the id indexes for the contact content is not matching up with the addressbook entries. Any hint how I fix this or or patch it up manually if I have to? (I posted this in the forum before I found this mailing-list) -- Mark Constable 0419 530 037 https://spiderweb.com.au

4 6

publically verifying roundcube-provided gpg key?
by David Mehler 04 Aug '19

04 Aug '19

Hello, I'm running roundcube and the enigma plugin. I've created a private/public key for my user. I'd like to get that key to a keyserver so that anyone receiving the message can verify it if they want to? Thanks. Dave.

2 1

roundcube calendar
by David Mehler 01 Aug '19

01 Aug '19

Hello, Running a roundcube 1.3 setup, and wanting to get a calendar going. Is this doable? Thanks. Dave.

6 9

Re: [RCU] upgrade to php 7.3
by Andreas Meyer 30 Jul '19

30 Jul '19

Reindl Harald <h.reindl(a)thelounge.net> schrieb am 30.07.19 um 16:03:22 Uhr: > > $ php -v PHP 7.3.7 (cli) (built: Jul 3 2019 11:30:22) ( NTS ) > > Copyright (c) 1997-2018 The PHP Group Zend Engine v3.3.7, Copyright > > (c) 1998-2018 Zend Technologies with the ionCube PHP Loader + > > ionCube24 v10.3.7, Copyright (c) 2002-2019, by ionCube Ltd. with > > Zend OPcache v7.3.7, Copyright (c) 1999-2018, by Zend Technologies > > > > and on the server (I installed php 7.3 today) I get a blank screen > > > > # php -v PHP 7.3.7 (cli) (built: Jul 3 2019 11:30:22) ( NTS ) > > Copyright (c) 1997-2018 The PHP Group Zend Engine v3.3.7, Copyright > > (c) 1998-2018 Zend Technologies > > > > I also changed <IfModule mod_php5.c> to <IfModule mod_php7.c> in > > the .htaccess of roundcube but that did not change anything. > > well, don't you see the differences? got it now # php -v PHP 7.3.8 (cli) (built: Jul 30 2019 09:26:16) ( NTS ) Copyright (c) 1997-2018 The PHP Group Zend Engine v3.3.8, Copyright (c) 1998-2018 Zend Technologies with the ionCube PHP Loader + ionCube24 v10.3.7, Copyright (c) 2002-2019, by ionCube Ltd. with Zend OPcache v7.3.8, Copyright (c) 1999-2018, by Zend Technologies > > one is using *two* bytecode caches (bad idea) > the other don't run one at all > > they can make subtle differences in good and bad ways > > anyways, this is as so often not a roudcube issue so go and find out > the differences and consider some sort of config management instead of > run randomly different setups spread all over your machines > > upgrading from a random PHP5 version directly to 7.3 is pretty dumb as > you miss all the warnings and deprecation notices between minor > versions and specially 5 to 7 and didn't likely clean up your stuff > over the years > > shopuldn't be a problem with roundcube but you are running 3rd party > stuff given all the issues you had in the past years nobody else had I have it running. Started the installer again and saw there where some dependencies for php7.3 missing not ok. Installed them and didn't need to install roundcube again. Can login, the blank screen (500 server error) is gone. All is well. Thanks! -- Andreas

1 0

Re: [RCU] upgrade to php 7.3
by Andreas Meyer 30 Jul '19

30 Jul '19

Reindl Harald <h.reindl(a)thelounge.net> schrieb am 30.07.19 um 14:16:43 Uhr: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA256 > > > > Am 30.07.19 um 13:49 schrieb Andreas Meyer: > > Today I upgraded from php 5.x to php 7.3 and removed php 5.x > > completly. Now I found I get a blank screen calling roundcube. > > > > I then added error_reporting(E_ALL); ini_set('display_errors', > > 'On'); > > > > and get Notice: Undefined index: env in > > /usr/share/roundcubemail/index.php on line 46 Notice: Undefined > > variable: rcmail_config in > > /usr/share/roundcubemail/program/lib/Roundcube/rcube_config.php on > > line 325 Notice: Undefined offset: 2 in > > /usr/share/roundcubemail/program/lib/Roundcube/rcube_charset.php on > > line 223 > > > > Is there a way to fix this? Should I install roundcube form > > scratch? > > you probably did something else than just replace the PHP binaries > > we are currently on PHP 7.2 because 7.3 is far from production ready > when trivial code like below recently was broken no matter that we > have proper autotests for a 250000 LOC codebase which runs perfectly > with 7.3 and 7.4 HEAD > > so i would not be suprised that you hit a similar or this bug > > /** https://bugs.php.net/bug.php?id=78271 */ > function bug78271($a, $b) > { > if($a==10) > { > $w = "x"; > } > else > { > $w = "y"; > } > if($b) > { > $d1 = "none"; > $d2 = "block"; > } > else > { > $d1 = "block"; > $d2 = "none"; > } > return $d2.$b; > } > if(bug78271(1, 1) !== 'block1') > { > trigger_error('https://bugs.php.net/bug.php?id=78271'); > $exit_code = 1; > } > > why don't you learn to build packages for roundcube and PHP combined > with proper backups of your document roots so that you can upgrade and > downgrade and reinstall everything in a clean way? But wait, on one server with CentOS 7 on which roundcube runs fine I have $ php -v PHP 7.3.7 (cli) (built: Jul 3 2019 11:30:22) ( NTS ) Copyright (c) 1997-2018 The PHP Group Zend Engine v3.3.7, Copyright (c) 1998-2018 Zend Technologies with the ionCube PHP Loader + ionCube24 v10.3.7, Copyright (c) 2002-2019, by ionCube Ltd. with Zend OPcache v7.3.7, Copyright (c) 1999-2018, by Zend Technologies and on the server (I installed php 7.3 today) I get a blank screen # php -v PHP 7.3.7 (cli) (built: Jul 3 2019 11:30:22) ( NTS ) Copyright (c) 1997-2018 The PHP Group Zend Engine v3.3.7, Copyright (c) 1998-2018 Zend Technologies I also changed <IfModule mod_php5.c> to <IfModule mod_php7.c> in the .htaccess of roundcube but that did not change anything. -- Andreas

1 0

upgrade to php 7.3
by Andreas Meyer 30 Jul '19

30 Jul '19

Hello! Today I upgraded from php 5.x to php 7.3 and removed php 5.x completly. Now I found I get a blank screen calling roundcube. I then added error_reporting(E_ALL); ini_set('display_errors', 'On'); and get Notice: Undefined index: env in /usr/share/roundcubemail/index.php on line 46 Notice: Undefined variable: rcmail_config in /usr/share/roundcubemail/program/lib/Roundcube/rcube_config.php on line 325 Notice: Undefined offset: 2 in /usr/share/roundcubemail/program/lib/Roundcube/rcube_charset.php on line 223 Is there a way to fix this? Should I install roundcube form scratch? -- Kind regards Andreas

1 0

Re: [RCU] Login failing, Dovecot shows login followed by logout
by James Brown 24 Jul '19

24 Jul '19

On 24 Jul 2019, at 6:22 pm, Reindl Harald <h.reindl(a)thelounge.net> wrote: > > Am 24.07.19 um 10:17 schrieb James Brown: >> On 24 Jul 2019, at 6:12 pm, Reindl Harald <h.reindl(a)thelounge.net> wrote: >>> >>>> >>> >>> no, as the error message obiously states it don't try to add anything to >>> the alias field because it's not listed at all and the field is lacking >>> a default value. >>> >>> so just open phpMyAdmin and define an empty string as default for the column >>> >> >> Perfect - thanks Reindl. >> >> In Navicat for MySQL I unchecked the ’Not Null’ box and now it all works perfectly. > > NOT NULL and default value are completly different worlds > > i said make sure there is a default value and not mangle around with > random options you obviously don't understand > > https://dev.mysql.com/doc/refman/8.0/en/working-with-null.html <https://dev.mysql.com/doc/refman/8.0/en/working-with-null.html> > https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html <https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html> Thanks again Reindl. I’ve now set ‘Default Value’ to ‘EMPTY STRING’. James.

1 0

Re: [RCU] Login failing, Dovecot shows login followed by logout
by James Brown 24 Jul '19

24 Jul '19

On 24 Jul 2019, at 6:12 pm, Reindl Harald <h.reindl(a)thelounge.net> wrote: > > Am 24.07.19 um 10:08 schrieb James Brown: >> [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), ‘myuser(a)bordo.com.au', 'mail.bordo.com.au', 'en_US')) >> So looks like the problem is that it can’t add anything to the ‘alias’ field? > > no, as the error message obiously states it don't try to add anything to > the alias field because it's not listed at all and the field is lacking > a default value. > > so just open phpMyAdmin and define an empty string as default for the column > Perfect - thanks Reindl. In Navicat for MySQL I unchecked the ’Not Null’ box and now it all works perfectly. Thanks for you fast reply. James.

1 0

Re: [RCU] Login failing, Dovecot shows login followed by logout
by James Brown 24 Jul '19

24 Jul '19

OK, managed to get logging working after adding: $config['log_logins'] = 'true'; $config['log_session'] = 'yes'; $config['imap_debug'] = 'yes'; $config['log_driver'] = 'file'; When I try to login I now see this: Error in /Library/Webserver/Documents/roundcube/program/lib/Roundcube/rcube_db.php (543): [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), ‘myuser(a)bordo.com.au', 'mail.bordo.com.au', 'en_US')) PHP Error in /Library/Webserver/Documents/roundcube/program/lib/Roundcube/rcube_user.php (688): Failed to create new user PHP Error in /Library/Webserver/Documents/roundcube/program/include/rcmail.php (652): Failed to create a user record. Maybe aborted by a plugin? Logs/imap has: [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] S: * OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID ENABLE IDLE LITERAL+ AUTH=PLAIN] Dovecot ready. [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] C: A0001 ID ("name" "Roundcube" "version" "1.3.9" "php" "7.3.7" "os" "Darwin" "command" "/roundcube/?_task=login") [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] S: * ID ("name" "Dovecot") [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] S: A0001 OK ID completed. [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] C: A0002 AUTHENTICATE PLAIN ****** [53] [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] S: A0002 OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE SNIPPET=FUZZY LITERAL+ NOTIFY SPECIAL-USE] Logged in [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] C: A0003 NAMESPACE [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] S: * NAMESPACE (("" ".")) NIL NIL [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] S: A0003 OK Namespace completed (0.001 + 0.000 secs). [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] C: A0004 LOGOUT [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] S: * BYE Logging out [24-Jul-2019 07:35:53 +0000]: <pg7kv1kp> [6E3B] S: A0004 OK Logout completed (0.001 + 0.000 secs). [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] S: * OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID ENABLE IDLE LITERAL+ AUTH=PLAIN] Dovecot ready. [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] C: A0001 ID ("name" "Roundcube" "version" "1.3.9" "php" "7.3.7" "os" "Darwin" "command" "/roundcube/?_task=login") [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] S: * ID ("name" "Dovecot") [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] S: A0001 OK ID completed. [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] C: A0002 AUTHENTICATE PLAIN ****** [53] [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] S: A0002 OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE SNIPPET=FUZZY LITERAL+ NOTIFY SPECIAL-USE] Logged in [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] C: A0003 NAMESPACE [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] S: * NAMESPACE (("" ".")) NIL NIL [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] S: A0003 OK Namespace completed (0.001 + 0.000 secs). [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] C: A0004 LOGOUT [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] S: * BYE Logging out [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> [2773] S: A0004 OK Logout completed (0.001 + 0.000 secs). Logs/userlogins has: [24-Jul-2019 07:52:15 +0000]: <pg7kv1kp> Failed login for myuser(a)bordo.com.au from 192.168.1.27 in session pg7kv1kplhbj81992hl94qht0m (error: 1) [24-Jul-2019 07:52:19 +0000]: <pg7kv1kp> Failed login for myuser(a)bordo.com.au from 192.168.1.27 in session pg7kv1kplhbj81992hl94qht0m (error: 0) So looks like the problem is that it can’t add anything to the ‘alias’ field? How can I fix that? Many thanks, James. On 23 Jul 2019, at 11:52 pm, James Brown <jlbrown(a)bordo.com.au> wrote: > > Running Roundcube 1.3.9, Dovecot 2.3.6 and mySQL 5.7.26 > > Dovecot log: > > Jul 23 23:07:15 imap-login: Info: Login: user=<myuser(a)bordo.com.au>, method=PLAIN, rip=192.168.1.27, lip=192.168.1.9, mpid=32877, TLS, session=<dJoh34iOicjAqAEb> > Jul 23 23:07:15 imap(myuser(a)bordo.com.au)<32877><dJoh34iOicjAqAEb>: Info: Logged out in=29 out=529 deleted=0 expunged=0 trashed=0 hdr_count=0 hdr_bytes=0 body_count=0 body_bytes=0 > > But Roundcube web login page says: > > Login failed. > > Nothing is logged to Roundcube’s logs. > > Any suggestions? > > Thanks, > > James. > _______________________________________________ > Roundcube Users mailing list > users(a)lists.roundcube.net > http://lists.roundcube.net/mailman/listinfo/users

1 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Users