Re: (RADIATOR) Logfile size

1999-06-03 Thread Stephan Forseilles

On 6/3/99 at 7:43 AM Mike McCauley wrote:

>Hi Ryan,
>
>On Jun 2, 11:51am, ryanm wrote:
>> Subject: (RADIATOR) Logfile size
>> Hello everyone,
>>
>> I am curious what size my daily logfiles will be with 1+ logins
>> a day. I am doing some capicity planning and want to add a couple
>> disks to store logging info on. I would appreciate any average
>> sizes you have. I have looked at the entries in the detail log
>
>That logic seems quite reasonable. I have seen similar numbers elsewhere. I
>would certainly advocate compression too.

IMHO, compression has a major drawback: it make the files difficult to search in. If 
you want to give your users a way to check their connection statistics online, this is 
a problem. Note that even without compression, making an fgrep in a 250MB file to get 
the statistics for a given login out of it can be a killer for the server, specially 
of you have lots of users making statistics requests through the web. But... without 
going as far as putting everything in a database (yeah, I know I can be a PITA with my 
database stuff :)), there's a way to compress data and let it 'searchable': just pass 
it through a filter and put everything in a more compact format (for example, change 
plain text dates to a Unix timestamp, ...). I think part of this can already be done 
by a proper configuration of the logging options of Radiator, but I can't advice on 
that as I don't use text logging.

Stephan
*
** Stephan Forseilles - Operations Director
** Belgacom Skynet SA/NV
** Email [EMAIL PROTECTED]
** Tel: +32 2 706 13 11 Fax: +32 2 726 93 11
*


ÿ
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Logfile size

1999-06-03 Thread Stephan Forseilles

On 6/2/99 at 4:54 PM Jason Godsey wrote:

>-rw-r-  1 root  wheel   15470156 Feb 28 23:59 detail.1999.02.gz
>-rw-r-  1 root  wheel   17094556 Mar 31 23:59 detail.1999.03.gz
>-rw-r-  1 root  wheel   17061311 Apr 30 23:59 detail.1999.04.gz
>-rw-r-  1 root  wheel  257358389 May 31 23:59 detail.1999.05
>-rw-r-  1 root  wheel   14702947 Jun  2 16:46 detail.1999.06
>
>We have 2.5k dialup users.  Looks like about 8megs/day.  Looks like you'll
>need much more than 2 20gig drives to keep a years worth :) (you'll need
>that for just 2 months) Each month will eat nearly 30megs if our numbers
>scale.

If you use a DB (datawarehouse type) you can purge all unnecessary data and only keep 
what's vital in a compacted format. We have 120K diakup users and have something like 
6GB for 7 months.

Stephan
*
** Stephan Forseilles - Operations Director
** Belgacom Skynet SA/NV
** Email [EMAIL PROTECTED]
** Tel: +32 2 706 13 11 Fax: +32 2 726 93 11
*


ÿ
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Logfile size

1999-06-02 Thread Jason Godsey



-rw-r-  1 root  wheel   15470156 Feb 28 23:59 detail.1999.02.gz
-rw-r-  1 root  wheel   17094556 Mar 31 23:59 detail.1999.03.gz
-rw-r-  1 root  wheel   17061311 Apr 30 23:59 detail.1999.04.gz
-rw-r-  1 root  wheel  257358389 May 31 23:59 detail.1999.05
-rw-r-  1 root  wheel   14702947 Jun  2 16:46 detail.1999.06

We have 2.5k dialup users.  Looks like about 8megs/day.  Looks like you'll
need much more than 2 20gig drives to keep a years worth :) (you'll need
that for just 2 months) Each month will eat nearly 30megs if our numbers
scale.

- Jason Godsey

On Wed, 2 Jun 1999, ryanm wrote:

> Hello everyone,
> 
> I am curious what size my daily logfiles will be with 1+ logins
> a day. I am doing some capicity planning and want to add a couple
> disks to store logging info on. I would appreciate any average
> sizes you have. I have looked at the entries in the detail log
> and 1 login/logout is roughyl 800 bytes. I multiplies this out
> by 1 and got 8,000,000 so I am assuming roughly 10 Megs a day?? 
> I plan on archiving these for up to a year for various reasons so 
> was hoping to get 2 20 gig Disks to do this. I also plan on using 
> some form of compression scheme.
> 
> Thanks for any info anyone can get back to me,
> 
> Thanks again,
> 
> Ryan
> 
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
> 


===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Logfile size

1999-06-02 Thread Anton Sparrius

With roughly 3700 calls per day, our logfile (trace level 4) is roughly
6-6.5 meg, with the details file being slightly smaller, at about 5-5.5 meg
per day.  All our accounting we log into a database, but we also use the
standard logfiles just as a backup.

So for a month, these two log files account for about 300+ meg (getting
bigger every month).  Since we are running Radiator under NT, I just use
WinZip once a month to archive the logs, which brings them down to about 25
meg per month, which is not bad compression!

Regards,

Anton Sparrius
Chief Operations Officer
---
Smarter Wayhttp://www.smart.net.au
Email[EMAIL PROTECTED]
Phone  (03) 9846 1711
 Melb   1800-240-829
 Sydn   1800-888-761


- Original Message -
From: ryanm <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 03, 1999 1:51 AM
Subject: (RADIATOR) Logfile size


> Hello everyone,
>
> I am curious what size my daily logfiles will be with 1+ logins
> a day. I am doing some capicity planning and want to add a couple
> disks to store logging info on. I would appreciate any average
> sizes you have. I have looked at the entries in the detail log
> and 1 login/logout is roughyl 800 bytes. I multiplies this out
> by 1 and got 8,000,000 so I am assuming roughly 10 Megs a day??
> I plan on archiving these for up to a year for various reasons so
> was hoping to get 2 20 gig Disks to do this. I also plan on using
> some form of compression scheme.
>
> Thanks for any info anyone can get back to me,
>
> Thanks again,
>
> Ryan
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.


===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Logfile size

1999-06-02 Thread Mike McCauley

Hi Ryan,

On Jun 2, 11:51am, ryanm wrote:
> Subject: (RADIATOR) Logfile size
> Hello everyone,
>
> I am curious what size my daily logfiles will be with 1+ logins
> a day. I am doing some capicity planning and want to add a couple
> disks to store logging info on. I would appreciate any average
> sizes you have. I have looked at the entries in the detail log
> and 1 login/logout is roughyl 800 bytes. I multiplies this out
> by 1 and got 8,000,000 so I am assuming roughly 10 Megs a day??
> I plan on archiving these for up to a year for various reasons so
> was hoping to get 2 20 gig Disks to do this. I also plan on using
> some form of compression scheme.

That logic seems quite reasonable. I have seen similar numbers elsewhere. I
would certainly advocate compression too.

Cheers.

>
> Thanks for any info anyone can get back to me,
>
> Thanks again,
>
> Ryan
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from ryanm



-- 
Mike McCauley   [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985   Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, 
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Logfile size

1999-06-02 Thread Stephan Forseilles

On 6/2/99 at 11:51 AM ryanm wrote:

>Hello everyone,
>
>I am curious what size my daily logfiles will be with 1+ logins
>a day. I am doing some capicity planning and want to add a couple
>disks to store logging info on. I would appreciate any average
>sizes you have. I have looked at the entries in the detail log
>and 1 login/logout is roughyl 800 bytes. I multiplies this out
>by 1 and got 8,000,000 so I am assuming roughly 10 Megs a day?? 
>I plan on archiving these for up to a year for various reasons so 
>was hoping to get 2 20 gig Disks to do this. I also plan on using 
>some form of compression scheme.

Ryan,

If they grow that big, I'd advice you to go to database logging. Currently we log 
temporarily to a MySQL and we have a deamon continously emptying that DB and feeding 
everything into a data warehouse (Sybase based). This lets us keep stats for more than 
a year (we make 1 table per month, something like 7 or 800 megs/month), have always 
handy summaries tables at hand (updated by the deamon), only keep data we want (there 
are some irrelevant data in a radius accounting packet dump), get rid of the STARTs 
and ALIVEs (make session reconstruction), ... Also, this deamon lets us make some 
nifty things such as for exemple send an email to all customers of a given POP several 
seconds after they connect (when it cleans the START), send our newsletter, and so on.

File-based logging will never give you the scalability you'd like to have. Big files 
tend to make systems slow, are unmanageable, difficult to search, difficult to backup 
(ever tried to backup a growing file? Works far better with a DB :))... Speaking of a 
database, there's almost no size limit. You just have to throw disks at it and don't 
have to worry about filesystem problems (if you go for any serious DB engine, I 
definitely prefer to let them format the FS and use the raw device, far faster).

Just my two cents.

Stephan
*
** Stephan Forseilles - Operations Director
** Belgacom Skynet SA/NV
** Email [EMAIL PROTECTED]
** Tel: +32 2 706 13 11 Fax: +32 2 726 93 11
*


ÿ
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.