https://bugs.freedesktop.org/show_bug.cgi?id=81430
Priority: medium
Bug ID: 81430
Assignee: [email protected]
Summary: libreoffice-mysql-connector cannot create/edit tables
over SSH tunnel from the internet
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.3.0.2 rc
Component: Database
Product: LibreOffice
Testing with Xubuntu 14.04 and with LibreOffice version
1:4.3.0~rc2-1ubuntu1~trusty0 from the pre-releases PPA.
Server Side:
------------
> CREATE DATABASE test;
> GRANT ALL PRIVILEGES ON test.* to 'dbuser'@'localhost' IDENTIFIED BY
> 'password';
> FLUSH PRIVILEGES;
dbuser performs all operations on databse test as expected.
Client Side:
------------
SSH tunnel established with:
$ ssh -L5000:server.example.com:3306 [email protected]
Manual connection test works well:
$ mysql -h 127.0.0.1 --port=5000 -u dbuser - p
dbuser performs all operations on databse test as expected.
Install and restart libreoffice:
$ sudo apt-get install libreoffice-mysql-connector
In LibreOffice, when I try to create a table, it reports the following error:
SQL Status: 42000
Error code: 1142
CREATE command denied to user 'dbuser'@'localhost' for table 'Capacity'
A quick search for the error codes indicates that I am logged into mysql with a
default null user with just about zero privileges.
I can read table content, but I cannot edit them in any meaningful way.
Workaround (JDBC):
------------------
Install and restart libreoffice:
$ sudo apt-get install libmysql-java
Configure:
* Tools -> Options -> LibreOffice -> Advanced
* tick Use a jre
** Select Oracle 1.7.0_55
* Click Class Path
** Add Archive /usr/share/java/mysql-connector-java.jar
* Restart LO (or maybe reboot, at first it did not work)
Now LibreOffice Base can edit a MySQL database over an SSH tunnel.
Bug submitted also with the packager as I am not sure where the problem lies:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1342755
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
