Cp/freeradius db files type?
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
I had try to read the files using db_ tools but db-tools had not been able to read the files:
db_dump185: db.daily: Inappropriate file type or format
db_dump: db.daily: unexpected file type or format
db_dump: open: db.daily: Invalid argument
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)
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.