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