Dave

I would love to see the screenshots to this, this is really interesting to me

Ade

See here for pictures.

For a catch all mailbox see : here

Thanks for a great guide. I'm almost there and I think I have a reasonable understanding of how everything hangs together thank to this.

However, courier-imap doesn't seem to be able to create the mail directories by itself. Am I wrong in thinking that it should? If I'm not, any ideas as to why it is failing?

When I try to get email from the imap account samwise@hydrus.xx.xx, I see the following. Database back end is retrieving all the right values and authentication succeeds.

Jan 22 22:01:17 hydrus imapd-ssl: Connection, ip=[::ffff:xx.156.116.xx]
Jan 22 22:01:18 hydrus imapd-ssl: samwise@hydrus.xx.xx: chdir(/var/mail/vmail) failed!!
Jan 22 22:01:18 hydrus imapd-ssl: error: No such file or directory
Jan 22 22:01:18 hydrus imapd-ssl: LOGIN FAILED, method=PLAIN, ip=[::ffff:xx.156.116.xx]
Jan 22 22:01:18 hydrus imapd-ssl: authentication error: No such file or directory

hydrus ~# ls -la /var/mail/
total 8
drwxrwxr-x 2 root mail 4096 Jan 13 16:16 .
drwxr-xr-x 5 root root 4096 Jan 15 19:51 ..

However, when I create the directories manually (all gid mail and group writable), it goes beyond that, but mail client says "unable to open this mailbox"

Any hints are greatly appreciated

Hi,
is there a how-to somewhere, how to add clam-av/f-prot and spamassassin?
Thanks a bunch,
Burkhard

Great howto , thanks.!!!!

One thing, when i access postfixadmin, i get the error:

DEBUG INFORMATION:
Invalid query: ERROR: relation "admin" does not exist

Please check the documentation and website for more information.

Postfix Admin
Knowledge Base

There is absulotely nothing on the net about it and i cant figure it out.

Any ideas or 'pointer-in-the-right-directions' would be much appreciated to get this server up and functional

Shawn

im running RHEL 4.0, i hav configured the basic setting in main.cf but im unable to send / recv mail. anyone can send me the confguration of postfix.

(mijildas@yahoo.com)

Hi!
I did everything as u say and I have error using pstfixadmin
I dont know how use it. I get the firt page and I run the setup

Now when I go to url of my server I get this error:

Warning: pg_last_error(): No PostgreSQL link opened yet in /var/www/mailadmin/functions.inc.php on line 925

DEBUG INFORMATION:
Connect:

Please check the documentation and website for more information.

Postfix Admin
Knowledge Base

I get this when I try to go to admin section.
I run setup.php and Everything seems fine... you are ready to rock & roll!
But it is not true! Sad
Somebody can help me?
What can I do?

I had an email today from someone trying to setup/install on Edgy Eft; to which my reply was :

Rob H wrote:
> Hi,
>
> I read your article about setting up Postfix with Postgres, and I've
> been trying to get it all to work. Everything seems fine up until the
> point where I create the mailbox in Postfixadmin. It does get created,
> the tables are updates in Postgres, but the actual DIR for the user
> created in /var/mail/vmail is *NOT* created. Up until I configure
> Postfix to use Postgres, I don't have any errors, then I start getting
> these two:
>

Hi Rob,

The mailboxes are created on demand by Postfix when it first receives an email for $user; therefore it's normally a good idea to send the 'welcome' email, so new users can connect to their mailbox ok.

I've not tried setting up Postfix admin on Edgy yet, but I wouldn't have thought there should be any real reasons why it won't work. I suspect your problems are somehow related to your attempted use of SSL with PostgreSQL. I've never setup PostgreSQL with SSL support before (or at least tried to use it!).

> postfix/trivial-rewrite[9370]: warning: connect to pgsql server
> localhost: SSL SYSCALL error: No such file or directory?
>
> postfix/trivial-rewrite[9370]: fatal:
> pgsql:/etc/postfix/pgsql/virtual_alias_maps.cf(0,lock|fold_fix): table
> lookup problem
>
> There are a few others that come from postfix/smtpd and postfix/master,
> but they seem to point back to these postfix/trivial-rewrite events. The
> query does work manually from that .cf file, I have also tried to change
> the user to postfixadmin or another user that has all permissions
> granted. So, it doesn't seem to be a problem with rights. I read
> somewhere that it looks like Postfix is trying to connect via SSL and to
> configure Postgres to allow "hostssl" in "pg_hba.conf". I tried that,
> and it didn't help.

