[ZendTo] Another Migration/upgrade of ZendTO

[Gregg Douglas]

Hi Ian,

As I understand it: The new CNAME is only used for the Pickups. The users
will still use the original name and the CNAME will only be valid for the
period the pickups on the old server have expired and been deleted.

Gregg

On Thu, Jul 27, 2023 at 10:41 AM Elston, Ian <I.Elston at bolton.ac.uk> wrote:

> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://jul.es/pipermail/zendto/attachments/20230727/38a5b833/attachment-0001.html>