On 2018-06-22 18:30, Andrew Colvin wrote:

On Friday, 22 June 2018 12:25:09 BST Carlos E. R. wrote:

...

On 2018-06-22 12:50, Carlos E. R. wrote:

...

Hi,

I'm trying again LO Base against an existing database in MySQL. Things have improved, but not enough to make it work.

...

...

I look around menus in LOB and I find in tools "Relations". Wonderful! I simply need to define the relationships between the several tables. In less than a minute I define the first one, in the familiar method I used in Windows decades ago and that Rekall also used:

http://paste.opensuse.org/65162073

This is how it is supposed to work, but it doesn't:

https://www.youtube.com/watch?v=lybleU8sfZg

Notice it is dated 2014. Why doesn't work for me?

I am also unable to get base to work correctly with mysql. I get errors around ill formed foreign key constraints. When some do work they do not create the foreign key in the database.

Have you looked at kexi to see if it will do what you need?

Years ago, and then no. -- Cheers / Saludos, Carlos E. R. (from 42.3 x86_64 "Malachite" at Telcontar)

On 2018-06-22 13:27, Dave Howorth wrote:

On Fri, 22 Jun 2018 12:50:34 +0200 "Carlos E. R." wrote:

...

Hi,

I'm trying again LO Base against an existing database in MySQL. Things have improved, but not enough to make it work.

[snip]

...

How is this supposed to work?

Is Libre Office Base finished? I have been waiting for this feature in Linux since 1998, when I used it in Windows Office and worked instantly. Rekall in KDE3 did it fine, but Rekall is no longer provided in openSUSE.

In fact, in order to take the photos for this post and show the line connecting the relationship I have to exit LO and delete the created file. It only draws the line the first time I try, not the next times.

Yes, I have looked in LO help. Useless. No howto. I don't understand a word of it.

I suggest posting your entire question to the LO mailing list. You're likely to get much more comprehensive replies there.

But this seems an openSUSE problem, the videos show it working. I tried to use ODBC, I can't even set it up. Select database: connect using ODBC. Name of the ODBC data source on your system. Browse--> nothing found. I try JDBC next. Select database: connect using JDBC. It asks for the datasource URL (e.g. postgressql://host/database). I try mysql://localhost/biblioteca. It does not allow me to continue. Where is that LO mailing list? -- Cheers / Saludos, Carlos E. R. (from 42.3 x86_64 "Malachite" at Telcontar)

On Fri, 22 Jun 2018 13:34:56 +0200 "Carlos E. R." wrote:

On 2018-06-22 13:27, Dave Howorth wrote:

...

On Fri, 22 Jun 2018 12:50:34 +0200 "Carlos E. R." wrote:

...

Hi,

I'm trying again LO Base against an existing database in MySQL. Things have improved, but not enough to make it work.

[snip]

...

How is this supposed to work?

Is Libre Office Base finished? I have been waiting for this feature in Linux since 1998, when I used it in Windows Office and worked instantly. Rekall in KDE3 did it fine, but Rekall is no longer provided in openSUSE.

In fact, in order to take the photos for this post and show the line connecting the relationship I have to exit LO and delete the created file. It only draws the line the first time I try, not the next times.

Yes, I have looked in LO help. Useless. No howto. I don't understand a word of it.

I suggest posting your entire question to the LO mailing list. You're likely to get much more comprehensive replies there.

But this seems an openSUSE problem, the videos show it working.

I stand by my suggestion. It may be an opensuse problem, it may not. But the people who will know are on the LO list.

I tried to use ODBC, I can't even set it up.

Select database: connect using ODBC. Name of the ODBC data source on your system. Browse--> nothing found.

I try JDBC next.

