PacketFence - BTS - PacketFence
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001289PacketFenceweb adminpublic2011-09-29 16:232011-10-24 20:17
Reporterfgaudreault 
Assigned Tofgaudreault 
PrioritylowSeveritytweakReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version3.0.1 
Target Version3.0.2Fixed in Version3.0.2 
fixed in git revision
fixed in mtn revision3b315a1cd426d37ffbc3e9f03e921ea07e213b32
Summary0001289: Dashboard won't give SQL stats if MySQL is running on another machine
DescriptionReported 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.
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-09-29 16:23fgaudreaultNew Issue
2011-09-29 16:39fgaudreaultmtn revision => 3b315a1cd426d37ffbc3e9f03e921ea07e213b32
2011-09-29 16:39fgaudreaultNote Added: 0002305
2011-09-29 16:39fgaudreaultStatusnew => resolved
2011-09-29 16:39fgaudreaultFixed in Version => +1
2011-09-29 16:39fgaudreaultResolutionopen => fixed
2011-09-29 16:39fgaudreaultAssigned To => fgaudreault
2011-10-24 20:15obilodeauTarget Version => 3.0.2
2011-10-24 20:15obilodeauNote Added: 0002387
2011-10-24 20:16obilodeauStatusresolved => closed
2011-10-24 20:17obilodeauFixed in Version+1 => 3.0.2

Notes
(0002305)
fgaudreault   
2011-09-29 16:39   
Fixed.
(0002387)
obilodeau   
2011-10-24 20:15   
fix released in 3.0.2