MySQL native connector - several databases retrieved?

users
#1

Hello team,
I currently installed a MariaDB base server as local host (version: :
5.3.3-MariaDB-rc-mariadb108~oneiric-log, installed from deb repositories)
and would like to connect it with LO as a GUI (Tom would likely to
appreciate.....)
For this, I installed the MySQL connector plug-in
('mysql-connector-ooo-1.0.1-linux-x86_64.oxt').
Connection set up: one existing database specified (this one being
completely empty) - with a user name having all rights on all databases in
this context.
Well, the connection worked fine, except that ALL existing MariaDB databases
got displayed in the table section, instead of the single one specified in
the connection set up; corresponding tables are listed below each db name.
I suppose that this was not the expected result ans I'm doubtful about
accessing simultaneously to all tables within all db.
Then the question is: what did I wrongly? How could I correct this, please?
I didn't go any further, for instance I did not test with a user having
access right only defined for the target db.
Thanks in advance for any hint or highlight!
(LO version in the signature)

#2

fmayo ,

Use the Tools >> Table Filter in the the odb document to choose the wanted -not wanted databases.

Greetz

Fernand

#3

Thanks very much for a so quick answer and guide line, Fernand.
Tried it, but this did not change displayed db/tables in any way (even after switching forth and back to queries or forms).

#4

Francois ,

for MySQL it works, but maybe you have to save the odb doc, close (who must close the connection) and reopen ?

Greetz

Fernand

#5

Thanks for the advice, Fernand. Good to know that it works fine with MySQL.
I tested it that way, even closing both the server and the Ubuntu session: no change.
So, as a general info to the community, when connecting Base to MariaDB thru MySQL native connector (1.0.1), it seems that all
db's within the targeted environment are reported in Base 'Tables' zone.
I will continue with testing this context and will report here new founding.
BTW, could someone drive me to some good LO+MySQL (or OO+MySQL) guide, tuto or forum, please?
Thanks in advance.

#6

Hi,

Thanks for the advice, Fernand. Good to know that it works fine with MySQL.
I tested it that way, even closing both the server and the Ubuntu session: no change.
So, as a general info to the community, when connecting Base to MariaDB thru MySQL native connector (1.0.1), it seems that all
db's within the targeted environment are reported in Base 'Tables' zone.

If you restrict your users' rights through the Tables/Columns privilege
in mysql, are these tables still visible when you re-start LO and
re-open the ODB ?

Alex

#7

Good point. I confirm that having user access privilege restricted to one single database only this one is displayed in the
tables area.
This seems to be a good workaround.
Format:
V Database name
           Table 1
           Table 2
            ......
Thanks Alex.

#8

Hi again,

Good point. I confirm that having user access privilege restricted to one single database only this one is displayed in the
tables area.
This seems to be a good workaround.
Format:
V Database name
            Table 1
            Table 2

If you want to be able to see all of the dbs again irrespective of the driver privileges, you could, instead of resetting them at mysql server level, try activating/deactiving the "Ignore Driver Privileges" option in the Connection > Advanced details of your ODB file (although I haven't tried this to see if it actually works).

Alex

#9

Thanks for the hint, Alex.
I gave it a try, but this action did not produce any visible effect on displayed dbs' (even with closing Base between each
action on this option).
Then, the ongoing solution for me is to have two distinct user profiles: one accessing to all db and an other one with access
rights restricted to the targeted db.
BTW, do you know of some guide, tuto,site or forum related to combined use of MySQL + Base ?
Thanks again for your support in Base area.

#10

Hi :slight_smile:
Perhaps this link?  I haven't read any of these tho :frowning:
http://wiki.services.openoffice.org/wiki/Connect_MySQL_and_Base
I'm not sure if the 'need' for java is still there.

http://user.services.openoffice.org/en/forum/viewforum.php?f=13&sid=6943ad59fc048d9c54a76bd69f7229cc

http://user.services.openoffice.org/en/forum/viewtopic.php?f=40&t=41292
http://www.webhosting.uk.com/forums/mysql-hosting/5591-connecting-mysql-openoffice-base-using-jdbc.html
Regards from
Tom :slight_smile:

#11

Hello Francois,

I believe that for the time being the absolute best location for
information is the one you have already found.

There is a Base user guide nearing completion, but it will not be
specific to MySQL connections.

There are some historical web sites that can be mined, but many of the
people that donated the most usable information there are now here.

Best wishes,

//drew

#12

Hi François,

Thanks for the hint, Alex.
I gave it a try, but this action did not produce any visible effect on displayed dbs' (even with closing Base between each
action on this option).
Then, the ongoing solution for me is to have two distinct user profiles: one accessing to all db and an other one with access
rights restricted to the targeted db.
BTW, do you know of some guide, tuto,site or forum related to combined use of MySQL + Base ?
Thanks again for your support in Base area.

Ah ok, wasn't sure anyway whether that option actually did anything, or
maybe I just misunderstood what it was supposed to do :wink:

If you speak/understand French, which I suspect you might from your
name, there are a few out there :

http://www.google.fr/url?sa=t&rct=j&q=openoffice.org%20base%20et%20mysql&source=web&cd=2&ved=0CCkQFjAB&url=http%3A%2F%2Fwww.openoffice.org%2Ffr%2FDocumentation%2FHow-to%2FBdd%2F05jdbc_mysqlfr-v2.pdf&ei=GIQZT9W5JILrOfGYiZcL&usg=AFQjCNHYrxzDz3noMW0VRrUbEFpbHgDITA&cad=rja

http://www.solix.info/spip/spip.php?article59

http://www.openoffice.org/fr/Documentation/How-to/indexht-base.html

http://forge.mysql.com/wiki/Connector_OpenOffice

http://valaurea.free.fr/documents/sig11_ooomysql_1.html

This link below points to the French OOo Base forum, but they will also
field questions about LibreOffice :

http://user.services.openoffice.org/fr/forum/viewforum.php?f=9&sid=c96475dd0faebf7e8ff1926dcfcabae4

The corresponding English OOo Base forums :

http://www.oooforum.org/forum/viewforum.phtml?f=10

http://user.services.openoffice.org/en/forum/viewforum.php?f=13&sid=4d3f693555f7ca2c615460430117d722

There is also more general stuff on the net about Base in English, not
least the User Guides produced by ODFAuthors and the LibreOffice
Documentation project :

http://www.odfauthors.org/openoffice.org/english/userguide3/db3/dbg3_draft

http://wiki.documentfoundation.org/images/6/68/0108GS3-GettingStartedWithBase.odt

So,yeah, you have to trawl around a bit, but there is stuff out there.

Alex

#13

Hi Frnaçois,

BTW, do you know of some guide, tuto,site or forum related to combined use of MySQL + Base ?
Thanks again for your support in Base area.

One more thing comes to mind : to get the best out of your connection to
a mysql server, you will find yourself writing and executing queries in
DirectSQL mode rather than with the graphical query designer as it is,
errm, how should I put it, a bit stuck in time (by that I mean, leagues
away in the past from where Access is today, or Lotus Approach, FMPro,
etc) when it comes to accessing the underlying server engine query
functionality. The same goes for "casual user friendly" Form design :wink:
just so you're forewarned :-))

Alex

#14

Hi :slight_smile:
Ahh yes i forgot there are some LibreOffice chapters but mostly only in draft
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
Probably not much different from the OOo guide as i suspect the same person/people is/are doing both. 
Regards from
Tom :slight_smile: