LightSquid, Captive Portal Codes as User



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


Log in to reply