Email Server Setup: Table mailserver.users doesn't exist
It isn't working. My mail.log includes this error:
dovecot: auth-worker(9629): Error: sql(
I've checked the instructions, and I don't see any designation of a user_query value in the Dovecot (nor Postfix) configuration. I don't have a table 'user' as the instructions don't call for creation of one.
Any help would be appreciated.
2 Replies
If the mailserver database isn't there then you need to see what you may have missed during your installation.
MSJ
NOTE that creation of this table is not mentioned in the (excellent) Linode Library piece on Postfix, Dovecot and Mysql. Neither is addition of lines to the main Dovecot configuration file setting namespace – these are:
namespace inbox {
inbox = yes
}
I suggest updating the guides for these omissions. I would also suggest noting in them 1) the date of the latest update (might already be there) 2) the version numbers of the Postfix, Dovecot and MySQL installations used. The latter would help readers quickly check to see if they are in some other version, and possibly need to capture upgrades in their configurations.