Linux Edu Handbook

User Tools

Site Tools

Trace:
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 [2011/04/14 18:04] – Updated PAM_pgsql configuration for Squeeze 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. +A 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.**
  
Line 139: Line 155:
  
   apt-get install libpam-pgsql   apt-get install libpam-pgsql
 +
 +Due to package updates, configuration of PAM_pgsql is different for Squeeze than for Etch and Lenny:
 +
 +===== Etch and Lenny =====
  
 Create a file ''/etc/pam.d/smtp'': Create a file ''/etc/pam.d/smtp'':
Line 145: Line 165:
   account sufficient pam_pgsql.so debug user=pam password=pam host=127.0.0.1 database=postfix table=pwdb user_column=id pwd_column=clear pw_type=clear   account sufficient pam_pgsql.so debug user=pam password=pam host=127.0.0.1 database=postfix table=pwdb user_column=id pwd_column=clear pw_type=clear
  
-------Squeeze------ +===== Squeeze ===== 
-For Debian Squeeze, the PAM_pgsql module has been changed. Ignore the above and instead create file /etc/pam_pgsql.conf:+Create file /etc/pam_pgsql.conf:
   database = postfix   database = postfix
   host = localhost   host = localhost
Line 235: Line 255:
  
  mkdir /var/spool/mail/virtual  mkdir /var/spool/mail/virtual
 +
 + chown 5000.5000 /var/spool/mail/virtual
 +
 + chmod g+s /var/spool/mail/virtual
  
 Add the following to ''/etc/postfix/main.cf'' Add the following to ''/etc/postfix/main.cf''
postfix/postvirt.1302804275.txt.gz · Last modified: by pyro