Dave Barton ha scritto:
-------- Original Message --------
From: Marcello Romani <[email protected]>
To: [email protected]
Date: Mon, 12 Apr 2010 08:15:17 +0200
Dave Barton ha scritto:
I have installed the MySQL Extension For OOo Extension Version 1.0 in
OOo 3.2 and I have a working MySQL database called "testdb" in the
/var/lib/mysql directory.
Here are the steps I am using to try and connect to my database:
o Start Database Wizard.
o 1. Select "MySQL" from "Connect to an existing database".
o 2. Select "Connect directly".
o 3. Database name: testdb
Server: localhost
Port: 3306
o 4. User name: root
Password required: Checked
Click Test Connection
Enter the MySQL password and click OK.
Result:
SQL Status: HY000
Error code: 2002
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I get the same result running Base as either root or user.
I searched and read everything I can find on using this extension.
Can anyone suggest where I am going wrong.
TIA
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Ensure networking is enabled in MySQL. For security reasons, most
distros configure it so that it accepts connections only through the
unix socket (i.e., no tcp/ip connections are possible to the mysql server).
Otherwise, check that the path to the mysql socket is the same in the
mysql configuration and in OOo (I don't know how to check the latter
though, sorry.)
HTH
Thanks Marcello,
Yes, it did help. Commenting out "skip-networking" in /etc/my.cnf and
restarting mysqld got the extension working.
I am not sure if this opens up a security issue or not. While it's not
important for the local test machine I am running this on, I suggest
that anyone reading this thread should investigate the security
implications before enabling networking on a production machine.
Regards
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
I'm glad the issue is solved.
IMHO enabling mysql to accept network connections on its standard port
is not a security issue in itself. It all depends on where
(network-wise) the machine is located.
If it's a LAN, then probably it's a non-issue. On the other hand,
exposing a mysql server on the internet (i.e. on a public server) is
definitely not wise at all.
But this would bring us too far OT...
--
Marcello Romani
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
