Sunday, August 25, 2013

Re: Squirrel Unauthorized Client Issue

Thanks, I'm on Windows so I couldn't run the .sh, but when I ran:

java -jar google_sql.jar <instance>

it connected without asking for any credentials... then when I tried Squirrel again it worked.

Do you know where the different tokens are stored in Windows?  Are they both in the registry?

On Sunday, August 25, 2013 4:33:46 PM UTC-4, 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.

--
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/8f6310ba-b7db-4975-87e4-5e7f4f08bbc1%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

No comments:

Post a Comment