sql errors for hmailserver after each windows update and restart

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

sql errors for hmailserver after each windows update and restart

Post by charleso » 2019-06-20 01:06

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.

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

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

Post by mattg » 2019-06-20 02:01

Is your SQL server on another machine?
Which database do you use?
Please show the contents of your hmailserver.ini file with passwords removed
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: sql errors for hmailserver after each windows update and restart

Post by charleso » 2019-06-20 02:19

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

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

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

Post by charleso » 2019-06-20 09:32

SOLVED:

simply upgraded to a newer version of HmailServer

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

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

Post by charleso » 2019-06-20 10:35

wow, now i restart and get this:
hm.png
Please any help?

User avatar
jimimaseye
Moderator
Moderator
Posts: 7953
Joined: 2011-09-08 17:48

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

Post by jimimaseye » 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?)
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

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

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

Post by charleso » 2019-06-20 12:13

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

User avatar
jimimaseye
Moderator
Moderator
Posts: 7953
Joined: 2011-09-08 17:48

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

Post by jimimaseye » 2019-06-20 12:18

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.
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

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

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

Post by charleso » 2019-06-20 12:20

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.

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

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

Post by Dravion » 2019-06-20 12:28

The Database is not ready or reachable as hMailServer
at this point time. Durnibg Setup, make sure you selected the MSSQL Service as Dependency.
64-Bit builds of hMailserver

hMailServer-5.6.+ (HCD) https://github.com/hMailServer-ComDevs/hmailserver
hMailServer-5.6.+ (LTS) https://github.com/Dravion/hMailServer/releases

User avatar
jimimaseye
Moderator
Moderator
Posts: 7953
Joined: 2011-09-08 17:48

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

Post by jimimaseye » 2019-06-20 12:30

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.
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

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

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

Post by charleso » 2019-06-20 12:36

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:
Attachments
hm.png

User avatar
jimimaseye
Moderator
Moderator
Posts: 7953
Joined: 2011-09-08 17:48

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

Post by jimimaseye » 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".......
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

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

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

Post by charleso » 2019-06-20 13:00

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

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

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

Post by charleso » 2019-06-20 13:16

Restarted successfully!. Thanks again

Post Reply