Search found 47 matches

by gsmaclean
2014-02-14 04:42
Forum: General discussions
Topic: Data Directory Synchronizer - SLOW!!
Replies: 17
Views: 5532

Re: Data Directory Synchronizer - SLOW!!

The indexing is stalling pretty reliably once or twice a day. I have to cycle the hMailServer service to get it to start again. I've found that it logs this in the error log when it does stall: "ERROR" 5016 "2014-02-10 13:30:39.207" "Severity: 3 (Medium), Code: HM5158, Source: MessageIndexer::DoWork...
by gsmaclean
2014-01-29 17:04
Forum: General discussions
Topic: Data Directory Synchronizer - SLOW!!
Replies: 17
Views: 5532

Re: Data Directory Synchronizer - SLOW!!

My message indexing stalled again several days ago, and after it was about 3,000 messages behind, I had a look to see what was going on. Stopping and restarting the hMailServer process did not restart the indexing as it normally does. I ran this query: select * from hm_messages where messageid not i...
by gsmaclean
2014-01-24 04:52
Forum: General discussions
Topic: Data Directory Synchronizer - SLOW!!
Replies: 17
Views: 5532

Re: Data Directory Synchronizer - SLOW!!

The values I'm running are: IndexerFullMinutes=720 IndexerFullLimit=50000 IndexerQuickLimit=15000 I've just bumped my IndexerFullMinutes value up from 720 to 30. It's very possible that I had more than 15,000 come in during a 12 hour period at some point, so I'm guessing that was the problem. I'm g...
by gsmaclean
2014-01-23 21:38
Forum: General discussions
Topic: Data Directory Synchronizer - SLOW!!
Replies: 17
Views: 5532

Re: Data Directory Synchronizer - SLOW!!

After the DDS run and clearing of the message index, it took some time but finally indexed the entire database. Once it got there, it kept the index up-to-date more or less in real time (or close to it) However, a week later, it has stopped indexing again. Well, not stopped - however it is showing ...
by gsmaclean
2014-01-23 20:43
Forum: General discussions
Topic: Data Directory Synchronizer - SLOW!!
Replies: 17
Views: 5532

Re: Data Directory Synchronizer - SLOW!!

After the DDS run and clearing of the message index, it took some time but finally indexed the entire database. Once it got there, it kept the index up-to-date more or less in real time (or close to it) However, a week later, it has stopped indexing again. Well, not stopped - however it is showing 1...
by gsmaclean
2014-01-16 17:47
Forum: General discussions
Topic: Data Directory Synchronizer - SLOW!!
Replies: 17
Views: 5532

Re: Data Directory Synchronizer - SLOW!!

Ahh ok. I've seen the stalling since adding the quickindex option. I've only seen it when 1st turning on indexing or after disabling & enabling again. Just haven't had time to look into it. The good news is it doesn't hurt anything because if a message is not indexed hmail will look it up & index i...
by gsmaclean
2014-01-16 14:41
Forum: General discussions
Topic: Data Directory Synchronizer - SLOW!!
Replies: 17
Views: 5532

Re: Data Directory Synchronizer - SLOW!!

The data dir sync tool is known to be far from efficient in many cases but it's made to suit a purpose & that's to be a utility. It needs to look at the database & compare with the data dir & either import or delete depending on which was chosen. In addition as of 5.4 it also attempts to fix the pa...
by gsmaclean
2014-01-16 06:00
Forum: General discussions
Topic: Data Directory Synchronizer - SLOW!!
Replies: 17
Views: 5532

Re: Data Directory Synchronizer - SLOW!!

Just as I thought - the reason for the huge delay was due to the rewriting of the filename of every message. UPDATES take far more time than SELECTS. I ran the UPDATE hm_messages query I wrote in the previous message, which deleted the the drive and pathname from the messagefilename column in the hm...
by gsmaclean
2014-01-16 05:16
Forum: General discussions
Topic: Data Directory Synchronizer - SLOW!!
Replies: 17
Views: 5532

Data Directory Synchronizer - SLOW!!

