[Bug 211915] Re: Insecure dependency when using sql for Log Reporting

[Tom GF]

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, me at test.com, 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
Server Team, which is subscribed to amavisd-new in ubuntu.