Enable PaaS (MySQL) in Azure Stack TP1

As you might have followed along the PaaS series on this website then this is the last PaaS resource provider we need to enable. And actually, in my opinion, the easiest one. Its fully automated but it is important that you run this as Administrator. I assumed you have updated the Powershell version on the CLIENTVM to the latest version as described here. I created this script to start the installer script:

When prompted enter the AzureStack Administrator Password:

clip_image001

This will start a bootstrap ISE window. Hit F5 to execute the script

clip_image002

Now before we start you maybe never used the Administrator account to login the CLIENTVM. We need to add the portal.azurestack.local and the login page for Azure AD to the trusted sites. Type in the command shell (blue screen) start https://portal.azurestack.local and login once. Then close the browser. You might need to setup the login for Azure AD to add to the trusted sites and allow cookies:

clip_image003

Ok, From now in its super simple. We start at the prepare mysql prerequisites. Skip the readme tab and select the New-SslCert.ps1 tab and hit F5. Specify password P@ssw0rd for the pfxfile. :

clip_image004

This will as you might expect create a certificate for the MySQL environment. You can verify after the script has ran the files in this location D:\MySQL\Prerequisites\BlobStorage\Container:

clip_image005

Now click on the Download-MySQLServer.ps1 and hit F5. The script will start and open up IE page for the license agreement

clip_image006

Close the IE browser an click continue:

clip_image007

When that’s done go to the next tab Upload-Microsoft.MySQL-RP.ps1 This will create a resource group, a storage account and then uploads the content we downloaded and created earlier:

clip_image008

The last part of the prepare tab is to publish gallery packages. This will enable in the portal the option to deploy the MySQL server from the marketplace. Just hit F5:

clip_image009

And that was the preparation part!

Now hop over to the Deploy-MySQLProvider TAB and start with the subtab Microsoft.MySql-provider.parameters.json and add the username and password:

clip_image010

Next go to the Deploy-Microsoft-MySql-provider.ps1 script and hit F5. It will ask for the tenant Azure AD name. Type yours and hit enter again:

clip_image011

Now the MySQL Resource provider will be deployed in Azure Stack. This might take a while to complete. For me it took 1 hour and 5 minutes:

clip_image012

So when that’s done go to the register-Microsoft.MySQL-fqdn.ps1 and hit F5. Again provide the name of your Azure AD and hit enter. This script will look up the external IP for the MySQL VM and register it in the DNS using an invoke-command to the ADVM:

clip_image013

Then we need to go to the Register-Microsoft.MySQL-Provider.ps1 As you might guess… Hit F5 and enter the Azure AD name and then the credentials you have specified in the parameters.json file earlier in this tutorial (basicAuthUsername & basicAuthPassword):

clip_image014

And if all goes correct we will have the output below:

clip_image015

The last 2 tabs are there for deploying MySQL Database using ARM templates and PowerShell. You can specify parameters and then go to the script(last tab)

clip_image016

In the last tab Hit F5 and you have your first mySQL DB enrolled:

clip_image017

Now let’s add the MySQL resource provider to the POC Plan. Go to the Azure Stack portal as Service Administrator and go to the Plan and add the MySQL resource provider:

clip_image018

You will notice when configure quota it is saying “coming soon”, just click on OK. Now we have the MySQL available for tenants as well. Strange enough i have 2 MySQL items available:

clip_image019

Enjoy!

Mark Scholman

@MarkScholman

Spread the word. Share this post!

  • Robert

    Hey Mark,

    great post again, thanks!
    Do you know if the “Resource Provider Management” for the MySQL provider is supposed to be working or is this not available yet? When I go to “Resource Providers” “MYSQL-LOCAL” and then “Go To Resource Provider Management”, the upcoming blade shows following error message:
    Unable to locate blade ‘ResourceProviderDashboardBlade’ in extension definition. Search path:'[0]Microsoft_Azure_MySql-[1]ResourceProviderDashboardBlade’
    Just wondering whether this is expected behavior for now or whether this should be working?
    Many thanks,
    Rob

    • Mark Scholman

      Hi, just checked, i got the same error on the RP management blade, but when i look at the trace it does successful connect to the resource provider. So it might not be implemented. i dont know for sure, will check it with colleagues who also implemented the MySQL RP.

      • O.Miossec Mediactive

        I got the same error
        But by closing my brower and start again to add Mysql to my plan it work

        • Mark Scholman

          Yes, MySQL is working as it should. It’s only the RP management blade giving me this error message

  • Charles Windom

    Mark,

    I am trying to deploy the SQL and the MySQL Resource Providers and I am running into issues when running the scripts. I will post my PowerShell results from the “Upload-Microsoft.MySQL-RP” tab as my trouble starts here.

    This is a clean Azure Stack installation. All was successful during deployment.

    I run the Upload-Microsoft.MySQL-RP script and I get the following errors: (text file attached)
    Any assistance would be greatly appreciated
    Thanks In Advance,
    Charles