Hosting your own URL shortener with YOURLS, Azure Web Site and WebMatrix

For a couple years now, I’ve been paying for a private-label URL-shortening service.  I’ve amassed hundreds of links, and don’t want to lose any of the shortcuts, but the cost has gone up with no change in features.  I would love to have better metrics, and certainly a lower cost.  Having a small Azure benefit gives me a level of free hosting with an Azure website.  I hunted around and found several open source URL shorteners.  I decided on using YOURLS, a PHP-based application with all the features I want and then some (nice charts, plugins, social sharing, an API and bookmarklets).  Plus, it looked insanely easy to install.  Here’s how I set up YOURLS on Azure (this blog post took longer and is more difficult to read than the actual process, it was that easy).  There are a couple paths you can follow here, yours may differ from mine since I already had some existing services set up.

Step 1: MySQL on Azure

YOURLS uses MySQL as its database.  There are two primary ways you can host MySQL on Azure:

  • ClearDB offers hosted MySQL databases on Azure, with a 20 MB developer instance for free.  This is plenty to play around with, but if you want more you can.  There are two ways to set up CleaDB on Azure: How to Create a MySQL Database in Windows Azure.
  • Spin up a VM (Linux or Windows) and host a MySQL instance on it.  This is probably the more expensive option, but gives you the utmost control.  If you wanted to use this VM to host your YOURLS, you could, but that’s another blog post.

I already had my developer instance set up from an earlier WordPress experiment.  I created this instance as a linked resource for Windows Azure Web Site previously, which is an easy way to get started, but limits you to the 20 MB limit.

Either way, follow one of the sets of instructions at http://www.windowsazure.com/en-us/develop/php/common-tasks/create-mysql-database/ to get started.

If you’re sharing a MySQL database, by default the Yourls tables are created with yourls_ prefix, so you can separate new tables from existing ones.

Step 2: Creating the Web Site

As with the MySQL database, you can do this in one of two ways.  If you have already followed, or plan to follow, the instructions for creating a MySQL database as a linked resource, use that and skip this step.  In that process, you’ll create a site in the Azure portal, then create a CleaDB MySQL instance linked to the site.

If you have a existing MySQL database, but need to create the website, you can create the site from within WebMatrix 3, which is what I did (if you don’t have WebMatrix 3, you will need to update to the latest version).

From the start screen, New >> Empty Site starts the process.

image

The next step is to find a unique name for your site, and a location to host it.  At this step you’re configuring the long name for your site.  Later you can configure a custom URL for your website.

 

image

A local and remote site are created

image

image

 

At this point, you’re read to start working.  You’ll be working in a local version of your website, not directly in the website.

Step 3: Installing and Configuring YOURLS

To get started this way, download the most recent version from https://github.com/YOURLS/YOURLS/tags (cloning and publishing via Git will be discussed in another post).  Unzip the download into the folder for the website created above.

