Bug 728513

Summary: cacti.sql doesn't work on mysql >= 5.5
Product: [Fedora] Fedora Reporter: Sven Lankes <sven>
Component: cactiAssignee: Gwyn Ciesla <gwync>
Status: CLOSED RAWHIDE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: rawhideCC: gwync, ktdreyer
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-08-08 16:59:11 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Patch none

Description Sven Lankes 2011-08-05 12:03:17 UTC 
Cacti comes with a cacti.sql that creates the mysql tables needed for cacti.

This script creates tables with TYPE=MyISAM. TYPE has been deprecated since mysql 4 and has been removed with 5.5 so that the script no longer imports.

This is already fixed in cacti svn - so no need to notify upstream.

Patch attached - changing TYPE to ENGINE.
Comment 1 Gwyn Ciesla 2011-08-08 15:51:29 UTC 
Patch attached. . .to. . .what? :)
Comment 2 Sven Lankes 2011-08-08 16:12:37 UTC 
Created attachment 517261 [details]
Patch
Comment 3 Gwyn Ciesla 2011-08-08 16:59:11 UTC 
Awesome, fixed in rawhide, thanks!
Comment 4 Ken Dreyer 2011-10-27 17:54:32 UTC 
For the record:

The upstream fix was http://svn.cacti.net/viewvc?view=rev&revision=6293
This was first included in an upstream release in 0.8.7h.