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?
Search found 43 matches
- 2016-05-31 14:27
- Forum: Scripting
- Topic: Simple Spam/Virus Warning in Object for exe in zip/rar/7z
- Replies: 25
- Views: 18120
- 2015-06-27 09:48
- Forum: General discussions
- Topic: MySQL stored procedure to automatically file folders by year
- Replies: 16
- Views: 13556
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...
- 2015-06-25 14:46
- Forum: General discussions
- Topic: MySQL stored procedure to automatically file folders by year
- Replies: 16
- Views: 13556
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...
- 2015-06-23 16:05
- Forum: General discussions
- Topic: MySQL stored procedure to automatically file folders by year
- Replies: 16
- Views: 13556
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...
- 2015-06-23 14:47
- Forum: General discussions
- Topic: MySQL stored procedure to automatically file folders by year
- Replies: 16
- Views: 13556
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.
Ok, I'm going to do a noob-proof tutorial as how to make it work... stay tuned.xsel777 wrote:Help!
- 2015-06-02 10:04
- Forum: General discussions
- Topic: Error HM5032 "Incorrect String Value"
- Replies: 14
- Views: 20453
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...
- 2015-04-15 15:25
- Forum: General discussions
- Topic: Help - No one can log into the hMail Server
- Replies: 35
- Views: 25677
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...
- 2015-04-15 12:13
- Forum: General discussions
- Topic: MySQL stored procedure to automatically file folders by year
- Replies: 16
- Views: 13556
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...
- 2015-04-15 12:03
- Forum: General discussions
- Topic: MySQL stored procedure to automatically file folders by year
- Replies: 16
- Views: 13556
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...
- 2015-04-12 19:27
- Forum: General discussions
- Topic: MySQL stored procedure to automatically file folders by year
- Replies: 16
- Views: 13556
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 ...
- 2015-04-11 21:34
- Forum: General discussions
- Topic: MySQL stored procedure to automatically file folders by year
- Replies: 16
- Views: 13556
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...
- 2014-10-14 00:30
- Forum: Feature requests
- Topic: Long-term roadmap suggestions?
- Replies: 91
- Views: 88565
Re: Long-term roadmap suggestions?
I really like hMailServer as it is now, so for me the only major thing is performance.
- 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: 7759
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 ...
- 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: 7759
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...
- 2014-01-14 12:05
- Forum: General discussions
- Topic: Moving data folder
- Replies: 4
- Views: 3270
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...
- 2014-01-09 10:41
- Forum: General discussions
- Topic: Moving data folder
- Replies: 4
- Views: 3270
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 ...
- 2013-10-16 23:25
- Forum: General discussions
- Topic: How to identify SMTP user / how to avoid SMTP abuse
- Replies: 2
- Views: 2777
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.
- 2013-10-16 22:27
- Forum: General discussions
- Topic: How to identify SMTP user / how to avoid SMTP abuse
- Replies: 2
- Views: 2777
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...
- 2011-12-05 12:08
- Forum: Development & alpha discussions
- Topic: Message Indexing query slow, can we optimize it?
- Replies: 61
- Views: 51966
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...
- 2011-12-05 10:28
- Forum: Development & alpha discussions
- Topic: Message Indexing query slow, can we optimize it?
- Replies: 61
- Views: 51966
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...
- 2011-12-01 12:20
- Forum: Development & alpha discussions
- Topic: Message Indexing query slow, can we optimize it?
- Replies: 61
- Views: 51966
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. ...
- 2011-10-07 11:54
- Forum: Development & alpha discussions
- Topic: I am alive
- Replies: 32
- Views: 27423
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?
Does anybody know?
- 2011-08-11 13:20
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
Re: Account with too many messages
Didn't have POP3 logging enabled.^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.
- 2011-08-11 13:20
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
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.
But at least I got to empty that account, it was a pain in the ass to backup.
- 2011-08-09 00:44
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
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...
- 2011-08-09 00:02
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
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...
- 2011-08-08 18:03
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
Re: Account with too many messages
Ok, so the limitation is with the POP3 protocol?^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.
I'm going to try to setup the account as IMAP and I'll be moving from the imap inbox to local folders.
- 2011-08-08 10:18
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
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...
- 2011-08-08 10:13
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
Re: Account with too many messages
In this tab there's only proxy, disk space and offline options.mattg wrote: I only use IMAP, but is it in
Tools >> Options >> Advanced >> Network and Disk Space
- 2011-08-07 17:33
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
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...
- 2011-08-07 15:35
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
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...
- 2011-08-05 21:06
- Forum: General discussions
- Topic: Account with too many messages
- Replies: 22
- Views: 15372
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...
- 2010-02-09 17:41
- Forum: General discussions
- Topic: Mail sent from public dynamic IP addresses allways is spam
- Replies: 3
- Views: 2865
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 ...
- 2010-02-09 11:50
- Forum: General discussions
- Topic: Mail sent from public dynamic IP addresses allways is spam
- Replies: 3
- Views: 2865
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:...
- 2009-08-05 16:30
- Forum: General discussions
- Topic: Severe crash
- Replies: 3
- Views: 2274
Re: Severe crash
Did you receive the email?
- 2009-07-27 14:40
- Forum: General discussions
- Topic: Severe crash
- Replies: 3
- Views: 2274
Re: Severe crash
Full log + problematic mails sent your way from address fp (a) um21 (point) net
- 2009-07-22 12:28
- Forum: General discussions
- Topic: Severe crash
- Replies: 3
- Views: 2274
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...
- 2008-02-24 18:55
- Forum: General discussions
- Topic: Bad connection-related tolerancy
- Replies: 8
- Views: 3908
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...
- 2008-02-24 12:10
- Forum: General discussions
- Topic: Bad connection-related tolerancy
- Replies: 8
- Views: 3908
- 2008-02-21 22:19
- Forum: General discussions
- Topic: Bad connection-related tolerancy
- Replies: 8
- Views: 3908
- 2008-02-19 21:25
- Forum: General discussions
- Topic: Bad connection-related tolerancy
- Replies: 8
- Views: 3908
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...
- 2008-02-19 20:20
- Forum: General discussions
- Topic: Bad connection-related tolerancy
- Replies: 8
- Views: 3908
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...
- 2008-02-19 11:31
- Forum: General discussions
- Topic: Bad connection-related tolerancy
- Replies: 8
- Views: 3908
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...