Solved pkg upgrade done wrong on Zabbix

Hi all,

I run the following to keep the system updated
Code:
root@bunker:~ # pkg upgrade
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Checking for upgrades (11 candidates): 100%
Processing candidates (11 candidates): 100%
Checking integrity... done (21 conflicting)
  - php74-session-7.4.10 conflicts with php72-session-7.2.33 on /usr/local/include/php/ext/session/php_session.h
  - php74-7.4.10 conflicts with php72-7.2.33 on /usr/local/bin/php
  - php74-7.4.10 conflicts with php72-hash-7.2.33 on /usr/local/include/php/ext/hash/php_hash.h
  - php74-xmlwriter-7.4.10 conflicts with php72-xmlwriter-7.2.33 on /usr/local/include/php/ext/xmlwriter/config.h
  - php74-xmlreader-7.4.10 conflicts with php72-xmlreader-7.2.33 on /usr/local/include/php/ext/xmlreader/config.h
  - php74-xml-7.4.10 conflicts with php72-xml-7.2.33 on /usr/local/include/php/ext/xml/php_xml.h
  - php74-simplexml-7.4.10 conflicts with php72-simplexml-7.2.33 on /usr/local/include/php/ext/simplexml/php_simplexml.h
  - php74-dom-7.4.10 conflicts with php72-dom-7.2.33 on /usr/local/include/php/ext/dom/dom_ce.h
  - php74-ctype-7.4.10 conflicts with php72-ctype-7.2.33 on /usr/local/include/php/ext/ctype/config.h
  - php74-fileinfo-7.4.10 conflicts with php72-fileinfo-7.2.33 on /usr/local/include/php/ext/fileinfo/config.h
  - php74-filter-7.4.10 conflicts with php72-filter-7.2.33 on /usr/local/include/php/ext/filter/filter_private.h
  - php74-sockets-7.4.10 conflicts with php72-sockets-7.2.33 on /usr/local/include/php/ext/sockets/sendrecvmsg.h
  - php74-ldap-7.4.10 conflicts with php72-ldap-7.2.33 on /usr/local/include/php/ext/ldap/config.h
  - php74-snmp-7.4.10 conflicts with php72-snmp-7.2.33 on /usr/local/include/php/ext/snmp/php_snmp.h
  - php74-snmp-7.4.10 conflicts with php72-snmp-7.2.33 on /usr/local/include/php/ext/snmp/php_snmp.h
  - php74-bcmath-7.4.10 conflicts with php72-bcmath-7.2.33 on /usr/local/include/php/ext/bcmath/config.h
  - php74-gd-7.4.10 conflicts with php72-gd-7.2.33 on /usr/local/include/php/ext/gd/gd_compat.h
  - php74-json-7.4.10 conflicts with php72-json-7.2.33 on /usr/local/include/php/ext/json/php_json_encoder.h
  - php74-gettext-7.4.10 conflicts with php72-gettext-7.2.33 on /usr/local/include/php/ext/gettext/php_gettext.h
  - php74-mysqli-7.4.10 conflicts with php72-mysqli-7.2.33 on /usr/local/include/php/ext/mysqli/php_mysqli_structs.h
  - php74-mbstring-7.4.10 conflicts with php72-mbstring-7.2.33 on /usr/local/include/php/ext/mbstring/php_mbregex.h
Cannot solve problem using SAT solver, trying another plan
Checking integrity... done (0 conflicting)
The following 49 package(s) will be affected (of 0 checked):

Installed packages to be REMOVED:
        php72: 7.2.33
        php72-bcmath: 7.2.33
        php72-ctype: 7.2.33
        php72-dom: 7.2.33
        php72-fileinfo: 7.2.33
        php72-filter: 7.2.33
        php72-gd: 7.2.33
        php72-gettext: 7.2.33
        php72-hash: 7.2.33
        php72-json: 7.2.33
        php72-ldap: 7.2.33
        php72-mbstring: 7.2.33
        php72-mysqli: 7.2.33
        php72-session: 7.2.33
        php72-simplexml: 7.2.33
        php72-snmp: 7.2.33
        php72-sockets: 7.2.33
        php72-xml: 7.2.33
        php72-xmlreader: 7.2.33
        php72-xmlwriter: 7.2.33

New packages to be INSTALLED:
        php74: 7.4.10
        php74-bcmath: 7.4.10
        php74-ctype: 7.4.10
        php74-dom: 7.4.10
        php74-fileinfo: 7.4.10
        php74-filter: 7.4.10
        php74-gd: 7.4.10
        php74-gettext: 7.4.10
        php74-json: 7.4.10
        php74-ldap: 7.4.10
        php74-mbstring: 7.4.10
        php74-mysqli: 7.4.10
        php74-session: 7.4.10
        php74-simplexml: 7.4.10
        php74-snmp: 7.4.10
        php74-sockets: 7.4.10
        php74-xml: 7.4.10
        php74-xmlreader: 7.4.10
        php74-xmlwriter: 7.4.10

