desktop-packages team mailing list archive
-
desktop-packages team
-
Mailing list archive
-
Message #129274
[Bug 833741] Re: libreoffice base problem connecting mysql with various schema
does this ever occur in trusty or later?
** Changed in: libreoffice (Ubuntu)
Status: New => Incomplete
** Changed in: libreoffice (Ubuntu)
Assignee: (unassigned) => Rolf Leggewie (r0lf)
** Tags added: base
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/833741
Title:
libreoffice base problem connecting mysql with various schema
Status in libreoffice package in Ubuntu:
Incomplete
Bug description:
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.
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/833741/+subscriptions
References