Re: [Openvpn-users] Stats from logs

[Sunny Gaurav Bharel <snmpwalker@xxxxxxxxx>]

I do it..

Use awk/grep to format the log or u can even use perl.
then save the formatted file seperately and have mysql
perform sum querries on it .

I provide the total time and frequency of each user
who connected to the VPN / day from the querries i
wrote..

the awk/grep and perl formatted file shud b smthin
that tells u when someone connected n when he logged
out...

catch "connection initiated" to know when someone
logged in..

and catch "inactivity" to check when he logged out...

hope this helps...
I have mysql querries too, if u r interested.


Sunny Bharel
Linux Systems Administrator
HCL Infinet Ltd.
INDIA
--- Paulo Andre <pandre@xxxxxxxxxxxxxxx> wrote:

> I rotate the log files monthly, I am wondering if
> someone has any type
> of script to create stats from the logs.
> I would like to know how many times users have
> logged in and for how long.
> 
> Is this something that has been written before or
> would I have to try
> and work on something new?
> 
> Paulo
> 
> 
>
-------------------------------------------------------
> This SF.Net email is sponsored by Yahoo.
> Introducing Yahoo! Search Developer Network - Create
> apps using Yahoo!
> Search APIs Find out how you can build Yahoo!
> directly into your own
> Applications - visit
>
http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
> _______________________________________________
> Openvpn-users mailing list
> Openvpn-users@xxxxxxxxxxxxxxxxxxxxx
>
https://lists.sourceforge.net/lists/listinfo/openvpn-users
> 



	

	
		
__________________________________________________________
Free antispam, antivirus and 1GB to save all your messages
Only in Yahoo! Mail: http://in.mail.yahoo.com

____________________________________________
Openvpn-users mailing list
Openvpn-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/openvpn-users