Dialup Usage listing incorrect

Discussion in 'Optigold ISP' started by rghering, Jul 7, 2004.

0
  1. #1
    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
     
    rghering, Jul 7, 2004 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    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.
     
    digitalpoint, Jul 7, 2004 IP
  3. rghering

    rghering Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    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
     
    rghering, Jul 7, 2004 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    Have you tried running the SQL statement you are using to pull usage outside of Optigold?
     
    digitalpoint, Jul 7, 2004 IP