Microsoft Azure Open Source Development Support Team Blog

Support for Open Source Technologies on Microsoft Azure App Service

WordPress Tools and MySQL Migration with WordPress Buddy+

WordPress Buddy+ is an Azure Web Apps Site Extension that facilitates WordPress configuration and especially useful for WordPress migrations. It has features for updating HOME and SITE_URL, viewing list of plugins and updating passwords. In addition, it can also help migrate the MySQL database, whether it be MySQL In-App, ClearDB or on a Virtual Machine… Read more

Migrating data between MySQL databases using kudu console – Azure App Service

NOTE: Always keep multiple backup’s of your database before migration. There are often times when you want to migrate data from one MySQL server to another. This maybe because you are migrating from an On-Premise environment to Azure or upgrading a ClearDB database to a different tier or other reasons. Database migration can be done… Read more

How to upgrade ClearDB database for Azure App Service

If you are using ClearDB as your MySQL database on Azure, you probably know that there is no upgrade path available on Azure portal. The only way to upgrade would be through ClearDB dashboard. You will need to put your credit card information on ClearDB portal to upgrade your database. This blog talks about how… Read more

WordPress: Error establishing a database connection

If you see the infamous “Error establishing a database connection“, enable WordPress Debug Logging by following the steps outlined here: http://blogs.msdn.com/b/azureossds/archive/2015/10/09/logging-php-errors-in-wordpress.aspx     Debug.log will be saved within wp-content folder. Possible error messages in debug.log: [25-Jul-2016 15:34:44 UTC] PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user ‘be96d626d450b1’@’23.102.165.199’ (using password: YES) in D:\home\site\wwwroot\wp-includes\wp-db.php on line 1490 [25-Jul-2016 15:34:44… Read more

Troubleshooting PHPMyAdmin Site Extension

If you recently started having trouble (HTTP 500) with PHPMyAdmin (PMA) SiteExtension, it may be a problem with sessions. The errors look like this: Browser Screenshot of Error Text Description Chrome The page cannot be displayed because an internal server error has occurred. Internet Explorer The website cannot display the page This error (HTTP 500… Read more

WordPress Scheduled Jobs (wp-cron.php) and Slowness

Overview In Unix/Linux, a cron job is a task that can be configured to run at specific times or intervals. This is no different than a Web Job in Azure. However, in regard to WordPress, crons are invoked from wp-cron.php. For every request, WordPress runs a check to see if it’s time to invoke a… Read more

Troubleshooting MySQL Database on ClearDB

This article covers some common scenarios customers may run into using ClearDB with Microsoft Azure. For reference, here is a link to the ClearDB FAQ: https://www.cleardb.com/developers/help/faq As listed on the ClearDB FAQ, there are some general guidelines for using ClearDB. These guidelines include limitations on: Maximum Database Connections Maximum Database Size Maximum SELECT Query Execution… Read more