heroku / heroku-airflow

Demo of Author data workflows with Airflow on Heroku (not maintained)
Other
23 stars 6 forks source link

Invalid code from auth provider #9

Closed jney closed 7 years ago

jney commented 7 years ago

Hi everyone, i have some errors while installing this repo. Here are the errors and the fixes.

Alchemy try to connect a sqlite database, i had to set AIRFLOW__CORE__SQL_ALCHEMY_CONN as DATABASE_URL is

AIRFLOW__CORE__SQL_ALCHEMY_CONN: postgres://...

then i had the error fixed by https://github.com/heroku/heroku-airflow/pull/7

KeyError: 'Decoder failed to handle access_token with data as returned by provider. A different decoder may be needed. Provider returned: {\n "error": "redirect_uri_mismatch",\n "error_description": "Bad Request",\n "error_uri": ""\n}\n'

then i had the following error:

    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) column user.provider_id does not exist
LINE 1: ...ame AS user_username, "user".email AS user_email, "user".pro...
                                                             ^
 'SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".provider_id AS user_provider_id, "user".registered_on AS user_registered_on \nFROM "user" \nWHERE "user".provider_id = %(provider_id_1)s \n LIMIT %(param_1)s' {'provider_id_1': u'112713688776680649961', 'param_1': 1}

i fixed it by running migration.sql myself, i don't how it is supposed to be run

now i have the following error:

KeyError: 'Decoder failed to handle access_token with data as returned by provider. A different decoder may be needed. Provider returned: {\n "error": "invalid_grant",\n "error_description": "Invalid code.",\n "error_uri": ""\n}\n'

any idea ?

jney commented 7 years ago

it actually works now. don't know how it was fixed