MySQL JDBC connector for Ubuntu 20.04 Bug?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

MySQL JDBC connector for Ubuntu 20.04 Bug?

Postby dls123 » Mon Nov 16, 2020 10:01 pm

I've just setup a Ubunto 20.04 WAMP system in a Proxmox VM. I have installed OpenOffice 4.1.7 with the relevant MySQL JBDC connector to allow Base to be used as a front end for MySQL server. The system works well with no connection problems so far other than:

A user (OrderSys) is setup with access and privileges for just the order database.
However when logged in to Base as OrderSys with connection to the order database, both the order database and the information_schema database are shown under Tables.

Surely only the order database should show with its tables? Is there any way to get rid of information_schema database a this makes it vulnerable.

Has anyone else experienced similar problems?

Many thanks
Open Office 4.1.1 on Windows 8.1
dls123
 
Posts: 8
Joined: Tue Dec 08, 2015 9:38 am

Re: MySQL JDBC connector for Ubuntu 20.04 Bug?

Postby Villeroy » Tue Nov 17, 2020 11:49 am

Awkward issue with MySQL on Ubuntu: viewtopic.php?f=13&t=98371 (you have to be system root to create a db admin account)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30153
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: MySQL JDBC connector for Ubuntu 20.04 Bug?

Postby Villeroy » Tue Nov 17, 2020 12:08 pm

And you have to set up the JDBC driver path under Tools>Options>"Advanced" (or "Java") [Class Path...] which is /usr/share/java/mysql-connector-java.jar on my system.
I strongly recommend to use LibreOffice on a Linux system. Everything is installable painlessly from distribution packages.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30153
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: MySQL JDBC connector for Ubuntu 20.04 Bug?

Postby dls123 » Tue Nov 17, 2020 9:26 pm

Thanks for the reply. Understood.... Trouble is I have many templates, forms, queries, reports etc setup in open office. would this all be completely and easily transferable?
Open Office 4.1.1 on Windows 8.1
dls123
 
Posts: 8
Joined: Tue Dec 08, 2015 9:38 am

Re: MySQL JDBC connector for Ubuntu 20.04 Bug?

Postby Villeroy » Wed Nov 18, 2020 12:10 am

Yes.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30153
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 0 guests