NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.

Forum Discussion

daniele76's avatar
daniele76
Aspirant
Sep 18, 2015

Using ReadyNAS 102 as MySQL with LibreOffice direct connector

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

NETGEAR Academy

Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology! 

Join Us!

ProSupport for Business

Comprehensive support plans for maximum network uptime and business peace of mind.

 

Learn More