Eclipse Community Forums: scout » [mars] RAP + DataSourceSecurityFilter

Help

Home

Home » Eclipse Projects » scout » [mars] RAP + DataSourceSecurityFilter

Show: Today's Messages :: Show Polls :: Message Navigator

[mars] RAP + DataSourceSecurityFilter [message #1752702]

Thu, 26 January 2017 10:32

marco giudici

Messages: 189
Registered: February 2013
Location: Italy

Senior Member

Hi Forum,
I try to implement in Mars Scout the Login function with DataSourceSecurityFilter, more or less as I have done with Kepler Scout.
But I have some errors and probably I make a mistake but I don't see it.

On the server side don't reconize the password, as you can see in the following image:
index.php/fa/28229/0/

On the RAP side, obviously, can't procede to the initialization:
index.php/fa/28230/0/

and on Internet Explorer return this:
index.php/fa/28231/0/

My config.ini contains the following definitions:

### Authentication
org.eclipse.scout.rt.server.commons.servletfilter.security.AnonymousSecurityFilter#active=false

org.eclipse.scout.rt.server.commons.servletfilter.security.BasicSecurityFilter#active=false
org.eclipse.scout.rt.server.commons.servletfilter.security.BasicSecurityFilter#realm=Controller Development
org.eclipse.scout.rt.server.commons.servletfilter.security.BasicSecurityFilter#users=admin\=manager,allen\=allen,blake\=blake


org.eclipse.scout.rt.server.commons.servletfilter.security.DataSourceSecurityFilter#active=true
org.eclipse.scout.rt.server.commons.servletfilter.security.DataSourceSecurityFilter#realm=Controller Development
org.eclipse.scout.rt.server.commons.servletfilter.security.DataSourceSecurityFilter#jdbcDriverName=oracle.jdbc.OracleDriver
org.eclipse.scout.rt.server.commons.servletfilter.security.DataSourceSecurityFilter#jdbcMappingName=jdbc:oracle:thin:@***********:1535:***
org.eclipse.scout.rt.server.commons.servletfilter.security.DataSourceSecurityFilter#jdbcUsername=******
org.eclipse.scout.rt.server.commons.servletfilter.security.DataSourceSecurityFilter#jdbcPassword=*******
org.eclipse.scout.rt.server.commons.servletfilter.security.DataSourceSecurityFilter#selectUserPass=SELECT USERACCOUNT FROM USERROLES WHERE USERACCOUNT=? AND PASSWORD=?

Someone can help me to understand where is my error.

Thanks in advance to all for any help
Marco

Attachment: Server_Error.jpg
(Size: 100.25KB, Downloaded 162 times)
Attachment: RAP_error.jpg
(Size: 106.90KB, Downloaded 161 times)
Attachment: IE_Error.jpg
(Size: 6.97KB, Downloaded 153 times)

[Updated on: Thu, 26 January 2017 10:59]

Report message to a moderator

Re: [mars] RAP + DataSourceSecurityFilter [message #1752736 is a reply to message #1752702]

Thu, 26 January 2017 17:33

Marco Dorfliger

Messages: 43
Registered: January 2015

Member

I notice that you aren't passing any SQL bind parameter arguments into your select statement (on ServerSession line 28).

[Updated on: Thu, 26 January 2017 17:53]

Report message to a moderator

Re: [mars] RAP + DataSourceSecurityFilter [message #1752779 is a reply to message #1752736]

Fri, 27 January 2017 08:50

marco giudici

Messages: 189
Registered: February 2013
Location: Italy

Senior Member

Hi,
can you explain to me the differences of this process between Kepler and Mars version? Because in Kepler this part works without problem.

I'm a little confused on that.

Thanks in advance for any explanation

Report message to a moderator

Re: [mars] RAP + DataSourceSecurityFilter [message #1752782 is a reply to message #1752779]

Fri, 27 January 2017 09:04

Marco Dorfliger

Messages: 43
Registered: January 2015

Member

I'm not the one to say, but I don't remember there being major differences in this area.

According to your log file, the failure happens on line 28 because the bind parameter pwdId is missing in the SQL bind context. If that same code was running on Kepler, then it must have been available as a context variable but isn't any more in your Mars version. Possibly the part of the code which sets the pwdId value in the context isn't being executed, or maybe is but in a different order (i.e. after execLoadSession)? Can you verify in your code where this is set?

Report message to a moderator