Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

authorization_code flow does not work #279

Closed
nivemaham opened this issue Jul 2, 2018 · 0 comments
Closed

authorization_code flow does not work #279

nivemaham opened this issue Jul 2, 2018 · 0 comments

Comments

@nivemaham
Copy link
Collaborator

nivemaham commented Jul 2, 2018

I am getting following exception on the test environment when I try to test the authorization-code flow using POSTMAN.


managementportal-app_1         | 2018-07-02 13:19:53.668 ERROR 7 --- [ XNIO-2 task-18] o.r.m.w.rest.errors.ExceptionTranslator  : Failed to process message
managementportal-app_1         | 
managementportal-app_1         | org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select expiresAt,status,lastModifiedAt,userId,clientId,scope from oauth_approvals where userId=? and clientId=?]; nested exception is org.postgresql.util.PSQLException: ERROR: column "expiresat" does not exist
managementportal-app_1         |   Hint: Perhaps you meant to reference the column "oauth_approvals.expiresAt".
managementportal-app_1         |   Position: 8
managementportal-app_1         | 	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)
managementportal-app_1         | 	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
managementportal-app_1         | 	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
managementportal-app_1         | 	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
managementportal-app_1         | 	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:655)
managementportal-app_1         | 	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:690)
managementportal-app_1         | 	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
managementportal-app_1         | 	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:732)
managementportal-app_1         | 	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:787)
....
managementportal-app_1         | Caused by: org.postgresql.util.PSQLException: ERROR: column "expiresat" does not exist
managementportal-app_1         |   Hint: Perhaps you meant to reference the column "oauth_approvals.expiresAt".
managementportal-app_1         |   Position: 8
managementportal-app_1         | 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
managementportal-app_1         | 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
managementportal-app_1         | 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
managementportal-app_1         | 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
managementportal-app_1         | 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
managementportal-app_1         | 	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
managementportal-app_1         | 	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
managementportal-app_1         | 	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
managementportal-app_1         | 	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
managementportal-app_1         | 	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:698)
managementportal-app_1         | 	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:639)
managementportal-app_1         | 	... 121 common frames omitted

It could be some issues with spring updates similar to this.
This also points us to wring a scenario to test the authorization-code flow in our tests.

@nivemaham nivemaham changed the title authorization_code flow does work authorization_code flow does work Jul 2, 2018
@nivemaham nivemaham changed the title authorization_code flow does work authorization_code flow does not work Jul 2, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant