Dialup Usage listing incorrect

[rghering]

Hello, We upgraded our radius server from cistron to freeradius
now our time usage from mysql import is incorrect. WAY incorrect users that showed average usage of like 30 to 50 hours now show 500+ hours , however call detail IS correct. What can I do to fix this up and also how to I remove the usage
thats been imported for ALL users over the last few months ?

Thanks
Ryan Ghering

[digitalpoint]

If you are importing the usage via SQL statements, you will want to edit them for your new table structure in Maintenance & Preferences -> General Preferences -> Usage -> SQL Hooks

You can remove existing usage by searching for it with the Search button on any customer's Usage screen (a date range of 1/1/2004...1/31/2004 for example would bring up January's usage). The resulting list will have a Delete All option.

[rghering]

We have edit for the table changes when we switched over the changes were very minor.
Does anyone have a sql hook example that they are using with freeradius ?
mabey we have something wrong.

Thanks
Ryan

[digitalpoint]

Have you tried running the SQL statement you are using to pull usage outside of Optigold?