mirror of
https://github.com/modoboa/modoboa.git
synced 2026-04-27 18:05:58 +03:00
[GH-ISSUE #1653] mail dovecot auth to pgsql failed #1302
Labels
No labels
bug
bug
dependencies
design
documentation
duplicate
enhancement
enhancement
enhancement
feedback-needed
help-needed
help-needed
installer
invalid
looking-for-sponsors
modoboa-contacts
new-ui
new-ui
pr
pull-request
pyconfr
python
question
security
stale
webmail
wontfix
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/modoboa-modoboa#1302
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @jkorac on GitHub (Jan 9, 2019).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/1653
Impacted versions
Steps to reproduce
Create new user and email on Modoboa
Fetch mail from Modoboa installation using IMAP with SSL
In:
/var/lib/pgsql/data/postgresql.conftried to fiddle with
max_locks_per_transactionmax_connectionswe've put 1500 as the max connections available. No change.
Current behavior
Error happens every several minutes (~30min):
user@domain.tld.cfg: credential/login error ([UNAVAILABLE] Temporary authentication failure.From log file:
mail dovecot: auth: Warning: pgsql: Query failed, retrying:Password query failed: Not connected to databaseExpected behavior
Should work without failed attempts to reach the db.
(optional)
Is there a painless process to migrate databases from PostgreSQL to mySQL?
@tonioo commented on GitHub (Jan 9, 2019):
@jkorac How many users do you host? Are you monitoring the number of active postgres connections?
About migrating to mysql, you can try with the 2 following commands:
but I don't guarantee it will work.
@jkorac commented on GitHub (Jan 9, 2019):
@tonioo we are currently running a test system with approx 50 active users. Pgsql log is constantly monitored, level = debug1. Connection limit for pgsql is set @ 1500. Re: migration - are the db/table structures the same for pgsql & mysql installations? If not, simple dump and import would not help. Has anyone tried that b4?
@tonioo commented on GitHub (Jan 9, 2019):
And what is the average number of active connections?
Structures are the same.
@jkorac commented on GitHub (Jan 10, 2019):
@tonioo all users are actively connected to modoboa server. Connections are set @ 2 minutes with imap (ssl). We have tried plain imap, pop with ssl, and plain pop with same results. We believe there is a problem with postgre db. Tonight we will try to migrate dbs to mysql to test it out. Do you have some hints to share in relation with migration?
@jkorac commented on GitHub (Jan 14, 2019):
Still without solution.
We have tried several things, so here is feedback:
a) dumpdata does incomplete job
It doesn't work.
b) after switching pgsql with mysql installation was in ruins. There were too many errors in system, all pointing to a missing connection with postgre, even though we did everything to plug it out. Nothing worked, in short.
(auto)Installer with mysql doesn't exist on github
If there is, I kindly ask to point me to it so we could try that way.
Manual Installation of modoboa using mysql is incomplete
There is a lot of missing information and packets during this process. Also, documentation is scarce about manual installation with mysql, and there are steps missing. Is there any valid documentation or at least some kind of step-by-step that might help us out here?
Trying different methods
We also tried to use different methods of authentication. We tried to connect with plain IMAP, POP with SSL, or plain POP. Problem persists.
Last thing we did, we tried to reach modoboa with several different clients from different systems: Thunderbird, Outlook, Gmail app, Apple mail (mojave), and our server. With every combination of client and method gives the same problem:
@tonioo commented on GitHub (Jan 18, 2019):
@jkorac FYI, the official installer does support mysql. You only have to modify the installer.cfg file, look at the database section.
About manual installation, if you think it's incomplete, please provide a PR containing documentation fixes, I'd glad to approve it :)
@jkorac commented on GitHub (Jan 25, 2019):
Problem solved.
Installing and using MySQL instead solved the problem.
We managed to manually install modoboa with mysql. I don't know what went wrong last time, I wasn't there, but we did it! I'm still waiting for the documentation, if I'll ever get one.
@tonioo commented on GitHub (Jan 31, 2019):
@jkorac Feel free to open a new PR about the documentation or an issue.