Am from www.icontechnicalgroup.com, we are trying to setup uPortal 5 environment in Centos 7 with mysql 5.7. As tables names are written in lowercase in some files data init is getting failed .
I cannot set variable lower_case_table_names=1 in mysql as it is effecting calendar and announcement portlets.
so , in next release can you make all tables names to upper case
Environment
None
Activity
Christian Murphy
June 15, 2018 at 5:53 PM
Hey @Satya Phanthala, We're unable to reproduce the error you're describing. I'd recommend updating to the latest version of uPortal and uPortal-start. If the issue persists, include a stacktrace of the problem. And as always, pull requests resolving issues are welcome.
Julien Gribonvald
May 15, 2018 at 4:54 PM
Are you sure this is a related problem to this mysql version ?
did you set the lower_case_table_names=1 variable before to init all your databases schema ?
I never get a such problem on mysql 5.5 and mariadb 10.1
Hello Sir/madam ,
Am from www.icontechnicalgroup.com, we are trying to setup uPortal 5 environment in Centos 7 with mysql 5.7.
As tables names are written in lowercase in some files data init is getting failed .
So i updated following files
export-profile.crn
import-group_membership_v5-0.crn
import-permission_set_v5-0.crn
import-permission_v2-6.crn
import-profile_v3-2.crn
RDBMDistributedLayoutStore.java
I cannot set variable lower_case_table_names=1 in mysql as it is effecting calendar and announcement portlets.
so , in next release can you make all tables names to upper case