Bertrand from France

Q: Wiki migration from Mavericks to Yosemite Server

Hi all,

 

I'm migrating a wiki server from 10.9.5 with Sever 3.2.2 to 10.10.1 with Server 4.0.

i've done these steps :

- backup postgres database with :

/pg_dump -h "/Library/Server/Wiki/PostgresSocket" --format=c --compress=9 --blobs --username=collab --file=/Volumes/ServerHD/Users/admin/Desktop/collab.pgdump collab

 

Then on the Yosemite server, i've retore the wiki database:

First, in postgres :

psql -h "/Library/Server/Wiki/PostgresSocket" -U collab template1

template1=# SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'collab' AND pid <> pg_backend_pid();drop database "collab";create database "collab";


- then restore postgres database with :

pg_restore -h "/Library/Server/Wiki/PostgresSocket" -d collab -U collab --single-transaction /Volumes/ServerHD/Users/admin/Desktop/collab.pgdump

 

I've transfered FileData folder between the two servers, and fix rights via chown -R _teamsserver:_teamsserver for the FileData folder in /Library/Server/Wiki/

After that, i used two commands :

wikiadmin fixPermissions

wikiadmin resetQuicklooks

 

All the wikis are visible, and seems to work fine.

But, when i try to view or download an attached file from a wiki, server returns an error page indicating that wiki is not activated (!!??)

 

I think there's a new organisation for the attachments in the wiki part of Yosemite, but without any documentation, it's not easy to make it work.

 

Does anybody got this problem a have a solution?

 

Thanks a lot

Bertrand.

Mac Pro, OS X Yosemite (10.10.1), Server

Posted on Jan 21, 2015 1:45 AM

Close

Q: Wiki migration from Mavericks to Yosemite Server

  • All replies
  • Helpful answers

  • by Semmelrocc,

    Semmelrocc Semmelrocc Jan 29, 2015 6:31 AM in response to Bertrand from France
    Level 1 (25 points)
    Jan 29, 2015 6:31 AM in response to Bertrand from France

    Just for curiosity's sake, why didn't you simply do an upgrade installation? Installing Yosemite over Mavericks and replacing Server.app 3 with 4 would have done the trick.

  • by Bertrand from France,

    Bertrand from France Bertrand from France Jan 29, 2015 9:14 AM in response to Semmelrocc
    Level 1 (0 points)
    Jan 29, 2015 9:14 AM in response to Semmelrocc

    Hi,

     

    It's just because Mavericks was broken and i had to reinstall all the services.

     

    I've found the solution by applying an ACL on the FileDatas folder for the user _www by :

     

    sudo chmod -R +a "www allow search" /Library/Server/Wiki/FileData

     

    Bertrand.

  • by fastweb11,

    fastweb11 fastweb11 Oct 15, 2016 11:00 AM in response to Bertrand from France
    Level 1 (8 points)
    Servers Enterprise
    Oct 15, 2016 11:00 AM in response to Bertrand from France

    Hi Bertrand,

     

    Your post has been very helpful since it is the only post that mentions Postgres db restore in Yosemite.

    However when I run the psql -h command, I get the error: -bash: syntax error near unexpected token `('

     

    Do I need to replace (pid) with the actual pid of Postgres?

     

    I'm running Yosemite 10.10.1 and server ver. 4

    Any ideas?

     

    Cheers,

    AA