Users July 2019

users@lists.roundcube.net

8 participants
20 discussions

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

23 Jul '19

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 <mailto:myuser@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 <mailto:myuser@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.

1 0

roundcube force change password every x days
by David Mehler 22 Jul '19

22 Jul '19

Hello, I'm running a virtual mail system with Postfix and Mysql and using roundcube. I am wondering if there's a way to force users to change their passwords every x days? None of the users have shell access, the only interact by roundcube. Thanks. Dave.

1 0

Configure Enigma plugin with ie11 shows no output in window
by David Mehler 21 Jul '19

21 Jul '19

Hello, I got enigma plugin going. I atempted via ie11 on win10 x64 to configure the enigma plugin. I went to settings, > preferences, > and atempted to access encryption. It showed a blank output window. I went in to chrome latest I believe did the same thing and got options I could configure. Is there a roundcube/ie11 issue with content display? A side note on chrome after setting the encryption and identity options I was able to generate and associate a gpg key with my account. Any info on the ie11 issue appreciated. Thanks. Dave.

1 0

list view
by mick crane 12 Jul '19

12 Jul '19

hello, Roundcube Webmail 1.4-rc1 here I've noticed that if I select list view in Inbox and then drag a thread [+thread] to another folder (not in list view) and then move messages back to Inbox the threading is lost. Meaning the messages are in a thread but click arrow bottom right and next message is outside the thread. Is a minor issue and I never did that before but thought I would mention it. mick -- Key ID 4BFEBB31

1 0

Sorting after date
by Andreas Meyer 11 Jul '19

11 Jul '19

Hello! Using version 1.3.9 of Roundcube. When I change the sorting of email in a folder from ascending to descending or viseversa, email of different dates are shown. Is there a limit somewhere how many mail is shown depending on sorting? Kind regards Andreas

1 0

"Mark as junk" functionality
by nux＠li.nux.ro 10 Jul '19

10 Jul '19

Hello, I'm on 1.4-rc, want to have a "mark as spam" button, however the plugin[1] for this seems unmaintained any more as apparently the functionality is in Roundcube itself. The question is, how do I enable it? Thanks [1] - https://plugins.roundcube.net/packages/johndoh/markasjunk2

1 0

All the Email addresses disappeared out of the Contacts table!
by Philip Rhoades 05 Jul '19

05 Jul '19

People, I sent out an email three nights ago to two of my group lists and that worked fine. Since then I have been probably only replying to individual emails that came in and that has also been fine. Today I tried to send new emails and realised that the list of addresses is not appearing as I type in the "To:" field - and when I look at the contacts table with psql, I see all the email fields are now empty! How could this happen? I can recover most of the email addresses from backups and restore them but this is a fairly scary occurrence and I would like to work out what happened . . I have not had this happen ever before in all the years I have been using RCM . . I have had some issues on the workstation but the server has been stable . . (both are Fedora 30 x86_64). Thanks, Phil. -- Philip Rhoades PO Box 896 Cowra NSW 2794 Australia E-mail: phil(a)pricom.com.au

1 1

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Users July 2019