Hi. I’d say this is a SOGo installation question related to the database. I am hoping to find someone who already has SOGo specific experience with GCP. If not someone might be able to give me a hint where to find those triggers? Then I could take these to the GCE SQL forums and ask the DBA experts if they might cause problems.
Thank you! Dirk > Am 11.01.2019 um 14:17 schrieb Christian Mack > ([email protected]) <[email protected]>: > > 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] > <mailto:[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 -- [email protected] https://inverse.ca/sogo/lists
