Re: Squirrel Unauthorized Client Issue

I wish this topic appeared higher up on Google's search results page! 

I've been searching for this for 2.5 - 3 hours!

Using the Python SDK I was able to connect via command line but not via SQuirreL SQL Client.

Following from what was said above, I connected to the Java SDK command line tool just once, restarted the SQuirreL SQL Client and volia, I can now connect! 

This really should be documented somewhere more official!!

On Sunday, 25 August 2013 21:33:46 UTC+1, Rob wrote:

Ah yes. The python google-SQL uses a different token store than the java one google_sql.sh is the one you want.  I'm aware this is confusing and will be remedied soon.

Rob

On Sunday, August 25, 2013, Michael Houck wrote:

I've run both on the same machine with only one google login set up.  Is there a different OAuth file for the python google-sql command line vs the OAuth used by the JDBC driver?

On Saturday, August 24, 2013 9:53:52 PM UTC-4, Amit Mondal wrote:

Is it running as same user?

On Aug 24, 2013 2:05 PM, "Michael Houck" <mho...@gmail.com> wrote:

I'm following the steps in this guide to test out external application access to the Google Cloud SQL:

https://developers.google.com/cloud-sql/docs/admin_tools

and when I get to the test portion, it's giving me this error:

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: 400 Bad Request

{

  "error" : "unauthorized_client"

}

I've tried revoking the access, deleting the OAuth keys in the registry and then regaining access via the google_sql.cmd tool (where I go to the link and paste the auth code into the cmd window) and also via the gauth python script in the /bin directory.  I can connect to the database fine with the google_sql command line, but whenever I test the connection in Squirrel SQL it gives me the unauthorized access issue.

Can anyone help me out on this?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/5a9a75c9-5584-41fa-b679-70053f331ef5%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a5744803-5277-4325-9e49-c08aeae1a261%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

z

This message is for the named person's use only.  If you receive this message in error, please delete it and notify the sender.  Appogee is the products division of Ancoris Limited.

Ancoris reserves the right to monitor all e-mail communications through its networks. Ancoris Limited, Registered in England Number: 04830784, Registered address: 5a Frascati Way, Maidenhead, Berkshire SL6 4UY. Trading Address: Lily Hill House, Lily Hill Road, Bracknell, Berkshire RG12 2SJ

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/cb6b58b4-e5c8-42a9-a72b-0d8f6527954e%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.