Re: Export SQL to cloud storage contains only table definitions, no data

Hi Ralph

We're currently working on improving connectivity.

I've sent you an email off-thread about this.

J

On Tue, Aug 27, 2013 at 5:29 AM, Ralph Brecheisen <ralph.brecheisen@arcus-business.com> wrote:

Hi,

We're using Google Cloud SQL for a hour registration tool. This tool is being used regularly by about 40 users so we need a good strategy for making changes to the database. It surprised us somewhat that the google_sql.sh tool allows you to upload a SQL file but not export and download one. After looking into the documentation I saw that Google Cloud Storage is the preferred medium of exchange. This is fine for us except for the fact that the SQL file exported from Cloud SQL does not contain the actual records, only the table DROP/CREATE statements.

Is there a special option or configuration setting that I have to set in order to let the dump contain the records as well? Or am I missing something else? Maybe there's some error being produced under the hood but I don't have access to the lower level logs as far as I know. The operations log in the cloud console just reports that the export went fine. 

It's really problematic for us that we're not able to download a copy of the database so any help would be greatly appreciated. 

Thanks!

Ralph

--
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/4c0c533e-ae0e-4aa1-99e5-46dda4032d2c%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Joe Faith | Product Manager | Google Cloud

--
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/CAHNz2%3D-vHOR1VwK-QjZdibW%3DjBBq425t89yu0ck7Zcaea8ihgw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Export SQL to cloud storage contains only table definitions, no data

Hi,

We're using Google Cloud SQL for a hour registration tool. This tool is being used regularly by about 40 users so we need a good strategy for making changes to the database. It surprised us somewhat that the google_sql.sh tool allows you to upload a SQL file but not export and download one. After looking into the documentation I saw that Google Cloud Storage is the preferred medium of exchange. This is fine for us except for the fact that the SQL file exported from Cloud SQL does not contain the actual records, only the table DROP/CREATE statements.

Is there a special option or configuration setting that I have to set in order to let the dump contain the records as well? Or am I missing something else? Maybe there's some error being produced under the hood but I don't have access to the lower level logs as far as I know. The operations log in the cloud console just reports that the export went fine. 

It's really problematic for us that we're not able to download a copy of the database so any help would be greatly appreciated. 

Thanks!

Ralph

--
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/4c0c533e-ae0e-4aa1-99e5-46dda4032d2c%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: SUPER Privilege Removal

As Tony indicated, the SUPER privilege was removed on July 31. I pinged you directly to find the instance name to re-enable it.

-- Razvan ME

On Mon, Aug 26, 2013 at 11:29 PM, Sandy Nader <sandy@startx.stanford.edu> wrote:

I am encountering the exact same issue - any update on whether the SUPER privileges are still in effect?

On Sunday, August 4, 2013 11:28:48 AM UTC-7, Aisa wrote:

I'm trying to set row format to dynamic for one of my tables to get past a "row too large" error.

Just doing alter table grants_grantapplication row_format=dynamic shows no error message but seems to have no effect.  I assume this is because innodb_file_per_table has to be on for it to work.  In the past, I did set global innodb_file_per_table = ON, then set the row format and it worked.

I'm trying to do the same thing for another table.  That variable is back to off now and when I try to change it I get the error about needing SUPER privileges.  Is there any way around this so I can use dynamic row format in additional tables?

On Tuesday, July 30, 2013 2:22:05 PM UTC-7, Tony Tseng wrote:

Dear Cloud SQL Users,

As stated previously, we are going to remove the SUPER privilege. This change will take effect tomorrow (7/31 Pacific time).

Please let us know if you encounter any issues.

--
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/054ee971-bc04-447a-8979-36e6e37de7b5%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/CA%2BUvTg169BcPqQg8bzipqWYA%2B%3D5bijGcb%3Dq-9V3LsbFq-nepMQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: SUPER Privilege Removal

I am encountering the exact same issue - any update on whether the SUPER privileges are still in effect?

On Sunday, August 4, 2013 11:28:48 AM UTC-7, Aisa wrote:

