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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 27th October 2008, 12:06
Stampy Stampy is offline
Junior Member
 
Join Date: Oct 2008
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Couple of questions on virtual users

Hello,

First of all hats off to the people that maintain this website and forum. Big big thank you for what you do. It is highly appreciated.

I have a few questions about virtual users/domains if someone enlighten me please? I have studied bunch of O'Reilly books recently (some are still being read now) so as this often happens I have tons of new commands, acronyms and abbreviations in my head and need to tie them up into a small business mail server called WonderfulMail.StampyNetworks.Com (name is not for sale don't ask) for topic's sake. I will put my thoughts alongside questions. Sorry if they sound dumb and please bear with me as it is the my first and by far longest thread.

1. I have noticed that quite a few writeups here feature MySQL as a database for storing (hundreds or thousands) virtual users' passwords and emails as opposed to Postfix map files. Although encrypted passwords and ease of scalability and maintenance are a clear advantage I am somewhat unsure if using MySQL to store 20-50 users is justified? I am in fond of 'keep it simple' rule and running an SQL instance for a few dozens of records does not sound right enough for me. Please note that I do not question the experience of the author of articles, majority of whom were written by guru Falko Timme, but simply want to dig a little bit deeper into reasoning before applying it to my setup.

2. I am pursuing virtual users / virtual domains scheme. As I understand it (please correct me otherwise), virtual users are not system users i.e. they are not created with useradd and are not assigned UID automatically. Taking this into account I wonder where in Postfix files we use them usernames? I read about virtual UID file but all I can see there according to the Postfix documentation is: email...UID and not actual username. Where do we map username with UID? I take it if I use MySQL I don't have to map UIDs?

3. A mail server (to remind: WonderfulMail.StampyNetworks.Com NOT for sale!!) is going to host up to 10 additional virtual mail domains (I am gonna be sooo cool!). Those 10 virtual domains will for sure have common usernames like 'sales' or 'info' (pls note that info@domain1.com and info@domain2.com are two separate mailboxes for two different people). I take it MySQL as well as Postfix will not like non-unique usernames? In which case I will follow the convention of naming my users according to domains in which they reside. That is: Bob.Domain1.com is one user whereas Bob.Domain2.com is another. I guess if I were to use Postfix config files I would map emails bob@domain1.com to first Bob and bob@domain2.com to the second. How is that done in MySQL? Or are non-unique (=same) usernames allowed?

Basically I guess you get the idea: trivial mail server with 10 virtual domains and identical yet separate users. I don't know which scheme (MySQL or Postfix map files) to follow to get this working right. I need simple (minimal) maintenance as I have only a dozen of domains with handful of users in each.

Thank you for your time.

Last edited by Hans; 27th October 2008 at 18:40. Reason: Picture removed
Reply With Quote
Sponsored Links
  #2  
Old 27th October 2008, 17:36
Stampy Stampy is offline
Junior Member
 
Join Date: Oct 2008
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hey guys,

forget about the above (well, except for the boobs) and help me with this please:

In virtual users / virtual domains setup with users created in the table or file who owns the mailboxes? I mean how does one log in to Courier or Squirrelmail to get mail for his account? Where and how do we specify usernames/passwords for Courier and Squirrelmail? Why I am asking is because it looks like Postfix don't care about usernames/passwords for virtual users as long as paths to local folders and corresponding emails are mapped correctly. However Courier or Squirrel then need login information to allow user access. How is that bit gets implemented? I mean the whole username/password thing to access mailboxes from outside?

Falko, anybody?

Last edited by Stampy; 27th October 2008 at 17:39.
Reply With Quote
  #3  
Old 27th October 2008, 18:12
marchost marchost is offline
Junior Member
 
Join Date: Feb 2008
Posts: 27
Thanks: 1
Thanked 4 Times in 4 Posts
Default

Try this howto :

http://howtoforge.com/virtual-users-...ail-ubuntu8.04

There is a MySQL module for courier which makes possible to login with IMAP (or squirelmail) and POP3 with the virtual user stored in the database.

All virtual mailboxes are owned by one user, "vmail" in Falko howto.


Marc
Reply With Quote
  #4  
Old 27th October 2008, 18:23
Stampy Stampy is offline
Junior Member
 
Join Date: Oct 2008
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks marchost, you confirmed my fears. It seems like one cannot have authpam to authenticate completely virtual users. One would have to implement and run either MySQL engine or stick to /etc/master.passwd (i.e. system users)... Right?
Reply With Quote
  #5  
Old 27th October 2008, 18:42
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,256
Thanks: 212
Thanked 648 Times in 294 Posts
Default Warning

@Stampy,

This time i have removed the attached picture.
If you ever attach any erotic content again, i will ban you from this forums!
__________________
Hans

MrHostman | Master in managed hosting
Reply With Quote
  #6  
Old 27th October 2008, 18:55
Stampy Stampy is offline
Junior Member
 
Join Date: Oct 2008
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Hans View Post
@Stampy,

This time i have removed the attached picture.
If you ever attach any erotic content again, i will ban you from this forums!
Hey, was just trying to get some attention to the topic. Your message is clear but no need to yell ???
Reply With Quote
  #7  
Old 27th October 2008, 22:43
marchost marchost is offline
Junior Member
 
Join Date: Feb 2008
Posts: 27
Thanks: 1
Thanked 4 Times in 4 Posts
 
Default

Stampy :

Well I dont know what is authpam but you can use imap, imaps, pop3, pop3s and smtp (postfix) with Saslauthd, webmail or not.

Read the howto if you want to know exactly how it works
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


All times are GMT +2. The time now is 09:46.


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