Cp/freeradius db files type?



  • Hi.

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

    captiveportal.db
    captiveportal_radius.db

    And the same thing but for freeradius?

    db.daily
    db.weekly

    How can I read the info in my console?

    Thanks!!!



  • 
    db.daily
    db.weekly
    
    

    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.

    Thanks!!!



  • 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. 
    
    

    http://freeradius.1045715.n5.nabble.com/sql-counter-clarification-and-issues-td2741790.html


Locked