Re: OperationalError: could not connect: ApplicationError: 1002

Are you able to connect from the Cloud SQL console?

J

On Dec 31, 2012 5:21 PM, "Richard Druce" <richard@yreceipts.com> wrote:

I've been getting 

OperationalError: could not connect: ApplicationError: 1002

From my python Appengine account while trying to execute requests. Does anyone know what this means? 

  Thanks,

Richard

OperationalError: could not connect: ApplicationError: 1002

I've been getting 

OperationalError: could not connect: ApplicationError: 1002

From my python Appengine account while trying to execute requests. Does anyone know what this means? 

Thanks,

Richard

Re: Automating Offsite Backups?

Hi Alex

We retain data for at least 30 days before it is permanently purged, so if you contact us during that window we should be able to recover your instance.

Also, I'll update the docs about backup retention

Hope this helps

J

On Fri, Dec 28, 2012 at 3:30 AM, Alexander Bertram <alex@bedatadriven.com> wrote:

Hi Joe,

Thanks for the response. Indeed it's number #3 that I'm most concerned about as a I have a fairly high level of confidence in Google to safeguard the data in the event of hardware failure.

It's good to hear that the backups are retained for seven days -- I haven't seen this documented elsewhere. What is the procedure for restoring a backup? For example, if the instance is deleted, there no longer appears to be an option available through the UI to restore a backup associated with this instance. 

Thanks,

Alex

On Tuesday, December 18, 2012 7:20:07 PM UTC+1, Joe Faith wrote:

Hi Alexander

There seem to be three issues here:

The first is the security of the infrastructure underlying the Google Cloud Platform. We take this very seriously, and you can read more about the safeguards we put in place here: https://cloud.google.com/files/Google-CommonSecurity-WhitePaper-v1.4.pdf

Second, as you say, replication in multiple locations means your data is safe, and available even in the event of very large failures.

Third, the question of operator error or malicious actions. For this we provide regular scheduled backups which are preserved for 7 days and cannot be deleted by operator actions.

With these three levels believe we have provided sufficient robustness and security to support even the most demanding of applications, nonetheless we want to make it straightforward to get your data in and out of Google's cloud. The import/export functionality allows you to do this manually, and we plan to make it easier to use early next year. Stay tuned!

J

On Tue, Dec 18, 2012 at 2:25 AM, Alexander Bertram <al...@bedatadriven.com> wrote:

HI there,

Having been using CloudSQL in production for a few months and am quite happy!

However, I'm still trying to find the best way to automate offsite backups. I'm satisfied that CloudSQL provides good safeguards against hardware failure, through replication and nightly backups, but I'm am still concerned about the possibility of data loss through operator error or the actions of a malicious intruder  -- total destruction of our production database is only two clicks a way!

To guard against this, we've been doing manual daily-weekly dumps and archiving them offsite. Is there anyway to automate this? Looking further down the road, have you considered adding "termination" protection so that a key database cannot be terminated without additional user authentication / safeguards?

Thanks,

Alex

--
Joe Faith | Product Manager | Google Cloud

--
Joe Faith | Product Manager | Google Cloud

Re: App Engine Cloud SQL project running locally on mySQL dev environment Access Denied

1) To correct the error: java.security.AccessControlException: access
denied (java.lang.RuntimePermission accessClassInPackage.sun.jdbc.odbc
Java VM has security permission that restrict the VM from running some
things that access local resources when running in a browser.  The
Java VM default is throw exception on anything sun.*
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.

2) To correct the error "java.lang.ClassNotFoundException:
com.mysql.jdbc.Driver while calling that function"
The docs say that the CLASSPATH gets added automatically by the
plugin.  This is not the case for the mySQL JDBC JAR driver that you
add to the Google Appengine mySQL settings.

Go to Windows -> Control Panel -> System -> Advanced Settings ->
Advanced Settings -> Environment Variables -> System Variables
Add a variable:  CLASSPATH with a value C:\Java\mySQL-JDBC  (or
wherever you stored your mySql JDBC jar mysql-connector-java-5.1.21-
bin.jar)

 

