FAQ

繁 | 簡 | GET A TRIAL | PURCHASE
   


FAQ Home 

Curtain e-locker
Installation Guide
User Guide 

Curtain LogTrace 

Curtain MonGuard

Website Product Page
Curtain e-locker
Curtain LogTrace
Curtain MonGuard 
 
FAQ No.:00369 
Category:Feature - Others 
 
Question:

How to change database type?

 
 
Answer:Curtain e-locker stores audit logs in a database. Currently supported database types include SQLite, MySQL, and Microsoft SQL Server. The default database type is SQLite.

Change to MySQL database type
1. Run Curtain e-locker admin, click "File > Settings > Database".

2. Select "MySQL" from the drop-down list of "Database Type".

e-locker data loss prevention (DLP) - Database Type

3. In the pop-up window, click the "Yes" button.

e-locker data loss prevention (DLP) - click the Yes

4. Enter the relevant information required for database connection, and then click the "Test Connection" button.
  • Server: Enter the IP address to identify the location of the database server
  • Port: The default port number of the MySQL database is 3306, which is used to specify the communication port of the database server
  • Username: The user name used to connect to the database, which requires permissions such as create, select, insert, and update.
  • Password: Enter the password to complete the connection

e-locker data loss prevention (DLP) - Test Connection

5. Click the "Test Connection" button and it will prompt "Connect successfully".

e-locker data loss prevention (DLP) - Connect successfully

6. Click the "Apply" button and select "Yes" or "No" in the pop-up window.

e-locker data loss prevention (DLP) - select Yes

6.1. If you select "Yes", the existing log data will be merged into the MySQL database. The time it takes to complete the merge depends on the size of the log file.

e-locker data loss prevention (DLP) - existing log data will be merged

6.2. If you select "No", the existing log data will not be merged.
Note: When the window of "Do you want to apply the settings to the following servers?" pops up, just click "No".

7. On the MySQL server, use the command "show databases" to view the database creation status.
The appearance of the curtain_adminlog, curtain_clientlog, and curtain_fileaudit database names indicates that the creation is successful.

e-locker data loss prevention (DLP) - show databases

Change to SQL Server database type
1. Run Curtain e-locker admin, click "File > Settings > Database".

2. Select "MySQL" from the drop-down list of "Database Type".

e-locker data loss prevention (DLP) - Database Type

3. In the pop-up window, click the "Yes" button.

e-locker data loss prevention (DLP) - Yes button

4. Enter the relevant information required for database connection, and then click the "Test Connection" button.
  • Server: Enter the IP address to identify the location of the database server
  • Port: The default port number of the SQL Server database is 1433, which is used to specify the communication port of the database server
  • Username: The user name used to connect to the database, which requires permissions such as create,read and write.
  • Password: Enter the password to complete the connection

e-locker data loss prevention (DLP) - Test Connection

5. Click the "Test Connection" button and it will prompt "Connect successfully".

e-locker data loss prevention (DLP) - Connect successfully

6. Click the "Apply" button and select "Yes" or "No" in the pop-up window.

e-locker data loss prevention (DLP) - Apply

6.1. If you select "Yes", the existing log data will be merged into the MySQL database. The time it takes to complete the merge depends on the size of the log file.

e-locker data loss prevention (DLP) - Merge SQLite to SQL Server

6.2. If you select "No", the existing log data will not be merged.
Note: When the window of "Do you want to apply the settings to the following servers?" pops up, just click "No".

7. Log in to the SQL Server management and check that database name of curtain_adminlog, curtain_clientlog, and curtain_fileaudit appears, indicating that the creation is successful.

e-locker data loss prevention (DLP) - the creation is successful

For related information, please refer to FAQ 00337 - Checklist before implementing Curtain e-locker