I’m looking to send all DHCP assignments over to a SQL database. Anyone have any examples? I’m not using freeradius we’re just simply logging the DHCP assignments for documentation in case authorities come looking for a specific mac address at a specific time. I’ve been scouring Google for the last couple days and everything is freeradius but thats not what I’m looking for.
Do you want the lookup to decide what MAC gets what address? Or simply to shoot out a message to say the router has given out the address?
If the latter, set up a log file rule for DHCP topics out to specific file, each night have external server FTP/SFTP in and take the file for logfile analysis.
The only other options really would be to have your SQL server the back end to something else that talks the RADIUS protocol.