Jahia Install Forum > Jahia 6.0 and MySQL...

0 (0 Good)
0 (0 Bad)

Jahia 6.0 and MySQL 5.5

by  odyssee »  2011/06/07 20:58

Hi all !

I installed Jahia with HypersonicDB and it works perfectly !

I tried to switch to Mysql 5.5 on a new installation of Jahia and I got many problems.

The file quartz-schema.sql (jahia_v6_CommunityEdition_r25203\webapps\config\WEB-INF\jahia\WEB-INF\var\db\sql\schema\mysql\quartz-schema.sql) is using the word "TYPE". It is deprecated since Mysql 4 and has been removed in MySQL 5.2 (http://bugs.mysql.com/bug.php?id=47974).
So I change the TYPE=InnoDB to ENGINE=InnoDB

The second problem was with hibernate. It using a mysql keyword "maxValue" in sql request. I tried to change the Hibernate Dialect from MySQLDialect to MySQL5Dialect but got the same problem.
Even with these errors, I got to the second installation step 'Importing a ACME website'. Here many column was not big enough to certain files.

Does someone have ever tried to install Jahia on MySQL 5 ?

  • Jahia 6.0 and MySQL 5.5
    2011/07/04 13:42

    odyssee <p> Hi all !<br /> <br /> I installed Jahia with HypersonicDB and it works perfectly !<br /> <br /> I tried to switch to Mysql 5.5 on a new installation of Jahia and I got many problems.<br /> <br /> The file quartz-schema.sql (jahia_v6_CommunityEdition_r25203\webapps\config\WEB-INF\jahia\WEB-INF\var\db\sql\schema\mysql\quartz-schema.sql) is using the word &quot;TYPE&quot;. It is deprecated since Mysql 4 and has been removed in MySQL 5.2 (<a href="http://bugs.mysql.com/bug.php?id=47974">http://bugs.mysql.com/bug.php?id=47974</a>).<br /> So I change the&nbsp;TYPE=InnoDB&nbsp;to&nbsp;ENGINE=InnoDB<br /> <br /> The second problem was with hibernate. It using a mysql keyword &quot;maxValue&quot; in sql request. I tried to change the Hibernate Dialect from MySQLDialect to MySQL5Dialect but got the same problem.<br /> Even with these errors, I got to the second installation step &#39;Importing a ACME website&#39;. Here many column was not big enough to certain files.<br /> <br /> Does someone have ever tried to install Jahia on MySQL 5 ?</p>

  • Number of messages  1
    Registration date Jun 7, 2011
    0 (0 Good)
    0 (0 Bad)

    Re: Jahia 6.0 and MySQL 5.5

    by  shyrkov »  2011/06/07 20:58

     

    Hello,

    the Jahia 6.0 compatibility with MySQL 5.5.x was recently addressed and the patch is planned to be included in one of the next hotfixes of the Jahia 6.1.1.
    The compatibility of jahia_v6_CommunityEdition_r25203 is guaranteed with MySQL 5.0.x branch.

    Kind regards
    Sergiy

  • Re: Jahia 6.0 and MySQL 5.5
    2011/07/04 13:42

    shyrkov <p> &nbsp;</p> <p> <meta charset="utf-8" /> Hello,<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; " /> <br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; " /> the Jahia 6.0 compatibility with MySQL 5.5.x was&nbsp;<a class="postlink" href="http://jira.jahia.org/browse/QA-1757" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; text-decoration: none; color: rgb(163, 27, 0); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(102, 102, 102); ">recently addressed</a>&nbsp;and the patch is planned to be included in one of the next hotfixes of the Jahia 6.1.1.<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; " /> The compatibility of jahia_v6_CommunityEdition_r25203 is guaranteed with MySQL 5.0.x branch.<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; " /> <br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; " /> Kind regards<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; " /> Sergiy</p>

  • Number of messages  407
    Registration date Jun 7, 2011
    0 (0 Good)
    0 (0 Bad)

    Re: Jahia 6.0 and MySQL 5.5

    by  shyrkov »  2011/06/07 20:58

    Hello,

    the Hotfix 2 for Jahia 6.1.1, which addresses MySQL 5.5 compatibility problem, is out (Changlog) and is available on our extranet for download.

    Kind regards
    Sergiy

  • Re: Jahia 6.0 and MySQL 5.5
    2011/07/04 13:43

    shyrkov <p> Hello,<br /> <br /> the Hotfix 2 for Jahia 6.1.1, which addresses MySQL 5.5 compatibility problem, is out (<a href="http://extranet.jahia.com/downloads/jahia/jahia6.1.1/Changelog/Jahia6_hotfix.html">Changlog</a>) and is available on our extranet for download.<br /> <br /> Kind regards<br /> Sergiy</p>

  • Number of messages  407
    Registration date Jun 7, 2011
    Contact
    Share
    Feedback

    Get in touch

    Whether you are a current user or if you are just evaluating Jahia, we are here to help.

    Contact us

    Share this page