Cannot create db schema on AWS MySQL RDS using YF 7.1
29 August, 2014
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
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]
[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
log_bin_trust_function_creators = 1
binlog_format=ROW