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

    LightSquid, Captive Portal Codes as User

    Scheduled Pinned Locked Moved Cache/Proxy
    1 Posts 1 Posters 548 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.
    • E
      eviltrooper
      last edited by

      Hello,

      is it possible to get the Voucher Codes see as username an not the IP Adresse in Lightsquid?

      on my old pfsense 2.0.3 i uses an script, this script read th captiveportal.db

      it looks like this the captivepotal.db

      1482842376,762,10.21.41.238,7c:b0:c2:b5:2f:6b,vBtFcEvZxZH,b168542c0e1a70f2,,3597440,,0
      

      on the new 2.3.2 it looks like this:

      ‹V'uindexstarttimecaptiveportalCREATE INDEX starttime ON captiveportal (allow_time)@'WindexipcaptiveportalCREATE INDEX ip ON captiveportal (ip)J'gindexusercaptiveportalCREATE INDEX user ON captiveportal (username)i!'indexidx_activecaptiveportalCREATEUNIQUE INDEX idx_active ON captiveportal (sessionid, username)‚!''„tablecaptiveportalcaptiveportalCREATE TABLE captiveportal (allow_time INTEGER, pipeno INTEGER, ip TEXT, mac TEXT, username TEXT, sessionid TEXT, bpassword TEXT, session_timeout INTEGER,”‡ã'ð10.102.0.11e4:7f:b2:18:80:79XBYveiALbsj3ba02343a3efb75b3…°voucherl INTEGER, radiusctx TEXT)
      ßß -%   ba02343a3efb75b3XBYveiALbsj3
      ðð%     XBYveiALbsj3
      ññ#     10.102.0.11
      

      it seems that it is an sql database now :(

      how can i get the voucher codes see in my lightSquid and not the IP Adress

      ?? an ideas?

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