Hi,
I have a cloud core router which is acting as DHCP server serving thousands of clients, i want that when a new lease is added it update my mysql table and when lease time expires it update mysql table so the record can be moved.
I have done it with api in php but it fetchs all thounsand of records at one and i have to update all thousands of records to view latest lease records.
I want scripting in mikrotik that interact with external php server to store data in mysql table:
example on new lease run the script:
http:// external-server .com/update-lease-table.php?action=add_new_record&ip=something&mac=something
example on lease expire run the script:
http:// external-server .com/update-lease-table.php?action=delte_ols_record&ip=something&mac=something