Search found 43 matches

by Spyd
2016-05-31 14:27
Forum: Scripting
Topic: Simple Spam/Virus Warning in Object for exe in zip/rar/7z
Replies: 25
Views: 9026

Re: Simple Spam/Virus Warning in Object for exe in zip/rar/7z

I'm testing this script. It does it's job, but it's a bit overkill in my opinion.
Is there a way to make it so if the attachment is marked as positive is renamed or the attachment removed instead of deleting the entire email?
by Spyd
2015-06-27 09:48
Forum: General discussions
Topic: MySQL stored procedure to automatically file folders by year
Replies: 16
Views: 4260

Re: MySQL stored procedure to automatically file folders by year

I modified the stored again, this time I added results, so there's no longer a warning after calling it. Also, as the stored returns progress data, you know what's doing. note: Something I don't know how to do, is to return the progress data in a single data set with multiple rows, instead of a data...
by Spyd
2015-06-25 14:46
Forum: General discussions
Topic: MySQL stored procedure to automatically file folders by year
Replies: 16
Views: 4260

Re: MySQL stored procedure to automatically file folders by year

I'm sorry; I forgot to mention that you need to restart the hMailServer's service to the changes to reflect on your mail client. It's provably caused by some memory caches that keep the old data for speedier processing on the hMailServer itself. Maybe the better way to do this is: Prepare everything...
by Spyd
2015-06-23 16:05
Forum: General discussions
Topic: MySQL stored procedure to automatically file folders by year
Replies: 16
Views: 4260

Re: MySQL stored procedure to automatically file folders by year

How to automatically file mail in year folders - TUTORIAL. Disclaimer: While I tested this a lot in my own hMailServer installation (even in the live database), when you play with the internals of any program, anything can go wrong. To be in the safe side, make a complete backup of the database bef...
by Spyd
2015-06-23 14:47
Forum: General discussions
Topic: MySQL stored procedure to automatically file folders by year
Replies: 16
Views: 4260

Re: MySQL stored procedure to automatically file folders by year

Long time not caring about this piece of code, but that's a good thing. It works pefectly.
xsel777 wrote:Help!
Ok, I'm going to do a noob-proof tutorial as how to make it work... stay tuned.
by Spyd
2015-06-02 10:04
Forum: General discussions
Topic: Error HM5032 "Incorrect String Value"
Replies: 14
Views: 10905

Re: Error HM5032 "Incorrect String Value"

I can confirm this is something related to rarely used UTF-8 codes. They can be icons or symbols or anything. You know they're rare because maybe they're displayed correctly in one computer/font or maybe the same code gives you a question mark inside a block on other computer/font. I had this proble...
by Spyd
2015-04-15 15:25
Forum: General discussions
Topic: Help - No one can log into the hMail Server
Replies: 35
Views: 9645

Re: Help - No one can log into the hMail Server

First, hMailServer seems to not be able to find the database server. Then as you say the clients error is "wrong password", it's likely that you have another mail server installed in the same server as hMailServer.Look for any other software on your server that uses the ports configured on your hMai...
by Spyd
2015-04-15 12:13
Forum: General discussions
Topic: MySQL stored procedure to automatically file folders by year
Replies: 16
Views: 4260

Re: MySQL stored procedure to automatically file folders by year

If your script is able to do INBOX |--- Dealt |--- 2014 |--- 2013 |--- 2012 in some way then I would be more than happy You now can do it with the 0.2 version of the stored procedure. Just call it this way: CALL yearize(INBOX FOLDERID, DEALT FOLDERID, true); Set the last parameter to true if you wa...
by Spyd
2015-04-15 12:03
Forum: General discussions
Topic: MySQL stored procedure to automatically file folders by year
Replies: 16
Views: 4260

Re: MySQL stored procedure to automatically file folders by year

I have a new version of the stored procedure! Changes: -New parameter: "Destination Folder" -> you can set a folderid for the folder where you want the year folders created. Use the same selects to get the folder id of the destination folder. You can use the same folder as the folder to file inputti...
by Spyd
2015-04-12 19:27
Forum: General discussions
Topic: MySQL stored procedure to automatically file folders by year
Replies: 16
Views: 4260

