0001289: Dashboard won't give SQL stats if MySQL is running on another machine - PacketFence - BTS

Bug Tracking System

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

ID

Project

Category

View Status

Date Submitted

Last Update

0001289

PacketFence

web admin

public

2011-09-29 16:23

2011-10-24 20:17

Reporter

fgaudreault

Assigned To

fgaudreault

Priority

low

Severity

tweak

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS

OS Version

Product Version

3.0.1

Target Version

3.0.2

Fixed in Version

3.0.2

Summary

0001289: Dashboard won't give SQL stats if MySQL is running on another machine

Description

Reported on the mailing list, we are not taking into account that MySQL can run on another machine.

Problematic code in pf/html/admin/status/sajax-dashboard.php :
if(!preg_match("/[\'|\"|\;]/", $user) && !preg_match("/[\'|\"|\;]/", $pass)){
      exec("/usr/bin/mysqladmin status -u$user -p$pass", $sql_output);
      if(preg_match("/Queries\sper\ssecond\savg:\s+(\d+\.\d+)/", $sql_output[0], $matches)){
        $sql_queries = $matches[1];
      }
    }

The -h flag is missing.

Tags

No tags attached.

fixed in git revision

fixed in mtn revision

3b315a1cd426d37ffbc3e9f03e921ea07e213b32

Relationships

Notes
(0002305) fgaudreault (viewer) 2011-09-29 16:39	Fixed.

(0002387) obilodeau (reporter) 2011-10-24 20:15	fix released in 3.0.2

Issue History
Date Modified	Username	Field	Change
2011-09-29 16:23	fgaudreault	New Issue
2011-09-29 16:39	fgaudreault	mtn revision	=> 3b315a1cd426d37ffbc3e9f03e921ea07e213b32
2011-09-29 16:39	fgaudreault	Note Added: 0002305
2011-09-29 16:39	fgaudreault	Status	new => resolved
2011-09-29 16:39	fgaudreault	Fixed in Version	=> +1
2011-09-29 16:39	fgaudreault	Resolution	open => fixed
2011-09-29 16:39	fgaudreault	Assigned To	=> fgaudreault
2011-10-24 20:15	obilodeau	Target Version	=> 3.0.2
2011-10-24 20:15	obilodeau	Note Added: 0002387
2011-10-24 20:16	obilodeau	Status	resolved => closed
2011-10-24 20:17	obilodeau	Fixed in Version	+1 => 3.0.2

Copyright © 2000 - 2012 MantisBT Group