Unable to login to the portal after installing (lower_case_table_names)

book

Article ID: 7770

calendar_today

Updated On:

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.