Public bug reported: 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. I hope my report is in the right place https://lists.launchpad.net/libreoffice/msg00072.html ** Affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Tags: ppa -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1342755 Title: libreoffice-mysql-connector cannot create/edit tables over SSH tunnel from the internet To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1342755/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
