-----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.ar/pro/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGJRQ6AlpOsGhXcE0RCnaeAJ44Md3Zbo74NbsrcQ8hZbJz21NV1wCdGRhr
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://sourceforge.net/powerbar/db2/
_______________________________________________
courier-users mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
