hMailServer forum

plumsauce

IndianNic, You may face a problem that is unique to your situation with RBL checks. Some of the RBL maintainers are very enthusiastic about blacklisting huge blocks of ip addresses issued by APNIC through guilt by association. If you are using such a list, all of your local users trying to send emai...

plumsauce

I see I was typing too fast. I did mean CREATE DATABASE <database name> The problem is that once the hardcoded CREATE DATABASE statement is executed it has already forced the database creation in a default location with default parameters copied from the model db. It is not possible to use any of th...

plumsauce

I don't see how such a thing that could change Neither do I, but I thought I would report it. The only thing I can think of, at least for the rules is that I created the account specific rules using the same rule names under multiple accounts. So, if the code differentiates rules by name instead of...

plumsauce

Would you rather not know then? Almost all emails will have a subject header because it is handled by the email client. Even if it is blank, the email client will insert the header. The behaviour observed while manually conversing with the server is what led me to discover the behaviour. This let me...

plumsauce

Sorry to be unclear. No, there is no operational problem at this time because I rolled back to a backup of the database as it was created by the hmail install. The database created by the script run manually did not work for the reasons outlined previously. The difference may lie in the fact that I ...

plumsauce

The problem may be at the other end.

For example, they may have suddenly introduced greylisting, or the account mght be dead.

To find out, you will need to look at the logs for the status responses from the other server.

plumsauce

In using telnet for manual testing of relay restrictions, I have discovered that hmailserver is treating a rule that says: "If predefined header subject is equal to blank string then delete" as being the same as: "If predefined header subject does not exist then delete" In my way of thinking these a...

plumsauce

No, the database user DBO is mapped to the LOGIN hmail. On every other database I have ever run the DBO is always SA. A user account is created for the service. For example DBO would be SA and an account HMAIL would be created and mapped to the login HMAIL. My point is that SA should never be forced...

plumsauce

Have you done some kind of export / import of the hMailServer database? No. The accounts were created in the manager gui. someone@a.com in the a.com domain another@b.com in the b.com domain . . . for a total of eight domains. Then I left hmailserver alone for a few weeks. Opened the gui, and the ac...

plumsauce

Is this hmailserver.exe by itself as shown in task manager?

It could be said that this is not a lot, but then again, if hmailserver were installed to be used as part of a web site, that is memory taken away from iis and sql.

plumsauce

The following stored procedure for MSSQL will copy an account rule from one account to another. You need to know the rule id. It is then invoked as: exec copyrule 'someone@example.com', rule-id-number drop procedure copyrule go create procedure copyrule @who varchar(100), @rul int as declare @cpy in...

plumsauce

memory issues.

how much memory are you consuming in the hmailserver process?

not that it solves your problem, but it would be a datapoint for the rest of us.

plumsauce

It then leaves the rest of the work to MSSQL. I think my original question could be rephrased as: "does the install process actually use that exact script?" Then it wasn't created properly, or the permissions wasn't created properly. That's the point. Hmailserver seems to want to run in the sql rol...

plumsauce

I installed hmailserver a few weeks ago. The hmailserver installation was inactive for two weeks, but running. I opened hmailadmin tonight to check before changing mx records to put the server live. The user accounts were in the wrong domain. Checking the tables showed the wrong hm_domains id in eac...

plumsauce

You might need to tune the underlying resources. The first culprit is NPP, non-paged pool. The limit is 256MB. NPP is used by things like sockets, handles, etc. This is set in a registry entry. The second is the behaviour of winsock. In particular the timing of disconnects. If you are handling this ...

plumsauce

Is the sql script "CreateTableMSSQL.sql" found in the dbscripts directory after installation the actual script used during installation? Or, is db creation during install actually hardcoded somewhere? I am trying to use a custom MSSQL database setup by running that script without success. I notice t...

plumsauce

Ok, in the change log I found this: API: It's now possible to check the current number of delivery attempts by accessing the DeliveryAttempt property on the hMailServer.Message object. So, on the very first send is hMailServer.Message.DeliveryAttempt zero or one? And is it incremented by one for eve...

plumsauce

There are usually two problems running a server from a broadband connection. 1. port 25 is often closed to the world at the edge of the isp network to prevent spammers from running servers using the ip address space of the isp. To check this you must be able to telnet to that address on port 25 from...

plumsauce

Great! That is good enough for the intended use. I am guessing that the property is msg.deliveryattempts, but I will confirm it in the docs later. Bounce messages are not needed for failed deliveries where no connection can be made to a server that is offline. The application handles resends based u...

plumsauce

