Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Cp/freeradius db files type?

    Scheduled Pinned Locked Moved Captive Portal
    7 Posts 2 Posters 2.8k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • perikoP
      periko
      last edited by

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

      Necesitan Soporte de Pfsense en México?/Need Pfsense Support in Mexico?
      www.bajaopensolutions.com
      https://www.facebook.com/BajaOpenSolutions
      Quieres aprender PfSense, visita mi canal de youtube:
      https://www.youtube.com/c/PedroMorenoBOS

      1 Reply Last reply Reply Quote 0
      • N
        Nachtfalke
        last edited by

        
        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

        1 Reply Last reply Reply Quote 0
        • perikoP
          periko
          last edited by

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

          Necesitan Soporte de Pfsense en México?/Need Pfsense Support in Mexico?
          www.bajaopensolutions.com
          https://www.facebook.com/BajaOpenSolutions
          Quieres aprender PfSense, visita mi canal de youtube:
          https://www.youtube.com/c/PedroMorenoBOS

          1 Reply Last reply Reply Quote 0
          • N
            Nachtfalke
            last edited by

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

            1 Reply Last reply Reply Quote 0
            • perikoP
              periko
              last edited by

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

              Necesitan Soporte de Pfsense en México?/Need Pfsense Support in Mexico?
              www.bajaopensolutions.com
              https://www.facebook.com/BajaOpenSolutions
              Quieres aprender PfSense, visita mi canal de youtube:
              https://www.youtube.com/c/PedroMorenoBOS

              1 Reply Last reply Reply Quote 0
              • perikoP
                periko
                last edited by

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

                Necesitan Soporte de Pfsense en México?/Need Pfsense Support in Mexico?
                www.bajaopensolutions.com
                https://www.facebook.com/BajaOpenSolutions
                Quieres aprender PfSense, visita mi canal de youtube:
                https://www.youtube.com/c/PedroMorenoBOS

                1 Reply Last reply Reply Quote 0
                • N
                  Nachtfalke
                  last edited by

                  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

                  1 Reply Last reply Reply Quote 0
                  • First post
                    Last post
                  Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.