Upgrade to Latest 21.7

Hello All,

Below is the current info for my Libre install.
What do I need to do to my server before I can upgrade to the latest 21.7 version?

Version 1.68-68-g774d95c - Wed Oct 21 2020 21:07:12 GMT-0500
Database Schema 2020_10_21_124101_allow_nullable_ospf_columns (187)
Web Server Apache/2.4.6 (CentOS) PHP/7.2.6
PHP 7.2.6
Python 3.6.8
MySQL 5.5.56-MariaDB
Laravel 7.28.3
RRDtool 1.4.8

Newer PHP and MariaDB.
I would upgrade the OS instead.

Also RRDtool is old

It sure is, and NET-SNMP also :slight_smile:

I migrated from CentOS 7 to Ubuntu 20.04 to cure most of this stuff, its not super hard to do the process.

Its hard to get some of those packages updated unless you compile from source (ick).

If you can’t migrate to a different server then you will need to update:

PHP to 7.4 (You can use REMI Install PHP 7.4 on CentOS, RHEL or Fedora - Remi's RPM repository - Blog)

You will want to upgrade maria/mysql to 5.7 or newer (Install MariaDB on CentOS 7: Step By Step | MariaDB)

Cannot get passed this -

Migrating: 2021_02_09_122930_migrate_to_utf8mb4

In Connection.php line 692:

SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes (SQL: ALTER TABLE config
MODIFY config_name
varchar(255)
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci
NOT NULL :wink:

In Exception.php line 18:

SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes

In PDOConnection.php line 53:

SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes

How did you fix it?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.