I'm trying to set row format to dynamic for one of my tables to get past a "row too large" error.

Just doing alter table grants_grantapplication row_format=dynamic shows no error message but seems to have no effect.  I assume this is because innodb_file_per_table has to be on for it to work.  In the past, I did set global innodb_file_per_table = ON, then set the row format and it worked.

I'm trying to do the same thing for another table.  That variable is back to off now and when I try to change it I get the error about needing SUPER privileges.  Is there any way around this so I can use dynamic row format in additional tables?

On Tuesday, July 30, 2013 2:22:05 PM UTC-7, Tony Tseng wrote:

Dear Cloud SQL Users,

As stated previously, we are going to remove the SUPER privilege. This change will take effect tomorrow (7/31 Pacific time).

Please let us know if you encounter any issues.

--
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/054ee971-bc04-447a-8979-36e6e37de7b5%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: cloud sql stops working after sometime

What language you using? Are you using the native connections [1]? For Java one very important thing is to make sure the connections are closed at the end of a request.

[1] https://developers.google.com/cloud-sql/docs/native-mysql-gae

[2] https://developers.google.com/cloud-sql/docs/native-mysql-gae#java

-- Razvan ME

On Mon, Aug 26, 2013 at 6:26 AM, ankur shah <shahankur3112@gmail.com> wrote:

So when you say connection you mean Database connection?. What if i add a check to my code to make sure that connection is refreshed every few hours will that help?
Also restarting the instance fixes everything again.

Thanks a lot for helping

On Monday, August 26, 2013 8:52:31 AM UTC-4, cp wrote:

If the app is not used I have noticed that the connection drops. Ping hasn't worked for me, so I refresh it every time I use it

On Monday, August 26, 2013 10:01:49 AM UTC+1, ankur shah wrote:

When i deploy the app engine project connected to cloud sql it works fine for sometime. But after sometime i try to access, it does not return any results. similar issue https://vaadin.com/old-forum/-/message_boards/view_message/2873573#_19_message_0

--
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/cef9ab0d-cb89-439d-8a07-f17dbe98d5d8%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/CA%2BUvTg2gGTwQBALk144JANtxLW%3DEkXT6Pybo%3DAejO61s0cUU8g%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: cloud sql stops working after sometime

So when you say connection you mean Database connection?. What if i add a check to my code to make sure that connection is refreshed every few hours will that help?
Also restarting the instance fixes everything again.

Thanks a lot for helping

On Monday, August 26, 2013 8:52:31 AM UTC-4, cp wrote:

If the app is not used I have noticed that the connection drops. Ping hasn't worked for me, so I refresh it every time I use it

On Monday, August 26, 2013 10:01:49 AM UTC+1, ankur shah wrote:

When i deploy the app engine project connected to cloud sql it works fine for sometime. But after sometime i try to access, it does not return any results. similar issue https://vaadin.com/old-forum/-/message_boards/view_message/2873573#_19_message_0

--
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/cef9ab0d-cb89-439d-8a07-f17dbe98d5d8%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: cloud sql stops working after sometime

So rest of the code logic works but only the part which access the sql is not working

On Monday, August 26, 2013 9:20:19 AM UTC-4, ankur shah wrote:

1. 2013-08-26 02:34:51.121 /api/buses/buslocation/1 200 271ms 0kb Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36
   173.230.64.120 - - [26/Aug/2013:02:34:51 -0700] "GET /api/buses/buslocation/1 HTTP/1.1" 200 430 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36" "transport-tracking.appspot.com" ms=272 cpu_ms=151 cpm_usd=0.000048 app_engine_release=1.8.3 instance=00c61b117c14ae15a695488c5e71a76159a0eb      

Above is few hours back when it worked.

Below is when it does not work.

1. 2013-08-26 06:19:27.593 /api/buses/buslocation/1 200 9ms 0kb Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36

   173.230.64.120 - - [26/Aug/2013:06:19:27 -0700] "GET /api/buses/buslocation/1 HTTP/1.1" 200 76 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36" "transport-tracking.appspot.com" ms=9 cpu_ms=21 cpm_usd=0.000008 app_engine_release=1.8.3 instance=00c61b117c14ae15a695488c5e71a76159a0eb      

