Hmm so yours is likely newer. Either microsoft broke something in newer version or that is not it.

Btw my rough method of rebuilding file paths was:Need to grab messageacccountid from hm_messages & lookup their account & domain from hm_accounts using that then update messagefilename in hm_messages to prepend DatafolderPath\theirdomain\theiraccount\originalfilename.eml & repeat for every message in hm_messages likely only doing ones that have messagetype = 2 which means delivered

In either case I'd have backups of your database & realize it is very risky.. I'd certainly test on a test server 1st. once paths are fixed (view some ot make sure they look right) then the other changes between 5.3.x & 5.4 shouldn't matter or are less critical. I thought I posted them up but you can view the upgrade SQL file in the DBScripts folder inside the hmail folder. You definitely need to manually change the db version value though. Then you should be able to install 5.3.4 over 5.4, select your existing database & cross your fingers. (Again I'd do trial runs on test server, even if using backups from your real server..)

Once im able to finish him i will post here...indeed, i will stop hmail and make a full backup including sql dump then i will rollback and if anything goes wrong at least im able to get 5.4 ready to rock again...

FiShBuRn wrote:Once im able to finish him i will post here...indeed, i will stop hmail and make a full backup including sql dump then i will rollback and if anything goes wrong at least im able to get 5.4 ready to rock again...

When u say "manually change db version" is to 5320 value right?

You'd match whatever version you were planning to install.

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

OK cool just checking cuz obviously could get VERY ugly if you muck up your database. Btw you test on a copy/dump of your actual database just to be sure? In case there is something odd about your database..

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

Bill48105 wrote:OK cool just checking cuz obviously could get VERY ugly if you muck up your database. Btw you test on a copy/dump of your actual database just to be sure? In case there is something odd about your database..

yeap, my tests were made on an actual database. Before do anything later i will backup every thing so if got any error for sure i can return to 5.4.

FiShBuRn wrote:yeap, my tests were made on an actual database. Before do anything later i will backup every thing so if got any error for sure i can return to 5.4.

ok cool so if you did tests on copy of actual database did you also try changing db version value & installing 5.3.4 to see if it actually works?

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

FiShBuRn wrote:I loved to test that sitation but i cant :/ lets hope that will be not a problem...

Why not? Copy (dump) database over & test as if that was your live server.

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

FiShBuRn wrote:Ok Bill, full test made, all went OK, installed hmailserver, copy Data folder, db dump, just fine and then checked some email and OK

Lets hope it run just fine in the main server.

Ok cool. You missed the change db versions, run your path update and install 5.3.4 but assuming you did those things great news! Not only for you but for anyone else scared to upgrade due to no (easy/trusted) downgrade path.

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

FiShBuRn wrote:Ok Bill, full test made, all went OK, installed hmailserver, copy Data folder, db dump, just fine and then checked some email and OK

Lets hope it run just fine in the main server.

Ok cool. You missed the change db versions, run your path update and install 5.3.4 but assuming you did those things great news! Not only for you but for anyone else scared to upgrade due to no (easy/trusted) downgrade path.

Nah, i had to change db version if i didnt change hmail cant inicialize DB and path update to ofcourse.

Way cool, thanks for the info! So that means you downgraded your actual server or just test server so far?Bill

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

FiShBuRn wrote:Just test server so far...later tonight i will downgrade main server...and post back the results.

Ahh ok cool.Btw, was thinking. Should a test be put in to to NOT update paths that have \ in the name or perhaps don't start with { just to be safe? (Would be REAL ugly to run that update on full paths!!)

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

If that works then suppose yeah! Obviously someone else looking to use that would need to change the Data dir path but hopefully that'd be obvious. lol

Btw what is "caminho" in there?ThxBill

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

It works fine, indeed, main server is downgraded OK now lets pray that it doesnt crash!

"caminho" could have whatever name you want, its a name for a column in case you need to call that select...in this case its no needed but...

OK cool! Yeah let's see if it works ok then we might know if it is 5.4/2k issue or such.

So caminho is a temp table name you made up? I'm asking in case someone else needs to downgrade we know the steps to provide.ThxBill

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

FiShBuRn wrote:Its not need to create, its like a temp collumn for that query...but like i said its not needed for this job but it doesnt hurt either

Sure, the only thing that need to be changed is the path to hmailserver Data folder, after that is ready to GO.

Ok cool I'll have to give it a try myself. Be good to have a working downgrade process to help minimize reluctance to try out 5.4 so thanks for the efforts! Since this thread is soooo long now & the info is all scattered in many posts might make sense to start a new one with 1st post being step by step how to downgrade. Feel free to create that if you have time since you are the pro on downgrade now. Thx!Bill

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

FiShBuRn wrote:Its not need to create, its like a temp collumn for that query...but like i said its not needed for this job but it doesnt hurt either

Sure, the only thing that need to be changed is the path to hmailserver Data folder, after that is ready to GO.

Ok cool I'll have to give it a try myself. Be good to have a working downgrade process to help minimize reluctance to try out 5.4 so thanks for the efforts! Since this thread is soooo long now & the info is all scattered in many posts might make sense to start a new one with 1st post being step by step how to downgrade. Feel free to create that if you have time since you are the pro on downgrade now. Thx!Bill

I will do that when i come back from vacations hope hmail doesnt crash so i can have good time

Thanks for you share but i my case hmail has running just fine with earlier releases only with 5.4 i had problems...if i want to use it, yeah i need to upgrade

regards

I think he was pointing out there are issues with windows 2k, even with prior versions of hmail not just with 5.4. You might have been lucky before. Anyway, if you happen to have issues after downgrading at least it helps you realize what you need to do.Bill

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

I will note that someone doing it should edit the paths in the query though. Besides the fact it appears you are running an international or non-english version of windows some people might not install into the default folder or might end up in C:\Program Files (x86) even on 64bit windows.

Thx!Bill

*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***hMailServer build LIVE on my servers: 5.4-B2014050402Latest test builds: http://www.hmailserver.com/forum/viewtopic.php?f=10&t=21420

I will note that someone doing it should edit the paths in the query though. Besides the fact it appears you are running an international or non-english version of windows some people might not install into the default folder or might end up in C:\Program Files (x86) even on 64bit windows.

Thx!Bill

Indeed, it should be highlighted so people could change that. Yes im running a Portuguese version of windows

Yesterday at 8.50am I started getting calls from users saying that they were getting mail errors. On checking hMailServer logs I was seeing HM4316.

To cut a long story short I also was running hMailServer 5.4 on Win 2000 on two servers in two distant locations but had upgraded a number of weeks ago and the issue just started yesterday ON BOTH SERVERS WITHIN MINUTES OF EACH OTHER.

Swapping out the HDD in order to keep files etc I installed Windows XP (I don't have a copy of later server versions yet but will do the job again when I do) before rebuilding everything on it. I restored the latest backup, copied certificates back in etc, and all is well again.

However, I still don't know what caused it and couldn't try anything because everytime I logged into hMailAdmin the server crashed and kicked me out. By the time I had logged in again it crashed and kicked me out so I couldn't troubleshoot any settings.

Anyway - thanks for the info in this thread everyone. Gotta drive over to the other server this morning and do the same job there