Re: How to delete SQL instance if it was suspended?

Hi Mike

we'll get back to you off-thread about this

J

On Thu, Nov 29, 2012 at 11:49 PM, mike <karnaukhov.mikhail@gmail.com> wrote:

I've checked that... 

The full picture of the situation: in September I have decided to run project on Google App Engine with Cloud SQL storage. I have chosen D1 pricing and begun studying the services. After certain personal circumstances I have abandoned that idea. The length of usage period was only two last weeks of September and my card was valid thru 09/12. So, I have decided that I would pay only for those two weeks.. Now I have to pay for October and November even when I didn't use DB at all.

What should I do now?

I suppose I have to change my card to valid one. After that billing would be enabled and I would be able to manage my instances. But could the accruals be revised by Google? I don't need any data in that instance anymore (actually, DB is empty). 

Many thanks. 

On Thursday, November 29, 2012 7:58:54 PM UTC+4, Razvan Musaloiu-E. wrote:

Can you please check that you have billing enabled?

-- Razvan ME

On Thu, Nov 29, 2012 at 7:20 AM, mike <karnaukho...@gmail.com> wrote:

Hi, I think I have the same issue...

Could you delete my suspended instance please [project:914128765070:sql:instance:asacloudstore:datastore]?

--
Joe Faith | Product Manager | Google Cloud

Re: Cannot create new instance (billing not enabled)

Ivan, your project looks ok and I see an instance in running state attached to that project. Are you still seeing issues creating new instances?

-- Razvan ME

On Fri, Nov 30, 2012 at 3:28 AM, Iván Yivoff <ivan@pavimentosarquiservi.com> wrote:

And me, same problem

Project Number: 679310361371

Thanks and regards,

I.-

El martes, 13 de noviembre de 2012 12:23:38 UTC+1, Paweł Panasewicz escribió:

I have the same problem.

 

Project no: 757908313104

 

Regards

Paweł

Re: Cannot create new instance (billing not enabled)

And me, same problem

Project Number: 679310361371

Thanks and regards,

I.-

El martes, 13 de noviembre de 2012 12:23:38 UTC+1, Paweł Panasewicz escribió:

I have the same problem.

 

Project no: 757908313104

 

Regards

Paweł

Re: How to delete SQL instance if it was suspended?

I've checked that... 

The full picture of the situation: in September I have decided to run project on Google App Engine with Cloud SQL storage. I have chosen D1 pricing and begun studying the services. After certain personal circumstances I have abandoned that idea. The length of usage period was only two last weeks of September and my card was valid thru 09/12. So, I have decided that I would pay only for those two weeks.. Now I have to pay for October and November even when I didn't use DB at all.

What should I do now?

I suppose I have to change my card to valid one. After that billing would be enabled and I would be able to manage my instances. But could the accruals be revised by Google? I don't need any data in that instance anymore (actually, DB is empty). 

Many thanks. 

On Thursday, November 29, 2012 7:58:54 PM UTC+4, Razvan Musaloiu-E. wrote:

Can you please check that you have billing enabled?

-- Razvan ME

On Thu, Nov 29, 2012 at 7:20 AM, mike <karnaukho...@gmail.com> wrote:

Hi, I think I have the same issue...

Could you delete my suspended instance please [project:914128765070:sql:instance:asacloudstore:datastore]?

Re: Fail at MySQL Connector using GAE + GPE

Hi,

You should use the following driver class instead standard MySQL driver:

com.google.appengine.api.rdbms.AppEngineDriver

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

Hope this helps,

Rob

On Thu, Nov 22, 2012 at 10:07 AM, eduardo conejo <eduardoconejo@gmail.com> wrote:

I´ve sent this email yesterday to GAE discussion group but seems to be more appropriate to use Cloud SQL group. So, I´m copying it here. Any help is very welcome!!!

I´m working on a new system to be deployed on Google App Engine using Google Cloud SQL as database.

My environment is based on Eclipse JUNO (SR1) plus GPE latest available. Using MySQL 5.2 and mysql-connector-java-5.1.22-bin everything on Windows 7 (x64).

I´ve been trying test codes using GAE and GWT mainly based on vanilla GEP auto-generated sample. I may also consider use SmartGWT for fast UI development. At testing time it starts up, the web page gets loaded and I can interact with buttons, etc but the DataBase data never gets populated - it shows the animated fetching icon all the time. Looking at Eclipse console it looks like JDBC connector fails somewhere. Showing the error messages like (full file errors attached):

=== 2012-11-21 23:13:10,192 [01-0] ERROR IDACall - Top-level servlet error: 

java.lang.ExceptionInInitializerError

at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.<clinit>(MysqlDataSource.java:58)

....

....

Caused by: java.security.AccessControlException: access denied ("java.lang.RuntimePermission" "modifyThreadGroup")

at java.security.AccessControlContext.checkPermission(AccessControlContext.java:366)

Searching I found a post in one blog mentioning that there is a issue at java.security.AccessControlException and a potential fix would be like:

In your Java SDK directory you need to remove or modify these 

permission. Modify JDK1.7.0_05\jre\lib\security\java.security file as 

below: 

Change (remove the sun.,): 

FROM 

package.access=sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.imageio.,com.sun.org.apache.xerces.internal.utils.,com.sun.org.apache.xalan.internal.utils. 

TO 

package.access=com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.imageio.,com.sun.org.apache.xerces.internal.utils.,com.sun.org.apache.xalan.internal.utils. 

Change (not totally necessary but to avoid other problems): 

FROM 

package.definition=sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.imageio.,com.sun.org.apache.xerces.internal.utils.,com.sun.org.apache.xalan.internal.utils. 

to 

package.definition=com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.imageio.,com.sun.org.apache.xerces.internal.utils.,com.sun.org.apache.xalan.internal.utils. 

This may leave open other java programs sun.* calls to local access 

