Patches
Search the entire project
This project's trackers
This project's forums
This project's releases
This project's news
Project
People
Skill
Advanced search
Log In
|
New Account
Home
My Page
Projects
Code Snippets
Project Openings
pgFouine
Summary
Activity
Forums
Tracker
News
SCM
Files
[#1008506] Timestamps in stderr logs not parsed
View Trackers
|
Patches
|
Download .csv
|
Monitor
Date:
2007-08-24 10:16
Priority:
3
State:
Open
Submitted by:
Nobody
Assigned to:
Guillaume Smet (gsmet)
Category:
Group:
Resolution:
None
Summary:
Timestamps in stderr logs not parsed
Detailed description
Timestamps in PostgreSQL stderr logs are in format YYYY-MM-DD HH:MI:SS. pgFouine feeds this to strtotime(), which fails to recognize.
I changed include/postgresql/parsers/StderrPostgreSQLParser.class.php from this:
$timestamp = strtotime($formattedDate);
to this:
list($date, $time) = explode(' ', $formattedDate);
list($year, $month, $day) = explode('-', $date);
list($hour, $minute, $second) = explode(':', $time);
$timestamp = mktime($hour, $minute, $second, $month, $day, $year);
As a result times are correct now in reports.
Followup
No Followups Have Been Posted
Attached Files:
Changes:
Field
Old Value
Date
By
assigned_to
none
2008-02-25 22:44
gsmet