On Monday, August 26, 2013 9:03:32 AM UTC-4, cp wrote:

check this as well it might help you http://stackoverflow.com/questions/12574741/cron-job-on-google-app-engine-to-speed-up-pages

On Monday, August 26, 2013 1:52:31 PM UTC+1, cp wrote:

If the app is not used I have noticed that the connection drops. Ping hasn't worked for me, so I refresh it every time I use it

On Monday, August 26, 2013 10:01:49 AM UTC+1, ankur shah wrote:

When i deploy the app engine project connected to cloud sql it works fine for sometime. But after sometime i try to access, it does not return any results. similar issue https://vaadin.com/old-forum/-/message_boards/view_message/2873573#_19_message_0

--
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/8a9137c1-809d-4a18-8e8d-206f617637fc%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: cloud sql stops working after sometime

1. 2013-08-26 02:34:51.121 /api/buses/buslocation/1 200 271ms 0kb Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36
   173.230.64.120 - - [26/Aug/2013:02:34:51 -0700] "GET /api/buses/buslocation/1 HTTP/1.1" 200 430 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36" "transport-tracking.appspot.com" ms=272 cpu_ms=151 cpm_usd=0.000048 app_engine_release=1.8.3 instance=00c61b117c14ae15a695488c5e71a76159a0eb      

Above is few hours back when it worked.

Below is when it does not work.

1. 2013-08-26 06:19:27.593 /api/buses/buslocation/1 200 9ms 0kb Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36

   173.230.64.120 - - [26/Aug/2013:06:19:27 -0700] "GET /api/buses/buslocation/1 HTTP/1.1" 200 76 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36" "transport-tracking.appspot.com" ms=9 cpu_ms=21 cpm_usd=0.000008 app_engine_release=1.8.3 instance=00c61b117c14ae15a695488c5e71a76159a0eb      

On Monday, August 26, 2013 9:03:32 AM UTC-4, cp wrote:

check this as well it might help you http://stackoverflow.com/questions/12574741/cron-job-on-google-app-engine-to-speed-up-pages

On Monday, August 26, 2013 1:52:31 PM UTC+1, cp wrote:

If the app is not used I have noticed that the connection drops. Ping hasn't worked for me, so I refresh it every time I use it

On Monday, August 26, 2013 10:01:49 AM UTC+1, ankur shah wrote:

When i deploy the app engine project connected to cloud sql it works fine for sometime. But after sometime i try to access, it does not return any results. similar issue https://vaadin.com/old-forum/-/message_boards/view_message/2873573#_19_message_0

--
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/cd2db090-5cdf-4b2d-af9c-8276bd1186c4%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: cloud sql stops working after sometime

check this as well it might help you http://stackoverflow.com/questions/12574741/cron-job-on-google-app-engine-to-speed-up-pages

On Monday, August 26, 2013 1:52:31 PM UTC+1, cp wrote:

If the app is not used I have noticed that the connection drops. Ping hasn't worked for me, so I refresh it every time I use it

On Monday, August 26, 2013 10:01:49 AM UTC+1, ankur shah wrote:

When i deploy the app engine project connected to cloud sql it works fine for sometime. But after sometime i try to access, it does not return any results. similar issue https://vaadin.com/old-forum/-/message_boards/view_message/2873573#_19_message_0

--
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/f3417842-a0b0-4393-b766-b240adfcadbd%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Databases fail to load