NOW the example guestbook app posted on the Google CloudSQL
documentation will work on a local mySQL instance thought Google
Eclipse Plugin on Windows.  There is NOW WAY it could have possibly
worked for anyone as posted for Eclipse with GPE under Windows,
although everyone who has posted an issue about this was simply
redirected to re-read the documentation.  I assume they just got
frustrated and must have gave up on it as no-one ever posted any
"thanks, it works now"

Thanks a lot John! I had troubles with the two exceptions mentioned above, but I solved thanks to your suggestions.

Best regards,

Saverio.

Re: Automating Offsite Backups?

Hi Joe,

Thanks for the response. Indeed it's number #3 that I'm most concerned about as a I have a fairly high level of confidence in Google to safeguard the data in the event of hardware failure.

It's good to hear that the backups are retained for seven days -- I haven't seen this documented elsewhere. What is the procedure for restoring a backup? For example, if the instance is deleted, there no longer appears to be an option available through the UI to restore a backup associated with this instance. 

Thanks,

Alex

On Tuesday, December 18, 2012 7:20:07 PM UTC+1, Joe Faith wrote:

Hi Alexander

There seem to be three issues here:

The first is the security of the infrastructure underlying the Google Cloud Platform. We take this very seriously, and you can read more about the safeguards we put in place here: https://cloud.google.com/files/Google-CommonSecurity-WhitePaper-v1.4.pdf

Second, as you say, replication in multiple locations means your data is safe, and available even in the event of very large failures.

Third, the question of operator error or malicious actions. For this we provide regular scheduled backups which are preserved for 7 days and cannot be deleted by operator actions.

With these three levels believe we have provided sufficient robustness and security to support even the most demanding of applications, nonetheless we want to make it straightforward to get your data in and out of Google's cloud. The import/export functionality allows you to do this manually, and we plan to make it easier to use early next year. Stay tuned!

J

On Tue, Dec 18, 2012 at 2:25 AM, Alexander Bertram <al...@bedatadriven.com> wrote:

HI there,

Having been using CloudSQL in production for a few months and am quite happy!

However, I'm still trying to find the best way to automate offsite backups. I'm satisfied that CloudSQL provides good safeguards against hardware failure, through replication and nightly backups, but I'm am still concerned about the possibility of data loss through operator error or the actions of a malicious intruder  -- total destruction of our production database is only two clicks a way!

To guard against this, we've been doing manual daily-weekly dumps and archiving them offsite. Is there anyway to automate this? Looking further down the road, have you considered adding "termination" protection so that a key database cannot be terminated without additional user authentication / safeguards?

Thanks,

Alex

--
Joe Faith | Product Manager | Google Cloud

Re: Passing proxy settings to connect Cloud SQL using command line tool

Hey Fabio, 

Did this work for you in the end? No matter what I try, I only ever seem to get the following...

Exiting; Unable to open connection.

Unable to fetch OAuth2 tokens.

Very frustrating. Any advice appreciated, 

Cheers, 

Al

On Thursday, November 8, 2012 6:46:56 PM UTC, Fábio Peruchi wrote:

Thansk Rob!

Em quinta-feira, 8 de novembro de 2012 16h40min00s UTC-2, Rob escreveu:

The arguments you will want are from here.

http://docs.oracle.com/javase/6/docs/technotes/guides/net/proxies.html

I'd change the following line:

${JAVA} -jar "${JAR}" "$@"

to something like:

${JAVA} -jar "${JAR}" -Dhttp.proxyPort=8080 -Dhttp.proxyHost=webcache.mydomain.com "$@"

On Thu, Nov 8, 2012 at 10:38 AM, Rob Clevenger <rcle...@google.com> wrote:

You'll need to edit google_sql.sh (or .cmd) to setting the system properties used by Java for http proxy server support.

