Ad Widget

Collapse

Zabbix Server Upgrade from 6.4 to 7

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Lewis Wiltshire
    Member
    • May 2024
    • 33

    #1

    Zabbix Server Upgrade from 6.4 to 7

    Having some issues updating DB for zabbix.

    Everything else has updated fine but the DB is failing to update. Please see the Web GUI error below

    Click image for larger version

Name:	Screenshot 2024-07-17 134648.png
Views:	1279
Size:	10.8 KB
ID:	487672

    Please can someone help
  • Markku
    Senior Member
    Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
    • Sep 2018
    • 1782

    #2
    Hi, note that this error is from the frontend, not from Zabbix server service. You need to restart the zabbix-server service manually after upgrade. See zabbix_server.log for information about the startup and upgrade process completion.

    Markku

    Comment

    • Lewis Wiltshire
      Member
      • May 2024
      • 33

      #3
      Originally posted by Markku
      Hi, note that this error is from the frontend, not from Zabbix server service. You need to restart the zabbix-server service manually after upgrade. See zabbix_server.log for information about the startup and upgrade process completion.

      Markku
      I have rebooted the server and still get the same message.

      Comment

      • Lewis Wiltshire
        Member
        • May 2024
        • 33

        #4
        See the logs

        Click image for larger version

Name:	image.png
Views:	1243
Size:	44.0 KB
ID:	487681

        Comment

        • Jason
          Senior Member
          • Nov 2007
          • 430

          #5
          That is saying your database isn't running. Take a look at postgres and see what is going on there.

          Comment

          • Lewis Wiltshire
            Member
            • May 2024
            • 33

            #6
            Originally posted by Jason
            That is saying your database isn't running. Take a look at postgres and see what is going on there.
            The database is running. We use a mysql database for the server. Do we need to change this? or update this?

            Click image for larger version

Name:	image.png
Views:	1250
Size:	38.5 KB
ID:	487688

            Comment

            • Markku
              Senior Member
              Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
              • Sep 2018
              • 1782

              #7
              The error message talks about port 5432, which is used for PostgreSQL. Please ensure that you are using the correct zabbix-server-mysql package, and not the zabbix-server-pgsql one, if you are using MySQL database.

              Markku

              Comment

              • Lewis Wiltshire
                Member
                • May 2024
                • 33

                #8
                Originally posted by Markku
                The error message talks about port 5432, which is used for PostgreSQL. Please ensure that you are using the correct zabbix-server-mysql package, and not the zabbix-server-pgsql one, if you are using MySQL database.

                Markku
                Hi,

                The pgsql is not even installed?
                Click image for larger version

Name:	image.png
Views:	1249
Size:	13.2 KB
ID:	487694

                Comment

                • Markku
                  Senior Member
                  Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
                  • Sep 2018
                  • 1782

                  #9
                  sudo grep -v -E "^(#|$)" /etc/zabbix/zabbix_server.conf

                  Markku

                  Comment

                  • Lewis Wiltshire
                    Member
                    • May 2024
                    • 33

                    #10
                    Originally posted by Markku
                    sudo grep -v -E "^(#|$)" /etc/zabbix/zabbix_server.conf

                    Markku
                    see attached

                    Click image for larger version

Name:	image.png
Views:	1245
Size:	30.8 KB
ID:	487697

                    Comment

                    • Markku
                      Senior Member
                      Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
                      • Sep 2018
                      • 1782

                      #11
                      dpkg -l zabbix\*

                      Markku

                      Comment

                      • Lewis Wiltshire
                        Member
                        • May 2024
                        • 33

                        #12
                        Originally posted by Markku
                        dpkg -l zabbix\*

                        Markku
                        see attached
                        Click image for larger version

Name:	image.png
Views:	1246
Size:	53.1 KB
ID:	487700

                        Comment

                        • Markku
                          Senior Member
                          Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
                          • Sep 2018
                          • 1782

                          #13
                          What's your personal idea, why would your Zabbix server (zabbix-server-mysql) try to connect to PostgreSQL server port 5432, as you told us it was still doing after the server reboot?

                          Markku

                          Comment

                          • Lewis Wiltshire
                            Member
                            • May 2024
                            • 33

                            #14
                            We have been trying to update from 6.4 to 7.0 LTS but then we got this when the update was complete.

                            Comment

                            • Markku
                              Senior Member
                              Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
                              • Sep 2018
                              • 1782

                              #15
                              sudo systemctl stop zabbix-server
                              sudo apt purge zabbix-server-mysql zabbix-server-pgsql
                              sudo apt install zabbix-server-mysql
                              sudo systemctl start zabbix-server


                              Markku

                              Comment

                              Working...