[zanata-users] Problem installing zanata 3.6.0 on wildfly 8.1.0 fresh

[Widura Schwittek]

Hello Sean,

yes, using MySQL 5.5 did solve the problem. Sorry for having come up with such fundamentals but the docs I read on readthedocs didn't point this out this detail.

Thanks again!
Widura
  

-----Ursprüngliche Nachricht-----
Von: Sean Flanigan [mailto:sflaniga at redhat.com] 
Gesendet: Freitag, 27. März 2015 01:28
An: Widura Schwittek; zanata-users at redhat.com
Betreff: Re: [zanata-users] Problem installing zanata 3.6.0 on wildfly 8.1.0 fresh


On 2015-03-26 20:22, Widura Schwittek wrote:
> Dear community!
> 
>  
> 
> I tried out to installing zanata with the zanata installer 3.6.0 for 
> wildfly 8.1.0 on Oracle JDK 1.8.0_60-ea-b07. I followed the 
> instructions on readthedocs. But I get the following exception while 
> liquibase is applying the sql migration scripts:
> 
>  
> 
> 08:42:36,389Z ERROR [liquibase] (MSC service thread 1-4)
> db/db.changelog.xml:
> db/changelogs/db.changelog-1.5.xml::8::aeng at redhat.com: Change Set 
> db/changelogs/db.changelog-1.5.xml::8::aeng at redhat.com failed.  Error:
> Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT
> AUTO_INCREMENT: Cannot change column 'id': used in a foreign key 
> constraint 'UKglossaryterm_glossary_entry_id' of table
> 'zanata.hglossaryterm':
> 
>  
> 
> For testing I tried again giving all rights to the mysql user but 
> without any change. Do you have any idea how to fix this?
> 
>  
> 
> Many thanks in advance!
> 
> Widura


Hi Widura,

Going by that error message, it sounds like you might be using mysql 5.6 or later. That's not supported, sorry:
https://bugzilla.redhat.com/show_bug.cgi?id=1048293


Zanata is mainly tested against mysql 5.5, although it generally works (without guarantee) on mysql back to 5.1, or on recent versions of mariadb.  I would recommend you try one of those options.


Regards


--
Sean Flanigan

Principal Software Engineer
Localisation Tools Engineering
Red Hat