I have downloaded the latest version of the Google Cloud SDK for python. After having exported the proper directory, I run gauth. It fires up the browser to authorize etc. At the end I receive a message saying "The authentication flow has completed."
On the terminal side though the script has crashed. The message is the following:
Traceback (most recent call last):
  File "/home/username/google-cloud-sdk-0.9.7/platform/gauth-bin/gauth_main.py", line 168, in <module>
    main()
  File "/home/username/google-cloud-sdk-0.9.7/platform/gauth-bin/gauth_main.py", line 150, in main
    credentials = manager.Authorize(refresh_token=args.refresh_token)
  File "/home/username/google-cloud-sdk-0.9.7/bin/bootstrapping/../../lib/gauth/auth.py", line 135, in Authorize
    return self._AuthorizeWithWebFlow()
  File "/home/username/google-cloud-sdk-0.9.7/bin/bootstrapping/../../lib/gauth/auth.py", line 185, in _AuthorizeWithWebFlow
    return oauth2_tools.run(flow, storage)
  File "/home/username/google-cloud-sdk-0.9.7/lib/gauth/lib/oauth2client/util.py", line 128, in positional_wrapper
    return wrapped(*args, **kwargs)
  File "/home/username/google-cloud-sdk-0.9.7/lib/gauth/lib/oauth2client/tools.py", line 197, in run
    credential = flow.step2_exchange(code, http=http)
  File "/home/username/google-cloud-sdk-0.9.7/lib/gauth/lib/oauth2client/util.py", line 128, in positional_wrapper
    return wrapped(*args, **kwargs)
  File "/home/username/google-cloud-sdk-0.9.7/lib/gauth/lib/oauth2client/client.py", line 1283, in step2_exchange
    headers=headers)
  File "/home/username/google-cloud-sdk-0.9.7/lib/gauth/lib/httplib2/__init__.py", line 1586, in request
    (response, content) = self._request(conn, authority, uri, request_uri, method, body, headers, redirections, cachekey)
  File "/home/username/google-cloud-sdk-0.9.7/lib/gauth/lib/httplib2/__init__.py", line 1333, in _request
    (response, content) = self._conn_request(conn, request_uri, method, body, headers)
  File "/home/username/google-cloud-sdk-0.9.7/lib/gauth/lib/httplib2/__init__.py", line 1255, in _conn_request
    conn.connect()
  File "/home/username/google-cloud-sdk-0.9.7/lib/gauth/lib/httplib2/__init__.py", line 1009, in connect
    sock = socks.socksocket(family, socktype, proto)
AttributeError: 'NoneType' object has no attribute 'socksocket'

So I cannot proceed to connect with the command line tool.

On Thursday, August 22, 2013 6:02:38 PM UTC+1, Amit Mondal wrote:

Can please verify this using the command line tool?

On Aug 22, 2013 1:49 AM, "DSG" <middlewar...@gmail.com> wrote:

The password is not changed. Definitely not by me and as I check from the backup of the database not from anyone else.

--
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/3d476911-9919-4942-a6a8-e056018d0b0e%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/bee574e1-ceb4-4d39-a241-c2f54f62a168%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: cloud sql stops working after sometime

If the app is not used I have noticed that the connection drops. Ping hasn't worked for me, so I refresh it every time I use it

On Monday, August 26, 2013 10:01:49 AM UTC+1, ankur shah wrote:

When i deploy the app engine project connected to cloud sql it works fine for sometime. But after sometime i try to access, it does not return any results. similar issue https://vaadin.com/old-forum/-/message_boards/view_message/2873573#_19_message_0

--
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/4d692746-75bf-4023-87f1-30c2c7189584%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: issue in google cloud

Same error is happening for me as well. I have a simple restful web service accessing the database it works fine for sometime but after that it starts sending back empty results.

On Tuesday, April 2, 2013 12:46:02 PM UTC-4, Tony Tseng wrote:

Hello,

Could you provide more information? This stack trace isn't very useful. I cannot tell whether this is a issue with the app, with App Engine, or with Cloud SQL. 

On Tue, Apr 2, 2013 at 12:19 AM, <glycus.te...@gmail.com> wrote:

hi this is satish