I'm attempting to run the Data Directory Synchronizer on my hMailServer installation. This server is a very fast box, with lots of CPU. It is running against a hefty MSSQL Server Enterprise, with six cores and 16GB RAM. There are approximately one million messages in the database. The hm_messages ta...
by gsmaclean
2011-02-14 22:28
Forum: User contributed hMailServer 4 scripts
Topic: Automated List Server for hMailServer
Replies: 24
Views: 26420

Re: Automated List Server for hMailServer

perast wrote:This script, will it works with hMailServer 5.3.3 - Build 1879 with MySql.
I am using it on 5.3.3 B1879 under MSSQL with no problems.
by gsmaclean
2010-11-23 18:12
Forum: General discussions
Topic: HM5136 and HM4208 on IMAP folder access
Replies: 0
Views: 2062

HM5136 and HM4208 on IMAP folder access

I just experienced a problem on my server (5.3.3 build 1879) that I've never seen before. It was occurring for just one user (that I know about). He could log in (IMAP), but it would fail with an odd error. hMailServer's logs showed (IP addresses redacted): "ERROR" 3932 "2010-11-23 10:58:36.433" "Se...
by gsmaclean
2010-08-25 21:42
Forum: General discussions
Topic: Server lockups
Replies: 15
Views: 4618

Re: Server lockups

Just a quick update...six weeks without a lockup, I think we have nailed the problem. Thanks to everyone!
by gsmaclean
2010-07-21 20:05
Forum: General discussions
Topic: Server lockups
Replies: 15
Views: 4618

Re: Server lockups

I thought I would post an update: I mentioned replacing generic Windows drivers with manufacturer-specific drivers, and started by installing a current version of the OEM network driver. That was 15 days ago, and we have not had a lockup since - whereas before then, the lockups seemed to be occurrin...
by gsmaclean
2010-07-13 13:42
Forum: General discussions
Topic: Server lockups
Replies: 15
Views: 4618

Re: Server lockups

There is nothing in any of the event logs immediately prior to the lockups.

I've tried replacing the network driver most recently, and it's been several days since a lockup, so we'll see...
by gsmaclean
2010-07-06 21:24
Forum: General discussions
Topic: Server lockups
Replies: 15
Views: 4618

Re: Server lockups

Wow that'd be frustrating as hell & I feel your pain. I'll make suggestions but wonder if you being at your wits end would allow you to actually take them into consideration or write them off as 'already tried'.. If you really want to solve it you need to keep an open mind. I've solved issues like ...
by gsmaclean
2010-07-06 20:02
Forum: General discussions
Topic: Server lockups
Replies: 15
Views: 4618

Re: Server lockups

Yup, I've tried updated drivers, generic drivers, anything that could touch kernel level stuff. I have seen a few references to this type of problem on the net with people using SQL server - where it just locks up, nothing logged, no errors. I suppose it's possible that MS might be burying some low-...
by gsmaclean
2010-07-06 19:47
Forum: General discussions
Topic: Server lockups
Replies: 15
Views: 4618

Re: Server lockups

So you rebooted the server when the problem appeared. Have you tried just restarting either ASSP or hMailServer to get a hint on where the trouble is? Not a 100% safe way to do it but at least a place to start..? No, you don't understand...the entire SERVER is frozen. It locks up solid - no keyboar...
by gsmaclean
2010-07-06 18:30
Forum: General discussions
Topic: Server lockups
Replies: 15
Views: 4618

Server lockups

This is a battle I have been fighting for almost a year now. This is a Windows 2003 Standard SP2 server with all current updates, running on an Intel DG35EC with a Core2Duo E8400 @ 3.00 GHz, with 4 GB of RAM and a Realtek RTL8169 gigabit NIC. There's nothing special about the hardware, it has three ...
by gsmaclean
2010-07-06 17:50
Forum: General discussions
Topic: Consistent SQL errors
Replies: 1
Views: 844

Consistent SQL errors