Configuration options are explained at http://yourls.org/#Config.  The main ones to configure are:

  1. YOURLS_DB_USER
  2. YOURLS_DB_PASS (remember this will be stored in plain text)
  3. YOURLS_DB_NAME
  4. YOURLS_DB_HOST
  5. YOURLS_DB_PREFIX (this is how you can separate YOURLS tables from any others in the same MySQL database)
  6. YOURLS_SITE (use the temporary URL until DNS propagates)
  7. YOURLS_COOKIEKEY (generate at http://yourls.org/cookie)
  8. $yourls_user_passwords (this is how you’ll log into the admin portal, you can encrypt these per https://github.com/YOURLS/YOURLS/wiki/Username-Passwords).

Do not put the config file in a publicly available location!  You have secrets in this file, make sure it stays private.

In order to view admin pages, you’ll also need to add a web.config to the root folder of your YOURLS site; see https://github.com/YOURLS/YOURLS/wiki/Web-Config-IIS for a sample file.

Step 4: Publishing to Azure and Installing Database Tables

If you used WebMatrix to create your Azure Web Site, all you need to do now is click Publish and your files will be transferred automatically.  If you created your database and site via the Azure Portal, you’ll be prompted to either choose an existing Azure Web Site, use WebDeploy, or manually configure FTP.  This is a one-time configuration—every subsequent time you can just hit Publish.

After the site is deployed, there is a one time installation.  Simply go to http://<yoursite>.cloudapp.net/admin, log in with the credentials you saved in the config file, and follow whatever prompts you’re given.

Step 5: Custom URL on Azure

Custom URLs for Azure Web Sites are not technically free, but you can apply Azure credits via an MSDN subscription (which I do) or pony up for a paid subscription.  Instructions for configuring a custom domain name for an Azure Web Site are at http://www.windowsazure.com/en-us/develop/net/common-tasks/custom-dns-web-site/.

You’ll need to have custom DNS for your site, usually this is done by using your registrar’s nameservers and custom DNS settings.  If your registrar doesn’t offer such a service, look into a service like https://dnsimple.com/.  You’ll need to configure both a CNAME and an A record.  Do not forward your domain name.  After you configure your DNS, it’ll take a day or so to propagate completely.  Once the DNS is propagated, you’ll need to edit the config file and set the YOURLS_SITE to the custom domain name and republish.

Step 6: Track those clicks!

You should be fully running, you can extend YOURLS with some of the plugins found at https://github.com/YOURLS/YOURLS/wiki/Plugin-List.

Happy shortening!

SQL Azure Reporting Update

Invitations have been sent out, mine has been activated and I’ll be working on the Azure Reporting features as an update to the book (http://bit.ly/msazurebook).  If you’re interested in SQL Azure Reporting, here is a recent message from the team:

You are receiving this email because you submitted your information on http://connect.microsoft.com/sqlazurectps to indicate your interest in the SQL Azure Reporting limited CTP. The Microsoft team has been very busy rolling out the SQL Azure Reporting limited CTP to customers and partners starting late last year. We have received an overwhelming response to our call for registration exceeding our most optimistic expectations.  The team has been very busy on-boarding registrants and rolling out the invitations in stages.

For those that have received an invitation, please follow the instructions provided in that email; those that are still waiting, we thank you for your support and patience as we bring you onboard.  The great news is that we are expanding the program with the goal to accommodate everyone who expressed interest – this means much richer community to test and discuss the product. We are looking forward to receiving your feedback and suggestion on features and functionality of SQL Azure Reporting.

If you have not received the invitation yet but would like to get a head start on SQL Azure Reporting here are a few pointers that will get you started:

· Intro to the SQL Azure Reporting Limited CTP – http://msdn.microsoft.com/en-us/library/gg430133.aspx

· SQL Azure Reporting FAQ – http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-reporting-faq.aspx

· Reporting Samples – http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-reporting-samples.aspx

· SQL Azure Forum – http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/threads

· Vote and comment on feature requests for SQL Azure Reporting – http://www.mygreatsqlazurereportingidea.com

It’s Microsoft Monday at Packt Publishing

Packt Publishing printed my book on Microsoft’s Azure (http://bit.ly/msazurebook), and to show their commitment to Microsoft technologies, today is Microsoft Monday, with two special offers:

To mark Microsoft Monday, Packt is highlighting five new Microsoft books:

And, of course:

Our Book is Officially Published!

Nate and I received the official word earlier today:

Hi Guys,

I am delighted to say I have just clicked some mouse buttons, and officially published your book.

Congratulations!

The book will become available on Packtpub.com in the next hour or so, and channel feeds will kick in soon (Amazon, for example, is currently taking around 3 days).

Well done on all your hard work! It looks fantastic.

The direct link to the book on Packt is http://bit.ly/msazurebook.

Right now, I’mfeeling a great deal of excitement and a great deal of relief.  What an awesome experience.  Packt Publishing was fantastic to work with, we had total freedom to develop the book as we saw fit, and I’m proud of how it turned out.  We worked our tails off to make this happen, and I hope everyone who reads the book finds it very useful.

New Database Sizes in SQL Azure

Received this bit of cool news yesterday:

Dear Customer,

We are pleased to announce that starting on June 28, 2010, we will be increasing the size limit of a SQL Azure Business Edition database from 10 GB to 50 GB and that of a SQL Azure Web Edition database from 1 GB to 5 GB.  Please note that if you elect to increase your existing databases to take advantage of these new sizes, there are additional charges.  Please refer to our offer comparison table for more details by offer on our pricing.

Thank you for your business and your continued interest in the Windows Azure platform.

Windows Azure Platform Team

Pgh.NET: Programming Silverlight in the Cloud

Join the Pgh.NET User Group on June 9 as Vijay Koneru gives an overview of programming Silverlight applications using the Azure Cloud Services API. Also, Craig Oaks will provide an introduction to using Silverlight with ArcGIS.

Date:     Tuesday, June 9
Time:     5:30 – 8 p.m.    
Venue:    Microsoft Offices, 30 Isabella Street, 15212

Register: http://webportal.pghtech.org/Events/CalendarEventsListView.aspx

DotNetKicks Image

Azure Services error–no log messages appear

Preparing for today’s Pittsburgh Code Camp talk was challenge, since we were stringing together a lot of things that are half baked.  On of the issues we had was with log messages (RoleManager.WriteToLog) not appearing in the development fabric UI.  Lindsay had the same problem when she was demoing Azure Services for MSDN Across America a couple weeks ago.

I would see the log messages once, then no messages for subsequent runs.  I finally figured out that if you shut down and exit the Development Fabric UI, then let it restart with the next run, your messages will log.  Unfortunately, you’ll need to do this each time you want to examine logged output.