[teiid-issues] [JBoss JIRA] (TEIID-4242) Google Spreadsheet gives 404 with ClientLogin Authentication Method

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13248254#comment-13248254 ] 

Steven Hawkins commented on TEIID-4242:
---------------------------------------

I don't think client login access works any more https://developers.google.com/identity/protocols/AuthForInstalledApps TEIID-4034 removes the option altogether.

> Google Spreadsheet gives 404 with ClientLogin Authentication Method
> -------------------------------------------------------------------
>
>                 Key: TEIID-4242
>                 URL: https://issues.jboss.org/browse/TEIID-4242
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.5.6_2
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>
> Google spreadsheet resource adapter gives a 404[1] error when using ClientLogin Authentication method.  Looking at the URL in the code it's set to https://www.google.com/accounts/ClientLogin and if you go manually to the Google login page it's https://accounts.google.com/ServiceLogin
> [1]
> 14:12:28,508 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (teiid-async-threads - 4) IJ000604: Throwable while attempting to get a new connection: null: org.teiid.resource.adapter.google.common.SpreadsheetAuthException: Error when attempting Client Login: 404: Not Found
> 	at org.teiid.resource.adapter.google.auth.ClientLoginHeaderFactory.login(ClientLoginHeaderFactory.java:80)
> 	at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.<init>(SpreadsheetConnectionImpl.java:76)
> 	at org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory$1.getConnection(SpreadsheetManagedConnectionFactory.java:58)
> 	at org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory$1.getConnection(SpreadsheetManagedConnectionFactory.java:55)
> 	at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:70) [teiid-api-8.7.6.6_2-redhat-1.jar:8.7.6.6_2-redhat-1]
> 	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:858) [ironjacamar-core-impl-1.0.36.Final-redhat-1.jar:1.0.36.Final-redhat-1]
> 	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:413) [ironjacamar-core-impl-1.0.36.Final-redhat-1.jar:1.0.36.Final-redhat-1]
> 	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:457) [ironjacamar-core-impl-1.0.36.Final-redhat-1.jar:1.0.36.Final-redhat-1]
> 	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:429) [ironjacamar-core-impl-1.0.36.Final-redhat-1.jar:1.0.36.Final-redhat-1]
> 	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:344) [ironjacamar-core-impl-1.0.36.Final-redhat-1.jar:1.0.36.Final-redhat-1]
> 	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:317) [ironjacamar-core-impl-1.0.36.Final-redhat-1.jar:1.0.36.Final-redhat-1]
> 	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:499) [ironjacamar-core-impl-1.0.36.Final-redhat-1.jar:1.0.36.Final-redhat-1]
> 	at org.teiid.resource.spi.WrappedConnectionFactory.getConnection(WrappedConnectionFactory.java:58) [teiid-api-8.7.6.6_2-redhat-1.jar:8.7.6.6_2-redhat-1]
> 	at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:181) [teiid-api-8.7.6.6_2-redhat-1.jar:8.7.6.6_2-redhat-1]
> 	at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:202) [teiid-api-8.7.6.6_2-redhat-1.jar:8.7.6.6_2-redhat-1]
> 	at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:58) [teiid-engine-8.7.6.6_2-redhat-1.jar:8.7.6.6_2-redhat-1]
> 	at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.7.6.6_2-redhat-1.jar:8.7.6.6_2-redhat-1]
> 	at org.teiid.jboss.VDBService$6.run(VDBService.java:390) [teiid-jboss-integration-8.7.6.6_2-redhat-1.jar:8.7.6.6_2-redhat-1]
> 	at org.teiid.jboss.VDBService$7.run(VDBService.java:439) [teiid-jboss-integration-8.7.6.6_2-redhat-1.jar:8.7.6.6_2-redhat-1]
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
> 	at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
> 	at org.jboss.threads.JBossThread.run(JBossThread.java:122)



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)