User not found when tring to access to the solution repository ?

[nanu]

Hello once again,

I have just set up a pentaho BI server with a postgresql database.
I still have a remaining persistent error when logging in the administration console and ater having logged in when creating a new schedule.

When logging in :
"Error
HTTP/1.1 500 Internal Server Error"

When creating a new schedule :
"SolutionRepositoryServiceProxy.ERROR_0001
Unable to get content of solution repository. HTTP/1.1 500 Internal Server Error"

For both errors, the logs in ../tomcat/bin/pentaho.log shows :
"ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/pentaho].[SolutionRepositoryService]] Servlet.service() for servlet SolutionRepositoryService threw exception
org.springframework.security.userdetails.UsernameNotFoundException: User not found"

I checked my configs in applicationContext-spring-securityxxx files and everything seems correct.
Where should I look for this user credentials exactly ? and which user by the way ?

Thanks for any help,
- emmanuel

[bugg_tb]

assuming you've removed the joe user in your migration, you need to change the user in resource/config/console.xml,

[nanu]

You assumed correctly, the problem is solved.
By the way, does the user needs particular rights or can it be a normal user ? For now, I use the 'admin' account.

Thanks !

[bugg_tb]

dunno, I always use an admin user, I suspect that would be the case, so it can traverse the entire solution stuff

[todd_peasley]

Hi guys,

I am receiving this exact same error. Even the same info displays in my log file.

I have changed the user to "Admin" in the resource/config/console.xml file but I am still getting the same errors.

I am running a MySQL5 database and have just followed the setup tutorial posted on the forum by pgraju on the 18th of February.

Can anyone else point me in the right direction as to what might be causing the error and where to look?

Thanks.

Todd.

[nanu]

Did you put 'Admin' or 'admin' ?
It may be that the program that reads the file is case-sensitive.

And does the 'admin' user still exists in you user list ?

For information, here is my complete console.xml file :
<?xml version="1.0" encoding="UTF-8"?>
<console>
<solution-path></solution-path>
<war-path></war-path>
<platform-username>admin</platform-username>
<biserver-status-check-period-millis>30000</biserver-status-check-period-millis>
<homepage-url>http://www.pentaho.com/console_home</homepage-url>
<homepage-timeout-millis>15000</homepage-timeout-millis>
<!-- comma separated list of roles (no spaces) -->
<default-roles>Authenticated</default-roles>
<default-server-dir>biserver-ce</default-server-dir>
</console>

- emmanuel

[todd_peasley]

Hi guys,

Got around this issue by adding admin to the MYSQL users list.

Todd.

[haubuchon]

I have the same error since I migrated to 3.7RC1. The only difference is that I'm using ldap for authentication. So in my console.xml, I put a ldap user that has admin privileges in pentaho.

it does not work either if I put an internal user like joe or admin. There are not used when using ldap auth.

It was working fine with 3.6.

any ideas ?

Thanks