You don't have authorization to view this page after login with user: superuser Pass: superuser

[Devendra Jakhmola]

Hello,

Getting below error while login to Jaspersoft report via Username: superuser Password: superuser on the reporting server.
However all 4 License file already available in the Administrator folder 


1. Login with superuser


2. Getting below error 

Please help ASAP

[Nika Hadzhikidi]

Hi Devendra

Is this a new or migrated server, did it ever work?
Any errors in jasperserver.log?
Is the Jaspersoft service started with Administrator user?

[Devendra Jakhmola]

Hi Nika,
1. Yes, by the "startup" command tomcat is running.
2. Fresh installed: 7.8.0
3. Log showing:- below error

WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.codehaus.groovy.vmplugin.v7.Java7$1 (file:/C:/Jasper_7.8.0/Tomcat/apache-tomcat-9.0.37/webapps/ppmreports/WEB-INF/lib/groovy-2.5.7.jar) to constructor java.lang.invoke.MethodHandles$Lookup(java.lang.Class,int)
WARNING: Please consider reporting this to the maintainers of org.codehaus.groovy.vmplugin.v7.Java7$1
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release

JaaSProxyAuthenticationFilter.doFilter() : Error while authenticating the User - superuser
org.springframework.security.authentication.BadCredentialsException: Bad credentials

ERROR JaaSProxyAuthenticationFilter,https-openssl-nio-8443-exec-8:36 [] - JaaSProxyAuthenticationFilter.doFilter() : Error while authenticating the User - superuser
org.springframework.security.authentication.BadCredentialsException: Bad credentials

NOte:- I have already copied 4 files from my name folder to Admin folder.
One more question: Is Administrator folder creates itself after Jaspersoft upgrade ?? or do we have to create Administrator folder after upgrade Jaspersoft
because Administrator folder created by me.

[Nika Hadzhikidi]

Devendra,

Looks like it does not like your Jaspersoft password. Can you please do the following:
1. Run this query to reset the superuser password:
UPDATE jiuser SET password = '' WHERE username = 'superuser';
commit
2. Restart Jaspersoft
3. Login to the account using superuser without a password
4. Go to Manage - Users to add a new password

See if that works for you. 

Administrator folder is not a folder created by Jaspersoft, this is a Windows user folder. For new installs, we recommend creating a separate Jaspersoft user to run the Jaspersoft service. This is to avoid cases in which a user's personal account is used and then if they leave, we need to move licenses around.
​

[Devendra Jakhmola]

Thanks for your response.

I did the same, set the null password and login with the superuser without password but still getting the same error with the below error message:- j_spring-security_check

[Nika Hadzhikidi]

Was the Jaspersoft installed with Administrator user, and was the service started with the Administrator user?

Please provide your latest jasperserver log

[Devendra Jakhmola]

Hi Niki,
Yes, it was installed through Administrator user and services restarted were also restarted. Please find attached jasperserver.log file.

[Nika Hadzhikidi]

2021-09-02T09:18:06,645 ERROR PPMCachedEncryptionService,quartzScheduler_Worker-1:129 [] - Error while creating and loading the TenantKeyStoreInfo to  Cache

java.security.GeneralSecurityException: Error in loading properties of keystore- the file- 'ppd.properties' does not exist.

1. Can you please recreate the keystore from the Clarity application server:

admin jaspersoft keystore
Move to the Jaspersoft folder as indicated

2. Then run SyncPPMContext

admin jaspersoft syncPPMContext -userName superuser -password superuser <---leave password as blank if you haven't changed it

 

See if that allows you to get in.

[Devendra Jakhmola]

Hi Nika,

I did the same: 
1. Leave password as blank like:  Password="" (In the context.xml file )
2. Generate new key store file from application side by the command "admin jaspersoft keystore" and placed in the Web_INF -->config on Jasper server
3. Run syn command but getting error: 

Could not login to http://XXXXXXX.americas.ppdi.local:8080/ppmreports with username superuser
Error occurred: com.niku.union.reporting.jaspersoft.exception.JasperDomainException: Could not login to http://XXXXXXX.americas.ppdi.local:8080/ppmreports with username superuser
Check admin.log or use -verbose for more information.

[Nika Hadzhikidi]

Are you able to connect with a blank password for superuser and change it in Manage Users?

[Devendra Jakhmola]

After changing  password, I am getting 404 error
Latest log file uploaded

[Devendra Jakhmola]

Here is the password I kept in context.xml file 

[Nika Hadzhikidi]

2021-09-02T11:01:05,827 ERROR IdTableHelper,main:105 [] - Unable obtain JDBC Connection
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-01005: null password given; logon denied

DO NOT set the password as null in Context.xml, please revert this. 

Only use the query to change it in the database, nothing else. Please try again with the steps I provided above and see if that helps

[Devendra Jakhmola]

1. I kept the same password whatever it was earlier 
2. Run Syn command but command failed due to below error:-

ERROR 2021-09-02 10:43:12,458 [main] restAdapter.JasperRestAdapter Login failed: 403 -
0 [main] ERROR com.ca.jasper.restAdapter.JasperRestAdapter - Login failed: 403 -
Could not login to http://XXXXXXX.americas.ppdi.local:8080/ppmreports with username superuser
Error occurred: com.niku.union.reporting.jaspersoft.exception.JasperDomainException: Could not login to http://XXXXXXX.americas.ppdi.local:8080/ppmreports with username superuser
Check admin.log or use -verbose for more information.


3. Run the Jaspersoft URL and getting the exact error again: 

4. Latest log file attached

[Nika Hadzhikidi]

Thank you for confirming Devendra

2021-09-02T11:43:04,575 DEBUG QuartzSchedulerThread,quartzScheduler_QuartzSchedulerThread:291 [] - batch acquisition of 0 triggers
2021-09-02T11:43:12,393 ERROR JaaSProxyAuthenticationFilter,http-nio-8080-exec-1:36 [] - JaaSProxyAuthenticationFilter.doFilter() : Error while authenticating the User - superuser
org.springframework.security.authentication.BadCredentialsException: Bad credentials
at org.springframework.security.authentication.dao.DaoAuthenticationProvider.additionalAuthenticationChecks(DaoAuthenticationProvider.java:98) ~[spring-security-core-4.2.13.RELEASE.jar:4.2.13.RELEASE]
at
Looks like still a password issue. Can you raise a case with Support so we can look into it over a webex