Yall - I wrote these two little perl scripts to help me manage my postgesql radius database. I figured that someone my find them useful. Anybody can do anything they want with them.
I'll try to explain them: uh, I wanted to make an abstract mapping between the VSA names, the database fields and actions resulting from the arrival of start or stop records. This is the fields file. It's tab delimited. After that it should be pretty self explanatory. After I had created that file, I created the schema.pl program. It uses this fields file and generates the database schema as well the queries that radius should use. Lastly I created the load.pl program. It also uses the fields file, but to load a radius "detail" log file and insert the records into the database. (it can do this because it knows your mapping between VSA names and database fields. get it?) I hope the small attachment is ok here. Please ask if you have any questions. - Gabriel Russell __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/
schema_tools.tar.gz
Description: schema_tools.tar.gz
