Cp/freeradius db files type?

[periko]

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!!!

[Nachtfalke]

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

[periko]

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!!!

[Nachtfalke]

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

[periko]

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

[periko]

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???

[Nachtfalke]

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