Product Documentation

To configure the MySQL service

Jun 05, 2015
Updated: 2013-05-14
  1. Enable the service at the top environment and location levels:
    1. From the Services Manager menu bar, select Configuration > System Manager > Service Deployment.
    2. Under Service Filter, ensure Top Environment Services is selected and then click MySQL
    3. Click Save.
    4. Under Service Filter, select Active Directory Location Services and choose a Location Filter, if applicable.
    5. Click MySQL and then click Save.
  2. Add credentials for the MySQL deployment and the MySQL web service:
    1. From the Services Manager menu bar, select Configuration > System Manager > Credentials. The Credentials Overview page appears.
    2. In the credentials table, click Add and enter the following information:
      To add credentials for Username Password Domain
      MySQL deployment Enter the username of the MySQL account. Enter the password of the MySQL account. Enter MySQL.
      MySQL web service Enter the username of the domain administrator account for the primary location. Enter the password of the domain administrator account for the primary location. Enter the domain name for the primary location.
    3. For each entry, leave Encrypted selected to encrypt the credentials as they are displayed on the page and stored in the database.
      Note: Citrix recommends encrypting credentials when Services Manager is deployed in a production environment. Use plain-text credentials only for debugging purposes.
    4. Click Add to save each credential entry.
    Note: The MySQL user you specify must have all rights that are listed in the MySQL users table, including References_priv.
  3. Assign server roles:
    1. From the Services Manager menu bar, select Configuration > System Manager > Service Roles and then click the entry for the server hosting MySQL.
    2. Under Server Connection Components, select MySQL.
    3. Under Server Roles, select MySQL Hosting.
    4. Click Save
  4. Create a server connection:
    1. From the Services Manager menu bar, select Configuration > System Manager > Server Connections.
    2. Under Management, click New Connection and then enter the following information for the server hosting MySQL:
      • In Server Role, select MySQL.
      • In Server, select the server hosting the MySQL web service.
      • In Credentials, select the domain administrator credentials that you created in Step 2 for running the MySQL web service.
      • In URL Base, enter the portion of the URL pointing to the MySQL web service. The default value is /MySQL/MySQLService.asmx. Modify this value to /MySQLWS/MySQLService.asmx.
      • In Protocol, select http.
      • In Port, the default value is 8095. If you change the port number here, make the same change for the web service as well.
      • In Timeout, the default value is 200000 milliseconds. If needed, modify this value to suit your deployment.
    3. Click Save.
    4. On the Server Connection Overview page, click the Test icon for the MySQL server. The icon turns green for a successful connection. A red icon indicates an unsuccessful connection. Mouse over it for information about the failed connection.
  5. Configure the service at the location level:
    1. From the Services Manager menu bar, select Configuration > System Manager > Service Deployment.
    2. Under Service Filter, select Active Directory Location Services and choose a Location Filter, if applicable.
    3. Click MySQL and then click Service Settings.
    4. Select the MySQL Credentials check box and then select the MySQL deployment credentials you created in Step 2.
    5. Click Apply changes and then click Save.
  6. Create a server collection:
    1. From the Services Manager menu bar, select Configuration > System Manager > Server Collections.
    2. If the Location Filter appears, select the appropriate location from the list.
    3. Under Management, click New Server Collection.
    4. In Name, enter a name for the collection, such as MySQLWindows.
      Note: The name cannot contain spaces.
    5. In Display Label, enter a friendly name that will be displayed when the service is provisioned. This name can contain spaces.
    6. In Service, select MySQL.
    7. In Servers, select each server hosting MySQL to be managed under this server collection.
    8. Click Save.

After configuring the MySQL service, you can provision the service to customers.