[jira] [Updated] (SYNCOPE-1308) Exception getting users with orderBy on SyncopeClient API with Postgres 10.3

2018-05-03 Thread JIRA 

 [ 
https://issues.apache.org/jira/browse/SYNCOPE-1308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Francesco Chicchiriccò updated SYNCOPE-1308:

Fix Version/s: 2.1.0
   2.0.9

> Exception getting users with orderBy on SyncopeClient API with Postgres 10.3
> 
>
> Key: SYNCOPE-1308
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1308
> Project: Syncope
>  Issue Type: Bug
>  Components: client
>Affects Versions: 2.0.8
> Environment: Windows Server 2012 R2 64
> Java 8
> Tomcat 8
> Syncope 2.0.8
> JDBC Driver 42.2.2
> Postgres 10.3
>Reporter: Paul Fullbright
>Priority: Major
> Fix For: 2.0.9, 2.1.0
>
>
> To reproduce, I used the following code:
> {{    UserService service = client.getService(UserService.class); }}
> {{    AnyQuery query = new AnyQuery.Builder() }}
> {{        .page(1) }}
> {{        .size(1) }}
> {{        .orderBy("email ASC") }}
> {{        .realm("/") }}
> {{        .build(); }}
> {{                }}
> {{    return service.search(query);}}
> And then I received the following exception stack:
> {{org.apache.syncope.common.lib.SyncopeClientException: 
> DataIntegrityViolation }}
> {{[ERROR: UNION types integer and text cannot be matched }}
> {{   Position: 158 {prepstmnt 1156037144 SELECT u.any_id,sva.stringvalue AS }}
> {{email FROM (SELECT DISTINCT any_id FROM user_search WHERE id IS NOT NULL) 
> u, }}
> {{(SELECT * FROM user_search_attr UNION SELECT * FROM user_search_null_attr) 
> }}
> {{sva WHERE u.any_id=sva.any_id AND sva.schema_id='email' AND u.any_id IN }}
> {{(SELECT any_id FROM user_search WHERE realm_id IN (SELECT id AS realm_id }}
> {{FROM Realm WHERE id=?)) ORDER BY email ASC} [code=0, state=42804]] }}
> {{    at }}
> {{org.apache.syncope.common.lib.SyncopeClientException.build(SyncopeClientException.java:37)
>  }}
> {{    at }}
> {{org.apache.syncope.client.lib.RestClientExceptionMapper.checkSyncopeClientCompositeException(RestClientExceptionMapper.java:143)
>  }}
> {{    at }}
> {{org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:53)
>  }}
> {{    at }}
> {{org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:42)
>  }}
> {{    at }}
> {{org.apache.cxf.jaxrs.client.ClientProxyImpl.checkResponse(ClientProxyImpl.java:313)
>  }}
> {{    at }}
> {{org.apache.cxf.jaxrs.client.ClientProxyImpl.handleResponse(ClientProxyImpl.java:876)
>  }}
> {{    at }}
> {{org.apache.cxf.jaxrs.client.ClientProxyImpl.doChainedInvocation(ClientProxyImpl.java:789)
>  }}
> {{    at }}
> {{org.apache.cxf.jaxrs.client.ClientProxyImpl.invoke(ClientProxyImpl.java:235)
>  }}
> {{    at com.sun.proxy.$Proxy64.search(Unknown Source) }}
> {{    at com.gal.ums.services.UsersService.getUsers(UsersService.java:65) }}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (SYNCOPE-1308) Exception getting users with orderBy on SyncopeClient API with Postgres 10.3

2018-05-03 Thread Paul Fullbright (JIRA) 
Paul Fullbright created SYNCOPE-1308:


 Summary: Exception getting users with orderBy on SyncopeClient API 
with Postgres 10.3
 Key: SYNCOPE-1308
 URL: https://issues.apache.org/jira/browse/SYNCOPE-1308
 Project: Syncope
  Issue Type: Bug
  Components: client
Affects Versions: 2.0.8
 Environment: Windows Server 2012 R2 64
Java 8
Tomcat 8
Syncope 2.0.8
JDBC Driver 42.2.2
Postgres 10.3

Reporter: Paul Fullbright


To reproduce, I used the following code:

{{    UserService service = client.getService(UserService.class); }}
{{    AnyQuery query = new AnyQuery.Builder() }}
{{        .page(1) }}
{{        .size(1) }}
{{        .orderBy("email ASC") }}
{{        .realm("/") }}
{{        .build(); }}
{{                }}
{{    return service.search(query);}}

And then I received the following exception stack:

{{org.apache.syncope.common.lib.SyncopeClientException: DataIntegrityViolation 
}}
{{[ERROR: UNION types integer and text cannot be matched }}
{{   Position: 158 {prepstmnt 1156037144 SELECT u.any_id,sva.stringvalue AS }}
{{email FROM (SELECT DISTINCT any_id FROM user_search WHERE id IS NOT NULL) u, 
}}
{{(SELECT * FROM user_search_attr UNION SELECT * FROM user_search_null_attr) }}
{{sva WHERE u.any_id=sva.any_id AND sva.schema_id='email' AND u.any_id IN }}
{{(SELECT any_id FROM user_search WHERE realm_id IN (SELECT id AS realm_id }}
{{FROM Realm WHERE id=?)) ORDER BY email ASC} [code=0, state=42804]] }}
{{    at }}
{{org.apache.syncope.common.lib.SyncopeClientException.build(SyncopeClientException.java:37)
 }}
{{    at }}
{{org.apache.syncope.client.lib.RestClientExceptionMapper.checkSyncopeClientCompositeException(RestClientExceptionMapper.java:143)
 }}
{{    at }}
{{org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:53)
 }}
{{    at }}
{{org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:42)
 }}
{{    at }}
{{org.apache.cxf.jaxrs.client.ClientProxyImpl.checkResponse(ClientProxyImpl.java:313)
 }}
{{    at }}
{{org.apache.cxf.jaxrs.client.ClientProxyImpl.handleResponse(ClientProxyImpl.java:876)
 }}
{{    at }}
{{org.apache.cxf.jaxrs.client.ClientProxyImpl.doChainedInvocation(ClientProxyImpl.java:789)
 }}
{{    at }}
{{org.apache.cxf.jaxrs.client.ClientProxyImpl.invoke(ClientProxyImpl.java:235) 
}}
{{    at com.sun.proxy.$Proxy64.search(Unknown Source) }}
{{    at com.gal.ums.services.UsersService.getUsers(UsersService.java:65) }}

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (SYNCOPE-1270) OpenID Connect client feature

2018-05-03 Thread ASF subversion and git services (JIRA) 

[ 
https://issues.apache.org/jira/browse/SYNCOPE-1270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16462555#comment-16462555
 ] 

ASF subversion and git services commented on SYNCOPE-1270:
--

