Search found 191 matches

by andyp
2015-01-12 23:19
Forum: Development & alpha discussions
Topic: Possible error in SQL command
Replies: 4
Views: 3151

Possible error in SQL command

I am getting since version 5.5.2 several times a day following error message, which seems to come from a program error ... "ERROR" 5936 "2015-01-11 01:03:09.842" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x93\xA6 T...' for...
by andyp
2011-09-07 21:18
Forum: User contributed hMailServer 5 scripts
Topic: Limit outbound mails by user, domain or server average
Replies: 137
Views: 115526

Re: Limit outbound mails by user, domain or server average

I am not saying, I don't understand you or you are wrong. But my entire scripts which are about 5-6 the size of this script take in average 1 second for each event in hm. This includes the logging and not 1 second only for the logging. So this is absolutely fine with my bill. But I seriously doubt t...
by andyp
2011-09-06 19:10
Forum: User contributed hMailServer 5 scripts
Topic: Limit outbound mails by user, domain or server average
Replies: 137
Views: 115526

Re: Limit outbound mails by user, domain or server average

Well... if logging to a DB fits your bill, fine with me, I just wonder how much overhead such an approach may introduce, see, opening a DB connection and writing to a table requires more time than just appending lines to a text file or (better) leveraging the "Eventlog.Write" native function and gi...
by andyp
2011-09-05 19:03
Forum: User contributed hMailServer 5 scripts
Topic: Limit outbound mails by user, domain or server average
Replies: 137
Views: 115526

Re: Limit outbound mails by user, domain or server average

Which hm COM API object has that customlog method?
by andyp
2011-09-05 17:30
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

Possible is everything, but are you sure you what to do it? You might get mixed up, where the configuration is coming from.
by andyp
2011-09-05 17:28
Forum: User contributed hMailServer 5 scripts
Topic: Limit outbound mails by user, domain or server average
Replies: 137
Views: 115526

Re: Limit outbound mails by user, domain or server average

EventLog.Write would be the right solution, if you like to use the hm log
by andyp
2011-09-05 12:59
Forum: User contributed hMailServer 5 scripts
Topic: Limit outbound mails by user, domain or server average
Replies: 137
Views: 115526

Re: Limit outbound mails by user, domain or server average

@philg and ObiWan I agree to you both, but I have tried it with a lock file and cached the log and writing it at the end of the script, so the file is only opened once, but it didn't fly without 100% errors. So I am currently using a database with odbc, which is a lot better. If you have got an erro...
by andyp
2011-09-03 17:46
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

I will do a better documentation and provide a new version of the script in the next days. Sorry for not supporting some issues of the script, but I was a little busy in the last 2 years.
by andyp
2011-09-03 17:44
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

No, could you post the log?
by andyp
2011-09-03 17:39
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

I like some of the further development and integrated it into my script in the last days, I also switched to database backend as the data store, so we don't have the instability by simulaneously writing/reading in files. Test it and will post the new script in the next days.
by andyp
2011-09-03 00:07
Forum: Scripting
Topic: isAlias function
Replies: 3
Views: 2795

Re: isAlias function

This script fails if the domain itself has an alias, doesn't it?
by andyp
2011-09-02 23:35
Forum: User contributed hMailServer 5 scripts
Topic: Limit outbound mails by user, domain or server average
Replies: 137
Views: 115526

Re: Limit outbound mails by user, domain or server average

Hi Masp, One thing I have learnt about hMailServer scripting in VB, is that its all too easy to get these sorts of problems. I modified the logging functions to retry and to use a lock file to try and avoid clashes like this. I'm guessing that the server itself is calling multiple scripts in differ...
by andyp
2011-09-02 23:07
Forum: User contributed hMailServer 5 scripts
Topic: Limit outbound mails by user, domain or server average
Replies: 137
Views: 115526

Re: Limit outbound mails by user, domain or server average

DjGL wrote:Hi andyp

Great script but where does the script get the "emailadmin" from?

And i guess you forgot something here :wink:

Code: Select all

		If msg_admin_warning then
		End If
Thanks I have already corrected the script and will provide it with database support and some other features in the next days
by andyp
2010-05-16 11:01
Forum: General discussions
Topic: View active topics
Replies: 2
Views: 1679

View active topics

Is there a reason, why I don't any topics listed in here?
by andyp
2009-12-21 23:26
Forum: Scripting
Topic: copy or move email
Replies: 47
Views: 17676

Re: copy or move email

