Cp/freeradius db files type?

  • Hi.

    Simple question, what type of file cp use to store his info?


    And the same thing but for freeradius?


    How can I read the info in my console?



    This is if you have set an "amount of time" on freeradius –> users
    These files are created by freeradius. They are independent from CP.

    Freeradius seems to use one of these databases:

    db3-3.3.11_3,1      The Berkeley DB package, revision 3.3
    db41-4.1.25_4      The Berkeley DB package, revision 4.1
    db42-4.2.52_5      The Berkeley DB package, revision 4.2

  • Hi.

    I had try to read the files using db_ tools but db-tools had not been able to read the files:

    db41_dump185 db.daily
    db_dump185: db.daily: Inappropriate file type or format

    db41_dump db.daily
    db_dump: db.daily: unexpected file type or format
    db_dump: open: db.daily: Invalid argument

    file db.daily
    db.daily: data

    This are really Berkeley files? Or I'm not using the tools right?

    CP use text files no issue.


  • Not sure if the files contain any (useful) content by default. I never tried that.

  • Once u setup users, users login, those have info, but if cat the file it show u a lot garbage that I cannot understand.

  • Those looks like they are not berkeley type, check this:

    /usr/share/misc(10): file termcap.db
    termcap.db: Berkeley DB 1.85 (Hash, version 2, native byte-order)

    Now fr2.

    file /var/log/radacct/timecounter/db.daily
    /var/log/radacct/timecounter/db.daily: data

    or I'm wrong???

  • It seems that it is something special for freeradius. I found this on the web:

    > Looking at that debug, where exactly is it resetting the counter ?
      The "counter" module is resetting the counter.
    > In the db.daily ?  Because it's not resetting in SQL.
      Yes, the counter module doesn't say it's using SQL.
    > Also what is the db.daily ?  How do you read that file ?
      You don't.  Its used by the counter module to keep it's count.
    > What I'm trying to achieve here is to get mysql to reset the counters
    > its doing, and then start a new row if possible.
    > Within the table radacct.  AcctInputOctets AcctOutputOctets.
    > Is it possible to do this ?
    > Does the counter actually do that ?
      You want sqlcounter.
      Alan DeKok. 


Log in to reply