I am investigating some dubious activity on the server and in that connection, I have been checking my logs.
I am using the following logging:
General:
- Server Logs
- PHP error Log
All applications (Backend)
- PHPR built-in Audit Trail
- Selfmade logging application using MySQL for logging
All applications (Frontend)
- Same Selfmade logging application using MySQL for logging
The first thing I noticed was that the time in the Audit trail do not match my other logs. It is systematically 2 hours ahead of all other logs on the machine. So when the server log and my selfmade log logs 17:00:00 the PHPR Audit trail logs time as 19:00:00.
I have a site which runs PHPR 5.3 so I checked that and it is exactly the same. Ergo, this issue is not related to version.
Audit trail is storing time in the MySQL-format "DATETIME" with a value generated by PHPR
In my selfmade system i store it in " a "TIMESTAMP" with the system generated default value "CURRENT_TIMESTAMP"
My system is set up for central european time and values logged in my selfmade application are correct.
Is there a time setting somewhere in PHPR that I have overlooked?
