question about the database

[seb51]

cacti creates graphes with rrdtool. but data are stored in MySQL database, right or wrong?
If during the installation of cacti , i change mysql software by SQServer, i finally use the new database SQL Server. is it possible?
i think i can, because rrdtool just helps cacti to generate graphes. after that this information and data are stored in the database.
thanks for your help!!!

[dieter]

MySql is used for the administrative things. Which graph on which tree, which devices are we monitoring, ...

The data from a device itself is stored in the RRD files, and rrdtool uses these files to generate a graph.

I don't know if changing to another dbms is possible? Is all the code written for MySql or is this done via odbc?

Code: Select all

$database_type = "mysql";

The line above (from ./include/config.php) makes me think that changing this line is the only thing to do to work with another dbms?

[Guest]

anyone ever tried using MSSQL?

[raX]

Although the ADODB framework is in place, I highly doubt that Cacti would work with anything other than MySQL at this point. There are a bunch of ADODB-specific functions that I need to make use of before Cacti will work with other SQL implimentations.

A friend of mine starting work on making Cacti work with MSSQL a while back. I think he got it to login, but I am pretty sure most pages resulted in some sort of error beyond that.

-Ian