[Mass mailing] manages the SQL Server ce database of hmailserver

If your hmailserver uses SQL Server or MySQL, the Enterprise Manager and phpMyAdmin of SQL Server can easily solve the problem. What if you use the SQL Server compact edition database built in hmailserver? How can I query the data in it?

First, you have to install a management studio of SQL Server 2008. The free Express version is enough. After trying it out, the 2005 version is unavailable and available on the Microsoft website, after installation, run SQL Server Management studio. Select SQL Server compact edition for the server type, and select hmailserver for the database file. well, what is the last one, password, and password? I tried the hmailserver system management password. It is wrong. What is the database connection password?

 

 

Open the bin directory under the hmailserver installation directory and find the hmailserver. open the INI file. There is a password in the [database] field, copy the string after =, and open the Addons \ utilities directory in the hmailserver installation directory, which contains several vbs files, double-click decryptblowfish. vbs, of course, the prerequisite for running is that you have not disabled the system script running and run decryptblowfish. vbs first prompts you to enter the administrator password, and then prompts you to enter the encrypted password. Just the string you copied. A string of characters is displayed in the last dialog box. copy it, that character is the database connection password.

Then you can manage your database. You can also click "create query" and create a simple query statement select count (accountid) from hm_accounts to query the number of users you have.