but for dev purposes this is the quickest solution without knowing 

specifically what the AppEngine Driver is doing locally and messing 

with app signing and policy files. 

s  

Is this workaround really needed, or I may be missing something else?

Appreciate by any hint on that since I´ve been fighting for about 2 weeks and not progressing.

thanks

Conejo

Re: How to delete SQL instance if it was suspended?

Can you please check that you have billing enabled?

-- Razvan ME

On Thu, Nov 29, 2012 at 7:20 AM, mike <karnaukhov.mikhail@gmail.com> wrote:

Hi, I think I have the same issue...

Could you delete my suspended instance please [project:914128765070:sql:instance:asacloudstore:datastore]?

Re: How to delete SQL instance if it was suspended?

Hi, I think I have the same issue...

Could you delete my suspended instance please [project:914128765070:sql:instance:asacloudstore:datastore]?

Re: php support

its facing the same error

Thanks,
Shilendra

On Tue, Nov 27, 2012 at 5:15 AM, Joe Faith <joefaith@google.com> wrote:

Hi Douglas

At the moment we have focussed on optimizing Cloud SQL for use with App Engine.

I know a lot of you are very interested in using Cloud SQL from Compute Engine. We're working hard on improving support but at the moment the only way to connect is using the external JDBC. 

See https://developers.google.com/cloud-sql/docs/external for more details.

Thanks for your patience

J

On Mon, Nov 26, 2012 at 3:11 PM, Douglas Finley <dafinley@gmail.com> wrote:

So we can only use Google Cloud SQL if we have an app running on App Engine??

So If I create an app on the Google Cloud Server, a Linux app running Apache and PHP, I would not be able to connect to the Google Cloud SQL??

On Friday, March 30, 2012 11:15:27 AM UTC-5, Joe Faith wrote:

We recently invited a number of users to join the limited preview who expressed an interest in using it with PHP. We did so because other users have reported success in using Quercus (a Java implementation of PHP) with AppEngine, such as this:

http://pressengine.appspot.com/2012/03/pressengine-wordpress-on-appengine/

J

On Fri, Mar 30, 2012 at 8:22 AM, Reinaldo Aguiar <rein...@reinaldo.ca> wrote:

Probably never. Also please note that cloud-sql is language neutral, it is SQL, it doesn't support any programming languages at all.

The programming platform to use (in connection with) CloudSQL is AppEngine, which only supports: Python, Java and Go (experimental).

On Fri, Mar 30, 2012 at 8:02 AM, Alican <alial...@gmail.com> wrote:

When will php support enable?

--
Joe Faith | Product Manager | Google Cloud

--
Joe Faith | Product Manager | Google Cloud

Re: connector for go

FYI, I have created a feature request in the App Engine issue tracker:

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

Please star it if you would like some traction on this.

Cheers,

Nick

On Thursday, 22 November 2012 03:09:56 UTC+11, Shilendra wrote:

Hi, All

No any update for the Go in App Engine  Its More differ from Java & Python and it may be future

Thanks,
Shilendra

On Wed, Nov 21, 2012 at 8:56 PM, Joe Faith <joef...@google.com> wrote:

Sorry, we don't have plans to support it in the near term.

Joe Faith | Google Cloud Product Manager
Sent from my phone, so please excuse my brevity.

On Nov 21, 2012 6:55 AM, "Nickolas Daskalou" <ni...@daskalou.com> wrote:

Any news on support for Go in App Engine?

Nick

On Tuesday, 23 October 2012 08:58:10 UTC+11, Matthias Koch wrote:

Hi,

is there also a driver for Go Lang available, or is it at least planed to have some in the near future ?

thanks

kr

Re: php support

Hi Douglas

At the moment we have focussed on optimizing Cloud SQL for use with App Engine.

I know a lot of you are very interested in using Cloud SQL from Compute Engine. We're working hard on improving support but at the moment the only way to connect is using the external JDBC. 

See https://developers.google.com/cloud-sql/docs/external for more details.

Thanks for your patience

J

On Mon, Nov 26, 2012 at 3:11 PM, Douglas Finley <dafinley@gmail.com> wrote:

So we can only use Google Cloud SQL if we have an app running on App Engine??

So If I create an app on the Google Cloud Server, a Linux app running Apache and PHP, I would not be able to connect to the Google Cloud SQL??

On Friday, March 30, 2012 11:15:27 AM UTC-5, Joe Faith wrote:

We recently invited a number of users to join the limited preview who expressed an interest in using it with PHP. We did so because other users have reported success in using Quercus (a Java implementation of PHP) with AppEngine, such as this:

http://pressengine.appspot.com/2012/03/pressengine-wordpress-on-appengine/

J

On Fri, Mar 30, 2012 at 8:22 AM, Reinaldo Aguiar <rein...@reinaldo.ca> wrote:

Probably never. Also please note that cloud-sql is language neutral, it is SQL, it doesn't support any programming languages at all.

The programming platform to use (in connection with) CloudSQL is AppEngine, which only supports: Python, Java and Go (experimental).

On Fri, Mar 30, 2012 at 8:02 AM, Alican <alial...@gmail.com> wrote:

When will php support enable?

--
Joe Faith | Product Manager | Google Cloud

--
Joe Faith | Product Manager | Google Cloud

Re: php support

So we can only use Google Cloud SQL if we have an app running on App Engine??

So If I create an app on the Google Cloud Server, a Linux app running Apache and PHP, I would not be able to connect to the Google Cloud SQL??

On Friday, March 30, 2012 11:15:27 AM UTC-5, Joe Faith wrote:

We recently invited a number of users to join the limited preview who expressed an interest in using it with PHP. We did so because other users have reported success in using Quercus (a Java implementation of PHP) with AppEngine, such as this:

http://pressengine.appspot.com/2012/03/pressengine-wordpress-on-appengine/

J