Installed packages to be UPGRADED:
        freetype2: 2.10.2 -> 2.10.2_1
        libxcb: 1.13.1 -> 1.14_1
        mbedtls: 2.16.7 -> 2.16.8
        net-snmp: 5.7.3_20,1 -> 5.9,1
        openntpd: 6.2p3_7,2 -> 6.2p3_8,2
        p5-HTTP-Message: 6.25 -> 6.26
        p5-IO-Tee: 0.65 -> 0.66

Installed packages to be REINSTALLED:
        pkg-1.15.4
        zabbix5-frontend-5.0.3 (direct dependency changed: php74-session)
        zabbix5-server-5.0.3 (needed shared library changed)

Number of packages to be removed: 20
Number of packages to be installed: 19
Number of packages to be upgraded: 7
Number of packages to be reinstalled: 3

The process will require 4 MiB more space.
7 MiB to be downloaded.

Proceed with this action? [y/N]: y
When I now log in to Zabbix, I get the following error
Code:
Configuration file error

    DB type "MYSQL" is not supported by current setup.
pkg info | grep php
Code:
mod_php72-7.2.33               PHP Scripting Language
php74-7.4.10                   PHP Scripting Language
php74-bcmath-7.4.10            The bcmath shared extension for php
php74-ctype-7.4.10             The ctype shared extension for php
php74-dom-7.4.10               The dom shared extension for php
php74-fileinfo-7.4.10          The fileinfo shared extension for php
php74-filter-7.4.10            The filter shared extension for php
php74-gd-7.4.10                The gd shared extension for php
php74-gettext-7.4.10           The gettext shared extension for php
php74-json-7.4.10              The json shared extension for php
php74-ldap-7.4.10              The ldap shared extension for php
php74-mbstring-7.4.10          The mbstring shared extension for php
php74-mysqli-7.4.10            The mysqli shared extension for php
php74-session-7.4.10           The session shared extension for php
php74-simplexml-7.4.10         The simplexml shared extension for php
php74-snmp-7.4.10              The snmp shared extension for php
php74-sockets-7.4.10           The sockets shared extension for php
php74-xml-7.4.10               The xml shared extension for php
php74-xmlreader-7.4.10         The xmlreader shared extension for php
php74-xmlwriter-7.4.10         The xmlwriter shared extension for php

