[google-appengine] Re: How to access Google Cloud SQL Proxy from App Engine from DotNet App

[George West]

Hi

I need more info about when MySQL and the App are running under the same 
project

Can I simply make a direct call to MySQL from the App engine without proxy, 
or white-listed IPs, or SSL
Just an internal ip address and user name and password?


On Friday, 24 March 2017 11:44:26 UTC-4, Jordan (Cloud Platform Support) 
wrote:
>
> As noted in the documentation 
> , 
> connections that are made using the Cloud SQL Proxy or from App Engine are 
> already encrypted by default whether you configure SSL for the instance or 
> not. So you do not require an SSL cert in these cases. 
>
> If your Cloud SQL instance is in the same project as the App Engine app 
> that is making the connection, your App Engine application is already 
> authorized to access the SQL instance. Therefore you do not need to 
> authorize any additional networks or IPs. If you are connecting to a Cloud 
> SQL instance located in a different project, you will need to authorize 
> the App Engine app 
> 
> . 
>
> Alternatively, you can force Only SSL connections to your instance 
> (regardless of IP address), by following the SSL guide 
> .
>  
> Just make sure you supply the location of your SSL cert and key 
> 
>  
> in your Dockerfile similar to how it is done again in Kubernetes 
> 
>  so 
> that the proxy starts with the SSL configuration. 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/29a2191e-e57c-4516-b818-926dd5cd991f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: How to access Google Cloud SQL Proxy from App Engine from DotNet App

[George West]

Hi

I did the following:

1- Took a copy of the Proxy (one for Linux and one for Windows) as part of 
the app
2- Marked the proxy with chmod as executable in the Docker file
3- when the .net app runs, it kills the old proxy tasks (if there), and 
start the proxy again.
4- The app then uses the proxy.

Not what I wanted but it worked

The only thing that I am not sure about is the SSL, to connect with SSL you 
will need, or I believe you will need to white-list external ip addresses, 
not sure why not the internal IPs?



On Tuesday, 21 March 2017 14:50:59 UTC-4, Jordan (Cloud Platform Support) 
wrote:
>
> It is actually much easier to connect to your Cloud SQL 
>  
> instance from App Engine. Instead of using a proxy to connect, you can 
> directly connect from your App Engine app securely with SSL using the IP, 
> username, and password of your Cloud SQL instance. 
>
> Alternatively, if you want to install the Cloud SQL proxy on all of your 
> App Engine instances (*Not recommended* as App Engine is meant for fast 
> scalable apps), you would need to build your own App Engine Flexible 
> environment runtime 
> . 
> In this Hicustom .NET runtime you would need to install the Cloud SQL proxy 
> into a container, by adding in the '*gcr.io/cloudsql-docker/gce-proxy 
> '* image to your Dockerfile as 
> shown in the Kubernetes example 
> 
> . 
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/aed00cc6-dceb-402e-a88d-7e2f06b357de%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] How to access Google Cloud SQL Proxy from App Engine from DotNet App

[George West]

How to access Google Cloud SQL Proxy from App Engine from DotNet Core App.

- I wrote a Web App using DotNet Core / ASP.NET
- I tested the app locally with My SQL and Google Cloud SQL Proxy
- I deployed the app to Google App Engine

**Question:**

Is there a copy of the Google SQL Proxy on the Flex / Custom VM where my 
app is deployed?

How to access it from .NET Core?

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/572ffe2b-f5b3-49f1-bdcb-1b3c56e9f2ad%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Too many GoogleHC/1.0 /_ah/vm_health entries in the log

[George West]

Hi

- I created a DotNet Core App
- Deployed it on the Google App Engine (Custom / Flex)
- I opened the logging tab

I noticed the following entry: _ah/vm_health
It is not there once or twice, it is there very large number of times

*Questions:*
1- How can I exclude this one from the logs, I know the system is checking 
if everything is healthy, and this is good, I just don’t want it logged.
2- How can I exclude anything from the logs? For example, there is an 
entry, and it is sending things to the logs, and wanted ignored by the log 
system.

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/8d405d87-9acd-4fcf-b746-0c507666d7ae%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Unable to create new Client ID for Android Application

[AJ West]

After generating my release key and finding the SHA1 I go into my app 
engine project Dev Console under the APIsAuth-Credentials section.

From here I click, Create a new Client ID
Select Installed Application
Click Android radio button
Put in my package name: ca.ajwest.pythonapi
And paste in my SHA1 certificate fingerprint
Deep linking is enabled

After I click Create Client ID the lightbox popup returns to the console 
screen with the new Client ID for Android application with the SHA1 and 
package name displayed properly. When refreshing the console or navigating 
away and back to the credentials screen, the newly created Android Client 
ID no longer lists the SHA1, and the Deep linking option has been changed 
to disabled.

