|
|
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 |