Webmail not working for just one particular email address

Operating System & Version
CloudLinux v7.9.0 STANDARD
cPanel & WHM Version
106.0.10

cpanzy

Member
Oct 2, 2005
21
0
151
Webmail for one email address does not work, when clicking on the "Check Email" for that address on the email accounts page in cpanel, I get a page:

"
The page isn’t redirecting properly

An error occurred during a connection to srv.example.com:2096.

This problem can sometimes be caused by disabling or refusing to accept cookies.
"

For other email addresses on that same domain the webmail is loading correctly.

I have tried renaming the dovecot.index file for that email account but that does not help.
I have tried "doveadm force-resync -u [email protected] INBOX" which recreates the dovecot.index file but does not help.

I can access the email account via IMAP in an email client okay.
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
13,427
2,113
363
cPanel Access Level
Root Administrator
Hey there! Do you see anything in the cPanel error log at /usr/local/cpanel/logs/error_log when you access that user's account? That is the most likely log to provide you with better details on troubleshooting this behavior.
 

cpanzy

Member
Oct 2, 2005
21
0
151
Hi! No there is nothing in that error log when I try and access that accounts webmail
 

cpanzy

Member
Oct 2, 2005
21
0
151
In /var /log /maillog I get these entries when try to access the webmail just once:


