another question about cacti and its database

[seb51]

so in the definition of cacti and database, i understand that rrdttol stores data returned by cacti and then generates graphes with these data and command. mysql is here just for indicating the structure of cacti and the organisation of the data. mysql doesn't store data (data generated by queries on the devices).

my question is the next :
I want to use SQL Server (instead of mysql) to store data. So rrdtool will generate graphes but won't store the data. i think it's a command line in a config file but i don't know where and if it's possible or if someone has already done the experience.
My goal is to use cacti, big brother and compaq Insight manager on the same server. that's why i want to use just one database (SQL Server Database).

[maenu]

hmm... good question..

the sourcecode has the file $cactidir/lib/database.php which contains all the used database-functions..
these functions are using AdoDB-stuff from php.weblogs.com/ADODB

their manual says the following

We currently support MySQL, Oracle, Microsoft SQL Server, Sybase, Sybase SQL Anywhere, Informix, PostgreSQL, FrontBase, SQLite, Interbase (Firebird and Borland variants), Foxpro, Access, ADO, DB2, SAP DB and ODBC. We have had successful reports of connecting to Progress and CacheLite via ODBC.

so I think the connection to the database shouldn't be a problem..

$cactidir/include/config.php has the line $database_type setting..

you need to change that to mssql or mssqlpo (check out http://phplens.com/lens/adodb/docs-adod ... connection)

another problem is the SQL himself .. I don't know if the used SQL is 100% compatible to MSSQL

feel free to port it to mssql.. I think it's possible

[raX]

another problem is the SQL himself .. I don't know if the used SQL is 100% compatible to MSSQL

Cacti currently makes use of ADODB which definitely a good first step in abstracting the database layer. Some of the SQL that I currently use makes use of MySQL-specific functions which will need to be abstracted or replaced. I *always* accept patches for this kind of thing .

-Ian

[TFC]

another problem is the SQL himself .. I don't know if the used SQL is 100% compatible to MSSQL

Cacti currently makes use of ADODB which definitely a good first step in abstracting the database layer. Some of the SQL that I currently use makes use of MySQL-specific functions which will need to be abstracted or replaced. I *always* accept patches for this kind of thing .

-Ian

Is phpMyAdmin answer for this problem?

[raX]

Is phpMyAdmin answer for this problem?

Not sure that I understand what you are getting at here. phpMyAdmin is typically a tool for administering a MySQL database, is there something else that it is good for?