My SQL User Database
- KoruMail is capable of verifying the validity of users by referring to a 'MySQL User Database' located on a remote server.
- If the recipient is not a valid user then email is rejected in SMTP level. Since the sophisticated filtering process is not used for invalid recipients, KoruMail's resources are not wasted.
- The 'MySQL User Database profiles' added here are available for selection in interfaces such as 'Managed Domains > Routes'.
- To open the 'MySQL User Database' screen, click the 'SMTP' tab on the left menu and click 'LDAP/DB' then 'MySQL User Database'.
MySQL User Database Profile – Table of Column Descriptions |
||
---|---|---|
Column Header |
Description |
|
Profile Name |
The name of the MySQL User Database profile added to KoruMail. |
|
Host Name or IP Address |
Displays the address of the system where the 'MySQL User Database' is located. |
|
Port |
Displays the port number to which KoruMail connects to. |
|
Database |
The name of the 'MySQL User Database'. |
|
SQL Clause |
The 'SQL clause' used to fetch the users' details. |
|
Action |
|
Allows the administrators to edit the details of a 'MySQL' profile. |
|
Allows the administrators to delete a 'MySQL' profile from the list. |
From this screen administrators can:
- Click 'Add MySQL User Database' link at the top of the screen.
The 'New MySQL User Database' screen will be displayed.
MySQL User Database Profile -Table of Parameters |
|
---|---|
Parameter |
Description |
Profile Name |
Enter the name of the MySQL profile. |
Host Name or IP Address |
Enter the hostname or IP address of the system where MySQL database is located. |
Port |
Enter the port number to which KoruMail should connect to. |
Search Type |
Select the type of search from the drop-down.
The options available are: Realtime – Checks the MySQL server each time for user validity. Cache – Checks the user validity from the system's cache memory and if not available checks the MYSQL server. |
Cache Time (minutes) |
If the 'Cache' option is enabled as 'Search Type', this field becomes active. Enter the time in minutes the details of users are cached after which they are wiped out. |
Database |
Enter the MySQL database name. |
Username |
The username to access the MySQL server. |
Password |
Enter the password to access the MySQL server. |
SQL Clause |
The SQL clause to fetch the users' details. |
Check Local DB Users Also |
Checks for users in Local Data base users list as well. |
E-Mail address for testing |
Enter the email address to test the MySQL database connection. |
- Click the 'Verify' button to check the entered parameters and connectivity are correct. If verification fails, the error message will be displayed.
- Click the 'Save' button to apply your changes.
-
Click the button beside a 'MySQL' profile that you want to edit.
- Edit the required parameters. This is similar to the method explained in the 'Add' section.
- Click the 'Save' button to apply your changes.
-
Click the delete button beside a 'MySQL' profile that you want to remove.
- Click 'OK' to confirm the deletion.