IceWarp Server User to User Forum IceWarp Server User to User Forum

Forums  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

Mail stored in \mail-folder

  		Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [IceWarp Product Configuration] >> IceWarp Mail Server Configuration >> Mail stored in \mail-folder Page: [1]
Login
Message << Older Topic   Newer Topic >>
Mail stored in \mail-folder - 9/8/2008 5:07:22 AM   
MartinE

 

Posts: 4
Score: 0
Joined: 7/18/2008
Status: offline 		I've upgraded to merak 9.3.1 and suddenly a lot of mails in saved directly in the \merak\mail\-folder. I've checked the mails and it's incoming mail to user-accounts that does not exists. All domains have Reject mail in the Unknown Accounts option group. Merak also added a ~spam folder in \merak\mail\-folder. This folder contains spam to unexisting accounts. You can imagen the amount of mails in that folder :)
Does anyone have similar problems or perhaps a soulution? Manually deleting these mails dailey is not a fun task.
Post #: 1
RE: Mail stored in \mail-folder - 9/13/2008 4:51:18 AM   
marciohumpris

 

Posts: 274
Score: 0
Joined: 5/1/2008
Status: offline 		Hi, Martin

It seems some msgs are being saved in the root merak\mail? Check such msgs, see to whom they were addressed, probably you have some account which points directly to your mail root. Check SMTP logs also, as headers might not be enough. Or maybe your backup is set to that path? Or some catch all account or something like that or even that option Bad mail where Merak can send you all the undeliverables (in Mail Service/SMTP Service/Delivery) or some filter... In worse case some program like Filemon might help to understand why/by whom the file is being saved... Or a content filter to copy all outgoing and incoming msgs to some account...

About spams, its related to your default in Antispam. Remember spam folder only shows in IMAP or Webmail (or for POP you can use the spam reports). So its not interesting to set "Send msgs to spam folder" as a default if your users are unaware of the spam folder, they will believe they are not receiving mails which goe to their spam folder.

If in the root theres a ~spam it seems really theres some account whose path is wrong, pointing to root.

regards,
Marcio

(in reply to MartinE)
Post #: 2
RE: Mail stored in \mail-folder - 9/15/2008 4:45:57 AM   
MartinE

 

Posts: 4
Score: 0
Joined: 7/18/2008
Status: offline 		Hi and thanks for answering.

All mails are addressed to non-existing accounts.
I've checked all users paths (in db directly), they are all correct.
No backup is active.
I've checked the bad-mail setting, there's nothing.
Checked all filters but xan't find anything strange.
Here's some log entries for one of the mails going into the root:
---------------------------------------------------------------------------------------------
xxx.xxx.xxx.xxx  [053C] 15:42:45 Connected
xxx.xxx.xxx.xxx  [053C] 15:42:45 >>> 220 mail.ourserv.xx ESMTP Secure MX; Mon, 15 Sep 2008 15:42:45 +0200
xxx.xxx.xxx.xxx  [053C] 15:42:45 <<< EHLO [xxx.xxx.xxx.xxx]
xxx.xxx.xxx.xxx  [053C] 15:42:45 >>> 250-mail.ourserv.xx Hello [xxx.xxx.xxx.xxx] [xxx.xxx.xxx.xxx], pleased to meet you.
xxx.xxx.xxx.xxx  [053C] 15:42:46 <<< MAIL From:<john.hassett@iirme.com>
xxx.xxx.xxx.xxx  [053C] 15:42:46 >>> 250 2.1.0 <john.hassett@iirme.com>... Sender ok
xxx.xxx.xxx.xxx  [053C] 15:42:46 <<< RCPT To:burnoose@dom.xx
xxx.xxx.xxx.xxx  [053C] 15:42:46 >>> 250 2.1.5 burnoose@dom.xx... Recipient ok
xxx.xxx.xxx.xxx  [053C] 15:42:46 <<< DATA
xxx.xxx.xxx.xxx  [053C] 15:42:46 >>> 354 Enter mail, end with "." on a line by itself
xxx.xxx.xxx.xxx  [053C] 15:42:49 *** <john.hassett@iirme.com> <burnoose@dom.xx> 1 586 00:00:03 OK VWF81946
xxx.xxx.xxx.xxx  [053C] 15:42:49 >>> 250 2.6.0 586 bytes received in 00:00:03; Message id VWF81946 accepted for delivery
xxx.xxx.xxx.xxx  [053C] 15:42:50 <<< QUIT
xxx.xxx.xxx.xxx  [053C] 15:42:50 >>> 221 2.0.0 mail.ourserv.xx closing connection
xxx.xxx.xxx.xxx  [053C] 15:42:50 Disconnected
------------------------------------------------------------------------------------------------------------------
dom.xx is an existing domain on our mailserver but I'm 100% sure that the account burnoose@dom.xx does not exists, not it that or any other domain. And it's exacly the same thing with all other mail addressed to nonexisiting accounts. This mail should bounce.

