Glenn,
> So I just upgraded to 2.4.1,1 (FreeBSD port) and decided to go through
> my configuration file and re-do it. I'm running perl 5.8.8,
> DBD-mysql41-3.0003, mysql-server-4.1.18, SpamAssassin 3.1.1_4, and
> FreeBSD 4.11-RELEASE.
>
> So I mounted the new conf file, and I restarted AMaViS and Postfix, and
> now I'm seeing:
>
> May 18 19:30:25 caduceus amavis[9024]: (09024-01) (!) WARN
> save_info_final: sql execute failed within transaction, err=-1, S1000,
> DBD::mysql::st execute failed: called with 8 bind variables when 9 are
> needed at (eval 53) line 138, <GEN6> line 374. at (eval 53) line 153,
> <GEN6> line 374.
This looks like it:
amavisd-new-2.4.0 release notes:
INCOMPATIBLE CHANGES SINCE 2.3.3:
- incompatible change when logging or quarantining to SQL: added field
'quar_loc' to table 'msgs' to facilitate quarantine release, and added
FOREIGN KEY constraint for data consistency and simplified purging;
see below for a simple database modification;
...
- incompatible change when logging or quarantining to SQL is enabled
(as mentioned above, here is a more detailed description of the change):
* added column 'quar_loc' to table 'msgs' to store quarantine file name
(the same string as in macro %q, normally seen in the main log entry);
based on input from Andrew A. Neuschwander, Brian Wong and Craig Herring;
* add constraint FOREIGN KEY ... ON DELETE CASCADE to keep database
consistent (no orphaned records) and simplify maintenance deletions
and possibly speed them up; suggested by Brian Wong;
The following clause must be executed for upgrading pre-2.4.0
amavisd-new SQL schema to the 2.4.0 schema:
ALTER TABLE msgs ADD quar_loc varchar(255) DEFAULT '';
The following clause should preferably be executed to take advantage
of the ON DELETE CASCADE:
ALTER TABLE msgrcpt
ADD FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE;
ALTER TABLE quarantine
ADD FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE;
See updated suggested set of DELETE clauses at the end of README.sql.
Mark
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
