Re: ava.sql.SQLInvalidAuthorizationSpecException Not authorized to access instance

On Tue, Nov 19, 2013 at 11:09 AM, developer <developer@gubo.com> wrote:

yes, i was quite confused on this, because of the scattered documentation
see: https://groups.google.com/forum/#!msg/google-cloud-sql-discuss/YeMriFXax6Q/qiJHYGQ4cEoJ

That message is old. As Sundar pointed out, that is deprecated.

 

can you offer an explanation of:
1. it had been working last month with that instance name

I'm surprised that it did.

 

2. why should it work from eclipse (connecting to cloud sql instance) ?

In Eclipse we had a way to overwrite the Cloud SQL instance name based on some JVM flags. We deprecated that in favor of IP connectivity.

Note: please ignore the pages from [1] for now. We are working on updating them.

[1] https://developers.google.com/eclipse/docs/cloudsql

-- Razvan ME

 

i will upgrade to the new wire protocol.

thanks again,
jeff

On 11/19/2013 11:04 AM, Sundar Venkatasubramanian wrote:

Also, please note that the custom JDBC driver you are using is a deprecated method of connecting. We recently launched connectivity using the mysql wire protocol. Please find the docs here.

On Tue, Nov 19, 2013 at 10:54 AM, Sundar Venkatasubramanian <sundaresan@google.com> wrote:

I think your instance name not right. Can you please try book-server:books instead of book-server.appspot.com:book-server:books?

On Tue, Nov 19, 2013 at 10:48 AM, jeff schulz <developer@gubo.com> wrote:

cant understand why: 

i can access db no problem from development server, but on deployed app engine i cant access db.

i am connecting as root, not as any particular user/password.

jdbc:google:rdbms://book-server.appspot.com:book-server:books/books

error:

java.sql.SQLInvalidAuthorizationSpecException Not authorized to access instance: book-server.appspot.com:book-server:books

--
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/edb677b3-2359-42ce-9882-559b9c28c885%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
-Sundar

--
-Sundar

--

You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/sPlMbRzYjSo/unsubscribe.
To unsubscribe from this group and all its topics, 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/CABrSwLS3D3Ke9_mMGKSRedTtZ8Nr%3DmtqC2AN9%3D8vrEjkpvAHZg%40mail.gmail.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/528BB77B.4020703%40gubo.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/CA%2BUvTg2x6ztBsLLARdY7mMqsKr2Yt1TrDGcQx-HBmGJkcCWOYA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.