Using ReadyNAS 102 as MySQL with LibreOffice direct connector

daniele76 · ‎2015-09-18

Hello guys, I recently bought a ReadyNAS 102 and I'm was wondering if I could use it to store a MySQL database (the answer in yes), managing it with Libre Office Base (the answer is: I hope)

I'm working with Xubuntu 14.04 and LibreOffice 4.2.8.2, I already installed phpMyAdmin on the NAS and, on my PC, the extension MySQL Connector from here http://extensions.libreoffice.org/extension-center/mysql-native-connector

in phpMyAdmin I created the database my_dbase, giving to the user guest all the privileges. My NAS has a static DNS like: 192.168.1.50.

Then, I followed this guide: https://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0

The problems start since: Setting up database connection

Name of the database: my_dbase

Host: 192.168.1.50 (or localhost?)

Port: 3306

Socket: no idea if I have to use it and how...

I try to connect as guest, with the guestpassword I choose and the result is:

Can't connect to MySQL at 192.168.1.50 (111)

If I use port 7082, the same as for php, the answer takes mor time and it's:

lost connection to MySQL server at 'reading initial communication packet', system error:0

Any idea how to set it in a proper way?

Thank you very much!

Daniele