I have made a Google App Engine project in Vaadin with google cloud sql database. I've tested it well on my local machine, without (any important) bugs. When I deploy it to GAE it also works for a certain time. Only after x hours it stops working (doing exactly the same as before and without changing anything to the code). If I deploy the project again, it is working again.When I take a look at the GAE logs it seems to be a 2013-03-25 10:26:03.071 com.vaadin.terminal.gwt.server.GAEApplicationServlet service: An exception occurred while servicing request. javax.servlet.ServletException: java.lang.RuntimeException at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.handleServiceException(AbstractApplicationServlet.java:1010) at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:548) at com.vaadin.terminal.gwt.server.GAEApplicationServlet.service(GAEApplicationServlet.java:239) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
java google-app-engine vaadin

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

--
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/8f1cbba8-96f0-4975-87e9-9b52c7d05cb8%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

cloud sql stops working after sometime

When i deploy the app engine project connected to cloud sql it works fine for sometime. But after sometime i try to access, it does not return any results. similar issue https://vaadin.com/old-forum/-/message_boards/view_message/2873573#_19_message_0

--
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/f931ff4f-1898-4f88-8634-02788e86b07d%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Failed to load databases

Hi there.

I'm experiencing this error in my CloudSQL project: "Failed to load databases". I also have some similar errors when I try to establish a connection via API. In those days it was not done any work on the DB.

How is it possible? How can I resolve?

Thank you in advance. 

Fausto

---

Injenia Srl 

Sede operativa: Via Dell'Arcoveggio, 74; 40129 Bologna 

Sede legale: Strada Statale Romana 413, 160-162; 41019 Appalto di Soliera (MO)
CF e P.IVA: 03008670360 | Registro delle Imprese di Modena  |  REA 350109  |  Capitale sociale: € 72.000,00 i.v.

---

Le informazioni trasmesse sono da intendersi solo per le persone od enti a cui sono indirizzate e possono contenere materiale riservato o confidenziale. Ogni modifica, ri-trasmissione, diffusione o qualsiasi altro uso di tale materiale da parte di persone od enti diversi dai destinatari è proibito. Se doveste ricevere per errore questo messaggio, per favore cancellatelo da ogni computer  e contattate: injenia@injenia.it

--
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/077d1d3a-8062-4725-b631-b87326a7a5b9%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Squirrel Unauthorized Client Issue

The OAuth2 token used by the Python should be in ~/.googlesql_oauth2.dat in Linux and in %USERPROFILE%\.googlesql_oauth2.dat in Windows.

Reference: https://developers.google.com/appengine/docs/python/cloud-sql/django#authentication

-- Razvan ME

On Sun, Aug 25, 2013 at 1:47 PM, Michael Houck <mhouck@gmail.com> wrote:

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.

--
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%2BUvTg15hpO1%3DZrDuX%2Bw4b%2Bt8SGj4BmcN25miLHNPazH8W--nQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

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.

Re: Squirrel Unauthorized Client Issue

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/CA%2BbE6i1%3DU71ydVa2bw9h8mx-oj6bCV4bT4e-A8R17CgTzd91_A%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Squirrel Unauthorized Client Issue

Yes, both are run on the exact same machine on the same account.

On Sunday, August 25, 2013 4:18:35 PM UTC-4, Amit Mondal wrote:

Are you running Squirrel from the same Linux/Windows account as the command line tool? This is important because the oauth2 token is shared.

On Sun, Aug 25, 2013 at 7:35 AM, Michael Houck <mho...@gmail.com> 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/603237b4-8e3c-4c6a-bd86-3b93c894ca41%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Squirrel Unauthorized Client Issue

Are you running Squirrel from the same Linux/Windows account as the command line tool? This is important because the oauth2 token is shared.

On Sun, Aug 25, 2013 at 7:35 AM, Michael Houck <mhouck@gmail.com> 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/CABeVsY%2BXyHKL_v4jO5hXGE6YZMdK55XBYrrYzTWJGgrfhJFEbw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Squirrel Unauthorized Client Issue

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.

Re: Squirrel Unauthorized Client Issue

Is it running as same user?

On Aug 24, 2013 2:05 PM, "Michael Houck" <mhouck@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/CABeVsYL-ecetLnFbzn4h-6dZDH_p1c4NeUijCCFsxhxseKN%3DcQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Squirrel Unauthorized Client Issue

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.

