Daniel -
You can find the PostgreSQL code for status data in the xdata/xsddb.c
file. Code for MySQL is mixed in there as well, but the PostgreSQL
code should be fairly evident, as it is enclosed in #define
statements. Let me know if you find anything wrong with the code.
On 11 Aug 2004 at 10:25, Fiederling, Daniel wrote:
> Thanks Ethan!
>
> I suspect that reading is the problem. If I use psql to query the
> timestamps everythings seems to be ok. I've done a little very dirty
> hack to display the times correctly: just before calling
> get_time_string() for display purposes I decrease the time (-2h). For
> now I've changed extinfo.c and status.c. I've also tried to find the
> file where the reading from pgsql is done but I didn't find it. Can
> you tell me where I find this code?
>
> As far as I know PostgreSQL uses local timezone settings (TZ
> environment variable) but that variable isn't set in my login shell -
> so I expect Apache not to set it when starting CGIs. The parameter
> "timezone" in postgresql.conf is not set, I've tried to change it -
> without success. But LC_TIME is set in postgresql.conf to "de_DE@euro"
> which was set by initdb and is correctly for my environment.
>
> It would by nice if anyone could supply with information about using
> Nagios with PostgreSQL and the actual timezone settings.
>
> Greets
> Daniel
>
>
>
> -----Ursprungliche Nachricht-----
> Von: Ethan Galstad [mailto:[email protected]]
> Gesendet: Mittwoch, 11. August 2004 05:31
> An: [email protected]
> Betreff: Re: [Nagios-devel] Displayed Timestamps on the web interface
>
>
> Sounds like the time isn't being written to or read from PostgreSQL
> correctly. I no longer have a PostgreSQL server setup, so I can't
> test this easily. Is anyone else able to test this?
>
> On 5 Aug 2004 at 10:42, Fiederling, Daniel wrote:
>
> > Hi list,
> >
> > I've already posted this to the Users-List, but there where no
> > answers. Perhaps you can help:
> >
> > --------------------------------------------------------------------
> > -- ------ --- I have Nagios running for about 4 weeks and I really
> > like it and there is the plan to substitue BigBrother with Nagios.
> > But there is one problem with the web interface: the timestamps
> > displayed are wrong (for example in extinfo.cgi). They are always
> > +2h. The timestamp display in "Current Network Status" / Last
> > Updated (the box in the upper left) is correct.
> >
> > I have found some questions about that issue in the list archive but
> > no answers. The FAQ says nothing about timezones / wrong timestamps.
> > Can anybody help me?
> >
> > My system is a SuSE 8.2 box with Nagios 1.2 (2004-02-02). My system
> > time is local time (CEST), synchronized with xntp to our main time
> > server. I use PostgreSQL for data storage. The timestamps in the
> > database are displayed correct with psql - maybe psql adjusts the
> > display to the current timezone, I don't know.
> >
> > I think, GMT is our local time - 2h, or in other words CEST is GMT+2
> > (not sure about that!). I don't know if that's a hint to the
> > problem.
> > --------------------------------------------------------------------
> > -- ------ ---
> >
> > In the meantime I tried to alter the function get_time_string() in
> > cgiutils.c, without success. I think that timestamps read from the
> > database are thought as being UTC but they are already CEST. The
> > localtime()-call in cgiutils.c adds 2h and I get the wrong times on
> > the web interface. Any tipps for me?
> >
> > Please help me!
> > Daniel
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by OSTG. Have you noticed the changes
> > on Linux.com, ITManagersJournal and NewsForge in the past few weeks?
> > Now, one more big change to announce. We are now OSTG- Open Source
> > Technology Group. Come see the changes on the new OSTG site.
> > www.ostg.com _______________________________________________
> > Nagios-devel mailing list [email protected]
> > https://lists.sourceforge.n
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]