Forum

This content is now out of date.

Visit Our Community

Cannot create db schema on AWS MySQL RDS using YF 7.1

Hi,

I'm trying to perform a fresh installation of Yellowfin 7.1 using a AWS MySQL RDS backend but its failing during the schema creation, see below.

[code]
com.hof.dbtool.DBException: Error executing update
ERR_UPDATEQUERY
Query:
SET GLOBAL log_bin_trust_function_creators = 1;


Error Code: 1227. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
[/code]

Note that AFAIK you cannot create a MySQL user with SUPER privilege on AWS RDS. You can set this parameter manually via the AWS Management Console or API.

See: https://forums.aws.amazon.com/message.jspa?messageID=183618

Kind Regards

Alex
In case it helps I did have the "create database" option selected in the install.properties:

[code]
InstallPath=/opt/yellowfin
InstallTutorialDatabase=True
InstallUsageReports=True
InstallJapaneseLangPack=False
InstallSpanishLangPack=False
InstallFrenchLangPack=False
InstallPortugueseLangPack=False
InstallChineseLangPack=False
ServicePort=80
InstallService=False
DatabaseType=MySQL
CreateYellowfinDB=True
CreateYellowfinDBUser=False
DatabaseHostname=
DatabaseName=abarnes_yellowfin_config
DatabaseDBAUser=
DatabaseDBAPassword=
DatabaseUser=
DatabasePassword=
LicenceFilePath=/opt/yellowfin/development-localhost.lic
[/code]
Ignore me, you can avoid the issue by first setting the parameter in the AWS Management Console and then running the installer.
change two parameters in RDS parameter group before running the yellowfin.

log_bin_trust_function_creators = 1
binlog_format=ROW

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.