This section contains user-submitted tutorials.
-
jimimaseye
- Moderator
- Posts: 10053
- Joined: 2011-09-08 17:48
Post
by jimimaseye » 2022-03-25 15:42
The internal Database does not come with any tools that allows view/interogation or update of the tables within. Access to the internal database would require extra 3rd party software. I have used
DatabaseBrowserPortable (original found
here).
To access the internal database using
DatabaseBrowserPortable you wll need the database password:
- a, open your HMAILSERVER.INI file and select the 'password' string under
[Database]
Password=a2bd344fc6608264d2d6b3ca2f89303
b, Run hmailsever/Addons/Utilities/DecryptBlowfish.vbs and where prompted enter the string copied. This will create and display a short string of characters (this is the password). Copy this string of characters.
c, Run DatabaseBrowserPortable, and choose 'Connections - Add' and point to your internal Data directory database (remember to choose MSSQL CE as database type). Enter "Hmailserver" as the User name and the above decrypted string as the password.
Done.
(If you want the benefit of easy access to Administration of the database in the future, you might also consider upgrading to an external database - see
here for a guide)
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
-
Dravion
- Senior user
- Posts: 2071
- Joined: 2015-09-26 11:50
- Location: Germany
-
Contact:
Post
by Dravion » 2022-03-25 18:38
Good Job!
-
glenluo
- Senior user
- Posts: 350
- Joined: 2011-07-03 12:10
Post
by glenluo » 2022-03-27 07:39
Thanks,it is really a good software.
-
Dravion
- Senior user
- Posts: 2071
- Joined: 2015-09-26 11:50
- Location: Germany
-
Contact:
Post
by Dravion » 2022-03-28 16:16
glenluo wrote: ↑2022-03-27 07:39
Thanks,it is really a good software.
I want add this Program, it servers me well in working with SQL CE Databases and is still somewhat up to date
https://github.com/christianhelle/sqlcequery/releases
PS: If you want to open the hmailServer SDF file, please make sure you start your tool as Admin and hMailServer Service is stopped
or the file is locked
-
glenluo
- Senior user
- Posts: 350
- Joined: 2011-07-03 12:10
Post
by glenluo » 2022-03-30 15:02
Dravion wrote: ↑2022-03-28 16:16
glenluo wrote: ↑2022-03-27 07:39
Thanks,it is really a good software.
I want add this Program, it servers me well in working with SQL CE Databases and is still somewhat up to date
https://github.com/christianhelle/sqlcequery/releases
PS: If you want to open the hmailServer SDF file, please make sure you start your tool as Admin and hMailServer Service is stopped
or the file is locked
TKS