https://sourceforge.net/p/secureideas/bugs/227/2009-10-09T18:44:56ZRecent changes to 227: timezone support in BASE spotty?2009-10-09T18:44:56Z2009-10-09T18:44:56ZJason Haarhttps://sourceforge.net/u/jhaar/https://sourceforge.net9c95f638b313f641bc85d444e80518b66844a3d4

<div class="markdown_content"><p>Hi there</p> <p>We're running several snort sensors in different countries, so we run all the collectors in UTC. However, we'd like the different base frontends to show time in local time. We ensure "TZ" is set correctly and sure enough, when you enter base, "Queried on" returns the current time in the local timezone - but all the times associated with snort events are still in UTC. I'm guessing that is because the former does direct PHP time calls (and is affected by TZ) whereas the snort events come out of mysql - and are not.</p> <p>mysql enables you to change the timezone settings via " SET time_zone = 'Pacific/Auckland';" (assuming you've initialized mysql tables correctly). Could support for that be added to base?</p> <p>Perhaps something like</p> <p>if (!preg_match("/^$/",getenv("TZ")) { dbcall "SET time_zone = getenv("TZ");"}</p> <p>Thanks</p> <p>Jason</p></div>