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

Wed Aug 29 23:54:18 PDT 2012

Thanks, it really helped.

On Thu, Aug 30, 2012 at 11:14 AM, Steve Swinsburg <steve.swinsburg at gmail.com
> wrote:

> 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"
>
>
>

-- 

Regards
----------------------------------------------------
Jehan Badshah | Sr. Software Engineer & Team Lead
Sakai Learning and Teaching Environment (SLATE)
National University of Computer and Emerging Sciences
A.K. Brohi Road, H-11/4, Islamabad
UAN: +92 (0)51 - 111 128 128 ext 344
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120830/53f1c392/attachment.html 