Regarding the mails going into the ~spam-root folder, heres a log entry for one of those:
------------------------------------------------------------------------------------------------------------
83.8.34.143     [0668] 10:25:58 VRO83750 '<alvarez@idirect.net>' '<aaleigh@dom2.xx>' 1 score 10,00 reason [SpamAssassin=10,00,Body=R] action REFUSE
----------------------------------------------------------------------------------------------------------
Same here, dom2.xx is an existing domain but aaleigh@ is no user. The log say "action Refuse", but delivers it to the ~spam-folder in the root.

Since last post I've noticed that I can't add user through the GUI. It always say "Please, check the username/password for duplicity". Same thing with mailing lists etc. I've checked the database for duplicates but there are none. I can edit existing users, mailinglists, etc.

Could anyone please help, this is getting quite annyoing.

(in reply to MartinE)
Post #: 3
RE: Mail stored in \mail-folder - 9/20/2008 3:28:01 AM   
marciohumpris

 

Posts: 274
Score: 0
Joined: 5/1/2008
Status: offline 		Hi, Martin

My pleasure. Did you check the setting in antispam where you can have refused msgs sent to some account? Did you try to disable your content filters, etc (I imagine log doesnt show anything about them being hit). Maybe make some filter, where msg is from some specific address or so, write to a log file all varibables like %%sender%%, %%recipient%% (see merak/examples/variables.dat.html). So you could create some logs with all msgs, its senders and recipients. Also maybe send a copy to some audit account of all incoming mails (copy to some email address - set that account with no mailbox limit so it doesnt generate bounce backs).

Not sure if that would help. Did you check also your backup mail archive paths? There has to be some explanation... First you could try to reproduce the problem, get one of those msgs and resend them using SMTP traffic test (free downloads on icewarp site) or simply send msg to un inexisting account. Once you can reproduce it, it might be easier to deselect some options that might cause this in Merak (for example disable content filters, antispam, etc) and then you could find out what is causing it. Even if posssible, late night you can try to rename entire config folder (your Merak will be completely new without all of your settings/users if using file system, so be carefull)...

Not sure if some program like Filemon could help to see what account is being consulted or maybe Merak will go directly to the root mail folder.

From the SMTP logs it seems to Merak that this account does exist... Or else it would show another error. Merak things it exists. Maybe even try to rename the domain and recreate it. It always happens with this domain only?

So if the GUI now says duplicity, either the accounts are really duplicate (remember to check for aliases, mailing lists, groups, etc) or you have some type of DB corruption. Try to use tool display account aaleigh@dom2.xx u_password u_mailbox in DOS to see the results. Check your DB settings, consider switching over to file system, seeing if the problem disappears, moving the accounts back to a new database. Also you can check with TOOL what it informs about the setting regarding catch all setting on the domain (or check the DB directly).

Hope it helps, these are just some ideas, this is really a case where you could try and if its not solved, I would suggest you contact IW support.

Finally theres also a setting in Merak about what to do with bounce backs, default is bounce back for everyone, but you can restrict only to local users, for example.

regards,
Marcio

(in reply to MartinE)
Post #: 4
RE: Mail stored in \mail-folder - 9/22/2008 4:44:29 PM   
corinthian

 

Posts: 24
Score: 0
Joined: 5/16/2008
Status: offline 		Not exactly sure on this but doesn't' the MDA force all emails to be received by the system?  This could also be the culprit.

(in reply to marciohumpris)
Post #: 5
RE: Mail stored in \mail-folder - 9/23/2008 11:34:49 PM   
MartinE

 

Posts: 4
Score: 0
Joined: 7/18/2008
Status: offline 		Hi and thanks for all the help. I think I perhaps figured it out. I think the problem is the connection to the database. The problem with adding new accounts could be related to the fact that the query always returns a positive result even though there are no duplicates in the database, I'm 100% sure. Perhaps this could also apply to the fact that the SMTP-log reports that nonexisting accounts exists and try to deliver them to the unexisting users folder which will then be empty (mailroot). Spam is delivered to the ~spam-folder of the unexisting account which then will be mailroot\~spam.
Does this seem logical?
This Saturday I will move the entire database from MySQL 4 to MySQL 5 and change from ODBC-connection to MySQL-connection using a new libmysql.dll in Merak and see if it makes a difference.

(in reply to corinthian)
Post #: 6
RE: Mail stored in \mail-folder - 9/27/2008 3:39:14 AM   
marciohumpris

 

Posts: 274
Score: 0
Joined: 5/1/2008
Status: offline 		Hi, Martin

Corinthian, afaik MDA doesnt do this, it just separates msgs receiveid in a separate queue instead of running filters, antispam during the moment when msg is being received.

Martin, glad youre finding a way out. Really not sure about what you said, I think best would be to open support ticket and send them remote access. There has to be some explanation to why msgs are going to your root /mail folder (like catch all or something) and why you have problems creating new accounts (usually problem is the syntax definition in ODBC settings for storage).

About storage with MySQL, Ive personally always used ODBC with MyODBC. The other ideas I sent might help to troubleshoot.

Good luck.

regards,
Marcio

(in reply to MartinE)
Post #: 7
RE: Mail stored in \mail-folder - 9/29/2008 4:17:16 AM   
MartinE

 

Posts: 4
Score: 0
Joined: 7/18/2008
Status: offline 		Some feedback.
As I expected. I moved meraks database from a MySQL 4.1 to a MySQL 5.x and all my problems went away. It works fine with both ODBC and MySQL directly through libmysql.dll. Merak is no longer storing mail to unknown users in the root folder and I'm able to add users through the GUI. The problem first occured when upgrading to merak 9.3.1, that makes me wonder if icewarp made som changes to the db-routines in Merak....
Well, problem solved, I'm happy.

// Martin

(in reply to marciohumpris)
Post #: 8
RE: Mail stored in \mail-folder - 9/30/2008 9:36:03 AM   
corinthian

 

Posts: 24
Score: 0
Joined: 5/16/2008
Status: offline 		MartinE,

I have had to "re-upgrade" the database after each upgrade.  This is done by migrating the database into a new db.  Failing to do so has produced several issues but not ones like you mentioned.  It may have been that your issue was due to the database not upgrading.

On a second note (if I may ask)... which version of the libmysql.dll are you using.  There is a KI where it will produce a my_thread<something?>  error in some versions.  Was wondering if you have detected this?

gl,
Corin

(in reply to MartinE)
Post #: 9
RE: Mail stored in \mail-folder - 10/4/2008 2:34:56 AM   
marciohumpris

 

Posts: 274
Score: 0
Joined: 5/1/2008
Status: offline 		Hi, Martin!

Glad you solved it! The good thing in Merak is that if you analyse all the factors, you will end up finding a solution.

Really strange, however. What I know is that upon upgrade IceWarp does some upgrade procedures (theres even a command in tool to force such upgrade procure), so if you install a newer merak and restore an older backup you might have issues.

Ive always used Mysql or SQL via ODBC, not directly as you did. I imagine maybe somehow some wrong path or setting in the DB. I guess it would be really necessary to somehow reproduce, if you still have a backup of your DB maybe try with another installation to use that same DB, the evidence is probably in there...

regards,
Marcio

(in reply to MartinE)
Post #: 10
RE: Mail stored in \mail-folder - 10/4/2008 7:05:15 AM   
corinthian

 

Posts: 24
Score: 0
Joined: 5/16/2008
Status: offline
quote:

The good thing in Merak is that if you 'analyze' all the factors, you will end up finding a solution.

I agree with you here.  However, I am certain that some find it difficult to find this information - looking in the wrong log, detail not enabled high enough, not able to understand what it says, etc. etc.  I have a couple of issues that have I have only found it possible to document by enabling logging elsewhere in some other application or within the O/S itself.

quote:

Ive always used Mysql or SQL via ODBC, not directly as you did.

I've continued to not use ODBC primarily because the DB was not updating completely/properly with either, ODBC or direct.  The direct connection is certainly faster & used less resources thus I've continued this way.  The support tech stated this was a KI, but with a simple solution whether via the command tool or migration, there's no need to press the issue.

quote:

I imagine maybe somehow some wrong path or setting in the DB. I guess it would be really necessary to somehow reproduce, if you still have a backup of your DB maybe try with another installation to use that same DB, the evidence is probably in there...

There's no path setting that I can think of which would confuse things.  There's no such setting with a direct connection.
I do, still, have monthly backups in which could be used.  Maybe when time presents itself I'll replay the event on the test box.  I do have plans to enable logging on the SQL server during the next upgrade, hoping that this will shed some light.

Martin -- Have you found resolution to your problem(s)? Marcio's response are right on and should get you straightened.

Many thanks for the comments. The sharing is what empowers us all.

(in reply to marciohumpris)
Post #: 11
RE: Mail stored in \mail-folder - 10/11/2008 2:15:37 AM   
marciohumpris

 

Posts: 274
Score: 0
Joined: 5/1/2008
Status: offline 		Hi, Corinthian

Thanks for answers, hope all works out well for you. I Might try direct connection to see how it compares with ODBC.

regards,
Marcio

(in reply to corinthian)
Post #: 12
Page:   [1]
All Forums >> [IceWarp Product Configuration] >> IceWarp Mail Server Configuration >> Mail stored in \mail-folder Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


2001 - 2008 © IceWarp