Setup MySQL for process reporting

When using VideoLX or VideoFX 3.0 +, Zoom process reporting in the Web Management Console can write data to a SQL server. This data will be fetched to display reports inside the Web Management Console about transcoding jobs. The SQL Server is also used for some other modules within Zoom. To save SQL database details in Zoom, follow the instructions given below:

1. If your SQL Server is not installed, then download your OS-specific installer from https://dev.mysql.com/downloads/installer/
2. Run the installer and follow the instructions.
3. After installation, create a MySQL user for use with Zoom.
   Do not use the root account to configure the access from Zoom services. Always create a dedicated account for use with Zoom.
4. Configure the SQL user to allow remote connections. By default, MySQL server only allows access from the localhost.
5. For Zoom versions up to 7.2, download the MySQL script file from here. Save this text file as ZoomScript.sql. Create a database and associated tables using this ZoomScript.sql and the user that was created previously. For example, using the MySQL CLI:
   mysql --host=yourdatabase-hostname-or-ip -u evolphin -pYourpasword < ZoomScript.sql
   You do not need to download and run this script from Zoom 7.3 onwards.
6. Save the user information and the location of the SQL database for use in the Web Management Console.
7. Log in to the Web Management Console of your Zoom Server. Go to Server Control Panel in the System node of the Admin Menu sidebar.
8. Click on SQL Server to open SQL Server settings. Specify username, password, and database location and click Save.

   

9. If the settings are valid then Zoom will be able to connect to the SQL Server. The settings will also be saved successfully. If the Zoom Server is not able to connect to the SQL Server then the settings will not be saved. Enter the correct settings and try again.