Cp/freeradius db files type?
-
Hi.
Simple question, what type of file cp use to store his info?
captiveportal.db
captiveportal_radius.dbAnd the same thing but for freeradius?
db.daily
db.weeklyHow 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 formatdb41_dump db.daily
db_dump: db.daily: unexpected file type or format
db_dump: open: db.daily: Invalid argumentfile db.daily
db.daily: dataThis 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: dataor 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