Page 1 of 1

sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 01:06
by charleso
Please each time i do a windows update on my 2016 windows server, every 2-3 months , i run into one sql server connection error on Hmailserver on another.

This is the latest error:

Code: Select all

ADO [DBNETLIB][ConnectionRead (recv()).]General network error.
Please is there anything i can do to fix this. my mail server has been down for hours.

Thanks.

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 02:01
by mattg
Is your SQL server on another machine?
Which database do you use?
Please show the contents of your hmailserver.ini file with passwords removed

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 02:19
by charleso
IT's all on the same machine.

SQL Server 2017 standard

Code: Select all

[Directories]
ProgramFolder=C:\Program Files (x86)\hMailServer
DatabaseFolder=C:\Program Files (x86)\hMailServer\Database
DataFolder=C:\Program Files (x86)\hMailServer\Data
LogFolder=C:\Program Files (x86)\hMailServer\Logs
TempFolder=C:\Program Files (x86)\hMailServer\Temp
EventFolder=C:\Program Files (x86)\hMailServer\Events
[GUILanguages]
ValidLanguages=english,swedish
[Security]
AdministratorPassword=XXX
[Database]
Type=MSSQL
Username=sa
Password=XXX
PasswordEncryption=1
Port=0
Server=.
Database=mailserver
Internal=0
[Settings]
DisableAUTHList=25
; Setting DisableAUTHList allows you to specify a comma-separated list of SMTP ports which authentication should not be enabled for.
; This is useful when working with legacy systems with malfunctioning SMTP support.
This is the config i have been using for several months. It's just after today's windows update which included Security Update for SQL Server 2017 (KB4494351), that this error started on restarting the machine

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 09:32
by charleso
SOLVED:

simply upgraded to a newer version of HmailServer

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 10:35
by charleso
wow, now i restart and get this:
hm.png
Please any help?

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 12:02
by jimimaseye
Perhaps you should review the detail behind the windows update KB4494351 (that caused you the problem). Maybe there are new features/securities in place that you need to work through. Also, check the database is available (port, name, etc). After all, Hmailserver is merely trying to connect to a database that you have told it to and something is stopping it from doing so. (Is it there? Available? TLS required?)

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 12:13
by charleso
jimimaseye wrote:
2019-06-20 12:02
Perhaps you should review the detail behind the windows update KB4494351 (that caused you the problem). Maybe there are new features/securities in place that you need to work through. Also, check the database is available (port, name, etc). After all, Hmailserver is merely trying to connect to a database that you have told it to and something is stopping it from doing so. (Is it there? Available? TLS required?)
The SQL server works fine, i can even access it remotely. Other applications accessing the same sql server have no issues, just hMailServer fails ... even after successfully upgrading to the laters version this morning

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 12:18
by jimimaseye
charleso wrote:
2019-06-20 12:13
The SQL server works fine, i can even access it remotely. Other applications accessing the same sql server have no issues, just hMailServer fails ... even after successfully upgrading to the laters version this morning
Upgrading HMS will not make a difference. You have a configuration issue that has been introduced by that last Windows Update. HMS will only try to connect according to how it, and the machine it runs on, has been configured.

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 12:20
by charleso
I installed the updated hmailserver this morning, and it all worked fine.

I restarted the server , and now i have this issue.

I have not changed any configs.

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 12:28
by Dravion
The Database is not ready or reachable as hMailServer
at this point time. Durnibg Setup, make sure you selected the MSSQL Service as Dependency.

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 12:30
by jimimaseye
charleso wrote:
2019-06-20 12:20

I have not changed any configs.
....and you didnt change HMS either.

But you HAVE changed the machine setup (by doing a reboot). Services stop and should restart (but maybe dont). Dependancies change. As Dravion says, check the service dependancies.

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 12:36
by charleso
steps:

1) restarted the server
2) ensure MSSQLSERVER service is running
3) ensure i can connect / access the sql server remotely from my laptop
4) then i remote into the server and try to start hMailServer Asministrator

I then get the error:

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 12:51
by jimimaseye
Dravion wrote:
2019-06-20 12:28
Durnibg Setup, make sure you selected the MSSQL Service as Dependency.
Run "DBSetup".......

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 13:00
by charleso
jimimaseye wrote:
2019-06-20 12:51
Dravion wrote:
2019-06-20 12:28
Durnibg Setup, make sure you selected the MSSQL Service as Dependency.
Run "DBSetup".......
WOW it works now. God Bless!

... but let me restart the server and see if the problem comes again

Re: sql errors for hmailserver after each windows update and restart

Posted: 2019-06-20 13:16
by charleso
Restarted successfully!. Thanks again