Community Discussions and Support
sharing Spamhalter databases

geby, thanks for that information. Unfortunately, Spamhalter daemon (or even a server for mercury/32) is not an option.

#1 Might it be possible to have the wi_sph Pmail plugin use a shared copy anyway?
    While I don't really care about speed, having a separate database for each mailbox does not contribute to good performance either.

#2 Also, can the  wi_sph.ini file be adapted to use mail folder *names*, not just IDs?
    If someone deletes a folder, the ID is invalid even if the folder is recreated (pmail's content control handler will create folders automatically if they do not exist, but the ID will change).

Thanks (and thanks for Spamhalter too! :)
Cy

<p>geby, thanks for that information. Unfortunately, Spamhalter daemon (or even a server for mercury/32) is not an option. </p><p>#1 Might it be possible to have the wi_sph Pmail plugin use a shared copy anyway?     While I don't really care about speed, having a separate database for each mailbox does not contribute to good performance either.</p><p>#2 Also, can the  wi_sph.ini file be adapted to use mail folder *names*, not just IDs?     If someone deletes a folder, the ID is invalid even if the folder is recreated (pmail's content control handler will create folders automatically if they do not exist, but the ID will change).</p><p>Thanks (and thanks for Spamhalter too! :) Cy </p>

Is there a way to get wi_sph.dll to use a shared copy of its databases (words4.db3 and white4.db3)?

If not, might it be possible to add this functionality in the next pmail release? For instance with a "bayDataDir=" parameter in the WI_sph.ini file?
[struck out because this isn't the wishlist forum :)]

From what I could gather from from reading SQLite sources and also from the SQLite FAQ ( http://www.sqlite.org/faq.html#q5 ), the back end does all the necessary record and file locking anyway (and evidently does so transparently), so from the point of view of the calling application there aren't any technical restrictions that might preclude concurrent access.

Any help would be much appreciated,
C.

ps: This is a venerable NetWare box btw. And yes, its running Mercury NLM. :)
 

Is there a way to get wi_sph.dll to use a shared copy of its databases (words4.db3 and white4.db3)? <p><strike>If not, might it be possible to add this functionality in the next pmail release? For instance with a "bayDataDir=" parameter in the WI_sph.ini file?</strike><sup> [struck out because this isn't the wishlist forum :)]</sup> </p> <p>From what I could gather from from reading SQLite sources and also from the SQLite FAQ ( http://www.sqlite.org/faq.html#q5 ), the back end does all the necessary record and file locking anyway (and evidently does so transparently), so from the point of view of the calling application there aren't any technical restrictions that might preclude concurrent access.</p> <p>Any help would be much appreciated, C. </p> <p>ps: This is a venerable NetWare box btw. And yes, its running Mercury NLM. :)  </p>

wi_sph Pmail plugin is designed for run on local computer. Yes, it can work if mailbox is located on network too, but it have big performance penalty! So, Spamhalter Pmail plugin is designed for standalone installations.

On site configurations use common Spamhalter deamon instead. It have shared database natively, and it is fastest possible solution. Wi_sph.dll can be used as helper for Spamhalter server daemon - you not lost Pmail GUI integration. (For enable helper mode just copy your spamhalter.ini to same folder with Pmail installation.)

However Spamhalter is not solution for NLM Mercury. Sorry. 

<p>wi_sph Pmail plugin is designed for run on local computer. Yes, it can work if mailbox is located on network too, but it have big performance penalty! So, Spamhalter Pmail plugin is designed for standalone installations.</p><p>On site configurations use common Spamhalter deamon instead. It have shared database natively, and it is fastest possible solution. Wi_sph.dll can be used as helper for Spamhalter server daemon - you not lost Pmail GUI integration. (For enable helper mode just copy your spamhalter.ini to same folder with Pmail installation.)</p><p>However Spamhalter is not solution for NLM Mercury. Sorry. </p>
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft