issue when implementing Header-driven method

Hi Alex,

I understood what was missing and now it is working fine for me.

Thanks for your support!

Regards,

Vadivel

Hi Vadivel,

form-builder-permissions.xml defines permissions for people using Form Builder. So with <role name="orbeon-user" app="test" form="*"/>, you're saying that to be able edit or create forms in the "test" app, users need to have the orbeon-user role. But this says nothing about what role is needed to be able to fill out forms in that app. For that, you'll want to define access permission within Form Builder when editing that form. See:

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/access-control#TOC-Since-Orbeon-Forms-4.0

Alex

Hi Alex,

I understood what was missing and now it is working fine for me.

Thanks for your support!

Regards,

Vadivel

Hi Vadivel,

form-builder-permissions.xml defines permissions for people using Form Builder. So with <role name="orbeon-user" app="test" form="*"/>, you're saying that to be able edit or create forms in the "test" app, users need to have the orbeon-user role. But this says nothing about what role is needed to be able to fill out forms in that app. For that, you'll want to define access permission within Form Builder when editing that form. See:

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/access-control#TOC-Since-Orbeon-Forms-4.0

Alex

Hi Alex,

I have configured Orbeon forms to use MySQL persistence layer and the form data

is getting saved in “orbeon_form_data” table.

But the issue is, the username that i pass through header is not getting saved in

“username” column.

The following are my configuration details,

<property as="xs:string" name="oxf.fr.authentication.method" value="header"/>                      

<property as="xs:string" name="oxf.fr.authentication.header.username" value="My-Username-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.group" value="My-Group-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.roles" value="My-Roles-Header"/>

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql" />

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql" />

<property as="xs:string" name="oxf.fr.persistence.provider.*.*.*" value="mysql" />

<property as="xs:anyURI" name="oxf.fr.persistence.mysql.uri" value="/fr/service/mysql" />

<property as="xs:string" name="oxf.fr.persistence.mysql.datasource" value="mysql" />

<property as="xs:boolean" name="oxf.fr.persistence.mysql.active" value="true" />

<property as="xs:string" name="oxf.http.forward-headers" value="mysql"/>

 <resource-ref>

     <description>DataSource</description>

     <res-ref-name>jdbc/mysql</res-ref-name>

     <res-type>javax.sql.DataSource</res-type>

     <res-auth>Container</res-auth>

 </resource-ref>

Am i missing any steps?

Regards,

Vadivel

Hi Vadivel,

Excellent then, and thanks for the update.

Alex

Hi Alex,

I have configured Orbeon forms to use MySQL persistence layer and the form data

is getting saved in “orbeon_form_data” table.

But the issue is, the username that i pass through header is not getting saved in

“username” column.

The following are my configuration details,

<property as="xs:string" name="oxf.fr.authentication.method" value="header"/>                      

<property as="xs:string" name="oxf.fr.authentication.header.username" value="My-Username-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.group" value="My-Group-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.roles" value="My-Roles-Header"/>

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql" />

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql" />

<property as="xs:string" name="oxf.fr.persistence.provider.*.*.*" value="mysql" />

<property as="xs:anyURI" name="oxf.fr.persistence.mysql.uri" value="/fr/service/mysql" />

<property as="xs:string" name="oxf.fr.persistence.mysql.datasource" value="mysql" />

<property as="xs:boolean" name="oxf.fr.persistence.mysql.active" value="true" />

<property as="xs:string" name="oxf.http.forward-headers" value="mysql"/>

 <resource-ref>

     <description>DataSource</description>

     <res-ref-name>jdbc/mysql</res-ref-name>

     <res-type>javax.sql.DataSource</res-type>

     <res-auth>Container</res-auth>

 </resource-ref>

Am i missing any steps?

Regards,

Vadivel

Hi Vadivel,

Excellent then, and thanks for the update.

Alex

Hi Alex,

Thanks for the support,

I have included this property to forward the headers to this datasource (“mysql” is my data source name)

<property as="xs:string" name="oxf.http.forward-headers" value="mysql"/>

Since i was not able to get through with the following properties, i tried to include that one as well.

<property as="xs:string" name="oxf.fr.authentication.method" value="header"/>                     

<property as="xs:string" name="oxf.fr.authentication.header.username" value="My-Username-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.group" value="My-Group-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.roles" value="My-Roles-Header"/>

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

As i mentioned in my earlier reply, i am able to pass the role header with these settings, only the user name that i pass

is not getting saved in the database.

Regards,

Vadivel

Hi Vadivel,

The last property looks suspicious:

<property as="xs:string" name="oxf.http.forward-headers" value="mysql"/>

It should be:

<property as="xs:string" name="oxf.http.forward-headers" value="My-Username-Header My-Roles-Header"/>

You'll let us know if this solves the problem,

Alex

Hi Alex,

Thanks for the support,

I have included this property to forward the headers to this datasource (“mysql” is my data source name)

<property as="xs:string" name="oxf.http.forward-headers" value="mysql"/>

Since i was not able to get through with the following properties, i tried to include that one as well.

<property as="xs:string" name="oxf.fr.authentication.method" value="header"/>                     

<property as="xs:string" name="oxf.fr.authentication.header.username" value="My-Username-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.group" value="My-Group-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.roles" value="My-Roles-Header"/>

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

As i mentioned in my earlier reply, i am able to pass the role header with these settings, only the user name that i pass

is not getting saved in the database.

Regards,

Vadivel

Hi Vadivel,

The last property looks suspicious:

<property as="xs:string" name="oxf.http.forward-headers" value="mysql"/>

It should be:

<property as="xs:string" name="oxf.http.forward-headers" value="My-Username-Header My-Roles-Header"/>

You'll let us know if this solves the problem,

Alex

Hi Erik,

Thanks for the support,

I didn’t see any difference between the one you mentioned,

<property

  as="xs:string"

  name="oxf.xforms.forward-submission-headers"

  value="My-Username-Header My-Roles-Header"/>

and the one that i already have

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

As i mentioned the following are the list of property settings i have

<property as="xs:string" name="oxf.fr.authentication.method" value="header"/>                     

<property as="xs:string" name="oxf.fr.authentication.header.username" value="My-Username-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.group" value="My-Group-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.roles" value="My-Roles-Header"/>

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

Am i missing your point?

I thought you may be asking me to remove all my property settings and include “only” the one you mentioned

And tried with the following properties alone and removed other ones

<property as="xs:string" name="oxf.fr.authentication.method" value="header"/>

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

Still i see the same behaviour. Username is not stored in the database.

Regards,

Vadivel

Try instead:

<property
  as="xs:string"
  name="oxf.xforms.forward-submission-headers"
  value="My-Username-Header My-Roles-Header"/>

-Erik

Hi Erik,

Thanks for the support,

I didn’t see any difference between the one you mentioned,

<property

  as="xs:string"

  name="oxf.xforms.forward-submission-headers"

  value="My-Username-Header My-Roles-Header"/>

and the one that i already have

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

As i mentioned the following are the list of property settings i have

<property as="xs:string" name="oxf.fr.authentication.method" value="header"/>                     

<property as="xs:string" name="oxf.fr.authentication.header.username" value="My-Username-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.group" value="My-Group-Header"/>

<property as="xs:string" name="oxf.fr.authentication.header.roles" value="My-Roles-Header"/>

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

Am i missing your point?

I thought you may be asking me to remove all my property settings and include “only” the one you mentioned

And tried with the following properties alone and removed other ones

<property as="xs:string" name="oxf.fr.authentication.method" value="header"/>

<property as="xs:string" name="oxf.xforms.forward-submission-headers" value="My-Username-Header My-Roles-Header"/>

Still i see the same behaviour. Username is not stored in the database.

Regards,

Vadivel

Try instead:

<property
  as="xs:string"
  name="oxf.xforms.forward-submission-headers"
  value="My-Username-Header My-Roles-Header"/>

-Erik

Hi Alex,

Thanks for the support,

Will wait for the updates.

Regards,

Vadivel

Hi Vadivel,

Sorry for the delay, but we haven't gotten a chance to verify this yet. However, we created a issue for this (linked below), and scheduled it for 4.5, so we'll at least double check this, and if we can fix it before the release. We'll also make sure to post updates here.

https://github.com/orbeon/orbeon-forms/issues/1541 

Alex

Hi Alex,

Thanks for the support,

Will wait for the updates.

Regards,

Vadivel

Hi Vadivel,

Sorry for the delay, but we haven't gotten a chance to verify this yet. However, we created a issue for this (linked below), and scheduled it for 4.5, so we'll at least double check this, and if we can fix it before the release. We'll also make sure to post updates here.

https://github.com/orbeon/orbeon-forms/issues/1541 

Alex

Hi Alex,

Thanks for the support.

“And just to confirm, you're saying that if, after saving, you look at what you have in the database, then the username isn't present in the last_modified_by column?”

Yes, this what happening in my case and I use "mysql-5.6.15".

Regards,

Vadivel

Hi Vadivel,

Sorry about that: I reopened the issue, renamed it to "Username not persisted with header based permission", will check if this works, and post an update here.

And just to confirm, you're saying that if, after saving, you look at what you have in the database, then the username isn't present in the last_modified_by column? And specifically, what relational database are you using?

Alex