OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: mysql query failed on non-existent mail address

From: Justin's Mailing Lists (mailinglistslegrice.co.nz)
Date: Tue Aug 18 2009 - 18:04:31 CDT


Adrian Dinu wrote:
> Hello,
>
> I have the following problem with my postfix configuration:
>
> << SNIP >>
> Aug 18 10:56:20 server postfix/smtpd[17528]: warning: mysql query
> failed: Unknown column 'email' in 'where clause'
> << SNIP >>
> Kind Regards.

OK You need to go through all the SQL queries you created. I am
presuming you followed one of the "Setup an ISP-like mail server" guides.

I had a similar issue and found that the guide had not altered one of
the SQL queries that is used in an earlier version of the guide.

I would also check that you have postmaster and abuse aliases setup as
well. You second log indicates a problem with sending to postmaster.

Regards

Justin