[Building Sakai] Question about the LTI2
Yuechuan Dai
daiyuechuan at hotmail.com
Fri Sep 12 10:24:06 PDT 2014
Hello, all
I’m trying to add LTI2.X sample tool to sakai 10.1 which like http://www.dr-chuck.com/sakai-api-test/tool.php with its key=12345 and secret=secret
But registration always failed and return like: could not establish context
I can’t figure out why and I am not sure if I do the right configuration in sakai.properties because sakai shows me like:
Alert: This server is not configured for LTI2. Sample configuration will be used. Do not use sample data in production.
here is my ==== sakai.properties ===
basiclti.provider.enabled=true
basiclti.provider.allowedtools=sakai.announcements:sakai.singleuser:sakai.assignment.grades:blogger:sakai.dropbox:sakai.mailbox:sakai.forums:sakai.gradebook.tool:sakai.podcasts:sakai.poll:sakai.resources:sakai.schedule:sakai.samigo:sakai.rwiki
basiclti.provider.12345.secret=secret
basiclti.outcomes.enabled=true
basiclti.roster.enabled=true
basiclti.settings.enabled=true
basiclti.lori.enabled=true
log.config.count=2
log.config.1 = DEBUG.org.sakaiproject.blti.ServiceServlet
log.config.2 = DEBUG.org.sakaiproject.blti.LessonsFacade
basiclti.outcomes.userid=basiclti
basiclti.outcomes.usereid=basiclti
Is there anyone know how to deal with this?
Thanks a lot
--
Yuechuan Dai
Sent with Airmail
在 2014年9月12日 3:00:07, sakai-dev-request at collab.sakaiproject.org (sakai-dev-request at collab.sakaiproject.org) 写到:
Send sakai-dev mailing list submissions to
sakai-dev at collab.sakaiproject.org
To subscribe or unsubscribe via the World Wide Web, visit
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
or, via email, send a message with subject or body 'help' to
sakai-dev-request at collab.sakaiproject.org
You can reach the person managing the list at
sakai-dev-owner at collab.sakaiproject.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of sakai-dev digest..."
Today's Topics:
1. Re: question about AuthenticationCache -- null authentication
record (Sanghyun Jeon)
2. Course enrollment information (Venkat Ravikanti)
3. Re: sakai grade book exception (Ismail Naik)
4. Exception (Ismail Naik)
5. Re: sakai grade book exception (Sam Ottenhoff)
6. Re: sakai grade book exception (Ismail Naik)
7. Re: sakai grade book exception (Sam Ottenhoff)
8. Re: Modifying Clog tool for Assessment (Adrian Fish)
9. Re: sakai grade book exception (Ismail Naik)
10. Re: Course enrollment information (Brian Baillargeon)
11. Re: Course enrollment information (Venkat Ravikanti)
----------------------------------------------------------------------
Message: 1
Date: Wed, 10 Sep 2014 12:13:35 -0700
From: Sanghyun Jeon <euksa99 at gmail.com>
Subject: Re: [Building Sakai] question about AuthenticationCache --
null authentication record
To: sakai-dev <sakai-dev at collab.sakaiproject.org>
Message-ID:
<CAOtsy=rpn1LLGKB_wigMuWEJPtrwyzetCdd+9PvmtROc7tCcDw at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Unfortunately, I have not heard back yet
Here's some more update:
If user entered the wrong pwd, then the tomcat threw [DEBUG]
org.sakaiproject.user.impl.AuthenticationCache:94 - getAuthentication:
record for authenticationId=XXXX failed password check
I think null record causes the issue, so that user authentication is
failed. Can anybody explain when the record can be null?
Thank you in advance.
S
On Tue, Sep 9, 2014 at 10:33 AM, Sanghyun Jeon <euksa99 at gmail.com> wrote:
> Hello All,
>
>
>
> One of our LDAP servers? users is having a difficulty to use WebDAV.
>
> Whenever these users enter the user name and pwd into WebDAV windows, the
> tomcat throws
>
> getAuthentication: replaying authentication failure for
> authenticationId=XXX.
>
>
>
> I look through the code
> in kernel/kernel-impl/src/main/java/org/sakaiproject/user/impl/ AuthenticationCache.java,
> this can happen only when user provided pwd and LDAP pwd are matched but
> authentication record is null.
>
> I am wondering when/how the authentication record can be null. User
> provides the right user id/pwd and LDAP has the right information, though.
>
>
>
>
>
> public Authentication getAuthentication(String authenticationId,
> String password)
>
> throws AuthenticationException {
>
> Authentication auth = null;
>
> Element element = authCache.get(authenticationId);
>
> if (element != null) {
>
> AuthenticationRecord record =
> (AuthenticationRecord)element.getObjectValue();
>
> byte[] salt = new byte[saltLength];
>
> System.arraycopy(record.encodedPassword, 0, salt,
> 0, salt.length);
>
> byte[] encodedPassword = getEncrypted(password,
> salt);
>
> if (MessageDigest.isEqual(record.encodedPassword,
> encodedPassword)) {
>
> if (record.authentication == null) {
>
> if (log.isDebugEnabled())
> log.debug("getAuthentication: replaying authentication failure for
> authenticationId=" + authenticationId);
>
> throw new
> AuthenticationException("repeated invalid login");
>
> } else {
>
> if (log.isDebugEnabled())
> log.debug("getAuthentication: returning record for authenticationId=" +
> authenticationId);
>
> auth = record.authentication;
>
> }
>
> } else {
>
> // Since the passwords didn't match, we're
> no longer getting repeats,
>
> // and so the record should be removed.
>
> if (log.isDebugEnabled())
> log.debug("getAuthentication: record for authenticationId=" +
> authenticationId + " failed password check");
>
> authCache.remove(authenticationId);
>
> }
>
> }
>
> return auth;
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140910/0c7994be/attachment-0001.html
------------------------------
Message: 2
Date: Wed, 10 Sep 2014 15:46:21 -0700
From: Venkat Ravikanti <vravikan at yahoo.com>
Subject: [Building Sakai] Course enrollment information
To: sakai-dev <sakai-dev at collab.sakaiproject.org>
Message-ID:
<1410389181.50936.YahooMailNeo at web185405.mail.gq1.yahoo.com>
Content-Type: text/plain; charset="us-ascii"
Hi,
I am new to Sakai. Need your help on the Sakai Tables.
I am looking to find the mysql tables where the course enrollment information stored.
Here is my scenario:
1. Created Course Site with couple of courses
2. Created Users
3. Added the Users to the above created courses as Participants
Now when I am trying to query for the participants information in CM_ENROLLMENT_T or CM_ENROLLMENT_SET_T. No Luck. These two tables are empty
Can someone help with me following:
1. Data dictionary for Sakai tables with some notes on which table stands for what
2. Which table stores the participants or enrollment information.
Thanks for your help.
Venkat
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140910/c74b6884/attachment-0001.html
------------------------------
Message: 3
Date: Thu, 11 Sep 2014 11:24:26 +0530
From: "Ismail Naik" <ismail.n at in.uaeexchange.com>
Subject: Re: [Building Sakai] sakai grade book exception
To: "'Sam Ottenhoff'" <ottenhoff at longsight.com>
Cc: arunkumar.vr at in.uaeexchange.com, 'Developers Sakai-Dev'
<sakai-dev at collab.sakaiproject.org>
Message-ID: <01d701cfcd84$d92f0bf0$8b8d23d0$@in.uaeexchange.com>
Content-Type: text/plain; charset="utf-8"
Greetings Sam,
Attached custom JLDAP code.
We observed one more point
1. We couldn?t see the participants list for the site when trying to edit the site details and can?t able to change the role of the users.
We are getting exception when trying to access grade book with ?admin? role the same is working fine if we login with ?access? role.
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
From: Sam Ottenhoff [mailto:ottenhoff at longsight.com]
Sent: 10 September 2014 19:08
To: Ismail Naik
Cc: Developers Sakai-Dev; arunkumar.vr at in.uaeexchange.com
Subject: Re: [Building Sakai] sakai grade book exception
Please share your custom JLDAP code.
On Wed, Sep 10, 2014 at 4:11 AM, Ismail Naik <ismail.n at in.uaeexchange.com> wrote:
Greetings Team,
We are using sakai 2.9.3 and we had customized (sakai-jldap-provider-2.9.3.jar )the code for ldap integration, till now everything is fine, users can able to login with their AD details. But we got below exception when trying to access grade book with admin role the same if we login with access role.
Whether this is LDAP problem or application problem, any assistance is highly appreciable.
Find below the log:
Technical Details
This information will automatically be included in your bug report.
org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:894)
caused by: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1483)
caused by: javax.servlet.ServletException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
caused by: javax.faces.FacesException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
caused by: org.apache.jasper.JasperException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
caused by: java.lang.RuntimeException: getUsers(): RuntimeException during search eid = ally.antony]
at org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
caused by: java.lang.NullPointerException
at edu.amc.sakai.user.JLDAPDirectoryProvider.getCachedUserEntry(JLDAPDirectoryProvider.java:1228)
at edu.amc.sakai.user.JLDAPDirectoryProvider.getUsers(JLDAPDirectoryProvider.java:665)
at org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
at org.sakaiproject.user.impl.BaseUserDirectoryService.getUsers(BaseUserDirectoryService.java:788)
at org.sakaiproject.authz.impl.SakaiSecurity.unlockUsers(SakaiSecurity.java:348)
at org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteEnrollments(SectionAwarenessImpl.java:177)
at org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteMembersInRole(SectionAwarenessImpl.java:145)
at org.sakaiproject.component.gradebook.BaseHibernateManager.getAllStudentUids(BaseHibernateManager.java:154)
at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.getAssignmentsAndCourseGradeWithStats(GradebookManagerHibernateImpl.java:1525)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy108.getAssignmentsAndCourseGradeWithStats(null:-1)
at org.sakaiproject.tool.gradebook.ui.OverviewBean.init(OverviewBean.java:201)
at org.sakaiproject.tool.gradebook.ui.InitializableBean.startRenderResponse(InitializableBean.java:69)
at org.sakaiproject.jsf.component.FlowState.encodeBegin(FlowState.java:131)
at javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:467)
at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:320)
at org.apache.jsp.overview_jsp._jspx_meth_sakai_005fflowState_005f0(overview_jsp.java:1450)
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
Disclaimer: This communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance upon the information is strictly prohibited and is unlawful. If you have received this communication by error, please notify us immediately by responding to this email before deleting it from your system. UAE Exchange cannot be held responsible for the improper or incomplete transmission of information contained in this communication, or for any delay in its receipt.
Warning: Internet communication cannot be guaranteed to be timely, secure, error-free or virus-free. It is the responsibility of the recipient to ensure that this email and its attachments, if any, are free from viruses. UAE Exchange doesn't accept liability for any damage that may result from viruses transmitted through this email.
Please be informed that as per UAE Exchange Information Security policy, we will never request you to disclose your Account Number, Credit Card Information, User ID, Personal Identification Number (PIN), Telephone Identification Number (TIN), Password or any such information through e-mails or phone.
Any e-mail or written communication received by you, which appears to have been sent from UAE Exchange seeking your personal & confidential information, should not be answered but advised to UAE Exchange at info.sec at uaeexchange.com.
For further assistance email us at info.sec at uaeexchange.com.
_______________________________________________
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/20140911/16c3b7d0/attachment-0001.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: JLDAPDirectoryProvider.java
Type: application/octet-stream
Size: 32302 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140911/16c3b7d0/attachment-0001.obj
------------------------------
Message: 4
Date: Thu, 11 Sep 2014 13:02:51 +0530
From: "Ismail Naik" <ismail.n at in.uaeexchange.com>
Subject: [Building Sakai] Exception
To: <sakai-dev at collab.sakaiproject.org>
Message-ID: <000f01cfcd92$988f4840$c9add8c0$@in.uaeexchange.com>
Content-Type: text/plain; charset="us-ascii"
Greetings Team,
We are getting below exception while trying to may admin user inactive. Any
suggest to avoid this page/exception
Session
no session established
no tool session established
Unknown Request
Snoop for request
${req.toString()}
Request headers
Servlet parameters (Single Value style):
Servlet parameters (Multiple Value style):
Request Attributes:
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
Disclaimer: This communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance upon the information is strictly prohibited and is unlawful. If you have received this communication by error, please notify us immediately by responding to this email before deleting it from your system. UAE Exchange cannot be held responsible for the improper or incomplete transmission of information contained in this communication, or for any delay in its receipt.
Warning: Internet communication cannot be guaranteed to be timely, secure, error-free or virus-free. It is the responsibility of the recipient to ensure that this email and its attachments, if any, are free from viruses. UAE Exchange doesn't accept liability for any damage that may result from viruses transmitted through this email.
Please be informed that as per UAE Exchange Information Security policy, we will never request you to disclose your Account Number, Credit Card Information, User ID, Personal Identification Number (PIN), Telephone Identification Number (TIN), Password or any such information through e-mails or phone.
Any e-mail or written communication received by you, which appears to have been sent from UAE Exchange seeking your personal & confidential information, should not be answered but advised to UAE Exchange at info.sec at uaeexchange.com
For further assistance email us at info.sec at uaeexchange.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140911/b5d24419/attachment-0001.html
------------------------------
Message: 5
Date: Thu, 11 Sep 2014 09:44:11 -0400
From: Sam Ottenhoff <ottenhoff at longsight.com>
Subject: Re: [Building Sakai] sakai grade book exception
To: Ismail Naik <ismail.n at in.uaeexchange.com>
Cc: arunkumar.vr at in.uaeexchange.com, Developers Sakai-Dev
<sakai-dev at collab.sakaiproject.org>
Message-ID:
<CAJEDiB4vH8O2MtSkifS_tK4pAhjX2WgqehBCv98ZKsi4PYgNTw at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
This isn't the code you are running. The code you are running provided a
stack trace:
caused by: java.lang.NullPointerException
at
edu.amc.sakai.user.JLDAPDirectoryProvider.getCachedUserEntry(JLDAPDirectoryProvider.java:1228)
But the code you sent contains only 1018 lines.
On Thu, Sep 11, 2014 at 1:54 AM, Ismail Naik <ismail.n at in.uaeexchange.com>
wrote:
> Greetings Sam,
>
>
>
> Attached custom JLDAP code.
>
>
>
> We observed one more point
>
>
>
> 1. We couldn?t see the participants list for the site when trying
> to edit the site details and can?t able to change the role of the users.
>
>
>
> *We are getting exception when trying to access grade book with ?admin?
> role the same is working fine if we login with ?access? role.*
>
>
>
> *Thanks & Regards*
>
> *Ismail N**.* - IT Department
>
> *X**m* *Software** Solutions Pvt Ltd* | SKCL | CENTRAL SQUARE- 1
>
> CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
>
> TEL: 044-30464899 | FAX: 044-30464861|
>
> Ext:613
>
> ismail.n at in.uaeexchange.com
>
>
>
> *From:* Sam Ottenhoff [mailto:ottenhoff at longsight.com]
> *Sent:* 10 September 2014 19:08
> *To:* Ismail Naik
> *Cc:* Developers Sakai-Dev; arunkumar.vr at in.uaeexchange.com
> *Subject:* Re: [Building Sakai] sakai grade book exception
>
>
>
> Please share your custom JLDAP code.
>
>
>
> On Wed, Sep 10, 2014 at 4:11 AM, Ismail Naik <ismail.n at in.uaeexchange.com>
> wrote:
>
> Greetings Team,
>
>
>
> We are using sakai 2.9.3 and we had customized
> (sakai-jldap-provider-2.9.3.jar )the code for ldap integration, till now
> everything is fine, users can able to login with their AD details. But we
> got below exception *when trying to access grade book with admin role the
> same if we login with access role.*
>
>
>
> Whether *this is LDAP problem or application problem, any assistance is
> highly appreciable.*
>
>
>
> *Find below the log:*
>
>
>
>
>
> Technical Details
>
> This information will automatically be included in your bug report.
>
>
>
> org.sakaiproject.portal.api.PortalHandlerException:
> org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: An
> exception occurred processing JSP page /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:894)
>
> caused by: org.sakaiproject.tool.api.ToolException:
> javax.servlet.ServletException: An exception occurred processing JSP page
> /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1483)
>
> caused by: javax.servlet.ServletException: An exception occurred
> processing JSP page /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>
> caused by: javax.faces.FacesException: An exception occurred processing
> JSP page /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
>
> caused by: org.apache.jasper.JasperException: An exception occurred
> processing JSP page /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
>
> caused by: java.lang.RuntimeException: getUsers(): RuntimeException during
> search eid = ally.antony]
>
> at
> org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
>
> caused by: java.lang.NullPointerException
>
> at
> edu.amc.sakai.user.JLDAPDirectoryProvider.getCachedUserEntry(JLDAPDirectoryProvider.java:1228)
>
> at
> edu.amc.sakai.user.JLDAPDirectoryProvider.getUsers(JLDAPDirectoryProvider.java:665)
>
> at
> org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
>
> at
> org.sakaiproject.user.impl.BaseUserDirectoryService.getUsers(BaseUserDirectoryService.java:788)
>
> at
> org.sakaiproject.authz.impl.SakaiSecurity.unlockUsers(SakaiSecurity.java:348)
>
> at
> org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteEnrollments(SectionAwarenessImpl.java:177)
>
> at
> org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteMembersInRole(SectionAwarenessImpl.java:145)
>
> at
> org.sakaiproject.component.gradebook.BaseHibernateManager.getAllStudentUids(BaseHibernateManager.java:154)
>
> at
> org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.getAssignmentsAndCourseGradeWithStats(GradebookManagerHibernateImpl.java:1525)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:616)
>
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
>
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
>
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>
> at $Proxy108.getAssignmentsAndCourseGradeWithStats(null:-1)
>
> at
> org.sakaiproject.tool.gradebook.ui.OverviewBean.init(OverviewBean.java:201)
>
> at
> org.sakaiproject.tool.gradebook.ui.InitializableBean.startRenderResponse(InitializableBean.java:69)
>
> at
> org.sakaiproject.jsf.component.FlowState.encodeBegin(FlowState.java:131)
>
> at
> javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:467)
>
> at
> javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:320)
>
> at
> org.apache.jsp.overview_jsp._jspx_meth_sakai_005fflowState_005f0(overview_jsp.java:1450)
>
> *Thanks & Regards*
>
> *Ismail N**.* - IT Department
>
> *X**m** Software Solutions Pvt Ltd* | SKCL | CENTRAL SQUARE- 1
>
> CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
>
> TEL: 044-30464899 | FAX: 044-30464861|
>
> Ext:613
>
> ismail.n at in.uaeexchange.com
>
>
>
> *Disclaimer*: This communication is intended solely for the use of the
> individual or entity to whom it is addressed and others authorized to
> receive it. It may contain confidential or legally privileged information.
> If you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution, or action taken in reliance upon the
> information is strictly prohibited and is unlawful. If you have received
> this communication by error, please notify us immediately by responding to
> this email before deleting it from your system. UAE Exchange cannot be held
> responsible for the improper or incomplete transmission of information
> contained in this communication, or for any delay in its receipt.
> *Warning*: Internet communication cannot be guaranteed to be timely,
> secure, error-free or virus-free. It is the responsibility of the recipient
> to ensure that this email and its attachments, if any, are free from
> viruses. UAE Exchange doesn't accept liability for any damage that may
> result from viruses transmitted through this email.
> Please be informed that as per UAE Exchange Information Security policy,
> we will never request you to disclose your Account Number, Credit Card
> Information, User ID, Personal Identification Number (PIN), Telephone
> Identification Number (TIN), Password or any such information through
> e-mails or phone.
> Any e-mail or written communication received by you, which appears to have
> been sent from UAE Exchange seeking your personal & confidential
> information, should not be answered but advised to UAE Exchange at
> info.sec at uaeexchange.com.
> For further assistance email us at info.sec at uaeexchange.com.
>
>
> _______________________________________________
> 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/20140911/54686224/attachment-0001.html
------------------------------
Message: 6
Date: Thu, 11 Sep 2014 19:35:09 +0530
From: "Ismail Naik" <ismail.n at in.uaeexchange.com>
Subject: Re: [Building Sakai] sakai grade book exception
To: "'Sam Ottenhoff'" <ottenhoff at longsight.com>
Cc: arunkumar.vr at in.uaeexchange.com, 'Developers Sakai-Dev'
<sakai-dev at collab.sakaiproject.org>
Message-ID: <002901cfcdc9$660a10d0$321e3270$@in.uaeexchange.com>
Content-Type: text/plain; charset="utf-8"
That was extracted source code from jar file (sakai-jldap-provider-2.9.3.jar) which is running in production server there were comments in between it was removed so line were reduced.
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
From: Sam Ottenhoff [mailto:ottenhoff at longsight.com]
Sent: 11 September 2014 19:14
To: Ismail Naik
Cc: Developers Sakai-Dev; arunkumar.vr at in.uaeexchange.com
Subject: Re: [Building Sakai] sakai grade book exception
This isn't the code you are running. The code you are running provided a stack trace:
caused by: java.lang.NullPointerException
at edu.amc.sakai.user.JLDAPDirectoryProvider.getCachedUserEntry(JLDAPDirectoryProvider.java:1228)
But the code you sent contains only 1018 lines.
On Thu, Sep 11, 2014 at 1:54 AM, Ismail Naik <ismail.n at in.uaeexchange.com> wrote:
Greetings Sam,
Attached custom JLDAP code.
We observed one more point
1. We couldn?t see the participants list for the site when trying to edit the site details and can?t able to change the role of the users.
We are getting exception when trying to access grade book with ?admin? role the same is working fine if we login with ?access? role.
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
From: Sam Ottenhoff [mailto:ottenhoff at longsight.com]
Sent: 10 September 2014 19:08
To: Ismail Naik
Cc: Developers Sakai-Dev; arunkumar.vr at in.uaeexchange.com
Subject: Re: [Building Sakai] sakai grade book exception
Please share your custom JLDAP code.
On Wed, Sep 10, 2014 at 4:11 AM, Ismail Naik <ismail.n at in.uaeexchange.com> wrote:
Greetings Team,
We are using sakai 2.9.3 and we had customized (sakai-jldap-provider-2.9.3.jar )the code for ldap integration, till now everything is fine, users can able to login with their AD details. But we got below exception when trying to access grade book with admin role the same if we login with access role.
Whether this is LDAP problem or application problem, any assistance is highly appreciable.
Find below the log:
Technical Details
This information will automatically be included in your bug report.
org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:894)
caused by: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1483)
caused by: javax.servlet.ServletException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
caused by: javax.faces.FacesException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
caused by: org.apache.jasper.JasperException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
caused by: java.lang.RuntimeException: getUsers(): RuntimeException during search eid = ally.antony]
at org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
caused by: java.lang.NullPointerException
at edu.amc.sakai.user.JLDAPDirectoryProvider.getCachedUserEntry(JLDAPDirectoryProvider.java:1228)
at edu.amc.sakai.user.JLDAPDirectoryProvider.getUsers(JLDAPDirectoryProvider.java:665)
at org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
at org.sakaiproject.user.impl.BaseUserDirectoryService.getUsers(BaseUserDirectoryService.java:788)
at org.sakaiproject.authz.impl.SakaiSecurity.unlockUsers(SakaiSecurity.java:348)
at org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteEnrollments(SectionAwarenessImpl.java:177)
at org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteMembersInRole(SectionAwarenessImpl.java:145)
at org.sakaiproject.component.gradebook.BaseHibernateManager.getAllStudentUids(BaseHibernateManager.java:154)
at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.getAssignmentsAndCourseGradeWithStats(GradebookManagerHibernateImpl.java:1525)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy108.getAssignmentsAndCourseGradeWithStats(null:-1)
at org.sakaiproject.tool.gradebook.ui.OverviewBean.init(OverviewBean.java:201)
at org.sakaiproject.tool.gradebook.ui.InitializableBean.startRenderResponse(InitializableBean.java:69)
at org.sakaiproject.jsf.component.FlowState.encodeBegin(FlowState.java:131)
at javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:467)
at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:320)
at org.apache.jsp.overview_jsp._jspx_meth_sakai_005fflowState_005f0(overview_jsp.java:1450)
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
Disclaimer: This communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance upon the information is strictly prohibited and is unlawful. If you have received this communication by error, please notify us immediately by responding to this email before deleting it from your system. UAE Exchange cannot be held responsible for the improper or incomplete transmission of information contained in this communication, or for any delay in its receipt.
Warning: Internet communication cannot be guaranteed to be timely, secure, error-free or virus-free. It is the responsibility of the recipient to ensure that this email and its attachments, if any, are free from viruses. UAE Exchange doesn't accept liability for any damage that may result from viruses transmitted through this email.
Please be informed that as per UAE Exchange Information Security policy, we will never request you to disclose your Account Number, Credit Card Information, User ID, Personal Identification Number (PIN), Telephone Identification Number (TIN), Password or any such information through e-mails or phone.
Any e-mail or written communication received by you, which appears to have been sent from UAE Exchange seeking your personal & confidential information, should not be answered but advised to UAE Exchange at info.sec at uaeexchange.com.
For further assistance email us at info.sec at uaeexchange.com.
_______________________________________________
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/20140911/1f42927f/attachment-0001.html
------------------------------
Message: 7
Date: Thu, 11 Sep 2014 10:12:32 -0400
From: Sam Ottenhoff <ottenhoff at longsight.com>
Subject: Re: [Building Sakai] sakai grade book exception
To: Ismail Naik <ismail.n at in.uaeexchange.com>
Cc: arunkumar.vr at in.uaeexchange.com, Developers Sakai-Dev
<sakai-dev at collab.sakaiproject.org>
Message-ID:
<CAJEDiB6t9dBhstD2Qe=Nno4P=2w2o_jycOdv7WQd-uXmxNy9tA at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Okay, I can't help you then. But the basics of Java debugging involve
taking the stacktrace and then looking at your Java source code on that
exact line. In the case of NullPointerExceptions, debugging should be
simple and straightforward.
On Thu, Sep 11, 2014 at 10:05 AM, Ismail Naik <ismail.n at in.uaeexchange.com>
wrote:
> That was extracted source code from jar file (sakai-jldap-provider-2.9.3.jar)
> which is running in production server there were comments in between it was
> removed so line were reduced.
>
>
>
> *Thanks & Regards*
>
> *Ismail N**.* - IT Department
>
> *X**m* *Software** Solutions Pvt Ltd* | SKCL | CENTRAL SQUARE- 1
>
> CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
>
> TEL: 044-30464899 | FAX: 044-30464861|
>
> Ext:613
>
> ismail.n at in.uaeexchange.com
>
>
>
> *From:* Sam Ottenhoff [mailto:ottenhoff at longsight.com]
> *Sent:* 11 September 2014 19:14
>
> *To:* Ismail Naik
> *Cc:* Developers Sakai-Dev; arunkumar.vr at in.uaeexchange.com
> *Subject:* Re: [Building Sakai] sakai grade book exception
>
>
>
> This isn't the code you are running. The code you are running provided a
> stack trace:
>
>
>
> caused by: java.lang.NullPointerException
>
> at
> edu.amc.sakai.user.JLDAPDirectoryProvider.getCachedUserEntry(JLDAPDirectoryProvider.java:1228)
>
>
>
> But the code you sent contains only 1018 lines.
>
>
>
> On Thu, Sep 11, 2014 at 1:54 AM, Ismail Naik <ismail.n at in.uaeexchange.com>
> wrote:
>
> Greetings Sam,
>
>
>
> Attached custom JLDAP code.
>
>
>
> We observed one more point
>
>
>
> 1. We couldn?t see the participants list for the site when trying
> to edit the site details and can?t able to change the role of the users.
>
>
>
> *We are getting exception when trying to access grade book with ?admin?
> role the same is working fine if we login with ?access? role.*
>
>
>
> *Thanks & Regards*
>
> *Ismail N**.* - IT Department
>
> *X**m** Software Solutions Pvt Ltd* | SKCL | CENTRAL SQUARE- 1
>
> CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
>
> TEL: 044-30464899 | FAX: 044-30464861|
>
> Ext:613
>
> ismail.n at in.uaeexchange.com
>
>
>
> *From:* Sam Ottenhoff [mailto:ottenhoff at longsight.com]
> *Sent:* 10 September 2014 19:08
> *To:* Ismail Naik
> *Cc:* Developers Sakai-Dev; arunkumar.vr at in.uaeexchange.com
> *Subject:* Re: [Building Sakai] sakai grade book exception
>
>
>
> Please share your custom JLDAP code.
>
>
>
> On Wed, Sep 10, 2014 at 4:11 AM, Ismail Naik <ismail.n at in.uaeexchange.com>
> wrote:
>
> Greetings Team,
>
>
>
> We are using sakai 2.9.3 and we had customized
> (sakai-jldap-provider-2.9.3.jar )the code for ldap integration, till now
> everything is fine, users can able to login with their AD details. But we
> got below exception *when trying to access grade book with admin role the
> same if we login with access role.*
>
>
>
> Whether *this is LDAP problem or application problem, any assistance is
> highly appreciable.*
>
>
>
> *Find below the log:*
>
>
>
>
>
> Technical Details
>
> This information will automatically be included in your bug report.
>
>
>
> org.sakaiproject.portal.api.PortalHandlerException:
> org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: An
> exception occurred processing JSP page /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:894)
>
> caused by: org.sakaiproject.tool.api.ToolException:
> javax.servlet.ServletException: An exception occurred processing JSP page
> /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1483)
>
> caused by: javax.servlet.ServletException: An exception occurred
> processing JSP page /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>
> caused by: javax.faces.FacesException: An exception occurred processing
> JSP page /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
>
> caused by: org.apache.jasper.JasperException: An exception occurred
> processing JSP page /overview.jsp at line 12
>
>
>
> 9: <%@ include file="/inc/appMenu.jspf"%>
>
> 10: </t:aliasBean>
>
> 11:
>
> 12: <sakai:flowState bean="#{overviewBean}" />
>
> 13:
>
> 14: <h2><h:outputText
> value="#{msgs.appmenu_overview}"/></h2>
>
> 15:
>
>
>
>
>
> Stacktrace:
>
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
>
> caused by: java.lang.RuntimeException: getUsers(): RuntimeException during
> search eid = ally.antony]
>
> at
> org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
>
> caused by: java.lang.NullPointerException
>
> at
> edu.amc.sakai.user.JLDAPDirectoryProvider.getCachedUserEntry(JLDAPDirectoryProvider.java:1228)
>
> at
> edu.amc.sakai.user.JLDAPDirectoryProvider.getUsers(JLDAPDirectoryProvider.java:665)
>
> at
> org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
>
> at
> org.sakaiproject.user.impl.BaseUserDirectoryService.getUsers(BaseUserDirectoryService.java:788)
>
> at
> org.sakaiproject.authz.impl.SakaiSecurity.unlockUsers(SakaiSecurity.java:348)
>
> at
> org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteEnrollments(SectionAwarenessImpl.java:177)
>
> at
> org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteMembersInRole(SectionAwarenessImpl.java:145)
>
> at
> org.sakaiproject.component.gradebook.BaseHibernateManager.getAllStudentUids(BaseHibernateManager.java:154)
>
> at
> org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.getAssignmentsAndCourseGradeWithStats(GradebookManagerHibernateImpl.java:1525)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:616)
>
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
>
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
>
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
>
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>
> at $Proxy108.getAssignmentsAndCourseGradeWithStats(null:-1)
>
> at
> org.sakaiproject.tool.gradebook.ui.OverviewBean.init(OverviewBean.java:201)
>
> at
> org.sakaiproject.tool.gradebook.ui.InitializableBean.startRenderResponse(InitializableBean.java:69)
>
> at
> org.sakaiproject.jsf.component.FlowState.encodeBegin(FlowState.java:131)
>
> at
> javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:467)
>
> at
> javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:320)
>
> at
> org.apache.jsp.overview_jsp._jspx_meth_sakai_005fflowState_005f0(overview_jsp.java:1450)
>
> *Thanks & Regards*
>
> *Ismail N**.* - IT Department
>
> *X**m** Software Solutions Pvt Ltd* | SKCL | CENTRAL SQUARE- 1
>
> CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
>
> TEL: 044-30464899 | FAX: 044-30464861|
>
> Ext:613
>
> ismail.n at in.uaeexchange.com
>
>
>
> *Disclaimer*: This communication is intended solely for the use of the
> individual or entity to whom it is addressed and others authorized to
> receive it. It may contain confidential or legally privileged information.
> If you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution, or action taken in reliance upon the
> information is strictly prohibited and is unlawful. If you have received
> this communication by error, please notify us immediately by responding to
> this email before deleting it from your system. UAE Exchange cannot be held
> responsible for the improper or incomplete transmission of information
> contained in this communication, or for any delay in its receipt.
> *Warning*: Internet communication cannot be guaranteed to be timely,
> secure, error-free or virus-free. It is the responsibility of the recipient
> to ensure that this email and its attachments, if any, are free from
> viruses. UAE Exchange doesn't accept liability for any damage that may
> result from viruses transmitted through this email.
> Please be informed that as per UAE Exchange Information Security policy,
> we will never request you to disclose your Account Number, Credit Card
> Information, User ID, Personal Identification Number (PIN), Telephone
> Identification Number (TIN), Password or any such information through
> e-mails or phone.
> Any e-mail or written communication received by you, which appears to have
> been sent from UAE Exchange seeking your personal & confidential
> information, should not be answered but advised to UAE Exchange at
> info.sec at uaeexchange.com.
> For further assistance email us at info.sec at uaeexchange.com.
>
>
> _______________________________________________
> 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/20140911/097d82f5/attachment-0001.html
------------------------------
Message: 8
Date: Thu, 11 Sep 2014 15:26:29 +0100
From: Adrian Fish <adrian.r.fish at gmail.com>
Subject: Re: [Building Sakai] Modifying Clog tool for Assessment
To: "Myburgh, Francette" <FMyburgh at unisa.ac.za>
Cc: "sakai-dev \(sakai-dev at collab.sakaiproject.org\)"
<sakai-dev at collab.sakaiproject.org>
Message-ID:
<CAM0rk3Fe74QkpxG7Y9dyxLJH5mY7SFE7ouCP4gTufiAA0XHYYw at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Hi Francette,
I don't think it's a great idea to fork CLOG and start a new tool. The
functionality you describe doesn't sound like it should require a radical
change in UI, so I think the risk of fragmenting a developer community by
forking isn't justified. Have you got any UI mockups you could show us?
It would also be good to see some real world figures demonstrating the
amount of data being downloaded on a site's CLOG tool. You could use cURL
on your biggest site and just save the json chunk. I think it would make
more sense to actually page the entire posts, rather than just the titles.
A long list of titles doesn't sound very useful compared to a series of
full post pages.
Cheers,
Adrian.
On 10 September 2014 11:35, Myburgh, Francette <FMyburgh at unisa.ac.za> wrote:
> This message (and attachments) is subject to restrictions and a
> disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full
> details.
> ------------------------------
>
> Hello everyone
>
>
>
> Just a heads up about some development work we are planning to do on the
> Clog tool. Your advice is welcomed.
>
>
>
> For our fully online courses, academics have indicated that they want to
> use blogging for formal assessment purposes.
> We have identified some gaps and issues with the current Clog tool that we
> need to address to support their assessment practices. Here are some of
> them:
>
> 1. Timeout issues because of the large numbers of blogs that need
> to load on the first page of the tool
> So we want to display only the titles on the first page. Users can then
> click on a title to open that specific title, with paging for the rest.
>
> 2. Add the ability for closing the clog tool for editing (but not
> reading)
>
> 3. Adding a marking interface and link the tool with the Gradebook
>
>
>
> Our intended development work will result in a major change to the tool
> presentation. Question: is anyone else interested in using the Clog tool
> in this manner? Should we make these changes available as an adaptation of
> Clog or release a new tool altogether?
>
>
>
> Regards
>
> Francette Myburgh
>
> UNISA
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140911/0b7e43a8/attachment-0001.html
------------------------------
Message: 9
Date: Thu, 11 Sep 2014 19:54:24 +0530
From: "Ismail Naik" <ismail.n at in.uaeexchange.com>
Subject: Re: [Building Sakai] sakai grade book exception
To: "'Sam Ottenhoff'" <ottenhoff at longsight.com>
Cc: arunkumar.vr at in.uaeexchange.com, 'Developers Sakai-Dev'
<sakai-dev at collab.sakaiproject.org>
Message-ID: <003701cfcdcc$16834d80$4389e880$@in.uaeexchange.com>
Content-Type: text/plain; charset="utf-8"
Hmm? The thing is we are able authenticate AD users with JLdap integration,
We are getting this after some time(may be after 30 or 6o mins) post ?site? creation, till then it fine, showing the grades and roster list. We will look into this mean while any solution will be greeted.
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
From: Sam Ottenhoff [mailto:ottenhoff at longsight.com]
Sent: 11 September 2014 19:43
To: Ismail Naik
Cc: Developers Sakai-Dev; arunkumar.vr at in.uaeexchange.com
Subject: Re: [Building Sakai] sakai grade book exception
Okay, I can't help you then. But the basics of Java debugging involve taking the stacktrace and then looking at your Java source code on that exact line. In the case of NullPointerExceptions, debugging should be simple and straightforward.
On Thu, Sep 11, 2014 at 10:05 AM, Ismail Naik <ismail.n at in.uaeexchange.com> wrote:
That was extracted source code from jar file (sakai-jldap-provider-2.9.3.jar) which is running in production server there were comments in between it was removed so line were reduced.
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
From: Sam Ottenhoff [mailto:ottenhoff at longsight.com]
Sent: 11 September 2014 19:14
To: Ismail Naik
Cc: Developers Sakai-Dev; arunkumar.vr at in.uaeexchange.com
Subject: Re: [Building Sakai] sakai grade book exception
This isn't the code you are running. The code you are running provided a stack trace:
caused by: java.lang.NullPointerException
at edu.amc.sakai.user.JLDAPDirectoryProvider.getCachedUserEntry(JLDAPDirectoryProvider.java:1228)
But the code you sent contains only 1018 lines.
On Thu, Sep 11, 2014 at 1:54 AM, Ismail Naik <ismail.n at in.uaeexchange.com> wrote:
Greetings Sam,
Attached custom JLDAP code.
We observed one more point
1. We couldn?t see the participants list for the site when trying to edit the site details and can?t able to change the role of the users.
We are getting exception when trying to access grade book with ?admin? role the same is working fine if we login with ?access? role.
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
From: Sam Ottenhoff [mailto:ottenhoff at longsight.com]
Sent: 10 September 2014 19:08
To: Ismail Naik
Cc: Developers Sakai-Dev; arunkumar.vr at in.uaeexchange.com
Subject: Re: [Building Sakai] sakai grade book exception
Please share your custom JLDAP code.
On Wed, Sep 10, 2014 at 4:11 AM, Ismail Naik <ismail.n at in.uaeexchange.com> wrote:
Greetings Team,
We are using sakai 2.9.3 and we had customized (sakai-jldap-provider-2.9.3.jar )the code for ldap integration, till now everything is fine, users can able to login with their AD details. But we got below exception when trying to access grade book with admin role the same if we login with access role.
Whether this is LDAP problem or application problem, any assistance is highly appreciable.
Find below the log:
Technical Details
This information will automatically be included in your bug report.
org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:894)
caused by: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1483)
caused by: javax.servlet.ServletException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
caused by: javax.faces.FacesException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
caused by: org.apache.jasper.JasperException: An exception occurred processing JSP page /overview.jsp at line 12
9: <%@ include file="/inc/appMenu.jspf"%>
10: </t:aliasBean>
11:
12: <sakai:flowState bean="#{overviewBean}" />
13:
14: <h2><h:outputText value="#{msgs.appmenu_overview}"/></h2>
15:
Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
caused by: java.lang.RuntimeException: getUsers(): RuntimeException during search eid = ally.antony]
at org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
caused by: java.lang.NullPointerException
at edu.amc.sakai.user.JLDAPDirectoryProvider.getCachedUserEntry(JLDAPDirectoryProvider.java:1228)
at edu.amc.sakai.user.JLDAPDirectoryProvider.getUsers(JLDAPDirectoryProvider.java:665)
at org.sakaiproject.user.impl.DbUserService$DbStorage.getUsersByIds(DbUserService.java:710)
at org.sakaiproject.user.impl.BaseUserDirectoryService.getUsers(BaseUserDirectoryService.java:788)
at org.sakaiproject.authz.impl.SakaiSecurity.unlockUsers(SakaiSecurity.java:348)
at org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteEnrollments(SectionAwarenessImpl.java:177)
at org.sakaiproject.component.section.sakai.SectionAwarenessImpl.getSiteMembersInRole(SectionAwarenessImpl.java:145)
at org.sakaiproject.component.gradebook.BaseHibernateManager.getAllStudentUids(BaseHibernateManager.java:154)
at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.getAssignmentsAndCourseGradeWithStats(GradebookManagerHibernateImpl.java:1525)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy108.getAssignmentsAndCourseGradeWithStats(null:-1)
at org.sakaiproject.tool.gradebook.ui.OverviewBean.init(OverviewBean.java:201)
at org.sakaiproject.tool.gradebook.ui.InitializableBean.startRenderResponse(InitializableBean.java:69)
at org.sakaiproject.jsf.component.FlowState.encodeBegin(FlowState.java:131)
at javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:467)
at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:320)
at org.apache.jsp.overview_jsp._jspx_meth_sakai_005fflowState_005f0(overview_jsp.java:1450)
Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka Industrial Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
<mailto:ismail.n at in.uaeexchange.com> ismail.n at in.uaeexchange.com
Disclaimer: This communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance upon the information is strictly prohibited and is unlawful. If you have received this communication by error, please notify us immediately by responding to this email before deleting it from your system. UAE Exchange cannot be held responsible for the improper or incomplete transmission of information contained in this communication, or for any delay in its receipt.
Warning: Internet communication cannot be guaranteed to be timely, secure, error-free or virus-free. It is the responsibility of the recipient to ensure that this email and its attachments, if any, are free from viruses. UAE Exchange doesn't accept liability for any damage that may result from viruses transmitted through this email.
Please be informed that as per UAE Exchange Information Security policy, we will never request you to disclose your Account Number, Credit Card Information, User ID, Personal Identification Number (PIN), Telephone Identification Number (TIN), Password or any such information through e-mails or phone.
Any e-mail or written communication received by you, which appears to have been sent from UAE Exchange seeking your personal & confidential information, should not be answered but advised to UAE Exchange at info.sec at uaeexchange.com.
For further assistance email us at info.sec at uaeexchange.com.
_______________________________________________
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/20140911/1ce4595a/attachment-0001.html
------------------------------
Message: 10
Date: Thu, 11 Sep 2014 10:26:58 -0400
From: Brian Baillargeon <bbailla2 at uwo.ca>
Subject: Re: [Building Sakai] Course enrollment information
To: Venkat Ravikanti <vravikan at yahoo.com>, sakai-dev
<sakai-dev at collab.sakaiproject.org>
Message-ID: <5411B132.4030602 at uwo.ca>
Content-Type: text/plain; charset="us-ascii"
I just did a quick search on confluence.sakaiproject.org and found a
little documentation that hasn't been modified since 2006, but it might
be useful nonetheless:
https://confluence.sakaiproject.org/display/CM/CM+API+Design+-+Round+1
Anyway, the table that stores roster memberships is CM_MEMBERSHIP_T
mysql> describe cm_membership_t;
+---------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+---------------------+--------------+------+-----+---------+----------------+
| MEMBER_ID | bigint(20) | NO | PRI | NULL |
auto_increment |
| VERSION | int(11) | NO | | NULL | |
| USER_ID | varchar(255) | NO | MUL | NULL | |
| ROLE | varchar(255) | NO | | NULL | |
| MEMBER_CONTAINER_ID | bigint(20) | YES | MUL | NULL | |
| STATUS | varchar(255) | YES | | NULL | |
+---------------------+--------------+------+-----+---------+----------------+
Note: the CM_ tables store information about official rosters, which
might not necessarily map to users' current role in the site if a role
has been changed. Also, you won't find any unofficial participants in
these tables. If you want the union of official and unofficial
participants, I think they can be found in sakai_realm_rl_gr, but there
might be a more authoritative source.
On 14-09-10 06:46 PM, Venkat Ravikanti wrote:
> Hi,
>
> I am new to Sakai. Need your help on the Sakai Tables.
>
> I am looking to find the mysql tables where the course enrollment
> information stored.
>
> Here is my scenario:
>
> 1. Created Course Site with couple of courses
> 2. Created Users
> 3. Added the Users to the above created courses as Participants
>
> Now when I am trying to query for the participants information in
> CM_ENROLLMENT_T or CM_ENROLLMENT_SET_T. No Luck. These two tables are
> empty
>
> Can someone help with me following:
>
> 1. Data dictionary for Sakai tables with some notes on which table
> stands for what
> 2. Which table stores the participants or enrollment information.
>
>
> Thanks for your help.
> Venkat
>
>
> _______________________________________________
> 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/20140911/97482735/attachment-0001.html
------------------------------
Message: 11
Date: Thu, 11 Sep 2014 08:11:12 -0700
From: Venkat Ravikanti <vravikan at yahoo.com>
Subject: Re: [Building Sakai] Course enrollment information
To: Brian Baillargeon <bbailla2 at uwo.ca>, sakai-dev
<sakai-dev at collab.sakaiproject.org>
Message-ID:
<1410448272.9727.YahooMailNeo at web185402.mail.gq1.yahoo.com>
Content-Type: text/plain; charset="us-ascii"
Thanks Brian.
I looked into table CM_MEMBERSHIP_T. There are no records in it.
I also added Official Participants to Course.
No records in CM_MEMBERSHIP_T or any Enrollment tables.
Can someone shed more light on SAKAI_REALM tables. I am not getting any clue.
Thanks,
Venkat
On Thursday, September 11, 2014 10:26 AM, Brian Baillargeon <bbailla2 at uwo.ca> wrote:
I just did a quick search on confluence.sakaiproject.org and found a little documentation that hasn't been modified since 2006, but it might be useful nonetheless:
https://confluence.sakaiproject.org/display/CM/CM+API+Design+-+Round+1
Anyway, the table that stores roster memberships is
CM_MEMBERSHIP_T
mysql> describe cm_membership_t;
+---------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+---------------------+--------------+------+-----+---------+----------------+
| MEMBER_ID | bigint(20) | NO | PRI | NULL |
auto_increment |
| VERSION | int(11) | NO | | NULL
| |
| USER_ID | varchar(255) | NO | MUL | NULL
| |
| ROLE | varchar(255) | NO | | NULL
| |
| MEMBER_CONTAINER_ID | bigint(20) | YES | MUL | NULL
| |
| STATUS | varchar(255) | YES | | NULL
| |
+---------------------+--------------+------+-----+---------+----------------+
Note: the CM_ tables store information about official rosters,
which might not necessarily map to users' current role in the site
if a role has been changed. Also, you won't find any unofficial
participants in these tables. If you want the union of official
and unofficial participants, I think they can be found in
sakai_realm_rl_gr, but there might be a more authoritative source.
On 14-09-10 06:46 PM, Venkat Ravikanti wrote:
Hi,
>
>
>I am new to Sakai. Need your help on the Sakai Tables.
>
>
>I am looking to find the mysql tables where the course enrollment information stored.
>
>
>Here is my scenario:
>
>
>1. Created Course Site with couple of courses
>2. Created Users
>3. Added the Users to the above created courses as Participants
>
>
>Now when I am trying to query for the participants information in CM_ENROLLMENT_T or CM_ENROLLMENT_SET_T. No Luck. These two tables are empty
>
>
>Can someone help with me following:
>
>
>1. Data dictionary for Sakai tables with some notes on which table stands for what
>2. Which table stores the participants or enrollment information.
>
>
>
>
>Thanks for your help.
>Venkat
>
>
>_______________________________________________
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/20140911/f8a73507/attachment-0001.html
------------------------------
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
End of sakai-dev Digest, Vol 67, Issue 9
****************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140913/2cf9059a/attachment.html
More information about the sakai-dev
mailing list