I manage a few linux mail servers and one of the automatic scripts that has proved really useful in one which reads the last couple of hours of entries in the log file and tries to determine if an email account has sent more than 30 emails in an hour (its just an arbitrary figure we picked) if there...

The account info has the password of test They are base64 encoded values. Suggest you disable that account fast and change the password, check undelivered messages as well to make sure your not sending out spam and if you are, delete the spam from the undelivered queue. I recently had a similar pro...

Just for the record I had something similar and never did end up find how they actually were able to send out the junk mail. In the end I blocked their range of IP address (from Nigeria) which seemed to solve the problem. A bit heavy handed I spose but it wokred

Rainer, here is the batch file i use. @echo off if not "%echoon%"=="" echo on endlocal if "%1"=="" goto :USAGE if "%1"=="/?" goto :USAGE if /I "%1"=="/h" goto :USAGE if /I "%1"=="-h" goto :USAGE REM CODE BELOW HERE REM prereq check phase for %%i in (logparser.exe) do set LOGPARSERPATH=%%~$PATH:i if...

I would like to write a script to list all the emails in a user's inbox. This is easy enough by writing an SQL query and outputting the results. The problem is that I would like to be able to do this from hmail's admin panel so you would select a user then click a button on the users General tab pag...

thanks

that's what I was hoping thanks. I jsut couldnt' find it b4 but have had another look & found the field.

btw - is there any database schema or even better an ERD or soemthing to help us write SQL statement to query the db?

Can someone give me a few clues on setting up SSL. Do I have to get a server wide certificate (which is expensive) or can I just get a certificate for the 1 server domain name and then have users use that domain name to connect? Can I just generate my own certificate for email and if so would it sti...

In the Admin gui each account has a total size figure.

If I want to create a report showing how much each account has used - where would I find this? Is it held in the database, calculated from individual; email sizes in the database or is the actual size of files in the HDD added and calculated?

do u know how it works?

I was assuming the server would fire off the emails to the external server for checking then the SA server would send them back.

Its now sounding like the SA server would analyse the email while its held on the hmail server - is that correct?

sounds to me then that the problem of having to initially train SA is solved. Just use it on another server that has been running for a few years.

It would probalby be worthwhile to get a cheap reseller account on a linux server and pass all your hmail emails thru it.

martin wrote:No, in version 5 you'll have to launch spamd and then enable the integration. If SpamAssassin is running on another computer, you have to type in the host name of that server.

so does that mean you could run email through SA on a completely different server?

SQLYog would do this really well tho I haven't tried it

got it now - think I had an extra charactor in the password b4 decryption

got it now - thanks

the internal MySQL on port 3307.

I'm using SQLYog which I use to access my main MySQL. I just can't seem to get into the hmail one. I've got the port set to 3307, the username is root and I have decrypted the password from the ini file but I always get an access dinied for root@localhost error. which means the password is wrong but...

[The internal database listens on port 3307. I'm not sure exactly what you mean. You typically doesn't connect *from* port 3306 when connecting to MySQL. There's info here on how to connect to the internal database: http://www.hmailserver.com/documentation/?page=howto_connect_to_mysql[/quote] I trie...

so how do u access the database in version 5?

the folders are in the database but the email files are stored on the HDD - right?

I was trying to locate where exactly the IMAP data and folders were stored. We'd written a small app to transfer IMAP folders from another mail server to hmail and I was trying to din out where the data actually was. Its seems IMAP folder email is just stored in the same place as all the rest. (I th...

Where are the IMAP folders actually stored?

Version 5 but I've sorted it now and found hmail can use both ports for SMTP.

My problem was that the outgoing SMTP server in IIS (for sending mail from scripts) was also set to port 26.

Some ISPs here block port 25. So a quick workaround is often to use port 26 for a mail server but you don't want to only have port 26 because most email clients use port 25 by default and its too hard to explain to people how to reset their client to use port 26 unless they really need to. Can hamil...

so what's the outcome?

Is it possible to use rules to find words an then increment the spam score?

I'm writing a script to add new accounts and also external accounts for fetching. Everything is working fine.

Is there a property to enable "Delete Messages Immediately"? or Are messages deleted immediately by setting the DaysToKeepMessages to 0?

martin wrote:Download textfilemigrate4.zip and read the sample.txt

Textfilemigrate.exe allows you to select which file to import.

Yeah but where from. The link about wont let me browse the directory

These scripts are a few years old now. Is there a newer or better way to import users now?

The script gives me errors about authentication - is there a later version now?

not sure how extensive wild card use is for white listing. Eg. Could I use *.co.nz as a wild card?

My reason being very little spam is generated by .co.nz domain names

martin wrote:If you guys have the account passwords for both old and new server, you can copy the messages using IMAPCopy:
http://home.arcor.de/armin.diehl/imapcopy/imapcopy.html

IMAPCopy appears to be gone. IMAPsync is probably better anyway but I've never been able to get it to work.

why bundle a database with it at all? MySql is commonly used and free. Why not just use a database in an external implementation of MySql that the user has to install and set up?

I have a similar situation - plenty of SPAM getting through. I have spamcop, spamhaus & SURBL all activated. OK I can see the system will never mark email that is DNS blacklisted but reject it completely. But why have I never seen any remaining email marked as SPAM?

Was this ever implemented?

that was a relief - thought I was going to have to reinstall

thanks for the info. Regenerating a new hash code worked great