Nov 29 08:21:09 srv dovecot: imap-login: Login: <[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961677, secured, session=<uFo3c47uIOIAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:09 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961679, TLS, session=<9mw6c47uPL4AAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:09 srv dovecot: imap([email protected])<2961679><9mw6c47uPL4AAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=12, out=522, bytes=12/522

Nov 29 08:21:09 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961683, TLS, session=<mu87c47uSr4AAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:09 srv dovecot: imap([email protected])<2961683><mu87c47uSr4AAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=12, out=522, bytes=12/522

Nov 29 08:21:09 srv dovecot: imap([email protected])<2961677><uFo3c47uIOIAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:09 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961686, secured, session=<6ts9c47uPOIAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:10 srv dovecot: imap([email protected])<2961686><6ts9c47uPOIAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:10 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961694, secured, session=<qYNDc47uVOIAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:10 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961701, TLS, session=<J7BGc47udL4AAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:10 srv dovecot: imap([email protected])<2961701><J7BGc47udL4AAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=12, out=522, bytes=12/522

Nov 29 08:21:10 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961707, TLS, session=<djdIc47ugr4AAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:10 srv dovecot: imap([email protected])<2961707><djdIc47ugr4AAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=12, out=522, bytes=12/522

Nov 29 08:21:10 srv dovecot: imap([email protected])<2961694><qYNDc47uVOIAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:10 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961709, secured, session=<ubZJc47ucOIAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:10 srv dovecot: imap([email protected])<2961709><ubZJc47ucOIAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:10 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961722, secured, session=<sGNPc47uiOIAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:11 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961725, TLS, session=<8h5Sc47uqL4AAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:11 srv dovecot: imap([email protected])<2961725><8h5Sc47uqL4AAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=12, out=522, bytes=12/522

Nov 29 08:21:11 srv dovecot: imap([email protected])<2961722><sGNPc47uiOIAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:11 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961730, secured, session=<0hFVc47uouIAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:11 srv dovecot: imap([email protected])<2961730><0hFVc47uouIAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:11 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961740, secured, session=<wG9ac47uuuIAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:11 srv dovecot: imap([email protected])<2961740><wG9ac47uuuIAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:12 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961750, secured, session=<BIdgc47u1OIAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:12 srv dovecot: imap([email protected])<2961750><BIdgc47u1OIAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:12 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961757, secured, session=<nYhlc47u7OIAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:12 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961763, TLS, session=<CNZoc47uEL8AAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:12 srv dovecot: imap([email protected])<2961763><CNZoc47uEL8AAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=12, out=522, bytes=12/522

Nov 29 08:21:12 srv dovecot: imap([email protected])<2961757><nYhlc47u7OIAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:12 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961767, secured, session=<jEZrc47uBuMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:12 srv dovecot: imap([email protected])<2961767><jEZrc47uBuMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:13 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961774, secured, session=<8ilwc47uHuMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:13 srv dovecot: imap([email protected])<2961774><8ilwc47uHuMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:13 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961782, secured, session=<Ihp1c47uNuMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:13 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961787, TLS, session=<sQ94c47uWr8AAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:13 srv dovecot: imap([email protected])<2961787><sQ94c47uWr8AAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=12, out=522, bytes=12/522

Nov 29 08:21:13 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961791, TLS, session=<t/V4c47uZr8AAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:13 srv dovecot: imap([email protected])<2961791><t/V4c47uZr8AAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=12, out=522, bytes=12/522

Nov 29 08:21:13 srv dovecot: imap([email protected])<2961782><Ihp1c47uNuMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:13 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961793, secured, session=<wXd6c47uVOMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:13 srv dovecot: imap([email protected])<2961793><wXd6c47uVOMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:14 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961801, secured, session=<aMN/c47ubOMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:14 srv dovecot: imap([email protected])<2961801><aMN/c47ubOMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:14 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961810, secured, session=<pl2Fc47uhuMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:14 srv dovecot: imap([email protected])<2961810><pl2Fc47uhuMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:14 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961819, secured, session=<PWeKc47uoOMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:15 srv dovecot: imap([email protected])<2961819><PWeKc47uoOMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:15 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961828, secured, session=<iJKPc47uuOMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:15 srv dovecot: imap([email protected])<2961828><iJKPc47uuOMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:15 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961838, secured, session=<FICUc47u0OMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:15 srv dovecot: imap([email protected])<2961838><FICUc47u0OMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:15 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961845, secured, session=<+36Zc47u6OMAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:16 srv dovecot: imap([email protected])<2961845><+36Zc47u6OMAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913

Nov 29 08:21:16 srv dovecot: imap-login: Login: </[email protected]'><[email protected]'>user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=2961856, secured, session=<H2+fc47uAOQAAAAAAAAAAAAAAAAAAAAB>

Nov 29 08:21:16 srv dovecot: imap([email protected])<2961856><H2+fc47uAOQAAAAAAAAAAAAAAAAAAAAB>: Disconnected: Logged out in=82, out=913, bytes=82/913
 

cpanzy

Member
Oct 2, 2005
21
0
151
I move the account to another server to test. The one email account still fails to load webmail, while the other email accounts load webmail okay. On the failed webmail load, the page now returns:


Oops... something went wrong!
An internal error has occurred. Your request cannot be processed at this time.

For administrators: Please check the application and/or server error logs for more information.
 

cpanzy

Member
Oct 2, 2005
21
0
151
When i check in the users log file /home/username/logs/.php.error.log :

[04-Dec-2022 22:41:44 Australia/Sydney] PHP Fatal error: Uncaught Error: Wrong parameters for MStilkerich\CardDavAddressbook4Roundcube\Db\DatabaseException([string $message [, long $code [, Throwable $previous = NULL]]]) in /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/src/Db/Database.php:112
Stack trace:
#0 /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/src/Db/Database.php(112): Exception->__construct(NULL)
#1 /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/carddav.php(1169): MStilkerich\CardDavAddressbook4Roundcube\Db\Database->startTransaction(false)
#2 /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/carddav.php(339): carddav->deleteAddressbook('1')
#3 /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_plugin_api.php(513): carddav->initPresets(Array)
#4 /usr/local/cpanel/base/3rdparty/roundcube/index.php(155): rcube_plugin_api->exec_hook('login_after', Array)
#5 {main}
thrown in /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/src/Db/Database.php on line 112
 

exone

Registered
Dec 12, 2022
4
0
1
Poland
cPanel Access Level
DataCenter Provider
We have exactly the same problem. Webmail not work for some users.

/home/username/logs/roundcube/errors.log
[12-Dec-2022 13:14:20 +0100]: <2e5ebab2> DB Error: [19] NOT NULL constraint failed: carddav_addressbooks2.last_updated (SQL Query: UPDATE carddav_addressbooks2 SET last_updated=strftime('%s', last_updated)) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 566 (GET /cpsess0642668097/3rdparty/roundcube/index.php?_task=mail&_token=GqqrtgYOXl0p3DFkIGN2ZcGDqf8gW2dA)
[12-Dec-2022 13:22:44 +0100]: <b63d1599> DB Error: [19] NOT NULL constraint failed: carddav_addressbooks2.last_updated (SQL Query: UPDATE carddav_addressbooks2 SET last_updated=strftime('%s', last_updated)) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 566 (GET /cpsess8719983567/3rdparty/roundcube/index.php?login=1&post_login=48062845321127)
[12-Dec-2022 13:22:44 Europe/Warsaw] PHP Fatal error: Uncaught Error: Wrong parameters for MStilkerich\CardDavAddressbook4Roundcube\Db\DatabaseException([string $message [, long $code [, Throwable $previous = NULL]]]) in /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/src/Db/Database.php:112
Stack trace:
#0 /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/src/Db/Database.php(112): Exception->__construct(NULL)
#1 /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/carddav.php(1169): MStilkerich\CardDavAddressbook4Roundcube\Db\Database->startTransaction(false)
#2 /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/carddav.php(339): carddav->deleteAddressbook('1')
#3 /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_plugin_api.php(513): carddav->initPresets(Array)
#4 /usr/local/cpanel/base/3rdparty/roundcube/index.php(155): rcube_plugin_api->exec_hook('login_after', Array)
#5 {main}
thrown in /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/src/Db/Database.php on line 112
 

exone

Registered
Dec 12, 2022
4
0
1
Poland
cPanel Access Level
DataCenter Provider
The sqlite database for roundcube is corrupted. If I delete all the /home/username/etc/username.rcube.* files, webmail starts working.

How to repair rcube.db without losing contacts?
 
Last edited:

exone

Registered
Dec 12, 2022
4
0
1
Poland
cPanel Access Level
DataCenter Provider
I tested all copies of sqlite username.rcube.db.* but unfortunately it didn't help.
The problem may not even be a damaged sqlite database but a plugin in roundcube.

I disabled the carddav plugin in /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php and webmail starts working :)

