Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - rejectid cannot be modified
  FAQ FAQ  Forum Search   Register Register  Login Login

rejectid cannot be modified

 Post Reply Post Reply
Author
tcig View Drop Down
Newbie
Newbie


Joined: 30 March 2005
Location: Germany
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote tcig Quote  Post ReplyReply Direct Link To This Post Topic: rejectid cannot be modified
    Posted: 21 April 2007 at 7:35pm

after update to 3.5.3.661 we got the following errors during startup:

04.22.07 01:21:15:471 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:486 -- Adding default Reject Codes: EmailFrom is in local blacklist file
04.22.07 01:21:15:486 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:518 -- Adding default Reject Codes: Reverse DNS not found
04.22.07 01:21:15:518 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:533 -- Adding default Reject Codes: Empty Mail From
04.22.07 01:21:15:533 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:565 -- Adding default Reject Codes: Mail From and Mail To are equal
04.22.07 01:21:15:565 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:596 -- Adding default Reject Codes: Mail From and Mail To domains are equal
04.22.07 01:21:15:596 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:611 -- Adding default Reject Codes: Exceeded maximum number of RCPT TO
04.22.07 01:21:15:627 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:643 -- Adding default Reject Codes: IP address is from a blacklisted country
04.22.07 01:21:15:643 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:658 -- Adding default Reject Codes: EmailTO is in local blacklist file
04.22.07 01:21:15:658 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:674 -- Adding default Reject Codes: EmailTO is not in AuthorizedTOEmail list
04.22.07 01:21:15:674 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:690 -- Adding default Reject Codes: no relay allowed or % found in FROM address
04.22.07 01:21:15:690 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:705 -- Adding default Reject Codes: IP found in MAPS search
04.22.07 01:21:15:705 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:721 -- Adding default Reject Codes: Keywords found in content
04.22.07 01:21:15:721 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:736 -- Adding default Reject Codes: Statistical filter match
04.22.07 01:21:15:736 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:752 -- Adding default Reject Codes: SPF Sender Policy Framework match
04.22.07 01:21:15:752 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:768 -- Adding default Reject Codes: Invalid sender domain MX record
04.22.07 01:21:15:768 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:783 -- Adding default Reject Codes: Virus Found in email
04.22.07 01:21:15:799 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:799 -- Adding default Reject Codes: IP blocked by honeypot entry
04.22.07 01:21:15:815 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:815 -- Adding default Reject Codes: URL in email found in SURBL search
04.22.07 01:21:15:830 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:830 -- Adding default Reject Codes: Detected spam signature in embedded image
04.22.07 01:21:15:846 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:846 -- Adding default Reject Codes: SFDB filter match
04.22.07 01:21:15:861 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:861 -- Adding default Reject Codes: Failed AUTH LOGIN
04.22.07 01:21:15:877 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:877 -- Adding default Reject Codes: Found prohibited attachment
04.22.07 01:21:15:893 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:16:486 -- Listener Started

After this no messages are stored in the quarantine database

System: win2003 R2, Sp 2, Mysql 5.037, ODBC 5.00.11 (also tried 3.5)

any help ?

 

 

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4105
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2007 at 10:43am
Can you please also add the lines in the log prior to the error? There should be something indicating why SpamFilter is trying to re-insert these entries in the tblRejectCodes table. The entries probably already exist, which is why the errors are appearing.

Please also let us know if you've upgraded an existing version of SpamFilter, or if this is a new install. Please also let us know if you're running SpamFilter in "Standard" or in "Enterprise" mode.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
tcig View Drop Down
Newbie
Newbie


Joined: 30 March 2005
Location: Germany
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote tcig Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2007 at 2:05pm

solved ! It's also the problem of the ODBC Driver. Either ODBC 3.51.14 nor ODBC 5 cannot be used. After using ODBC 3.51.12 everything is working fine.

The problem was: before I changed to Spamfilter 3.5.3.661 I did a upgrade to Mysql 5.037 and ODBC 3.51.14. ...

Do anybody knows where is the Problem in those ODBC - Connectors ?

 

 

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4105
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2007 at 10:04pm
We're looking into it. For some reason one of the DLLs used by the MySQL ODBC drivers 3.51.14 (MSDART.DLL - a Microsoft DLL) is throwing an Access Violation (it's crashing...). We're trying to find out what the differences between v3.51.12 and v3.51.14 of the MySQL ODBC drivers could be causing this.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.164 seconds.