-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
James Homuth wrote:
> I'm looking for a decent front end to a
postfix/courier/mysql
> instalation that's fairly quick to set up. I have a
mysql setup
> that's a little different from the typical, so the
easiest to change
> without breaking things would be probably best. If
anyone's got
> suggestions, I'd appreciate them. On or off-list makes
no difference to me.
I also have a different setup for my mysql auth structure,
but I'm using MySQL 5's VIEWS to convert
them into a virtual table, easily usable from
courier-authmysql:
CREATE VIEW v_accounts AS select a.id, concat(a.name,' ',d.name)
as user, clear, uid, gid, home,
concat('/home/',a.name,'/','Maildir') as maildir, quota,
a.name, disablepop3, disableimap,
disablewebmail FROM ACCOUNTS a, domains d WHERE a.domain_id
= d.id;
Then I just make v_accounts the USER_TABLE in authmysqlrc.
- --
Arturo "Buanzo" Busleiman - Consultor
Independiente en Seguridad Informatica
Foros GNU/Buanzo: Respeto, Soluciones y Buena Onda: http://foros.buanzo.com.ar
Consulting and Secure Mail Hosting: http://www.buanzo.com.a
r/pro/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGJRQ6AlpOsGhXcE0RCnaeAJ44Md3Zbo74NbsrcQ8hZbJz21NV1wCd
GRhr
gLfNfEbvgWv+zxp1OEWZhF8=
=5/w9
-----END PGP SIGNATURE-----
------------------------------------------------------------
-------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and
take
control of your XML. No limits. Just data. Click to get it
now.
http://sourcefor
ge.net/powerbar/db2/
_______________________________________________
courier-users mailing list
courier-userslists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-u
sers
|
