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.
-
charleso
- Normal user

- Posts: 32
- Joined: 2016-09-22 15:45
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.
-
mattg
- Moderator

- Posts: 21267
- Joined: 2007-06-14 05:12
- Location: 'The Outback' Australia
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

- Posts: 32
- Joined: 2016-09-22 15:45
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

- Posts: 32
- Joined: 2016-09-22 15:45
Post
by charleso » 2019-06-20 09:32
SOLVED:
simply upgraded to a newer version of HmailServer
-
charleso
- Normal user

- Posts: 32
- Joined: 2016-09-22 15:45
Post
by charleso » 2019-06-20 10:35
wow, now i restart and get this:
Please any help?
-
jimimaseye
- Moderator

- Posts: 8917
- Joined: 2011-09-08 17:48
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?)
5.7 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

- Posts: 32
- Joined: 2016-09-22 15:45
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
-
jimimaseye
- Moderator

- Posts: 8917
- Joined: 2011-09-08 17:48
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.
5.7 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

- Posts: 32
- Joined: 2016-09-22 15:45
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.
-
Dravion
- Senior user

- Posts: 1688
- Joined: 2015-09-26 11:50
- Location: Germany
-
Contact:
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.
-
jimimaseye
- Moderator

- Posts: 8917
- Joined: 2011-09-08 17:48
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.
5.7 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

- Posts: 32
- Joined: 2016-09-22 15:45
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
-

-
jimimaseye
- Moderator

- Posts: 8917
- Joined: 2011-09-08 17:48
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".......
5.7 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

- Posts: 32
- Joined: 2016-09-22 15:45
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

- Posts: 32
- Joined: 2016-09-22 15:45
Post
by charleso » 2019-06-20 13:16
Restarted successfully!. Thanks again