bengen343 / superset-on-gcp-cloud-run Goto Github PK

I followed all the steps and at last, I got this error in Cloud run logs when I hit the URL

19:40:41,946:ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (psycopg2.OperationalError) connection to server on socket "/cloudsql/test-ecb9b:asia-southeast1:superset-configs/.s.PGSQL.5432" failed: FATAL: password authentication failed for user "superset"

And thank you for the wonderful documentation & setup scripts.

Following step 1 of "Build Superset Configuration SQL Database", superset db upgrade fails to run with the error message included below. I've attempted the suggested fixes described here with no success so far. I am unsure of next steps to resolve this error, any help is appreciated.

Traceback (most recent call last):
  File "/usr/local/bin/superset", line 5, in <module>
    from superset.cli.main import superset
  File "/usr/local/lib/python3.8/site-packages/superset/__init__.py", line 21, in <module>
    from superset.app import create_app
  File "/usr/local/lib/python3.8/site-packages/superset/app.py", line 23, in <module>
    from superset.initialization import SupersetAppInitializer
  File "/usr/local/lib/python3.8/site-packages/superset/initialization/__init__.py", line 33, in <module>
    from superset.extensions import (
  File "/usr/local/lib/python3.8/site-packages/superset/extensions/__init__.py", line 32, in <module>
    from superset.utils.cache_manager import CacheManager
  File "/usr/local/lib/python3.8/site-packages/superset/utils/cache_manager.py", line 24, in <module>
    from superset.utils.core import DatasourceType
  File "/usr/local/lib/python3.8/site-packages/superset/utils/core.py", line 75, in <module>
    from cryptography.hazmat.backends.openssl.x509 import _Certificate
ModuleNotFoundError: No module named 'cryptography.hazmat.backends.openssl.x509'

Hey,

When I try to access my deployed suerpset instance on GCP I get following error:

"Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/superset/app.py", line 37, in create_app
app_initializer.init_app()
File "/usr/local/lib/python3.8/site-packages/superset/initialization/init.py", line 567, in init_app
self.setup_db()
File "/usr/local/lib/python3.8/site-packages/superset/initialization/init.py", line 693, in setup_db
pessimistic_connection_handling(db.engine)
File "/usr/local/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 998, in engine
return self.get_engine()
File "/usr/local/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 1017, in get_engine
return connector.get_engine()
File "/usr/local/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 594, in get_engine
self._engine = rv = self._sa.create_engine(sa_url, options)
File "/usr/local/lib/python3.8/site-packages/flask_sqlalchemy/init.py", line 1027, in create_engine
return sqlalchemy.create_engine(sa_url, **engine_opts)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/init.py", line 525, in create_engine
return strategy.create(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 61, in create
entrypoint = u._get_entrypoint()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/url.py", line 172, in _get_entrypoint
cls = registry.load(name)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 277, in load
raise exc.NoSuchModuleError(
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: `sqlalchemy.dialects:postgresql.psycopg"

There seems to be a python version mismatch, However, I have not been able to solve it. I haven't got much experience with GCP so currently I am able to tell whether it is related to the python version on GCP or the container.