Hello Tony, I saw that you posted a similar question on the "Community App UI now with CI/CD (and cui.fineract.dev removed)" email thread, so I'll attempt to answer everything in this thread here instead:
> Do you have an app.yaml for the fineract.dev deployment on GAE Flex that can be shared? As per FAQ on https://www.fineract.dev: "We haven’t been able to figure out how to explain the details of how this runs and make it an effective use of your and our time." Sorry if that's (intentionally) a bit evasive... ;-) But see below. > I was also wondering if you use the dockerfile as is for the deployment and how you set that up without using docker compose. Yeah, exactly, I use the dockerfile as is. The Docker Compose isn't useful, in this scenario. So I basically just build https://github.com/apache/fineract/blob/develop/Dockerfile on Google Cloud Build and push it to Google Container Registry (because AppEngine cannot read from Docker Hub). On Mon, Nov 23, 2020 at 8:53 PM Tony O <[email protected]> wrote: > Hello Community, > Anyone able to deploy fineract on Google App Engine flex successfully? > I am having a connection exception when fineract tries to make a > connection to a Cloud Sql instance in the same VPC network. > > Error: Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: > Communications link failure > > 1. I set the JDBC parameters as environment variable in my app.yaml file : > The one you showed below looks pretty good, mine looks essentially like that, so you must be close, but I did spot one thing: > runtime: custom > env: flex > > env_variables: > DRIVERCLASS_NAME: "com.mysql.jdbc.Driver" > PROTOCOL: "jdbc" > SUB_PROTOCOL: "mysql" > fineract_tenants_driver: "com.mysql.jdbc.Driver" > fineract_tenants_url: "jdbc:mysql://IP:3306/fineract_tenants" > fineract_tenants_uid: "root" > PLEASE don't EVER use default passwords... ;-) > fineract_tenants_pwd: "mysql" > FINERACT_DEFAULT_TENANTDB_HOSTNAME: "" > This seems wrong, no? Compare this to https://github.com/apache/fineract/blob/develop/docker-compose.yml#L53.. it must be the hostname of where you tenants DB is. How can it be empty? ;-) Also I our docker-compose.yml example doesn't quote the YAML values, but that shouldn't make any difference. > FINERACT_DEFAULT_TENANTDB_PORT: "3306" > FINERACT_DEFAULT_TENANTDB_UID: "root" > as above FINERACT_DEFAULT_TENANTDB_PWD: "IP" > erm... not IP, but some your well chosen super secret password here, yes? ;-) 2. I provide a simple Dockerfile - openjdk11 > as above, this shouldn't actually be needed. > FROM gcr.io/distroless/java:11 as fineract > > ADD fineract-provider.jar fineract-provider.jar > > ENTRYPOINT ["java","-jar","fineract-provider.jar"] > > === > Appreciate anyone helping to figure out why I am getting a connection > issue. > Does this help? Could I ask you a question: If with 1 click you could simply "rent" a pre-configured dedicated private tenant on https://www.fineract.dev, or another server like it, instead of having to figure all this out yourself, would you use it? Best, M. _______________________ Michael Vorburger http://www.vorburger.ch
