Upgrade stuck

[MiamiJack]

Hello All,

Spun up my older librenms instance, got Centos 7 updated with yum completely, ran daily.sh and got this in return:

/opt/librenms/ ./daily.sh
PHP Warning:  Module 'zip' already loaded in Unknown on line 0
Re-running /opt/librenms/daily.sh as librenms user
PHP Warning:  Module 'zip' already loaded in Unknown on line 0
PHP Warning:  Module 'zip' already loaded in Unknown on line 0
PHP Warning:  Module 'zip' already loaded in Unknown on line 0
PHP Warning:  Module 'zip' already loaded in Unknown on line 0
PHP Warning:  Module 'zip' already loaded in Unknown on line 0
PHP Warning:  Module 'zip' already loaded in Unknown on line 0
PHP Warning:  Module 'zip' already loaded in Unknown on line 0
PHP Warning:  Module 'zip' already loaded in Unknown on line 0
Updating to latest codebase                        OK

In ProviderRepository.php line 208:

  Class 'SocialiteProviders\Manager\ServiceProvider' not found



In ProviderRepository.php line 208:

  Class 'SocialiteProviders\Manager\ServiceProvider' not found


Updating Composer packages                         OK
Updated from 450463f to 0f37f68                    OK
Updating SQL-Schema                                OK
Updating submodules                                OK
Cleaning up DB                                     OK
Fetching notifications                             OK
Caching PeeringDB data                             OK
Caching Mac OUI data                               OK

I skipped over that and ran
./lnms migrate
And got this:

Blockquote`ash-4.2$ mysql_upgrade
Version check failed. Got the following error when calling the ‘mysql’ command line client
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
FATAL ERROR: Upgrade failed
bash-4.2$ ./lnms migrate**************************************

• Application In Production!
  

---

Do you really wish to run this command? (yes/no) [no]:

yes
Migrating: 2020_12_14_091314_create_port_groups_table
In Connection.php line 712:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table port_groups add unique port_groups_name_unique(nam e))
In Exception.php line 18:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
In PDOStatement.php line 117:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

librenms.log has the following:

Blockquote[2022-08-03T20:47:52.878313-04:00] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.printer_supplies’ doesn’t exist (SQL: select exists(select * from printer_supplies) as exists) (View: /opt/librenms/resources/views/layouts/librenmsv1.blade.php) (View: /opt/librenms/resources/views/layouts/librenmsv1.blade.php) {“userId”:1,“exception”:“[object] (Illuminate\View\ViewException(code: 0): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.printer_supplies’ doesn’t exist (SQL: select exists(select * from printer_supplies) as exists) (View: /opt/librenms/resources/views/layouts/librenmsv1.blade.php) (View: /opt/librenms/resources/views/layouts/librenmsv1.blade.php) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712)
[previous exception] [object] (Illuminate\View\ViewException(code: 0): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.printer_supplies’ doesn’t exist (SQL: select exists(select * from printer_supplies) as exists) (View: /opt/librenms/resources/views/layouts/librenmsv1.blade.php) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712)
[previous exception] [object] (Illuminate\Database\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.printer_supplies’ doesn’t exist (SQL: select exists(select * from printer_supplies) as exists) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712)
[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.printer_supplies’ doesn’t exist at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)
[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.printer_supplies’ doesn’t exist at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82)”}

GUI Error shows this

Blockquote### Database inconsistencies found during a database error, please fix to continue.## Your database is out of date!
./lnms migrate

Any ideas or suggestions?

Thanks!

[Jellyfrog]

You database version is too old.
Do yourself a favor and switch to a modern operating system

[MiamiJack]

I’m on Centos 7, I would not consider that old, it’s not Centos 5…
any suggestions on what I can do to get that fixed?
I’m not sure which version of Maria DB I should try to load.