HELP! Cannot LOGON. Receiving Bad Credentials...

[briane123]

 I have successfully installed JasperServer 3.7 on UNIX, connecting to

a SQL Server database.

However, I now try to logon and I receive a BAD CREDENTIALS error:

 

2010-02-22 12:28:47,894  WARN LoggerListener,http-8081-Processor25:60 - Authentication event AuthenticationFailureBadCredentialsEvent: jasperadmin; details: org.springframework.security.ui.WebAuthenticationDetails@957e: RemoteIpAddress: 120.0.0.1.45;SessionId: 917642DD685A788618B728A8768B3E78; exception: Bad credentials

 

I am using jasperadmin/jasperadmin to logon.

 

I assume my encrypted password in the database is incorrect, but from what I have read,

it looks fine.

 

 

This is the JIUser record data:

id username tenantId fullname emailAddress password externallyDefined enabled 3 jasperadmin 2 jasperadmin   349AFAADD5C5A2BD477309618DCD58B9 FALSE

TRUE

 

 

 

 

 

Post Edited by briane123 at 02/22/2010 22:14

Post Edited by briane123 at 02/22/2010 22:15

Post Edited by briane123 at 02/23/2010 22:17

[swood]

How were the users created in the repository?

 

Have you tried logging in as the superuser?

 

Sherman

Jaspersoft

[briane123]

 To create my users, I used the following SQL commands to create the

appropriate records.  

Does this look correct, or am I missing something?  

Thanks!!

 

INSERT INTO JITenant

(tenantId,tenantAlias,parentId,tenantName,tenantDesc,tenantNote,tenantUri,tenantFolderUri) 

VALUES ('organizations','organizations',NULL,'root','default tenant',' ','/','/');

 

INSERT INTO JIUser

(username,tenantId,fullname,emailAddress,password,externallyDefined,enabled) VALUES

('anonymousUser',1,'Anonymous User',NULL,'CF35D2E88192D6EB',0,1);

INSERT INTO JIUserRole 

(userId,roleId)

select u.id, r.id from JIUser u, JIRole r where u.username = 'anonymousUser' and r.roleName = 'ROLE_ANONYMOUS';

 

-- add jasperadmin user

 

INSERT INTO JIUser 

(username,tenantId,fullname,emailAddress,password,externallyDefined,enabled) VALUES

('jasperadmin',1,'Jasper Administrator',NULL,'349AFAADD5C5A2BD477309618DCD58B9',0,1);

 

INSERT INTO JIUserRole 

(userId,roleId)

select u.id, r.id from JIUser u, JIRole r where u.username = 'jasperadmin' and r.roleName = 'ROLE_ADMINISTRATOR';

 

INSERT INTO JIUserRole 

(userId,roleId)

select u.id, r.id from JIUser u, JIRole r where u.username = 'jasperadmin' and r.roleName = 'ROLE_USER';

 

INSERT INTO JIResourceFolder 

(version,uri,hidden,name,label,description,parent_folder,creation_date,update_date) VALUES 

(0,'/',0,'/','root','Root of the folder hierarchy',NULL, '2010-2-22','2010-2-22');

 

INSERT INTO JIObjectPermission 

(uri,recipientobjectclass,permissionMask,recipientobjectid)

select 'repo:/','com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole', 1, r.id

from JIRole r where rolename = 'ROLE_ADMINISTRATOR';

 

INSERT INTO JIObjectPermission 

(uri,recipientobjectclass,permissionMask,recipientobjectid)

select 'repo:/','com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole', 2, r.id

from JIRole r where rolename = 'ROLE_USER';

[briane123]

 I found my problem!

When I created the default security dataset in the repository, I had messed up

the link between the jitenant table and the related table joined on "tenatId".

Once I got the tables using the same 'tenantId', everything worked fine.

 

Just make sure you create your default security dataset correctly....