Use OnDeliveryStart or OnDeliverMessage Eventhandler depending on your needs. Write a function copy_mail containing if criteria in which the mail has to be copied if ... then omessage.Copy(long iDestinationFolderID) end if if ... then omessage.Copy(long iDestinationFolderID) end if ... Your need to ...
by andyp
2009-12-21 15:13
Forum: User contributed hMailServer 5 scripts
Topic: Limit outbound mails by user, domain or server average
Replies: 137
Views: 115526

Re: Limit outbound mails by user, domain or server average

What do you mean by
ozhim wrote:I just want to control users
Could you tell me what line in the code you have changed!
by andyp
2009-12-16 23:53
Forum: General discussions
Topic: Still problems with more than 2.000.000.000 mails?
Replies: 15
Views: 4710

Re: Still problems with more than 2.000.000.000 mails?

Stephan, I don't what you like to do, but the LRZ which is responsible for all public organizations and all universities / schools in and around Munich has about 100.000 Mail Accounts. Let's say everyone gets 50 Mails per day we have 5 mio per day, close to you. I know they have a hell of hardware r...
by andyp
2009-11-15 17:57
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

In version2 you can send all command mails to the admin, I am currently on version3 and will provide a setting to do this. This should be very simple.
by andyp
2009-11-10 20:41
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

That is right and what is the questions? You need to active the email subscription of course.
by andyp
2009-11-06 19:30
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

I think it should be an ups from my side, replace

Code: Select all

prepare_mailconfiguration oClient, oMessage
by

Code: Select all

add_client_info oClient, oMessage
by andyp
2009-11-06 19:23
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

I am not saying your argumentation is wrong or not logical. I also told you, your proposal should not be required for people running hmailserver on a usual webserver with one or several IPs. But I simply don't have the need for this feature and am not going to change the script. So the third time: F...
by andyp
2009-11-05 22:36
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

No, that means that authenticated user and senders from the ip configured by variable ipslocalhost populate the list. As I already said: Feel free to change the script.
by andyp
2009-11-05 22:33
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

