Re: dovecot questions

2007-12-28 Thread Andrew Falanga
On Wednesday 26 December 2007 16:13:50 Peter Schuller wrote:

 Dovecot doesn't really care. You provide the method of obtaining the user
 list from the database, in the form of SQL statements (assuming they differ
 from defaults), and it's up to you to make sure this returns the
 appropriate information (so in other words, dovecot doesn't add users for
 you).

 I used to run a pg+dovecot+postfix, but have since moved away from it and I
 don't have the configs easily accessible to check out specifics. But
 googling, this should be useful in terms of providing a bunch of real-world
 configuration examples:

http://www.gjdv.at/snippets/linux/virtual_mail_hosting

Thanks for this link.  I think it will be helpful, though at this point, I'm 
overwhelmed.


  Also, with respect to the configuration file (dovecot.conf) why are there
  so many passdb/userdb?  If I have passdb sql turned on, should I turn
  off all other passdb sections?  What is the significance of the userdb
  static { } section in that file?  It appears that it is necessary for use
  if using a single user to access several mailboxes (i.e. virtual users
  which is what I want to implement).  Is this true?

 I can't answer each one of the above off hand, but things like uids is
 controlled by the user database that it sounds like you want to keep in
 PostgreSQL. This includes the ability to set the uid/gid, which you can
 have different for each user, the same, or some combination thereof, on a
 per-user basis. Your exact table design is up to you, as long as you can
 give dovecot the appropriate SQL statements for obtaining relevant
 information.

Ok, if I may run this by you, I've made a user id for this virtual mail stuff, 
the virtual mail user is vmail.  Yes I know, very inventive.  The users 
home directory is /usr/home/vmail, but I'm thinking that what dovecot cares 
about is where mail is stored.  In this case, I'm pretty sure 
it's /var/mail/vmail.  

I've followed the instructions in http://wiki.dovecot.org/AuthDatabase/SQL and 
created the table as defined on this page.  If my understaning is correct, 
this field will contain the entry /var/mail/vmail, correct?  Further, if 
I'm following, dovecot somehow delivers all mails to this virtual user and 
somehow categorizes them according to the virtual users?  Does this sound 
correct?

I wonder, sometimes attachments get large, if I'm anywhere near correct, I 
wonder if I should use a directory under /usr instead of /var?


  If I'm understanding things correctly, the next, very important item, is
  how do I setup new users and how would those users then manage things
  like passwords, etc.?

 This is up to you. dovecot does not provide and user interfaces for
 managing accounts (that I am aware of). Typically a reason to have the user
 database in a relational database would be to enable the construction of
 such interfaces, or perhaps use of existing tools. But unless I am missing
 something, user management is beyond the scope of what dovecot itself is
 providing.


Ok, that makes it simpler though some additional work for me coming up with an 
easy way to add people to the list.

Thanks for all the help.

Andy
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


dovecot questions

2007-12-26 Thread Andrew Falanga
Hi,

I'm trying to install and configure Dovecot.  Thanks to the efforts of the 
port maintainer for Dovecot, installation was mindless.  However, 
configuration isn't quite so simple.  There were several in this list that 
suggested the use of Dovecot when I inquired for suggestions as to a good 
POP/IMAP server.

So, I'm hoping that these same folks can offer help in getting me running.  
The WIKI for Dovecot is helpful, but seems to assume much in terms of what 
the reader will understand.  How do I add users to the system?  If I've done 
my work correctly, I've setup my Dovecot system to store virtual users in a 
PostgreSQL database.  However, how do I add users?

Also, with respect to the configuration file (dovecot.conf) why are there so 
many passdb/userdb?  If I have passdb sql turned on, should I turn off 
all other passdb sections?  What is the significance of the userdb static { } 
section in that file?  It appears that it is necessary for use if using a 
single user to access several mailboxes (i.e. virtual users which is what I 
want to implement).  Is this true?

If I'm understanding things correctly, the next, very important item, is how 
do I setup new users and how would those users then manage things like 
passwords, etc.?

Andy
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: dovecot questions

2007-12-26 Thread Peter Schuller
 configuration isn't quite so simple.  There were several in this list that
 suggested the use of Dovecot when I inquired for suggestions as to a good
 POP/IMAP server.

I'll add my recommendation to that (having used courier in the past).

 So, I'm hoping that these same folks can offer help in getting me running.
 The WIKI for Dovecot is helpful, but seems to assume much in terms of what
 the reader will understand.  How do I add users to the system?  If I've
 done my work correctly, I've setup my Dovecot system to store virtual users
 in a PostgreSQL database.  However, how do I add users? 

Dovecot doesn't really care. You provide the method of obtaining the user list 
from the database, in the form of SQL statements (assuming they differ from 
defaults), and it's up to you to make sure this returns the appropriate 
information (so in other words, dovecot doesn't add users for you).

I used to run a pg+dovecot+postfix, but have since moved away from it and I 
don't have the configs easily accessible to check out specifics. But 
googling, this should be useful in terms of providing a bunch of real-world 
configuration examples:

   http://www.gjdv.at/snippets/linux/virtual_mail_hosting

 Also, with respect to the configuration file (dovecot.conf) why are there
 so many passdb/userdb?  If I have passdb sql turned on, should I turn
 off all other passdb sections?  What is the significance of the userdb
 static { } section in that file?  It appears that it is necessary for use
 if using a single user to access several mailboxes (i.e. virtual users
 which is what I want to implement).  Is this true?

I can't answer each one of the above off hand, but things like uids is 
controlled by the user database that it sounds like you want to keep in 
PostgreSQL. This includes the ability to set the uid/gid, which you can have 
different for each user, the same, or some combination thereof, on a per-user 
basis. Your exact table design is up to you, as long as you can give dovecot 
the appropriate SQL statements for obtaining relevant information.

 If I'm understanding things correctly, the next, very important item, is
 how do I setup new users and how would those users then manage things like
 passwords, etc.?

This is up to you. dovecot does not provide and user interfaces for managing 
accounts (that I am aware of). Typically a reason to have the user database 
in a relational database would be to enable the construction of such 
interfaces, or perhaps use of existing tools. But unless I am missing 
something, user management is beyond the scope of what dovecot itself is 
providing.

-- 
/ Peter Schuller

PGP userID: 0xE9758B7D or 'Peter Schuller [EMAIL PROTECTED]'
Key retrieval: Send an E-Mail to [EMAIL PROTECTED]
E-Mail: [EMAIL PROTECTED] Web: http://www.scode.org



signature.asc
Description: This is a digitally signed message part.


Re: dovecot questions

2007-12-26 Thread Jay Chandler

Peter Schuller wrote:


This is up to you. dovecot does not provide and user interfaces for managing 
accounts (that I am aware of). Typically a reason to have the user database 
in a relational database would be to enable the construction of such 
interfaces, or perhaps use of existing tools. But unless I am missing 
something, user management is beyond the scope of what dovecot itself is 
providing.


  

You are correct; I use Postfixadmin to do this personally.

--
Jay Chandler / KB1JWQ
Living Legend / Systems Exorcist
Today's Excuse: Vendor no longer supports the product

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]