On Fri, Mar 30, 2012 at 8:22 AM, Reinaldo Aguiar <rein...@reinaldo.ca> wrote:

Probably never. Also please note that cloud-sql is language neutral, it is SQL, it doesn't support any programming languages at all.

The programming platform to use (in connection with) CloudSQL is AppEngine, which only supports: Python, Java and Go (experimental).

On Fri, Mar 30, 2012 at 8:02 AM, Alican <alial...@gmail.com> wrote:

When will php support enable?

--
Joe Faith | Product Manager | Google Cloud

Re: Failed to import gs://devsql/Dump20121123.sql: An unknown problem occurred (ERROR_RDBMS)

Your mysqldump file has invalid UTF8 char.

You most-likely need to use "hex-blob" option while taking the dump.

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

    mysqldump --databases database_name [-u username -p  password] --hex-blob database_name > database_file.sql

On Thu, Nov 22, 2012 at 10:25 PM, menacers <arif@cloudmail.ca> wrote:

cloudmail.ca:dejerosql:dev-async

Failed to import gs://devsql/Dump20121123.sql: An unknown problem occurred (ERROR_RDBMS)

i made sure i use USE "XXX" where XXX is database name in my import .sql file.

In the Log screen i can't seem to see the log details. Is there any ways for me to figure out why this database is not importing from my Google Cloud Storage?

my instance name is:

cloudmail.ca:dejerosql:dev-async

Thanks, any help someone could provide would be greatly appreciated.

Arif

Fail at MySQL Connector using GAE + GPE

I´ve sent this email yesterday to GAE discussion group but seems to be more appropriate to use Cloud SQL group. So, I´m copying it here. Any help is very welcome!!!

I´m working on a new system to be deployed on Google App Engine using Google Cloud SQL as database.

My environment is based on Eclipse JUNO (SR1) plus GPE latest available. Using MySQL 5.2 and mysql-connector-java-5.1.22-bin everything on Windows 7 (x64).

I´ve been trying test codes using GAE and GWT mainly based on vanilla GEP auto-generated sample. I may also consider use SmartGWT for fast UI development. At testing time it starts up, the web page gets loaded and I can interact with buttons, etc but the DataBase data never gets populated - it shows the animated fetching icon all the time. Looking at Eclipse console it looks like JDBC connector fails somewhere. Showing the error messages like (full file errors attached):

=== 2012-11-21 23:13:10,192 [01-0] ERROR IDACall - Top-level servlet error: 

java.lang.ExceptionInInitializerError

at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.<clinit>(MysqlDataSource.java:58)

....

....

Caused by: java.security.AccessControlException: access denied ("java.lang.RuntimePermission" "modifyThreadGroup")

at java.security.AccessControlContext.checkPermission(AccessControlContext.java:366)

Searching I found a post in one blog mentioning that there is a issue at java.security.AccessControlException and a potential fix would be like:

In your Java SDK directory you need to remove or modify these 

permission. Modify JDK1.7.0_05\jre\lib\security\java.security file as 

below: 

Change (remove the sun.,): 

FROM 

package.access=sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.imageio.,com.sun.org.apache.xerces.internal.utils.,com.sun.org.apache.xalan.internal.utils. 

TO 

package.access=com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.imageio.,com.sun.org.apache.xerces.internal.utils.,com.sun.org.apache.xalan.internal.utils. 

Change (not totally necessary but to avoid other problems): 

FROM 

package.definition=sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.imageio.,com.sun.org.apache.xerces.internal.utils.,com.sun.org.apache.xalan.internal.utils. 

to 

package.definition=com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.imageio.,com.sun.org.apache.xerces.internal.utils.,com.sun.org.apache.xalan.internal.utils. 

This may leave open other java programs sun.* calls to local access 

but for dev purposes this is the quickest solution without knowing 

specifically what the AppEngine Driver is doing locally and messing 

with app signing and policy files. 

s  

Is this workaround really needed, or I may be missing something else?

Appreciate by any hint on that since I´ve been fighting for about 2 weeks and not progressing.

thanks

Conejo

Re: connector for go

Hi, All

No any update for the Go in App Engine  Its More differ from Java & Python and it may be future

Thanks,
Shilendra

On Wed, Nov 21, 2012 at 8:56 PM, Joe Faith <joefaith@google.com> wrote:

Sorry, we don't have plans to support it in the near term.

Joe Faith | Google Cloud Product Manager
Sent from my phone, so please excuse my brevity.

On Nov 21, 2012 6:55 AM, "Nickolas Daskalou" <nick@daskalou.com> wrote:

Any news on support for Go in App Engine?

Nick

On Tuesday, 23 October 2012 08:58:10 UTC+11, Matthias Koch wrote:

Hi,

is there also a driver for Go Lang available, or is it at least planed to have some in the near future ?

thanks

kr

Re: connector for go

Sorry, we don't have plans to support it in the near term.

Joe Faith | Google Cloud Product Manager
Sent from my phone, so please excuse my brevity.

On Nov 21, 2012 6:55 AM, "Nickolas Daskalou" <nick@daskalou.com> wrote:

Any news on support for Go in App Engine?

Nick

On Tuesday, 23 October 2012 08:58:10 UTC+11, Matthias Koch wrote:

Hi,

is there also a driver for Go Lang available, or is it at least planed to have some in the near future ?

thanks

kr

Re: connector for go

Any news on support for Go in App Engine?

Nick

On Tuesday, 23 October 2012 08:58:10 UTC+11, Matthias Koch wrote:

Hi,

is there also a driver for Go Lang available, or is it at least planed to have some in the near future ?

thanks

kr

Re: java.sql.SQLException: Table 'myschema.EVENT doesn't exist

I was able to resolve the issue by adding the @Table annotation on the entity and specifying the name attribute of the entity class in all lower case. It was also necessary for me to issue and ALTER TABLE command in the SQL Console to specify the AUTO_INCREMENT option on the id columns of my entities.

