-
Notifications
You must be signed in to change notification settings - Fork 4
Description
Trying to connect this to GMail or Google Docs generates "Failed to retrieve access token" after authorising with Google.
Looking in the logs, I see that the authentication has successfully completed but there is an error saving this information to the database.
frontend_container | data: {
frontend_container | access_token: 'XXXXXXXXXXX',
frontend_container | expires_in: 3599,
frontend_container | refresh_token: 'XXXXXXXXXXX',
frontend_container | scope: 'https://mail.google.com/',
frontend_container | token_type: 'Bearer'
frontend_container | }
frontend_container | }
frontend_container | TOKEN DATA
frontend_container | {
frontend_container | access_token: 'XXXXXXXXXXX',
frontend_container | expires_in: 3599,
frontend_container | refresh_token: 'XXXXXXXXXXX,
frontend_container | scope: 'https://mail.google.com/',
frontend_container | token_type: 'Bearer'
frontend_container | }
frontend_container | PARSED TOKEN REQUEST
frontend_container | {
frontend_container | api_key: '',
frontend_container | access_token: 'XXXXXXXXXXX',
frontend_container | refresh_token: 'XXXXXXXXXXX',
frontend_container | client_id: 'XXXXXXXXXXX',
frontend_container | client_secret: 'XXXXXXXXXXX',
frontend_container | table_name: 'gmail'
frontend_container | }
backend_container | ERROR:app.controllers.token:Unexpected error in token controller.py: (sqlalchemy.dialects.postgresql.asyncpg.Error) <class 'asyncpg.exceptions.DataError'>: invalid input for query argument $1: '' (invalid UUID '': length must be between 32..36 characters, got 0)
backend_container | [SQL: SELECT gmail.id, gmail.api_key, gmail.access_token, gmail.refresh_token, gmail.client_id, gmail.client_secret, gmail.created_at, gmail.updated_at
backend_container | FROM gmail
backend_container | WHERE api_key = $1
backend_container | LIMIT $2::INTEGER OFFSET $3::INTEGER]
backend_container | [parameters: ('', 6500, 0)]
backend_container | (Background on this error at: https://sqlalche.me/e/20/dbapi)
backend_container | INFO: 172.31.0.3:35324 - "POST /api/token HTTP/1.1" 500 Internal Server Error
frontend_container | Token exchange error: { detail: 'An unexpected error occurred' }
frontend_container | GET /api/oauth2/callback?code=4%2XXXXXXXXXXX&scope=https%3A%2F%2Fmail.google.com%2F&state=4e1321b3-21e0-43d4-bf1b-a2c8fc3c6d14 500 in 530ms