Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Suggest HOWTO

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 23rd October 2008, 10:11
sdb_231 sdb_231 is offline
Junior Member
 
Join Date: Oct 2008
Location: Chandannagar, WB, India
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Post Howto implement virtual mailserver with MySQL, fetchmail, antivius, antispam

Hello,

I have been searching the net to find a solution for:

I've a single e-mail account with my ISP (e-mail@mydomain.com) and I want to allow my family and friends to use this account individually (john@mydomain.com, jill@mydomain.com, me@mydomain.com etc. -- I have mydomain.com registered) using webmail interface like squirrelmail or egroupware. Spam and antivirus checking would be great but not really that important right now. They should be able to receive mails from "outside" directly into their individual mail box. (fetchmail? polling at regular intervals) They should be able to send mails "outside". When they send mail to family members (john@mydomain.com ---> jill@mydomain.com) the mail is sent directly without being sent to the internet.

I intend having a dedicated PC for this role (an old P4 with 512 Mb ram and 2 * 80 Gb IDE hard disks) always connected to the internet by broadband, my family members and friends have their individual desktops / laptops running operating systems of their preference.

I have found the article "Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 LTS)" at http://www.howtoforge.com/virtual-us...ail-ubuntu8.04 by Falko Timme quite near to my requirement but find integrating fetchmail into this difficult.

Ideally, I would want all e-mails to be downloaded into one account (incoming@mydomain.com) and then sent to individual accounts (original copy remains in incoming@mydomain.com). Similarly, all outgoing mails are copied into another account (outmails@mydomain.com) before being sent. Would also
prefer to have all the users in MySQL and the mails stored in MySQL (if possible). Reason? It would simplify:

a) mail backup (an SQL dump would back-up all mails and users)
b) new user creation only in MySQL and not in system.
c) Single fethcmail filter - I would not have to create individual fetchmail.rc filters. (only one that just forwards all mails to the incoming user (this probably would have to a "real" Linux user) and the MySQL does the job of mail distribution.
d) users can manage their password and folders themselves.

Though this is my preferred solution, I'm open to other options as well.

Is it possible for you to compile a step-by-step tutorial and help me in this regard? Maybe, some extra hacks into the existing "Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 LTS)" tutorial?

Thank you for your time and my gratitude.

Last edited by sdb_231; 23rd October 2008 at 17:28.
Reply With Quote
Sponsored Links
  #2  
Old 24th October 2008, 20:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,711
Thanks: 1,900
Thanked 2,702 Times in 2,545 Posts
Default

I'm not sure how to put all emails in one folder and then split the emails up...
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
sdb_231 (25th October 2008)
  #3  
Old 25th October 2008, 06:12
sdb_231 sdb_231 is offline
Junior Member
 
Join Date: Oct 2008
Location: Chandannagar, WB, India
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by falko View Post
I'm not sure how to put all emails in one folder and then split the emails up...
Thanks.

I was wondering about your Howto and hacking it to an extent

fetchmail all virtual user mails to vdamail (a real unix account for each virtual domain - we can replace the 'd' with the domain here - [vmydomainamail]) and then run some X-Envelope-To: based rules within Postfix. Is this possible?

Postfix runs in Internet with Smarthost capability so that I'm able to use my ISP/WSP account to send mails.

Thanks again.
__________________
shantanu

It is possible .................................................. ..................... in time
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL problem satimis Server Operation 5 25th June 2008 15:41
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
fetchmail Virtual Users And Domains With Postfix, Courier And MySQL (Ubuntu 7.10) c0mputernick HOWTO-Related Questions 4 31st January 2008 15:28
MySQL Cluster HOWTO - Cannot load Virtual IP address samu HOWTO-Related Questions 6 11th January 2007 10:19
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 02:53


All times are GMT +2. The time now is 04:01.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.