[Building Sakai] How to create user using Sql Queries

[Jehan]

Everything works fine,

 but following error log is generating when creating new user or updating
existing user



Jun 23, 2014 2:32:08 PM org.apache.catalina.loader.WebappClassLoader
loadClass
INFO: Illegal access: this web application instance has been stopped
already.  C
ould not load org.sakaiproject.sitestats.impl.ServerStatImpl.  The eventual
foll
owing stack trace is caused by an error thrown for debugging purposes as
well as
 to attempt to terminate the thread which caused the illegal access, and
has no
functional impact.
java.lang.IllegalStateException
        at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1599)
        at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1558)
        at
org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:164)

        at
org.hibernate.impl.SessionFactoryImpl.getImplementors(SessionFactoryI
mpl.java:730)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1544)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
        at
org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.doUpdateServer
StatObjects(StatsUpdateManagerImpl.java:1157)
        at
org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.access$1400(St
atsUpdateManagerImpl.java:76)
        at
org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl$4.doInHibernat
e(StatsUpdateManagerImpl.java:878)
        at
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(Hibern
ateTemplate.java:419)
        at
org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:339)
        at
org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.doUpdateConsol
idatedEvents(StatsUpdateManagerImpl.java:805)
        at
org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.run(StatsUpdat
eManagerImpl.java:484)
        at java.lang.Thread.run(Thread.java:619)



On Mon, Jun 23, 2014 at 1:04 PM, Jehan <jeehaaan at gmail.com> wrote:

> Thanks! problem resolved, it was realm entry missing.
>
>
>
> On Mon, Jun 23, 2014 at 10:24 AM, Jehan <jeehaaan at gmail.com> wrote:
>
>> Dear Metthew Jhones!
>>
>> Yes! I want to create new tool for some users who will create new user
>> accounts only.
>>
>> Yes! I am using UserDirectoryService.
>>
>> New tool is added to a project site, and that user  i.g., "DAVID" is
>> added with maintain role.
>>
>>
>> When "DAVID" attempt to create new user  then face permission/security
>> exception. I don't want to give access of  !admin (Administrator
>> Workspace) to that user.
>>
>> How to resolve permission exception.
>>
>> Thanks
>>
>>
>>
>> On Mon, Jun 23, 2014 at 8:50 AM, Steve Swinsburg <
>> steve.swinsburg at gmail.com> wrote:
>>
>>> As others have suggested, use the api.
>>>
>>> Rule of thumb: unless your tool owns the database tables, dont touch
>>> them with SQL.
>>>
>>> You can wrap the api calls with session escalation if required. Know
>>> what you are doing before you do that though, and how to cleanup.
>>>
>>> Cheers
>>> Steve
>>>
>>> sent from my mobile device
>>> On 21/06/2014 3:09 PM, "Jehan" <jeehaaan at gmail.com> wrote:
>>>
>>>>  Dear Johan
>>>>
>>>> I want to create a new tool for user creation and password resetting,
>>>> that tool permission will be given to an academic assistant, who will be
>>>> able to change password and create new user  of his department only, we
>>>> cannot give him admin rights/realm, and without admin rights webservices
>>>> gives permission exception while creating new user.
>>>>
>>>> Can you help.
>>>>
>>>>
>>>>
>>>> On Fri, Jun 20, 2014 at 8:06 PM, John Bush <jbush at anisakai.com> wrote:
>>>>
>>>>> yes but I think it would be several sql calls, but its the wrong way
>>>>> to do it,  so I'm not going to give you any details to shoot yourself
>>>>> in the foot with.
>>>>>
>>>>> On Fri, Jun 20, 2014 at 3:06 AM, Jehan <jeehaaan at gmail.com> wrote:
>>>>> > Dear All
>>>>> >
>>>>> >
>>>>> > Is it possible to create new user using Sql Query instead of using
>>>>> > web-service call.
>>>>> >
>>>>> > Thanks
>>>>> >
>>>>> > _______________________________________________
>>>>> > 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"
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> John Bush
>>>>> 602-490-0470
>>>>>
>>>>> ** This message is neither private nor confidential in fact the US
>>>>> government is storing it in a warehouse located in Utah for future
>>>>> data mining use cases should they arise. **
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> 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/20140623/e8751792/attachment.html