caratking brought it up in another thread (see below) but this is a show stopper for us. When a message is removed from quarantine and we use individual filters (for all our domains) the entry is added to the correct domains WL_AutoWhiteListForceDelivery.txt file, but never updates the db. So if you stop/start SFE, that entry is GONE because there was never a db entry written.

Please fix this as soon as possible as we can't proceed without it working. Thanks!

While I'm bitching  I want to say I think the concept of being able to define 'Use Default' for each of the other lists is quite important as it becomes a nightmare to keep updated common keywords and blacklisted IP's. Right now I'm working on scripts to sync up changes from default to all 300 domains and then it occured to me I need to do the same for deletes. If I only had to worry about one table, the default table, it would be more logical. Not sure if something like this can wait until 4.0. If someone have a couple thousand domains this would become problemetic without being able to use defaults for common lists like BL keywords, BL ip's, RBL's, SURBL's, etc.

caratking wrote: Inb SFE, when you look through the Quarantine messages, and select Deliver Selected the system adds the email pair for auto whitelisted. Is it also supposed to report back to the DB and add that pair (I see there is a table for it), and then sync with all the other servers? My autowhitelist table is empty.

caratking wrote: You are not running beta software in a production environment with 300 domains are you?  That would be crazy.

No, copied my production SFI directory to a test server trying it out. Since I want to have a separate autowhitelistdelivery file and authorizedto list for each domain I'm forced to make each of the domains a custom domain. I've only made a few custom domains for testing and evaluating  as I have to write scripts to split up the SFI authorizedto list into separate domains as well as the autowhitelistdelivery file. I thought I had 34000 entries but it is actually 340000 entries. Have to parse the list and add the right domain info into the tables.

 Until some of the duplication of the common data like keywords, suble, rbls can be consolidated by SFE to use defaults I may have to hold off a bit. Don't want to write scripts to duplicate common data across all domains and have to remove them later. Too much work ...

Yeah, I can go ahead and copy the 'all domains' 300 hundred times via the gui, The problem I have is there are 300 hundred copies of the same data that is common to all our domains (like BL keywords). If I want to add a keyword to all 300 domains I have to write a script to copy it to 300 domains. If I want to remove a RBL because its no longer in service, I have to write a script to remove it from 300 domains.

If each of my 300 domains was totally unique and did not share common lists like BL keywords, etc, there would be no issue. But if I have to have the same entries, why duplicate them? Let them share entries in ALL DOMAINS and then add whatever uniques entries as needed for individual domains. That way I can add a single bl keyword to ALL DOMAINS table and that will take care of all 300 domains

 What if I had 2000 domains, I can imagine the size of the db if you had dupes of each common bl/wl x 2000.

But since no one else seems to feel this is an issue, maybe I'm beating a dead horse. If the autowhitelistdelivery is fixed I guess I'll get the update and just write my scripts to update all the domains whenever I want to add a keyword or blacklist an IP. There is no easy way to add a single keyword to all the domains via the gui if your using unique bl/wl for each domain.

Thanks!

Just to add my 2 cents worth in, I have been following the whole SFE development since it's announcement. I am using the SFE RCs in a live environment to resolve the "mail splitting" issue. However due to current infrastructure (and time) I am yet to implement the "enterprise" features of SFE.

With that said I have for a while been contemplating the All Domains/Default scenerio which Web Guyz is mentioning. I too believe it would be best to have some sort of "inheritance".

I think a "server wide/default" set of rules (especially for keywords etc) should be a necessity.

Then the option of the current style defaults for not-customized domains or the alternative of customization for that domain.

Sorry if I didnt pipe up about this earlier, I think I sort of assumed that I had misunderstood the whole defaults thing and Web Guyz has now bought this out in the open.

With that said I think LogSat has done a great job with the development of SFE and attending to our bug reports etc, I do think that this "server wide defaults" thing needs to be addressed before many of us will choose to go live in enterprise mode.

Why not have both the system wide defaults and domain specific for each list like blacklist keywords,blacklist IP's, etc. When the text file is being built just read the specific default records and then the individual domain records for that specific table.

If a system wide default causes grief for a single domain just create a corresponding whitelist entry for that domain.

Some tables I think should have a 'default':

SURBL
MAPS
Blacklist Keywords
Blacklist FROM
Blacklist IP's
Blacklist Domains