could not create instance because billing in not enabled

It strikes again!

app-id : wordpress-webapp

--
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/ed1774c6-44be-40f8-88b3-253fb546dfa5%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Databases fail to load

Can please verify this using the command line tool?

On Aug 22, 2013 1:49 AM, "DSG" <middleware.dsg.tcd@gmail.com> wrote:

The password is not changed. Definitely not by me and as I check from the backup of the database not from anyone else.

--
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/3d476911-9919-4942-a6a8-e056018d0b0e%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/CABeVsY%2BxSq%3Dn-zmKC2YgRkswNJw1Fn64mDyGPHkW79yuC4mZ%2Bg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Databases fail to load

The password is not changed. Definitely not by me and as I check from the backup of the database not from anyone else.

--
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/3d476911-9919-4942-a6a8-e056018d0b0e%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Unable to export data from my Google Cloude SQL database instance

I got a response directly from google; but forgot to post the response here. Currently, the mysql logs are not exposed directly to the user. What was happening to me was that I had a view that referenced tables/fields no longer in the database (cleanup issue on my part); so the dump routine was failing but the exact mysql error message was not being passed all the way to the Google Cloud SQL console. Google responded very quickly and accurately. They also said they have plans to eventually expose the mysql logs to the admin.

I thought it most interesting part of this was the dump routine actually checked the validity of the statements (e.g. the create view statement) it was creating and not just blindly writing it out. Nice, because then you don't have to deal with it when you are importing it.



On Wednesday, August 21, 2013 5:27:40 AM UTC-10, Lee S. wrote:

Do you see anything in the operations log?  Are you using http://cloud.google.com/console?  Also, what's the instance name??

--
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/64de959b-19ea-40f8-9553-c0790aa84733%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Databases fail to load

Did you change the root password? The prompt works only if the root password is left unset.

On Wed, Aug 21, 2013 at 9:16 AM, DSG <middleware.dsg.tcd@gmail.com> wrote:

Hi everyone,
We are experiencing a problem the past few days. The databases seem not to be working. In the screenshots it's obvious that the backups are made, nevertheless, the databases do not load in the backend. In the frontend it seems that sometimes they work, sometimes they don't. Yesterday, after many page refreshes, the dbs loaded up and I managed to execute a query. Does anyone have an idea of what's happening?

Regards,

C

--
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/cb6b603d-3b71-4d78-822b-3a87c9995db9%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/CABeVsYJdE5fcP19vrAnUiBb5u%3Dw5HEzsVPO2LmAenhkPdcAsxA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Databases fail to load

Hi everyone,
We are experiencing a problem the past few days. The databases seem not to be working. In the screenshots it's obvious that the backups are made, nevertheless, the databases do not load in the backend. In the frontend it seems that sometimes they work, sometimes they don't. Yesterday, after many page refreshes, the dbs loaded up and I managed to execute a query. Does anyone have an idea of what's happening?

Regards,

C

--
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/cb6b603d-3b71-4d78-822b-3a87c9995db9%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Unable to export data from my Google Cloude SQL database instance

Do you see anything in the operations log? Are you using http://cloud.google.com/console? Also, what's the instance name??

--
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/480342a3-715f-4d77-85c4-abe2527956b4%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

"Security Groups" as traffic filters/firewall

Hi,
Hopefuly this is the right place to ask this:

Is there a similar mechanism to Amazon EC2's "Security Group", that would allow me to filter traffic before it gets to my instances?

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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/83940d2a-beb6-4818-a97d-5641d4326c6b%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Unable to export data from my Google Cloude SQL database instance

I've been getting this for a few days. 

Failed to back up to gs://{bucket}/{filename}.gz: An unknown problem occurred (ERROR_RDBMS)

The data bucket I'm usin gand filename are valid.

That's all the detail google is giving me. I see some other posts with this issue but someone (I assume from google) always says he will help them and notify them offline.

I've tried restarting the database instance.

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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f0657ac6-9d9f-4ac8-97c6-f79a34900831%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.