image_3 A while ago I ported Subtext to MySQL.  I've gotten a bit of feedback that suggested that the port and specially MySQL integration could be much improved.  So, I addressed a couple of issues (see below), most of them having to do with variations of MySQL installations at various web hosting companies .  As before, this is not an official version of Subtext, but simply my port from Microsoft SQL Server to MySQL.  Here is the good stuff:

Downloads:

Installation (2.84 MB)
Source (22.7 MB)

Fixes:

Removed the extra unneeded files
Fixed the location of the MySQL provider
Subtext now accounts for whether MySQL is case sensitive
Subtext now comes with a MySQL provider that supports medium trust
Added more debugging information during installation

Minimum Requirements

MySQL 5.x. 
Anything else that regular Subtext requires.

GoDaddy issues

Seeing how almost every issue that was reported to me revolved around GoDaddy, here are easy 20 steps to blogging with Subtext for MySQL:

  1. Login to GoDaddy
  2. Go to Hosting & Servers menu, then pick My Hosting Account.
  3. Click on the Open link.
  4. From the Content menu, pick IIS Settings and create a folder. 
  5. Give the folder Set Application Root and Anonymous Access permissions.
  6. From the Content menu, select File Manager, check the newly created folder, then click on the Permissions button.  Uncheck Inherit, then give the folder read/write permissions.
  7. Go to Databases menu and select MySQL, then click Create Database button
  8. For version, pick 5.0.  Give the database a name.  Note that the User ID for the database and the Database name will be the same.
  9. Go into Edit/View Details of the database and you'll see various information.  Stay on this page, while doing the next set of steps.
  10. Unzip the Installation file you just downloaded from this page and upload the contents into the folder you just created in your hosting account.
  11. Open the web.config (that resides in the folder you've created) in your editor of choice. 
  12. Search for the following line: <add name="subtextData"  connectionString="Server=YOUR_SERVER;Database=YOUR_DB;User ID=YOUR_USER_ID;Password=YOUR_PASSWORD" />
  13. Ok, remember all the way back in the step 9, I told you stay on that page.  Great. 
  14. Replace YOUR_SERVER with Host Name (from the web page). 
  15. Replace YOUR_DB with Database Name
  16. Replace YOUR_USER_ID with User Name
  17. Replace YOUR_PASSWORD with whatever password you assigned yourself for the database.  Great, the part for identifying the database is done.  Let's move on.
  18. Search for the following line:  <trust level="Full" originUrl=".*" />
  19. Comment this line out.  That means place <!-- in front of the line and --> at the end of the line.  So it should look like this:  <!--  <trust level="Full" originUrl=".*" /> -->  Why?  Because for whatever reason, GoDaddy no likey when someone tells it under what trust level to run.  So even if you set it to Medium or Low or whatever else, the site will still barf. 
  20. That's it.  You are ready to start blogging.

Troubleshooting

If the site still does not work, you can try these steps to get to the real error.  If you are still having issues, shoot me a message via the Contact link at the top.