Commit f29e60f62f12bc7ec77ce6de4d2674db466a8f4f in syncope's branch 
refs/heads/2_0_X from [~dimaayash]
[ https://git-wip-us.apache.org/repos/asf?p=syncope.git;h=f29e60f ]

[SYNCOPE-1270] implementation for OpenID Connect for Admin Console and Enduser


> OpenID Connect client feature
> -
>
> Key: SYNCOPE-1270
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1270
> Project: Syncope
>  Issue Type: New Feature
>  Components: extensions
>Reporter: Dima Ayash
>Assignee: Francesco Chicchiriccò
>Priority: Major
> Fix For: 2.0.9, 2.1.0
>
>
> This feature implements an SSO access to the Enduser UI and Admin Console by 
> using [OpenID Connect 1.0|http://openid.net/connect/] which is a simple 
> identity layer on top of the OAuth 2.0 protocol. It allows Clients to verify 
> the identity of the End-User based on the authentication performed by an 
> Authorization Server, as well as to obtain basic profile information about 
> the End-User in an interoperable and REST-like manner.
> The flow for this feature will be possibly as follow (using Google as an 
> example of OpenID Connect Provider):
> # From Enduser or Admin login UI, the user can choose to be authenticated 
> using Google account.
> #  Check if the user has a valid session, otherwise prompts the user to login 
> by redirecting him to the Google Login UI.
> #  After the user login successfully to his Google account, grant him an 
> access to Enduser UI or Admin console.
> This will be achieved by following the OpenId Connect required flow, 
> leveraging possibly from CXF features.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (SYNCOPE-1270) OpenID Connect client feature

2018-05-03 Thread ASF GitHub Bot (JIRA) 

[ 
https://issues.apache.org/jira/browse/SYNCOPE-1270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16462557#comment-16462557
 ] 

ASF GitHub Bot commented on SYNCOPE-1270:
-

Github user asfgit closed the pull request at:

https://github.com/apache/syncope/pull/74


> OpenID Connect client feature
> -
>
> Key: SYNCOPE-1270
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1270
> Project: Syncope
>  Issue Type: New Feature
>  Components: extensions
>Reporter: Dima Ayash
>Assignee: Francesco Chicchiriccò
>Priority: Major
> Fix For: 2.0.9, 2.1.0
>
>
> This feature implements an SSO access to the Enduser UI and Admin Console by 
> using [OpenID Connect 1.0|http://openid.net/connect/] which is a simple 
> identity layer on top of the OAuth 2.0 protocol. It allows Clients to verify 
> the identity of the End-User based on the authentication performed by an 
> Authorization Server, as well as to obtain basic profile information about 
> the End-User in an interoperable and REST-like manner.
> The flow for this feature will be possibly as follow (using Google as an 
> example of OpenID Connect Provider):
> # From Enduser or Admin login UI, the user can choose to be authenticated 
> using Google account.
> #  Check if the user has a valid session, otherwise prompts the user to login 
> by redirecting him to the Google Login UI.
> #  After the user login successfully to his Google account, grant him an 
> access to Enduser UI or Admin console.
> This will be achieved by following the OpenId Connect required flow, 
> leveraging possibly from CXF features.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[GitHub] syncope pull request #74: [SYNCOPE-1270] implementation for OpenID Connect f...

2018-05-03 Thread asfgit 
Github user asfgit closed the pull request at:

https://github.com/apache/syncope/pull/74


---

[jira] [Commented] (SYNCOPE-1270) OpenID Connect client feature

2018-05-03 Thread ASF GitHub Bot (JIRA) 

[ 
https://issues.apache.org/jira/browse/SYNCOPE-1270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16462496#comment-16462496
 ] 

ASF GitHub Bot commented on SYNCOPE-1270:
-

Github user ilgrosso commented on the issue:

https://github.com/apache/syncope/pull/74
  
Thanks @DimaAy for your changes, they look fine!
Just squash your 3 commits into 1 and I'll gladly merge this PR, thanks.


> OpenID Connect client feature
> -
>
> Key: SYNCOPE-1270
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1270
> Project: Syncope
>  Issue Type: New Feature
>  Components: extensions
>Reporter: Dima Ayash
>Assignee: Francesco Chicchiriccò
>Priority: Major
> Fix For: 2.0.9, 2.1.0
>
>
> This feature implements an SSO access to the Enduser UI and Admin Console by 
> using [OpenID Connect 1.0|http://openid.net/connect/] which is a simple 
> identity layer on top of the OAuth 2.0 protocol. It allows Clients to verify 
> the identity of the End-User based on the authentication performed by an 
> Authorization Server, as well as to obtain basic profile information about 
> the End-User in an interoperable and REST-like manner.
> The flow for this feature will be possibly as follow (using Google as an 
> example of OpenID Connect Provider):
> # From Enduser or Admin login UI, the user can choose to be authenticated 
> using Google account.
> #  Check if the user has a valid session, otherwise prompts the user to login 
> by redirecting him to the Google Login UI.
> #  After the user login successfully to his Google account, grant him an 
> access to Enduser UI or Admin console.
> This will be achieved by following the OpenId Connect required flow, 
> leveraging possibly from CXF features.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[GitHub] syncope issue #74: [SYNCOPE-1270] implementation for OpenID Connect for Admi...

2018-05-03 Thread ilgrosso 
Github user ilgrosso commented on the issue:

https://github.com/apache/syncope/pull/74
  
Thanks @DimaAy for your changes, they look fine!
Just squash your 3 commits into 1 and I'll gladly merge this PR, thanks.


---

Re: Regarding GSOC 2018

2018-05-03 Thread Andrea Patricelli 
Hi Ashish,

In order to learn Syncope and some idm concepts you can start from 
documentation here [1].
If you like to contribute by working on issues and improvements please refer to 
Jira at [2].
The last but not the least: tips on how to contribute are at [3].


HTH,
Andrea

[1] https://syncope.apache.org/docs/
[2] 
https://issues.apache.org/jira/projects/SYNCOPE/issues/SYNCOPE-1270?filter=allopenissues
[3] https://syncope.apache.org/contributing
- Messaggio originale -
Da: Ashish Malhotra 
A: dev@syncope.apache.org
Inviato: Wed, 02 May 2018 17:36:21 +0200 (CEST)
Oggetto: Re: Regarding GSOC 2018

Hello,

I am new to this platform, I am also willing to participate and learn last
year I have applied for GSoC but was not able to qualify the starting
rounds. Can I also work and learn here?


Thanks and Regards
Ashish Malhotra

On 2 May 2018 at 14:04, Andrea Patricelli 
wrote:

> Hi Rohan,
>
> welcome abroad!
>
> Hope you can contribute to this project, if you wish, also "outside" the
> GSoc project. But, at the moment, focus on you work ;)
>
> Have a nice work and (with me obviously) stay in touch.
>
> Best regards,
> Andrea
>
>
>
> Il 23/04/2018 18:17, rohan julka ha scritto:
>
>> Hi ,
>>
>> Thank you for giving me the opportunity , I really appreciate it ,
>> looking forward to work with you all . Thank you Andrea for mentoring my
>> project .
>>
>> Best Regards,
>> Rohan Julka
>>
>>
>> --
> Dott. Andrea Patricelli
> Tel. +39 3204524292
>
> Developer @ Tirasa S.r.l.
> Viale D'Annunzio 267 - 65127 Pescara
> Tel +39 0859116307 / FAX +39 085973
> http://www.tirasa.net
>
> Apache Syncope PMC Member
>
>


-- 
*Regards,*

Ashish Malhotra

CSE - Telecom Informatics 2014-18 Batch

University of Petroleum & Energy Studies,

Dehradun (Uttrakhand)

8006066680

malhotraashish2...@gmail.com, malhotra.ashis...@stu.upes.ac.in