Select database: connect using JDBC. It asks for the datasource URL (e.g. postgressql://host/database). I try mysql://localhost/biblioteca. It does not allow me to continue.

Where is that LO mailing list?

https://www.libreoffice.org/get-help/mailing-lists/ - users -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On 2018-06-23 07:42, David C. Rankin wrote:

On 06/22/2018 05:50 AM, Carlos E. R. wrote:

...

This is how it displays in Rekall - correctly:

http://paste.opensuse.org/25141180

There was a standalone tool that became part of mysql-workbench that did a wonderful job before everything was wrapped up in the current mysql-workbench package (it's in OSS)

My only objection to the current package is that it has ballooned from a simple few hundred K viewer/editor to 134M of ??

I have 42.3 on a platter drive as well where storage isn't as critical. I'll give it a try when I get a chance. rekall is no lightweight (5M+ for recall and 21M+ for the inexplicable mandatory dependency of rekall-examples...)

Recall is perfect for my needs, although I have the feeling that the current incarnation in 42.3 has lost features. The problem is, it is for KDE3, and it doesn't exist a package for 15.0. So I have to migrate the tool before I upgrade the machine. mysql-workbench I don't remember, I don't have it installed, apparently. Installing mysql-workbench - A MySQL visual database modeling, administration and querying tool 87 MB libvsqlitepp3 - Well designed C++ sqlite 3.x wrapper library 200K proj - Cartographic projection software 5M The last two are automatic, by deps. Why "proj" I have no idea at all. proj - Cartographic projection software This package offers the commandline tools for performing respective forward and inverse transformation of cartographic data to or from cartesian data with a wide range of selectable projection functions. Tabooing it blocks installation of mysql-workbench, go figure. Running mysql-workbench warns "unsuported operating system" When I create a connection it says the server protocol (10.0.34) is not compatible, some features will not work. I say Ok, then it crashes: (mysql-workbench-bin:6603): glibmm-ERROR **: unhandled exception (type std::exception) in signal handler: what: error calling Python module function WbAdmin.autoDetectLocalInstance If I reuse an old connection for root (apparently I tried it years ago, the config must still be there) it connects. It displays: Title Author Nightfall 1 A taste for death 5 It does not display the linked table value for authors, instead displays the index number. How do I tell it that the field Autor is a number that must be searched in the table Autores, find the corresponding string, and display the string, not the number? Not only that, but if I create a new book entry it must display a droplist allowing me to choose the autor by name, not by number. A read-write linked table view. All this is done by rekall without a single line of code. I don't speak sql. Apparently years ago I created a view: 'NightFall', 'Isaac Asimov', 'SciFi' 'A taste for death', 'P.D. James', 'Misterio' ... Possibly someone told me what to write, because it is impossible I did it myself - unless done by some tool that presents a graphic editor then writes sql behind: CREATE ALGORITHM = UNDEFINED DEFINER = `cer`@`Telcontar.valinor` SQL SECURITY DEFINER VIEW `Biblioteca`.`View1` AS SELECT `Biblioteca`.`Libros`.`Titulo` AS `Titulo`, `Biblioteca`.`Autores`.`Autor` AS `Autor`, `Biblioteca`.`Generos`.`Generos` AS `Generos` FROM ((`Biblioteca`.`Libros` LEFT JOIN `Biblioteca`.`Autores` ON ((`Biblioteca`.`Autores`.`Indice` = `Biblioteca`.`Libros`.`Autor`))) LEFT JOIN `Biblioteca`.`Generos` ON ((`Biblioteca`.`Generos`.`Clave` = `Biblioteca`.`Libros`.`Genero`))) And yes, I can view those fields correctly, but it does not allow editing books. This is no use to me, uninstalling. -- Cheers / Saludos, Carlos E. R. (from 42.3 x86_64 "Malachite" at Telcontar)

On 06/23/2018 02:01 AM, Carlos E. R. wrote:

On 2018-06-23 08:58, Carlos E. R. wrote:

...

On 2018-06-23 07:42, David C. Rankin wrote:

...

Running mysql-workbench warns "unsuported operating system" ...

...

This is no use to me, uninstalling. Crashes with backtrace on exit. This tool is broken, I can't rely on it.

Man, that's tough. All of these tools used to work flawlessly. No problems, no crashes, but that was back in the Qt3 days. I do know once the editor/viewer was all wrapped up together in the current workbench package and moved to Qt4, I didn't like it as well, but it still worked. You could just click on the field and edit it. It was a breeze. It beat the heck out of 'update database.table set field='new value' where other-field like '%term', etc... Given the growing pains with Qt5, I'm not surprised. -- David C. Rankin, J.D.,P.E.