Zabbix server log has nothing usefull but the apache error log has this :
Code:
PHP Warning:  PHP Startup: Unable to load dynamic library 'session.so' (tried: /usr/local/lib/php/20170718/session.so (Cannot open "/usr/local/lib/php/20170718/session.so"), /usr/local/lib/php/20170718/session.so.so (Cannot open "/usr/local/lib/php/20170718/session.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'bcmath.so' (tried: /usr/local/lib/php/20170718/bcmath.so (Cannot open "/usr/local/lib/php/20170718/bcmath.so"), /usr/local/lib/php/20170718/bcmath.so.so (Cannot open "/usr/local/lib/php/20170718/bcmath.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'ctype.so' (tried: /usr/local/lib/php/20170718/ctype.so (Cannot open "/usr/local/lib/php/20170718/ctype.so"), /usr/local/lib/php/20170718/ctype.so.so (Cannot open "/usr/local/lib/php/20170718/ctype.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'dom.so' (tried: /usr/local/lib/php/20170718/dom.so (Cannot open "/usr/local/lib/php/20170718/dom.so"), /usr/local/lib/php/20170718/dom.so.so (Cannot open "/usr/local/lib/php/20170718/dom.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'fileinfo.so' (tried: /usr/local/lib/php/20170718/fileinfo.so (Cannot open "/usr/local/lib/php/20170718/fileinfo.so"), /usr/local/lib/php/20170718/fileinfo.so.so (Cannot open "/usr/local/lib/php/20170718/fileinfo.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'filter.so' (tried: /usr/local/lib/php/20170718/filter.so (Cannot open "/usr/local/lib/php/20170718/filter.so"), /usr/local/lib/php/20170718/filter.so.so (Cannot open "/usr/local/lib/php/20170718/filter.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'gd.so' (tried: /usr/local/lib/php/20170718/gd.so (Cannot open "/usr/local/lib/php/20170718/gd.so"), /usr/local/lib/php/20170718/gd.so.so (Cannot open "/usr/local/lib/php/20170718/gd.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'gettext.so' (tried: /usr/local/lib/php/20170718/gettext.so (Cannot open "/usr/local/lib/php/20170718/gettext.so"), /usr/local/lib/php/20170718/gettext.so.so (Cannot open "/usr/local/lib/php/20170718/gettext.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'json.so' (tried: /usr/local/lib/php/20170718/json.so (Cannot open "/usr/local/lib/php/20170718/json.so"), /usr/local/lib/php/20170718/json.so.so (Cannot open "/usr/local/lib/php/20170718/json.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'ldap.so' (tried: /usr/local/lib/php/20170718/ldap.so (Cannot open "/usr/local/lib/php/20170718/ldap.so"), /usr/local/lib/php/20170718/ldap.so.so (Cannot open "/usr/local/lib/php/20170718/ldap.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'mbstring.so' (tried: /usr/local/lib/php/20170718/mbstring.so (Cannot open "/usr/local/lib/php/20170718/mbstring.so"), /usr/local/lib/php/20170718/mbstring.so.so (Cannot open "/usr/local/lib/php/20170718/mbstring.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'mysqli.so' (tried: /usr/local/lib/php/20170718/mysqli.so (Cannot open "/usr/local/lib/php/20170718/mysqli.so"), /usr/local/lib/php/20170718/mysqli.so.so (Cannot open "/usr/local/lib/php/20170718/mysqli.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'simplexml.so' (tried: /usr/local/lib/php/20170718/simplexml.so (Cannot open "/usr/local/lib/php/20170718/simplexml.so"), /usr/local/lib/php/20170718/simplexml.so.so (Cannot open "/usr/local/lib/php/20170718/simplexml.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'snmp.so' (tried: /usr/local/lib/php/20170718/snmp.so (Cannot open "/usr/local/lib/php/20170718/snmp.so"), /usr/local/lib/php/20170718/snmp.so.so (Cannot open "/usr/local/lib/php/20170718/snmp.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'sockets.so' (tried: /usr/local/lib/php/20170718/sockets.so (Cannot open "/usr/local/lib/php/20170718/sockets.so"), /usr/local/lib/php/20170718/sockets.so.so (Cannot open "/usr/local/lib/php/20170718/sockets.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'xml.so' (tried: /usr/local/lib/php/20170718/xml.so (Cannot open "/usr/local/lib/php/20170718/xml.so"), /usr/local/lib/php/20170718/xml.so.so (Cannot open "/usr/local/lib/php/20170718/xml.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'xmlreader.so' (tried: /usr/local/lib/php/20170718/xmlreader.so (Cannot open "/usr/local/lib/php/20170718/xmlreader.so"), /usr/local/lib/php/20170718/xmlreader.so.so (Cannot open "/usr/local/lib/php/20170718/xmlreader.so.so")) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'xmlwriter.so' (tried: /usr/local/lib/php/20170718/xmlwriter.so (Cannot open "/usr/local/lib/php/20170718/xmlwriter.so"), /usr/local/lib/php/20170718/xmlwriter.so.so (Cannot open "/usr/local/lib/php/20170718/xmlwriter.so.so")) in Unknown on line 0

Could anyone please assist

Tank you
 
hi,

I reinstall mysql57, Zabbix 5 and still same error.
I really don't know dow to resolved it
 
FIxed it :)

php 72 was upgraded to 7.4 automatically but not mod_php.
 
/usr/ports/UPDATING would have given you notification of this ... but not sure what the pkg equivalent of UPDATING is?

In this case - the last line:
Code:
20200914:
  AFFECTS: users of lang/php72
  AUTHOR: tz@FreeBSD.org

  The default version of PHP has been switched from 7.2 to 7.4.

  If you use binary packages you should make a list of php packages
  before running 'pkg upgrade':

  # pkg info php7\* > ~/installed-php-ports-list

  After the upgrade, check with such list if all your php extensions
  are still installed, and reinstall them if needed.

  If you use mod_php72 you need to deinstall it and install mod_php74.
 
I uninstalled zabbix5-frontend, so all php72 pkgs were uninstalled automatically here. Then installed zabbix5-frontend again and all php74 pkgs were installed. no issues so far.
 
not sure what the pkg equivalent of UPDATING is?
pkg updating, requires /usr/ports/UPDATING, so therefore ports tree installed and updated, or fetch https://svn.freebsd.org/ports/head/UPDATING -o /usr/ports before running the command. Change URL accordingly for quarterly ports tree.

pkg (8)
Code:
updating
         Display UPDATING entries of installed packages.
 
Back
Top