On Thu, Nov 8, 2012 at 10:35 AM, Fábio Peruchi <fhpe...@ciandt.com> wrote:

Hi!

Can I pass proxy server settings to connect to Cloud SQL via command line tool (google_sql) ? I can't find this information in command line tool documentation (https://developers.google.com/cloud-sql/docs/commandline).

Thanks in advance.

Fábio Peruchi

Re: Another "An unknown problem occurred (ERROR_RDBMS)"

Awesome, thanks!

Merry Christmas to you too! :-)

-- Razvan ME

On Tue, Dec 25, 2012 at 1:51 AM, Alessandro Alessio <alessalessio@gmail.com> wrote:

Hello Razvan

thanks for your reply. I`am actually out of office for holiday. I ll be back in 2 days and i ll send you the dump file.

 

tnx and merry christmas

2012/12/22 Razvan Musaloiu-E. <razvanm@google.com>

Quick update: I also tried the dump fragment from your email and it worked properly for my dummy table. If you still have issues with the import can you share the exact dump file with me?

Thanks!

Razvan ME

On Fri, Dec 21, 2012 at 10:10 AM, Razvan Musaloiu-E. <razvanm@google.com> wrote:

Can you contact me directly with the name of your instance? Creating triggers works fine (I attached an import that works properly).

-- Razvan ME

On Fri, Dec 21, 2012 at 6:08 AM, Alessandro Alessio <alessalessio@gmail.com> wrote:

Update

Problem seems to be related to the creation of the trigger after the creation of the table.

This means that it is NOT possible to create triggers within a DB hosted in Google Cloud????!!

Here is the trigger creation:

LOCK TABLES `gesevento` WRITE;

/*!40000 ALTER TABLE `gesevento` DISABLE KEYS */;

/*!40000 ALTER TABLE `gesevento` ENABLE KEYS */;

UNLOCK TABLES;

/*!50003 SET @saved_cs_client      = @@character_set_client */ ;

/*!50003 SET @saved_cs_results     = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client  = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection  = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;

/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `win415`.`GESEVENTO_Trigger`

BEFORE UPDATE ON `win415`.`gesevento`

FOR EACH ROW

begin

if  (not(new.aperto = '1' and new.calcolato = '0'))

then

set new.idtipo = old.idtipo;

set new.desc = old.desc;

set new.data = old.data;

set new.aperto = old.aperto;

set new.calcolato = old.calcolato;

end if;

end */;;

DELIMITER ;

/*!50003 SET sql_mode              = @saved_sql_mode */ ;

/*!50003 SET character_set_client  = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection  = @saved_col_connection */ ;

Il giorno venerdì 21 dicembre 2012 12:01:11 UTC+1, Alessandro Alessio ha scritto:

Hi,

I created my bucket and uploaded mysql dump files into. (   mysqldump --user=<user> --password=<password> --hex-blob win415 > win415.sql    )

What i got into logs is       Failed to import gs://win415bucket/win415.sql: An unknown problem occurred (ERROR_RDBMS)

I checked and there is the use win415 on top of the dump file.

It only creates the first table and nothing more. 

Can someone please help me going through?

p.s.: after the table creation, there is a trigger creation for that table. i hope triggers are allowed onto google cloud

Re: Another "An unknown problem occurred (ERROR_RDBMS)"

Hello Razvan

thanks for your reply. I`am actually out of office for holiday. I ll be back in 2 days and i ll send you the dump file.

 

tnx and merry christmas

2012/12/22 Razvan Musaloiu-E. <razvanm@google.com>

Quick update: I also tried the dump fragment from your email and it worked properly for my dummy table. If you still have issues with the import can you share the exact dump file with me?

Thanks!

Razvan ME

On Fri, Dec 21, 2012 at 10:10 AM, Razvan Musaloiu-E. <razvanm@google.com> wrote:

Can you contact me directly with the name of your instance? Creating triggers works fine (I attached an import that works properly).

-- Razvan ME

On Fri, Dec 21, 2012 at 6:08 AM, Alessandro Alessio <alessalessio@gmail.com> wrote:

