Unable to login to the portal after installing (lower_case_table_names)

Article Id: 7770
Status: Published
Updated On: 04-05-2020 12:59
Legacy Id: TEC1207646
Products:
CA API Developer Portal CA API Gateway
Issue/Introduction:

After a fresh install of portal, using the admin/7layer credentials does not let you login. 

Cause:

Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup

Environment:

Release: L7APIP99000-3.5-API Developer Portal-Perpetual
Component:

Resolution:

Add the following line in /etc/my.cnf and then restart mysql:
lower_case_table_names=1

where : 
lower_case_table_names=0 (Case Sensitive Enabled)
lower_case_table_names=1 (Case Sensitive Disabled)

Additional Information:

Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.