Hello Sorry, but that is a database question, not a SOGo one. Please contact 2nd generation Google Cloud SQL server database forums.
Kind regards, Christian Mack Am 11.01.19 um 11:36 schrieb Dirk Weise ([email protected]): > Hi. > > I am about to install SOgo on GCE using a 2nd generation Google Cloud SQL > server. > > I stumbled about the following error message: > ERROR 1419 (HY000) at line 2: You do not have the SUPER privilege and binary > logging is enabled (you *might* want to use the less safe > log_bin_trust_function_creators variable) > > I found these stack exchange posts [1][2] explaining why that happens. tldr; > Triggers might cause inconsistencies when replication is enabled. Either you > do without triggers or you set the flag log_bin_trust_function_creators > promising the db that the trigger will not cause replication problems. > > My question is: can I safely set this flag without destroying the replication > or is there any other way to get around this error? > > Thank you! > Dirk > > [1]: > https://stackoverflow.com/questions/39221261/triggers-cloud-sql-2nd-generation > > [2]: > https://dba.stackexchange.com/questions/73447/why-when-does-creating-a-mysql-trigger-require-super-privileges > -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