What does your pg_hba.conf file look like?
Try allowing local connections (127.0.0.1, localhost) through non-ssl?

>
> I'm using Ubuntu Edgy Server (32 bit), Postfix is 2.3.3 I believe, and
> Postgres is 8.1.4.
>
> Besides your article, I have read through this one:
> http://www.lxtreme.nl/index.pl/docs/linux/dovecot_postfix_pam
>
> Any thoughts?

See above; although I don't think I've added anything new!

Hi, I have been following your procedures step by step for installing it in ubuntu edgy + postgres 8.1.Everything seems to be fine just I cannot make it work :))
I am at the point of having postfix admin up and running. What puzzles me is that I cannot seem to find a way to set up an email address as I am constantly given the message: Email not valid.
I must admit the corresponding host does not exists, meaning I have not registered with ICANN yet (just to be clear I tried to create a mailbox "renato" for the domain "mydomain.com" which has not been registered yet) I am not sure that is the reason. Moreover glancing your screenshots it seems like you should be able to have one admin being charge of more than one domain,in your screenshots the admin dg@clocksoft.com seems to be the admin of two domains. I have not found a way to select an existing admin for associating it to a domain. Last, but no least, the only link I have found for defining domains is the one you can find following the setup (when setup.php has not been removed), I could not find it anywhere else.
I do apreciate these could be postfixadmin support related questions, my problem is this is the first time I see postfix working and I am not able to understand whether some things do not work because of an incorrect setup procedure from my side.
Thank you for any time you can take to give me a hand
Sincerely
Renato Dall'Armi

ps actually there is one thing in your procedure I could not follow, when you said about editing /var/www/postfixadmin-2.1.0/admin/.htaccess to fix the path for the .htpasswd file:
I have not found any .htpasswd file nor I could find infos about the htpasswd2 command. It is there, it has no man associated and googleing it did not return any usefull info.

Hallo David, thanks for your help.
I am getting there, with just two little things:

1st I am not asked any username/password for accessing http://mysite/postfixadmin/admin, it is for everybody to edit.

following your procedure I have changed .htaccess which looks now like:

AuthUserFile /var/www/postfixadmin-2.1.0/admin/.htpasswd
AuthGroupFile /dev/null
AuthName "Postfix Admin"
AuthType Basic

require valid-user

I have also modified the admin password by using: sudo htpasswd -c .htpasswd admin in the postfix/admin directory.
Permissions are set like: (for all files in the admin directory I report just 5 for brevity)

-rw-r----- 1 www-data www-data 2747 2005-01-07 00:00 edit-alias.php
-rw-r----- 1 www-data www-data 2966 2007-01-24 10:51 edit-domain.php
-rw-r----- 1 www-data www-data 4009 2007-01-24 10:51 edit-mailbox.php
-rw-r----- 1 www-data www-data 168 2007-01-25 16:34 .htaccess
-rw-r----- 1 www-data www-data 20 2007-01-25 16:30 .htpasswd

2nd there is no way I found to associate a domain to an existing admin, no by editing a domain, not by editing the admin, how do you normally do that?

I have been trying to install postfix/postfixadmin onto ubuntu edgy 6.10 X86_64 I have been experiencing the same error as one of the previous posters "SSL SYSCALL error: No such file or directory?" that is not due to trying to use SSL, but, as it turns, from the lack of SSL support. Once SSL support has been granted to postgres that error goes away. I am now fighting with a virtual_alias_maps map lookup problem for root@broker-group.es, but it could be these errors have to do with some access problems due to lack of SSL support up to this morning

the SSL problem (localhost: SSL SYSCALL error: No such file or directory?) is not due to SSL, but instead to improper setting of the postfix configuration file main.cf. postfix does not want to be run chrooted so, **every** service listed must be **explicitally** told not to run chrooted. As it is by default in edgy, all services are chrooted and that is the problem.

I am facing a problem with courier instead. while trying to login to a test account I get

Feb 21 19:30:13 server authdaemond: Connection to server 'localhost.' userid 'postfix.' database 'postfix' failed.
Feb 21 19:30:13 server authdaemond: could not translate host name "localhost." to address: Name or service not known.
Feb 21 19:30:13 server courierpop3login: LOGIN FAILED, user=massimo@eudealers.com, ip=[::ffff:127.0.0.1]
Feb 21 19:30:13 server courierpop3login: authentication error: Input/output error

now I can psql -d postfix -h localhost -U postfix with no problem so the problem does not seem to be at the database level...... any clue?
tx
Renato

Please help me to solve the problem.

