any working howto for accessing mysql/mariadb from libre office?

[M. Fioretti]

(already sent also to users at global.libreoffice.org)

Greetings,

as per subject. I have a Fedora 20 x86_64 box here, running LO
4.2.5.2, with all updates installed.

NONE of the official howtos, forums, whatever around contains a
usable, step by step description of what should be done to connect
Base to a local mariadb / mysql database which is running and already
accessible from the same computer, both from the command line and from
php through the local web server. The closest I've got, AFTER already
doing plenty of searches for any variant of mysql, libre office and
the several error messages below, is:

(configuring the 
connect to existing database mysql
connect using jdbc

database name: mydb

server: localhost

port number 3306

MySql JDBC Driver class:

com.mysql.jdbc.Driver (and when I click on "Test Class" I get "the
      	   	  	jdbc driver was loaded successfully")

user name marco, password required yes

Then I click on "Test Connection" I get 

SQL Status: 08S01
Communications link failure

the last packet sent successfully to the server was 0 milliseconds
ago. The driver has not received any packets from the server.

I get this on the command line where I had launched lo:

Exception in thread "Thread-26" java.lang.NoClassDefFoundError: com/jdbc/mysql/Driver
Caused by: java.lang.ClassNotFoundException: com.jdbc.mysql.Driver
       at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
       at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
       at java.security.AccessController.doPrivileged(Native Method)
       at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
       at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:358)

from http://stackoverflow.com/questions/15827547/java-lang-classnotfoundexceptioncom-mysql-jdbc-driver

I read that that message means "problem is not in the code, but you don't have added the driver to your project!!! You have to add the *.jar driver to your project... "

but I HAVE added in Options->ADvanced the class path
/usr/share/java/mysql-connector-java.jar. Maybe the problem is that
this LO (as packaged by Fedora, that is) is using JRE 1.7.0_60 by
ORACLE?

Also, adding ?autoReconnect=true to the database name, as some of the
many howtos and forums I already read, doesn't change anything.

What now? First I thought the problem could be on the fedora side
(maybe something in selinux/firewall) but why would it work both on
the command line and on http/php from the same machine? that's why I
am also asking here.



   TIA,
   Marco

-- 

M. Fioretti http://mfioretti.com                   http://stop.zona-m.net

Your own civil rights and the quality of your life heavily depend on how
software is used *around* you

----- End forwarded message -----

-- 

M. Fioretti http://mfioretti.com                   http://stop.zona-m.net

Your own civil rights and the quality of your life heavily depend on how
software is used *around* you