libdbd-mysql-perl:
Version: 3.0002-2build1

The error on /var/log/mail.log:

... amavis[22796]: (22796-01) sql begin transaction
... amavis[22796]: (22796-01) sql: executing clause: SELECT id FROM maddr WHERE 
email=?
... amavis[22796]: (22796-01) sql: executing clause: INSERT INTO maddr (email, 
domain) VALUES (?,?)
... amavis[22796]: (22796-01) save_info_preliminary: 8, [EMAIL PROTECTED], new
... amavis[22796]: (22796-01) sql: executing clause: INSERT INTO msgs (mail_id, 
secret_id, am_id, time_num, time_iso, sid, policy, client_addr, size, host) 
VALUES (?,?,?,?,?,?,?,?,?,?)
... amavis[22796]: (22796-01) sql rollback
... amavis[22796]: (22796-01) save_info_preliminary: rollback done
... amavis[22796]: (22796-01) WARN save_info_preliminary: sql execute: sts=, 
Insecure dependency in parameter 10 of DBI::st=HASH(0xa025714)->execute method 
call while running with -T switch at (eval 41) line 127, <GEN22> line 25. at 
(eval 41) line 131, <GEN22> line 25.
... amavis[22796]: (22796-01) sql_storage: retrying prelim., 3 attempts remain


in /etc/amavis/conf.d/50-user:
# SQL Lookup
@lookup_sql_dsn = ( ['DBI:mysql:database=db;host=host;', 'user', 'pass'] );
@storage_sql_dsn = @lookup_sql_dsn;  # none, same, or separate database

$log_level = 5; # after your suggestion

The DB schema is coming from /usr/share/doc/amavisd-new/README.sql.gz.

Thanks for helping to solve this issue.

-- 
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to