Database version: 5700, Required database version: 5601

[charleso]

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?

[mattg]

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

[charleso]

MSSQL Server 2017

I have Local Admin Access on that machine.

I'll try the service on Local Admin.

[mattg]

What user was the hMailserver service running under?

[charleso]

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

[mattg]

https://www.hmailserver.com/documentati ... ermissions

Check your dcom permission

[charleso]

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

[mattg]

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

[Dravion]

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.