Update

Problem seems to be related to the creation of the trigger after the creation of the table.

This means that it is NOT possible to create triggers within a DB hosted in Google Cloud????!!

Here is the trigger creation:

LOCK TABLES `gesevento` WRITE;

/*!40000 ALTER TABLE `gesevento` DISABLE KEYS */;

/*!40000 ALTER TABLE `gesevento` ENABLE KEYS */;

UNLOCK TABLES;

/*!50003 SET @saved_cs_client      = @@character_set_client */ ;

/*!50003 SET @saved_cs_results     = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client  = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection  = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;

/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `win415`.`GESEVENTO_Trigger`

BEFORE UPDATE ON `win415`.`gesevento`

FOR EACH ROW

begin

if  (not(new.aperto = '1' and new.calcolato = '0'))

then

set new.idtipo = old.idtipo;

set new.desc = old.desc;

set new.data = old.data;

set new.aperto = old.aperto;

set new.calcolato = old.calcolato;

end if;

end */;;

DELIMITER ;

/*!50003 SET sql_mode              = @saved_sql_mode */ ;

/*!50003 SET character_set_client  = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection  = @saved_col_connection */ ;

Il giorno venerdì 21 dicembre 2012 12:01:11 UTC+1, Alessandro Alessio ha scritto:

Hi,

I created my bucket and uploaded mysql dump files into. (   mysqldump --user=<user> --password=<password> --hex-blob win415 > win415.sql    )

What i got into logs is       Failed to import gs://win415bucket/win415.sql: An unknown problem occurred (ERROR_RDBMS)

I checked and there is the use win415 on top of the dump file.

It only creates the first table and nothing more. 

Can someone please help me going through?

p.s.: after the table creation, there is a trigger creation for that table. i hope triggers are allowed onto google cloud

Re: Transient error

maouel.com:maouel:maouel

thanks

On Saturday, December 22, 2012 3:52:56 PM UTC-5, Ken Ashcraft wrote:

No system-wide issues that I am aware of. What is your instance name?

On Dec 22, 2012 8:31 AM, "maouel" <ba...@maouel.com> wrote:

i keep getting a 'Transient error, please try again later' exception when I run my app in the App Engine. Everything works fine from eclipse+plugin. Is this a temporary system glitch?

Re: Transient error

No system-wide issues that I am aware of. What is your instance name?

On Dec 22, 2012 8:31 AM, "maouel" <badis@maouel.com> wrote:

i keep getting a 'Transient error, please try again later' exception when I run my app in the App Engine. Everything works fine from eclipse+plugin. Is this a temporary system glitch?

Transient error

i keep getting a 'Transient error, please try again later' exception when I run my app in the App Engine. Everything works fine from eclipse+plugin. Is this a temporary system glitch?

Re: Another "An unknown problem occurred (ERROR_RDBMS)"

Quick update: I also tried the dump fragment from your email and it worked properly for my dummy table. If you still have issues with the import can you share the exact dump file with me?

Thanks!

Razvan ME

On Fri, Dec 21, 2012 at 10:10 AM, Razvan Musaloiu-E. <razvanm@google.com> wrote:

Can you contact me directly with the name of your instance? Creating triggers works fine (I attached an import that works properly).

-- Razvan ME

On Fri, Dec 21, 2012 at 6:08 AM, Alessandro Alessio <alessalessio@gmail.com> wrote:

Update

Problem seems to be related to the creation of the trigger after the creation of the table.

This means that it is NOT possible to create triggers within a DB hosted in Google Cloud????!!

Here is the trigger creation:

LOCK TABLES `gesevento` WRITE;

/*!40000 ALTER TABLE `gesevento` DISABLE KEYS */;

/*!40000 ALTER TABLE `gesevento` ENABLE KEYS */;

UNLOCK TABLES;

/*!50003 SET @saved_cs_client      = @@character_set_client */ ;