Hi, I have been following the procedure (and done a lot of debugging because edgy seems to be not as "mature as dapper) and I have postfix/postgres/postfixadmin up and running, I can access my email using pop3.....not so sure about IMAP.
If I set kmail to access my server using IMAP it just hung in there with "checking account for new email". is there anything I have to do to enable IMAP besides following the procedure above?
thanks
Renato

i used this guide and a couple of others to install postfix, postfixadmin, courier imap, imaps, pop3d and pop3d on a mandriva 2007 distro. on another system i have postgres 8.1 running (also on a mandriva 2007 distro) and i must say that once i got the maildir permissions issue resolved (discovered postfix is running as 'nobody', at least that's the way the mail dirs are being created) everything came up and worked 100%...both imap and pop3. have not tried the ssl stuff yet.

nice job.

The following may be of use :

Updated Squirrelmail plugin for Postfixadmin

Hi,

I've got some problms with postfix and postgre.

My first problem was the same as described By renato (not verified) at 2007-02-22 09:18

So postfix admin said it has send a test email to new user. In fact either by postfixadmin either by a test with email client, the /var/mail/vmail/the_new_user@its_domain is never created...

So I create it by hands and i do a chow 700 (how to set drwx--S--- permission ?) and I create the subdirectories...

Now I can connect by telnet.

But email system still not working.

with a tail /var/log/mail.err I can see that :
Apr 7 14:53:28 courriel1 postfix/trivial-rewrite[2596]: fatal: pgsql:/etc/postfix/pgsql/virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem

So I will be very happy if someone can help me to fix that.

Thanks a lot

STef

Oki, it seems I've got a configuration problem.

postmap -q pgsql:/etc/postfix/pgsql/virtual_alias_maps.cf alias_name@domain.eu
postmap: fatal: open database alias_name@domain.eu.db: No such file or directory

I've checked the pgsql/* files, there are the same as thoses in this site (with my parameters).
I can also use the postgres database without problem with this command:
psgl -U postfixadmin postfix

a tail /var/log/mail.log says the same :
Apr 10 20:28:20 courriel1 postfix/postmap[5208]: fatal: open database alias_name@domain.eu.db: No such file or directory

The alias I've created was done with postfixadmin and points to a virtual domain managed by postfix (and also configured with postfixadmin).

So David is right : I've got a serious problem with my postfix configuration

There's also a reccuring message who comes everytime in /var/log/mail.log (even when I don't do anything). I put a little copy/paste here, maybe it could help.

root@courriel1:/etc/postfix# tail /var/log/mail.log
Apr 10 20:29:04 courriel1 postfix/smtpd[4539]: send attr request = resolve
Apr 10 20:29:04 courriel1 postfix/smtpd[4539]: send attr sender =
Apr 10 20:29:04 courriel1 postfix/smtpd[4539]: send attr address = stef@main_virtual_domain.com
Apr 10 20:29:04 courriel1 postfix/smtpd[4539]: private/rewrite socket: wanted attribute: flags
Apr 10 20:29:04 courriel1 postfix/smtpd[4697]: rewrite stream disconnect
Apr 10 20:29:04 courriel1 postfix/smtpd[4697]: connect to subsystem private/rewrite
Apr 10 20:29:04 courriel1 postfix/smtpd[4697]: send attr request = resolve
Apr 10 20:29:04 courriel1 postfix/smtpd[4697]: send attr sender =
Apr 10 20:29:04 courriel1 postfix/smtpd[4697]: send attr address = stef@main_virtual_domain.com
Apr 10 20:29:04 courriel1 postfix/smtpd[4697]: private/rewrite socket: wanted attribute: flags

Another thing is I don't realy trust postfixadmin. I would like to create some entries by myself but I don't know how to put an encrypted password in the password field of postgresql.

I would also thank for this debian/ubuntu usefulf website and the help reveived.

STef

Many thanks,

So the following command is working :

root@courriel1:/etc/postfix# postmap -q alias_name@one_domain.eu pgsql:/etc/postfix/pgsql/virtual_alias_maps.cf

It returns :
real_name@one_domain.eu

There's nothing particular when I do /var/log/mail.log except a new instance of the message I've mentionned before.
Something I didn't write is that my server has 2 ip adresses : One public (eth0) (for receiving and sending emails) and one private (eth1) (to communicate with the postfixadmin server). Maybe it is mandatory to say postfix what to do with each intefaces.

I've tried one more time to send emails to accounts created with postfixadmin using my account provided by my adsl provider
It still not working : mailboxes aren't created in /var/mail/vmail (i've do a chmod mail:mail on /var/mail/vmail as suggested by David).

