search

opendcim / openDCIM

An open source (GPL v3) Data Center Inventory Management (DCIM) application.
http://opendcim.org
305 stars 204 forks source link

21.01 Database does work in 23.04 #1482

Closed cpbonamico closed 9 months ago

cpbonamico commented 9 months ago

I have a legacy 21.01 DCIM instance on Rocky 8.9. Created a new instance on rocky 8.9, installed 23.04 with the new PHP 8.0 and it runs fine with a empty Database. Once I upload my 21.01 mysqldump .sql file and login into the new Database on the 23.04, it goes directly to install.php but the page is blank. I have the AllowEncodedSlashes On in my conf file. What am I missing here please?

wilpig commented 9 months ago

if it is showing a blank install.php then there is likely an error occuring on the server when it is trying to run the upgrade for the database. check your apache error logs to see what is up. I would also say to make sure you followed the RHEL8 install guide so you have all the modules installed that are needed. https://github.com/opendcim/openDCIM/wiki/RHEL#rhel-8-installation-instructions The rocky packages should be named the exact same.

cpbonamico commented 9 months ago

This is all I could find..keeps repeating....

[01-Dec-2023 12:47:20 America/Denver] Newer version codebase than database, redirecting to installation script. [01-Dec-2023 19:47:20 UTC] Applying database update from 23.02 to 23.03 [01-Dec-2023 19:47:20 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'fac_Country' already exists in /opt/openDCIM/openDCIM-23.04/install.php:65 Stack trace:

0 /opt/openDCIM/openDCIM-23.04/install.php(65): PDO->query()

1 /opt/openDCIM/openDCIM-23.04/install.php(235): applyupdate()

2 /opt/openDCIM/openDCIM-23.04/install.php(261): upgrade()

3 {main}

thrown in /opt/openDCIM/openDCIM-23.04/install.php on line 65

You help is greatly appreciated

Chris B.

samilliken commented 9 months ago

Did you setup 23.04 as a blank site, first? If so, the tables already exist. You should drop and recreate the new db, then import the dump into that new db before you run the install.

Scott

From: cpbonamico Sent: Friday, December 01, 2023 2:57 PM To: opendcim/openDCIM @.> Cc: Subscribed @.> Subject: Re: [opendcim/openDCIM] 21.01 Database does work in 23.04 (Issue #1482)

This is all I could find..keeps repeating....

[01-Dec-2023 12:47:20 America/Denver] Newer version codebase than database, redirecting to installation script. [01-Dec-2023 19:47:20 UTC] Applying database update from 23.02 to 23.03 [01-Dec-2023 19:47:20 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'fac_Country' already exists in /opt/openDCIM/openDCIM-23.04/install.php:65 Stack trace:

0 /opt/openDCIM/openDCIM-23.04/install.php(65): PDO->query()

1 https://github.com/opendcim/openDCIM/issues/1 /opt/openDCIM/openDCIM-23.04/install.php(235): applyupdate()

2 https://github.com/opendcim/openDCIM/issues/2 /opt/openDCIM/openDCIM-23.04/install.php(261): upgrade()

3 https://github.com/opendcim/openDCIM/issues/3 {main}

thrown in /opt/openDCIM/openDCIM-23.04/install.php on line 65

You help is greatly appreciated

Chris B.

— Reply to this email directly, view it on GitHub https://github.com/opendcim/openDCIM/issues/1482#issuecomment-1836698372 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AAMTY64VP7CVIOASFBBSEULYHIY7PAVCNFSM6AAAAABADI2SVSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZWGY4TQMZXGI . You are receiving this because you are subscribed to this thread. https://github.com/notifications/beacon/AAMTY64GF3AFBJXZIK73TJTYHIY7PA5CNFSM6AAAAABADI2SVSWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTTNPHFQI.gif Message ID: @. @.> >

cpbonamico commented 9 months ago

That was the trick! Thank You Scott and sorry to bug you....

Chris B