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

Captive Portal Voucher DB issue

Scheduled Pinned Locked Moved Captive Portal
5 Posts 3 Posters 738 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.
  • W
    wazim4u
    last edited by Jan 11, 2021, 6:55 PM

    I have recently upgraded 2.5 Development version to latest 2.5.0.a.20210107.2142 got issue with Voucher DB from one roll all active voucher marked as used. there was another issue that active users vs active voucher has big difference. Unable to understand this. I even did full backup and tried to backup from XML backup file still same.

    Active Users.jpg

    Active Vouchers.png

    Rolls.jpg

    G 1 Reply Last reply Jan 14, 2021, 10:50 AM Reply Quote 0
    • G
      Gertjan @wazim4u
      last edited by Jan 14, 2021, 10:50 AM

      @wazim4u said in Captive Portal Voucher DB issue:

      I even did full backup and tried to backup from XML backup file still same.

      The 2.4.5-p1 version uses DB files to store which roll/voucher has a usage records.
      This information is not stored in the config (xml) file.
      If I recall well, hese file should be backup in parallel with the config, and restored together.

      Dono if the 2.5.0 dev version works the same way, so better check this out.

      @wazim4u said in Captive Portal Voucher DB issue:

      there was another issue that active users vs active voucher has big difference

      The two images lists the same vouchers <=> users.

      No "help me" PM's please. Use the forum, the community will thank you.
      Edit : and where are the logs ??

      W 1 Reply Last reply Jan 15, 2021, 10:50 PM Reply Quote 0
      • W
        wazim4u @Gertjan
        last edited by Jan 15, 2021, 10:50 PM

        @gertjan I copied db files as well. XML only takes the lists of vouchers then manually you have to copy the db files to db directory. Whenever upgraded never worked properly. there should be option to download vouchers database from backup page or it should make zip file including XML & voucher database files.

        V 1 Reply Last reply Feb 3, 2021, 2:41 PM Reply Quote 0
        • V
          viktor_g Netgate @wazim4u
          last edited by Feb 3, 2021, 2:41 PM

          @wazim4u unable to reproduce your issue - I can successfully backup/restore Captive Portal Vouchers + Vouchers DB (extra data checkbox) on pfSense 2.5.0.a.20210202.2250

          Could you provide more info about your configuration?

          W 1 Reply Last reply Feb 17, 2021, 2:30 PM Reply Quote 0
          • W
            wazim4u @viktor_g
            last edited by Feb 17, 2021, 2:30 PM

            @viktor_g There was issue with HDD and I've replaced it with SSD and now everything works fine. Vouchers backup is working properly.

            1 Reply Last reply Reply Quote 1
            • First post
              Last post
            Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.
              [[user:consent.lead]]
              [[user:consent.not_received]]