Hi list!
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.
May 18 19:30:25 caduceus amavis[9024]: (09024-01) (!!) ERROR
sql_storage: too many retries on storing final, info not saved
The MySQL statements are direct out of the conf file.. I'm putting in my
old ones as well as the new ones, for comparison..
Old conf file SQL:
$sql_select_policy = 'SELECT *,users.id FROM users,policy'.
' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))'.
' ORDER BY users.priority DESC';
$sql_select_white_black_list = 'SELECT wb FROM wblist'.
' WHERE (rid=?) AND (wblist.email IN (%k))'.
' ORDER BY wblist.priority DESC';
New conf file SQL:
$sql_select_policy =
'SELECT *,users.id'.
' FROM users LEFT JOIN policy ON users.policy_id=policy.id'.
' WHERE users.email IN (%k) ORDER BY users.priority DESC';
$sql_select_white_black_list =
'SELECT wb'.
' FROM wblist LEFT JOIN mailaddr ON wblist.sid=mailaddr.id'.
' WHERE (wblist.rid=?) AND (mailaddr.email IN (%k))'.
' ORDER BY mailaddr.priority DESC';
%sql_clause = (
'sel_policy' => \$sql_select_policy,
'sel_wblist' => \$sql_select_white_black_list,
'sel_adr' =>
'SELECT id FROM maddr WHERE email=?',
'ins_adr' =>
'INSERT INTO maddr (email, domain) VALUES (?,?)',
'ins_msg' =>
'INSERT INTO msgs (mail_id, secret_id, am_id, time_num, time_iso,
sid,'.
' policy, client_addr, size, host) VALUES (?,?,?,?,?,?,?,?,?,?)',
'upd_msg' =>
'UPDATE msgs SET content=?, quar_type=?, quar_loc=?, dsn_sent=?,'.
' spam_level=?, message_id=?, from_addr=?, subject=? WHERE mail_id=?',
'ins_rcp' =>
'INSERT INTO msgrcpt (mail_id, rid, time_num,'.
' ds, rs, bl, wl, bspam_level, smtp_resp) VALUES (?,?,?,?,?,?,?,?,?)',
'ins_quar' =>
'INSERT INTO quarantine (mail_id, chunk_ind, time_num, mail_text)'.
' VALUES (?,?,?,?)',
'sel_quar' =>
'SELECT mail_text FROM quarantine WHERE mail_id=? ORDER BY chunk_ind',
);
I fully admit here that I'm no SQL master. I can get around, I can
add/remove users and such, but not this kind of stuff!
Can anyone tell me what's going on? :-/
Thanks in advance, and thanks for a great product--it's managed to keep
my old company, as well as my own server and users Spam/Virus free since
2001! :)
Best,
--Glenn
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
~Benjamin Franklin, Historical Review of Pennsylvania, 1759
-------------------------------------------------------
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/
