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] |
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 (917) 536-0998 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] |
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] |
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 (917) 536-0998 > 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] |
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] |
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 (917) 536-0998 > 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] |
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] |
In reply to this post by 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] |
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] |
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 (917) 536-0998 > 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] |
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] |
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 (917) 536-0998 > 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] |
Free forum by Nabble | Edit this page |