I have a domain on my server that contains a large number of accounts. Each of these accounts has a large accountmaxsize setting (50 megabytes). I'm seeing this error regularly in my error logs: "ERROR" 1564 "2010-07-05 10:57:30.669" "Severity: 2 (High), Code: HM5033, Source: DALRecordset::Open, Des...
by gsmaclean
2009-01-31 00:10
Forum: Development & alpha discussions
Topic: Using existing MSSQL in place of MSSQL CE
Replies: 4
Views: 3206

Using existing MSSQL in place of MSSQL CE

I currently run v4 with the internal MySQL database. I already have an MSSQL 2005 server available. Is it possible when upgrading my v4 hMailServer to point it to my existing MSSQL 2005 server and have it upgrade to that server, instead of creating and using the MSSQL CE embedded server?
by gsmaclean
2008-12-22 23:07
Forum: General discussions
Topic: Wrong SPAM detection, hmailserver or ASSP?
Replies: 1
Views: 1255

Re: Wrong SPAM detection, hmailserver or ASSP?

It's ASSP. You need to post your question in ASSP's user forum.
by gsmaclean
2008-10-03 22:37
Forum: User contributed hMailServer 4 scripts
Topic: Automated List Server for hMailServer
Replies: 24
Views: 26420

Re: Automated List Server for hMailServer

Correct, that FS2 should be FO2. Corrected version attached.
by gsmaclean
2008-07-25 22:14
Forum: User contributed hMailServer 4 scripts
Topic: My script to delete spam email after x days old, with report
Replies: 75
Views: 65193

Re: My script to delete spam email after x days old, with report

Ok, I was wrong. The problem only happens when you go from the first item to the last, which is what happened on my modified script. Going from the last to the first (step -1) as you delete a file, the number moves with it, so my apologies. Right, that is why you see the Step - 1 on this line of my...
by gsmaclean
2008-07-11 21:40
Forum: User contributed hMailServer 4 scripts
Topic: My script to delete spam email after x days old, with report
Replies: 75
Views: 65193

Re: My script to delete spam email after x days old, with report

I've added to the script above to do something very similar to what you asked. In the script you'll see one additional line at the top: SendSpamReport = True ' If true, each user gets an email listing all emails in their spam folder, if false, no email is sent If this is set to False, the script ope...
by gsmaclean
2008-05-31 15:36
Forum: User contributed hMailServer 4 scripts
Topic: DataDirectorySynchronizer for individual account
Replies: 3
Views: 7729

Re: DataDirectorySynchronizer for individual account

tayyem wrote:Hi

I have tried to download the attachment but forbidden message appears, please check the links and permissions.

Thanks
Works for me as well, perhaps you have a virus checker or something blocking it?
by gsmaclean
2008-05-30 21:46
Forum: User contributed hMailServer 4 scripts
Topic: My script to delete spam email after x days old, with report
Replies: 75
Views: 65193

My script to delete spam email after x days old, with report

I mentioned this script that I had written the other day, and someone asked me for it. Here is what it does: Scans every user in every domain Looks for an IMAP folder named "Spam" for each user. If one doesn't already exist, it creates one Scans through each "Spam" IMAP folder. Any messages in that ...
by gsmaclean
2008-05-28 22:50
Forum: Scripting
Topic: reviewing of spam email
Replies: 6
Views: 4515

Re: reviewing of spam email

I have my spam filter (ASSP) add a header to any email that it deems to be spam. I then set up a global filter that sends those messages to an IMAP folder named "Spam". Lastly, I wrote a VBScript that is called once a day (at midnight) that goes through every "Spam" IMAP folder on the server and del...
by gsmaclean
2008-05-28 22:41
Forum: General discussions
Topic: Case Insensitive Regular Expression
Replies: 2
Views: 1575

Re: Case Insensitive Regular Expression

Good question. The pattern flag (i.e. the "i" for case insensitive) is not normally part of the regex string. In Javascript, it would be:

/widget/i

Without experimentation, the only way I could see if easily doing it here is by using this as your regex code:

