Hybris 6.7 with mysql 5.7 setup

[agupta]

Hi Teams,

Does any body has setup hybris 6.7 with database mysql 5.7 ?

problem is when i do update i am getting error like ,

ERROR [hybrisHTTP5] [Registry] cannot activate tenant <> since its database connection is currently lost

thanks in advance.

[arvind-kumar_avinash]

Please try with MySQL 5.6.

[geffchang]

According to the 3rd-party matrix - https://help.hybris.com/6.7.0/hcd/8c71300f866910149b40c88dfc0de431.html - mySQL 5.7 should be OK with Hybris 6.7. Try to use a different DB Driver, as suggested.

[Former Member]

Hi Ankur,

Can you please add the following lines in your my.cnf file and let us know if it resolves the error?

 [mysqld] 
 innodb_file_per_table=OFF
 innodb_flush_log_at_trx_commit=0

and then place the file (my.cnf) in the etc folder. After that is done please restart the mysql server. This should resolve your issue.

thanks,

[Former Member]

Hi,

You should first run these scripts

SET GLOBAL innodb_file_per_table=OFF; SET GLOBAL innodb_flush_log_at_trx_commit=0;

and it will be very nice if you use innoDB

[VinayKumarS]

Hi Ankur,

What is the mysql connector jar you are using??? It should be at least version 5.1.x

you can try this. https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.44 or higher version.