Vouchers reported as used and expired, although they aren't



  • We have 70 voucher rolls in our voucher portal available.

    I have recently created a couple of new rolls and supplied the voucher codes to our end-users.

    They report that very often they receive the message that the voucher is already used and expired.
    I'm certain that the vouchers are only supplied once and the voucher has not been used before.

    Our logging is full with these messages:

    Jul 14 14:28:07 portal logportalauth[22155]: FAILURE: F2RsKTxKsfP, c4:d9:87:20:30:8c, 192.168.39.142, voucher expired
    Jul 14 14:28:11 portal logportalauth[21756]: F2RsKTxKsfP (48/406) already used and expired

    I don't have syslog enabled, so I cannot view historical logging.

    I have exported all vouchers rolls in use and have searched for the vouchers that have been reported not to be working (hundreds already) and the vouchers only appear in the voucher rolls once.

    I explicitly created a couple of new voucher rolls and supplied these vouchers. Even a lot of these vouchers also report they are already used an expired.
    I have also checked and these vouchers don't appear in other rolls and haven't been used before by other users.

    What could be the cause of this issue?

    Running pfSense 2.1.5-RELEASE (i386), built on Mon Aug 25 07:44:26 EDT 2014, FreeBSD 8.3-RELEASE-p16

    Vouchers sync not enabled.


  • Banned

    2.1.5 -> dead. Chime back if you have issues with 2.2.4



  • Were issues known with 2.1.5?
    Will this be resolved when upgrading to 2.2.4?



  • This
    @mreco:

    ….
    I don't have syslog enabled, so I cannot view historical logging.
    ....

    is NOT good - especially if you work with 'vouchers' etc.
    It is somewhat the proof for you that something is working - or not. You have 'nothing'.

    From what we (and you) see on this forum : your issue is unknown.
    And yes, your are not the only one working with vouchers.



  • In the meantime I have been testing a batch of vouchers.
    This was a new roll created and I just tested entering the vouchers on the portal page.

    Some of the codes just say 'voucher expired' and I'm sure they were never issued before.

    Is it somehow possible to see which vouchers in a roll are already used?
    By that I don't mean in the Captive Portal Status GUI, saying how many vouchers are used and active.
    I mean showing the actual roll of vouchers with at status?

    I have seen the active and used db files in /var/db, but how should these be interpreted?

    Please advice.


  • Banned

    Perhaps you might re-enable logging finally?!?!?!?!?!



  • Logging is enabled, but the version I have doesn't support log file enlargement and I don't have a syslog server available…

    How can I view the status of all voucher rolls, with an overview of which vouchers are expired and which are still valid?


  • Banned

    @mreco:

    the version I have doesn't support log file enlargement

    Eh???



  • After some time (and receiving a lot of incidents about users that report vouchers that are expired, although they aren't) I finally managed to upgrade our pfSense.

    I have created a clone of the VM, upgraded it to version 2.2.4 and have wiped all rolls. Then created a new roll of vouchers and started testing.

    On this system, no users are active.

    The following happens:

    • when I expire a code the appears in the logging: Aug 24 16:06:08 logportalauth[92658]: Zone: guest - CSPZsCnnRiJ (70/61) forced to expire
    • I then test the voucher again and it is indeed expired: Aug 24 16:06:12 logportalauth[92658]: Zone: guest - CSPZsCnnRiJ (70/61) already used and expired
    • when looking in the roll view in the GUI it shows 8 vouchers of this roll are used, instead of one! (see screenshot 1)
    • trying the next voucher in the roll says: Aug 24 16:13:41 logportalauth[61087]: Zone: guest - hDvRKFaqvqm (70/53) already used and expired
    • expiring another voucher: Aug 24 16:17:42 logportalauth[61087]: Zone: guest - muhaudiXxhj (70/293) forced to expire
    • now the roll view in the GUI shows 37 vouchers are used, instead of only two! (see screenshot 2)

    So it looks like more than one voucher code is marked as used when one is expired.

    This is the logfiles with our tests:

    Aug 24 16:06:08 logportalauth[92658]: Zone: guest - CSPZsCnnRiJ (70/61) forced to expire
    Aug 24 16:06:12 logportalauth[92658]: Zone: guest - CSPZsCnnRiJ (70/61) already used and expired
    Aug 24 16:13:41 logportalauth[61087]: Zone: guest - hDvRKFaqvqm (70/53) already used and expired
    Aug 24 16:16:19 logportalauth[61087]: Zone: guest - m4DeJG7EYrV (70/45) already used and expired
    Aug 24 16:17:08 logportalauth[61087]: Zone: guest - fjRWvZuqATw (70/37) already used and expired
    Aug 24 16:17:42 logportalauth[61087]: Zone: guest - muhaudiXxhj (70/293) forced to expire

    Only these codes were forced to expire: CSPZsCnnRiJ and muhaudiXxhj.
    As you can see other codes are also reported as used and expired.





Log in to reply