Ad Widget

Collapse

tryinig to setup Zabbix proxy on openWRT with postgres DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mikkiblue
    Junior Member
    • Jan 2023
    • 5

    #1

    tryinig to setup Zabbix proxy on openWRT with postgres DB

    I am tryinig to setup Zabbix proxy on openWRT (GL.iNET) with postgres DB. In GL.iNET repository there is only Zabbix version 4.0.16-3 vailable, but without zabbix-sql-scripts.
    How can I get proxy.sql for this release?

    I've used the latest and get the following error when starting the proxy:
    The proxy does not match Zabbix database. Current database version (mandatory/optional): 06020000/06020013. Required mandatory version: 04000000.​
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    Find a suitable package from zabbix repo, extract needed scripts... http://repo.zabbix.com/zabbix/4.0/ I dont know what kind of packages openwrt uses..

    Comment

    • Hamardaban
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • May 2019
      • 2713

      #3
      if the installed proxy uses the sqlite database, then it is enough to stop the service, delete the database file and start the service again.
      Database of the required version will be created.

      Comment

      • mikkiblue
        Junior Member
        • Jan 2023
        • 5

        #4
        Originally posted by Hamardaban
        if the installed proxy uses the sqlite database, then it is enough to stop the service, delete the database file and start the service again.
        Database of the required version will be created.
        How can I configure zabbix_proxy to use SQLite database? I have dropped the postgress db, and set some path to a database file, but not shure if it will outomatically detect the right DB. Logs say ' connection to database <path to db> failed FATAL: database <path to db> does not exist. I've already tried both, without file, and with a file created by sqlite3 dommand.

        Comment

        • Hamardaban
          Senior Member
          Zabbix Certified SpecialistZabbix Certified Professional
          • May 2019
          • 2713

          #5
          I'm sorry - I inattentively read the title of the topic and did not pay attention to what the database type is written there.
          In your case, you need to find in the distributions a script for creating a database exactly for your version (as cyber wrote)

          Comment

          • mikkiblue
            Junior Member
            • Jan 2023
            • 5

            #6
            Originally posted by cyber
            Find a suitable package from zabbix repo, extract needed scripts... http://repo.zabbix.com/zabbix/4.0/ I dont know what kind of packages openwrt uses..
            How can I view those files in folder .db?

            Comment

            Working...