Can't created CDEF's get a 'Error: Save Failed'

[mailmeuk]

Hi,

I can't seem to create any CDEF's I keep getting the following error: 'Error: Save Failed'..

I'm using the following:

- Cacti Version 0.8.5
- MySQL Version 4.0.17
- PHP Version 4.3.5
- IIS

Is there anyway to fix this? because I realy need to create cdef's


thanks...
mailmeuk

[dieter]

With Mysql Control Center you can manually enter a cdef function in the table

[mailmeuk]

I found the problem, it seems there was no 'cdef' table in my database. Running the following SQL script corrected this.

Code: Select all

CREATE TABLE cdef (
  id mediumint(8) unsigned NOT NULL auto_increment,
  hash varchar(32) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY ID (id),
  KEY id_2 (id)
) TYPE=MyISAM;

--
-- Dumping data for table `cdef`
--

INSERT INTO cdef VALUES (3,'3d352eed9fa8f7b2791205b3273708c7','Make Stack Negative');
INSERT INTO cdef VALUES (4,'e961cc8ec04fda6ed4981cf5ad501aa5','Make Per 5 Minutes');
INSERT INTO cdef VALUES (12,'f1ac79f05f255c02f914c920f1038c54','Total All Data Sources');
INSERT INTO cdef VALUES (2,'73f95f8b77b5508157d64047342c421e','Turn Bytes into Bits');
INSERT INTO cdef VALUES (14,'634a23af5e78af0964e8d33b1a4ed26b','Multiply by 1024');
INSERT INTO cdef VALUES (15,'068984b5ccdfd2048869efae5166f722','Total All Data Sources, Multiply by 1024');

It's still strange why this table was missing, I installed the version of cacti on two boxes and on both the cdef table was missing.

Anyway its working now..
thanks!

mailmeuk

[mailmeuk]

It seems this also corrected a problem I was not aware off, in graph management the graph items where not showing. After running the SQL script above this also works!

mailmeuk