orphan mails in 5.3.4-B1913

Use this forum if you want to discuss a problem or ask a question related to a hMailServer beta release.
Post Reply
sbouli
Normal user
Normal user
Posts: 69
Joined: 2007-11-27 12:37

orphan mails in 5.3.4-B1913

Post by sbouli » 2012-06-22 10:47

Hi,

(first I have to apologize to Bill48105 for not opening a new thread, but as I got multiple subject questions, I will have to open multiple thread BUT as I don't receive any notification when there is reply, it's not easy to follow).

I am planning to upgrade on 5.4, but before, I was checking my backup and I discovered that I have eml files stuck in the data folder, not sent and seem to be forgotten by hmailserver ....
Is there a way to ask hmailserver to scan those files to resend them ?

Stéphane

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: orphan mails in 5.3.4-B1913

Post by ^DooM^ » 2012-06-22 10:54

Open up the eml files in outlook or thunderbird and see when they were supposed to be sent and what's in them first. If you need to send them just hit forward in your client and send them on. That's the easiest way.
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

sbouli
Normal user
Normal user
Posts: 69
Joined: 2007-11-27 12:37

Re: orphan mails in 5.3.4-B1913

Post by sbouli » 2012-06-22 11:06

^DooM^ wrote:Open up the eml files in outlook or thunderbird and see when they were supposed to be sent and what's in them first. If you need to send them just hit forward in your client and send them on. That's the easiest way.
those mails are there since yesterday, at the time the hmailserver crashed (see the other thread on "ERROR" 2184 "2012-06-21 09:51:51.171" "Severity: 2 (High), Code: HM4208, Source: IOCPQueueWorkerTask::DoWork, Description: An unknown error occured while handling asynchronous requests. Error number: invalid vector<T> subscript"). As the server is the company one (in production) those emails are for some of my colleagues coming from outside, I just cannot bring them back to my computer and just send them !

There is probably no other way ... I think that a little tool would be great for next version ;) I will post in the correct area ....

Stéphane

sbouli
Normal user
Normal user
Posts: 69
Joined: 2007-11-27 12:37

Re: orphan mails in 5.3.4-B1913

Post by sbouli » 2012-06-22 11:21

sbouli wrote:[...] BUT as I don't receive any notification when there is reply, it's not easy to follow[...]
I do receive the notification now !

Stéphane

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: orphan mails in 5.3.4-B1913

Post by ^DooM^ » 2012-06-22 13:03

No open them on the server. i said nothing of bringing them to your own client.
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

sbouli
Normal user
Normal user
Posts: 69
Joined: 2007-11-27 12:37

Re: orphan mails in 5.3.4-B1913

Post by sbouli » 2012-06-22 14:29

^DooM^ wrote:No open them on the server. i said nothing of bringing them to your own client.
I have no mail client on the server. Moreover, I don't want to forward those mail with my mail account, some of them are probably for outside people, and I speak about 150 files ... so manual solution is not welcome :) ....

but ... still ... thanks for your help !!

Stéphane

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: orphan mails in 5.3.4-B1913

Post by ^DooM^ » 2012-06-22 14:33

Well the other way is manual, a lot more work, requires knowledge of SQL and a lot harder, so it's your choice.

Either setup a generic account on your mailserver and send it through that or re-add them to the database and have the mailserver send them out or use the COMAPI and VBScript to loop through each email and send them out as each specific sender.
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

sbouli
Normal user
Normal user
Posts: 69
Joined: 2007-11-27 12:37

Re: orphan mails in 5.3.4-B1913

Post by sbouli » 2012-06-22 14:43

^DooM^ wrote:re-add them to the database and have the mailserver send them out
can you provide few information on this solution ?

where do I add the messages in the database (lot of different tables in there), and how I tell mailserver to send them ?

I did made a addon a few years ago in php_cli that clean mails in the database that are not on disk anymore (like fantom ones) ....

Stéphane

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: orphan mails in 5.3.4-B1913

Post by ^DooM^ » 2012-06-22 14:45

not off the top of my head. I suggest you send an email to another server and track it through the database. Enable all logging to help you. Then you will see what is added to where.
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

Bill48105
Developer
Developer
Posts: 6192
Joined: 2010-04-24 23:16
Location: Michigan, USA

Re: orphan mails in 5.3.4-B1913

Post by Bill48105 » 2012-06-22 16:06

sbouli wrote:
^DooM^ wrote:re-add them to the database and have the mailserver send them out
can you provide few information on this solution ?

where do I add the messages in the database (lot of different tables in there), and how I tell mailserver to send them ?

I did made a addon a few years ago in php_cli that clean mails in the database that are not on disk anymore (like fantom ones) ....

Stéphane
If you want to add message to user folder or send from script best to use COM API, you can do both cleanly/safely from there.
Bill
hMailServer build LIVE on my servers: 5.4-B2014050402
#hmailserver on FreeNode IRC https://webchat.freenode.net/?channels=#hmailserver
*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***

Post Reply