Getting Flowview Plugin sql script to work with MariaDB

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
involv3r
Posts: 2
Joined: Tue Aug 12, 2014 8:36 am

Getting Flowview Plugin sql script to work with MariaDB

Post by involv3r »

When I try to create the rows in the cacti database for the flowview plugin I get the following error.

ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MEMORY' at line 6

I am using the newest version of MariaDB instead of mysql. Does anyone know what I need to change the line TYPE=Memory to for this script to work?
cigamit
Developer
Posts: 3369
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Re: Getting Flowview Plugin sql script to work with MariaDB

Post by cigamit »

I would change
TYPE=MEMORY
to
ENGINE=MEMORY
involv3r
Posts: 2
Joined: Tue Aug 12, 2014 8:36 am

Re: Getting Flowview Plugin sql script to work with MariaDB

Post by involv3r »

sweet that worked. Thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests