> I've got cluebringer-2.0.7-1.noarch.rpm installed and working except
> nowhitelist or autoblacklist entries are being created.
>
> In the logs I can see
>
> [2009/06/19-15:32:00 - 7748] [GREYLISTING] ERROR: Database insert
> failed: cbp::dblayer::DBDo(125): Error executing command: You have an
> error in your SQL syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use near
> '@t...@greylisting_autowhitelist
> %09%09%09%09%09%09%09%09%09%09(TrackKey,Added,LastSeen,Comment)
> %09%09%09%09%09%09' at line 1
>
> The error seems to be in /usr/lib/policyd-2.0/cbp/modules/Greylisting.pm
>
> Should the SQL statement be referencing @t...@greylisting_autowhitelist as
> the table name? The only 4 lines that syntax is used is in the AWL and
> ABL code.
>
>
Fixed in r463, appears a patch from trunk leaked in table prefix macros.
Patch attached.
Regards
Nigel
Index: cbp/modules/Greylisting.pm
===================================================================
--- cbp/modules/Greylisting.pm (revision 462)
+++ cbp/modules/Greylisting.pm (revision 463)
@@ -441,7 +441,7 @@
# Update blacklisting to the new details
$sth = DBDo('
UPDATE
- @t...@greylisting_autoblacklist
+ greylisting_autoblacklist
SET
TrackKey = ?,
Added = ?,
@@ -459,7 +459,7 @@
} else {
# Record blacklisting
$sth = DBDo('
- INSERT INTO @t...@greylisting_autoblacklist
+ INSERT INTO greylisting_autoblacklist
(TrackKey,Added,Comment)
VALUES
(?,?,?)
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users
