On Sunday 24 November 2002 16:17, Jason Lixfeld wrote: > I've just upgraded to 0.8 and have found various errors in my log > telling me that the op field for various attributes is NULL or > non-existent: > > Error: rlm_sql: The 'op' field for attribute 'Framed-IP-Address = > 192.168.0.1' is NULL, or non-existent. > > I've cross referenced the `describe rad(check | reply);` output from > that of the 0.8 sql schema and there are differences, obviously. The error messages you see were added so that people would be informed that something was not setup correctly and fix the problem. If you do a 'select * from rad(check|reply);', are there any op fields that are NULL? If so, they need to be fixed in order for the error messages to go away.
> My current radius database was created from the schema from 0.6 with no > customizations. I'm wondering if anyone knows what the effects would be > if I re-ran the current schema against the existing database. Would it > break everything or would it do what one would hope; update the > differences and keep the data intact? You shouldn't have any problems using the latest schema. The major change was to make sure the op field was never NULL. If you want to apply the changes made to the schema, instead of dropping and rebuilding the table, read about the 'alter table' syntax in mysql documentation. Kevin Bonner - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