HTH someone else.

-Tony

On Friday, November 16, 2012 10:46:41 PM UTC-6, Tony Piazza wrote:

So I am trying to test my new app locally using GPE with JPA configured to use my Cloud SQL instance.When I try running it I get the following exception:

[EL Info]: 2012-11-16 22:33:53.613--ServerSession(1682847419)--EclipseLink, version: Eclipse Persistence Services - 2.4.1.v20121003-ad44345
[EL Info]: connection: 2012-11-16 22:33:55.609--ServerSession(1682847419)--file:/C:/workspace/MyWebApp/war/WEB-INF/classes/_User1 login successful
[EL Warning]: 2012-11-16 22:33:56.668--UnitOfWork(1692389875)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table 'myschema.EVENT' doesn't exist
Error Code: 1146
Call: SELECT MAX(EVENTDATE) FROM EVENT
Query: ReportQuery(referenceClass=Event sql="SELECT MAX(EVENTDATE) FROM EVENT")

I can execute the same query using the Google APIs Console. I can also see the schema and table using the Data Source Explorer in Eclipse so I know they exist.

Any ideas as to what is wrong?

Thanks in advance for your help.

-Tony

Re: How to add and manage local MySQL users

The connections are coming from localhost and '%' doesn't match the localhost. If you replace '%' with 'localhost' things should start working as you would expect.