/*!50003 SET @saved_cs_results     = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client  = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection  = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;

/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `win415`.`GESEVENTO_Trigger`

BEFORE UPDATE ON `win415`.`gesevento`

FOR EACH ROW

begin

if  (not(new.aperto = '1' and new.calcolato = '0'))

then

set new.idtipo = old.idtipo;

set new.desc = old.desc;

set new.data = old.data;

set new.aperto = old.aperto;

set new.calcolato = old.calcolato;

end if;

end */;;

DELIMITER ;

/*!50003 SET sql_mode              = @saved_sql_mode */ ;

/*!50003 SET character_set_client  = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection  = @saved_col_connection */ ;

Il giorno venerdì 21 dicembre 2012 12:01:11 UTC+1, Alessandro Alessio ha scritto:

Hi,

I created my bucket and uploaded mysql dump files into. (   mysqldump --user=<user> --password=<password> --hex-blob win415 > win415.sql    )

What i got into logs is       Failed to import gs://win415bucket/win415.sql: An unknown problem occurred (ERROR_RDBMS)

I checked and there is the use win415 on top of the dump file.

It only creates the first table and nothing more. 

Can someone please help me going through?

p.s.: after the table creation, there is a trigger creation for that table. i hope triggers are allowed onto google cloud

iPhone App - Spanish Flashcards with Pictures

iPhone App - Spanish Flashcards with Pictures - http://spanishiphoneapp.weebly.com

Re: Another "An unknown problem occurred (ERROR_RDBMS)"

Can you contact me directly with the name of your instance? Creating triggers works fine (I attached an import that works properly).

-- Razvan ME

On Fri, Dec 21, 2012 at 6:08 AM, Alessandro Alessio <alessalessio@gmail.com> wrote:

Update

Problem seems to be related to the creation of the trigger after the creation of the table.

This means that it is NOT possible to create triggers within a DB hosted in Google Cloud????!!

Here is the trigger creation:

LOCK TABLES `gesevento` WRITE;

/*!40000 ALTER TABLE `gesevento` DISABLE KEYS */;

/*!40000 ALTER TABLE `gesevento` ENABLE KEYS */;

UNLOCK TABLES;

/*!50003 SET @saved_cs_client      = @@character_set_client */ ;

/*!50003 SET @saved_cs_results     = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client  = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection  = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;

/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `win415`.`GESEVENTO_Trigger`

BEFORE UPDATE ON `win415`.`gesevento`

FOR EACH ROW

begin

if  (not(new.aperto = '1' and new.calcolato = '0'))

then

set new.idtipo = old.idtipo;

set new.desc = old.desc;

set new.data = old.data;

set new.aperto = old.aperto;

set new.calcolato = old.calcolato;

end if;

end */;;

DELIMITER ;

/*!50003 SET sql_mode              = @saved_sql_mode */ ;

/*!50003 SET character_set_client  = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection  = @saved_col_connection */ ;

Il giorno venerdì 21 dicembre 2012 12:01:11 UTC+1, Alessandro Alessio ha scritto:

Hi,

I created my bucket and uploaded mysql dump files into. (   mysqldump --user=<user> --password=<password> --hex-blob win415 > win415.sql    )

What i got into logs is       Failed to import gs://win415bucket/win415.sql: An unknown problem occurred (ERROR_RDBMS)

I checked and there is the use win415 on top of the dump file.

It only creates the first table and nothing more. 

Can someone please help me going through?

p.s.: after the table creation, there is a trigger creation for that table. i hope triggers are allowed onto google cloud

Re: Another "An unknown problem occurred (ERROR_RDBMS)"

Update

Problem seems to be related to the creation of the trigger after the creation of the table.

This means that it is NOT possible to create triggers within a DB hosted in Google Cloud????!!

Here is the trigger creation:

LOCK TABLES `gesevento` WRITE;

/*!40000 ALTER TABLE `gesevento` DISABLE KEYS */;

/*!40000 ALTER TABLE `gesevento` ENABLE KEYS */;

