User Tools

Site Tools


postfix:postvirt

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
postfix:postvirt [2013/03/07 23:09] – add setting owner and permissions to spooldir pyropostfix:postvirt [2013/03/08 03:07] (current) – typo pyro
Line 57: Line 57:
  
   create user cherryhost with password 'pass';   create user cherryhost with password 'pass';
 +
 +Chadmin is the mail domain admin
 +
 +  create user chadmin with password 'pass';
  
 Pam is used by saslauthd to authenticate users for TLS. Pam is used by saslauthd to authenticate users for TLS.
Line 111: Line 115:
  
  
-Finally, a table for virtual forwarding. That is, aliases with no login or mailbox on the system. +table for virtual forwarding. That is, aliases with no login or mailbox on the system. 
  
   CREATE TABLE virtuals (   CREATE TABLE virtuals (
Line 125: Line 129:
   GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE virtuals TO cherryhost;   GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE virtuals TO cherryhost;
  
 +Finally, the tables for cherryhost itself:
 +
 +  CREATE TABLE domain_admins (
 +    uname text,
 +    domain text );
 +
 +  CREATE TABLE mail_admins (
 +    uname text,
 +    pass text );
  
 +  GRANT INSERT,DELETE,UPDATE,SELECT on domain_admins,mail_admins to chadmin;
 +  GRANT SELECT on domain_admins, mail_admins to cherryhost;
 + 
 **Note that since several componants of the system run in a chroot environment, postgres MUST be configured to allow connections on localhost with md5 authentication.** **Note that since several componants of the system run in a chroot environment, postgres MUST be configured to allow connections on localhost with md5 authentication.**
  
postfix/postvirt.1362697755.txt.gz · Last modified: by pyro