[ZendTo] Another Migration/upgrade of ZendTO

[Scott Silva]

I have to admit I didn’t let mine get that far behind before I migrated…
5xx to 6xx is a big jump.


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


CAUTION: This email originated from outside your organization. Exercise caution when opening attachments or clicking links, especially from unknown senders.
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




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://jul.es/pipermail/zendto/attachments/20230727/9e9c8bd9/attachment.html>