V4 on MySQL: datalayer CanConnect fails - is the versionspec check invalid?
I have been experiencing some problems with installing Umbraco v4 on MySQL.
I did some investigation and debugging of the installer, and apparently the CanConnect check in umbraco.DataLayer.Utility.Installer fails.
On an empty db, I suppose the
[code]VersionSpecs("db","mysql.db",DatabaseVersion.None) [/code]
in umbraco.DataLayer.SqlHelpers.MySql acts as the fall-through-on-empty-db case umbraco.DataLayer.SqlHelpers.MySql, and it seems to fail. I recon the "db" is supposed to be a field in the "mysql.db" table.
As I interprete it, the problem is that I don't have a "mysql.db" table.
Is the check wrong, or am I missing something in my MySQL database installation?
I tried downloading the latest Umbraco sources last night, and build a v4 datalayer dll with a slight change in the umbraco.DataLayer.SqlHelpers.MySql.MySqlInstaller file. The last entry in the VersionSpecs-definition:
was substituted with this:
[code]new VersionSpecs("version","information_schema.tables",DatabaseVersion.None) };[/code]
... and it seems to be working on my MySQL v5 installation (on my hosted site).
I assume Ruben (or someone else) already got a fix coming up in CodePlex.
I got a dll if anyone is interested.
Just install umbraco like you normally do, then you can choose in the install-wizard which DB-type you want. You can choose from MSSQL, mySQL or vistaDB.
This thread is about an earlier version of umbraco which was not fully compatible with mySQL (at least not in detecting the right version). This is all solved, and version 4.0.2.1 is fully compatible with mySQL.
V4 on MySQL: datalayer CanConnect fails - is the versionspec check invalid?
I have been experiencing some problems with installing Umbraco v4 on MySQL.
I did some investigation and debugging of the installer, and apparently the CanConnect check in umbraco.DataLayer.Utility.Installer fails.
On an empty db, I suppose the
[code]VersionSpecs("db","mysql.db",DatabaseVersion.None) [/code]
in umbraco.DataLayer.SqlHelpers.MySql acts as the fall-through-on-empty-db case umbraco.DataLayer.SqlHelpers.MySql, and it seems to fail. I recon the "db" is supposed to be a field in the "mysql.db" table.
As I interprete it, the problem is that I don't have a "mysql.db" table.
Is the check wrong, or am I missing something in my MySQL database installation?
Yes it is invalid :s It was changed for compatibility with version 4, but apparently, it does not work on version 5. :s
wtf....
What version of mySQL are you using?
I'm using mysql server 5.0.67. I'll try to do some debugging tonight (I've benn out for the weekend)
I tried downloading the latest Umbraco sources last night, and build a v4 datalayer dll with a slight change in the umbraco.DataLayer.SqlHelpers.MySql.MySqlInstaller file. The last entry in the VersionSpecs-definition:
[code]new VersionSpecs("db","mysql.db",DatabaseVersion.None) };[/code]
was substituted with this:
[code]new VersionSpecs("version","information_schema.tables",DatabaseVersion.None) };[/code]
... and it seems to be working on my MySQL v5 installation (on my hosted site).
I assume Ruben (or someone else) already got a fix coming up in CodePlex.
I got a dll if anyone is interested.
Hi Tommy,
I'm a newbie on Umbraco. I want to be able to use Umbraco with mySQL 5. How do I go about this?
Hi,
you can use umbraco with mySQL 5 out of the box.
Just install umbraco like you normally do, then you can choose in the install-wizard which DB-type you want. You can choose from MSSQL, mySQL or vistaDB.
This thread is about an earlier version of umbraco which was not fully compatible with mySQL (at least not in detecting the right version). This is all solved, and version 4.0.2.1 is fully compatible with mySQL.
HTH,
PeterD
is working on a reply...