[Building Sakai] if "Administration Workspace" is deleted, then how to restore it ?

Wed Aug 29 23:14:21 PDT 2012

Hi,

You could do this via the various UI tools but its probably just as easy to run the SQL that sets it up in the first place.

Check your kernel source/kernel-impl/src/main/sql/DB_VENDOR/ and look for anything that has !admin in it.

For example for kernel 1.2.x and mysql:

[steveimac:~/dev/sakai/src/extra/kernel-1.2.x/kernel-impl/src/main/sql/mysql]$ grep -r '!admin' *
sakai_realm.sql:INSERT INTO SAKAI_REALM VALUES (DEFAULT, '/site/!admin', '', (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'admin'), 'admin', 'admin', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
sakai_realm.sql:INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '/site/!admin'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'admin'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'site.upd'));
sakai_realm.sql:INSERT INTO SAKAI_REALM_RL_GR VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '/site/!admin'),'admin', (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'admin'), '1', '0');
sakai_site.sql:INSERT INTO SAKAI_SITE VALUES('!admin', 'Administration Workspace', null, null, 'Administration Workspace', null, null, null, 1, 0, 0, '', 'admin', 'admin', NOW(), NOW(), 0, 0, 0);
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-100', '!admin', 'Home', '0', 1, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE_PROPERTY VALUES('!admin', '!admin-100', 'is_home_page', 'true' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-110', '!admin-100', '!admin', 'sakai.motd', 1, 'Message of the Day', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-120', '!admin-100', '!admin', 'sakai.iframe.myworkspace', 2, 'My Workspace Information', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-200', '!admin', 'Users', '0', 2, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-210', '!admin-200', '!admin', 'sakai.users', 1, 'Users', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-250', '!admin', 'Aliases', '0', 3, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-260', '!admin-250', '!admin', 'sakai.aliases', 1, 'Aliases', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-300', '!admin', 'Sites', '0', 4, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-310', '!admin-300', '!admin', 'sakai.sites', 1, 'Sites', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-350', '!admin', 'Realms', '0', 5, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-355', '!admin-350', '!admin', 'sakai.realms', 1, 'Realms', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-360', '!admin', 'Worksite Setup', '0', 6, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-365', '!admin-360', '!admin', 'sakai.sitesetup', 1, 'Worksite Setup', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-400', '!admin', 'MOTD', '0', 7, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-410', '!admin-400', '!admin', 'sakai.announcements', 1, 'MOTD', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL_PROPERTY VALUES('!admin', '!admin-410', 'channel', '/announcement/channel/!site/motd' );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-500', '!admin', 'Resources', '0', 8, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-510', '!admin-500', '!admin', 'sakai.resources', 1, 'Resources', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL_PROPERTY VALUES('!admin', '!admin-510', 'home', '/' );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-600', '!admin', 'On-Line', '0', 9, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-610', '!admin-600', '!admin', 'sakai.online', 1, 'On-Line', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-700', '!admin', 'Memory', '0', 10, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-710', '!admin-700', '!admin', 'sakai.memory', 1, 'Memory', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-900', '!admin', 'Site Archive', '0', 11, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-910', '!admin-900', '!admin', 'sakai.archive', 1, 'Site Archive / Import', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-1000', '!admin', 'Job Scheduler', '0', 12, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-1010', '!admin-1000', '!admin', 'sakai.scheduler', 1, 'Job Scheduler', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-1100', '!admin', 'Become User', '0', 13, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-1110', '!admin-1100', '!admin', 'sakai.su', 1, 'Become User', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-1200', '!admin', 'User Membership', '0', 14, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-1210', '!admin-1200', '!admin', 'sakai.usermembership', 1, 'User Membership', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_PAGE VALUES('!admin-1205', '!admin', 'Email Templates', '0', 15, '0' );
sakai_site.sql:INSERT INTO SAKAI_SITE_TOOL VALUES('!admin-1211', '!admin-1205', '!admin', 'sakai.emailtemplateservice', 1, 'Email Templates', NULL );
sakai_site.sql:INSERT INTO SAKAI_SITE_USER VALUES('!admin', 'admin', -1);

Make sure you use the correct version for your Sakai install. Either find the scripts in your source, or check the kernel version and grab it from the tag on source.sakaiproject.org

cheers,
Steve

On 30/08/2012, at 3:51 PM, Jehan Badshah <jehan.badshah at nu.edu.pk> wrote:

> Dear All
> 
> if administration workspace is deleted by admin, then what is the way to restore/create it?.
> 
> 
> 
> Regards
> 
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120830/455b6f2e/attachment.html 