Comodo Help
Find the desired product help
Xcitium Secure Email Gateway Enterprise

Xcitium Secure Email Gateway Enterprise

Admin Guide Version 6.7

English

Print Help Download Help
SMTP Configuration > LDAP/Local DB/My SQL User Database > My SQL User Database
  • Introduction To Comodo Secure Email Gateway
    • Login To The Secure Email Gateway Module
    • Get Started
      • Cloud Customers
      • On-premise Customers
    • The Main Interface
  • The Dashboard
    • System Usage Graphics
    • About Software
  • System Configurations
    • Services
    • Licenses
    • Configure System Settings
      • System General Settings
      • Cache Settings
      • Session Settings
      • GUI Customization
      • System Backup
      • System Restore
      • Log Upload Settings
      • Postmaster Settings
      • Web UI SSL
      • SMTP TLS Settings
      • Update Database
      • Syslog Server
    • Logs
      • Log Files
      • Purge Files
    • Tools
      • Check Connectivity
      • Clear SMTP Queue
    • Session Reports
    • System Usage Statistics
  • SMTP Configuration
    • SMTP (Send E-Mail Protocol) Settings
      • General Settings
      • Advanced Settings
      • Outbound Delivery Queue
    • Manage Domains
      • Manage Domain Names
      • Manage Domain Routes
      • Manage Smart Hosts
      • Default Domain Routing
    • Secure Email Gateway SMTP AUTH Connector
      • SMTP Authentication Settings
      • Block Users
      • Anomaly Detection
    • LDAP/Local DB/My SQL User Database
      • LDAP Profile
      • Local DB Users
      • My SQL User Database
    • Greylist
      • Greylist Ignored IP Addresses/Domains
    • Manage RBL Servers
    • Disclaimer
    • SMPT Relay
    • DomainKeys Identified Mail (DKIM)
    • Outgoing SMTP Limits
    • Incoming SMTP Limits
  • Modules
    • Anti-spam
      • Anti-spam General Settings
      • Authorized Trainers
      • Advanced Anti-spam Settings
      • Bayesian Training
      • Content Filter
      • Signature Whitelist
      • Attachment Filter
    • Anti-Virus
      • Anti-Virus General Settings
      • Advanced Anti-Virus Settings
    • Korumail Reputation Network (KRN)
    • Anti-Spoofing
    • SMTP IPS/FW
      • SMTP IPS General Settings
      • Whitelist IP Addresses
      • Blocked IP Addresses
      • Rate Control
    • Auto Whitelist
    • Containment System
    • Data Leak Prevention (DLP)
    • Attachment Verdict System
  • Profile Management
    • Add And Configure A New Profile
      • Edit A Profile
      • Delete A Profile
  • Reports
    • Mail Logs Report
    • SMTP Queue Report
    • Delivery Logs Report
    • SMTP-AUTH Logs Report
    • Summary Reports
    • Domain Reports
    • Attachment Verdict Reports
    • Original Mail Request
  • Quarantine & Archive
    • Quarantine & Archive Settings
      • Quarantine & Archive General Settings
      • Email Reports Settings
      • Admin E-mail Reports Settings
    • Quarantine Logs
    • Archived Mails
  • About Comodo Security Solutions

My SQL User Database


  • Secure Email Gateway 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 at the SMTP level. Since the filtering process is not engaged for invalid recipients, Secure Email Gateway's resources are not wasted.
  • The 'MySQL User Database profiles' added here are available for selection in interfaces such as 'Manage Domains > Routes'. 
    • To open the 'MySQL User Database' screen,
    • Click the 'SMTP' tab on the left menu
    • Click 'SMTP' > 'LDAP/DB' > '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 Secure Email Gateway.

      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 Secure Email Gateway connects to.

      Database

      The name of the 'MySQL User Database'.

      SQL Clause

      The 'SQL clause' used to fetch the users' details.

      Action



      Allows you to edit the details of the 'MySQL' profile.

      Allows you to delete a 'MySQL' profile from the list.


      From this screen administrators can:

      • Add a new MySQL profile
      • Edit a MySQL profile
      • Delete a MySQL profile


      Add a new MySQL profile

      • 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 Secure Email Gateway 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.


      Edit a MySQL profile

      • 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 'Save' to apply your changes.


      Delete a MySQL profile

      • Click the delete button  beside a 'MySQL' profile that you want to remove.




      • Click 'OK' to confirm the deletion.

      Our Products
      • Free Antivirus
      • Free Internet Security
      • Website Malware Removal
      • Free Anti-Malware
      • Anti-Spam (Free Trial)
      • Windows Antivirus
      • Antivirus for Windows 7
      • Antivirus for Windows 8
      • Antivirus for Windows 10
      • Antivirus for MAC
      • Antivirus for Linux
      • Free Endpoint Security
      • Free ModSecurity
      • Free RMM
      • Free Website Malware Scanner
      • Free Device Manager for Android
      • Free Demo
      • Network Security
      • Endpoint Protection
      • Antivirus for Android
      • Comodo Antivirus
      • Wordpress Security
      Cheap CDN
      • Bootstrap CDN
      • Semantic UI CDN
      • Jquery CDN
      • CDN Plans
      • CDN
      • Free CDN
      Enterprise
      • Patch Management Software
      • Patch Manager
      • Service Desk
      • Website Down
      • Endpoint Protection Solutions
      • Website Security Check
      • Remote Monitoring and Management
      • Website Security
      • Device Manager
      • ITSM
      • CRM
      • MSP
      • Android Device Manager
      • MDR Services
      • Managed IT Support Services
      • Free EDR
      Free SSL Certificate
      Support Partners Terms and Conditions Privacy Policy

      © Comodo Group, Inc. 2025. All rights reserved.