Bug 143648

Summary:	courier-authlib-mysql package wanted
Product:	[openSUSE] SUSE Linux 10.1	Reporter:	Christian Boltz <suse-beta>
Component:	Network	Assignee:	Thorsten Kukuk <kukuk>
Status:	VERIFIED WONTFIX	QA Contact:	E-mail List <qa-bugs>
Severity:	Enhancement
Priority:	P5 - None	CC:	dwight, forgotten_pdeXwctaxL
Version:	Alpha 4
Target Milestone:	---
Hardware:	Other
OS:	Other
Whiteboard:
Found By:	Other	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---

Description Christian Boltz 2006-01-17 22:54:58 UTC

SUSE Linux already contains the courier-authlib, courier-authlib-userdb and courier-authlib-ldap packages.

Unfortunately, courier-authlib-mysql, the MySQL "connector", is missing.

I think this package would be really useful for people who use postfix and courier and don't want to manage their users in files. In this case, MySQL is the perfect solution for the user database.

Additionally, nearly every HowTo about setting up large scale mailservers with postfix and courier and "Das Postfix-Buch" recommend the usage of MySQL for the user database.

BTW: If I get the description in the "Postfix-Buch" right, it shouldn't be too hard to get the mysql support in courier-authlib - you just need to have mysql and its devel packages in the build environment.

BTW: You can find SUSE 10.0 packages and the corresponding spec file on http://www.matthias-keller.ch/RPM/courier-authlib-0.57/ if you need any reference.

Comment 1 Thorsten Kukuk 2006-02-17 13:50:20 UTC

*** Bug 151692 has been marked as a duplicate of this bug. ***

Comment 2 Thorsten Kukuk 2006-03-13 09:25:47 UTC

You don't need plain files, you can use LDAP.

With databases there is always the problem of correct converting of config files and content on update.

Comment 3 Christian Boltz 2006-03-13 23:27:47 UTC

LDAP?!

Quoting Ratti (from a mail in suse-linux mailinglist, translated):
   LDAP! I asked for roller skates, and they fastened tanks under my feet.

No thanks. I don't want or need headache^WLDAP.

MySQL is _much_ easier to maintain IMHO.

> With databases there is always the problem of correct converting of config
> files and content on update.

I don't get your point here (and don't see the problem) - could you please explain a bit more detailed?


BTW: if you keep your "wontfix" decision, this will probably be my first project on the upcoming built service ;-)

(not reopening - but please explain what problem you see with using MySQL.)

Comment 4 Dwight Tuinstra 2006-03-14 03:41:26 UTC

Please reconsider re-opening bug and supplying MySQL. Organizational constraints or decisions made elsewhere in an organization may require a database authentication mechanism. To require that an enterprise change it's chosen authentication framework if they wish to deploy SuSE is not realistic: it is instead a motivation to use a different distro.

Or, if an organization has settled on SuSE, it now must download, verify, build, install, and maintain the software manually ... as well as spend extra effort watching for (non-SuSE) security alerts. As someone who is doing this for a client, I would much prefer the alternative of changing a few lines in config files when an upgrade or security patch comes out!

And as for maintaining config settings during an upgrade, can this not be done with sysconfig?

Comment 5 Forgotten User pdeXwctaxL 2006-04-20 22:14:23 UTC

I totally agree. At the moment i'm using Matthias Keller's courier-authlib-mysql package on my 10.0 box. This is an essential package if you provide mail services with many domains - like i do and many others. The strange thing is postfix officially supports mysql maps since version 10.0. I don't see the correlation from this point of view.

Comment 6 Christian Boltz 2006-08-01 19:10:00 UTC

see also bug 188587 :-)

Comment 7 Christian Boltz 2006-12-30 19:11:10 UTC

VERIFIED FIXED for 10.2 (available via FTP only)