Environment
Vibe 4.0.3
MySQL database server
Situation
How to view User Subscriptions such as Folders.
These steps will explain how an admin can view what folders their users are subscribed to.
The steps can be modified slightly depending on the type of database.
Resolution
- Open a terminal as root to the Vibe Database server.
- Login to the database. For a MySQL example:
mysql -uroot -p
Note: Input password at prompt.
Note: Please consult the database provider's documentation on how to login if using another type of database. - Enter the following in the database prompt:
use sitescape; - Enter one of the following queries:
- (Option 1) Display all users and what they are subscribed to:
SELECT s.principalid AS "User ID",
p.NAME AS "User Login Name",
s.entityid AS "Folder ID",
f.pathname AS "Folder Path"
FROM SS_Subscriptions s,
SS_Principals p,
SS_Forums f
WHERE s.entitytype = 2
AND s.principalid = p.id
AND s.entityid = f.id
ORDER BY s.principalid; - (Option 2) Display everything a specific user is subscribed to:
SELECT s.principalid AS "User ID",
p.NAME AS "User Login Name",
s.entityid AS "Folder ID",
f.pathname AS "Folder Path"
FROM SS_Subscriptions s,
SS_Principals p,
SS_Forums f
WHERE p.NAME = 'user1'
AND s.entitytype = 2
AND s.principalid = p.id
AND s.entityid = f.id
ORDER BY s.principalid;
Note: Replace 'user1' with a proper username.
- (Option 1) Display all users and what they are subscribed to:
- Type 'exit' to exit the database.