New installation or upgrade from previous version of Appcenter fails.
There is an error present in /var/log/nukona/appcenter-upgrade.log or /var/log/nukona/appcenter-install.log stating:
1. django.db.utils.OperationalError: (1298, "Unknown or incorrect time zone: 'America/Los_Angeles'")
2. "'tenantname' is not allowed to connect to this MySQL server"
MySQL either does not recognize the server's timezone or its information is missing.
Oracle 11g is not impacted by this issue.
For Linux operating systems the zoneinfo files are included, but not always correctly specified. Please run the following command in the terminal on the MySQL server and be sure to modify the provided paths as needed:
mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -Dmysql -u root mysql -p
Provide password for DB access when prompted
Grep for zoneinfo, to find correct path to import time zones.
There is no need to restart mysql service on linux type system.
For Windows operating systems please visit the following link and place the downloaded/extracted files into your database directory.