René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"*(psycopg2.OperationalError) could not connect to server: No such file or directory* GAE Flex enivronment","articleBody":"Hi, I'm getting this error when im trying to connect to my PostgreSQL on my app when its deployed. I followed the instructions here [https://cloud.google.com/appengine/docs/flexible/python/using-cloud-sql-postgres?authuser=0](https://cloud.google.com/appengine/docs/flexible/python/using-cloud-sql-postgres)\r\n\r\nBoth the app and PostgreSQL are in the same project and in the same region.\r\n\r\nThe error message is\r\n```\r\nAn internal error occurred:\r\n(psycopg2.OperationalError) could not connect to server: No such file or directory\r\n\tIs the server running locally and accepting\r\n\tconnections on Unix domain socket \"/cloudsql/flask-161002:us-east1:myserver/.s.PGSQL.5432\"?\r\nSee logs for full stacktrace.\r\n```\r\n\r\nMy app.yaml is this\r\n```\r\nruntime: python\r\nenv: flex\r\nentrypoint: gunicorn -b :$PORT app:app\r\n\r\nruntime_config:\r\n  python_version: 3\r\n\r\nenv_variables:\r\n    # Replace user, password, database, and instance connection name with the values obtained\r\n    # when configuring your Cloud SQL instance.\r\n    SQLALCHEMY_DATABASE_URI: \u003e-\r\n      postgresql+psycopg2://postgres:pass@/postgres?host=/cloudsql/flask-161002:us-east1:myserver\r\nbeta_settings:\r\n    cloud_sql_instances: flask-161002:us-east1:myserver\r\n```\r\nIn my app.py, I connect wtih\r\n```\r\napp.config['SQLALCHEMY_DATABASE_URI'] = os.environ['SQLALCHEMY_DATABASE_URI']\r\n```\r\n\r\nThe logs from the stacktrace\r\n```\r\nsqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: No such file or directory\r\nat connect (/env/lib/python3.5/site-packages/psycopg2/__init__.py:130)\r\nat connect (/env/lib/python3.5/site-packages/sqlalchemy/engine/default.py:385)\r\nat connect (/env/lib/python3.5/site-packages/sqlalchemy/engine/strategies.py:105)\r\nat __connect (/env/lib/python3.5/site-packages/sqlalchemy/pool.py:651)\r\nat __init__ (/env/lib/python3.5/site-packages/sqlalchemy/pool.py:461)\r\nat _create_connection (/env/lib/python3.5/site-packages/sqlalchemy/pool.py:333)\r\nat _do_get (/env/lib/python3.5/site-packages/sqlalchemy/pool.py:1135)\r\nat reraise (/env/lib/python3.5/site-packages/sqlalchemy/util/compat.py:186)\r\nat __exit__ (/env/lib/python3.5/site-packages/sqlalchemy/util/langhelpers.py:60)\r\nat _do_get (/env/lib/python3.5/site-packages/sqlalchemy/pool.py:1138)\r\nat checkout (/env/lib/python3.5/site-packages/sqlalchemy/pool.py:516)\r\nat _checkout (/env/lib/python3.5/site-packages/sqlalchemy/pool.py:766)\r\nat connect (/env/lib/python3.5/site-packages/sqlalchemy/pool.py:387)\r\nat _wrap_pool_connect (/env/lib/python3.5/site-packages/sqlalchemy/engine/base.py:2141)\r\nat reraise (/env/lib/python3.5/site-packages/sqlalchemy/util/compat.py:185)\r\nat raise_from_cause (/env/lib/python3.5/site-packages/sqlalchemy/util/compat.py:202)\r\nat _handle_dbapi_exception_noconnection (/env/lib/python3.5/site-packages/sqlalchemy/engine/base.py:1456)\r\nat _wrap_pool_connect (/env/lib/python3.5/site-packages/sqlalchemy/engine/base.py:2145)\r\nat contextual_connect (/env/lib/python3.5/site-packages/sqlalchemy/engine/base.py:2106)\r\nat _connection_for_bind (/env/lib/python3.5/site-packages/sqlalchemy/orm/session.py:403)\r\nat _connection_for_bind (/env/lib/python3.5/site-packages/sqlalchemy/orm/session.py:971)\r\nat connection (/env/lib/python3.5/site-packages/sqlalchemy/orm/session.py:966)\r\nat _connection_from_session (/env/lib/python3.5/site-packages/sqlalchemy/orm/query.py:2807)\r\nat _get_bind_args (/env/lib/python3.5/site-packages/sqlalchemy/orm/query.py:2825)\r\nat _execute_and_instances (/env/lib/python3.5/site-packages/sqlalchemy/orm/query.py:2816)\r\nat __iter__ (/env/lib/python3.5/site-packages/sqlalchemy/orm/query.py:2795)\r\nat one_or_none (/env/lib/python3.5/site-packages/sqlalchemy/orm/query.py:2724)\r\nat one (/env/lib/python3.5/site-packages/sqlalchemy/orm/query.py:2754)\r\nat load_on_ident (/env/lib/python3.5/site-packages/sqlalchemy/orm/loading.py:223)\r\nat _get_impl (/env/lib/python3.5/site-packages/sqlalchemy/orm/query.py:862)\r\nat get (/env/lib/python3.5/site-packages/sqlalchemy/orm/query.py:829)\r\nat get_single_state (/home/vmagent/app/app.py:65)\r\nat dispatch_request (/env/lib/python3.5/site-packages/flask/app.py:1598)\r\nat full_dispatch_request (/env/lib/python3.5/site-packages/flask/app.py:1612)\r\nat reraise (/env/lib/python3.5/site-packages/flask/_compat.py:33)\r\nat handle_user_exception (/env/lib/python3.5/site-packages/flask/app.py:1517)\r\nat full_dispatch_request (/env/lib/python3.5/site-packages/flask/app.py:1614)\r\nat wsgi_app (/env/lib/python3.5/site-packages/flask/app.py:1982)\r\n```","author":{"url":"https://github.com/ben-nguyen1","@type":"Person","name":"ben-nguyen1"},"datePublished":"2017-04-03T18:06:48.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":15},"url":"https://github.com/884/python-docs-samples/issues/884"}