Migrating from ubuntu16 to ubuntu22

I’m trying to migrate from ubuntu 16 LTS to ubuntu 22 LTS. Have installed all required components, and restored old rrd files and librenms mysql dump to ubuntu 22, i’m hitting “Could not connect to database, check logs/librenms.log”.

Opening the webbrowser opens the setup page and i wonder if my restored db get overwritten if proceed with setup page, because i see “Build Database” button.

I don’t have config backups of ubuntu16, esp .env and config.php.

ubuntu 16

LibreNMS  | 21.7.0-85-g8bb6eec73
DB Schema | 2021_25_01_0127_create_isis_adjacencies_table (213)
PHP       | 7.4.22
Python    | 3.6.9
MySQL     | 10.3.8-MariaDB-1:10.3.8+maria~artful
RRDTool   | 1.7.0
SNMP      | NET-SNMP 5.7.3

ubuntu 22

Component | Version
--------- | -------
LibreNMS  | 23.2.0-51-g13d8ac222 (2023-04-06T07:35:59+05:30)
DB Schema | Not Connected (0)
PHP       | 8.1.2-1ubuntu2.11
Python    | 3.10.6
Database  | Not Connected
RRDTool   | 1.7.2
SNMP      | 5.9.1

[OK]    Composer Version: 2.5.5
[OK]    Dependencies up-to-date.
Could not connect to database, check logs/librenms.log.


Have you followed the steps referenced on the Librenms FAQ page correctly?

here is a screenshot of the steps for reference:

Done everything, except .env and config.php files since i don’t have config backup( ubuntu 16 crashed and not recoverable, fortunately i had automatic backups of mysql and rrd files).

Went ahead and completed installation thru GUI.

restored mysql backup and rrd folder again.

edited .env and config.php files.

ran ./validate.php again to fix the issues.

Now the issue is with graph, “ERROR: This RRD was created on another architecture”

I personally haven’t seen this issue before but I assume you’ve moved from 32bit to 64bit architecture?
If so maybe try the article in the link below about fixing that issue:
tolaris.com · rrdtool: This RRD was created on other architecture

Yes, i got similar rrd migration link on discord, converted old 32bit to 64bit and copied to LNMS.

There are still some quirks, could be due to new LNMS renaming thngs, for some devices it says file not found, which are not in 32bit rrd folder.

Don’t know how fix those. Have not got any response for this on discord.