UNLOCK TABLES;

/*!50003 SET @saved_cs_client      = @@character_set_client */ ;

/*!50003 SET @saved_cs_results     = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client  = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection  = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;

/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `win415`.`GESEVENTO_Trigger`

BEFORE UPDATE ON `win415`.`gesevento`

FOR EACH ROW

begin

if  (not(new.aperto = '1' and new.calcolato = '0'))

then

set new.idtipo = old.idtipo;

set new.desc = old.desc;

set new.data = old.data;

set new.aperto = old.aperto;

set new.calcolato = old.calcolato;

end if;

end */;;

DELIMITER ;

/*!50003 SET sql_mode              = @saved_sql_mode */ ;

/*!50003 SET character_set_client  = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection  = @saved_col_connection */ ;

Il giorno venerdì 21 dicembre 2012 12:01:11 UTC+1, Alessandro Alessio ha scritto:

Hi,

I created my bucket and uploaded mysql dump files into. (   mysqldump --user=<user> --password=<password> --hex-blob win415 > win415.sql    )

What i got into logs is       Failed to import gs://win415bucket/win415.sql: An unknown problem occurred (ERROR_RDBMS)

I checked and there is the use win415 on top of the dump file.

It only creates the first table and nothing more. 

Can someone please help me going through?

p.s.: after the table creation, there is a trigger creation for that table. i hope triggers are allowed onto google cloud

Re: Another "An unknown problem occurred (ERROR_RDBMS)"

Hi,

My instance name is  win415betad0:win415

Any help is highly appreciated.

Tnx

Il giorno venerdì 21 dicembre 2012 12:01:11 UTC+1, Alessandro Alessio ha scritto:

Hi,

I created my bucket and uploaded mysql dump files into. (   mysqldump --user=<user> --password=<password> --hex-blob win415 > win415.sql    )

What i got into logs is       Failed to import gs://win415bucket/win415.sql: An unknown problem occurred (ERROR_RDBMS)

I checked and there is the use win415 on top of the dump file.

It only creates the first table and nothing more. 

Can someone please help me going through?

p.s.: after the table creation, there is a trigger creation for that table. i hope triggers are allowed onto google cloud

Another "An unknown problem occurred (ERROR_RDBMS)"

Hi,

I created my bucket and uploaded mysql dump files into. (   mysqldump --user=<user> --password=<password> --hex-blob win415 > win415.sql    )

What i got into logs is       Failed to import gs://win415bucket/win415.sql: An unknown problem occurred (ERROR_RDBMS)

I checked and there is the use win415 on top of the dump file.

It only creates the first table and nothing more. 

Can someone please help me going through?

p.s.: after the table creation, there is a trigger creation for that table. i hope triggers are allowed onto google cloud

Re: Automating Offsite Backups?

Hi Alexander

There seem to be three issues here:

The first is the security of the infrastructure underlying the Google Cloud Platform. We take this very seriously, and you can read more about the safeguards we put in place here: https://cloud.google.com/files/Google-CommonSecurity-WhitePaper-v1.4.pdf

Second, as you say, replication in multiple locations means your data is safe, and available even in the event of very large failures.

Third, the question of operator error or malicious actions. For this we provide regular scheduled backups which are preserved for 7 days and cannot be deleted by operator actions.

With these three levels believe we have provided sufficient robustness and security to support even the most demanding of applications, nonetheless we want to make it straightforward to get your data in and out of Google's cloud. The import/export functionality allows you to do this manually, and we plan to make it easier to use early next year. Stay tuned!

J

On Tue, Dec 18, 2012 at 2:25 AM, Alexander Bertram <alex@bedatadriven.com> wrote:

HI there,

Having been using CloudSQL in production for a few months and am quite happy!

However, I'm still trying to find the best way to automate offsite backups. I'm satisfied that CloudSQL provides good safeguards against hardware failure, through replication and nightly backups, but I'm am still concerned about the possibility of data loss through operator error or the actions of a malicious intruder  -- total destruction of our production database is only two clicks a way!

