On 2015-12-23, Stuart Henderson wrote:
> On 2015-12-23, Predrag Punosevac <[email protected]> wrote:
> > 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
>
> in order to have permission to do this you'll either disable binary
> logging, or set the log_bin_trust_function_creators variable, or grant
> the SUPER privilege.
>
> https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#
> \
> log_bin_trust_function_creators \
> https://mariadb.com/kb/en/mariadb/binary-logging-of-stored-routines/
Hi Sten,
Thanks for the help. Login into MariaDB and doing
MariaDB [(none)]> GRANT TRIGGER ON `racktables_db`.* TO
`racktables_user`@`localhost`;
fixes the permission problem. However now I have another problem
Pdo exception: PDOException
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'racktables_db.Config' doesn't exist (42S02)
at file /racktables/wwwroot/inc/database.php, line 3979
/racktables/wwwroot/inc/database.php:3979 execute(Array
(
)
)
/racktables/wwwroot/inc/database.php:4031 usePreparedSelectBlade('SELECT
varname, varvalue, vartype, is_hidden, emptyok, description,
is_userdefined FROM Config ORDER BY varname')
/racktables/wwwroot/inc/functions.php:5249 loadConfigCache()
/racktables/wwwroot/inc/init.php:42 loadConfigDefaults()
/racktables/wwwroot/index.php:21
require_once('/racktables/wwwroot/inc/init.php')
/htdocs/racktables/index.php:1 require('/racktables/wwwroot/index.php')
Error info:
Array
(
[0] => 42S02
[1] => 1146
[2] => Table 'racktables_db.Config' doesn't exist
)
Which is indeed true
MariaDB [racktables_db]> SHOW TABLES LIKE '%Object%';
Empty set (0.00 sec)
I think I am better off to take this off the misc@openbsd as my lack of
MySQL knowledge is all too obvious.
Thanks for the help.
Predrag
