Yes I've checked. There is no problem write this kind of password here, only localhost is listen...

/etc/amavisd.conf:

@lookup_sql_dsn =  (
    ['DBI:mysql:database=vmail;host=127.0.0.1;port=3306', 'vmail', 'xxx']
);

# For Amavisd-new-2.6.x.
# WARNING: IN() may cause MySQL lookup performance issue.
$sql_select_policy = "SELECT domain FROM domain WHERE CONCAT('@', domain) IN (%k)";

# mysql -h localhost -u vmail --password=xxx vmail
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3025
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

I'm having exactly the same problem.

I'm running Amavis-new 2.6.6. so I uncommented the same lines, with the same result.

You asked the OP to log the queries, but that is rather pointless, because the error is that binding the parameter fails, so it's the construction of the query in the DB layer that fails, it isn't even passed on for execution.

To be sure, I did a tcpdump + pt_query_digest to look at the queries run (our setup uses a central DB server, so query logging there is not an option).

How to fix this, I don't currently have any anti-spam measures active on my domains, which is quite an issue for some as we receive hunderds of spam mails a day for those domains...

"bind_param failed", do you have correct SQL bind host/username/password?

No idea yet, sorry.

Sorry for digging this out, but anyone made further progress here? I have exactly the same problem.

I recently noticed that there's plenty of spam delivered normally and not put to junk folder for not configured domains.

And I would really like amavisd to look up domains in MySQL.

Running amavisd-new-2.6.5 (20110407) @ Ubuntu 12.04.2 LTS here.

Or is there any elegant method to run a newer version of amavisd under Ubuntu (maybe self compiled) ?

Thanks Zhang, that's a good idea too! I am using this variant for now.

Still, I'd prefer to have it perfect

Here's a work around.  Create a view of vmail.domain in amavisd.  For example:

mysql -u root -p
msyql> create view amavisd.vmail_domian as select domain from vmail.domain;
mysql> GRANT SELECT ON `vmail` . * TO 'amavisd'@'localhost';
mysql> \q

edit /etc/amavisd/amavisd.conf and bottom of file make the following changes:
@storage_sql_dsn = (
    ['DBI:mysql:database=amavisd;host=127.0.0.1;port=3306', 'amavisd', 'xxxxxxxxxxxxxxx'],
);
# Uncomment below two lines to lookup virtual mail domains from MySQL database.
#@lookup_sql_dsn =  (
#    ['DBI:mysql:database=vmail;host=127.0.0.1;port=3306', 'vmail', 'xxxxxxxxxxxxxxxx'],
#);
# For Amavisd-new-2.7.0 and later versions. Placeholder '%d' is available in Amavisd-2.7.0+.
$sql_select_policy = "SELECT domain FROM vmail_domain WHERE domain='%d'";

It worked for me.

I spoke too soon.  My last post does not work.
After digging through the amavisd code a bit, I've determined that the $sql_select_policy query will not work as an easy wholesale way to enable all domains to be scanned.  The reason being is that this query is intended to return a list of policy values.  The default query coded into amavisd actually looks like this:

$sql_select_policy =
    'SELECT users.*, policy.*, users.id'.
    ' FROM users LEFT JOIN policy ON users.policy_id=policy.id'.
    ' WHERE users.email IN (%k) ORDER BY users.priority DESC';

The simplest and easiest way to ensure that all email domains are scanned and tagged for spam is to use:

@local_domains_maps = ( ["."]);

Sorry for the bad info in my original post.

I think that this may possibly work: http://un.codiert.org/2008/10/amavisd-s … al-domain/
need some help testing it

*It'd require a MySQL View as such:*

CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `root`@`localhost` 
    SQL SECURITY DEFINER
VIEW `domains` AS
    SELECT 
        `vmail`.`domain`.`domain` AS `domain`
    FROM
        `vmail`.`domain` 
    UNION SELECT 
        `domain`.`alias_domain` AS `alias_domain`
    FROM
        `vmail`.`alias_domain` `domain`

With this, we'll probably need a few more tweaks to now tighten security.
Incoming Mail [from Remote to Local] is tagged as "Passed CLEAN {RelayedInternal}, MYUSERS LOCAL"
Outgoing Mail [from Local to Remote] is tagged as " Passed CLEAN {RelayedInternal}, MYNETS/MYUSERS LOCAL"

So MyNets should be the only directive with Originating on, and less scanning. I think..?
We can also remove DKIM Checking for outgoing mails, as it is a bit useless it always just marks them as PASS, JUST GENERATED ASSUMED GOOD, which makes no effect down the line just adds useless headers.

Okay I think I've fixed it, the MYSQL View I was using in the first place was wrong, a bit of MariaDB Logging led me to that. Use the following instead, and also do the @local_domains_maps change I mentioned above, I have yet to fix the Policy Banks and then will include my whole config file as text and a file along with the MySQL View.

CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `root`@`localhost` 
    SQL SECURITY DEFINER
VIEW `amavisd`.`domains` AS
    SELECT 
        CONCAT("@", `vmail`.`domain`.`domain`) AS `domain`
    FROM
        `vmail`.`domain` 
    UNION SELECT 
        CONCAT("@", `domain`.`alias_domain`) AS `alias_domain`
    FROM
        `vmail`.`alias_domain` `domain`

It DKIM Verifies all incoming mail, even if its Local=>Local, but not Local=>Remote, so *=>Local, which is perfect