Search found 133 matches

by sckramer2
2016-06-11 06:06
Forum: SpamAssassin implementation discussions
Topic: HmailServer & SpamAssassin : The WinSock error code is 2.
Replies: 73
Views: 29122

Re: HmailServer & SpamAssassin : The WinSock error code is 2.

https://www.jam-software.com/spamassassin/changes.shtml

FYI: jam software just released sa fixing the DNS Blacklist lookups not happening... was wondering why those were not showing up in the tests!
by sckramer2
2016-06-10 06:16
Forum: SpamAssassin implementation discussions
Topic: HmailServer & SpamAssassin : The WinSock error code is 2.
Replies: 73
Views: 29122

Re: HmailServer & SpamAssassin : The WinSock error code is 2.

Ok, yes I've seen talk about it & just ignore that error-- was just fyi, seemed close on the timestamps to the spamass errors.
by sckramer2
2016-06-10 05:23
Forum: SpamAssassin implementation discussions
Topic: HmailServer & SpamAssassin : The WinSock error code is 2.
Replies: 73
Views: 29122

Re: HmailServer & SpamAssassin : The WinSock error code is 2.

Screen Shot 2016-06-09 at 11.17.16 PM.png
Could this be a clue, these nearby when the HM5508 error happens:

Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value.......... ---> goes on for awhile
by sckramer2
2016-06-09 22:50
Forum: SpamAssassin implementation discussions
Topic: HmailServer & SpamAssassin : The WinSock error code is 2.
Replies: 73
Views: 29122

Re: HmailServer & SpamAssassin : The WinSock error code is 2.

See this post:

viewtopic.php?f=22&t=28227#p175811

I'm getting this one: HM5508, not new

Edit, checked 6-3-2016 logs: 3 HM5157's (winsock errors) there... so on the same page with this.
by sckramer2
2016-06-09 18:04
Forum: SpamAssassin implementation discussions
Topic: HmailServer & SpamAssassin : The WinSock error code is 2.
Replies: 73
Views: 29122

Re: HmailServer & SpamAssassin : The WinSock error code is 2.

Ugh, not getting windsock error-- We'll need the force to finally fix this!

Anyone try a workaround... i.e. scripting a retry? Thanks!
by sckramer2
2016-06-09 15:55
Forum: SpamAssassin implementation discussions
Topic: HmailServer & SpamAssassin : The WinSock error code is 2.
Replies: 73
Views: 29122

Re: HmailServer & SpamAssassin : The WinSock error code is 2.

"ERROR" 2628 "2016-06-09 08:56:35.935" "Severity: 2 (High), Code: HM5508, Source: SpamAssassinTestConnect::TestConnect, Description: The SpamAssassin tests did not complete. Please confirm that the configuration (host name and port) is valid and that SpamAssassin is running." Thu Jun 9 08:56:33 201...
by sckramer2
2015-08-28 18:26
Forum: General discussions
Topic: DataDirSync remove DB entries not on disk
Replies: 2
Views: 669

DataDirSync remove DB entries not on disk

Why is there no option for: remove DB entries not found on disk? I have an out of sync mail with 384,000 rows in hm_messages, but only 260,000K files on the disk... Is there a way to do this? Could DDS be updated to do this? I have no option to restore from BU etc... Also you can't just delete hm_me...
by sckramer2
2015-04-10 02:56
Forum: General discussions
Topic: Safe to wipe hm_messages
Replies: 3
Views: 840

Re: Safe to wipe hm_messages

I have the same problem, need to remove db entries that don't have files...
by sckramer2
2015-04-09 20:54
Forum: General discussions
Topic: Safe to wipe hm_messages
Replies: 3
Views: 840

Safe to wipe hm_messages

Is it safe to wipe hm_messages, then rebuild it with the datasyncronizer?
by sckramer2
2015-04-07 02:05
Forum: Feature requests
Topic: Allow outbound Spamassassin scans when authenticated
Replies: 11
Views: 7032

Re: Allow outbound Spamassassin scans when authenticated

Any chance we can have this Martin? Even tho it's miles down the feature request list? Get bit by this all the time--
by sckramer2
2014-08-18 18:16
Forum: Development & alpha discussions
Topic: STARTTLS feedback?
Replies: 157
Views: 50835

Re: STARTTLS feedback?

Would adding a counter for successfully/unsuccessfully encrypted messages be worthwhile on the status page?
by sckramer2
2014-08-02 19:10
Forum: General discussions
Topic: Failure to flag message that scores above threshold with SA
Replies: 28
Views: 3722

Re: Failure to flag message that scores above threshold with

Search your logs -- see if it's related to this thread:

http://www.hmailserver.com/forum/viewto ... =7&t=25933

You might have to turn on all logging options--
by sckramer2
2014-08-02 18:55
Forum: General discussions
Topic: Failure to flag message that scores above threshold with SA
Replies: 28
Views: 3722

Re: Failure to flag message that scores above threshold with

Please see if those same flagged emails are sitting in hmailserver\temp
by sckramer2
2014-07-26 02:45
Forum: General discussions
Topic: SpamAssassin temp size off by one
Replies: 15
Views: 7001

Re: SpamAssassin temp size off by one

anyway... please can we have an ini setting to fudge the off by 1?
by sckramer2
2014-07-26 02:24
Forum: General discussions
Topic: SpamAssassin temp size off by one
Replies: 15
Views: 7001

Re: SpamAssassin temp size off by one

Just add a 0 to the end of all your spam mark numbers and you will get the same functionality with no serverside changes. Will give you much greater scope for marking spam so 1 becomes 10 and in your example 1.5 would now be 15, then in your RBLS, you can tailor to suit. I'll experiment, lately, I'...
by sckramer2
2014-07-26 02:20
Forum: General discussions
Topic: SpamAssassin temp size off by one
Replies: 15
Views: 7001

Re: SpamAssassin temp size off by one

yep, that's why i said "bit of a bump"
by sckramer2
2014-07-26 01:33
Forum: General discussions
Topic: SpamAssassin temp size off by one
Replies: 15
Views: 7001

Re: SpamAssassin temp size off by one

this is a bit of a bump, but was thinking hmailservers "Spam mark threshold" is a little thick... would it be useful to add a decimal place 1.x... to fine tune?
by sckramer2
2014-07-14 18:37
Forum: General discussions
Topic: SpamAssassin temp size off by one
Replies: 15
Views: 7001

Re: SpamAssassin temp size off by one

Hi Bill, I'm not sure how to do a compare for you to help debug... sure I have the temp file, but how do I recreate the source (from SA at that time)? I can manually score the email again, but it's always a little different (order of blacklist lookups, bayes learning etc)-- If it's not too hard, an ...
by sckramer2
2014-07-12 00:35
Forum: General discussions
Topic: SpamAssassin temp size off by one
Replies: 15
Views: 7001

Re: SpamAssassin temp size off by one

Anyone have a suggestion on this? It let's ridiculously high scored spams thru, and people are asking about it... thousands of emails are filtered just fine, but those 20 a day are a problem!

Thanks!
by sckramer2
2014-07-09 21:57
Forum: General discussions
Topic: SpamAssassin temp size off by one
Replies: 15
Views: 7001

Re: SpamAssassin temp size off by one

Hi, "SA: Temp file size did not match what Spamd reported! (temp: 9173, spamd: 9174). Reverting to original message file." We're getting a bunch of these everyday also, took awile to find why hmailserver\temp was filling up with scored spams, but still allowed the original message through. Always of...
by sckramer2
2014-03-26 01:07
Forum: SpamAssassin implementation discussions
Topic: Pyzor & SpamAssassin 3.4.0-RC5
Replies: 2
Views: 1857

Pyzor & SpamAssassin 3.4.0-RC5

Has anyone installed done a windows pyzor install successfully & enabled spamassassin to use it? I tried but can't get it to work... I'm not very familiar with python on windows--

Thanks!
by sckramer2
2013-10-17 20:03
Forum: General discussions
Topic: wiping the hm_messages table
Replies: 1
Views: 786

wiping the hm_messages table

