Hi Misc, I am trying to deploy www/racktables with httpd (from the base). I am following 5.8 stable
# uname -a OpenBSD oko.bagdala2.net 5.8 GENERIC.MP#2 amd64 httpd tested with static files OK httpd tested with PHP 5.6.11 php_fpm OK PmWiki works like a charm mysqld configured for chroot and tested OK racktables_db created and racktables_user granted privilages. Installation script http://localhost/install.php works as a charm until very last step when I get Pdo exception: PDOException SQLSTATE[HY000]: General error: 1419 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) (HY000) at file /racktables/wwwroot/inc/dictionary.php, line 43 /racktables/wwwroot/inc/dictionary.php:43 query('CREATE TRIGGER `trigger_test` BEFORE INSERT ON `innodb_test` FOR EACH ROW BEGIN END') /racktables/wwwroot/inc/install.php:359 isInnoDBSupported() /racktables/wwwroot/inc/install.php:66 init_database_static() /racktables/wwwroot/index.php:284 renderInstallerHTML() /htdocs/racktables/index.php:1 require('/racktables/wwwroot/index.php') Error info: Array ( [0] => HY000 [1] => 1419 [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) ) That looks very much like https://bugs.racktables.org/view.php?id=1233 Can anybody who is running racktables on OpenBSD give me a hint what am I doing wrong? Best, Predrag
