Removing a Public Facing User Page in OS X Server Wiki
OS X Server has some pretty neat tools that are easy to set up and use for a team collaboration. The problem is that some of these tools are a bit quirky, especially when it comes to removing users or making sure that no data is accessible from the outside world. For example, if you edit your user profile page, this change will be visible to the public world. There is no real way (that I can find) to hide it, so it is a little bit annoying. Even removing the user from the wiki does not fix this. After doing some digging, it looks like all of this is controlled by a PostgreSQL database which makes it nice to try to figure out how to get rid of these pages. You can log into the PostgreSQL database on OS X server by opening up a terminal and running sudo -u _postgres psql template1
You can list all of the available databases by running \list
and you should see one called collab
. Connect to collab so that you can view the data inside and make some changes by running \c collab
You can see the entire scheme by running \dt
and it will look something like this:
: List of relations Schema | Name | Type | Owner --------+-----------------------------+-------+-------- public | blog_entity | table | collab public | document_entity | table | collab public | entity | table | collab public | entity_acls | table | collab public | entity_acls_defaults | table | collab public | entity_attrs | table | collab public | entity_changesets | table | collab public | entity_comment | table | collab public | entity_lock | table | collab public | entity_preview | table | collab public | entity_private_attrs | table | collab public | entity_tag | table | collab public | entity_type | table | collab public | file_entity | table | collab public | filedata_entity | table | collab public | filename_reservation | table | collab public | global_settings | table | collab public | groups | table | collab public | migration_entity | table | collab public | migration_status | table | collab public | migrationplaceholder_entity | table | collab public | notification | table | collab public | page_entity | table | collab public | podcast_entity | table | collab public | podcast_episode_entity | table | collab public | preview_queue | table | collab public | project_entity | table | collab public | relationship | table | collab public | savedquery_entity | table | collab public | search_index | table | collab public | search_stat | table | collab public | session | table | collab public | subscription | table | collab
select * from entity where long_name like 'Lev%';
com.apple.entity.Page
. You can grab the uid of this item from the first column and then run a simple update statement to mark the item as deleted.
update entity set is_deleted = 't' where uid = 'YOUR UID';
Thank you for reading! Share your thoughts with me on bluesky, mastodon, or via email.
Check out some more stuff to read down below.
Most popular posts this month
- 2024
- Reinstalling Windows at 1am
- SQLite DB Migrations with PRAGMA user_version
- My Custom Miniflux CSS Theme
- How to Disable Wayland in Debian Testing
Recent Favorite Blog Posts
This is a collection of the last 8 posts that I bookmarked.
- The AGI economy is coming faster than you think from Freethink
- Rolling the ladder up behind us from Xe Iaso's blog
- In Praise of “Normal” Engineers from charity.wtf
- Reports of Bluesky's death have been greatly exaggerated from The Torment Nexus
- What Would a Kubernetes 2.0 Look Like from matduggan.com
- We Can Just Measure Things from Armin Ronacher's Thoughts and Writings
- workflows for ai coding from /* 🤖🛠️ */
- Reinvent the Wheel from Matthias Endler
Articles from blogs I follow around the net
in the heat of the summer better call out a plumber
Back in the old days, the good old days, when it was generally accepted that Fascism and Nazis were bad, bloggers would write these posts that were sort of recaps […]
via WIL WHEATON dot NET June 20, 2025Just one more Patreon indignity
I was today years old when I learned that Patreon offers no mechanism to download all of your own posts from your "creator" account. Because fuck you that's why. Confirmed with "support" [sic] who sent me a response with the level of ov…
via jwz June 20, 2025Pluralistic: Oregon bans the corporate practice of medicine (20 Jun 2025)
Today's links Oregon bans the corporate practice of medicine: Karma for Unitedhealthcare, Part II. Hey look at this: Delights to delectate. Object permanence: 2015, 2020 Upcoming appearances: Where to find me. Recent appearances: Where I've been. …
via Pluralistic: Daily links from Cory Doctorow June 20, 2025Generated by openring