Database version: 5700, Required database version: 5601

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
charleso
Normal user
Normal user
Posts: 32
Joined: 2016-09-22 15:45

Database version: 5700, Required database version: 5601

Post by charleso » 2019-01-28 03:21

After battling with this error for long:

[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

I followed the steps and advice from here viewtopic.php?t=33269#p207910
and upgraded to this version: download/file.php?id=4203

The initial Error is gone. I can now log into hMailAdmin, and i see my domains listed.

On clicking Status, i get the following erorr:

Code: Select all

An error occurred processing the request.

ExceptionType: COMException
HelpLine: 
Message: An error occurred processing the request.
Source: hMailServer COM library
StackTrace:    at hMailServer.SettingsClass.get_HostName()
   at hMailServer.Administrator.ucStatus.DisplayWarnings()
   at hMailServer.Administrator.ucStatus.LoadData()
   at hMailServer.Administrator.formMain.ShowNodeRepresentation(INode node)
   at hMailServer.Administrator.formMain.treeNodes_AfterSelect(Object sender, TreeViewEventArgs e)
   at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)
   at System.Windows.Forms.TreeView.WmNotify(Message& m)
   at System.Windows.Forms.TreeView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
TargetSite: System.String get_HostName()
Also on clicking Settings > Advanced i now get this:

Code: Select all

You do not have access to this property / method. Ensure that hMailServer.Application.Authenticate() is called with proper login credentials.

ExceptionType: COMException
HelpLine: 
Message: You do not have access to this property / method. Ensure that hMailServer.Application.Authenticate() is called with proper login credentials.
Source: hMailServer COM library
StackTrace:    at hMailServer.SSLCertificatesClass.get_Count()
   at hMailServer.Administrator.Nodes.NodeSSLCertificates.get_SubNodes()
   at hMailServer.Administrator.formMain.LoadNodeChildren(TreeNode node, Int32 recursionDepth)
   at hMailServer.Administrator.formMain.treeNodes_BeforeExpand(Object sender, TreeViewCancelEventArgs e)
   at System.Windows.Forms.TreeView.TvnExpanding(NMTREEVIEW* nmtv)
   at System.Windows.Forms.TreeView.WmNotify(Message& m)
   at System.Windows.Forms.TreeView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
TargetSite: Int32 get_Count()
hmailserver-webadmin (with errors: On) shows this:

Code: Select all

Severity: 1 (Critical), Code: HM5011, Source: Application::OnDatabaseConnected, Description: The database is too new for this version of hMailServer. Please upgrade hMailServer. Database version: 5700, Required database version: 5601
Please has anyone else tried the suggested fix for [DBNETLIB][ConnectionOpen (SECDoClientHandshake()) Error?
Are you experiencing any of these?

User avatar
mattg
Moderator
Moderator
Posts: 20221
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Database version: 5700, Required database version: 5601

Post by mattg » 2019-01-28 03:44

Which database are you using?

That error/ solution should be specific to the MS SQL database mentioned in that initial thread that you link to
The errors you are getting now look like DCOM errors, and could be caused by you running the hMailserver service as a non-standard user
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

charleso
Normal user
Normal user
Posts: 32
Joined: 2016-09-22 15:45

Re: Database version: 5700, Required database version: 5601

Post by charleso » 2019-01-28 04:18

MSSQL Server 2017

I have Local Admin Access on that machine.

I'll try the service on Local Admin.

User avatar
mattg
Moderator
Moderator
Posts: 20221
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Database version: 5700, Required database version: 5601

Post by mattg » 2019-01-28 07:18

What user was the hMailserver service running under?
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

charleso
Normal user
Normal user
Posts: 32
Joined: 2016-09-22 15:45

Re: Database version: 5700, Required database version: 5601

Post by charleso » 2019-01-28 10:26

Local system Account, I did not need to change it.

User avatar
mattg
Moderator
Moderator
Posts: 20221
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Database version: 5700, Required database version: 5601

Post by mattg » 2019-01-28 11:35

Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

charleso
Normal user
Normal user
Posts: 32
Joined: 2016-09-22 15:45

Re: Database version: 5700, Required database version: 5601

Post by charleso » 2019-01-28 12:09

i have downgraded back to 5601 (hMailServer version 5.6.7-B2425)

and re-enabled TLS 1.0 for peace of mind. That seems to be the only way out for now, sadly :(

User avatar
mattg
Moderator
Moderator
Posts: 20221
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Database version: 5700, Required database version: 5601

Post by mattg » 2019-01-29 00:55

Or you can use a different database type

The TLSv1.0 checkbox in hMailserver should NOT effect database connections, and should only impact on mail connections
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
Dravion
Senior user
Senior user
Posts: 1466
Joined: 2015-09-26 11:50
Location: Germany
Contact:

Re: Database version: 5700, Required database version: 5601

Post by Dravion » 2019-01-29 07:12

Hi,

Do you use the my hMailServer Patch for TLSv1.2 Support for MS-SQL Server which i attached for a other Support Case?

Anyhow.
The Error you receive haa to do with the Database Table hm_version. It has only 1 Fiield which is the Database version Number. As quick fix you can update it to 5700 but you should update again to 5601 before you apply an official hMailServer Update again.

Post Reply