Couple of questions on virtual users

Discussion in 'HOWTO-Related Questions' started by Stampy, Oct 27, 2008.

  1. Stampy

    Stampy New Member


    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 [email protected] and [email protected] 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: is one user whereas is another. I guess if I were to use Postfix config files I would map emails [email protected] to first Bob and [email protected] 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 a moderator: Oct 27, 2008
  2. Stampy

    Stampy New Member

    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: Oct 27, 2008
  3. marchost

    marchost New Member HowtoForge Supporter

  4. Stampy

    Stampy New Member

    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?
  5. Hans

    Hans Moderator ISPConfig Developer



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

    Stampy New Member

    Hey, was just trying to get some attention to the topic. Your message is clear but no need to yell ???
  7. marchost

    marchost New Member HowtoForge Supporter

    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

Share This Page