hi, im getting this error Wed Oct 16 19:30:18 UTC 2019 There was an unexpected error (type=Internal Server Error, status=500). Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Cannot connect to MySQL server on google:3,306. Make sure that there is a MySQL server running on the machine/port you are trying to connect to and that the machine this software is running on is able to connect to this host/port (i.e. not firewalled). Also make sure that the server has not been started with the --skip-networking flag.
Hi, I am getting the below error. Cloud you please help me on this? I am using your zip file and replacing with my SQL instance and project id in application.yml file. Whitelabel Error Page This application has no explicit mapping for /error, so you are seeing this as a fallback. Thu Aug 22 05:23:24 UTC 2019 There was an unexpected error (type=Internal Server Error, status=500). Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Thanks in advance.
Hi amareswaran! I have create spring boot application with spring security. I have uploaded on google cloud through your video after successful upload, when i am calling my services it is show 502 error bad gateway.. I am not getting this error how to fix
+MD MUQTAR please make sure you have added mysql connection socketfactory dependency is added or not. Cloud sql and application should be in same project. Make sure cloud sql api(s) are enabled in your GCP. Above steps are I mentioned in video itself. Please verify it. Otherwise send your code to talk2amareswaran@gmail.com I will verify and reply you very soon
I have done all the requirements what ever you have shown in tutorial but am using application properties for connecting. i have send you mail application properties mail please check
Also, download this zip and extract the project. I used build.gradle file and jdbctemplate for connecting the database. github.com/talk2amareswaran/projects/blob/master/GCP-Appengine-cloudsql.zip
Thanks for the tutorial. Am getting error while deploying the appEngine and below is the error message gradle appengineDeploy :compileJava UP-TO-DATE :processResources UP-TO-DATE :classes UP-TO-DATE :findMainClass :jar :bootRepackage :assemble :appengineStage FAILED FAILURE: Build failed with an exception. * What went wrong: Execution failed for task ':appengineStage'. > java.lang.NullPointerException (no error message) * Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. BUILD FAILED Total time: 11.276 secs Any thoughts?
No I have not. I have done gcloud auth activate-service-account --key-file=hgh.json, but the issue still exists. Can you please share the exact steps to solve this? I did not find anything related to gcloud in this video. Is it outside the scope of this video? Thanks!
Can you please send your application to my mail ID talk2amareswaran@gmail.com. I will verify it and send you the reply soon. Also, You error seems like NullPointerException occurs, but there no messages. With this I can't find the issues?
Your app.yaml file is empty. You need to configure your app with the app.yaml file. cloud.google.com/appengine/docs/flexible/java/configuring-your-app-with-app-yaml Please look my video at 19:00 minutes.
Please make vedio on how to deploy spring boot application along with MySQL database containing (more entities (tables)) in Google cloud platform using maven project not gradel project. Please make vedio on this as soon as possible. Thanks in advance
Hello Mr. very nice tutoreil, but I have a question I develop in back end with spring boot and front end with angular 4 how delpoyer this in app engine please
If Angular application and spring boot both are in same service(application) you can follow the same whatever I followed in this video. Otherwise deploy it as two applications in app engine.. same process for two times.. (API and UI).. Please make sure your API should support CORS
@@Talk2Amareswaran my 2 applications can not communicate: I have 2 micoservices spring boot in backend and an application angular 2 in frontend: how to configure the routes between my mmicroservices and angular
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
hi, im getting this error
Wed Oct 16 19:30:18 UTC 2019
There was an unexpected error (type=Internal Server Error, status=500).
Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Cannot connect to MySQL server on google:3,306. Make sure that there is a MySQL server running on the machine/port you are trying to connect to and that the machine this software is running on is able to connect to this host/port (i.e. not firewalled). Also make sure that the server has not been started with the --skip-networking flag.
thanks you
Thanks a bunch for this great tutorial , badly i stuck with in this work now my issue got resolved .
+Basanta Hota super. Thank you
better than most tutorials
Hi,
I am getting the below error. Cloud you please help me on this? I am using your zip file and replacing with my SQL instance and project id in application.yml file.
Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.
Thu Aug 22 05:23:24 UTC 2019
There was an unexpected error (type=Internal Server Error, status=500).
Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
Thanks in advance.
The video was quite outdated. Let me check with latest one and i will update you
How to update the existing app on google cloud app engine?
Could you please help me with spring boot with cloud sql and deployed to cloud run..
When I try to add class on the project it wont let me cause "not a java project"
Best Regards From Mexico City. Manuel Silva
Yes. Welcome
Thanks you it's clear
Nice one. But where is micro service here.
Hi amareswaran! I have create spring boot application with spring security. I have uploaded on google cloud through your video after successful upload, when i am calling my services it is show 502 error bad gateway.. I am not getting this error how to fix
+MD MUQTAR May I know are you connecting Google cloud sql?
Talk2 Amareswaran yes I m connecting to google sql cloud
+MD MUQTAR
please make sure you have added mysql connection socketfactory dependency is added or not.
Cloud sql and application should be in same project.
Make sure cloud sql api(s) are enabled in your GCP.
Above steps are I mentioned in video itself. Please verify it.
Otherwise send your code to talk2amareswaran@gmail.com I will verify and reply you very soon
I have done all the requirements what ever you have shown in tutorial but am using application properties for connecting. i have send you mail application properties mail please check
Also, download this zip and extract the project. I used build.gradle file and jdbctemplate for connecting the database. github.com/talk2amareswaran/projects/blob/master/GCP-Appengine-cloudsql.zip
Thanks for the tutorial.
Am getting error while deploying the appEngine and below is the error message
gradle appengineDeploy
:compileJava UP-TO-DATE
:processResources UP-TO-DATE
:classes UP-TO-DATE
:findMainClass
:jar
:bootRepackage
:assemble
:appengineStage FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':appengineStage'.
> java.lang.NullPointerException (no error message)
* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output.
BUILD FAILED
Total time: 11.276 secs
Any thoughts?
Have u install Google SDK in your machine? You have to do gcloud auth
No I have not.
I have done gcloud auth activate-service-account --key-file=hgh.json, but the issue still exists.
Can you please share the exact steps to solve this? I did not find anything related to gcloud in this video. Is it outside the scope of this video?
Thanks!
Can you please send your application to my mail ID talk2amareswaran@gmail.com. I will verify it and send you the reply soon. Also, You error seems like NullPointerException occurs, but there no messages. With this I can't find the issues?
I have sent the mail, please check and let me know. thanks for the extended help!
Your app.yaml file is empty. You need to configure your app with the app.yaml file.
cloud.google.com/appengine/docs/flexible/java/configuring-your-app-with-app-yaml
Please look my video at 19:00 minutes.
Please make vedio on how to deploy spring boot application along with MySQL database containing (more entities (tables)) in Google cloud platform using maven project not gradel project. Please make vedio on this as soon as possible. Thanks in advance
Hello Mr. very nice tutoreil, but I have a question I develop in back end with spring boot and front end with angular 4 how delpoyer this in app engine please
If Angular application and spring boot both are in same service(application) you can follow the same whatever I followed in this video. Otherwise deploy it as two applications in app engine.. same process for two times.. (API and UI).. Please make sure your API should support CORS
@@Talk2Amareswaran my 2 applications can not communicate: I have 2 micoservices spring boot in backend and an application angular 2 in frontend: how to configure the routes between my mmicroservices and angular
This is not a microservices