Is it safe to just completely wipe the hm_messages table & rebuild from the files w/the data synchronizer?
by sckramer2
2013-10-04 22:09
Forum: General discussions
Topic: Spamming Issue
Replies: 11
Views: 1918

Re: Spamming Issue

I wonder if someone's figured out you to trick/compromise hmailserver to do this.... we got hit this week also--
by sckramer2
2013-10-03 20:44
Forum: General discussions
Topic: Performance, MySQL vs. MSSQL
Replies: 5
Views: 1998

Re: Performance, MySQL vs. MSSQL

not often, but need to know my options when there are problems--
by sckramer2
2013-10-03 19:39
Forum: General discussions
Topic: Performance, MySQL vs. MSSQL
Replies: 5
Views: 1998

Re: Performance, MySQL vs. MSSQL

hoping someone has 1st hand experience trying this, could just be that one MySQL statement is not optimal, but screams on another db server, I know mssql is the default db, maybe perf is ok there, for situations like this or maybe there's a quick index I could apply to the tables that helps it, with...
by sckramer2
2013-10-03 19:11
Forum: General discussions
Topic: Performance, MySQL vs. MSSQL
Replies: 5
Views: 1998

Performance, MySQL vs. MSSQL

In the process of cleaning up an hMailserver that had an acct used to spam (too easy a password), with 300,000+ email in the delivery queue, a lot of the pain is how long it takes to delete these. It took more than a day to clear the queue, it's all the mysql sql statements deleting them 1 by 1... T...
by sckramer2
2013-10-01 16:54
Forum: General discussions
Topic: Alias / Spammers
Replies: 6
Views: 1864

Re: Alias / Spammers

One of our systems just got hit by something like this... 250,000 emails in the delivery queue (takes forever to remove these) How do you find which acct is compromised (too weak a password)? I'm sifting thru logs & cant find that out... basically I'm stabbing in the dark disabling acct's to see if ...
by sckramer2
2013-01-31 17:55
Forum: General discussions
Topic: [Greylisting] Problems with messages from google.com (gmail)
Replies: 28
Views: 14804

