Migrate one wiki from 10.8 server to 10.10 server ?

[The Mac OS X Server Mailing List mailing list]

Has anyone done this ?  I have a 10.8 server with a few wikis on Apple's own wiki system.  All may die except one.  I need to transfer that one to a 10.10 server.  I am not super-fussy about the theme or how long the lines are, just as long as the text and embedded images appear I'm happy.

If it's easier, I can backup the old server, delete all the wikis except the one I want to keep, then transfer the entire wiki dataset across.

I have found the following article but nothing in it actually seems to work so please only recommend something if you've actually done it with success.

<http://krypted.com/mac-os-x/setup-os-x-yosemite-server-as-a-wiki-server/>

I also don't know how to find the name of the one wiki I want to save.  Its name when I'm logged in is long and has punctuation marks in it.  Is there a command to list wiki names ?

Simon

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

Hi Simon.

I actually just finished putting together some info on how to do just that.

Here is a gist of the steps.  You will need to pull over the users and
groups for proper access though.

https://gist.github.com/benbasscom/848f0a46bb81f3c1c1dd


-----------------------------------------------------------
Ben Bass, ACTC (10.6, 10.9) MTC
Specialist: Mac OSX Security & Mobility
Senior Macintosh Consultant
[phone]


On Thu, Mar 26, 2015 at 3:12 PM, OS X Server Mail List <
[hidden email]> wrote:

> Has anyone done this ?  I have a 10.8 server with a few wikis on Apple's
> own wiki system.  All may die except one.  I need to transfer that one to a
> 10.10 server.  I am not super-fussy about the theme or how long the lines
> are, just as long as the text and embedded images appear I'm happy.
>
> If it's easier, I can backup the old server, delete all the wikis except
> the one I want to keep, then transfer the entire wiki dataset across.
>
> I have found the following article but nothing in it actually seems to
> work so please only recommend something if you've actually done it with
> success.
>
> <http://krypted.com/mac-os-x/setup-os-x-yosemite-server-as-a-wiki-server/>
>
> I also don't know how to find the name of the one wiki I want to save.
> Its name when I'm logged in is long and has punctuation marks in it.  Is
> there a command to list wiki names ?
>
> Simon
>
>  _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Macos-x-server mailing list      ([hidden email])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/macos-x-server/benbass%40gmail.com
>
> This email sent to [hidden email]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

On 26 Mar 2015, at 7:29pm, OS X Server Mail List <[hidden email]> wrote:

> I actually just finished putting together some info on how to do just that.
>
> Here is a gist of the steps.  You will need to pull over the users and
> groups for proper access though.
>
> https://gist.github.com/benbasscom/848f0a46bb81f3c1c1dd

Man, that started so well.

I assume that by your step 4.1 you mean "Turn the wiki service back on".

In your step 4.1, command

sudo pg_restore -h "/Library/Server/Wiki/PostgresSocket" -d collab -U collab --single-transaction

I got the following response:

pg_restore: WARNING:  => is deprecated as an operator name
DETAIL:  This name may be disallowed altogether in future versions of PostgreSQL.
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2420; 2753 19366 OPERATOR FAMILY btree_hstore_ops _postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  role "_postgres" does not exist
    Command was: ALTER OPERATOR FAMILY public.btree_hstore_ops USING btree OWNER TO _postgres;


Simon.

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

Hrm.   This was on a Yosemite server you were trying to restore to?  

You followed that with the path to the collab.pgdump you made from the source server?  Try it again with the Wiki Service turned off - I have done it with it off, but on testing it again I got an error that nothing was listening on that socket and had to enable the wiki service.

-----------------------------------------------------------
Ben Bass, ACTC (10.6, 10.9) MTC
Specialist: Mac OSX Security & Mobility
Senior Macintosh Consultant
[phone]

> On Mar 26, 2015, at 4:11 PM, OS X Server Mail List <[hidden email]> wrote:
>
>
> On 26 Mar 2015, at 7:29pm, OS X Server Mail List <[hidden email]> wrote:
>
>> I actually just finished putting together some info on how to do just that.
>>
>> Here is a gist of the steps.  You will need to pull over the users and
>> groups for proper access though.
>>
>> https://gist.github.com/benbasscom/848f0a46bb81f3c1c1dd
>
> Man, that started so well.
>
> I assume that by your step 4.1 you mean "Turn the wiki service back on".
>
> In your step 4.1, command
>
> sudo pg_restore -h "/Library/Server/Wiki/PostgresSocket" -d collab -U collab --single-transaction
>
> I got the following response:
>
> pg_restore: WARNING:  => is deprecated as an operator name
> DETAIL:  This name may be disallowed altogether in future versions of PostgreSQL.
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 2420; 2753 19366 OPERATOR FAMILY btree_hstore_ops _postgres
> pg_restore: [archiver (db)] could not execute query: ERROR:  role "_postgres" does not exist
>    Command was: ALTER OPERATOR FAMILY public.btree_hstore_ops USING btree OWNER TO _postgres;
>
>
> Simon.
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Macos-x-server mailing list      ([hidden email])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/macos-x-server/benbass%40gmail.com
>
> This email sent to [hidden email]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

