View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
1233RackTablesdefaultpublic2014-05-16 10:542014-05-18 17:18
Reporternareshbtech@yahoo.com Assigned To 
PrioritynormalSeverityminorReproducibilityN/A
Status closedResolutionno change required 
PlatformlinuxOSubunutOS Version12.04 lts
Product Version0.20.7 
Summary1233: pod exception
DescriptionHi all i was trying to upgrade and now i am fasing this issue

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 /var/www/tacams2/inc/dictionary.php, line 43

/var/www/tacams2/inc/dictionary.php:43 query('CREATE TRIGGER `trigger_test` BEFORE INSERT ON `innodb_test` FOR EACH ROW BEGIN END')
/var/www/tacams2/inc/upgrade.php:1394 isInnoDBSupported()
/var/www/tacams2/inc/upgrade.php:1620 getUpgradeBatch('0.20.7')
/var/www/tacams2/inc/upgrade.php:1807 executeUpgradeBatch('0.20.7')
/var/www/tacams2/index.php:269 renderUpgraderHTML()
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)
)
Parameters:

GET

module upgrade
POST

reallyreally on
COOKIE

openfire-dashboard-timeperiod last7days
advanced_box open
PHPSESSID 18r4cmllg663hce3d8l8qmb0g3
JSESSIONID zq785shj9sre1ccfj9e7y8ji4

my php version

 apt-cache policy php5
php5:
  Installed: 5.5.12+dfsg-2+deb.sury.org~precise+1
  Candidate: 5.5.12+dfsg-2+deb.sury.org~precise+1
  Version table:
 *** 5.5.12+dfsg-2+deb.sury.org~precise+1 0
        500 http://ppa.launchpad.net/ondrej/php5/ubuntu/ precise/main amd64 Packages
        100 /var/lib/dpkg/status
     5.3.10-1ubuntu3.11 0
        500 http://gb.archive.ubuntu.com/ubuntu/ precise-updates/main amd64 Packages
        500 http://security.ubuntu.com/ubuntu/ precise-security/main amd64 Packages
     5.3.10-1ubuntu3 0
        500 http://gb.archive.ubuntu.com/ubuntu/ precise/main amd64 Packages


thanx in advance please help
TagsNo tags attached.

Activities

nareshbtech@yahoo.com

nareshbtech@yahoo.com

2014-05-16 12:11

reporter   ~0002309

now i fixed it via updating the php-mysql
but now blank page turns up with errro 500
please help

[16/May/2014:11:04:33 +0100] "GET /index.php HTTP/1.1" 500 220 "-" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36"
madmax

madmax

2014-05-16 16:16

reporter   ~0002313

Does you racktables database user have the trigger privilege on the sql server?

If not:
grant trigger ON `schemaname`.* TO `user`@`server`
infrastation

infrastation

2014-05-18 15:02

administrator   ~0002319

The TRIGGER requirement is in the 0.20.7 release notes and the upgrade script displays it during the upgrade. Please check the server error log for more information about the 500 error.
infrastation

infrastation

2014-05-18 17:18

administrator   ~0002321

This looks very much like the issue resolved on the mailing list, thus I close this request. Please reopen if you still have any questions.

Issue History

Date Modified Username Field Change
2014-05-16 10:54 nareshbtech@yahoo.com New Issue
2014-05-16 12:11 nareshbtech@yahoo.com Note Added: 0002309
2014-05-16 16:16 madmax Note Added: 0002313
2014-05-18 15:02 infrastation Note Added: 0002319
2014-05-18 17:18 infrastation Note Added: 0002321
2014-05-18 17:18 infrastation Status new => closed
2014-05-18 17:18 infrastation Resolution open => no change required