timezone support in BASE spotty?
Brought to you by:
secureideas,
sinukas
Menu
▾
▴
#227 timezone support in BASE spotty?
Hi there
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.
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?
Perhaps something like
if (!preg_match("/^$/",getenv("TZ")) { dbcall "SET time_zone = getenv("TZ");"}
Thanks
Jason
Discussion
This brings up a lot of questions. Do other back end databases support this? Would it require changes to the snort or what ever that is inputing the events?
wow - I never saw your original response to this!
I don't know how other databases besides mysql handle this, but I don't think it matters. If "database XXX" store time values without being timezone aware, but php's "database XXX" code is responsive to timezone changes, then that would be a bug: i.e. either it works or it doesn't
Certainly mysql stores times internally correctly, and re-expresses the timestamps according to the timezone that php states it's working in
my dad brought me my Miu Miu Outlet http://miumiuoutlet.v5s7.com . i really like how they appear, but the top quality is fantastic. a incredibly great Miu Miu Outlet http://miumiuoutlet.v5s7.com order.
That i bring these kind of Buy Burberry http://buyburberry.v5s7.com at the end of Go down as well as all over the Winter season. They may be particularly tough, quality, as well as clothing (some people held up by using a Los angeles wintertime, as a result that could be explaining a great deal). One particular swindle which i expert had been sliding to look at stepped by using slush. Some other swindle had been these kind of Buy Burberry http://buyburberry.v5s7.com can be simply tainted. In spite of this, that difficulty is generally avoided if it's dispersed together with resilient sprinkle. Extremely minor these kind of Buy Burberry http://buyburberry.v5s7.com happen to be good we then got an additional binocular.
eL3iWI <a href="http://ttbdlytxefjx.com/">ttbdlytxefjx</a>, [url=http://nodkfpwhiidl.com/]nodkfpwhiidl[/url], [link=http://gcfibrvpwzeh.com/]gcfibrvpwzeh[/link], http://gfhpudcnhtbf.com/
SQZZaW <a href="http://nejojpwooagq.com/">nejojpwooagq</a>, [url=http://dnulqsmdekez.com/]dnulqsmdekez[/url], [link=http://capjwjskwgam.com/]capjwjskwgam[/link], http://wxeaozhyaxgq.com/
SourceForge.net: Detail: 2875887 - timezone support in BASE spotty? tmotyeql <a href="http://onthelevelinc.com/pumps.html" title="christian louboutin outlet">christian louboutin outlet</a>
SourceForge.net: Detail: 2875887 - timezone support in BASE spotty? olnodavqhfn louboutin sale http://www.kingdomofsmiles.com/
SourceForge.net: Detail: 2875887 - timezone support in BASE spotty? fqzolnhuvn burberry http://www.vaiarelli.it/