Communication with php pogram
Monday August 31st 2015

Deploying phpBB on Windows Azure

Windows Azure is the Mircrosoft cloud computing solution. One thing that might come as a surprise is that is specifically intended to run php applications (well, it runs .net too, even java). Long story short, we got introduced to the azure platform during the JumpIn! Camp. The project to get phpBB running on the Azure platform started right there – now it’s showing results.

The prequisite for deploying on Azure is the new support for the native MSSQL driver, which was contributed by Microsoft.
However, a few issues had to be tackled to actually run phpBB in the cloud, namely:

  • SQL Azure is not quite the same as SQL Server and requires a few tweaks
  • Files (uploads) can’t be stored on the local file system, but have to be shared among all instances
  • A few oddities of the Azure platform, especially regarding values reported by the webserver

To expand a bit on the issues: SQL Azure requires primary (“clustered”) keys on all tables, something the default phpBB schema does not deliver. On the flip side, the phpBB MSSQL schema includes partition clauses, which are not supported on Azure. Long story short: it needs a different schema. Files cannot be stored locally in a multi-server environment – for instance a cloud – but have to be shared between all instances. This required a few patches to the phpBB core. Finally, Azure includes a load balancer, which reports an incorrect – internal – port via the ‘SERVER_PORT’ variable. This had to be corrected.

All of these changes can be found in my azure branches of my fork at github: and

So, how to use these? The answer is:

  • Download the source from the bug/9725 branch
  • Create a SQL Azure database
  • Add a firewall rule to allow your own machine to connect to the SQL Azure database
  • Start the phpBB installation, using the bug/9725 branch on your local machine
  • Use the credentials of the SQL Azure database during the install
  • Add the line define(‘AZURE_INSTALL’, true); to the config.php file
  • Delete the install directory
  • Create an Azure package with the phpBB installation you had locally
  • Deploy the package on Azure
  • Add a firewall rule to SQL Azure to allow your phpBB instance to connect with the database

Congrats, you’re running phpBB on Azure.

View full post on phpBB

  • Share/Bookmark
Related Tags: , , ,

Leave a Comment

More from category

The return of the database

internet advertising Any of you who have tried to access phpBB over the past few days might have experienced a variety [Read More]

Symfony Live London 2015 – Please vote for phpBB!

internet advertising Symfony Live London and the rest of the SymfonyLive/SymfonyCon conference series are amazing [Read More]

phpBB Developer Documentation

internet advertising When the phpBB Team met in Prague last month for a short productivity meeting we achieved many [Read More]

phpBB at Symfony Developers UK (London)

internet advertising At a recent meeting of the Symfony Developers UK user group in London I gave a talk titled [Read More]

OSCON 2014 Recap

internet advertising Last week phpBB again attended OSCON, the O’Reilly Open Source Convention, in Portland, [Read More]

Twitter On Me

<p>Error: Twitter did not respond. Please wait a few minutes and refresh this page.</p>


August 2015
« Jul