More details: the mysql users are independent from the apis/console teammates so they don't (and password certainly shouldn't) have to be the same. So there are two layers of projectes: the teammates is the first one and the mysql user/password is the second one. By default the mysql one is disabled (root doesn't have any password and when you use the google_sql.sh the root user is the default one).

All the best!

Razvan ME

On Tue, Nov 20, 2012 at 12:28 PM, Monocle <rlancione@aldogroup.com> wrote:

I'm using SQuirrel to connect to my Google Cloud SQL instance and I created a couple users and gave them the necessary grants to use a testdb database that I created.

The problem I'm facing is that I can only connect to the Google Cloud SQL instance if I leave the username and password fields blank in the SQuirrel SQL Client (root).   Whenever I try logging in using the new user I created, I get an error stating "Unexpected Error occurred attempting to open an SQL connection."

Here is how I added the user, once connected to my Cloud SQL instance.

CREATE USER 'rob'@'%' IDENTIFIED BY 'mypass';

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON testdb.* TO 'rob'@'%';

There is mention in the docs that I need to add the users as teammates to my project first (which I did), but I understand why this is really necessary.  Does the MySQL user and the project team member username (email address) need to be the same?  If so, this wouldn't make a lot of sense due to the 16 character username limitation for MySQL user names.

Any clarification would be appreciated.

Rob.

How to add and manage local MySQL users

I'm using SQuirrel to connect to my Google Cloud SQL instance and I created a couple users and gave them the necessary grants to use a testdb database that I created.

The problem I'm facing is that I can only connect to the Google Cloud SQL instance if I leave the username and password fields blank in the SQuirrel SQL Client (root).   Whenever I try logging in using the new user I created, I get an error stating "Unexpected Error occurred attempting to open an SQL connection."

Here is how I added the user, once connected to my Cloud SQL instance.

CREATE USER 'rob'@'%' IDENTIFIED BY 'mypass';

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON testdb.* TO 'rob'@'%';

There is mention in the docs that I need to add the users as teammates to my project first (which I did), but I understand why this is really necessary.  Does the MySQL user and the project team member username (email address) need to be the same?  If so, this wouldn't make a lot of sense due to the 16 character username limitation for MySQL user names.

Any clarification would be appreciated.

Rob.

Create a bucket with GSUtil causing problems

Mac OSX 10.8.2

Following https://developers.google.com/cloud-sql/docs/import_export#importing - 

Importing and Exporting Data.

Step 3 of Upload your existing MySQL database to Google Cloud Storage: is causing following error:-

Thomas-Duffys-MacBook-Air:tom tom$ gsutil mb gs://bucket_tom

Creating gs://bucket_tom/...

GSResponseError: status=400, code=MissingSecurityHeader, reason=Bad Request, detail=Authorization.

Thomas-Duffys-MacBook-Air:tom tom$ 

Any help would be appreciated.

Re: What are the points for using SQL over NoSql

Also see the FAQ: https://developers.google.com/cloud-sql/faq#choice

j

On Tue, Nov 20, 2012 at 8:06 AM, Tony Tseng <ttt@google.com> wrote:

Hi,

For your SQL vs NoSQL question, this video from Google I/O should be helpful: http://www.youtube.com/watch?v=rRoy6I4gKWU

On Tue, Nov 20, 2012 at 2:15 AM, Shahid Latif <shahidlatif2005@gmail.com> wrote:

Hi,

I have read on google site that Google Cloud storage is useful for small to medium application. What they called small application? I wan to decide which one I used for my application SQL or NoSQL

--
Joe Faith | Product Manager | Google Cloud

Re: What are the points for using SQL over NoSql

Hi,

For your SQL vs NoSQL question, this video from Google I/O should be helpful: http://www.youtube.com/watch?v=rRoy6I4gKWU

On Tue, Nov 20, 2012 at 2:15 AM, Shahid Latif <shahidlatif2005@gmail.com> wrote:

Hi,

I have read on google site that Google Cloud storage is useful for small to medium application. What they called small application? I wan to decide which one I used for my application SQL or NoSQL

What are the points for using SQL over NoSql

Hi,

I have read on google site that Google Cloud storage is useful for small to medium application. What they called small application? I wan to decide which one I used for my application SQL or NoSQL

java.sql.SQLException: This Connection is closed.

Hi,

i'm using GAE with Google Cloud SQL and i am creating a new db connection for each HTTP Request.  Sometimes, I receive an SQLException with "This connection is closed" even though the connection is newly created.  Here are my logs :

D 2012-11-19 15:03:02.864

ca.satisfa.db.DbManager initConnection: Initializing DB connection to jdbc:google:rdbms://....

I 2012-11-19 15:03:02.864

ca.satisfa.db.DbManager getConnection: Existing DB connection is active. Using it.

W 2012-11-19 15:03:02.870

ca.satisfa.db.DbManager validateToken: A problem happended while executing method validateToken java.sql.SQLException: This Connection is closed.

The connection is closed 6 ms after being created.  I am testing each connection with the following :

if (connection == null || connection.isClosed() || !isValid(connection)) {

where isValid(connection) do a SELECT 1.

Any idea ? Is there any known issues with Google Cloud SQL connections ? 

Thanks

Re: Cant create new instance Google Cloud SQL

Thank you

вторник, 13 ноября 2012 г., 20:53:53 UTC+2 пользователь Joe Faith написал:

Hi Dmitriy

It looks like the problem is that you are trying to associate an App Engine application in the US with a Cloud SQL instance in the EU.

 Sorry that the error message is not clear -- we are fixing that.

J

On Tue, Nov 13, 2012 at 3:28 AM, Dmitriy Makeev <makeev.d...@gmail.com> wrote:

Error still
Project number: 442777118880

пятница, 9 ноября 2012 г., 19:21:45 UTC+2 пользователь Rob написал:

Account 442777118880 looks correct. Please try again.

Thanks,

Rob

On Friday, November 9, 2012 4:00:36 AM UTC-8, Dmitriy Makeev wrote:

I have same problem. 

Project number: 442777118880

пятница, 9 ноября 2012 г., 12:19:20 UTC+2 пользователь Manuel Alejandro Fernandez Casado написал:

Hi.

I have billing enabled and a project, but i can´t create a instance. The error says: 

An unexpected error has occurred. We're looking into it.

Project number: 790165179596

Regards.

--
Joe Faith | Product Manager | Google Cloud

Re: How to delete SQL instance if it was suspended?

Wow!  Razvan, you are so quick!  I am amazed!  Thanks a lot!
Have a great weekend!
Xiping

On Sat, Nov 17, 2012 at 7:00 AM, Razvan Musaloiu-E. <razvanm@google.com> wrote:

Done.

-- Razvan ME

On Sat, Nov 17, 2012 at 3:46 AM, xiping <xiping.long@gmail.com> wrote:

Hi Tony,
I have the same issue to delete my Google cloud SQL instances since the menu action menu item delete is disabled.
I think,  the menu item should not be disabled and a suspended instance should be deletable by its owner,
Ｃould you also help me to get my instances deleted also?  
My 3 instances are xipinglong:china-itv, xipinglong:umessage, and xipinglong:chemicalexchange.
Thanks.
Xiping

On Friday, July 13, 2012 11:16:41 AM UTC-4, Erwin Feser wrote:

Thanks! the instance is "octopus-stx:green". Will google modify that in order to a user can delete a suspended instance?

Regards!

On Friday, July 13, 2012 11:34:20 AM UTC-3, Tony Tseng wrote:

An instance can't be deleted if it's suspended. If you really need to turn off your cloud sql service and delete your instance, please tell me your instance name. (feel free to respond off list)

On Fri, Jul 13, 2012 at 5:07 AM, Erwin Feser <erwin...@gmail.com> wrote:

I want to turn off my SQL service, but it ask for me to delete the SQL instance. How to delete it if it is suspended?

Re: How to delete SQL instance if it was suspended?

Done.

-- Razvan ME

On Sat, Nov 17, 2012 at 3:46 AM, xiping <xiping.long@gmail.com> wrote:

Hi Tony,
I have the same issue to delete my Google cloud SQL instances since the menu action menu item delete is disabled.
I think,  the menu item should not be disabled and a suspended instance should be deletable by its owner,
Ｃould you also help me to get my instances deleted also?  
My 3 instances are xipinglong:china-itv, xipinglong:umessage, and xipinglong:chemicalexchange.
Thanks.
Xiping

On Friday, July 13, 2012 11:16:41 AM UTC-4, Erwin Feser wrote:

Thanks! the instance is "octopus-stx:green". Will google modify that in order to a user can delete a suspended instance?

Regards!

On Friday, July 13, 2012 11:34:20 AM UTC-3, Tony Tseng wrote:

An instance can't be deleted if it's suspended. If you really need to turn off your cloud sql service and delete your instance, please tell me your instance name. (feel free to respond off list)

On Fri, Jul 13, 2012 at 5:07 AM, Erwin Feser <erwin...@gmail.com> wrote:

I want to turn off my SQL service, but it ask for me to delete the SQL instance. How to delete it if it is suspended?

Re: How to delete SQL instance if it was suspended?

Hi Tony,
I have the same issue to delete my Google cloud SQL instances since the menu action menu item delete is disabled.
I think,  the menu item should not be disabled and a suspended instance should be deletable by its owner,
Ｃould you also help me to get my instances deleted also?  
My 3 instances are xipinglong:china-itv, xipinglong:umessage, and xipinglong:chemicalexchange.
Thanks.
Xiping


On Friday, July 13, 2012 11:16:41 AM UTC-4, Erwin Feser wrote:

Thanks! the instance is "octopus-stx:green". Will google modify that in order to a user can delete a suspended instance?

Regards!

On Friday, July 13, 2012 11:34:20 AM UTC-3, Tony Tseng wrote:

An instance can't be deleted if it's suspended. If you really need to turn off your cloud sql service and delete your instance, please tell me your instance name. (feel free to respond off list)

On Fri, Jul 13, 2012 at 5:07 AM, Erwin Feser <erwin...@gmail.com> wrote:

I want to turn off my SQL service, but it ask for me to delete the SQL instance. How to delete it if it is suspended?

Re: Google Apps Script JDBC Service and Google Cloud SQL

+Joe,
               Thnks a lot, we ll look into it!!

--Bb

On Thursday, November 15, 2012 11:14:32 PM UTC+5:30, Joe Faith wrote:

Hi Sarathbabou

The Apps Script Range class includes a getValues() method for getting the values out of a spreadsheet. See

https://developers.google.com/apps-script/class_range#getValues

For example, this will get the values for the range A1:B10 in the active spreadsheet. 

var values = SpreadsheetApp.getActiveSheet().getRange(0, 0, 10, 1).getValues();

You can then create a connection to a Cloud SQL database and insert the values. See https://developers.google.com/apps-script/jdbc

var conn = Jdbc.getCloudSqlConnection("jdbc:google:rdbms://instance_name/database_name");

conn.setAutoCommit(false);

var stmt = conn.prepareStatement("insert into person (lname,fname) values (?,?)");

for (var i = 0; i < 10; i++) {

    // Objects are accessed using 1-based indexing

    stmt.setObject(1, var[i][0]);

    stmt.setObject(2, var[i][1]);

    stmt.addBatch();

}

var res = stmt.executeBatch();

conn.commit();

conn.close();

On Thu, Nov 15, 2012 at 9:22 AM, SS <sarathbab...@ssomens.com> wrote:

Sorry Joe,
                       Bt then using JDBC, how will u import the Data directly into GC SQL from the Spreadsheet Data?
Sorry I m a bit lost!

Hw to get the values from the SpreadSheet using JDBC?
I want all my Spreadsheet data to be migrated to GC SQL?

Thnks fr ur help!

--Som

On Saturday, November 10, 2012 10:53:23 PM UTC+8, Joe Faith wrote:

Hi Son

You could use an Apps Script to gather the data from your spreadsheet then use the new JDBC to insert the values into your Cloud SQL database.

Joe Faith | Google Cloud Product Manager
Sent from my phone, so please excuse my brevity.

On Nov 10, 2012 2:05 AM, "SS" <sarathbab...@ssomens.com> wrote:

Hi Joe,
           Any direct tool/method/function to import DATA from ScriptDB/Spreadsheet into Google Cloud SQL?

If so, plz refer me to the lnk!

1000 Thnks,
Som

On Saturday, November 10, 2012 12:54:41 AM UTC+8, Joe Faith wrote:

I'm very pleased to say that Apps Script now has a JDBC to Cloud SQL

https://developers.google.com/apps-script/jdbc

Hope you can make good use of it, and let us know how you get on.

j

On Thu, Nov 1, 2012 at 12:12 AM, DaBe <rup...@kromco.co.za> wrote:

For what it's worth. Agreed, we need the direct CLoudSQL connectivity from Google Spreadsheet Query and Apps Script.

--
Joe Faith | Product Manager | Google Cloud

--
Joe Faith | Product Manager | Google Cloud

java.sql.SQLException: Table 'myschema.EVENT doesn't exist

So I am trying to test my new app locally using GPE with JPA configured to use my Cloud SQL instance.When I try running it I get the following exception:

[EL Info]: 2012-11-16 22:33:53.613--ServerSession(1682847419)--EclipseLink, version: Eclipse Persistence Services - 2.4.1.v20121003-ad44345
[EL Info]: connection: 2012-11-16 22:33:55.609--ServerSession(1682847419)--file:/C:/workspace/MyWebApp/war/WEB-INF/classes/_User1 login successful
[EL Warning]: 2012-11-16 22:33:56.668--UnitOfWork(1692389875)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table 'myschema.EVENT' doesn't exist
Error Code: 1146
Call: SELECT MAX(EVENTDATE) FROM EVENT
Query: ReportQuery(referenceClass=Event sql="SELECT MAX(EVENTDATE) FROM EVENT")

I can execute the same query using the Google APIs Console. I can also see the schema and table using the Data Source Explorer in Eclipse so I know they exist.

Any ideas as to what is wrong?

Thanks in advance for your help.

-Tony

Re: Google Apps Script JDBC Service and Google Cloud SQL

This summary is not available. Please click here to view the post.

Re: Google Apps Script JDBC Service and Google Cloud SQL

Sorry, I didn't realize you were talking about allowing access by other users from Apps Script.

Unfortunately the only way to allow them access at the moment is to give them access to the project. See:

https://developers.google.com/cloud-sql/docs/access_control#individuals

We understand its not an ideal solution and are looking at alternatives

J

On Fri, Nov 16, 2012 at 8:55 AM, Jacob van den Berg <jacobvdb@lagaroo.com.br> wrote:

+Joe 

The link you send, that informantion would also account for the jdbc connection from a G Apps Script?

As in the documentation it is written :

"Scripts that execute as the active user will not be able to connect to the database unless the end users are also members of the project. That may not always be possible or desirable, especially for consumer-facing web apps, and we are working on alternative solutions."

Thanks for your attention! 

Jacob 

On Friday, November 18, 2011 3:20:24 PM UTC-2, Laurent Rousset wrote:

Hi,

First of all : Google Cloud SQL is great !

While Google Cloud SQL is a MySQL implementation, is it possible to access an instance of a domain "xxxxx.com" from a Google Apps Script hosted by a SpreadSheet in the same domain ? Using the Google Apps Script JDBC Service.

I tried but it seems not working.

Any help ? It would be a great feature to build richer Google Apps Script application.

Regards

Laurent

--
Joe Faith | Product Manager | Google Cloud

Re: Google Apps Script JDBC Service and Google Cloud SQL

+Joe 

The link you send, that informantion would also account for the jdbc connection from a G Apps Script?

As in the documentation it is written :

"Scripts that execute as the active user will not be able to connect to the database unless the end users are also members of the project. That may not always be possible or desirable, especially for consumer-facing web apps, and we are working on alternative solutions."

Thanks for your attention! 

Jacob 

On Friday, November 18, 2011 3:20:24 PM UTC-2, Laurent Rousset wrote:

Hi,

First of all : Google Cloud SQL is great !

While Google Cloud SQL is a MySQL implementation, is it possible to access an instance of a domain "xxxxx.com" from a Google Apps Script hosted by a SpreadSheet in the same domain ? Using the Google Apps Script JDBC Service.

I tried but it seems not working.

Any help ? It would be a great feature to build richer Google Apps Script application.

Regards

Laurent

Re: Google Apps Script JDBC Service and Google Cloud SQL

This summary is not available. Please click here to view the post.

Re: Google Apps Script JDBC Service and Google Cloud SQL

Any tip/idea for a work around to make GC SQL available for people outside of the project?

Em sexta-feira, 18 de novembro de 2011 15h20min24s UTC-2, Laurent Rousset escreveu:

Hi,

First of all : Google Cloud SQL is great !

While Google Cloud SQL is a MySQL implementation, is it possible to access an instance of a domain "xxxxx.com" from a Google Apps Script hosted by a SpreadSheet in the same domain ? Using the Google Apps Script JDBC Service.

I tried but it seems not working.

Any help ? It would be a great feature to build richer Google Apps Script application.

Regards

Laurent

Re: Master/Slaveでは正常動作の処理がHRDでは動作しない

Thank you for your kind reply.

Both applications are exactly same and on the same code base,

as I deployed same project only rewriting application and version tag of    

appengine-web.xml. And so surely talk to the same Cloud SQL instance.

1. I deployed more simple project, means with no related sub-screens, but

  result is same.

(1)　Master/Slave

http://erp2-ondev.swsgaejpgm3.appspot.com/addOrdCal.htm

(2)　HRD

http://1.bizcloudsql.appspot.com/addOrdCal.htm

2. HRD outputs warning and critical logs as below even master/slave outputs no such logs.

   

[W] /ordersvlt java.lang.NullPointerException at com.business.orderBean.getCustInfo(orderBean.java:58) at com.business.orderSvlt.doGet(orderSvlt.java:24

[C] Uncaught exception from servlet java.lang.NullPointerException at com.business.orderBean.getCustInfo(orderBean.java:58) at com.business.orderSvlt.do

 
I want to transfer from Master/Slave to HRD but this problem inhibits.

Regards. 

Katsuyuki Seino.

On Fri, Nov 16, 2012 at 9:51 AM, Tony Tseng <ttt@google.com> wrote:

Hi,

There's no functional difference between master/slave and hrd applications as far as Cloud SQL is concerned. Actually master/slave application association is deprecated; you won't be able to associate a Cloud SQL instance with a master/slave application anymore. I don't know why your applications would return different data. Are you sure they are talking to the same Cloud SQL instance and both applications are on the same code base?

2012/11/15 katsuyuki seino <superelmer21@gmail.com>

Sorry I rewrote as below.

My name is Katsuyuki seino.
On my sample using Cloud SQL ,I got problem as below.

The Cloud SQL application which execute without problem on Master/Slave has problem
on HRD environment.

(1)　Master/Slave

http://erp2-ondev.swsgaejpgm3.appspot.com/addOrdDtl.htm

(2)　HRD

http://1.bizcloudsql.appspot.com/addOrdDtl.htm

Above (1) and (2) are same application using Cloud SQL.
(1) If you enter 'c0001' on top field right side of [顧客ID](Customer ID), other fields (TEL..) will show customer info.
(2) Same application with (1)  only differ High Replication is selected, do not show customer info   
on same operation (enter 'c0001' on top field)

My understanding is Cloud SQL don't care about Master/Slave or HRD but result is like above.
Are there any recommendation to use Master/Slave when access Cloud SQL.

Regards.

2012/11/15 Văn Trường Phạm <invncur@gmail.com>

I can't understand you. Do you can write with english or vietnamese?
Vào Thứ năm, ngày 15 tháng mười một năm 2012, katsuyuki seino đã viết:

お世話になります、清野　克行といいます。

My Applicationsの１つをHRDにして

それまで、Master/Slaveで動作していた　CloudSQLをアクセスするProjectを

AppEngine にディプロイしたところ、正常動作しないようになっています。

(1)　Master/Slave

http://erp2-ondev.swsgaejpgm3.appspot.com/addOrdDtl.htm

(2)　HRD

http://1.bizcloudsql.appspot.com/addOrdDtl.htm

上記同一サンプルで　「顧客ID」に　「c0001」 を入力すれば、TEL以下の顧客情報

が(1)では表示されるが（２）では表示されません。
Cloud SQLを使用する場合、HRDを選択したApplicationではなにか制限があるのでしょうか。

あるいはCloud SQLの場合はMaster/Slaveを選択すべきでしょうか。
どちらにしてもDetastoreは使用していなので、HRDとMaster/Slave自身は関係ないと思いますが。

お返事、よろしくお願いします。

　

Re: Master/Slaveでは正常動作の処理がHRDでは動作しない

Hi,

There's no functional difference between master/slave and hrd applications as far as Cloud SQL is concerned. Actually master/slave application association is deprecated; you won't be able to associate a Cloud SQL instance with a master/slave application anymore. I don't know why your applications would return different data. Are you sure they are talking to the same Cloud SQL instance and both applications are on the same code base?

2012/11/15 katsuyuki seino <superelmer21@gmail.com>

Sorry I rewrote as below.

My name is Katsuyuki seino.
On my sample using Cloud SQL ,I got problem as below.

The Cloud SQL application which execute without problem on Master/Slave has problem
on HRD environment.

(1)　Master/Slave

http://erp2-ondev.swsgaejpgm3.appspot.com/addOrdDtl.htm

(2)　HRD

http://1.bizcloudsql.appspot.com/addOrdDtl.htm

Above (1) and (2) are same application using Cloud SQL.
(1) If you enter 'c0001' on top field right side of [顧客ID](Customer ID), other fields (TEL..) will show customer info.
(2) Same application with (1)  only differ High Replication is selected, do not show customer info   
on same operation (enter 'c0001' on top field)

My understanding is Cloud SQL don't care about Master/Slave or HRD but result is like above.
Are there any recommendation to use Master/Slave when access Cloud SQL.

Regards.

2012/11/15 Văn Trường Phạm <invncur@gmail.com>

I can't understand you. Do you can write with english or vietnamese?
Vào Thứ năm, ngày 15 tháng mười một năm 2012, katsuyuki seino đã viết:

お世話になります、清野　克行といいます。

My Applicationsの１つをHRDにして

それまで、Master/Slaveで動作していた　CloudSQLをアクセスするProjectを

AppEngine にディプロイしたところ、正常動作しないようになっています。

(1)　Master/Slave

http://erp2-ondev.swsgaejpgm3.appspot.com/addOrdDtl.htm

(2)　HRD

http://1.bizcloudsql.appspot.com/addOrdDtl.htm

上記同一サンプルで　「顧客ID」に　「c0001」 を入力すれば、TEL以下の顧客情報

が(1)では表示されるが（２）では表示されません。
Cloud SQLを使用する場合、HRDを選択したApplicationではなにか制限があるのでしょうか。

あるいはCloud SQLの場合はMaster/Slaveを選択すべきでしょうか。
どちらにしてもDetastoreは使用していなので、HRDとMaster/Slave自身は関係ないと思いますが。

お返事、よろしくお願いします。

　

Re: Google Apps Script JDBC Service and Google Cloud SQL

Hi Sarathbabou

The Apps Script Range class includes a getValues() method for getting the values out of a spreadsheet. See

https://developers.google.com/apps-script/class_range#getValues

For example, this will get the values for the range A1:B10 in the active spreadsheet. 

var values = SpreadsheetApp.getActiveSheet().getRange(0, 0, 10, 1).getValues();

You can then create a connection to a Cloud SQL database and insert the values. See https://developers.google.com/apps-script/jdbc

var conn = Jdbc.getCloudSqlConnection("jdbc:google:rdbms://instance_name/database_name");

conn.setAutoCommit(false);

var stmt = conn.prepareStatement("insert into person (lname,fname) values (?,?)");

for (var i = 0; i < 10; i++) {

    // Objects are accessed using 1-based indexing

    stmt.setObject(1, var[i][0]);

    stmt.setObject(2, var[i][1]);

    stmt.addBatch();

}

var res = stmt.executeBatch();

conn.commit();

conn.close();

On Thu, Nov 15, 2012 at 9:22 AM, SS <sarathbabou.somaya@ssomens.com> wrote:

Sorry Joe,
                       Bt then using JDBC, how will u import the Data directly into GC SQL from the Spreadsheet Data?
Sorry I m a bit lost!

Hw to get the values from the SpreadSheet using JDBC?
I want all my Spreadsheet data to be migrated to GC SQL?

Thnks fr ur help!

--Som

On Saturday, November 10, 2012 10:53:23 PM UTC+8, Joe Faith wrote:

Hi Son

You could use an Apps Script to gather the data from your spreadsheet then use the new JDBC to insert the values into your Cloud SQL database.

Joe Faith | Google Cloud Product Manager
Sent from my phone, so please excuse my brevity.

On Nov 10, 2012 2:05 AM, "SS" <sarathbab...@ssomens.com> wrote:

Hi Joe,
           Any direct tool/method/function to import DATA from ScriptDB/Spreadsheet into Google Cloud SQL?

If so, plz refer me to the lnk!

1000 Thnks,
Som

On Saturday, November 10, 2012 12:54:41 AM UTC+8, Joe Faith wrote:

I'm very pleased to say that Apps Script now has a JDBC to Cloud SQL

https://developers.google.com/apps-script/jdbc

Hope you can make good use of it, and let us know how you get on.

j

On Thu, Nov 1, 2012 at 12:12 AM, DaBe <rup...@kromco.co.za> wrote:

For what it's worth. Agreed, we need the direct CLoudSQL connectivity from Google Spreadsheet Query and Apps Script.

--
Joe Faith | Product Manager | Google Cloud

--
Joe Faith | Product Manager | Google Cloud

Re: Google Apps Script JDBC Service and Google Cloud SQL

Sorry Joe,
                       Bt then using JDBC, how will u import the Data directly into GC SQL from the Spreadsheet Data?
Sorry I m a bit lost!

Hw to get the values from the SpreadSheet using JDBC?
I want all my Spreadsheet data to be migrated to GC SQL?

Thnks fr ur help!

--Som

On Saturday, November 10, 2012 10:53:23 PM UTC+8, Joe Faith wrote:

Hi Son

You could use an Apps Script to gather the data from your spreadsheet then use the new JDBC to insert the values into your Cloud SQL database.

Joe Faith | Google Cloud Product Manager
Sent from my phone, so please excuse my brevity.

On Nov 10, 2012 2:05 AM, "SS" <sarathbab...@ssomens.com> wrote:

Hi Joe,
           Any direct tool/method/function to import DATA from ScriptDB/Spreadsheet into Google Cloud SQL?

If so, plz refer me to the lnk!

1000 Thnks,
Som

On Saturday, November 10, 2012 12:54:41 AM UTC+8, Joe Faith wrote:

I'm very pleased to say that Apps Script now has a JDBC to Cloud SQL

https://developers.google.com/apps-script/jdbc

Hope you can make good use of it, and let us know how you get on.

j

On Thu, Nov 1, 2012 at 12:12 AM, DaBe <rup...@kromco.co.za> wrote:

For what it's worth. Agreed, we need the direct CLoudSQL connectivity from Google Spreadsheet Query and Apps Script.

--
Joe Faith | Product Manager | Google Cloud