felix.schwarz at web.de
2004-Jul-21 15:48 UTC
[Dovecot] Fatal: Unknown userdb type 'pgsql'
Hello,
I'm trying to use postgres authentication with dovecot on a linux
system running Fedora Core 2. Installation of dovecot was done by
installing the rpm included in the fedora distribution ("yum install
dovecot").
from /etc/dovecot.conf
auth_userdb = pgsql /etc/dovecot-pgsql.conf
auth_passdb = pgsql /etc/dovecot-pgsql.conf
but the logs tell me:
dovecot: Jul 21 19:28:39 Info: Dovecot starting up
dovecot-auth: Jul 21 19:28:40 Fatal: Unknown userdb type 'pgsql'
dovecot: Jul 21 19:28:40 Error: Auth process died too early - shutting down
dovecot: Jul 21 19:28:40 Error: child 5229 (auth) returned error 89
imap-login: Jul 21 19:28:40 Fatal: fd_send(-1) failed: Broken pipe
imap-login: Jul 21 19:28:40 Fatal: fd_send(-1) failed: Broken pipe
I think that the fedora rpm was compiled without postgresql support.
- Is the information given above sufficient for an educated guess?
- Would that lead to the above error message?
- What other errors may cause this behavior?
- How can I check which authentification types are supported by my dovecot-auth?
- Are there any other Fedora rpms compiled with postgres support available on
the net?
thank you for your help :-)
--
Felix
Yep - looks like it was compiled without the pgsql support. I've just pull the latest Fedora SRPM from rpmfind.net and --with-pgsql is not mentioned in the SPEC file. Best grab the SRPM yourself and unpack, add --with-pgsql to the configure line in the SPEC file and rebuild - should do the job. Tim Best bet is On Wed, 21 Jul 2004 17:48:11 +0200 felix.schwarz at web.de wrote:> Hello, > > I'm trying to use postgres authentication with dovecot on a linux > system running Fedora Core 2. Installation of dovecot was done by > installing the rpm included in the fedora distribution ("yum install > dovecot"). > > from /etc/dovecot.conf > auth_userdb = pgsql /etc/dovecot-pgsql.conf > auth_passdb = pgsql /etc/dovecot-pgsql.conf > > but the logs tell me: > dovecot: Jul 21 19:28:39 Info: Dovecot starting up > dovecot-auth: Jul 21 19:28:40 Fatal: Unknown userdb type 'pgsql' > dovecot: Jul 21 19:28:40 Error: Auth process died too early - shutting > down dovecot: Jul 21 19:28:40 Error: child 5229 (auth) returned error > 89 imap-login: Jul 21 19:28:40 Fatal: fd_send(-1) failed: Broken pipe > imap-login: Jul 21 19:28:40 Fatal: fd_send(-1) failed: Broken pipe > > I think that the fedora rpm was compiled without postgresql support. > - Is the information given above sufficient for an educated guess? > - Would that lead to the above error message? > - What other errors may cause this behavior? > - How can I check which authentification types are supported by my > dovecot-auth?- Are there any other Fedora rpms compiled with postgres > support available on the net? > > thank you for your help :-) > > -- > Felix >-- Mr Tim J Southerwood Senior Programmer CSG, Dept of Computing, Imperial College, London Email personal: ts at dionic.net work: ts at doc.ic.ac.uk Tel home: +44 (0)1892 824850 mobile: +44 (0)7739-902439 work: +44 (0)20-759-48392
Yep - looks like it was compiled without the pgsql support. I've just pull the latest Fedora SRPM from rpmfind.net and --with-pgsql is not mentioned in the SPEC file. Best grab the SRPM yourself and unpack, add --with-pgsql to the configure line in the SPEC file and rebuild - should do the job. Tim Best bet is On Wed, 21 Jul 2004 17:48:11 +0200 felix.schwarz at web.de wrote:> Hello, > > I'm trying to use postgres authentication with dovecot on a linux > system running Fedora Core 2. Installation of dovecot was done by > installing the rpm included in the fedora distribution ("yum install > dovecot"). > > from /etc/dovecot.conf > auth_userdb = pgsql /etc/dovecot-pgsql.conf > auth_passdb = pgsql /etc/dovecot-pgsql.conf > > but the logs tell me: > dovecot: Jul 21 19:28:39 Info: Dovecot starting up > dovecot-auth: Jul 21 19:28:40 Fatal: Unknown userdb type 'pgsql' > dovecot: Jul 21 19:28:40 Error: Auth process died too early - shutting > down dovecot: Jul 21 19:28:40 Error: child 5229 (auth) returned error > 89 imap-login: Jul 21 19:28:40 Fatal: fd_send(-1) failed: Broken pipe > imap-login: Jul 21 19:28:40 Fatal: fd_send(-1) failed: Broken pipe > > I think that the fedora rpm was compiled without postgresql support. > - Is the information given above sufficient for an educated guess? > - Would that lead to the above error message? > - What other errors may cause this behavior? > - How can I check which authentification types are supported by my > dovecot-auth?- Are there any other Fedora rpms compiled with postgres > support available on the net? > > thank you for your help :-) > > -- > Felix >-- Mr Tim J Southerwood Senior Programmer CSG, Dept of Computing, Imperial College, London Email personal: ts at dionic.net work: ts at doc.ic.ac.uk Tel home: +44 (0)1892 824850 mobile: +44 (0)7739-902439 work: +44 (0)20-759-48392 -- Mr Tim J Southerwood Senior Programmer CSG, Dept of Computing, Imperial College, London Email personal: ts at dionic.net work: ts at doc.ic.ac.uk Tel home: +44 (0)1892 824850 mobile: +44 (0)7739-902439 work: +44 (0)20-759-48392 -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: not available URL: <http://dovecot.org/pipermail/dovecot/attachments/20040721/a8ea16b5/attachment-0001.bin>
--On Wednesday, July 21, 2004 5:31 PM +0100 Tim Southerwood <ts at doc.ic.ac.uk> wrote:> Best grab the SRPM yourself and unpack, add --with-pgsql to the > configure line in the SPEC file and rebuild - should do the job.For long-term use, create an RPM macro that defaults to empty and can be overridden on the rpmbuild command line, to be loaded with additional configure options like this. Then submit the patch to Red Hat Bugzilla. In the future you can do something like: rpmbuild --rebuild --define 'configureoptions --with-pgsql' dovecot-version-release.src.rpm