• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

After update to Plesk 11.5 Courier IMAP no longer works.

H

hgmichna

Basic Pleskian
OS: Debian 6.0.6
Panel version: 11.5.30 Update #11 (updated from 11.0)

The two services "Courier IMAP server" and "Courier IMAP server with SSL/TLS support" are not running, and trying to start them has no effect.

Is this a known defect? Is there a workaround? Do you need more information?

Needless to say, this is a catastrophe for my mail users.

Hans


From psa-horde.log:

2013-08-11T11:02:17+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'imp_sentmail_seq'
DROP TABLE `imp_sentmail_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:18+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'ingo_rules_seq'
DROP TABLE `ingo_rules_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:18+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'ingo_shares_seq'
DROP TABLE `ingo_shares_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:18+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.rampage_types' doesn't exist
SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN
('calendar','event') [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:21+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_groups_seq'
DROP TABLE `horde_groups_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:21+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_perms_seq'
DROP TABLE `horde_perms_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:21+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_vfs_seq'
DROP TABLE `horde_vfs_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:21+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_muvfs_seq'
DROP TABLE `horde_muvfs_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:23+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'kronolith_resources_seq'
DROP TABLE `kronolith_resources_seq` [pid 14883 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:03:50+00:00 EMERG: HORDE User is not authorized for horde [pid 18012 on line 267 of "/usr/share/psa-pear/pear/php/Horde/Registry.php"]
2013-08-11T11:04:32+00:00 EMERG: HORDE User is not authorized for horde [pid 18699 on line 267 of "/usr/share/psa-pear/pear/php/Horde/Registry.php"]
2013-08-11T11:07:08+00:00 EMERG: HORDE User is not authorized for horde [pid 19648 on line 267 of "/usr/share/psa-pear/pear/php/Horde/Registry.php"]
 
hgmichna said:
OS: Debian 6.0.6
Panel version: 11.5.30 Update #11 (updated from 11.0)

The two services "Courier IMAP server" and "Courier IMAP server with SSL/TLS support" are not running, and trying to start them has no effect.

Is this a known defect? Is there a workaround? Do you need more information?

Needless to say, this is a catastrophe for my mail users.

Hans


From psa-horde.log:

2013-08-11T11:02:17+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'imp_sentmail_seq'
DROP TABLE `imp_sentmail_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:18+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'ingo_rules_seq'
DROP TABLE `ingo_rules_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:18+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'ingo_shares_seq'
DROP TABLE `ingo_shares_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:18+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.rampage_types' doesn't exist
SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN
('calendar','event') [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:21+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_groups_seq'
DROP TABLE `horde_groups_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:21+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_perms_seq'
DROP TABLE `horde_perms_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:21+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_vfs_seq'
DROP TABLE `horde_vfs_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:21+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_muvfs_seq'
DROP TABLE `horde_muvfs_seq` [pid 14847 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:02:23+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'kronolith_resources_seq'
DROP TABLE `kronolith_resources_seq` [pid 14883 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-11T11:03:50+00:00 EMERG: HORDE User is not authorized for horde [pid 18012 on line 267 of "/usr/share/psa-pear/pear/php/Horde/Registry.php"]
2013-08-11T11:04:32+00:00 EMERG: HORDE User is not authorized for horde [pid 18699 on line 267 of "/usr/share/psa-pear/pear/php/Horde/Registry.php"]
2013-08-11T11:07:08+00:00 EMERG: HORDE User is not authorized for horde [pid 19648 on line 267 of "/usr/share/psa-pear/pear/php/Horde/Registry.php"]
Click to expand...

It might be two different problems.
What do you mean "trying to start them has no effect"? Are the services started?
Try to login to host imap with telnet for example.
Also look into /usr/local/psa/var/log/maillog, there might by any related errors.
 
igor.A. said:
It might be two different problems.
What do you mean "trying to start them has no effect"? Are the services started?
Click to expand...

The two services "Courier IMAP server" and "Courier IMAP server with SSL/TLS support" are not running, and trying to start them has no effect. When I go to the Services Management page in Plesk and click on the start icon for either of the two services, nothing happens. The services are still not running. Their icons on the left side do not show the green check mark, but remain grey.

igor.A. said:
Try to login to host imap with telnet for example.
Click to expand...

I entered: telnet linkcafe.org imap

The result was that a connection to the IMAP port could not be established. This was to be expected, as the IMAP services are not running.

igor.A. said:
Also look into /usr/local/psa/var/log/maillog, there might by any related errors.
Click to expand...

/usr/local/psa/var/log/maillog looks normal. I can send emails without any problems, and POP3 also works fine.

Only IMAP is failing since the upgrade to Plesk 11.5.30. It seems to me that the cause is indicated in the psa-horde.log (see above), where the IMAP service complains about being unable to find any of its MySQL tables.

I would be very grateful for a solution to this nasty problem.
 
hgmichna said:
The two services "Courier IMAP server" and "Courier IMAP server with SSL/TLS support" are not running, and trying to start them has no effect. When I go to the Services Management page in Plesk and click on the start icon for either of the two services, nothing happens. The services are still not running. Their icons on the left side do not show the green check mark, but remain grey.
Click to expand...
what is the output of:
Code: 
# /etc/init.d/courier-imapd start
# /etc/init.d/courier-imaps start
?
 
igor.A. said:
what is the output of:
Code: 
# /etc/init.d/courier-imapd start
# /etc/init.d/courier-imaps start
?
Click to expand...

Each of the commands only yields a one-line output:

/etc/init.d/courier-imapd start
Starting Courier IMAP server: courierlogger.

/etc/init.d/courier-imaps start
Starting Courier IMAP server with SSL/TLS support: courierlogger.

However, contrary to what they say, the services do not actually start, and Horde still cannot let any user log on.

Is there any particular log file you would like to see?

Hans
 
Since it is my email server that does not work, I cannot easily get at my own incoming mail. My alternative mail address is hgmich©gmail.com (retype, don't copy). Can I reach you by email at a parallels.com address?
 
Solved

I was confused by some error messages in the logs, which did not have anything to do with the malfunction.

I received a second Plesk update and applied it in the hope that it might repair the damage. I am not sure whether that actually happened, but I found that one of the updates had overwritten several IMAP settings that are essential, particularly the pointer to the SSL certificate. Some other IMAP default settings are also deleterious. These are my changes:

Note: cert-7kNods is my self-signed mail certificate.

1. SMTP

postfix

Renamed /etc/postfix/postfix_default.pem to postfix_default_original.pem
Copied /usr/local/psa/var/certificates/cert-7kNods
to /etc/postfix/postfix_default.pem
Entered /etc/init.d/postfix reload


2. POP3 and IMAP

For courier-imap made the following change in the following 2 files:
/etc/courier-imap/pop3d-ssl
/etc/courier-imap/imapd-ssl

#TLS_CERTFILE=/usr/share/courier.../....d.pem
TLS_CERTFILE=/usr/local/psa/var/certificates/cert-7kNods


----- IMAP Configuration -----

Some of the following settings (MAX…) are absolutely essential for a
loaded mail server, some others are merely a matter of taste.

MAXPERIP must be increased to a fairly high number, because each client
typically has at least 4 connections, and multiple clients can be behind
one NAT router.
Settings changed in:

/etc/courier-imap/imapd

##NAME: MAXDAEMONS:0
#
# Maximum number of IMAP servers started
#
#
# DEFAULT SETTING from /etc/courier-imap/imapd.dist:
#
#MAXDAEMONS=40
#

MAXDAEMONS=256

##NAME: MAXPERIP:0
#
# Maximum number of connections to accept from the same IP address
#
# DEFAULT SETTING from /etc/courier-imap/imapd.dist:
#
#MAXPERIP=4
#

MAXPERIP=128

# ...

##NAME: IMAP_CHECK_ALL_FOLDERS:0
#
# Set IMAP_CHECK_ALL_FOLDERS to 1 if you want the server to check for new
# mail in every folder. Not all IMAP clients use the IMAP's new mail
# indicator, but some do. Normally new mail is checked only in INBOX,
# because it is a comparatively time consuming operation, and it would be
# a complete waste of time unless mail filters are used to deliver
# mail directly to folders.
#
# When IMAP clients are used which support new mail indication, and when
# mail filters are used to sort incoming mail into folders, setting
# IMAP_CHECK_ALL_FOLDERS to 1 will allow IMAP clients to announce new
# mail in folders. Note that this will result in slightly more load on the
# server.
#

#IMAP_CHECK_ALL_FOLDERS=0
IMAP_CHECK_ALL_FOLDERS=1

# ...

##NAME: IMAP_ENHANCEDIDLE:0
#
# If Courier was compiled with the File Alteration Monitor, setting
# IMAP_ENHANCEDIDLE to 1 enables enhanced IDLE mode, where multiple
# clients may open the same folder concurrently, and receive updates to
# folder contents in realtime. See the imapd(8) man page for additional
# information.
#
# IMPORTANT: IMAP_USELOCKS *MUST* also be set to 1, and IDLE must be included
# in the IMAP_CAPABILITY list.
#
#
# DEFAULT SETTING from /etc/courier-imap/imapd.dist:
#
#IMAP_ENHANCEDIDLE=0
#

IMAP_ENHANCEDIDLE=1

# ...

##NAME: IMAP_EMPTYTRASH:0
#
# The following setting is optional, and causes messages from the given
# folder to be automatically deleted after the given number of days.
# IMAP_EMPTYTRASH is a comma-separated list of folder:days. The default
# setting, below, purges 7 day old messages from the Trash folder.
# Another useful setting would be:
#
# IMAP_EMPTYTRASH=Trash:7,Sent:30
#
# This would also delete messages from the Sent folder (presumably copies
# of sent mail) after 30 days. This is a global setting that is applied to
# every mail account, and is probably useful in a controlled, corporate
# environment.
#
# Important: the purging is controlled by CTIME, not MTIME (the file time
# as shown by ls). It is perfectly ordinary to see stuff in Trash that's
# a year old. That's the file modification time, MTIME, that's displayed.
# This is generally when the message was originally delivered to this
# mailbox. Purging is controlled by a different timestamp, CTIME, which is
# changed when the file is moved to the Trash folder (and at other times too).
#
# You might want to disable this setting in certain situations - it results
# in a stat() of every file in each folder, at login and logout.
#
#
# DEFAULT SETTING from /etc/courier-imap/imapd.dist:
#
#IMAP_EMPTYTRASH=Trash:7
#

IMAP_EMPTYTRASH=Trash:99
 
Thank you so much, I was able to get IMAP up and running but am unable to start IMAPS. I am using the default Cert not my own though. Are you able to post any suggestions? Google brings up ZIP...
 
You must log in or register to reply here.

Similar threads

nethubonline
Resolved Plesk install failure on AlmaLinux 9
Replies
3
Views
1K
nethubonline
nethubonline
L
Issue ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [14] unable to open database file (Abstract.php:144)
Replies
3
Views
2K
mow
M
M
Issue Error after trying to update to obsidian
Replies
4
Views
1K
McCoy
M
R
Resolved MYSQL server loses connection while trying to drop psa database to import dump.
Replies
1
Views
2K
RMoto
R
Endre
Issue Server Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
15
Views
7K
MihaiNecreala
M
Back
Top