Hi QBik,
I'm currently reading the HISTORY.DBF file with my own software to get traffic per client(by IP).
My program does the following +- every 2 minutes:
1)Using Borland's BDE it opens the HISTORY.DBF file
2)Check for new records
3)Add the traffic into my own DB
4)Delete used records from HISTORY.DBF
5)Close the DB file
But every day or two, the server hangs completely & I have to drive there & reset it, delete History files & reboot to get it up & running again. I've changed hardware, re-installed XPPro, upgarded Firmware, drivers, Wingate (6.2) but the problem just wouldn't go away. The only thing I can think is that maybe me sharing the history.dbf while it is busy might cause the server to hang.
Please QBik, help me out here. I need current traffic logs and cannot parse the log files once a day. I also cannot use users+authentication as it would be an administrative nightmare for us. Wingate is setup with NAT/ENS & proxy with no users/authentication with 100 user license.
So I guess my questions would be:
1) Would you consider it safe to read the history file like I'm doing?
2) If so, which library would you recommend if Borland's BDE might be causing problems?
3) If not, how can I get current logs from Wingate into an external app? I'm a developer so can write anything necessary. Is it possible to write a plugin for Wingate that can get this info?
4) As a last resort, how can I make wingate to rotate log files, say every few minutes instead of once a day?
Please help me out here, I'm an old Wingate user with 70+ clients using the Internet 24/7 that doesn't like the server hanging every now and again.
Ekkas