[ixpmanager] Best way to perform a clean V6.0 installation.

[Jose Gonzalez]

Dear support,


We come from V3.0 to V5.8, always updating the same server with Ubuntu
18.04. Finally, we decided to go from V5.8 to V6.0, but on a new server
with a clean installation. Common sense says that we only need to create a
backup of the database, a backup of the mrtg directory, of the .env and
skinny files, but I have some problems with the database. Everything looks
good, but some bugs were found. An SQL error when I tried to access the
user list "Server Error :: SQLSTATE [42S22]: Column not found: 1054", and
also with some member port information.

My question is, what is the best way to create a new server with V6.0 using
the old server's database with V5.8.


   1. Procedure to do a clear V6.0 installation:
*https://github.com/inex/IXP-Manager/tree/master/tools/installers
   <https://github.com/inex/IXP-Manager/tree/master/tools/installers>*
   2. Procedure to backup and restore ixpmanager database:
*https://docs.ixpmanager.org/usage/operational-notes/#backup-ixp-manager
   <https://docs.ixpmanager.org/usage/operational-notes/#backup-ixp-manager>*
   3. Ubuntu Version New Server: Distributor ID: Ubuntu
   Description:    Ubuntu 20.04.2 LTS
   Release:        20.04
   Codename:       focal
   4. PHP Version New Server:PHP 8.0.8 (cli) (built: Jul  1 2021 15:26:46)
   ( NTS )
   Copyright (c) The PHP Group
   Zend Engine v4.0.8, Copyright (c) Zend Technologies
       with Zend OPcache v8.0.8, Copyright (c), by Zend Technologies
   5. Laravel log New Server:
   https://pastebin.ibn.ie/?8e350d619b735bec#uSUt5tciLTBPpXK4kqLsLzM11Z1E9CEMKsGXuWdsVXG
   6. Mysql log New Server:
   https://pastebin.ibn.ie/?326ae8710c4f8cb3#ERhirPLBTWt2YDALv3sD8bByZ2kA9QN2NSZpsjRYrWjT

Best Regards.
Jose Gonzalez.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20210728/e11eec69/attachment.htm>