[Postfixadmin-devel] postfixadmin-devel@lists.sourceforge.net

[MailingLists <mai...@st...>]

Hey guys,

I am having a serious problem with amavis and postfixadmin.  My
mailserver setup is as follows:

Postfix -> Dovecot -> Amavisd-new (clamav/spamassasin) -> MySQL ->
Roundcube -> Postfixadmin.

I sometimes get errors in my mail.log as follows:

Jul 20 16:36:12 stoned-hacker amavis[14077]: (14077-07)
lookup_sql_field(id) (WARN: no such field in the SQL table),
"mai...@st..." result=undef
Jul 20 16:36:32 stoned-hacker amavis[13326]: (13326-11)
lookup_sql_field(id) (WARN: no such field in the SQL table),
"mai...@st..." result=undef
Jul 20 16:38:28 stoned-hacker amavis[14077]: (14077-08)
lookup_sql_field(id) (WARN: no such field in the SQL table),
"mai...@st..." result=undef


root@stoned-hacker:/var/log# cat /etc/amavis/conf.d/50-user
use strict;

#
# Place your configuration directives here.  They will override those in
# earlier files.
#
# See /usr/share/doc/amavisd-new/ for documentation and examples of
# the directives you can use in this file
#

@lookup_sql_dsn = (
    ['DBI:mysql:database=postfixadmin;host=127.0.0.1;port=3306',
     'postfixadm',
     'aaaaaaaa']);

$sql_select_policy = 'SELECT domain FROM domain WHERE CONCAT("@",domain)
IN (%k)';



#------------ Do not modify anything below this line -------------
1;  # ensure a defined return
root@stoned-hacker:/var/log#



Is this a known problem as I can't find anything about it on google.

I am not the best with SQL so can't re-arrange the tables.

I would be really grateful if anyone can help me with this.

Thanks in advance,

Dusty.

P.S: Not sure what else you may need to see, just ask and i'll show ya.