libreoffice base problem connecting mysql with various schema

[Dario Sepulveda]

I use Ubuntu 64bit 11.04 and Libreoffice Base 3.3.3 and mysql 5.1.54
I have 4 different schema in mysql, each with different tables.
In LOB I use a form combining tables from different schema for data input.
I use native mysql connector, from LOB to connect to mysql server, specifying no database name, thus from LOB I had access to all schemas and their corresponding tables.
The mysql server runs in the same computer as LOB, thus the connection is to "localhost".
After updating (which solved a tremendous problem with forms in Base) I receive a message of:
SQL status: 42000
Error Code: 1049

Unknown database 'localhost:3306'

When opening the forms in LOB (which worked perfectly before!)

I found that changing the connector to mysql (JDBC) and back to mysql (native) I am able to see all schema and tables as before.

[Bryan Quigley (bryanquigley)]

Thank you for reporting this bug to Ubuntu. This Ubuntu release has reached EOL for Desktops.
See this document for currently supported Ubuntu releases: https://wiki.ubuntu.com/Releases

Please upgrade to the latest version and re-test. If the bug is still reproducible, please note that and set the status back to New.

Do feel free to report any other bugs you may find.

[Rolf Leggewie (r0lf)]

does this ever occur in trusty or later?

[Rolf Leggewie (r0lf)]

We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to "New". Thanks again!