[mrtg] Re: migration from NT to Linux

[Alex van den Bogaerdt]

Okay, previous post went wrong.  Let's try again...

Scheidel, Greg wrote:
> 
> "For Excel"?  If you happen to be using Excel to process this, Ok, but it
> works just as with a calculator, pen and paper, or converting it on the
> Linux box.
> 
> The logfile should be the same, yes.  All I'm saying is that if I take the
> date of 949075089 on my Linux box and process it I get Fri Jan 28 10:58AM
> EST 2000.  If I convert 949075089 using the formula given in MRTG's doc
> logfile-format I get a different result.  If I convert it with the formula
> that I listed I get the correct date/time.  Regardless of whether I use
> Excel, a calculator, or pen and paper.
> 
> If there may be some sort of problem with my Linux box that is causing this,
> feel free to point it out.
> 

The problem is different.
You answer something not related to the question.
Also, if you are referring to the MRTG docs, reread them.

I quote:

> Hi,
> 
> Is there any difficulties to migrate MRTG from NT to a Linux ?
> I want to keep all my *.log files
> 
> Regards,
> 
> Oliver somewhere in The Hague

No relation whatsoever to that formula.

And I quote again:
>          A.  The Unix timestamp (1.A) when the data on
>              this line was gathered.
> 
>              This timestamp may be converted in EXCEL by
>              using the following formula and choosing the
>              option for the "1904 base":
> 
>                     =(x+((365*66+17)*86400))/86400
> 
>              If the "1900 base" is selected, then change
>              the "66" value to "70".

*I* did *not* insert EXCEL here.

There are two problems with this formula:

1) It converts GMT times to GMT times.  You are somewhere in the U.S.
   and hence the 5/24 you use in your formula.  This is only valid when
   daylight saving is not (or: is) applied and only if you want to see
   your timezone.  For me, the formula as you provide is not right.

2) The formula adds a fixed number of leap days to the 66 or 70 years.
   This number is not correct anymore; it should be 19 nowadays, indeed.

   Perhaps the following formula will do:
   =(x+DATE(1970,1,1)-5/24) for timezones 5 hours west of Greenwich
   =(x+DATE(1970,1,1)+1/24) for Europe
   and so on.
-- 
   __________________________________________________________________
 / alex at slot.hollandcasino.nl                  alex at ergens.op.het.net \
| work                                                         private |
| My employer is capable of speaking therefore I speak only for myself |
+----------------------------------------------------------------------+

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:mrtg-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/mrtg