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

    Zabbix proxy on pfsense

    pfSense Packages
    3
    5
    2.4k
    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.
    • R
      rajbps
      last edited by

      Hi Team,

      I have pfsense installed all up to date. I have zabbix proxy and agent installed , the TLS package and was working fine. Now all of sudden I get this error :

      80822:20170109:123436.959 [Z3005] query failed: [0] database disk image is malformed [insert into proxy_history (itemid,clock,ns,value) values (26676,1483965276,44232840,'1658526404');
      ]

      I have tried to remove and reinstalled but still no joy.

      Could anyone assist please?

      Rajbps

      1 Reply Last reply Reply Quote 0
      • jahonixJ
        jahonix
        last edited by

        Just a wild guess: your disk is not full, is it?

        1 Reply Last reply Reply Quote 0
        • R
          rajbps
          last edited by

          that`s the output of df -h

          /root: df -h
          Filesystem        Size    Used  Avail  Capacity  Mounted on
          /dev/ad4s1a    59G    3.7G    50G    7%        /
          devfs                1.0K    1.0K      0B    100%      /dev
          /dev/md0          3.4M  132K    3.0M    4%      /var/run
          devfs                1.0K    1.0K      0B    100%      /var/dhcpd/dev

          1 Reply Last reply Reply Quote 0
          • R
            rajbps
            last edited by

            Ok sorted the issue myself. Here is the solution for anyone that might have the same issue.
            Go to
            /var/db/zabbix-proxy-lts
            there should be a db file there called : proxy.db

            Go to the gui and disable zabbix proxy, then rename that db file to proxy.db.old.

            Now enable zabbix proxy again. This will recreate a new db file without the corruption.

            This worked for me at least.

            Rajbps

            1 Reply Last reply Reply Quote 0
            • B
              bbrendon
              last edited by

              I was going to reply with that. Glad you found it.

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