Unable to login to the portal after installing (lower_case_table_names)
book
Article ID: 7770
calendar_today
Updated On:
Products
CA API Developer PortalCA 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
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.