Re: MySQL stored procedure to automatically file folders by year

If I'm reading the code correct then the procedure will make yearly subfolders for folder (X) ... INBOX ( X = oFolder.ItemByName(INBOX).ID ) |---2011 <--- containing 'inbox' emails from 2011) |---2012 |---2013 |---2014 I may need to update my MySQL as I can't make it accept this.. (or perhaps read ...
by Spyd
2015-04-11 21:34
Forum: General discussions
Topic: MySQL stored procedure to automatically file folders by year
Replies: 16
Views: 4260

MySQL stored procedure to automatically file folders by year

WARNING: this post contains SQL that can potentially destroy your hMailServer database. Use it at your own risk. WARNING 2: if you intend to use this stored procedure, read all this post. There's important information at the end. I have several IMAP accounts on my hMailServer that have massive amou...
by Spyd
2014-10-14 00:30
Forum: Feature requests
Topic: Long-term roadmap suggestions?
Replies: 91
Views: 41193

Re: Long-term roadmap suggestions?

I really like hMailServer as it is now, so for me the only major thing is performance.
by Spyd
2014-01-30 13:42
Forum: User contributed hMailServer 5 scripts
Topic: Aliases when only allowing to send from your own account
Replies: 4
Views: 4488

Re: Aliases when only allowing to send from your own account

Might be a good idea to check that to/from are not "" (like when address is <>) to avoid issues with mid & instr but also to skip some code in that case. Bill Can't test it, because Outlook won't let me set up an account with an invalid address, but it should work. Known limitations: If you try to ...
by Spyd
2014-01-29 18:32
Forum: User contributed hMailServer 5 scripts
Topic: Aliases when only allowing to send from your own account
Replies: 4
Views: 4488

Aliases when only allowing to send from your own account

This script lets you send a message using your own account, any of your aliases, and any of your domain aliases, and disallows you from sending using a non existing combination of account, alias or domain alias. I have tested it with all the possible allowed permutations (account@domain, alias@domai...
by Spyd
2014-01-14 12:05
Forum: General discussions
Topic: Moving data folder
Replies: 4
Views: 1463

Re: Moving data folder

By the way, I took a look at the 5.4 documentation, and there's no mention of hMailServer using relative paths, even it warns you about absolute paths when moving servers... I'm sure it's because the documentation was copied from the 5.3 one. Can you show the specific page that has this incorrect i...
by Spyd
2014-01-09 10:41
Forum: General discussions
Topic: Moving data folder
Replies: 4
Views: 1463

Moving data folder

I had hMailServer for a long time on a home server, then I had enough to pay for a dedicated server where I transferred all the installation and data. At that time 5.4 wasn't out, so I had to recreate the exact same folder locations to make it work, and because of this I have the data folder on the ...
by Spyd
2013-10-16 23:25
Forum: General discussions
Topic: How to identify SMTP user / how to avoid SMTP abuse
Replies: 2
Views: 1266

Re: How to identify SMTP user / how to avoid SMTP abuse

Thank you for the help. That's all I needed to fix my problems.
by Spyd
2013-10-16 22:27
Forum: General discussions
Topic: How to identify SMTP user / how to avoid SMTP abuse
Replies: 2
Views: 1266

How to identify SMTP user / how to avoid SMTP abuse

Today I had a very busy day. During the morning, my mail users complained about not being able to send/receive mails, but as they had some Internet problems, and on my phone my accounts seemed to run fine, I didn't look into it. When I got home at night, I looked onto it, and almost had a heart atta...
by Spyd
2011-12-05 12:08
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29939

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

I'll try looking at the sources. I don't have VS2008, and the only downloadable trials are for the 2010 edition. Does the project work with VS2010? I did a SVN Checkout, and looked at PersistentMessageMetaData (using notepad). I'm not familiar using databases in C++ so I have lots of questions abou...
by Spyd
2011-12-05 10:28
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29939

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

That would work. How good are you at C++? I usually program in Delphi and my database of choice is Firebird; but I defend myself in C++. The indexer thread actually calls another class to get a listing of messages to index. MessageIndexer is the file that does the indexing, PersistentMessageMetaDat...
by Spyd
2011-12-01 12:20
Forum: Development & alpha discussions
Topic: Message Indexing query slow, can we optimize it?
Replies: 61
Views: 29939

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

I have an idea that I think can contribute to speed up and be without index misses and without schema changes. As I don't exactly know how hMailSever works internally, I don't know if it's feasible, but here I go: So I guess the MessageID column is an integer and that increments with every message. ...
by Spyd
2011-10-07 11:54
Forum: Development & alpha discussions
Topic: I am alive
Replies: 32
Views: 15383

Re: I am alive

I'm just curious about what happened to Martin because his last activity in this forum is more than 2 months old.
Does anybody know?
by Spyd
2011-08-11 13:20
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Re: Account with too many messages

^DooM^ wrote:Did you have pop3 logging enabled in hMail? If you did you will see why pop3 clients choke on massive amounts of email.
Didn't have POP3 logging enabled.
by Spyd
2011-08-11 13:20
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Re: Account with too many messages

I finally got that damn account empty. IMAP worket well, but a bit slow. I had only one or two timeouts. Also (I don't know if because Thunderbird or hMail) sometimes deleted mails appeared again after restarting the client.
But at least I got to empty that account, it was a pain in the ass to backup.
by Spyd
2011-08-09 00:44
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Re: Account with too many messages

Accessing large folders with IMAP works. Now the problem seems to be the client. Thunderbird is a bit slow, but I don't care if it gets the job done. Anyway, I'm curious as why there are so many problems with large folders using POP3. Someone that knows the internals of hMailServer can satiate my cu...
by Spyd
2011-08-09 00:02
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Re: Account with too many messages

Ok, I changed the account on Thunderbird to IMAP. To my surprise, it still has 10k messages, so while in POP mode Thunderbird was downloading the undownloaded messages only every time I tried, it didn't erase none. Now the IMAP folder downloaded fine (headers only). But It downloaded all the 10k hea...
by Spyd
2011-08-08 18:03
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Re: Account with too many messages

^DooM^ wrote:I have one account with ~100k emails in and I can access it fine with thunderbird using IMAP. You should not check huge folders with pop3.
Ok, so the limitation is with the POP3 protocol?
I'm going to try to setup the account as IMAP and I'll be moving from the imap inbox to local folders.
by Spyd
2011-08-08 10:18
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Re: Account with too many messages

I'm using Thunderbird 5.0. You need lighter IMAP client. Try some webmail. If hMailServer is set to use MySQL, make sure that indexing is turned on in hMailServer advanced performance settings. Don't do that if you use MSSQL Compact. Make sure that your webmail client does not try to sort that mail...
by Spyd
2011-08-08 10:13
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Re: Account with too many messages

mattg wrote: I only use IMAP, but is it in

Tools >> Options >> Advanced >> Network and Disk Space
In this tab there's only proxy, disk space and offline options. :(
by Spyd
2011-08-07 17:33
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Re: Account with too many messages

I forgot to add: When I restart the service, the "stopping service" progress bar appears, but the service does not seem to send the "stopped" message back, so the progress bar slowly fills until there's a message about "Windows can't stop the service" (don't remember exact error message text). The s...
by Spyd
2011-08-07 15:35
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Re: Account with too many messages

In the mail client extend the timeout to maximum I'm using Thunderbird 5.0. I can't find the option, and while I looked at the advanced options I'm not sure what option is (filtering for timeout gives about 15 results). Are you leaving the messages on Server? No, the idea is to free the server from...
by Spyd
2011-08-05 21:06
Forum: General discussions
Topic: Account with too many messages
Replies: 22
Views: 7844

Account with too many messages

I'm using hMailServer 5.3.3 B1879, on a Windows 2003 Server Enterprise with SP2. I have several domains and dozens of mail accounts. About 1/3 get the mail is get thru IMAP, the rest using POP3 only. The server works flawlessly, except when I discovered an unattended account that had more than 90k m...
by Spyd
2010-02-09 17:41
Forum: General discussions
Topic: Mail sent from public dynamic IP addresses allways is spam
Replies: 3
Views: 1309

Re: Mail sent from public dynamic IP addresses allways is spam

The problem isn't me nor my SA; the problem is that there are some domains that refuse to receive mail from the affected address. When I receive his mails I usually receive them as non spam (I have a 5.0 points to be tagged as spam in my SA config. Meanwhile, I requested a full header from the mail ...
by Spyd
2010-02-09 11:50
Forum: General discussions
Topic: Mail sent from public dynamic IP addresses allways is spam
Replies: 3
Views: 1309

Mail sent from public dynamic IP addresses allways is spam

Hi. One of the users of my email server has an ISP that is permanently tagged as spam sender, and he can't change it. All mails that he sends have these SpamAssasin scores: 0.9 RCVD_IN_PBL RBL: Received via a relay in Spamhaus PBL [83.38.103.236 listed in zen.spamhaus.org] 0.9 RCVD_IN_SORBS_DUL RBL:...
by Spyd
2009-08-05 16:30
Forum: General discussions
Topic: Severe crash
Replies: 3
Views: 983

Re: Severe crash

Did you receive the email?
by Spyd
2009-07-27 14:40
Forum: General discussions
Topic: Severe crash
Replies: 3
Views: 983

Re: Severe crash

Full log + problematic mails sent your way from address fp (a) um21 (point) net
by Spyd
2009-07-22 12:28
Forum: General discussions
Topic: Severe crash
Replies: 3
Views: 983

Severe crash

Today my mail users warned me that they were unable to access their email from POP3 nor from SquirrelMail. I checked the server, and while the service was still running, nothing worked except the administrator. I tried to stop the service and it stoped about 2 minutes after I pressed the "stop" butt...
by Spyd
2008-02-24 18:55
Forum: General discussions
Topic: Bad connection-related tolerancy
Replies: 8
Views: 1730

I think I found what's wrong. I only need the last confirmation to be sure at last: -When you're using SquirrelMail, all the external connections are managed by Apache? While I'm positive the answer is yes, this means that something has gone horribly wrong with my network (or my DSL router). I'm jus...
by Spyd
2008-02-24 12:10
Forum: General discussions
Topic: Bad connection-related tolerancy
Replies: 8
Views: 1730

I'm sorry because I love hMailServer, but if I can't get any help about my problem I'll have to go back to Argosoft.
I just can't have my users waiting any more time.
by Spyd
2008-02-21 22:19
Forum: General discussions
Topic: Bad connection-related tolerancy
Replies: 8
Views: 1730

Today I tested if this happens with IMAP, and the problem is the same.
What can I do to get more data on this error?
by Spyd
2008-02-19 21:25
Forum: General discussions
Topic: Bad connection-related tolerancy
Replies: 8
Views: 1730

The exact error that the client gives me is: El servidor finalizó inesperadamente la conexión. Puede que haya un problema en el servidor, un problema de red o que haya estado inactivo un periodo largo. Cuenta: 'um21.net', Servidor: 'um21.net', Protocolo: POP3, Puerto: 110, Seguridad (SSL): No, Error...
by Spyd
2008-02-19 20:20
Forum: General discussions
Topic: Bad connection-related tolerancy
Replies: 8
Views: 1730

I upgraded to a new server, so as I had to reinstall all and I hadn't any good upgrade options to argosoft .net mail server, I decided to try hMailServer on the new server. The old server (with argosoft) is still online, but not visible from the Internet. I'm keeping it installed so changing the NAT...
by Spyd
2008-02-19 11:31
Forum: General discussions
Topic: Bad connection-related tolerancy
Replies: 8
Views: 1730

Bad connection-related tolerancy

I just migrated from ArgoSoft, and while I love almost every aspect of hMailServer compared to ArgoSoft (except account aliases that are real slow to add), I have encountered a severe problem: I live in Spain, and I have the server on a DSL line, and while it is a good line (based on local standards...