HOW TO: Accessing the INTERNAL Database tables

This section contains user-submitted tutorials.
Post Reply
User avatar
jimimaseye
Moderator
Moderator
Posts: 10053
Joined: 2011-09-08 17:48

HOW TO: Accessing the INTERNAL Database tables

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

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

Re: HOW TO: Accessing the INTERNAL Database tables

Post by Dravion » 2022-03-25 18:38

Good Job!

glenluo
Senior user
Senior user
Posts: 350
Joined: 2011-07-03 12:10

Re: HOW TO: Accessing the INTERNAL Database tables

Post by glenluo » 2022-03-27 07:39

Thanks,it is really a good software.

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

Re: HOW TO: Accessing the INTERNAL Database tables

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
Senior user
Posts: 350
Joined: 2011-07-03 12:10

Re: HOW TO: Accessing the INTERNAL Database tables

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

Post Reply