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

    How to access MySql/Sqlite database from pfsense shell?

    Scheduled Pinned Locked Moved Development
    4 Posts 3 Posters 3.7k 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.
    • M
      Mahendra
      last edited by

      Hi,

      I tried to open captiveportal_radius.db file with Sqlite Browser but its showing file is corrupted or encrypted, so kindly help me out in how to connect mysql/sqlite database from PFSense shell or the correct method access tables structure.

      Thanks in Advance !

      1 Reply Last reply Reply Quote 0
      • marcellocM
        marcelloc
        last edited by

        Ckeck if it's a text or an sqlite2 file.

        Treinamentos de Elite: http://sys-squad.com

        Help a community developer! ;D

        1 Reply Last reply Reply Quote 0
        • M
          Mahendra
          last edited by

          No.. it's a ".db" file.

          1 Reply Last reply Reply Quote 0
          • jimpJ
            jimp Rebel Alliance Developer Netgate
            last edited by

            On 2.0.x and before, and on 2.1 up until late December, that's just a normal text file not a special database file.

            On recent 2.1 snapshots it is actually an sqlite database.

            Remember: Upvote with the 👍 button for any user/post you find to be helpful, informative, or deserving of recognition!

            Need help fast? Netgate Global Support!

            Do not Chat/PM for help!

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