To guard against this, we've been doing manual daily-weekly dumps and archiving them offsite. Is there anyway to automate this? Looking further down the road, have you considered adding "termination" protection so that a key database cannot be terminated without additional user authentication / safeguards?

Thanks,

Alex

--
Joe Faith | Product Manager | Google Cloud

Re: Error when attempting to add authorized apps

On Tue, Dec 18, 2012 at 2:27 AM, ADLER ìTech <adleritech@adleritech.com> wrote:

Hi, Joe, thanks for the information.

So hopefully, there will be some option for creating EU instances even without premium account :)

To be clear, you can create Cloud SQL instances without a premium account.  See this blog post for info on creating EU apps without a premium account:

http://googleappengine.blogspot.com/2012/12/app-engine-174-released.html

Ken

 

Regards

Pavel

On Thu, Nov 15, 2012 at 5:51 PM, Joe Faith <joefaith@google.com> wrote:

Hi Pavel

For performance reasons we try to keep your Cloud SQL instance as close as possible to the top authorized App Engine application. As a result Cloud SQL instances in the EU can only be accessed from App Engine instances in the EU, and similarly for the US. Apologies if the documentation isn't clear on this, we will be clarifying it.

At the moment EU locations are only available to App Engine's premier customers. I know there's a lot of you guys in Europe using App Engine who are not on premier accounts, and we hope to be able to help you out as soon as possible.

J

On Thu, Nov 15, 2012 at 2:37 AM, ADLER ìTech <adleritech@adleritech.com> wrote:

Hi, Ken, thanks for the info. 

So I understand that to be able to use EU DB instance from my GAE application, this application must be also in EU. However I tried to create new application (itaxi-test) and have not found any settings where to specify location for new application. 

Could you please advice how to create new GAE application in EU, so that it can be authorized in my EU db instance?

Thanks for help

Pavel

On Tue, Nov 13, 2012 at 7:09 PM, Ken Ashcraft <kash@google.com> wrote:

We don't allow US instances to be associated with EU apps and vice versa.  A fix for the error message is pending release.

Ken

On Tue, Nov 13, 2012 at 3:50 AM, Pavel Jetensky <adleritech@adleritech.com> wrote:

Hi, I am having also this issue. My DB instance is:

adleritech.com:adler-itaxi:adler-taxi-test

I try to authorize following application

adler-taxi2

I have no problem authorizing adler-taxi2 for instance adleritech.com:adler-itaxi:adler-taxi created under same account. It seems to be related to different location - adleritech.com:adler-itaxi:adler-taxi-test is created in European Union while adleritech.com:adler-itaxi:adler-taxi is in US.

Please mail me some suggestions privately to jety[AT]inmite.eu, thanks.

Regards

Pavel Jetensky

On Friday, June 29, 2012 8:42:46 PM UTC+2, Tim Jones wrote:

Whenever I attempt to authorize an app, I get " An unexpected error has occurred. We're looking into it. " and nothing changes.  Is there anything I can do to fix this or do I just have to sit back and wait for an undetermined amount of time?

--
Joe Faith | Product Manager | Google Cloud

Re: Error when attempting to add authorized apps

Hi, Joe, thanks for the information.

So hopefully, there will be some option for creating EU instances even without premium account :)

Regards

Pavel

On Thu, Nov 15, 2012 at 5:51 PM, Joe Faith <joefaith@google.com> wrote:

Hi Pavel

For performance reasons we try to keep your Cloud SQL instance as close as possible to the top authorized App Engine application. As a result Cloud SQL instances in the EU can only be accessed from App Engine instances in the EU, and similarly for the US. Apologies if the documentation isn't clear on this, we will be clarifying it.

At the moment EU locations are only available to App Engine's premier customers. I know there's a lot of you guys in Europe using App Engine who are not on premier accounts, and we hope to be able to help you out as soon as possible.

J

