[ZendTo] Another Migration/upgrade of ZendTO

[Sangster, Mark]

Installer: https://zend.to/files/install.ZendTo.tgz

Linked from here: https://zend.to/downloads#useinstaller

There is also upgrade instructions here: https://zend.to/upgrade

Cheers
Mark

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

CAUTION: External email. Ensure this message is from a trusted source and exercise caution before clicking links/opening attachments.

Hi All,

Where can I get the installation file for my older version: 5.23-3?

I download this file, but it is not the installation, it is just files:  https://zend.to/files/ZendTo-5.23-3.tgz

There is no installation script.

Regards
Gregg


On Thu, Jul 27, 2023 at 4:43 PM Scott Silva via ZendTo <zendto at zend.to<mailto:zendto at zend.to>> wrote:
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<mailto: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<mailto:zendto at zend.to>>
Cc: Gregg Douglas <douglagm at gmail.com<mailto: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




_______________________________________________
ZendTo mailing list
ZendTo at zend.to<mailto:ZendTo at zend.to>
http://jul.es/mailman/listinfo/zendto


The University of Aberdeen is a charity registered in Scotland, No SC013683.
Tha Oilthigh Obar Dheathain na charthannas clàraichte ann an Alba, Àir. SC013683.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://jul.es/pipermail/zendto/attachments/20230728/2854d098/attachment-0001.html>