[wW][iI][dD][gG][eE][tT]
by gsmaclean
2008-05-28 22:07
Forum: General discussions
Topic: ASSP vs. SA, which do you like?
Replies: 5
Views: 2490

Re: ASSP vs. SA, which do you like?

I've used both, and agree partly with Shiloh. While I prefer (and use) ASSP, and feel that it filters better and is more configurable, it is very complex to configure and learn. The main failing of ASSP is that it is single threaded, and it is very easy to cripple a server with any kind of decent lo...
by gsmaclean
2008-05-07 20:43
Forum: General discussions
Topic: Multiple Domain Hosting
Replies: 2
Views: 1668

Re: Multiple Domain Hosting

You could always bind all the appropriate IP's to the network card in your mail server, and have hMailServer listen to all of them. The mail server would still think it was running virtual servers, users would still have to use their domains in their logins, but it would work.
by gsmaclean
2008-05-07 20:40
Forum: General discussions
Topic: I have to send 500.000 emails from a big Publisher
Replies: 10
Views: 3874

Re: I have to send 500.000 emails from a big Publisher

One of your biggest problems is having your mailing being identified as spam by the recipient mail servers. (I'm assuming it's NOT spam, right? :) ) Sending a large number of identical emails to different recipients on the same mail server in a single mail transaction WILL get you flagged as spam, a...
by gsmaclean
2008-05-06 16:04
Forum: General discussions
Topic: PLease help me reduce the spam - I'm not getting very far
Replies: 29
Views: 8144

Re: PLease help me reduce the spam - I'm not getting very far

I have to agree with the poster that suggested ASSP - I've been using it for a couple of years now, and it is by far the most effective spam killer I have ever used (and I've been doing this for over ten years now). The fact that it is free makes it all the much better. It is definitely not the kind...
by gsmaclean
2008-05-05 21:54
Forum: User contributed hMailServer 4 scripts
Topic: Automated List Server for hMailServer
Replies: 24
Views: 26420

Automated List Server for hMailServer

One of the things I was missing with hMailServer that I had with IMail was the ability for users to join and leave mailing lists on their own, through an email interface. I decided to write one myself to return this functionality to my users. This is not a simple script (it is almost 20K) and it giv...
by gsmaclean
2008-05-02 22:32
Forum: General discussions
Topic: Runing Data Directory Synchronizer crashes hmailserver
Replies: 2
Views: 1766

Re: Runing Data Directory Synchronizer crashes hmailserver

If you're trying to fix one user, try running the synchronizer I wrote - it's in the user submitted scripts area. I suppose you could run it from the command line in a batch file, telling it to do one user at a time for the entire server as well, if you wanted to.
by gsmaclean
2008-05-02 15:10
Forum: General discussions
Topic: Just stopped working
Replies: 5
Views: 1827

Re: Just stopped working

Are you still getting error messages? What does your log file say?
by gsmaclean
2008-05-02 13:14
Forum: General discussions
Topic: Just stopped working
Replies: 5
Views: 1827

Re: Just stopped working

AVG has bound to port 25, so hMailServer cannot. Disable all mail handling options and plugins within AVG, and restart your server. You should not be running client email scanners like AVG on a mail server.
by gsmaclean
2008-05-01 20:22
Forum: Scripting
Topic: How to assign value to global variable
Replies: 6
Views: 2843

Re: How to assign value to global variable

Actually, no. Here's what I would do to solve your problem: Sub OnAcceptMessage(oClient, oMessage) oMessage.Subject = oMessage.Subject & vbTab & oClient.IPAddress End Sub Sub OnDeliverMessage(oMessage) Dim IPAddress Dim SPos SPos = Instr(oMessage.Subject, vbTab) If SPos Then IPAddress = Mid(oMessage...
by gsmaclean
2008-05-01 20:12
Forum: Scripting
Topic: How to assign value to global variable
Replies: 6
Views: 2843

Re: How to assign value to global variable

