ava.sql.SQLInvalidAuthorizationSpecException Not authorized to access instance

[jeff schulz]

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

[Sundar Venkatasubramanian]

I think your instance name not right. Can you please try book-server:books instead of 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-d...@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 Venkatasubramanian]

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.

--
-Sundar

[developer]

hi sundar

thanks for your help, the correction to the instance name seems to have resolved the problem.
i had tried different instance names, but not the one you suggested.

much appreciated,
jeff

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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABrSwLRMmREkdS6_u4_ebjOFMXppLg2D2c2WHYYLnSGC-pcLgw%40mail.gmail.com.

[developer]

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

can you offer an explanation of:
1. it had been working last month with that instance name
2. why should it work from eclipse (connecting to cloud sql instance) ?

i will upgrade to the new wire protocol.

thanks again,
jeff

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-d...@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.

[Razvan Musaloiu-E.]

On Tue, Nov 19, 2013 at 11:09 AM, developer <deve...@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

 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/528BB77B.4020703%40gubo.com.

[jeff schulz]

a follow-up concerning connecting from app-engine application:

this document https://developers.google.com/appengine/docs/java/cloud-sql/#Java_Connect_to_your_database says:

...

Class.forName("com.mysql.jdbc.GoogleDriver");

url = "jdbc:google:mysql://your-project-id:your-instance-name/guestbook?user=root";

...

Connection conn = DriverManager.getConnection(url);

im using:

private final String url = "jdbc:google:rdbms://application-id:instance-id/database";

DriverManager.registerDriver( new AppEngineDriver() );

connection =  DriverManager.getConnection( url );

is this usage of AppEngineDriver correct ?

if so, can it be documented on same page.

thanks :)

[Razvan Musaloiu-E.]

The jdbc:google:rdbms:// is deprecated so please use the jdbc:google:rdbms://.

A correct set of examples are here:

https://developers.google.com/appengine/docs/java/cloud-sql/

 

if so, can it be documented on same page.

Which page? :-)

-- Razvan ME

 

thanks :)

--
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-d...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/98968bdd-7a68-44de-9093-87c587a90802%40googlegroups.com.