{"id":7823,"date":"2018-03-09T17:35:55","date_gmt":"2018-03-09T17:35:55","guid":{"rendered":"http:\/\/evolphin.com\/help\/?p=7823"},"modified":"2018-03-09T17:35:55","modified_gmt":"2018-03-09T17:35:55","slug":"setup-mysql-for-process-reporting-with-videolx","status":"publish","type":"post","link":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/","title":{"rendered":"Setup MySQL for process reporting"},"content":{"rendered":"

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:<\/p>\n

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

    \"\"<\/p>\n<\/li>\n

  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.<\/li>\n<\/ol>\n
    Provision periodic backups of data present on your SQL server.<\/span><\/div>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    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 […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[4],"tags":[156],"class_list":["post-7823","post","type-post","status-publish","format-standard","hentry","category-guides","tag-videolx"],"yoast_head":"\nSetup MySQL for process reporting - Evolphin Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setup MySQL for process reporting - Evolphin Documentation\" \/>\n<meta property=\"og:description\" content=\"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 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/\" \/>\n<meta property=\"og:site_name\" content=\"Evolphin Documentation\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-09T17:35:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2018\/03\/img_5ab8d6fd4c8fb.png\" \/>\n<meta name=\"author\" content=\"Rahul Bhargava\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rahul Bhargava\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/\"},\"author\":{\"name\":\"Rahul Bhargava\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#\\\/schema\\\/person\\\/e5f3dc53ac5f026ed258e224e75447f7\"},\"headline\":\"Setup MySQL for process reporting\",\"datePublished\":\"2018-03-09T17:35:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/\"},\"wordCount\":318,\"publisher\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/evolphin.com\\\/help\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/img_5ab8d6fd4c8fb.png\",\"keywords\":[\"VideoLX\"],\"articleSection\":[\"Guides\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/\",\"url\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/\",\"name\":\"Setup MySQL for process reporting - Evolphin Documentation\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/evolphin.com\\\/help\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/img_5ab8d6fd4c8fb.png\",\"datePublished\":\"2018-03-09T17:35:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/#primaryimage\",\"url\":\"https:\\\/\\\/evolphin.com\\\/help\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/img_5ab8d6fd4c8fb.png\",\"contentUrl\":\"https:\\\/\\\/evolphin.com\\\/help\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/img_5ab8d6fd4c8fb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/deployment\\\/guides\\\/setup-mysql-for-process-reporting-with-videolx\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/evolphin.com\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setup MySQL for process reporting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/evolphin.com\\\/help\\\/\",\"name\":\"Evolphin Documentation\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/evolphin.com\\\/help\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#organization\",\"name\":\"Evolphin Documentation\",\"url\":\"https:\\\/\\\/evolphin.com\\\/help\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/evolphin.com\\\/help\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/cropped-evolphin-logo-dolphin_sm.png\",\"contentUrl\":\"https:\\\/\\\/evolphin.com\\\/help\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/cropped-evolphin-logo-dolphin_sm.png\",\"width\":200,\"height\":200,\"caption\":\"Evolphin Documentation\"},\"image\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#\\\/schema\\\/person\\\/e5f3dc53ac5f026ed258e224e75447f7\",\"name\":\"Rahul Bhargava\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g\",\"caption\":\"Rahul Bhargava\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setup MySQL for process reporting - Evolphin Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/","og_locale":"en_US","og_type":"article","og_title":"Setup MySQL for process reporting - Evolphin Documentation","og_description":"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 […]","og_url":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/","og_site_name":"Evolphin Documentation","article_published_time":"2018-03-09T17:35:55+00:00","og_image":[{"url":"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2018\/03\/img_5ab8d6fd4c8fb.png","type":"","width":"","height":""}],"author":"Rahul Bhargava","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rahul Bhargava","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/#article","isPartOf":{"@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/"},"author":{"name":"Rahul Bhargava","@id":"https:\/\/evolphin.com\/help\/#\/schema\/person\/e5f3dc53ac5f026ed258e224e75447f7"},"headline":"Setup MySQL for process reporting","datePublished":"2018-03-09T17:35:55+00:00","mainEntityOfPage":{"@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/"},"wordCount":318,"publisher":{"@id":"https:\/\/evolphin.com\/help\/#organization"},"image":{"@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/#primaryimage"},"thumbnailUrl":"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2018\/03\/img_5ab8d6fd4c8fb.png","keywords":["VideoLX"],"articleSection":["Guides"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/","url":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/","name":"Setup MySQL for process reporting - Evolphin Documentation","isPartOf":{"@id":"https:\/\/evolphin.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/#primaryimage"},"image":{"@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/#primaryimage"},"thumbnailUrl":"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2018\/03\/img_5ab8d6fd4c8fb.png","datePublished":"2018-03-09T17:35:55+00:00","breadcrumb":{"@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/#primaryimage","url":"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2018\/03\/img_5ab8d6fd4c8fb.png","contentUrl":"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2018\/03\/img_5ab8d6fd4c8fb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/evolphin.com\/help\/deployment\/guides\/setup-mysql-for-process-reporting-with-videolx\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/evolphin.com\/help\/"},{"@type":"ListItem","position":2,"name":"Setup MySQL for process reporting"}]},{"@type":"WebSite","@id":"https:\/\/evolphin.com\/help\/#website","url":"https:\/\/evolphin.com\/help\/","name":"Evolphin Documentation","description":"","publisher":{"@id":"https:\/\/evolphin.com\/help\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/evolphin.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/evolphin.com\/help\/#organization","name":"Evolphin Documentation","url":"https:\/\/evolphin.com\/help\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/evolphin.com\/help\/#\/schema\/logo\/image\/","url":"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2020\/04\/cropped-evolphin-logo-dolphin_sm.png","contentUrl":"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2020\/04\/cropped-evolphin-logo-dolphin_sm.png","width":200,"height":200,"caption":"Evolphin Documentation"},"image":{"@id":"https:\/\/evolphin.com\/help\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/evolphin.com\/help\/#\/schema\/person\/e5f3dc53ac5f026ed258e224e75447f7","name":"Rahul Bhargava","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g","caption":"Rahul Bhargava"}}]}},"_links":{"self":[{"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/posts\/7823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/comments?post=7823"}],"version-history":[{"count":0,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/posts\/7823\/revisions"}],"wp:attachment":[{"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/media?parent=7823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/categories?post=7823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/tags?post=7823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}