[Vmail-discuss] Exim+MySQL+POP3+IMAP Solution

Eric Renfro psi-jack@xxxxxxxxxxxxx
Sun, 11 Nov 2001 13:36:45 -0600


This is a multi-part message in MIME format.

------=_NextPart_000_0038_01C16AB5.E847F7E0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_0039_01C16AB5.E84B0520"


------=_NextPart_001_0039_01C16AB5.E84B0520
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hey guys. I was reading through past articles, and noticed a common
question being Webmail and IMAP.
 
For the guys interested, I've been working on a previous endeavor
myself doing that, and originally, I started out using Postfix with
MySQL, and Courier-IMAP. And since my discoveries of postfix and
virtual not mixing well with combined functionality, I've since gone
back to exim. I'm re-working my exim configurations now to use MySQL
backends for data instead of using flatfiles, thanks to help from
vmail-sql, and I'm re-doing some parts to use Maildir over mbox
formatted mail, using /var/[spool/]/mail/virtual/$domain/$user/ as
the Maildir_path, for the popboxes, and then, using Courier-IMAP to
follow up and use MySQL for authentication reading similar
information to get that same resolution of the Maildir_path. Though
Courier-IMAP is slightly different in what it expects, it still will
work, though is a bit of a redundancy hack.
 
PS: I enclosed 'spool/' in []'s because my server model is being
designed on FreeBSD, but will be used on Linux in production. 
'virtual/' could also easily be deleted and just use $domain/$user
instead for a cleaner heigharchy (Sp?).
 
Courier-IMAP also has "soft" quotas. The only limiting factor of
this, is if a real user of a virtual popbox has shell access in, and
uses local MUA's, then it doesn't work for the quota. Else, it works
fine over Webmail, such as SquirrelMail (which is what I plan to use,
when this is all done and fixed up).
 
 
Anyway, thought I'd spread my idea, and possibly get second opinions
on the matter.
 
 
- ---
Eric Renfro - Myrddin Computers & Designs
CEO/President
(713) 595-2104 ext. 2261
 

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
Comment:   -- Psi-Jack <Encrypting the Net/Securely>

iQA/AwUBO+7TTLdZW96NGwakEQK6NQCg9GScyIs/st8tXP31yhM0a2mWjGEAoPvg
uTd9KqttU+p1KXgQaEnb9Oe7
=+kZ0
-----END PGP SIGNATURE-----


------=_NextPart_001_0039_01C16AB5.E84B0520
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">



Exim+MySQL+POP3+IMAP Solution




-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hey guys. I was reading through past articles, and noticed a common
question being Webmail and IMAP.

For the guys interested, I've been working on a previous endeavor
myself doing that, and originally, I started out using Postfix with
MySQL, and Courier-IMAP. And since my discoveries of postfix and
virtual not mixing well with combined functionality, I've since gone
back to exim. I'm re-working my exim configurations now to use MySQL
backends for data instead of using flatfiles, thanks to help from
vmail-sql, and I'm re-doing some parts to use Maildir over mbox
formatted mail, using /var/[spool/]/mail/virtual/$domain/$user/ as
the Maildir_path, for the popboxes, and then, using Courier-IMAP to
follow up and use MySQL for authentication reading similar
information to get that same resolution of the Maildir_path. Though
Courier-IMAP is slightly different in what it expects, it still will
work, though is a bit of a redundancy hack.

PS: I enclosed 'spool/' in []'s because my server model is being
designed on FreeBSD, but will be used on Linux in production.
'virtual/' could also easily be deleted and just use $domain/$user
instead for a cleaner heigharchy (Sp?).

Courier-IMAP also has "soft" quotas. The only limiting factor = of
this, is if a real user of a virtual popbox has shell access in, and
uses local MUA's, then it doesn't work for the quota. Else, it works
fine over Webmail, such as SquirrelMail (which is what I plan to = use,
when this is all done and fixed up).


Anyway, thought I'd spread my idea, and possibly get second opinions
on the matter.


- ---
Eric Renfro - Myrddin Computers & Designs
CEO/President
(713) 595-2104 ext. 2261


-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
Comment:   -- Psi-Jack <Encrypting the Net/Securely>

iQA/AwUBO+7TTLdZW96NGwakEQK6NQCg9GScyIs/st8tXP31yhM0a2mWjGEAoPvg
uTd9KqttU+p1KXgQaEnb9Oe7
=3D+kZ0
-----END PGP SIGNATURE-----

