That's right, in order to upgrate to 0.20.7 you need either the SUPER mysql privilege or to disable binary logging.
16.04.2014 11:25, Dika Ye wrote:
Hi all,When I try to upgrade my racktables from version 0.20.6 to 0.20.7 by following the README, I got the error as below:*Pdo exception: PDOException*SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need the SUPER privilege for this operation (42000)at file /var/www/html/rt6/wwwroot/inc/dictionary.php, line 43/var/www/html/rt6/wwwroot/inc/dictionary.php:43 query('CREATE TRIGGER `trigger_test` BEFORE INSERT ON `innodb_test` FOR EACH ROW BEGIN END')/var/www/html/rt6/wwwroot/inc/upgrade.php:1394 isInnoDBSupported() /var/www/html/rt6/wwwroot/inc/upgrade.php:1620 getUpgradeBatch('0.20.7')/var/www/html/rt6/wwwroot/inc/upgrade.php:1807 executeUpgradeBatch('0.20.7')/var/www/html/rt6/wwwroot/index.php:269 renderUpgraderHTML() *Error info:* Array ( [0] => 42000 [1] => 1227 [2] => Access denied; you need the SUPER privilege for this operation ) *Parameters:* *GET* *module* upgrade *POST* *reallyreally* on *COOKIE* *PHPSESSID* kq2s1luaf5166v00e84d7pvl87 Current, my secret.php setting as below: <?php # This file has been generated automatically by RackTables installer. $pdo_dsn = 'mysql:host=10.196.12.28;dbname=rt6'; $db_username = 'racktables'; $db_password = 'xxxxx';# Setting MySQL client buffer size may be required to make downloading work for# larger files, but it does not work with mysqlnd. # $pdo_bufsize = 50 * 1024 * 1024; $user_auth_src = 'database'; $require_local_account = TRUE;
-- Best regards, Alexey