Re: Connect to Google Cloud SQL using LibreOffice

Yes, you are right. I tried it without sudo and was able to connect. Thx!

I connected to Google Cloud Sql using LibreOffice database tool. Created a table.

Now I want to edit/add data using LO spreadsheet.

So, here are the steps
1. open a spreadsheet
2. Press F4
3. There you can see an already existing database called "Bibliography", expand till table "biblio". You can see content data on the right.
4. Drag and drop biblio table on spreadsheet, It works!

Now when I try to do it the same way using Google Cloud Sql DB I create earlier I get the following errors:

The data content could not be updated

SQL Status: 0A100

CONCUR_UPDATABLE is not implemented yet.

The SQL command leading to this error is:

SELECT * FROM `test`.`users_info` 

Check attachments for more details.

Thx for your help!

On 13 February 2013 17:58, Razvan Musaloiu-E. <razvanm@google.com> wrote:

Can you get the ./google_sql.sh to work as your user? I would expect the sudo to put the keys in the root directory instead of yours.

-- Razvan ME

On Wed, Feb 13, 2013 at 4:04 AM, Gheorghe Chirica <chiricagheorghe@gmail.com> wrote:

Ok, I tried it on a differnt computer and it worked, I got "The JDBC driver was loaded successfully". Probably different java version.
 
But now I have another problem. When I'm on step 3 "Set up user authentication", I press test connection and I get

SQL Status: 22023

Unable to load OAuth2 refresh or access token. Please run the google_sql command line tool once to setup cached credentials. See: http://code.google.com/apis/sql/docs/commandline.html

I did steps described here http://code.google.com/apis/sql/docs/commandline.html and in attachment you can see that I'm connected to MySql DB from command line.

Not sure what's the problem, it should connect.

On 13 February 2013 12:55, Ken Ashcraft <kash@google.com> wrote:

On Wed, Feb 13, 2013 at 7:31 AM, Gheorghe Chirica <chiricagheorghe@gmail.com> wrote:

Yes, saw this tutorial earlier and thought it should work/configured in similar way, but seems that not. Can't figure out how to do it.

From your screenshot, it appears that you are using the standard mysql driver instead of the Google driver.

--
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.
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.
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.
For more options, visit https://groups.google.com/groups/opt_out.