Dear Cloud SQL users,As of July 30, we are removing the SUPER privilege for Cloud SQL users which gives accounts the ability to kill threads belonging to other accounts and to make various configuration changes. More information is available in the MySQL documentation.We are doing this because Cloud SQL is a managed service and this is a little used feature, and removing it will also enable us to offer additional features that will make the Cloud SQL service more powerful and easier to use. However, some users might be using MySQL features that require SUPER privilege. If that is the case we would like to hear from you, so that we can find workarounds or other solutions.Thanks,Joe FaithGoogle Cloud SQL Team
--
Joe Faith | Product Manager | Google Cloud
Hi.
I'm receiving the following error when attempting to create a new instance: "you cannot create new instances because billing is disabled".--
I can confirm billing is enabled.
Project number: 567491558978
I have created an online PHP code executor at http://web.guru99.com
Though I have checked all security aspects … do you experts see any major flaw that I need to care of?
--
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/c70585fb-ff2b-45cd-9b68-a018d4a3f3ee%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
how to connect my db2 database to google app engine.for doing these i have to set my pc as server?--
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/61fda14d-dc1e-480a-876a-6747599a0dc8%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Still no success =( I get the same error.Could not connect to Profile ([APPNAME]-AppEngine.GoogleCloudSQL.DevInstance).Error creating SQL Model Connection connection to Profile ([APPNAME]-AppEngine.GoogleCloudSQL.DevInstance). (Error: null)java.lang.NullPointerExceptionOKCheers
On Friday, 26 July 2013 21:38:35 UTC+10, Vladimir Ralev wrote:Try to connect from the google sql command line tool once from the same user that starts the eclipse process. There are some tokens that need to be deployed in the user config directory. The command line tool does it automatically for you. I never had success doing this step manually even though in theory it is possible. All of this is assuming you are using the correct jdbc driver for google and not mysql.
On Jul 26, 2013 1:28 PM, "Ben Evans" <benny.j...@gmail.com> wrote:Hi all,I'm currently trying to get cloud sql working with with an app engine app however I keep receiving the following with the eclipse plugin:Could not connect to Profile ([APPNAME]-AppEngine.GoogleCloudSQL.DevInstance).Error creating SQL Model Connection connection to Profile ([APPNAME]-AppEngine.GoogleCloudSQL.DevInstance). (Error: null)java.lang.NullPointerExceptionOKI am logged into eclipse, I have billing enabled and the db instance is running. I'm using root as the username and not entering anything as the pass. I'm pretty sure the dbname and instance names are correct as changing them provides additional errors stating the instance cannot be found or the db does not exist.Any help on solving this error would be much appreciated.Cheers--
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/f82c2d9f-efe8-468c-b1ea-87c214edc2ed%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ed58524d-dd61-4fb8-8e36-b1ff2abb58b0%40googlegroups.com.
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.
I have created an online PHP code executor at http://web.guru99.com
Though I have checked all security aspects … do you experts see any major flaw that I need to care of?Try to connect from the google sql command line tool once from the same user that starts the eclipse process. There are some tokens that need to be deployed in the user config directory. The command line tool does it automatically for you. I never had success doing this step manually even though in theory it is possible. All of this is assuming you are using the correct jdbc driver for google and not mysql.
On Jul 26, 2013 1:28 PM, "Ben Evans" <benny.j...@gmail.com> wrote:Hi all,I'm currently trying to get cloud sql working with with an app engine app however I keep receiving the following with the eclipse plugin:Could not connect to Profile ([APPNAME]-AppEngine.GoogleCloudSQL.DevInstance). Error creating SQL Model Connection connection to Profile ([APPNAME]-AppEngine.GoogleCloudSQL.DevInstance). (Error: null) java.lang.NullPointerExceptionOKI am logged into eclipse, I have billing enabled and the db instance is running. I'm using root as the username and not entering anything as the pass. I'm pretty sure the dbname and instance names are correct as changing them provides additional errors stating the instance cannot be found or the db does not exist.Any help on solving this error would be much appreciated.Cheers--
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/f82c2d9f-efe8-468c- b1ea-87c214edc2ed% 40googlegroups.com
For more options, visit https://groups.google.com/groups/opt_out .
Try to connect from the google sql command line tool once from the same user that starts the eclipse process. There are some tokens that need to be deployed in the user config directory. The command line tool does it automatically for you. I never had success doing this step manually even though in theory it is possible. All of this is assuming you are using the correct jdbc driver for google and not mysql.
Hi all,I'm currently trying to get cloud sql working with with an app engine app however I keep receiving the following with the eclipse plugin:Could not connect to Profile ([APPNAME]-AppEngine.GoogleCloudSQL.DevInstance).Error creating SQL Model Connection connection to Profile ([APPNAME]-AppEngine.GoogleCloudSQL.DevInstance). (Error: null)java.lang.NullPointerExceptionOKI am logged into eclipse, I have billing enabled and the db instance is running. I'm using root as the username and not entering anything as the pass. I'm pretty sure the dbname and instance names are correct as changing them provides additional errors stating the instance cannot be found or the db does not exist.Any help on solving this error would be much appreciated.Cheers--
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/f82c2d9f-efe8-468c-b1ea-87c214edc2ed%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Hello,I have a MySql database whose tables weigh in at 40GB, and when I run the command "top -c" it shows that mysql is using 14GB of RAM.In order to migrate this database to cloud SQL, do I have to maintain the same amount of ram? Or does the way that cloud SQL manage indexes and memory mean that I can choose a server is less RAM? Are there tools that will allow me to know if performance is suffering due to lack of RAM?Thanks for your feedbackRegards,Marcelo--
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.
For more options, visit https://groups.google.com/groups/opt_out.
I am deploying a Django backend technology in a Google Compute Engine instance. As of now, i have MySQL server installed locally in that instance and I now wish to use the Google Cloud SQL as my backend instead. I am aware of;
The connection used if its in an App Engine
DATABASES = { 'default': { 'ENGINE': 'google.appengine.ext.django.backends.rdbms', 'INSTANCE': 'my_project:instance1', 'NAME': 'my_database', } }I would like to know if its possible to do something similar in Google Compute Engine?
I've read about the connection to external application here; https://developers.google.com/cloud-sql/docs/external
But I have no clue how to use the connections to produce something similar. Any guidelines i can follow?
--
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/2954e521-9bc1-4aba-a58b-24dae0e3135f%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
I am deploying a Django backend technology in a Google Compute Engine instance. As of now, i have MySQL server installed locally in that instance and I now wish to use the Google Cloud SQL as my backend instead. I am aware of;
The connection used if its in an App Engine
DATABASES = { 'default': { 'ENGINE': 'google.appengine.ext.django.backends.rdbms', 'INSTANCE': 'my_project:instance1', 'NAME': 'my_database', } }I would like to know if its possible to do something similar in Google Compute Engine?
I've read about the connection to external application here; https://developers.google.com/cloud-sql/docs/external
But I have no clue how to use the connections to produce something similar. Any guidelines i can follow?
----I am not able to obtain the OAuth2 authorization needed to let Netbeans and other programs access my Cloud SQL database. I get a 400 back, and I can't find any tokens in the registry. I am able to grant the Google Cloud SDK access through gauth, but this does apparently not create an OAuth2 available in Netbeans. I have spent days going through the registry, trying with new cloud instances, changing setting and executing the google_sql_tool/google_sql command in all possible ways. What on earth could a do? I can't find any more information online. I have tried with the firewall off and such things but to no avail.
Are there any alternative ways to connect to Cloud SQL that I could try? I would be endlessly grateful!
I am not able to obtain the OAuth2 authorization needed to let Netbeans and other programs access my Cloud SQL database. I get a 400 back, and I can't find any tokens in the registry. I am able to grant the Google Cloud SDK access through gauth, but this does apparently not create an OAuth2 available in Netbeans. I have spent days going through the registry, trying with new cloud instances, changing setting and executing the google_sql_tool/google_sql command in all possible ways. What on earth could a do? I can't find any more information online. I have tried with the firewall off and such things but to no avail.
Are there any alternative ways to connect to Cloud SQL that I could try? I would be endlessly grateful!
--Until Googe App Engine version 1.7.6 we where using a Local MySQL Instance During Development;
https://developers.google.com/appengine/docs/java/cloud-sql/developers-guide?hl=nl
appengine-java-sdk/bin/dev_appserver.sh \ --jvm_flag=-Drdbms.server=local \ --jvm_flag=-Drdbms.driver=com.mysql.jdbc.Driver \ --jvm_flag=-Drdbms.url=jdbc:mysql://localhost:3306/yourdatabase?user=username"&"password=password--
But from Googe App Engine version 1.8.0 this is not working anymore because the Java Development
Server's JDBC driver doesn't find the local MySql driver...
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
What happened after version 1.7.6?
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/bf13c77c-96b7-4230-ac42-f90845679df2%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
appengine-java-sdk/bin/dev_appserver.sh \ --jvm_flag=-Drdbms.server=local \ --jvm_flag=-Drdbms.driver=com.mysql.jdbc.Driver \ --jvm_flag=-Drdbms.url=jdbc:mysql://localhost:3306/yourdatabase?user=username"&"password=password
--
But from Googe App Engine version 1.8.0 this is not working anymore because the Java Development
Server's JDBC driver doesn't find the local MySql driver...
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
What happened after version 1.7.6?
Hi Mikael,
After connecting with google_sql.sh (to get the auth token), I was able to import the driver and connect the database from netbeans without issues.
Best regards
Sergio
El 24/07/2013 15:03, Mikael Saltzman escribió:
Correction: I used the cmd file, as I am on a Windows 7 machine. When I run it I get an unauthorized_request. I have looked for oath2 tokens in the registry but found none.
Den onsdagen den 24:e juli 2013 kl. 13:43:19 UTC+2 skrev Mikael Saltzman:Thank you Tony!
I have already tried google_sql.sh and pretty much everything else that I can find. Nothing seems to work.
Best,Mikael
Den tisdagen den 23:e juli 2013 kl. 19:58:36 UTC+2 skrev Tony Tseng:Hi Mikael,Instead of using gauth, could you try google_sql.sh instead? Also please take a look at https://developers.google.com/cloud-sql/docs/external .
On Tue, Jul 23, 2013 at 6:12 AM, Mikael Saltzman <mikaels...@gmail.com> wrote:
Using Netbeans 7.3, I am trying to connect to my Cloud SQL instance uzing the "new connection wizard". I have authorized the project on my local machine with gauth using python 2.7. I though this would create the OAuth 2.0 tokens needed but when I test the connection using "com.google.cloud.sql.Driver", the connection cannot be established. I plan to deploy the Java application on App Engine, using some kind of ORM againts the
Any suggestions what to do to make this connection work?
Correction: I used the cmd file, as I am on a Windows 7 machine. When I run it I get an unauthorized_request. I have looked for oath2 tokens in the registry but found none.
Den onsdagen den 24:e juli 2013 kl. 13:43:19 UTC+2 skrev Mikael Saltzman:Thank you Tony!--
I have already tried google_sql.sh and pretty much everything else that I can find. Nothing seems to work.
Best,Mikael
Den tisdagen den 23:e juli 2013 kl. 19:58:36 UTC+2 skrev Tony Tseng:Hi Mikael,Instead of using gauth, could you try google_sql.sh instead? Also please take a look at https://developers.google.com/cloud-sql/docs/external .
On Tue, Jul 23, 2013 at 6:12 AM, Mikael Saltzman <mikaels...@gmail.com> wrote:
Using Netbeans 7.3, I am trying to connect to my Cloud SQL instance uzing the "new connection wizard". I have authorized the project on my local machine with gauth using python 2.7. I though this would create the OAuth 2.0 tokens needed but when I test the connection using "com.google.cloud.sql.Driver", the connection cannot be established. I plan to deploy the Java application on App Engine, using some kind of ORM againts the
Any suggestions what to do to make this connection work?
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/1067fe9b-3d7b-438c-9183-bca9243fed3e%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Thank you Tony!--I have already tried google_sql.sh and pretty much everything else that I can find. Nothing seems to work.Best,Mikael
Den tisdagen den 23:e juli 2013 kl. 19:58:36 UTC+2 skrev Tony Tseng:Hi Mikael,Instead of using gauth, could you try google_sql.sh instead? Also please take a look at https://developers.google.com/cloud-sql/docs/external .On Tue, Jul 23, 2013 at 6:12 AM, Mikael Saltzman <mikaels...@gmail.com> wrote:
Using Netbeans 7.3, I am trying to connect to my Cloud SQL instance uzing the "new connection wizard". I have authorized the project on my local machine with gauth using python 2.7. I though this would create the OAuth 2.0 tokens needed but when I test the connection using "com.google.cloud.sql.Driver", the connection cannot be established. I plan to deploy the Java application on App Engine, using some kind of ORM againts the
Any suggestions what to do to make this connection work?
Hi Mikael,Instead of using gauth, could you try google_sql.sh instead? Also please take a look at https://developers.google.com/cloud-sql/docs/external .On Tue, Jul 23, 2013 at 6:12 AM, Mikael Saltzman <mikaels...@gmail.com> wrote:
Using Netbeans 7.3, I am trying to connect to my Cloud SQL instance uzing the "new connection wizard". I have authorized the project on my local machine with gauth using python 2.7. I though this would create the OAuth 2.0 tokens needed but when I test the connection using "com.google.cloud.sql.Driver", the connection cannot be established. I plan to deploy the Java application on App Engine, using some kind of ORM againts the
Any suggestions what to do to make this connection work?
Using Netbeans 7.3, I am trying to connect to my Cloud SQL instance uzing the "new connection wizard". I have authorized the project on my local machine with gauth using python 2.7. I though this would create the OAuth 2.0 tokens needed but when I test the connection using "com.google.cloud.sql.Driver", the connection cannot be established. I plan to deploy the Java application on App Engine, using some kind of ORM againts the
Any suggestions what to do to make this connection work?
--
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.
For more options, visit https://groups.google.com/groups/opt_out.
Using Netbeans 7.3, I am trying to connect to my Cloud SQL instance uzing the "new connection wizard". I have authorized the project on my local machine with gauth using python 2.7. I though this would create the OAuth 2.0 tokens needed but when I test the connection using "com.google.cloud.sql.Driver", the connection cannot be established. I plan to deploy the Java application on App Engine, using some kind of ORM againts the
Any suggestions what to do to make this connection work?
-- GoogleCredential credential = new GoogleCredential.Builder() .setTransport(TRANSPORT) .setJsonFactory(JSON_FACTORY) .setServiceAccountId("SOMETHING@developer.gserviceaccount.com") .setServiceAccountScopes(BigqueryScopes.BIGQUERY) .setServiceAccountPrivateKeyFromP12File(new File("key.p12")) .build(); Bigquery bigquery = Bigquery.builder(TRANSPORT, JSON_FACTORY) .setHttpRequestInitializer(credential) .build();i can get my access token from oauth 2.0 after creating credentials but i don't know how to use it while trying to connect cloud sql. Any ideas?
my current code:
HTTP_TRANSPORT = GoogleNetHttpTransport.newTrustedTransport(); GoogleCredential credential = new GoogleCredential.Builder().setTransport(HTTP_TRANSPORT) .setJsonFactory(JSON_FACTORY) .setServiceAccountId("xxx@developer.gserviceaccount.com") .setServiceAccountScopes("https://www.googleapis.com/auth/sqlservice.admin","https://www.googleapis.com/auth/cloud-platform") .setServiceAccountPrivateKeyFromP12File(new File("xxx-privatekey.p12")) //.setServiceAccountUser("xxxx.apps.googleusercontent.com") .build();Hi all,I am new to this cloud datastorage thing. I got a java console project that needs to connect cloud database to verify user-password (and to be able to add new records to database when sign up) and i am super confused what to use. To authenticate should i use service account method or installed application one? For installed application method do i need to open a new google account and use it for everyone who uses the program?I connected cloud db with cloud.sql.Driver;But as you all know i needed to verify my user with sql_command_tool . The users of my program shouldn't connect like this. I think to automate so i need to use OAuth2.0.But when i try the code below, i get error:
java.lang.NullPointerExceptionat java.util.Collections$UnmodifiableCollection.<init>(Unknown Source)at java.util.Collections.unmodifiableCollection(Unknown Source)at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.<init>(GoogleCredential.java:208)at com.google.api.client.googleapis.auth.oauth2.GoogleCredential$Builder.build(GoogleCredential.java:368)at Deneme.main(Deneme.java:66)My Code:try {try {HTTP_TRANSPORT = GoogleNetHttpTransport.newTrustedTransport();GoogleCredential credential = new GoogleCredential.Builder().setTransport(HTTP_TRANSPORT).setJsonFactory(JSON_FACTORY).setServiceAccountId(SERVICE_ACCOUNT_EMAIL).setServiceAccountPrivateKeyFromP12File(new File("f013fa043086020121d22df3d38vaga7a159619fc-privatekey.p12"))// .setServiceAccountUser("user@example.com").build();Connection cloud = null;try {DriverManager.registerDriver(new Driver());cloud = DriverManager.getConnection("jdbc:google:rdbms://instance/db");} catch (SQLException e) {e.printStackTrace();} finally {if (cloud != null)try {cloud.close();} catch (SQLException ignore) {}}}return;} catch (IOException e) {System.err.println(e.getMessage());}} catch (Throwable t) {t.printStackTrace();}System.exit(1);}Any help is appreciated,ThanksYusuf---
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/lg8P0pc2Vc0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Yes, I can see my project and cloud SQL instance (got charged at least).--Also that Cloud SQL instance ID is very confusing, but I tried both, both didn't work.But still
On Thursday, July 18, 2013 5:11:37 PM UTC-7, Tony Tseng wrote:Use the account to access https://cloud.google.com/console#/c=l . Does the project show up? Can you see the Cloud SQL instance?On Thu, Jul 18, 2013 at 1:55 PM, Jun Chen <data....@gmail.com> wrote:"This account needs to have access to Cloud SQL."How to verify/add the access of that account?and where?--
On Sunday, December 9, 2012 12:32:04 PM UTC-8, Chicago wrote:I was able to solve this issue. Check the Google ID you are logged into the Eclipse App Engine plugin with (bottom right hand corner of Eclipse). This account needs to have access to Cloud SQL. Then pass root and an empty password when setting up the Cloud SQL database in Eclipse.
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 .
For more options, visit https://groups.google.com/groups/opt_out .
Use the account to access https://cloud.google.com/console#/c=l . Does the project show up? Can you see the Cloud SQL instance?On Thu, Jul 18, 2013 at 1:55 PM, Jun Chen <data....@gmail.com> wrote:"This account needs to have access to Cloud SQL."How to verify/add the access of that account?and where?--
On Sunday, December 9, 2012 12:32:04 PM UTC-8, Chicago wrote:I was able to solve this issue. Check the Google ID you are logged into the Eclipse App Engine plugin with (bottom right hand corner of Eclipse). This account needs to have access to Cloud SQL. Then pass root and an empty password when setting up the Cloud SQL database in Eclipse.
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 .
For more options, visit https://groups.google.com/groups/opt_out .
"This account needs to have access to Cloud SQL."How to verify/add the access of that account?and where?--
On Sunday, December 9, 2012 12:32:04 PM UTC-8, Chicago wrote:I was able to solve this issue. Check the Google ID you are logged into the Eclipse App Engine plugin with (bottom right hand corner of Eclipse). This account needs to have access to Cloud SQL. Then pass root and an empty password when setting up the Cloud SQL database in Eclipse.
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.
For more options, visit https://groups.google.com/groups/opt_out.