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.
@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).
@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:
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.
Umbraco and MySQL on Linux
Hi all,
I'm thinking about the following setup:
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.
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
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...
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?
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
Okay, MySQL is just much cheaper to host than a full MS SQL licence.
@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.
@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
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
is working on a reply...