Re: [AMaViS-user] Please help--Amavis is stuck :-/

2008-08-07 Thread Mark Martinec
Glenn,

 I have about 2000 emails in queue, all saying:
   (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing,
   id=37705-01-2, sql-enter FAILED: sql exec: err=16, S1000, DBD::mysql::st
   bind_param failed: Illegal parameter number at (eval 99) line 164,
   GEN18 line 24.)
 I've gone through the mysql tweaks that RELEASE_NOTES said.. :-/
 Running: Amavisd-New 2.6.1,1 on FreeBSD 7.0 with Postfix 2.5.1_2,1

Looks like the 'ins_msg' entry in %sql_clause (probably in a config file)
does not match the version of amavisd.

amavisd-new-2.6.0 introduced a new field 'partition_tag' into tables
maddr, msgs, msgrcpt and quarantine. This required a change at three
places: altering SQL tables themselves, adding an extra parameter
in SQL clauses (stored in %sql_clause), and providing an actual
extra parameter in the code (a call to bind_param from amavisd).

Seems to me you had an explicit setting of %sql_clause in your
config file, overriding a built-in default. Now that the default
has changed, you need also change your manual override.

  Mark

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/


[AMaViS-user] Please help--Amavis is stuck :-/

2008-08-05 Thread Glenn Sieb
Hello!

I have about 2000 emails in queue, all saying:

(host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, 
id=37705-01-2, sql-enter FAILED: sql exec: err=16, S1000, DBD::mysql::st 
bind_param failed: Illegal parameter number at (eval 99) line 164, 
GEN18 line 24. (in reply to end of DATA command))

I can send a (sanitized) amavisd.conf if that helps. I've gone through 
the mysql tweaks that RELEASE_NOTES said.. :-/

I'm going to try sending this from my real account, but since incoming 
mail is bottlenecked, please cc me at rainbear at gmail dot com

Thank you!

Running: Amavisd-New 2.6.1,1 on FreeBSD 7.0 with Postfix 2.5.1_2,1

Best,
--Glenn

-- 
...destination is merely a byproduct of the journey
   --Eric Hansen


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/