Re: [Greylisting] Problems with messages from google.com (gm

does the hmail domain whitelist apply to the greylisting engine?
mattg wrote:I believe it applies to ALL anti-spam methods including greylisting
are you 100% sure about this?
by sckramer2
2013-01-31 01:18
Forum: General discussions
Topic: [Greylisting] Problems with messages from google.com (gmail)
Replies: 28
Views: 14804

Re: [Greylisting] Problems with messages from google.com (gm

we had an important email sent at 2pm arrive at 9pm, because each of the google retrys used a different ip address, it eventually got a hit in the hmail lookup table
by sckramer2
2013-01-30 00:41
Forum: General discussions
Topic: [Greylisting] Problems with messages from google.com (gmail)
Replies: 28
Views: 14804

Re: [Greylisting] Problems with messages from google.com (gm

too bad greylisting does not let you whitelist domains... we are having gmail greylisting problems this week also & have the bypass on SPF checked... maybe google added ip addr's & the TTL's on the SPF-DNS records are not updated yet
by sckramer2
2011-12-21 19:45
Forum: Development & alpha discussions
Topic: LATEST EXPERIMENTAL BUILD - 5.4-B2014060501
Replies: 228
Views: 140917

Re: LATEST EXPERIMENTAL BUILD - 5.4-B2011120101

Bill,

We're using the latest experimental, the gui changes are nice, no problems--

--Scott
by sckramer2
2011-11-29 20:40
Forum: Scripting
Topic: selecting all messages in account, folder recursion needed?
Replies: 11
Views: 4270

Re: selecting all messages in account, folder recursion need

you're right, but it started to get hairy when I actually used recursion & errors happened (over millions of messages), this way an error happens it's just a missed folder name on a single messages, instead of some unknown chunk-- + vbscript has limited error control & this is not done yet, i'll rev...
by sckramer2
2011-11-29 20:16
Forum: Scripting
Topic: selecting all messages in account, folder recursion needed?
Replies: 11
Views: 4270

Re: selecting all messages in account, folder recursion need

yep, but this was easier on the eyes :), & in a year i'll be able to debug it, along with other people, so i went this simpler route--
by sckramer2
2011-11-29 20:07
Forum: Development & alpha discussions
Topic: hMailServer 5.4 Alpha (Build 1913) up
Replies: 24
Views: 23070

Re: hMailServer 5.4 Alpha (Build 1913) up

argh, my bad :) -- thought i saw 1931 in the subject -- you can delete my post!
by sckramer2
2011-11-29 20:00
Forum: Development & alpha discussions
Topic: hMailServer 5.4 Alpha (Build 1913) up
Replies: 24
Views: 23070

Re: hMailServer 5.4 Alpha (Build 1913) up

ObiWan is using it on another thread & I just wanted to bring it up in general, thought maybe this was a good thread for it, since it's the version w/the problem
by sckramer2
2011-11-29 19:38
Forum: Development & alpha discussions
Topic: hMailServer 5.4 Alpha (Build 1913) up
Replies: 24
Views: 23070

Re: hMailServer 5.4 Alpha (Build 1913) up

Bill,

Maybe 5.4 beta should be pulled from the official download page, it has the attachment corruption problem people are running into--
by sckramer2
2011-11-29 17:52
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

the big thing is the query is only run twice a day instead of every 60 seconds (and multiple times in a row if there are new messages)-- I'm not sure how mssql handles it, but w/mysql it is expensive

you should try it out & let us know--
by sckramer2
2011-11-29 17:46
Forum: Scripting
Topic: selecting all messages in account, folder recursion needed?
Replies: 11
Views: 4270

Re: selecting all messages in account, folder recursion need

this works without recursion: Set Messages = Account.Messages and yes, you can't get the foldname (that I know of) from Messages so I had to fire off a db query to get it: select foldername from hm_imapfolders where folderid = (select messagefolderid FROM hm_messages where messageid = '" & CStr(id) ...
by sckramer2
2011-11-23 19:31
Forum: Scripting
Topic: selecting all messages in account, folder recursion needed?
Replies: 11
Views: 4270

Re: selecting all messages in account, folder recursion need

I'm just using vbscript, I know how to do the recursion, but i'd rather not & keep it simpler-- was hoping there was an un'doc'd feature in the api
by sckramer2
2011-11-23 19:12
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

btw, the FULL scan sql can be improved:

http://www.hmailserver.com/forum/viewto ... 30#p132030

the FULL scan is still firing the original statement
by sckramer2
2011-11-21 18:59
Forum: Scripting
Topic: Message.Recipients [Archive Script]
Replies: 2
Views: 1490

Re: Message.Recipients [Archive Script]

i suppose, that kind'a sucks
by sckramer2
2011-11-21 18:54
Forum: Scripting
Topic: selecting all messages in account, folder recursion needed?
Replies: 11
Views: 4270

selecting all messages in account, folder recursion needed?

Hello, Does the API really make you script folder recursion to get to all messages in an account? Can I just get at a flat list of messages, and pull the folder name from each message? The database is organized this way anyway-- This is to support my initial full archive script, also can be useful t...
by sckramer2
2011-11-18 22:03
Forum: Scripting
Topic: Message.Recipients [Archive Script]
Replies: 2
Views: 1490

Message.Recipients [Archive Script]

Message.Recipients contains all the recipients when called from the OnAcceptMessage eventhandler but when used this way, stand alone, its always 0: Set Messages = Account.IMAPFolders.ItemByName(FOLDER_TO_ARCHIVE).Messages For MessageNum = Messages.Count To 1 Step -1 Set Message = Messages.Item(Messa...
by sckramer2
2011-11-18 21:57
Forum: Scripting
Topic: Saving attachments to database [Archive Script]
Replies: 6
Views: 3199

Re: Saving attachments to database [Archive Script]

the memorystream object works fine when here OnAcceptMessage '------------------------------------------------------------------ ' Hmailserver Eventhandlers '------------------------------------------------------------------ Sub OnAcceptMessage(Client, Message) ArchiveToDatabase(Message) End Sub but...
by sckramer2
2011-11-18 06:31
Forum: Scripting
Topic: Saving attachments to database [Archive Script]
Replies: 6
Views: 3199

Re: Saving attachments to database [Archive Script]

Thanks!

Good idea, I'll add that--

I use memory streams all the time in c#, was surprised this worked in vbscript
by sckramer2
2011-11-18 06:24
Forum: Scripting
Topic: Saving attachments to database [Archive Script]
Replies: 6
Views: 3199

Re: Saving attachments to database [Archive Script]

can you believe this actually works!? Set ms = CreateObject("System.IO.Memorystream") for i = 0 to Attachments.Count - 1 dim attFilename attFilename = Attachments.Item(i).Filename ms.SetLength(0) Attachments.Item(i).SaveAs(ms) AddBinaryDataRowAtt ReadBinaryFile(ms), id, attFilename 'test 'GetBinaryD...
by sckramer2
2011-11-17 17:31
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

Bill48105 wrote:Quick loop is same as full loop.. If there are any messages that get indexed it loops back until there are none found to index..
Bill
ok

cool, re: the INI settings--
by sckramer2
2011-11-17 16:59
Forum: Scripting
Topic: Saving attachments to database [Archive Script]
Replies: 6
Views: 3199

Re: Saving attachments to database [Archive Script]

something like this (pretty sure this does not work):

Code: Select all

   for i = 0 to Attachments.Count - 1
   
     dim attFilename
     attFilename = Attachments.Item(i).Filename
          
     AddBinaryDataRowAtt ReadBinaryFile(  Attachments.Item(i).SaveAs() ), id, attFilename
    
   Next
by sckramer2
2011-11-17 16:47
Forum: Scripting
Topic: Saving attachments to database [Archive Script]
Replies: 6
Views: 3199

Saving attachments to database [Archive Script]

Hi, I'm building a pure Archive to Database script, it saves everything into db tables, even the .eml & attachments as binary cols This is a snippit of code from my full archive to DB I'm running / developing, this part saves each attachment as a row in the db (a binary column) Is there a trick to a...
by sckramer2
2011-11-17 05:55
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

I can't think of a good reason to run QUICK twice in a row, think its nessessary anymore?Maybe it should be taken out...
by sckramer2
2011-11-16 22:06
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

Well not so fast with checking >0.. I am pretty sure that requires a DB scan & if going to do that might as well do a FULL but we'll see if there is a low-cost way to see if there are remnants requiring an early full. low-cost is probably just use the count result from the normal 12-hour FULL, then...
by sckramer2
2011-11-16 21:51
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

No that logging was not added. ok In my testing the only way I've been able to get past the 1000 mark was to pound the server with >1000 per minute & even then once the next FULL triggers the missed ones get indexed then. 1/2 a day might be too long but then again how often do we expect 1k emails/m...
by sckramer2
2011-11-16 21:35
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

I was just talking about the DEBUG logging itself: "DEBUG" 660 "2011-11-16 14:29:45.633" "Doing QUICK index..." "DEBUG" 660 "2011-11-16 14:29:45.664" "Doing QUICK index..." "DEBUG" 660 "2011-11-16 14:29:45.679" "No messages to index." after the 1st "Doing QUICK index..." is it then supposed to say: ...
by sckramer2
2011-11-16 21:24
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

Hard to believe you had 1000 in 1 minute though. I've had a hard time doing that with testing let alone real world! lol
not sure where you got that ? -- maybe if I was hacked by a botnet :)
by sckramer2
2011-11-16 20:56
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

The way you'll know if you are having issues with the QUICK ones is that the counts on the performance indexing tab don't match this was exactly my plan, I'm curious what/why if any rows fall through the cracks... so I will keep you posted after a few 12 hour periods one little note re logging: "DE...
by sckramer2
2011-11-16 20:44
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29089

Re: Message Indexing query slow, can we optimize it?

I was talking about the original hmail indexing method, showing how bad it was (my mysql is tuned very well)... ...I meant the index query was hitting for 8 - 20 seconds every minute, but with the new code, of course that will only happen every 12 hours... so far with the new experimental, the "long...