------=_NextPart_001_0039_01C16AB5.E84B0520-- ------=_NextPart_000_0038_01C16AB5.E847F7E0 Content-Type: text/x-vcard; name="Eric Renfro (psi-jack@myrddincd.com).vcf" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="Eric Renfro (psi-jack@myrddincd.com).vcf" BEGIN:VCARD VERSION:2.1 N:Renfro;Eric FN:Eric Renfro (psi-jack@myrddincd.com) ORG:Myrddin Computers & Designs TITLE:CEO/President TEL;WORK;VOICE:(713) 595-2104 X2261 TEL;HOME;VOICE:(936) 231-2895 TEL;WORK;FAX:(713) 595-2104 X2261 ADR;WORK:;;14324 Old Humble Pipeline Road;Conroe;TX;77302-4422;United = States of America LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:14324 Old Humble Pipeline = Road=3D0D=3D0AConroe, TX 77302-4422=3D0D=3D0AUnited States=3D of America EMAIL;PREF;INTERNET:psi-jack@myrddincd.com REV:20011030T164102Z END:VCARD ------=_NextPart_000_0038_01C16AB5.E847F7E0 Content-Type: application/octet-stream; name="PGPexch.rtf.asc" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="PGPexch.rtf.asc" owHtWE2MI0cVHoFAaKU9oNyIFD1GId4g293+m9lhPBt5xl52pPHMsOMkWm2HqNxdbRdbXdVTVT0e s5pDuHFAQoITh+QCR06JhBQ4cEbcEDfEkSMHjogDr6rt2fFsW8lmdyUi7INlV796f/Xe977qn669 9dWvrW3/8y8Hv3vw8O8/e/Xrv/7mV77zj7WPfvjnv376h99//KdP/vibX336Sk3yR++8tvahv//L n/9nu/evVz/4xgf//tbDu6+98ou//Xb9J8M1+3kcKBPXAiI0c19hOqrVW/UgVjIZm4TXIIhoHPuP g1gKY4b85g386QexnjCtgzgcE6Wp8aGjGOHbF+5xLYgTGVElYE9milEFh3Qye4aqBeOXG+twMk2G cr6zMd95RfPTOppLzbvnoeRSoauBopEfjBSlwg+GPKP+9lNL9VbLKg2ysBakREVBygkTNmZDho0N H/Jg602wmr8b2JwYMqo3G9D+dvdob/DguAf3Bv0DOH5792B/D9YrnvduY8/zuoNu/qBZ9WGgbHIN k4Jwz+sdrt+5WNDXAGsdFhdrW9C2Gq7LNnG51+leW65tbkJ7sD846F17UG/WoE+1JiN6bcftFrS9 oi21QncKFzdq0O73Bh0IsT6oMDvr/RMX9kbV96v1Dfzy10GQhO58v3fYu98ZHN2/Zg39a3sFEdWL DLZ8aO8edR9ck/WLZLc2oN3df+fOhVvAQofH818+XJHbaBZKLOi6jVk/Oe4cQsiJ1juN5mZjo75R 26rU8FP3/dqdz9ZRa96G9t2jwwHEJKQ7rmZBsx/TnfrC7rgJtuYwpks99+gURtlUV2EfJkQv6m3O gleUREyMwIyVzEZjSIk2QJRhIae6DEREICT+oxEQPK8kkQJOM6ptXcKQ2q3v0mFCGHeyhTb2+53j 6mJULUyzZ8O6EsTFkhRs1VHW5rFY9orkZv1y3Vp+InTzxqJ5H0/GWzzmZda/vFXi/P58pfLSDud6 pG+IoU63n4gGJeKvjvIFNfxdqbCPqWv64k5kiLcKm5dGZdgvnVHsYCpgItUj28jY0QRSRc+YzDRQ EVFyhiqTqaY8hkjmOEFMeXmrS8VGDAcWn6IB0AaRBJFDZgYybbcfS21idg4TZsbQn5784CBXNhvY FQcV0MEVFA9psZFkChHToTyjuEeDjCGdqbWqzpgyGeYMYQsSdm6tTijnuUlEsCETdIn3cSbCfOAy M51lKPdjJAUmi4SPwEig5yxBUC0loGhlnjx0yq4XK8ZBF7NRpojVrtG1idWTaZrnwGnGfGuIMd8R MQSYwFMikQ0uz1zMCYboQLnQBB6MeKSt2jHlKVgyBmcWlyv6lOdJnnmcH6SWCUW0V0ZfuoLCEVNg 87ok8UN5bl1MiLHHarWXZ+55Z0R5D3UqJffe8+wTb3YQ3uuRxP/Cex2NKA9wEtkiLTQwc+H9lJhx 2SXDiqYyRcPzcYQrYm71atnYMGLJOeY2S5dX6JOkW/Uks+pwvrmTgfk01CxhHKWZyKO1z1D9iBrX AKCRmyybp1ryzG3Ao7PeX42pCoOxG7MLjjMNmrPR2HBb2HGMLSoM2i62MLEOMIPVltLQYFLwN45j V+H2C+uxjIadGdRMYIgC6AvB6KJMRESE02LNY6zC1ZxezenVnH65c/r45Hs4HKkIudTLRlEph9KS hYGH75U0TuqQWOzCOYMwaiHa3nq5bfGchkdUs5EdbQg9d/G2unvSLcMQJ6+DhUIjQ2qB3+04YCI7 t8ZSJaPMTcHqsxUFlOaAX8Ixm3G8MHCNw5JohriGptBbapbFa/H6R5k2bhItTIzLUejwGo+MEoGr Y4qISVQ4XgJmt07St95codkKzVZo9nLRbIHKuJZfQi40rGsZm3U4zaQh2nIhitCD4MCRbhlHcklo sMsdc2KW2mhgOXNBdxwYOCJTaGDO+3O2CNaeHlviT8KQalQkcv6IajRwGaJo/+1OSZcdo7QsKpJU i5JxFGrJBWHGSF0EVehxTR3/sjuQvOPNImfPs1ciZdBZOLaM9+Q0Y0pRbskg3JqMWejI2XKCtw8p J2JGzcswsS7anDhKh0FF9kJiw8FrD2Jqlq6w7qU2yApxVsNjdZQvfHh0xHRCpvP7KsJeaQk/1Km9 m1v2yyJKciRPpdZsiPPD3ss1DSWuyZQJ947F3tiXvWZw7y/UCjBX/f3/0N//swEikcEb6w6nsVmI 9ZTDF473ObCoUqksqqqhm7v3r2wLODK8mzdeRJE+b3v0FAvhPhWxklCB/lRFEV7e92SSZght+uki IMnVGnjjiSbouhcH+ssT+17vyDtW6HVEhXlWt29t1hpvQmurVanbOqbnpgp1BLdnCmeFCs8XYAsL wNs96j64sxhjfRPX7w36B9fWG7OEXPwX ------=_NextPart_000_0038_01C16AB5.E847F7E0--