On 26 Mar 2015, at 8:17pm, OS X Server Mail List <[hidden email]> wrote:

> Hrm.   This was on a Yosemite server you were trying to restore to?  

Yes.

> You followed that with the path to the collab.pgdump you made from the source server?  Try it again with the Wiki Service turned off - I have done it with it off, but on testing it again I got an error that nothing was listening on that socket and had to enable the wiki service.

Same problem with it turned on and off.

The Postgres installation on Yosemite server doesn't appear to have a _postgres role.  The two roles I get are

template1=# SELECT rolname FROM pg_roles;
   rolname    
--------------
 _teamsserver
 collab
(2 rows)

template1=# SELECT d.datname as "Name",
template1-# pg_catalog.pg_get_userbyid(d.datdba) as "Owner"
template1-# FROM pg_catalog.pg_database d;
   Name    |    Owner    
-----------+--------------
 template1 | _teamsserver
 template0 | _teamsserver
 postgres  | _teamsserver
 collab    | collab

I got that far but I don't know how to proceed.

Simon

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

Ok, I wonder if the issue is taking a 10.8 dump directly to a 10.10 machine.  

I don’t think you can go directly from 10.8 to 10.10.  

What I did was import the 10.8 dump into a 10.8 VM, upgrade the VM to 10.10 and verify the wiki’s were working on the VM.  Then follow the directions on the gist to get it from the 10.10 vm to your 10.10 server.

I used VMware Professional, but I think you should be able to use Parallels if you have either or VirtualBox if you don’t have them as VirtualBox is free.

Good luck!

-----------------------------------------------------------
Ben Bass, ACTC (10.6, 10.9) MTC
Specialist: Mac OSX Security & Mobility
Senior Macintosh Consultant
[phone]

> On Mar 26, 2015, at 4:27 PM, OS X Server Mail List <[hidden email]> wrote:
>
>
> On 26 Mar 2015, at 8:17pm, OS X Server Mail List <[hidden email]> wrote:
>
>> Hrm.   This was on a Yosemite server you were trying to restore to?  
>
> Yes.
>
>> You followed that with the path to the collab.pgdump you made from the source server?  Try it again with the Wiki Service turned off - I have done it with it off, but on testing it again I got an error that nothing was listening on that socket and had to enable the wiki service.
>
> Same problem with it turned on and off.
>
> The Postgres installation on Yosemite server doesn't appear to have a _postgres role.  The two roles I get are
>
> template1=# SELECT rolname FROM pg_roles;
>   rolname    
> --------------
> _teamsserver
> collab
> (2 rows)
>
> template1=# SELECT d.datname as "Name",
> template1-# pg_catalog.pg_get_userbyid(d.datdba) as "Owner"
> template1-# FROM pg_catalog.pg_database d;
>   Name    |    Owner    
> -----------+--------------
> template1 | _teamsserver
> template0 | _teamsserver
> postgres  | _teamsserver
> collab    | collab
>
> I got that far but I don't know how to proceed.
>
> Simon
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Macos-x-server mailing list      ([hidden email])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/macos-x-server/benbass%40gmail.com
>
> This email sent to [hidden email]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

On 26 Mar 2015, at 8:34pm, OS X Server Mail List <[hidden email]> wrote:

> I don’t think you can go directly from 10.8 to 10.10.

Ah.  Thank you.

Simon

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

On 26 Mar 2015, at 8:11pm, Simon Slavin <[hidden email]> wrote:

> On 26 Mar 2015, at 7:29pm, OS X Server Mail List <[hidden email]> wrote:
>
>> I actually just finished putting together some info on how to do just that.
>>
>> Here is a gist of the steps.  You will need to pull over the users and
>> groups for proper access though.
>>
>> https://gist.github.com/benbasscom/848f0a46bb81f3c1c1dd
>
> Man, that started so well.

