Google Cloud MySql Data Console Changes: Viewing and Querying Data

[Jason Andrea]

So, one of the reasons i only developed 1 or 2 apps using GAE was because i was unhappy with the console interfaces (aside from all of the other tools required to even get started) and the time it takes to learn them, get comfortable with them etc... and back when i created my 1 or 2 apps, the consoles, menus, etc... seemed to change ever few weeks. Granted, this was a few years ago.  But now i have to do some data maintenance on one of my GAE websites that, thankfully, is still working just fine. I have a Cloud MySql database behind my website. People can register information about their businesses, etc... and have other people on the web search it. All is working fine, but now i need to simply dump the data in the MySql db AND make a small change to one of the fields in a MySql table.

Back before i abandoned GAE, i could easily go to https://appengine.google.com, find the data viewing console and type in queries, and actually SEE my MySql data behind my site. Now... my old documentation is completely defunct, with links all redirecting to new locations, because the google console interfaces have changed so drastically since I was last on the site, and i can't seem to find anything even remotely close to a console screen where i can select the database i want to query (like in the old days) and type into a text box to run some queries or update my schema.

Basically... i know my data is there because people are adding to it every day... and the data is findable on the website itself, but i can't for the life of me find a way to connect/view my data on the https://appengine.google.com or https://console.developers.google.com sites. Does anybody have any advice?

In my Python app settings.py code I have my:

GOOGLE_APPINSTANCE_NAME

GOOGLE_DATABASE_NAME

I'm also wondering if i can connect to this data via my desktop Navicat MySql client.

Do i really have to do all this? https://cloud.google.com/sql/docs/mysql-client

And do I have to create a MySql instance/IP if I alerady HAVE a MySql instance running out on GAE? My website is obviously using the MySql data behind it from when i first built the site. Why can I not find my MySql data via the Google Console(s)?

[Ryan (Cloud Platform Support)]

Salutations Jason,

You cannot currently access your data through the console. You can file a Feature Request to get that functionality added.

There might be some confusion with how to connect. You can use what ever client you want. If you already have an IP address for the instance you don't need a new one. You need to add the IP address of the computer you are connecting from to the whitelist.

You can access the interface to look up the IP and whitelist by going here, selecting your instance -> Access Control 

-> Authorization -> Allowed Networks: to add your computers IP

-> IP address: to get the IP of your CloudSQL.

[Jason Andrea]

Very helpful... thank you for your help!

So i've:

-created a new user/password to access my instance

-authorized my computer's IP to access the instance

-found the IPv6 IP address for my instance

I've plugged all of these into my usual GUI MySql client Navicat and it gives me this error when trying to connect:

'Unknown MySql server host '[my IPv6 IP]' (10051)

I've also tried to connect from the >mysql command line prompt using instructions i found... but i get the same connection error.

I assume the port is 3306.

[Ryan (Cloud Platform Support)]

The IP address for your PC that you authorised. Is it a IPv4 or IPv6 address?

On Tuesday, July 7, 2015 at 4:48:21 PM UTC-4, Jason Andrea wrote:

[Jason Andrea]

ahhhh.... yes. it is IPv4. So now I've had Google generate an IPv4 IP 'allowable IP' for me... which makes perfect sense. I've updated all of my connection info with the new IPv4 IP that Google assigned me. But still not connecting. But now it is taking much longer before it gives me basically the same error.

I wish i could see my database show up somewhere on one of Google's consoles. This whole thing is just odd to me. I'm looking at my project, and looking at the "databases" tab, but it doesn't list any databases (see attached screen shot).

Even when i simply try to "Export" my data using the export button at the top.... it always throws an error because it can't find the database. 

Here is my python code:

#google cloud sql database connection info

#production database

GOOGLE_DATABASE="shpotrades"

I can't even get confirmation from Google that I actually DO have a database named 'shpotrades'. Yet my site is working and showing the data. Lord God Google.... WHERE IS MY DATA? :)

Thanks for your help, Ryan... you are the man.

[Jason Andrea]

I was able to get my database structure edits, etc... done by creating some extra 'tool' type queries in my python website app and re-deploying, so no worries. basically i just used my website app to do the things i was hoping to do with a mysql client... but oh well.

[Ryan (Cloud Platform Support)]

I'm glad you were able to get your work done. Please file a Feature Request to add what you need to the console. I will process it personally if you do.

On Tuesday, July 7, 2015 at 4:48:21 PM UTC-4, Jason Andrea wrote:

[Jays Work Email]

Done. And thanks again!

--
You received this message because you are subscribed to a topic in the Google Groups "Google App Engine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-appengine/rZ4cXIyG4Cw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-appengi...@googlegroups.com.
To post to this group, send email to google-a...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/48e7d74a-b9d6-4682-acf6-cd1e4241240e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ryan (Cloud Platform Support)]

Mp, what is the link to your Feature Request?

[Jason Andrea]

Oops... got busy and i never did submit it until just now.

https://code.google.com/p/googleappengine/issues/detail?id=12133

To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/8717c896-d9ca-49b8-8ef6-e0834276c18e%40googlegroups.com.