[ZendTo] Another Migration/upgrade of ZendTO

[Elston, Ian]

I'm in a similar position - a wiser man than me (Jules) once suggested that this jump is a bit large to handle nicely, and the best thing would be to launch a new server, potentially with a new name to make that simpler. Our service has been called 'zendto' for years so I'm loathe to change it, which makes things trickier to swap over, running two in parallel etc.



-----Original Message-----
From: ZendTo <zendto-bounces at zend.to> On Behalf Of Gregg Douglas via ZendTo
Sent: 27 July 2023 09:36
To: ZendTo Users <zendto at zend.to>
Cc: Gregg Douglas <douglagm at gmail.com>
Subject: [ZendTo] Another Migration/upgrade of ZendTO

WARNING: This message originated from outside the University. Use caution when following links or opening attachments.
Hi All,

I have been neglecting the upgrade on my ZendTO server, it has now come time for me to bite the bullet. I have scoured the mailing lists for recommendations. From what I understand is there are two options:

1.      Implement a new server and change the upload url and create a CNAME
2.      Implement a new server copy data and DB across then upgrade the scheme of the DB


I have tried both, but I can't seem to get either to work.

Using option 1, I change the following:

        In the preference.php, I change the serverRoot option to the CNAME

        In the apache configuration, I also change to the CNAME

        Reboot server, just to make sure

        However I can't upload any files and get the following error message:

                Sorry, I failed to drop-off your files! Note that you cannot drop-off directories, only files.

        When I change the above back to the original settings everything works


Using the option 2:

        Current server is 5.23-3


        New server is 6.13-3


        The DB is MySQL/MariaDB


        Comment out all cron jobs on new server


        I export the DB from the current server and import into the new server


        Then run the following script as suggested: /usr/bin/php /opt/zendto/sbin/cleanup.php /opt/zendto/config/preferences.php


        However I get the following error:


                PHP Warning:  Undefined array key "authLDAPAdmins" in /opt/zendto/lib/NSSLDAPAuthenticator.php on line 70


                Cleanup of ZendTo for preference file:

                  /opt/zendto/config/preferences.php


                Updating database schema

                PHP Fatal error:  Uncaught mysqli_sql_exception: Duplicate column name 'Passphrase' in /opt/zendto/lib/MySQL.php:889

                Stack trace:

                #0 /opt/zendto/lib/MySQL.php(889): mysqli->query()

                #1 /opt/zendto/lib/MySQL.php(716): Sql->DBReqAddPassphrase()

                #2 /opt/zendto/sbin/cleanup.php(58): Sql->DBUpdateSchema()

                #3 {main}

                  thrown in /opt/zendto/lib/MySQL.php on line 889


I really like option 1 as I can then also migrate the DB to the default DB, but at this point I would be happy to get either option working.

Any assistance or guidance will be highly appreciated.

Regards
Gregg




[University of Bolton]<https://www.bolton.ac.uk>

This email (and any attachments) is confidential and may contain personal views which are not the views of the University of Bolton unless specifically stated. If you have received it in error, please delete it from your system. Do not use, copy or disclose information in any way nor act in reliance on it and notify the sender immediately. Please note the University of Bolton monitors emails sent or received. Further communication will signify your consent to this.