[isf-wifidog] Auth Server Upgrade

[Alberto]

Ok, thank you Benoit, worked like a charm.

Alberto

2007/1/11, Benoit Grégoire <bock at step.polymtl.ca>:
>
> On Wednesday 10 January 2007 15:14, Gabe Sawhney wrote:
> > I dunno how others do it, but I upgraded our auth server last week
> > (from one that was even older than yours), this way:
> >
> > - download from svn into a new folder, in the same apache virtual
> > server space (i.e. auth.wirelesstoronto.ca/newauth)
> > - create a new postgres database called wifidog-new (or whatever)
> > - pg_dump wifidog > wifidog.sql
> > - psql wifidog-new < wifidog.sql
>
> That will prompty destroy all the Binary blobs (such as those in the Image
> content type) on many versions of postgres.
>
> Use the sql/backup_database.sh and sql/restore_database.sh scripts
> instead.
>
> > - run the install.php script as if it was a new install, and it
> > upgrades the schema
>
> Unless you missed a step, the wifidog-new is never used for anything, and
> not
> modified bit the install script.
>
> > - bail on the install.php script after the schema upgrade ('cause
> > otherwise it tries to create a new admin account)
>
> It's more reliable to just go to the auth server home page to update the
> schema.  The corresponding code in install.php will be deleted, and it may
> not be safe.
>
> > >From now on we'll be better about keeping it updated, so I'll just do
> >
> > svn updates to the live site.
> >
> > If the process above seems bonkers to anyone, please let me know -- I
> > promise to put the info on the wiki.  <smile>
>
> Basically, the recommended process goes:
> 1-Read the Changelog (seriously)
> 2-Use sql/backup_database.sh before the upgrade
> 3-Testing (optionnal, but recommended)
> 3.1-Checkout lastest SVN on a developement machine (not the same one as
> your
> server, unless you really know what you are doing: you need to modify
> config.php to point to a different DB, and you cant's use the restore
> script
> directly
> 3.2-Restore your live database on the development machine.  Check if
> everything seems in order (good tests are loging-in, viewing your most
> complicated portal and opening the Reusable content library).  For a more
> complete test (especially if you didn't upgrade in months), plug a gateway
> to
> your development server and login, and try creating a new account.
> 4-Run svn update on your live server
> 5-Go to your auth server home page to make sure the schema has been
> updated
> (it may already have been by a random user accessing the auth server)
> 6-If the Changelog mentionned dependency changes (or if unsure), start the
> install script till the dependencies page.
>
> --
> Benoit Grégoire
> Technologies Coeus inc.
>
>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20070119/513ab63d/attachment.html