Community
 
 
 

CloudPortal Business Manager 2.x

324 followers
 
Avatar
Thura Minn minn

Root account locked

Hi,

I cannot login as Root with correct credentials.
I think the account is locked.
How cloud I unlock the Root account without email.

I have not set mail for Root account yet because of following CPBM2 Known Issue
8.Root cannot set the secondary email from UI.

Thanks,
Thura Minn Minn


9 comments
0

Please sign in to leave a comment.

 
 

Previous 9 comments

Avatar
Thura Minn minn

Hi,

I manually change the portal db as below and now able to login.
update users set enabled=1,locked=0 where username='root';

Same as CPBM1.4?

But I still would like to know how to set email for Root account manually as it cannot be set from UI.

Thanks,
Thura


Comment actions Permalink
Avatar
Pankaj Paliwal
Avatar

Hi,

The email id is saved in encoded format in DB, so it is always recommended to change it from UI.

Thanks,
Manish


Manish Agarwal CITRIX EMPLOYEES
Comment actions Permalink
Avatar
Pankaj Paliwal
Avatar

Manish,

Can you provide instructions on how to change an email id on the UI? It does not appear to be an editable field (see attached).

-David

Attached Files


David Noland CITRIX EMPLOYEES
Comment actions Permalink
Avatar
Pankaj Paliwal
Avatar

Hi David,

Below is the process to update email id from UI.
1. Navigate to "My Profile" >> "Email Addresses"
2. Add the email id you want to update. (this will send a verification email on the new email address)
3. Verify the email address.
4. Click on "Make Primary" to make this email id as primary. (Any verified email can be made as primary. )
5. Verify the updated email id on "Profile" page.

Thanks,
Manish


Manish Agarwal CITRIX EMPLOYEES
Comment actions Permalink
Avatar
Pankaj Paliwal
Avatar

Hi Manish,

When performing step 3 (loading the link I received through e-mail), I get the message "Were sorry, but the page you have requested is not available." I'm using a browser that does not have an active CPBM session. See the following in /var/log/cloud/portal/cpbm-server.log:

[2013-04-17 18:21:22.129] ERROR http-bio-8080-exec-13 com.vmops.web.controllers.AuthenticationController handleAccessDeniedException####AbstractAccessDecisionManager.accessDenied org.springframework.security.access.AccessDeniedException: AbstractAccessDecisionManager.accessDenied
at org.springframework.security.access.vote.AffirmativeBased.decide(AffirmativeBased.java:71)
at org.springframework.security.access.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:204)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at sun.proxy.$Proxy314.save(Unknown Source)
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:309)
at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at sun.proxy.$Proxy568.save(Unknown Source)
at com.vmops.web.controllers.AbstractAuthenticationController$7.run(AbstractAuthenticationController.java:601)
at com.vmops.web.controllers.AbstractAuthenticationController$7.run(AbstractAuthenticationController.java:586)
at java.security.AccessController.doPrivileged(Native Method)
at com.vmops.internal.service.impl.PrivilegeServiceImpl.runAsPortal(PrivilegeServiceImpl.java:276)
at sun.reflect.GeneratedMethodAccessor590.invoke(Unknown Source)
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:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at sun.proxy.$Proxy229.runAsPortal(Unknown Source)
at sun.reflect.GeneratedMethodAccessor590.invoke(Unknown Source)
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:309)
at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at sun.proxy.$Proxy579.runAsPortal(Unknown Source)
at com.vmops.web.controllers.AbstractAuthenticationController.verifyAdditionalEmail(AbstractAuthenticationController.java:586)
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.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:574)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)

-David


David Noland CITRIX EMPLOYEES
Comment actions Permalink
Avatar
Thura Minn minn

Hi Manish,

I also get the same error as above.

Thanks,
Thura


Comment actions Permalink
Avatar
Gert Jensen

Hello,

Have you solved this ?

Kind regards
Gert


Comment actions Permalink
Avatar
Pankaj Paliwal
Avatar

Hello I was wondering if anyone figured out a way to resolve this issue?


Dan Cole MEMBERS
Comment actions Permalink
Avatar
Pankaj Paliwal
Avatar

Hi Dan,

There is an issue when verifying email address for only root user. While we fix the issue in next release could you please try resetting password using below workaround:
1. Login to CPBM database
2. Update the email of the "root" user using below update statement:
update users set email= HEX(AES_ENCRYPT('<root user's new email address>;','<database field encryption key>')) where id =1;

Note: Database field encryption key is the key used for encrypting fields in database. You can find value of the property (field.encryption.key) in cloud.properties file available at /usr/share/vts3/repository/prop/ directory.

Thanks,
Manish


Manish Agarwal CITRIX EMPLOYEES
Comment actions Permalink

Top Contributors