I need to read dhcpdlog file into databs

[Anon]

Hi all

I want to parse the dhcpdlog file on a Slackware box into a MySQL database as I need to be able to cross reference between IPs and MAC addresses - information which is in that log file.

I can't seem to find much info on getting log files into databases tho. I can't do a an fopen on the log file as I get permission denied - is this becuase of the permissions of PHP or do I need to rotate log files?

Any pointers appreciated!

[Anon]

Well, if you're not allowed to read the file, you're pretty much stuck, aren't you? :-)

PHP usually runs with very restricted permissions, for obvious reasons; if it's an Apache module, then Apache's are the permissions it runs with - and do you want every man and his dog to be able to poke through your logfiles?

If you've compiled PHP as a CGI, you could write the script and run it from the command line as a user that does have permission to read the logfiles.

This is the sort of job Perl was invented for...

[Anon]

Thanks for the answer. I am prtty new at this having never touched a Linux server until a couple of months ago, so I am stilla little "imaginative" in what I try to do I guess. It makes sense that we don't want PHP to be able to run about willy-nilly displaying log files I guess.

Thanks