Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Henning Molbaek 23 posts 43 karma points
    Dec 30, 2010 @ 00:48
    Henning Molbaek
    0

    Umbraco and MySQL on Linux

    Hi all,

    I'm thinking about the following setup:

    • A Windows 2008 R2 server running the .net code (umbraco)
    • A Ubuntu 10.10 server running Mysql 5.5 for the database.

    Any thoughts on this setup? Will it work? Will it be fast and effiecent?

    We will only run 4.5+ umbraco sites on this setup.

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Dec 30, 2010 @ 20:37
    Jan Skovgaard
    0

    Hi Henning

    Just out of curiosity since I don't know that much about Linux...is it possible to run .aspx pages in this environment? Can apache handle this?

    /Jan

  • Luca Anchini 9 posts 29 karma points
    Dec 31, 2010 @ 03:09
    Luca Anchini
    0

    Umbraco is a .net application, so it works only on Microsoft Windows and MS SQL.

     

    Linux and apache cannot handle .asp, .net and so on...

  • Henning Molbaek 23 posts 43 karma points
    Dec 31, 2010 @ 13:03
    Henning Molbaek
    0

    Sorry I will make myself more clear.

    We will run two servers. The windows server will run the .net code and umbraco. The ubuntu server will only run the database.

    So what I'm asking is if umbraco can run properly on a MySQL database?

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Dec 31, 2010 @ 14:17
    Jan Skovgaard
    0

    Hi Henning

    That makes more sense - Umbraco itself without any 3. party addons/packages runs fine on MySQL. I have had a minor site running on MySQL without any problems.

    However you should be aware that some packages may require a MSSQL database to function properly I think.

    /Jan

  • Henning Molbaek 23 posts 43 karma points
    Jan 01, 2011 @ 14:42
    Henning Molbaek
    0

    Okay, MySQL is just much cheaper to host than a full MS SQL licence.

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Jan 02, 2011 @ 13:36
    Sebastiaan Janssen
    2

    @Henning: You don't actually need a MS SQL license, umbraco runs great on MS SQL express which is free for use and allows you to have databases up to 2 gb (which has always been plenty for me, and I've built some large sites).

    I'd prefer MS SQL all the time.

  • Michael Hunter 1 post 22 karma points
    Apr 08, 2011 @ 04:14
    Michael Hunter
    1

    @Luca Anchini and @Jan Skovgaard  Actually, it is possible to run .Net code in linux environments with the use of Mono .Net: http://www.mono-project.com/

    I run my personal blog (http://beyondtheledge.com/) using Graffiti CMS (http://graffiticms.com/) on a Suse 10.3 box running Apache 2 and MySQL 5.x

    Although, Novell and Microsoft do collaborate on making mono compatible with all things .Net, there are still plenty of obstacles to overcome, so I would be hesitant to run a production .Net web application on Mono, unless it was specifically built with Mono in mind.  http://www.mono-project.com/Compatibility

    Now, given all that, I have yet to attempt to install Umbraco in a linux environment, but plan to try it out as soon as I get some free time.

    However, it looks like there have been attempts by people in the past to make this possible:

    http://old.kasperb.dk/2006/1/8/umbraco-on-mysql--download-here.aspx

     

  • Shay Mandel 1 post 21 karma points
    Jul 11, 2013 @ 20:59
    Shay Mandel
    0

    Apparenly, at least in versions Umbraco 6.0.3-6.0.6, Umbraco doesn't work nicely with MySQL on Linux servers. This is because Umbraco requires a case-insensitive database, and when MySQL is on Linux it is case-sensitive. If you'll try it, you will get the database installation step stuck at 15%, saying:

    "
    The database you're trying to use does not support case insensitive queries. 

    We currently do not support these types of databases.

    You can fix this by changing the following two settings in your my.ini file in your MySQL installation directory:

    lower_case_table_names=1

    lower_case_file_system=1

    "

    You can fix the first one - table names, but you can't change the file system.

    Read more here: http://issues.umbraco.org/issue/U4-2187

Please Sign in or register to post replies

Write your reply to:

Draft