... the global value would get overwritten by every email coming in, so you couldn't necessarily depend on the value you were utilizing in OnDeliverMessage. I think that this bit still applies. Correct. Here's what is wrong with your file version: 1. Remote server A connects. 2. You write IP addres...
by gsmaclean
2008-04-29 21:28
Forum: Scripting
Topic: How to assign value to global variable
Replies: 6
Views: 2843

Re: How to assign value to global variable

Public IPAddress Sub OnAcceptMessage(oClient, oMessage) IPAddress = oClient.IPAddress End Sub Sub OnDeliverMessage(oMessage) Set Conn = CreateObject("ADODB.Connection") Conn.Open ("..............") SQL = "INSERT INTO EMails (MessageID,Name,Email,Subject,IPAddress) Values (" & oMessage.ID+1 & ",'" &...
by gsmaclean
2008-04-28 23:19
Forum: User contributed hMailServer 4 scripts
Topic: Forwarding plugin for SquirrelMail
Replies: 0
Views: 6135

Forwarding plugin for SquirrelMail

This is a quick and dirty plugin I wrote for SquirrelMail that allows the end user to control the hMailServer forwarding option for their account from within SquirrelMail. My apologies for my PHP, it's definitely not my language of choice. :)
by gsmaclean
2008-04-28 21:44
Forum: Scripting
Topic: Forwarding email from API
Replies: 0
Views: 1450

Forwarding email from API

I was looking at how to automate the "Forward Mail" account setting, and did not find it in the API documentation. I went and browsed the hMailServer object, and found it...it's there, the API documentation just isn't updated yet. There are three properties in the Account object: ForwardAddress (str...
by gsmaclean
2008-04-21 18:36
Forum: Scripting
Topic: Scripting Reference
Replies: 4
Views: 3390

Re: Scripting Reference

You might want to note that some of the API documentation is out of date (or incorrect). I ended up loading an object browser to browse the hMailServer object and find out some of the IMAP/Subfolder functionality, because it was wrong in the API docs. There may be other areas.
by gsmaclean
2008-04-21 00:33
Forum: User contributed hMailServer 4 scripts
Topic: DataDirectorySynchronizer for individual account
Replies: 3
Views: 7729

DataDirectorySynchronizer for individual account

Needing to run DataDirectorySynchronizer on an individual account (not on every account on the system), I wrote the attached script to do so. Martin started off with a small script to do adds only, and I added to it to give it add/delete functionality and error checking. The code is not the cleanest...
by gsmaclean
2008-04-21 00:29
Forum: General discussions
Topic: Can't restore individual user?
Replies: 5
Views: 1957

Re: Can't restore individual user?

It still sounds strange that it would take that long time. In version 5, I've rewritten DDS from scratch so it runs several times faster. It's still not possible to synchronize just one account in that version though. Sounds like a good feature to add. I took your script and expanded on it. I gave ...
by gsmaclean
2008-04-20 16:29
Forum: General discussions
Topic: Can't restore individual user?
Replies: 5
Views: 1957

Re: Can't restore individual user?

About 1,000 accounts, but the problem is that the majority of those accounts use the mail server as an IMAP data store, so most of them have hundreds, even thousands of messages stored on the server. Failing a solution today, I'm going to have to write my own DDS that utilizes the COM object and wor...
by gsmaclean
2008-04-20 01:40
Forum: General discussions
Topic: Can't restore individual user?
Replies: 5
Views: 1957

Can't restore individual user?

I have a user that was accidentally deleted today (not by me!). Restoring the user's account is easy enough, I can just put it back into the domain. Restoring the user's directory containing all the messages is also easy. However, what is not easy is getting the user's message information back into ...
by gsmaclean
2008-04-16 18:45
Forum: User contributed hMailServer 4 scripts
Topic: Add Reply-To header for Distribution List
Replies: 5
Views: 15162

Re: Add Reply-To header for Distribution List

Instr has a case-insensitive compare. You can write it as such: If InStr(1, oMessage.To, "distrlist@domain.com", vbTextCompare) Then HOWEVER - as I discovered today, this can have unintended consequences if not watched carefully. If you have a user "jsmith@domain.com", and a list "smith@domain.com",...