# GCP app engine \[Aug 19\] **URL:** \ **Category:** Discord-Discussions\ **Created:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651 "2022-11-03T10:39:31Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/1 "2022-11-03T10:39:32Z")
> 🙋‍♂️ **Philipp Tsipman** _asked_ ## Hi all - looking for some technical help! #### #### Has anyone had luck deploying NocoDB to _Google Cloud App Engine_ as a _Node app_? #### #### I am quite close. It works great on my local machine, but it does not work when I deploy it to GCloud. I see a response in my browser “Cannot GET /dashboard” #### #### Details: #### The Node app and the NocoDB Database are part of the same Google Cloud project. Here’s how I currently specify the database to use as an environmental variable in _app.yaml_: #### #### env\_variables: #### NC\_DB: ‘pg://[DATABASE INSTANCE PUBLIC IP]]?u=[MYUSER]&p=[MYPASSWORD]]&d=[DATABASE NAME]’ #### #### I believe I may need to specify the NocoDB database in a format different from the instance’s public IP address. But stuck here. #### #### Would appreciate any help from the team. Thank you! ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/2 "2022-11-03T10:39:33Z")
> 💁 **o1lab** _replied_ #### I think with cloud SQL some socket param’s have to be set # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/3 "2022-11-03T10:39:34Z")
> 💁 **o1lab** _replied_ #### pls see if you can get a sample node app working with knex before # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/4 "2022-11-03T10:39:35Z")
> 💁 **o1lab** _replied_ #### then it can be worked backwards # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/5 "2022-11-03T10:39:36Z")
> 🙋‍♂️ **Philipp Tsipman** _replied_ #### Thank you! I’m closer. #### #### Google App Engine connects to SQL via Unix Sockets rather than TCP. So, I switched to a Knex JSON file format to write out the full host. Like this: #### #### app.yaml #### env\_variables: #### NC\_DB\_JSON\_FILE: ‘./dbconnect.json’ #### #### dbconnect.json #### { #### “client”: “pg”, #### “connection”: { #### “host” : “/cloudsql/project:region:instance”, #### “user” : “my\_user”, #### “password” : “my\_password”, #### “database” : “db\_name” #### } #### } #### (Source: [Manage database connections  |  Cloud SQL for PostgreSQL  |  Google Cloud](https://cloud.google.com/sql/docs/postgres/manage-connections)) #### #### Now, I can log in and can see my NocoDB project and tables. Yay. #### #### However, none of the table data is showing. Every table times out. #### #### To be continued… # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/6 "2022-11-03T10:39:37Z")
> 🙋‍♂️ **Philipp Tsipman** _replied_ #### I can see the table names and table column names. But, the data is not showing: #### #### “A :: KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?” # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/7 "2022-11-03T10:39:39Z")
> 🙋‍♂️ **Philipp Tsipman** _replied_ #### Any advice? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/8 "2022-11-03T10:39:40Z")
> 💁 **o1lab** _replied_ #### Are u doing from gae or cloud run # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/9 "2022-11-03T10:39:41Z")
> 💁 **o1lab** _replied_ #### With cloud run thr were issues related to pool # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/10 "2022-11-03T10:39:42Z")
> 💁 **o1lab** _replied_ #### However I cannot see anything specific from our end # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/11 "2022-11-03T10:39:43Z")
> 💁 **o1lab** _replied_ #### Could you also try setting pool connection limits # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/12 "2022-11-03T10:39:44Z")
> 💁 **o1lab** _replied_ #### In your config # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/13 "2022-11-03T10:39:46Z")
> 💁 **o1lab** _replied_ #### Pls lookup knex # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/14 "2022-11-03T10:39:47Z")
> 💁 **o1lab** _replied_ #### For it # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:39am UTC](https://community.nocodb.com/t/gcp-app-engine-aug-19/651/15 "2022-11-03T10:39:48Z")
[Autogenerated from discord](https://discord.com/channels/661905455894888490/1008864848517550081) * * * #### Join [NocoDB’s](http://www.nocodb.com/) community [Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)