Wiki content?

Im having the same exact issue. Cant find any documentation to migrate/move to Lion. What folders are used to store Wiki data in Lion Server 10.7?

Well, for me (moving from the latest 10.6-version to Lion), simply pulling the old /Library/Collaboration folder out from a Time Machine backup and copying it to a temporary location was needed. Then the

sudo wikiadmin migrate /tmp/Collaboration/

did the trick. Note that, other than in Mtaksrud's post above, there is no .../folder at the end. Migrated the whole content and all was accessible on the new machine.

No idea, though, where it's kept in Lion. But won't need to know until the next upgrade comes, I guess.

Cheers,

Hendrik

I took Hendrik's advice and was able to successfully migrate the whole content.

The key for me was to make sure the temp folder was on the same volume as the Lion Server. Then i used the following:

sudo wikiadmin migrate -r /temp/Collaboration/

Thanks !

I also want to know where wiki data is stored in Lion... can't find it anywhere...

Dear ESMP,

I think it is in the folder "/Library/Server/Wiki/FileData". That's were my data is. I hope this helps.

Hi!

@mahongue: IMHO, you're only seeing part of it. Under .../FileData you only find a copy of attachments to your wiki (pasted pictures etc.), not the wiki itself. So if you'd only back this up, you'd be pretty frustrated if you ever tried to play it back.

Looking at /etc/collabd/collabd.plist, I suspect that the new wiki is stored in a database by name of "collab", and looking at running processes, I find a

239 ?? Ss 0:00.01 postgres: collab collab [local] idle

So I guess the data now is in postgres, which makes backing it up a bit more complicated than in the past, where saving /Library/Collaboration did the trick. I supposed a "pg_dump -U collab collab >foo" would do the trick, so you could play back that database if you need to restore.

Cheers,

Hendrik

Thank you guys for your answers.

Actually I also did notice that under /FileData no actual content is stored. What I really want to do is just "restart" the wiki, because I was doing some tests, created several test users, etc. however even if I delete the wiki, some documents still exist. For example, I can't find a way to delete the "about" pages for already deleted users. Their About page is still there even though they don't exist anymore, and I don't really want a lot of "Wiki TEST" user pages...

/Librbary/Server/Wiki/FileData stores all of the files for the wiki server. All the wiki data itself is stored in the Postgres database.

If your database fu is very strong, you can drop tables and users and recreate them to reset the wiki. If all you want to do is hide particular users, you can do that by going to each user's My Page as an admin, clicking the gear menu and choosing "Hide Person..."

Doug,

Thank you very much for the information provided. It really is helpful. Now one last question remains... do you know the disk location of such database?

Regards,

- Eduardo

@Eduardo: I believe postgres stores the data under /var/pgsql. But I would not tamper with those files directly. If you want to back up, use the dump command above (pg_dump -U collab collab >foo), which gives you all the sql-instructions to set up, initialize and populate the databse with the current content. So in principle, you could dump the db, then drop it (delete it from postgres), then make a copy of your dump and edit it (it's clear text) to delete all data, and then reload it into postgres.

If you open the dump, first you'll find table and function defintions, and then the data, so with a bit of experimenting you should be able to delete that.

Or: drop the db from postgres, disable wiki and re-enable it in the Server app. Possibly that reinitializes the db. As always, keep a backup handy and use at your own risk.

About the postgres raw files under /var/pgsql: I believe also iCal data is stored in postgres, so if you fool around with the files in there, you may lose more than only your wiki.

Cheers,

Hendrik

@Doug,

Yes, you're right about "Hide Person...", but then how do you unhide that person ? Impossible for me to find out anything about that. Can you help ? Thanks.

About the wiki data, doing a "pg_dump" works perfectly (I had to "su" before).

I did the same trick with the terminal command. It seems to have done the whole procedure but when I try to get to the wiki I have the follwoing message:

No_route_matches "groups/essai/calendar"

Is the path now different from before?

To address a couple of issues raised in this thread:

Wiki backup: The commands to back up and restore the Wiki can be found here.

Dropping the Wiki database: Someone speculated that you could "drop the db from postgres, disable wiki and re-enable it in the Server app. Possibly that reinitializes the db." It does not. It just sits there and complains that the DB is missing. What I haven't tried is doing pg_dump on, say, a virgin 10.7 server and then restoring that over the corrupt DB. I have a hunch that the DB has host-specific parameters baked in and this would not work, but I could be wrong. Moral of the story: Back up your DB early and often. Related moral: Snapshot your VMs.

Unhide users: Someone asked how to unhide people. I haven't tried this, but I noticed that in /etc/collabd/collabd-search.plist, there's this bit:

<key>ignoredEntityExpressions</key>

<array>

<dict>

<key>type</key>

<string>com.apple.entity.FileData</string>

</dict>

<dict>

<key>isHidden</key>

<real>1</real>

</dict>

<dict>

<key>isDeleted</key>

<real>1</real>

</dict>

<dict>

<key>isPermanentlyDeleted</key>

<real>1</real>

</dict>

</array>

It could be that if you edited the value for isHidden to be 0, it would show hidden pages in a search (assuming you knew what you were searching for) and then you could open and unhide them. Maybe not, though - someone should try it.

/Librbary/Server/Wiki/FileData - folder is locked. What do I do next? Thanks.

You could follow several steps to unhide a person, which is hidden by "hide a person..."

1. Go to the "People" page;

2. Create a new page by clicking the plus botton;

3. The new page that you've created must have exactly the same name of the hidden person's name;

4. Refresh and go back to your "People" page, the hidden person is back;

5. Now you could delete the page you've just created, and meanwhile you could hide yourself again by clicking "Config".

Ordo ab Chao wrote:

@Doug,

Yes, you're right about "Hide Person...", but then how do you unhide that person ? Impossible for me to find out anything about that. Can you help ? Thanks.

About the wiki data, doing a "pg_dump" works perfectly (I had to "su" before).