Are you sure it looks like : Sub OnAcceptMessage(oClient, oMessage) write_log ("------------------------- OnAcceptMessage Event -----") Set obApp = CreateObject("hMailServer.Application") Call obApp.Authenticate(user, pw) prepare_mailconfiguration oClient, oMessage End Sub Sub OnDeliveryStart(oMessa...
by andyp
2009-11-01 15:20
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

I understood your request well, but I would assume most people have a server in the web and are not using authentication for local net. So am I, except my backupserver.
by andyp
2009-11-01 05:45
Forum: Feature requests
Topic: Rules improvement in functionality and user interface
Replies: 6
Views: 6239

Re: Rules improvement in functionality and user interface

I you want to duplicate the rules, you can copy the rules in the appriopiate table in the db. Just a hint.
by andyp
2009-11-01 05:28
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

the ip of the localhost is just used for the determination whether the client has authenticated. Usually you can send without auth from the localhost, so you probably what to whitelist these addresses as well. I don't think that a mailserver has that many ips. But feel free to customize this part of...
by andyp
2009-10-31 13:09
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

new provided version
by andyp
2009-10-31 13:09
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

new provided version
by andyp
2009-10-19 13:16
Forum: General discussions
Topic: Merging 2 hmailserver installs
Replies: 18
Views: 4584

Re: Merging 2 hmailserver installs

There is one other possibility. You need to choose one server as the master and import all relevant domain data of the secondary server into the master. Before you do that you need to ensure the primary keys of the database are unique. Check the relevant tables and add to the secondary db prim key t...
by andyp
2009-10-15 21:19
Forum: General discussions
Topic: Network problems with hMailserver
Replies: 3
Views: 2089

Re: Network problems with hMailserver

Updating the driver is not that simple, as i have only remote access. But this is the next thing to to with the server provider. The server is in productive use, so I think twice before changing anything. The virtual machine was mainly for testing the network connection of the server, but this is ob...
by andyp
2009-10-15 19:25
Forum: General discussions
Topic: Network problems with hMailserver
Replies: 3
Views: 2089

Network problems with hMailserver

Hello, I once wrote the post http://www.hmailserver.com/forum/viewtopic.php?f=6&t=15578, because I had severe IMAP connection problems with hm. Maybe they encounter with SMTP as well, but not that annoying than IMAP. Sometimes the Clients where absolutely unable to connect with outlook 2003 neither ...
by andyp
2009-10-15 12:43
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

Currently, I am adding some features for myself. Is anyone missing something in this script? (Which can be realized easily?)
by andyp
2009-10-12 17:48
Forum: Feature requests
Topic: Automatic whitelisting of local to external recpients
Replies: 20
Views: 14379

Re: Automatic whitelisting of local to external recpients

The script is only useful for small installations, because I have used a file as a store.

I would like this script directly in hmailserver as well.
by andyp
2009-10-10 08:42
Forum: Scripting
Topic: Search accounts
Replies: 2
Views: 2216

Re: Search accounts

I think you have to go to domain one by one and check, whether the domain name exists. Same with account. I wrote one following script to check, whether a domain is local and whether the list is local. Function is_local_domain(domain_or_email) is_local_domain = False Dim domain Dim doms Dim alss Dim...
by andyp
2009-10-09 19:36
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

Yes, the ips of all server of the mx entry will be generally whitelisted.
by andyp
2009-09-13 22:33
Forum: Archived feature requests
Topic: a real listserver
Replies: 19
Views: 28255

Re: a real listserver

You can do this by the script posted. Just add the addresses which should receive mail to the list and add the addresses which should send email to the list to the allowaddresses= parameter. Set allowmembers=true and operator=and and pw=something_strange. Done.
by andyp
2009-09-13 22:23
Forum: Development & alpha discussions
Topic: Error in B362
Replies: 1
Views: 2113

Error in B362

I get following error using message indexing having 18367 messages. Der Wert 18369 ist für Value ungültig. Value sollte zwischen 'minimum' und 'maximum' liegen. Parametername: Value ExceptionType: ArgumentOutOfRangeException HelpLine: Message: Der Wert 18369 ist für Value ungültig. Value sollte zwis...
by andyp
2009-09-11 20:20
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

is there a way to prevent the sender on the list defined in hmailserver directly to get a copy of the mail which was send to the list? No, this cannot be influenced by API. to write the emailadress of the "config file" a little bit strange You need to guarentee there is only one config file per lis...
by andyp
2009-09-05 02:54
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

I have added the new feature.

Now all IPs of the mailservers used by registered email addresses are whitelisted as well. The old emailaddressfile will be converted.
by andyp
2009-09-05 02:52
Forum: General discussions
Topic: hMailServer in kleinem Netzwerk
Replies: 3
Views: 3291

Re: hMailServer in kleinem Netzwerk

Das ist kein Problem mit hmailserver. Wenn Du keine feste IP hast, dann musst/solltest allerdings einen SMTP Relay Server in den SMTP Einstellungen angeben. Vielleicht ist das auch das Problem mit dem verschicken. Ohne Fehlermeldungen kann ich Dir bei dem anderen nicht weiterhelfen. Liefern die Clie...
by andyp
2009-09-05 02:44
Forum: General discussions
Topic: Editing post with replies
Replies: 3
Views: 1417

Editing post with replies

Hi Martin,

I cannot edit post, which have already replies. Is that intentionally?

So I cannot upload the script on the top of the topic any more.

Cheers
Andy
by andyp
2009-08-11 22:36
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

DFitch wrote:Is this possible?
Yes, it is possible.
izero wrote:It is simple
Yes, too.
But not done in a few minutes. I like it and I will take some time in the next weeks to do it.
by andyp
2009-07-18 13:23
Forum: General discussions
Topic: Migration problems to a new server
Replies: 7
Views: 4045

Re: Migration problems to a new server

Now I have moved the mysql db on the old 32 bit server and there was really an improvement. After two days I decided to switch to an 32 bit mysql db on the new server and hoped there would be an improvement to, but now I am back to the same errors. I think not in the same frequency, but they are the...
by andyp
2009-07-09 17:16
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

I already thought of using a database or something like you provided. Just hadn't the time to implement it.
by andyp
2009-07-08 18:54
Forum: General discussions
Topic: Migration problems to a new server
Replies: 7
Views: 4045

Re: Migration problems to a new server

Now I have confirmed, that it isn't the MySQL Server. Found following error message in the log: "DEBUG" 1200 "2009-07-08 00:14:17.061" "The read operation failed. Bytes transferred: 0 Remote IP: a.b.c.d, Code: 10054, Message: Eine vorhandene Verbindung wurde vom Remotehost geschlossen" "DEBUG" 3480 ...
by andyp
2009-07-03 19:11
Forum: General discussions
Topic: Migration problems to a new server
Replies: 7
Views: 4045

Re: Migration problems to a new server

Well, I have not found it yet. Rouncube throws many errors in the err log.

I assume it is mysql and will try to get the log running. There is a log flush command, but it doesn't work. Will google...
by andyp
2009-07-03 19:00
Forum: General discussions
Topic: Migration problems to a new server
Replies: 7
Views: 4045

Re: Migration problems to a new server

Tried to, but I haven't found it. Should be in the data dir, shouldn't it? Do I have to activate something?

I have installed roundcube again, and it seems to work better, till now.
by andyp
2009-07-03 18:10
Forum: General discussions
Topic: Migration problems to a new server
Replies: 7
Views: 4045

Migration problems to a new server

As I have become new hardware, I have migrated hmailserver installation as well. Old installtion: Win 2003, Mysql 32 bit, hmailserver b341 New Installation: Win 2008 Web Edition, newest MySQL 64 bit, hmailserver b341 I had no problems with the migration itself, but afterwards I am encountering insta...
by andyp
2009-06-25 15:05
Forum: General discussions
Topic: hmailserver und MySQL 5 x64
Replies: 3
Views: 1867

Re: hmailserver und MySQL 5 x64

Sorry missed the other post. Now it works. Downloaded the binarys from mysql website...
by andyp
2009-06-24 15:16
Forum: General discussions
Topic: hmailserver und MySQL 5 x64
Replies: 3
Views: 1867

hmailserver und MySQL 5 x64

In case I use this combination, I need to copy the 32-bit libmysql.dll in hm bin dir. Does 32-bit libmysql.dll work with 64-bit mysql db?
by andyp
2009-06-06 19:37
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Re: Distribution list enhancement

hMailServer has distribution lists - not mailing lists.
Yes, I know. Two years ago, I had a hard time to find any free mailserver with some list feature. Hmailserver is one of or still the best mailserver, but I simply required that feature, so I wrote the script.
by andyp
2009-06-06 10:17
Forum: User contributed hMailServer 5 scripts
Topic: Distribution list enhancement
Replies: 120
Views: 100911

Distribution list enhancement

hMailServer is one of the few mailservers for windows supporting distribution list. But compared to linux (majordomo or mailman) the features of the distribution list are very thin. As I have extensive use of the lists, I have written a script to extend the list features. This script comes close to ...
by andyp
2009-06-05 10:17
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

Yeah, these and some other stuff was missing, posted the updated file in the first post. Sorry.
by andyp
2009-06-03 10:22
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

We had the problem that I continously improve the code without post every change. I had the script already changed so you could recognized the code. Posted an update above. No adding of local domains in version6 any more.
by andyp
2009-06-02 10:26
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

Insert the markes lines. Check the log to see what the script is doing ... source = get_smtp_recipient(oMessage, oClient.IPAddress) sourcearr = Split(source,"#") For k = 0 To UBound(sourcearr) If Not is_local_domain(sourcearr(k)) Then toarr = toarr & sourcearr(k) & "#" 'From the line afterwards writ...
by andyp
2009-05-26 19:35
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

djamell wrote:1. Is the script supposed to add local domains to the emailaddresses.txt file?
No, it should not in newer versions
djamell wrote:2. Is there some delay that's causing mail-enabled devices and Web Server Contact Forms to stumble?
I think version1 and 2 is doing this.

So make an update to version5
by andyp
2009-05-24 12:55
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

Each address in one line without any other characters.

Addresses in this file will be permanently updated in the whitelist.
by andyp
2009-05-15 13:14
Forum: General discussions
Topic: Hmailserver on 64 bit windows
Replies: 18
Views: 13875

Re: Hmailserver on 64 bit windows

Running on win 2003 x64 and mysql x64 fine since 3 years
by andyp
2009-05-12 20:30
Forum: User contributed hMailServer 5 scripts
Topic: Automatic whitelisting
Replies: 172
Views: 133589

Re: Automatic whitelisting

This should work. But this Suppose domain.tld is hosted on mx01 and mx02 is a backup mx for domain.tld. If mx02 receives a spam addressed TO AND FROM user@domain.tld it doesn't do AntiSpam checks for it because the FROM address is in the white list on mx02. The spam is delivered and doesn't get chec...
by andyp
2009-05-05 10:58
Forum: User contributed hMailServer 5 scripts
Topic: Limit outbound mails by user, domain or server average
Replies: 137
Views: 115526

Re: Limit outbound mails by user, domain or server average

Replace If oMessage.FromAddress = emailadmin Then excptn = true Else For k = 0 To oMessage.recipients.count - 1 If oMessage.recipients(k).OriginalAddress = emailadmin Then excptn = True End If Next End If with If oMessage.FromAddress = emailadmin Then excptn = true If InStr(1," " & oMessage.to,email...