On Thu, Nov 15, 2012 at 2:37 AM, ADLER ìTech <adleritech@adleritech.com> wrote:

Hi, Ken, thanks for the info. 

So I understand that to be able to use EU DB instance from my GAE application, this application must be also in EU. However I tried to create new application (itaxi-test) and have not found any settings where to specify location for new application. 

Could you please advice how to create new GAE application in EU, so that it can be authorized in my EU db instance?

Thanks for help

Pavel

On Tue, Nov 13, 2012 at 7:09 PM, Ken Ashcraft <kash@google.com> wrote:

We don't allow US instances to be associated with EU apps and vice versa.  A fix for the error message is pending release.

Ken

On Tue, Nov 13, 2012 at 3:50 AM, Pavel Jetensky <adleritech@adleritech.com> wrote:

Hi, I am having also this issue. My DB instance is:

adleritech.com:adler-itaxi:adler-taxi-test

I try to authorize following application

adler-taxi2

I have no problem authorizing adler-taxi2 for instance adleritech.com:adler-itaxi:adler-taxi created under same account. It seems to be related to different location - adleritech.com:adler-itaxi:adler-taxi-test is created in European Union while adleritech.com:adler-itaxi:adler-taxi is in US.

Please mail me some suggestions privately to jety[AT]inmite.eu, thanks.

Regards

Pavel Jetensky

On Friday, June 29, 2012 8:42:46 PM UTC+2, Tim Jones wrote:

Whenever I attempt to authorize an app, I get " An unexpected error has occurred. We're looking into it. " and nothing changes.  Is there anything I can do to fix this or do I just have to sit back and wait for an undetermined amount of time?

--
Joe Faith | Product Manager | Google Cloud

Automating Offsite Backups?

HI there,

Having been using CloudSQL in production for a few months and am quite happy!

However, I'm still trying to find the best way to automate offsite backups. I'm satisfied that CloudSQL provides good safeguards against hardware failure, through replication and nightly backups, but I'm am still concerned about the possibility of data loss through operator error or the actions of a malicious intruder  -- total destruction of our production database is only two clicks a way!

To guard against this, we've been doing manual daily-weekly dumps and archiving them offsite. Is there anyway to automate this? Looking further down the road, have you considered adding "termination" protection so that a key database cannot be terminated without additional user authentication / safeguards?

Thanks,

Alex

Re: Cannot create new instance (billing not enabled)

ok in my machine have 2 identity gmail and iperthink.com (only one permitted ?)

ciao

piero

On Monday, December 17, 2012 5:58:31 PM UTC+1, Razvan Musaloiu-E. wrote:

Is the gmail user you are using part of the Team for the 538401573747 project? I presume you did setup for the command line [1], right?

[1] https://developers.google.com/cloud-sql/docs/commandline#setup

-- Razvan ME

On Mon, Dec 17, 2012 at 12:34 AM, Piero <psba...@gmail.com> wrote:

./google_sql.sh iperthink.com:iperthink:iper-view2

Exiting; Unable to open connection.

End user Google Account not authorized.

ciao

piero

On Monday, December 17, 2012 4:01:51 AM UTC+1, Razvan Musaloiu-E. wrote:

What error do you get when you try using the command line tool?

-- Razvan ME

On Sun, Dec 16, 2012 at 8:27 AM, Piero <psba...@gmail.com> wrote:

ok istance 538401573747
create sql server but not connect from command line from pc

ciao

piero

On Sunday, December 16, 2012 1:07:09 AM UTC+1, Piero wrote:

ok is good

have same problem with

istance 538401573747

On Friday, December 14, 2012 4:53:54 PM UTC+1, Tony Tseng wrote:

Hi Piero,

Could you try again please? It should be working now.

On Fri, Dec 14, 2012 at 2:36 AM, Piero <psba...@gmail.com> wrote:

same problem

ciao piero

id: 741257275474

On Sunday, November 4, 2012 10:33:59 PM UTC+1, Mike Drummond wrote:

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: 411892037600