I did the following checks :

1) An NS lookup on the MX record of my destination domain on http://www.zoneedit.com the answer is correct so I don't have a DNS problem

2) when doing a tail /var/log/mail.err I see some identical lines :
Apr 10 22:27:04 courriel1 postfix/trivial-rewrite[6322]: fatal: pgsql:/etc/postfix/pgsql/virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem
it's very strange becoz the (new) test command provided by David worked fine

It seems also I've got a problem when trying (using both ftp method and email client) to check emails :
authentification failed (login name = complete_email_adress ; pass = pass filled in the postfixadmin interface)

Maybe is there a problem with the hash of the password ?

thanks for help

I was following the steps in "Creating the PostgreSQL database structure", after executing "cat DATABASE_PGSQL.TXT | psql", I get an error of

psql: FATAL: password authentication failed for user "postgres"

Hey,

I've got a postfix configuration with a MySQL database.

I've got the folowing error in my mail.log :

May 26 18:02:16 VirtualUbuntu postfix/cleanup[10399]: warning: BD6A9D6300: virtual_alias_maps map lookup problem for postmaster@example.com

When I run this command: root@VirtualUbuntu:/etc/postfix/sql# postmap -q "postmaster@example.com" mysql:/etc/postfix/sql/virtual_alias_maps.cf

I get the correct result: bamm.bamm@example.com

So the permissions on the tables for postfix are correct. But why do i get this error.

A part of my main.cf looks like this:

myhostname = mail.example.com
mydestination = $mydomain, $myhostname, localhost.localdomain, localhost
virtual_mailbox_domains = mysql:/etc/postfix/sql/virtual_mailbox_domains.cf
virtual_uid_maps = mysql:/etc/postfix/sql/virtual_uid_maps.cf
virtual_gid_maps = mysql:/etc/postfix/sql/virtual_gid_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/sql/virtual_mailbox_recipients.cf
virtual_alias_maps = mysql:/etc/postfix/sql/virtual_alias_maps.cf
relayhost =
mynetworks_style = class
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
local_transport = maildrop
maildrop_destination_recipients_limit = 1

Can anyone help me?

Thnx!

Greetings,

David

Hi,
i got here from googling on my problem, here goes:

Jun 27 22:47:18 mail postfix/trivial-rewrite[37514]: warning: mysql query failed: MySQL server has gone away
Jun 27 22:47:18 mail postfix/trivial-rewrite[37514]: fatal: mysql:/usr/local/etc/postfix/mysql/virtual_alias_maps.cf(0,lock|fold_fix): table lookup problem

(this is from maillog).
I have postfix+mysql virtual users and aparently all works, ie: I can send/recieve emails, accounts are created from postfix admin etc. But i keel getting those lines in maillog, whats the problem, i suspect the mysql server isnt playing nice, BUT what is the problem ? :(

Hi there folks,

This How-To is very good, thanks a lot!
Well, I was having trouble in default Ubuntu Dapper (Server LTS) install, somehow when I was trying to add users in virtual domains I was getting this log:

Mar 4 07:56:10 alucard postfix/smtpd[4239]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Mar 4 07:56:10 alucard postfix/smtpd[4239]: warning: problem talking to service rewrite: Success
Mar 4 07:56:10 alucard postfix/master[3700]: warning: process /usr/lib/postfix/trivial-rewrite pid 4262 exit status 1
Mar 4 07:56:10 alucard postfix/master[3700]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling

Some googling before, I found that Ubuntu has SSL broken in PostgreSQL by default: http://lists.tummy.com/pipermail/vpostmaster/2006-August/000406.html

The fix for this was changing /etc/postgresql//main/postgresql.conf

where says: ssl=true
change to: ssl=false

Restarted service postgresql and I could at least add an user:
Mar 4 07:57:10 alucard postfix/smtpd[4239]: B9528B728D: client=localhost[127.0.0.1]
Mar 4 07:57:10 alucard postfix/cleanup[4311]: B9528B728D: message-id=<20080304105710.B9528B728D@alucard>
Mar 4 07:57:10 alucard postfix/qmgr[3705]: B9528B728D: from=, size=467, nrcpt=1 (queue active)
Mar 4 07:57:10 alucard postfix/smtpd[4239]: disconnect from localhost[127.0.0.1]
Mar 4 07:57:10 alucard postfix/virtual[4313]: B9528B728D: to=, relay=virtual, delay=0, status=sent (delivered to maildir)
Mar 4 07:57:10 alucard postfix/qmgr[3705]: B9528B728D: removed