My only suggestion would be to say clearly that if $myhostname is not
explicitely declared there are warnings on the log files and the
messages are not stored into the DB (MySQL at least).
Maybe to produce a newer package is not absolutely needed yet...
--
Insecure dependency when using sql for
I have found a solution.
First I have noticed another log in /var/log/mail.err:
...amavis[23324]: (23324-03) ERROR sql_storage: too many retries on
storing preliminary, info not saved
which confirmed that nothing went into the DB.
Googling about this error, I found a message from Mark Martinec
Yes, I can connect to the DB using this user and password. I can write
to the msgs table. I granted all the privileges to the amavis user on
tables on the amavis DB (exactly the same that you sent). Exactly the
same result.
This is coming from the save_info_preliminary subroutine on amavisd-new.
I
Yes, I also recognized that the transaction is not being comitted to the
DB.
This is the schema of msgs on my server:
show create table msgs;
| msgs | CREATE TABLE `msgs` (
`mail_id` varchar(12) NOT NULL default '',
`secret_id` varchar(12) default '',
`am_id` varchar(20) NOT NULL default
An extra note:
The command "INSERT INTO msgs..." never touch MySQL. The msgs table is
empty and the mysql log file doesn't say a thing about 'INSERT INTO
msgs...'.
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification be
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,
d
I am running MySQL 4.1.
Source: mysql-dfsg-4.1
Version: 4.1.15-1ubuntu5
--
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 ubun
Public bug reported:
Binary package hint: amavisd-new
When using @storage_sql_dsn Amavis complains on the log file:
WARN save_info_preliminary: sql execute: sts=, Insecure dependency in
parameter 10 of DBI::st=HASH(0xa077aec)->execute method call while
running with -T switch at (eval 41) line 12
