Connecting BASE to MySQL database.

[pnommensen]

Hello everyone!

I'm trying to get my MySql database connected with Libre Office Base. I tried all three MySql settings (Native....) and had no luck. I'm positive that the database name and password is correct. The hostname is set to mysql.mydomain.org.

The error I'm getting is no SDBC driver found.

I am using dreamhost.

I was wondering if there's a guide somewhere out there - like step by step?

Many thanks!

[r4zoli]

Native driver works only in local connection, use JDBC connectors in connections over the internet.

http://wiki.services.openoffice.org/wik ... L_and_Base

[rudolfo]

Zoltan, do you have any references or pointers for this limitations of the native sdbc driver? I am sure it works over the network, because I use it in my LAN. But maybe your "local connection" doesn't mean "only localhost connections". The only thing I am aware of is that at least version 5.1 is required on the server side.
I can't see any reason why the sdbc driver should use something else apart from the typical tcp port 3306 to make the connection. So the only requirement would be to keep this port open in the outgoing firewall. But that's the same in case of JDBC.

[r4zoli]

The internet only bug is on known issues (the driver works on local LAN):
http://wiki.services.openoffice.org/wik ... own_Issues

[mriosv]

I think is a problem in LibO 3.4 and above, also with access databases, seems that SDBC drivers weren't shipping in this versions of LibreOffice.
Look in this reported bug: https://bugs.freedesktop.org/show_bug.cgi?id=35673

[rudolfo]

Accessing non-intranet servers by IP address might fail
If you set up a connection to a MySQL server outside your intranet, which is known by IP address, this might fail with an error code of 10060, effectively saying "Can't connect". The problem is not fully analyzed, yet, so the problem description here is somewhat rough at the moment.

This is the statement that r4zoli referenced in his post above. I have to fully agree with the might fail, because I had no problems to connect to my tables via the internet (including a NAT router doing port forwarding at the last hop) both via a DNS name and directly via the IP address.
And as far as I understand this, the failures should not happen if you use a hostname that is resolved via DNS or via the local /etc/hosts file. If you have admin privileges on your local computer you can always add an entry to the host file that enables you to specify the SQL connection with a hostname if you got failures with IP addresses in the connect string.