Would a retry perhaps trigger one of the exposed events? Even if the event was triggered on every try including the initial one, if there was perhaps a header that exists on a retry but not the initial attempt, then I could manage it. The sender name is *always* the same, so I would check for: if(!s...

plumsauce

Is there a good spot to intercept insertion of failed emails into the retry queue? The reason for this is to drop the retry on automated mail sent by a application because the application handles the retry logic since it has access to information that the mail server does not. I know that I could ha...

plumsauce

I have never had an ISP with an open relay. compuserve.com anyways, it's not an "open relay", it's a relay with alternative authentication. you just don't happen to like the authentication mechanism. they don't block port 25 egress either. i just happen to like using their relay server because it i...

plumsauce

i recall that sendmail v8 used ident, i think exim in certain configs does too. the problem only arises if the firewall drops the ident connection without responding with a refusal. this can hang connections for 30+ seconds. but, as long as hmailserver itself does not use ident, then i can remove th...

plumsauce

Does hmailserver make outbound ident connections when responding to inbound connections?

ident is on port 113

plumsauce

What source port is used by hmailserver during smtp relay operations? Is it an ephemaral port client port? To clarify, I am trying to find out if hmailserver uses a specific port to talk to port 25 on the remote smtp server or it is just any port that winsock happens to hand out when the socket is c...

plumsauce

You are a clairvoyant too

Yes, I meant MAIL FROM. Thanks.

plumsauce

Where would email address whitelisting fit into the diagram? It's step 2 in sub process S1. Just to double check, that means RCPT TO is checked against the email sender name whitelist at about the same place as the connecting ip is checked against the ip whitelist? (step 2 of S1) On the subject of ...

plumsauce

Thanks for taking the time to write such a complete answer!

plumsauce

I have 2 ip ranges setup for 127.0.0.1 and the public ip's bound to the network card. These ip ranges specify no authentication required. I would like to send automated emails from an application using the account system@example.com Does the account system@example.com have to exist given that authen...

plumsauce

I am working my way through flowchart.pdf from the link posted. Where would email address whitelisting fit into the diagram? Additionally, are all of the "spam protection" processing blocks mentioned on page 1 of the type subprocess S2 as determined by subprocess S1? In subprocess S1, what is "forwa...

plumsauce

I think the distinction ought to be made between whitelisted ip addresses and whitelisted email addresses.

If you've whitelisted an IP address, hMailServer will ignore if the helo host it's giving is incorrect...

But, dasanco is talking about whitelisting by email address.

plumsauce

unless things have changed in the last few months, firebird does have size limitations.

plumsauce

windows has been stable since NT4 *if* it is properly setup.

my current uptime record for a publicly available W2K server monitored by netcraft.com is 495 days.

on day 496, an electrician pulled the wrong power cord at the data center.

the chart is now back up to 200+ days

plumsauce

The Windows and Netware login suspension models work very well. Implementing this when the user accounts are in a db is fairly simple. I have done this by incrementing a failed login counter that is reset on a successful login. If the failed login count reaches the defined threshold, the "wait until...

plumsauce

Convert to using stored procedures

plumsauce

I would like to be able to deny attachments by default unless they are in the exception list. By this, I mean that any attachment not matching the list would be deemed to be denied. It is much easier to decide on what attachments to permit than to try to imagine all the file extensions that might be...

plumsauce

Document that when using MSSQL, it is possible to manually create the database using the provided sql script. This is already possible but easily overlooked by a new user. Even though I knew this, I forgot by the time I did the production install and did a lot of grumbling caused by my paranoia. I j...

plumsauce

plumsauce

ah! thank you!

i do recall seeing that in my many visits to this site. i am guessing that it should be pretty much what i asked for

plumsauce

I would like to make two suggestions with respect to hmail. Both are relatively minor. Mention that when using MSSQL, it is possible to manually create the database using the provided sql script. Even though I knew this, I forgot by the time I did the production install and did a lot of grumbling ca...

plumsauce

If someone has the time, I would like to find out the exact order in which the following things happen: OnClientConnect greylisting host address blacklist lookup alias processing catchall processing whitelisting OnAcceptMessage OnDeliveryStart surbl blacklist processing clamwin spam filter external ...

plumsauce

For the record, I recommend against a portable implementation of hmailserver. I have seen more than enough source code that had to be butchered to the point of incomprehensibility with #ifdef 's to switch between compile targets. Multiple OS's mean that you get to favour 1 OS over another, or select...

plumsauce

I use hMail because I'm forced to use a Win server

never mind. once someone throws this line in, it's time to realise that one is dealing with a hammerhead.

shpeel ???

that would be "spiel" for those who still remember how to spell.

Search found 43 matches

rules: blank header value is not the same as does not exist

mssql stored proc to copy rules

mssql - primary and foreign key offsets

CreateTableMSSQL.sql

intercepting and cancelling sending retries

ident

request: information for firewall rules

sending from system accounts

Stored procedures

change attachment deletion control to default deny

document procedure to create databases manually

hmail suggestions

smtp receive processing order