Just in case, I tried an authenticated call with the backend and the server 
logs display say that my client id is not authorized, despite it being 
clearly listed in my project's dev console (but now without the SHA1 field 
filled in for some reason).

I have tried creating an entirely new project, *and *a new 
keystore/certificate with the same results. Is there a problem with App 
Engine creating client ID credentials? 

-- 
You received this message because you are subscribed to the Google Groups 
Google App Engine group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] deployed my project to GAE,but The server encountered an error and could not complete your request

[west]

I run my project on my Eclipse,it's ok.But when I deploy it to GAE,and
I visit the website,and then login.the error happens:

Error: Server Error

The server encountered an error and could not complete your request.
If the problem persists, please report your problem and mention this
error message and the query that caused it.

I copy the logs from GAE

04-03 01:28AM 25.259 /Frame.jsp 500 62ms 38cpu_ms 0kb Mozilla/5.0
(Windows; U; Windows NT 5.1; en-US) AppleWebKit/533.1 (KHTML, like
Gecko) Chrome/5.0.335.1 Safari/533.1,gzip(gfe)
218.18.44.28 - - [03/Apr/2010:01:28:25 -0700] GET /Frame.jsp HTTP/
1.1 500 0 http://mywebchat.appspot.com/; Mozilla/5.0 (Windows; U;
Windows NT 5.1; en-US) AppleWebKit/533.1 (KHTML, like Gecko) Chrome/
5.0.335.1 Safari/533.1,gzip(gfe) mywebchat.appspot.com
W 04-03 01:28AM 25.312
/Frame.jsp
java.lang.NullPointerException
at com.google.appengine.runtime.Request.process-
cf3c064e718becb0(Request.java)
at org.apache.jsp.Frame_jsp._jspService(Frame_jsp.java:55)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
511)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1166)
at
com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlobUploadFilter.java:
97)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java:
35)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:
43)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
388)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
182)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
418)
at
com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java:
238)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
542)
at org.mortbay.jetty.HttpConnection
$RequestHandler.headerComplete(HttpConnection.java:923)
at
com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java:
76)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java:
135)
at
com.google.apphosting.runtime.JavaRuntime.handleRequest(JavaRuntime.java:
243)
at com.google.apphosting.base.RuntimePb$EvaluationRuntime
$6.handleBlockingRequest(RuntimePb.java:5485)
at com.google.apphosting.base.RuntimePb$EvaluationRuntime
$6.handleBlockingRequest(RuntimePb.java:5483)
at
com.google.net.rpc.impl.BlockingApplicationHandler.handleRequest(BlockingApplicationHandler.java:
24)
at com.google.net.rpc.impl.RpcUtil.runRpcInApplication(RpcUtil.java:
398)
at com.google.net.rpc.impl.Server$2.run(Server.java:852)
at
com.google.tracing.LocalTraceSpanRunnable.run(LocalTraceSpanRunnable.java:
56)
at
com.google.tracing.LocalTraceSpanBuilder.internalContinueSpan(LocalTraceSpanBuilder.java:
536)
at com.google.net.rpc.impl.Server.startRpc(Server.java:807)
at com.google.net.rpc.impl.Server.processRequest(Server.java:369)
at
com.google.net.rpc.impl.ServerConnection.messageReceived(ServerConnection.java:
442)
at
com.google.net.rpc.impl.RpcConnection.parseMessages(RpcConnection.java:
319)
at
com.google.net.rpc.impl.RpcConnection.dataReceived(RpcConnection.java:
290)
at com.google.net.async.Connection.handleReadEvent(Connection.java:
474)
at
com.google.net.async.EventDispatcher.processNetworkEvents(EventDispatcher.java:
831)
at
com.google.net.async.EventDispatcher.internalLoop(EventDispatcher.java:
207)
at com.google.net.async.EventDispatcher.loop(EventDispatcher.java:
103)
at
com.google.net.rpc.RpcService.runUntilServerShutdown(RpcService.java:
251)
at com.google.apphosting.runtime.JavaRuntime
$RpcRunnable.run(JavaRuntime.java:404)
at java.lang.Thread.run(Unknown Source)
C 04-03 01:28AM 25.315
Uncaught exception from servlet
java.lang.NullPointerException
at 

[google-appengine] Can we add 3rd party Libraries to a Java App?

[West]

Hi,

I'm using the Google App Eclipse SDK. In my application i want to use
some external libraries and jar functionalities. I'm able to add these
Libraries to the Project but when the application is tested on G.
Development Server i get a class not found error! Can someone please
help??


Regards
West

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Google App Engine group.
To post to this group, send email to google-appengine@googlegroups.com
To unsubscribe from this group, send email to 
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/google-appengine?hl=en
-~--~~~~--~~--~--~---