Connecting BASE to MySQL database.

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.

Connecting BASE to MySQL database.

Postby pnommensen » Thu Dec 22, 2011 7:26 pm

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!
LibreOffice 3.4.4 on Windows 7
pnommensen
 
Posts: 1
Joined: Thu Dec 22, 2011 7:22 pm

Re: Connecting BASE to MySQL database.

Postby r4zoli » Thu Dec 22, 2011 8:05 pm

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

http://wiki.services.openoffice.org/wik ... L_and_Base
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Connecting BASE to MySQL database.

Postby rudolfo » Fri Dec 23, 2011 2:38 am

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.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
rudolfo
Volunteer
 
Posts: 1415
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany

Re: Connecting BASE to MySQL database.

Postby r4zoli » Fri Dec 23, 2011 2:40 pm

The internet only bug is on known issues (the driver works on local LAN):
http://wiki.services.openoffice.org/wik ... own_Issues
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Connecting BASE to MySQL database.

Postby mriosv » Sat Dec 24, 2011 3:19 am

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
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
mriosv
 
Posts: 650
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: Connecting BASE to MySQL database.

Postby rudolfo » Sat Dec 31, 2011 12:57 am

http://wiki.services.openoffice.org/wiki/Database/Drivers/ wrote:
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.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
rudolfo
Volunteer
 
Posts: 1415
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany


Return to LibreOffice

Who is online

Users browsing this forum: No registered users and 1 guest