Going from a 10.10 server to a 10.10 server, it seems to have worked except that I don't have any images showing.  Both the quicklooks and the full images show up with the 'image missing' icon.  Any help ?

Simon
--
Simon Slavin                               Fylde Building Room C11
Computing Development Officer              x93569
Psychology Department                      01524 593569
University of Lancaster



 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

Where do I look on Yosemite server to find the images stored on the wiki ?  Are they separate files in a folder somewhere or are they blobs in the Postgres database ?  Anyone know ?

Simon.

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

In addition to the postgres data, the Wiki images and other media are kept in /Library/Server/Wiki/FileData.

I missed a part of the path in my gist - i’ll go update that now.

Copy from the old server, and once on the new server make sure to change the permissions:


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


-----------------------------------------------------------
Ben Bass, ACTC (10.6, 10.9) MTC
Specialist: Mac OSX Security & Mobility
Senior Macintosh Consultant
[phone]

> On Apr 10, 2015, at 8:09 AM, OS X Server Mail List <[hidden email]> wrote:
>
> Where do I look on Yosemite server to find the images stored on the wiki ?  Are they separate files in a folder somewhere or are they blobs in the Postgres database ?  Anyone know ?
>
> Simon.
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Macos-x-server mailing list      ([hidden email])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/macos-x-server/benbass%40gmail.com
>
> This email sent to [hidden email]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

On 10 Apr 2015, at 2:31pm, OS X Server Mail List <[hidden email]> wrote:

> In addition to the postgres data, the Wiki images and other media are kept in /Library/Server/Wiki/FileData.
>
> I missed a part of the path in my gist - i’ll go update that now.
>
> Copy from the old server, and once on the new server make sure to change the permissions:
>
>
> sudo chown -R _teamsserver:_teamsserver /Library/Server/Wiki/FileData
> sudo chmod -R +a "www allow search" /Library/Server/Wiki/FileData

Ben, thanks for your continuing interest.  I found my problems ...

First, my method of copying the FileData folder from one server to another had enough privs to access the page-preview images but not the saved images or their thumbnails.  Since the folder was still pretty big it never occurred to me that I had not copied the entire content.

Once I had the right files in the right place, I executed some of your commands in the wrong order.  The order you listed them in works, but because I had already executed the three wikiadmin commands once it didn't occur to me that I had to do them again after doing the chown/chmod again.

So if someone follows your script correctly the first time it should all work.  And my wiki content appears to be working correctly.  Haven't tried editing a page yet.  That's next.

Thanks again for your help, Ben.

Simon

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]

[The Mac OS X Server Mailing List mailing list]

Glad to hear that things are working for you Simon!

Let me know if I need to make any tweaks or clarifications on the gist - I might actually be writing it up a bit more and would love any specific feedback if you have any.


Thank you!
-----------------------------------------------------------
Ben Bass, ACTC (10.6, 10.9) MTC
Specialist: Mac OSX Security & Mobility
Senior Macintosh Consultant
[phone]

> On Apr 10, 2015, at 11:19 AM, OS X Server Mail List <[hidden email]> wrote:
>
>
> On 10 Apr 2015, at 2:31pm, OS X Server Mail List <[hidden email]> wrote:
>
>> In addition to the postgres data, the Wiki images and other media are kept in /Library/Server/Wiki/FileData.
>>
>> I missed a part of the path in my gist - i’ll go update that now.
>>
>> Copy from the old server, and once on the new server make sure to change the permissions:
>>
>>
>> sudo chown -R _teamsserver:_teamsserver /Library/Server/Wiki/FileData
>> sudo chmod -R +a "www allow search" /Library/Server/Wiki/FileData
>
> Ben, thanks for your continuing interest.  I found my problems ...
>
> First, my method of copying the FileData folder from one server to another had enough privs to access the page-preview images but not the saved images or their thumbnails.  Since the folder was still pretty big it never occurred to me that I had not copied the entire content.
>
> Once I had the right files in the right place, I executed some of your commands in the wrong order.  The order you listed them in works, but because I had already executed the three wikiadmin commands once it didn't occur to me that I had to do them again after doing the chown/chmod again.
>
> So if someone follows your script correctly the first time it should all work.  And my wiki content appears to be working correctly.  Haven't tried editing a page yet.  That's next.
>
> Thanks again for your help, Ben.
>
> Simon
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Macos-x-server mailing list      ([hidden email])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/macos-x-server/benbass%40gmail.com
>
> This email sent to [hidden email]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      ([hidden email])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/macos-x-server/lists%2Bs10970n2h62%40n7.nabble.com

This email sent to [hidden email]