[Building Sakai] AuthzPermissionException Thrown After Upgrading from 2.7.1 to 2.9.3

[Steve Swinsburg]

If you have no data to upgrade,  startup sakai 2.9.3 on a clean database
and the tables etc will be created for you. No need to upgrade.

Cheers
Steve

sent from my mobile device
On 06/05/2014 8:56 AM, "BJ Peter DeLaCruz" <bjpeter2008 at gmail.com> wrote:

> The dump file only includes the DDL. When I open the sakai database using
> DbVisualizer, I see no data in the tables.
>
> Because there are no data in the tables, I had to comment out many INSERT
> INTO statements in the upgrade scripts because the fields cannot be null.
> Perhaps the database should be upgraded when there's data in there? I think
> Sakai was looking for the admin user when it started up but couldn't find
> it?
>
> I am using the following scripts, and I applied them in the order listed
> below:
>
> 2.7.1 -> 2.8.0
>
> https://source.sakaiproject.org/svn/reference/branches/sakai-2.8.x/docs/conversion/sakai_2_8_0_mysql_conversion.sql
>
> 2.8.0 -> 2.9.0
>
> https://source.sakaiproject.org/svn/reference/branches/sakai-2.9.x/docs/conversion/sakai_2_9_0_mysql_conversion.sql
>
> 2.9.0 -> 2.9.1
>
> https://source.sakaiproject.org/svn/reference/branches/sakai-2.9.x/docs/conversion/sakai_2_9_0-2_9_1_mysql_conversion.sql
>
> 2.9.1 -> 2.9.2
>
> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_9_1-2_9_2_mysql_conversion.sql
>
> 2.9.2 -> 2.9.3
>
> http://code.metager.de/source/xref/sakai/2.9.3/reference/docs/conversion/sakai_2_9_2-2_9_3_mysql_conversion.sql
>
>
> On Mon, May 5, 2014 at 10:54 AM, Steve Swinsburg <
> steve.swinsburg at gmail.com> wrote:
>
>> And does the dump include the data or just the DDL?
>> Can you go to a table, sakai_site for example and see records?
>>
>> What about the code,  how did you get from 2.7.1 to 2.9.3?
>>
>> Cheers
>> Steve
>>
>> sent from my mobile device
>> On 06/05/2014 3:52 AM, "BJ Peter DeLaCruz" <bjpeter2008 at gmail.com> wrote:
>>
>>> That is correct, Steve.
>>>
>>> I don't have a database created. I imported the dump, and it created a
>>> new one. I ran all upgrade scripts to bring it up to 2.9.3. I started up
>>> Sakai, and I received that error.
>>>
>>> Any ideas?
>>>
>>>
>>> On Sat, May 3, 2014 at 2:09 PM, Steve Swinsburg <
>>> steve.swinsburg at gmail.com> wrote:
>>>
>>>> Can you confirm the order of operations here? You should have
>>>> 1. Import dump into new db
>>>> 2. Run all upgrade scripts from 2.7.1 onwards in order to bring it up
>>>> to 2.9.3
>>>> 3. Start sakai.
>>>>
>>>> Cheers
>>>> Steve
>>>>
>>>> sent from my mobile device
>>>> On 03/05/2014 3:12 AM, "BJ Peter DeLaCruz" <bjpeter2008 at gmail.com>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> I have a MySQL database dump (table structures) for Sakai 2.7.1, and I
>>>>> am trying to upgrade the database to Sakai 2.9.3. The scripts upgraded the
>>>>> database fine, but when I start up Tomcat, I see the following errors in
>>>>> the log file. There is no data in the database.
>>>>>
>>>>> Is the admin user automatically created by Sakai when it starts up for
>>>>> the first time and the database is empty? How can I fix this error? I am
>>>>> upgrading the database on Windows 7, and I am running MySQL 5.6.16.
>>>>>
>>>>> Thanks,
>>>>> BJ
>>>>>
>>>>> org.springframework.beans.factory.BeanCreationException: Error
>>>>> creating bean with name
>>>>> 'org.theospi.portfolio.security.DefaultRealmManager.portfolio' defined in
>>>>> file
>>>>> [C:\opt2\apache-tomcat-7.0.52\components\osp-common-component\WEB-INF\components.xml]:
>>>>> Invocation of init method failed; nested exception is
>>>>> java.lang.RuntimeException:
>>>>> org.sakaiproject.authz.api.AuthzPermissionException user=admin
>>>>> function=realm.add resource=/realm/!site.template.portfolio
>>>>>  at
>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)
>>>>>  at
>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
>>>>>  at
>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
>>>>>  at java.security.AccessController.doPrivileged(Native Method)
>>>>> at
>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
>>>>>  at
>>>>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
>>>>> at
>>>>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>>>>>  at
>>>>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
>>>>> at
>>>>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
>>>>>  at
>>>>> org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:112)
>>>>> at
>>>>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
>>>>>  at
>>>>> org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:73)
>>>>>  at
>>>>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
>>>>>  at
>>>>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
>>>>> at
>>>>> org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:160)
>>>>>  at
>>>>> org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:98)
>>>>> at
>>>>> org.sakaiproject.component.cover.ComponentManager.get(ComponentManager.java:107)
>>>>>  at
>>>>> org.sakaiproject.component.cover.ServerConfigurationService.getInstance(ServerConfigurationService.java:52)
>>>>> at org.sakaiproject.util.RequestFilter.init(RequestFilter.java:811)
>>>>>  at
>>>>> org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
>>>>> at
>>>>> org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
>>>>>  at
>>>>> org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
>>>>> at
>>>>> org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4809)
>>>>>  at
>>>>> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5485)
>>>>> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>>>>>  at
>>>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>>>>>  at
>>>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
>>>>>  at
>>>>> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
>>>>> at
>>>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
>>>>>  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
>>>>>  at
>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
>>>>> at
>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
>>>>>  at java.lang.Thread.run(Thread.java:662)
>>>>> Caused by: java.lang.RuntimeException:
>>>>> org.sakaiproject.authz.api.AuthzPermissionException user=admin
>>>>> function=realm.add resource=/realm/!site.template.portfolio
>>>>>  at
>>>>> org.theospi.portfolio.security.model.DefaultRealmManagerImpl.init(DefaultRealmManagerImpl.java:75)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>>  at
>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>>> at
>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>>>  at java.lang.reflect.Method.invoke(Method.java:597)
>>>>> at
>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414)
>>>>>  at
>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375)
>>>>>  at
>>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
>>>>>  ... 35 more
>>>>> Caused by: org.sakaiproject.authz.api.AuthzPermissionException
>>>>> user=admin function=realm.add resource=/realm/!site.template.portfolio
>>>>>  at
>>>>> org.sakaiproject.authz.impl.BaseAuthzGroupService.unlock(BaseAuthzGroupService.java:163)
>>>>> at
>>>>> org.sakaiproject.authz.impl.BaseAuthzGroupService.addAuthzGroup(BaseAuthzGroupService.java:712)
>>>>>  at
>>>>> org.theospi.portfolio.security.model.DefaultRealmManagerImpl.init(DefaultRealmManagerImpl.java:69)
>>>>> ... 42 more
>>>>> java.lang.Exception: traceback
>>>>> at
>>>>> org.sakaiproject.util.NoisierDefaultListableBeanFactory.destroySingletons(NoisierDefaultListableBeanFactory.java:94)
>>>>>  at
>>>>> org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:83)
>>>>>  at
>>>>> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
>>>>>  at
>>>>> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
>>>>> at
>>>>> org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:160)
>>>>>  at
>>>>> org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:98)
>>>>> at
>>>>> org.sakaiproject.component.cover.ComponentManager.get(ComponentManager.java:107)
>>>>>  at
>>>>> org.sakaiproject.component.cover.ServerConfigurationService.getInstance(ServerConfigurationService.java:52)
>>>>> at org.sakaiproject.util.RequestFilter.init(RequestFilter.java:811)
>>>>>  at
>>>>> org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
>>>>> at
>>>>> org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
>>>>>  at
>>>>> org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
>>>>> at
>>>>> org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4809)
>>>>>  at
>>>>> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5485)
>>>>> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>>>>>  at
>>>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
>>>>> at
>>>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>>>>>  at
>>>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
>>>>> at
>>>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
>>>>>  at
>>>>> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
>>>>> at
>>>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
>>>>>  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
>>>>>  at
>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
>>>>> at
>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
>>>>>  at java.lang.Thread.run(Thread.java:662)
>>>>>
>>>>> _______________________________________________
>>>>> 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/20140506/f0abaf04/attachment.html