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
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
- [libreoffice-users] any working howto for accessing mysql/mariadb from libre office? · M. Fioretti
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.