poil / cgraphz Goto Github PK

At the moment it is not possible to define a socket for the database connection. To enable that the following changes need to be done to modules/DB.php:

            private function Connect()
            {
                    $this->settings = parse_ini_file(DIR_FSROOT.'/config/databases.ini.php');
                    $dsn = 'mysql:dbname='.$this->settings["dbname"].';';
                    if($this->settings["socket"])
                    {
                            $dsn .= 'unix_socket='.$this->settings["socket"];
                    }
                    else
                    {
                            $dsn .= 'host='.$this->settings["host"];
                    }

about mysql_escape_string() that should be replaced by mysql_real_escape_string()
after fixing a few, new notices about deprecated mysql that should be replaced by mysqli....

Hi Poil ! :-)

The new javascript RRD feature, allowing user to scroll RRD graph, needs the RRD files served as static.
If user is not authenticated, he can download RRD files, which is a big vulnerability.

Steps to reproduce (firebug needed) :

• Login to CGraphz.
• Navigate to a dashboard.
• Ask for a detail view (check the downloaded RRD file URL in Firebug 'network' panel)
• Logout from CGraphz.

Copy/paste the RRD file URL in your browser : you can download it !

IMHO, the ability to view (download) RRD files should be linked to CGraphz permissions.

Best regards.
R.SAIKALI

When executing:

mysql -u root -p -e "source /var/www/CGraphz/sql/initial_cgraphz_2.10.sql; source /var/www/CGraphz/sql/upgrade_from_2.10_to_2_20.sql;"

I get:

ERROR 1062 (23000) at line 337 in file: 'initial_cgraphz_2.10.sql': Duplicate entry '1' for key 'PRIMARY'

Any fix?

Hi, I installed successfully Graphz and it seems promissory. However I cannot add a server. It does nothing. Is that related to the collectd / rrdtool plugin? I mean the directory where the data are collected which has a directory by server / instance?
Let me know if there is something special todo with those directories

Thanks et encore Bravo!

Hi Poil!

at the moment I'm testing CGraphz in out lab. Installation was easy but now I'm unable to create a server.

Firebug gives me an error:

SyntaxError: missing ; before statement
"sEmptyTable":     "No data available in table",
jquery....min.js (Zeile 2, Spalte 17)

And the Apache error logfile:

[Tue Dec 17 13:06:44.176520 2013] [:error] [pid 5358] [client 10.10.0.220:46409] PHP Notice:  Undefined index: f_server_name in /var/www/CGraphz/html/config/server/w_server.php on line 17, referer: http://10.10.10.36/CGraphz/index.php?module=config&component=server
[Tue Dec 17 13:06:44.176747 2013] [:error] [pid 5358] [client 10.10.0.220:46409] PHP Warning:  Invalid argument supplied for foreach() in /var/www/CGraphz/html/config/server/w_server.php on line 18, referer: http://10.10.10.36/CGraphz/index.php?module=config&component=server

Cant find any wrong configuration. Please help.

Regards
tec

Hi,

what about a complete update to php7.x ?

Hi,
I have added 4 servers in our config and I can see only the first 2 in the dashboard. All servers are in the same project with same configuration. Any clue?

There is a Bug in /html/dashboard/project_list/r_project_server_list.php that could be solved in different ways:

replace line 6 with
$f_id_config_role=intval(filter_input(INPUT_GET,'f_id_config_role',FILTER_SANITIZE_NUMBER_INT));

1. replace the check in line 49 to check for a string instead of an int

Pour un utilisateur qui n'a accès qu'au composant "ligth", si on lance l'url CGraphz/index.php?module=dashboard&component=view, l'utilisateur voit l'ensemble des noms des projets et des serveurs.

When using that file to initialize the database one gets:
ERROR 1171 (42000) at line 180 in file: '...': All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE insted

PS:
Just went back to tag v2.46.3 and found that the same could be said for all three supplied init scripts, after checking via git blame I found that the error is present since before tag v2.00!!!

Hey Poli,

Is there a good way to translate the hard coded strings to another language? Not that I have problems with french but english or german would sometimes be easier.

I could surely help with the translation.

Pour un utilisateur qui n'a accès qu'au composant "ligth", si on lance l'url CGraphz/index.php?module=dashboard&component=view, l'utilisateur voit l'ensemble des noms de serveur grâce à l'autocompletion du input "search".

Hi,

as we have alot of Servers with >32 logical Cores, its nearly impossible to realy see anything there ;)
It would be great to have one graph to see the percentual usage of all cores.

Maybe you're faster to do that, than I am.

Thanks

Si on place des filtre sur un utilisateur. Si on va sur un projet ou il n'y a aucun graph ( car tous filtré), il n'y a pas de message qui précise qu'aucun graph n'est visible.

I'm using 2.46.1 (collectd 5.5), and all images under the Redis headline is showing broken images, all others work (tcpconns, df, apache etc.)

I go from f_id_config_server 19 to the server id = 18 which has redis, and in the error log I see:

[Thu Dec 03 13:20:19.564826 2015] [:error] [pid 12454] [client 99.91.4.16:34057] PHP Notice:  Undefined variable: plugin_json in /var/www/html/CGraphz/CGraphz/modules/functions.inc.php on line 189, referer: http://cgraphz.test.net/CGraphz/index.php?module=dashboard&component=view&f_id_config_project=2&f_id_config_environment=&f_id_config_role=Role&f_id_config_server=19


[Thu Dec 03 13:20:20.003293 2015] [:error] [pid 11090] [client 99.91.4.16:34058] PHP Fatal error:  Call to undefined function imagecreatetruecolor() in /var/www/html/CGraphz/CGraphz/modules/functions.inc.php on line 63, referer: http://cgraphz.test.net/CGraphz/index.php?module=dashboard&component=view&f_id_config_project=2&f_id_config_environment=&f_id_config_role=Role&f_id_config_server=18

This is caused by wrong usage of PDO bind function. To repair you need to add in file html/dashboard/project_list/r_project_server_list.php a bind before every query:

// add this -------------
$connSQL->bind('f_id_config_project',$f_id_config_project);
$connSQL->bind('s_id_user',$s_id_user);
// ----------------------

// before every query
$all_role=$connSQL->query($lib);
$cpt_role=count($all_role);

If not it will cause an unhandled error while executing SQL query without bound variables.