This is a problem I think is carddav plugin or sqlite database in the sense that the table schema is not consistent with the carddav plugin DB Error: [19] NOT NULL constraint failed".

[12-Dec-2022 13:14:19 +0100]: <c3019954> DB Error: [19] NOT NULL constraint failed: carddav_addressbooks2.last_updated (SQL Query: UPDATE carddav_addressbooks2 SET last_updated=strftime('%s', last_updated)) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 566 (GET /cpsess0642668097/3rdparty/roundcube/index.php?_task=mail&_token=lnJ3BVGBPPTlGok6ctIFsQFrAk3QaDn7)
[12-Dec-2022 13:14:19 +0100]: <bcb764c2> DB Error: [19] NOT NULL constraint failed: carddav_addressbooks2.last_updated (SQL Query: UPDATE carddav_addressbooks2 SET last_updated=strftime('%s', last_updated)) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 566 (GET /cpsess0642668097/3rdparty/roundcube/index.php?_task=mail&_token=pT4FRg0rJidsgJRLPYleOhbAs44F1N08)
[12-Dec-2022 13:14:20 +0100]: <2e5ebab2> DB Error: [19] NOT NULL constraint failed: carddav_addressbooks2.last_updated (SQL Query: UPDATE carddav_addressbooks2 SET last_updated=strftime('%s', last_updated)) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 566 (GET /cpsess0642668097/3rdparty/roundcube/index.php?_task=mail&_token=GqqrtgYOXl0p3DFkIGN2ZcGDqf8gW2dA)
[12-Dec-2022 13:22:44 +0100]: <b63d1599> DB Error: [19] NOT NULL constraint failed: carddav_addressbooks2.last_updated (SQL Query: UPDATE carddav_addressbooks2 SET last_updated=strftime('%s', last_updated)) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 566 (GET /cpsess8719983567/3rdparty/roundcube/index.php?login=1&post_login=48062845321127)
 

weetabix

Well-Known Member
Oct 26, 2006
68
7
158
Last edited:

weetabix

Well-Known Member
Oct 26, 2006
68
7
158
@weetabix - what file did you change? If it somehow got the roundcube databases out of sync, it might be easiest to restore from a backup.
I did exactly this;
Starting in this folder:

/home/<cpanel_user>/etc/<domain>/
To restore to a previous version, either from the automatic copies made, or from a backup

  1. Rename the file <email_user>.rcube.db to <email_user>.rcube.db.bak or move it out of the folder
  2. Rename <email_user>.rcube.db.<number_stamp> (use the most recent copy first based on timestamp) to <email_user>.rcube.db
  3. Attempt to access RoundCube again
I used the newest timestamp. What should I try to restore from backup? That same file?