Ad Widget

Collapse

Database error after upgrading from 6.0 to 6.2.4

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Stergios
    Junior Member
    • Jun 2022
    • 2

    #1

    Database error after upgrading from 6.0 to 6.2.4

    Upgraded from 6.0 to 6.2.4 on Ubuntu and now getting the error
    "The Zabbix database version does not match current requirements. Your database version: 6010048. Required version: 6020000. Please contact your system administrator."

    Here is the data:

    Linux zabbix 5.4.0-132-generic #148-Ubuntu SMP Mon Oct 17 16:02:06 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
    zabbix_server (Zabbix) 6.2.4
    Revision 885eaefa6f7 2 November 2022​

    /var/log/zabbix/zabbix_server.log

    1102:20221121:063225.069 housekeeper [deleted 99593 hist/trends, 0 items/triggers, 0 events, 1 problems, 0 sessions, 0 alarms,>
    1102:20221121:073225.169 executing housekeeper
    1102:20221121:074115.176 housekeeper [deleted 99568 hist/trends, 0 items/triggers, 0 events, 1 problems, 0 sessions, 0 alarms,>
    1102:20221121:084115.278 executing housekeeper​


    /etc/zabbix/web/zabbix.conf.php

    <?php
    // Zabbix GUI configuration file.

    $DB['TYPE'] = 'MYSQL';
    $DB['SERVER'] = 'localhost';
    $DB['PORT'] = '10051';
    $DB['DATABASE'] = 'zabbix';
    $DB['USER'] = 'zabbix';
    $DB['PASSWORD'] = 'aqualung';

    // Schema name. Used for PostgreSQL.
    $DB['SCHEMA'] = '';

    // Used for TLS connection.
    $DB['ENCRYPTION'] = false;
    $DB['KEY_FILE'] = '';
    $DB['CERT_FILE'] = '';
    $DB['CA_FILE'] = '';
    $DB['VERIFY_HOST'] = false;
    $DB['CIPHER_LIST'] = '';

    // Vault configuration. Used if database credentials are stored in Vault secrets manager.
    $DB['VAULT_URL'] = '';
    $DB['VAULT_DB_PATH'] = '';
    $DB['VAULT_TOKEN'] = '';

    // Use IEEE754 compatible value range for 64-bit Numeric (float) history values.
    // This option is enabled by default for new Zabbix installations.
    // For upgraded installations, please read database upgrade notes before enabling this option.
    $DB['DOUBLE_IEEE754'] = true;

    // Uncomment and set to desired values to override Zabbix hostname/IP and port.
    // $ZBX_SERVER = '';
    // $ZBX_SERVER_PORT = '';

    $ZBX_SERVER_NAME = 'Zabbix';

    $IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;

    // Uncomment this block only if you are using Elasticsearch.
    // Elasticsearch url (can be string if same url is used for all types).
    //$HISTORY['url'] = [
    // 'uint' => 'http://localhost:9200',
    // 'text' => 'http://localhost:9200'
    //];
    // Value types stored in Elasticsearch.
    //$HISTORY['types'] = ['uint', 'text'];

    // Used for SAML authentication.
    // Uncomment to override the default paths to SP private key, SP and IdP X.509 certificates, and to set extra settings.
    //$SSO['SP_KEY'] = 'conf/certs/sp.key';
    //$SSO['SP_CERT'] = 'conf/certs/sp.crt';
    //$SSO['IDP_CERT'] = 'conf/certs/idp.crt';
    //$SSO['SETTINGS'] = [];

    ​any help would be much appreciated

  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    That error is from GUI? You should first (re?)start your server, let it do the upgrade tasks and only after that connect to GUI.

    Comment

    • Stergios
      Junior Member
      • Jun 2022
      • 2

      #3
      Originally posted by cyber
      That error is from GUI? You should first (re?)start your server, let it do the upgrade tasks and only after that connect to GUI.
      Yes, the error comes from GUI
      I restarted the zabbix server and rebooted the whole Ubuntu Sever
      Upgrade is finished, unfortunately something went wrong during the procedure...

      Comment

      Working...