PDA

View Full Version : Prepare MySQL BA Repository Database



Davit.Petrosyan
01-23-2014, 01:24 PM
Hi everyone!


I am just starting to use Pentaho BI Server 5.0.1.
I have done the mysql configuration for Pentaho (read from this instruction http://anonymousbi.wordpress.com/2013/12/15/pentaho-bi-server-5-0-1ce-mysql-installation-guide/ and
http://infocenter.pentaho.com/help/index.jsp?topic=%2Finstall_ziptar%2Ftask_prepare_rdbms_repository.html).


Login to application works fine, but when I try to create new User, I am getting the "Principal does not exists" exception. It seems, that the application does not create principal for new user.


I tried to debug the codes. The strange thing is that the it normally passes createUser function of AbstractJcrBackedUserRoleDao.java, but fails on verification in checkValidEntry method(ACLTemplate.java).


Also I can see that user is not being creatred in MySQL users table.




Caused by: org.springframework.extensions.jcr.JcrSystemException: Repository access exception; nested exception is javax.jcr.security.AccessControlException: Pr
incipal mysqlDBTestUser-/pentaho/tenant0 does not exist.
at org.springframework.extensions.jcr.SessionFactoryUtils.translateException(SessionFactoryUtils.java:223)
at org.springframework.extensions.jcr.JcrAccessor.convertJcrAccessException(JcrAccessor.java:58)
at org.springframework.extensions.jcr.JcrTemplate.execute(JcrTemplate.java:94)
at org.springframework.extensions.jcr.JcrTemplate.execute(JcrTemplate.java:115)
at org.pentaho.platform.security.userroledao.jackrabbit.JcrUserRoleDao.createUser(JcrUserRoleDao.java:136)
... 90 more
Caused by: javax.jcr.security.AccessControlException: Principal mysqlDBTestUser-/pentaho/tenant0 does not exist.
at org.apache.jackrabbit.core.security.authorization.acl.ACLTemplate.checkValidEntry(ACLTemplate.java:323)
at org.apache.jackrabbit.core.security.authorization.acl.ACLTemplate.addEntry(ACLTemplate.java:385)
at org.apache.jackrabbit.core.security.authorization.AbstractACLTemplate.addAccessControlEntry(AbstractACLTemplate.java:152)
at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileAclUtils.internalUpdateAcl(JcrRepositoryFileAclUtils.java:241)
at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileAclUtils.createAcl(JcrRepositoryFileAclUtils.java:171)
at org.pentaho.platform.security.userroledao.jackrabbit.AbstractJcrBackedUserRoleDao.internalCreateFolder(AbstractJcrBackedUserRoleDao.java:752)
at org.pentaho.platform.security.userroledao.jackrabbit.AbstractJcrBackedUserRoleDao.createUserHomeFolder(AbstractJcrBackedUserRoleDao.java:736)
at org.pentaho.platform.security.userroledao.jackrabbit.AbstractJcrBackedUserRoleDao.createUser(AbstractJcrBackedUserRoleDao.java:342)
at org.pentaho.platform.security.userroledao.jackrabbit.JcrUserRoleDao$4.doInJcr(JcrUserRoleDao.java:139)
at org.springframework.extensions.jcr.JcrTemplate.execute(JcrTemplate.java:89)
... 92 more


If somebody has experiance, it would be very helpfull.
Thanks in advice