v7.2CE insatllation on Centos7, AWS RDS(mysql5.7) using script installation fails to create tables

Question

Hi.
new user (clearly)

I have a centos7 server in AWS.
AWS RDS mysql database defined. User defined with CREATE priveleges.

The installation script runs succesfully  
Databases and tables are created in the database with no apparent errors.

navigate to home page after install and attemtp to login with default users, and failed.

investigating logs, I found (log etract below) apparently some tables missing.

This is odd, as install reported successful. Ive repeated this, and altough i didnt thorighly investigate first time, had erro even loading home page (although tomcat home was ok), rsulting in retry of installation.

So, I guess just a quick question if theres anything obvious I might have missed. pre-install?

(I actually would prefer to install on postgresql, but installation script doesnt appear to offer this as an option.Any pointers hwo to do this?)

thanks,
--geoff

 egrep 'Caused|ERROR' knowage.log
[localhost-startStop-2] 04 Jan 2021 05:30:57,569 ERROR it.eng.spagobi.tools.scheduler.init.CleanCacheQuartzInitializer.initCleanForTenant:110 - Error while initializing scheduler
Caused by: it.eng.spagobi.commons.dao.SpagoBIDAOException: Impossible to access to the default quartz scheduler
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Table 'knowage_ce.QRTZ_TRIGGERS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.QRTZ_TRIGGERS' doesn't exist]]

[localhost-startStop-2] 04 Jan 2021 05:30:57,808 ERROR it.eng.spagobi.commons.dao.AbstractHibernateDAO.logException:255 - org.hibernate.exception.SQLGrammarException could not initialize a collection: [it.eng.spagobi.commons.metadata.SbiExtRoles.sbiNewsRoles#1]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.SBI_NEWS_ROLES' doesn't exist
[localhost-startStop-2] 04 Jan 2021 05:30:57,820 ERROR it.eng.spagobi.security.init.InternalSecurityInitializer.initRoles:346 - An unexpected error occurred while initializieng default roles
it.eng.spago.error.EMFUserError: severity [ERROR] description [Generic Error]
[localhost-startStop-2] 04 Jan 2021 05:30:57,823 ERROR it.eng.spagobi.security.init.InternalSecurityInitializer.initExtRolesCategory:704 - An unexpected error occurred while reading defualt profile attibutes
[localhost-startStop-2] 04 Jan 2021 05:30:57,931 ERROR it.eng.spagobi.security.init.InternalSecurityInitializer.initUsers:237 - An unexpected error occurred while initializieng default users
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.SBI_USER' doesn't exist
[localhost-startStop-2] 04 Jan 2021 05:30:59,942 ERROR it.eng.spagobi.security.init.InternalSecurityInitializer.initDefaultAuthorizationsRoles:646 - An unexpected error occurred while reading defualt profile attibutes
[localhost-startStop-2] 04 Jan 2021 05:30:59,949 ERROR it.eng.spagobi.commons.dao.AbstractHibernateDAO.logException:255 - org.hibernate.exception.SQLGrammarException could not initialize a collection: [it.eng.spagobi.commons.metadata.SbiExtRoles.sbiNewsRoles#1]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.SBI_NEWS_ROLES' doesn't exist
[localhost-startStop-2] 04 Jan 2021 05:30:59,950 ERROR it.eng.spagobi.security.InternalSecurityInfoProviderImpl.getRoles:67 - severity [ERROR] description [Generic Error]
 

----------------------------8<-------------------

Current database: knowage_ce

--------------------------------8<---------------------

Current database: ds_cache

MySQL [ds_cache]> show tables;
Empty set (0.00 sec)

--------------------------------8<---------------------

 show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ds_cache           |
| innodb             |
| knowage_ce         |
| mysql              |
| performance_schema |
| sys                |
| tmp                |
+--------------------+
8 rows in set (0.01 sec)

numerous errors logged in db log:
2021-01-04T05:40:45.189914Z 30795 [Note] Aborted connection 30795 to db: 'ds_cache' user: 'knowage' host: '172.31.29.217' (Got an error reading communication packets)
2021-01-04T05:40:45.190060Z 30784 [Note] Aborted connection 30784 to db: 'knowage_ce' user: 'knowage' host: '172.31.29.217' (Got an error reading communication packets)

SHOW VARIABLES LIKE "%version%";
+-------------------------+-----------------------+
| Variable_name           | Value                 |
+-------------------------+-----------------------+
| innodb_version          | 5.7.30                |
| protocol_version        | 10                    |
| slave_type_conversions  |                       |
| tls_version             | TLSv1,TLSv1.1,TLSv1.2 |
| version                 | 5.7.30-log            |
| version_comment         | Source distribution   |
| version_compile_machine | x86_64                |
| version_compile_os      | Linux                 |
+-------------------------+-----------------------+
8 rows in set (0.00 sec)

Comments

I gave up for now on trying to create the knowage_ce database in AWSRDS, and used the default local MariaDB.
This worked. Ive got knowage up for now, to test, but also facing other weird issues connecting to an RDS mySQL data_source.    Can connect succesfully same credentials, from same host (installatiion host for knowage) to the remote database, but attempting to define & test the datasource, I simply get 
Access denied for user 'knowage'@'13.xxx.yyy.11' (using password: YES)

 mysql -h mazshop.cluster-ro-XXXXXXXXXXXXXXXXXsouth-1.rds.amazonaws.com -u knowage --password=*************
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 209
Server version: 5.7.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> show grants;
+----------------------------------------------+
| Grants for knowage@%                         |
+----------------------------------------------+
| GRANT USAGE ON *.* TO 'knowage'@'%'          |
| GRANT SELECT ON `mazshop`.* TO 'knowage'@'%' |
+----------------------------------------------+
2 rows in set (0.03 sec)