← Back to team overview

desktop-packages team mailing list archive

[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