Date: Wed, 05 Dec 2007 09:57:46 +0000 From: "O. Hartmann" <ohartman@zedat.fu-berlin.de> To: freebsd-openoffice@freebsd.org Subject: OpenOffice 2.3, PostgreSQL 8.2, postgresql-odb: not working! Message-ID: <4756761A.1010408@zedat.fu-berlin.de>
next in thread | raw e-mail | index | archive | help
Hello all. First, please reply also to my eMailaddress as I'm not member of this list. Thank you very much in advance. I run a bunch of FreeBSD 7.0-BETA4 boxes, all with OpenOffice 2.3, PostgreSQL 8.2 and postgresql-odbc (all most recent builds from the ports). My databases are about to migrate from MySQL to PostgreSQL and if this has been done, MySQL is about to be deleted. On MySQL connections from OpenOffice of any kind in conjunction wih the mysql-connector-odbc (unixODBC based) works well with the MySQL 5.0 server backend. But with PostgreSQL I have much trouble! When building postgresql-odbc with iODBC as standard in the port, connections do fail at the base, even with global odbc.ini/odbcinst.ini and ~/.odbc.ini. I rejected iODBC and installed postgresql-odbc with unixODBC instead (it is much better documented). I try to access a database from OpenOffice choosing ODBC with both MySQL and PostgreSQL and proper settings for the data sources in my ~/.odbc.ini, but with connections to PostgreSQL I receive an empty errorlike box (with MySQL, in a similar box is the Error-Message from the underlying ODBC driver presented, but this one is without text and only OK button present). Connections never succeed. Even with a proper setup of users in PostgreSQL or with a loose bunch of users able to connect from everywhere without passwords it does not work and drives my crayzy :-( Connecting from localhost and remotely host via 'psql' client works well, so I suspect the ODBC driver is faulty, somehow. OpenOffice Howtos, both in English and German, do have a kind of tutorial how to connect to Postgres via ODBC and I wonder this works for all of us working with FreeBSD/PostgreSQl/OpenOffice. I also have another PostgreSQL server, running our databases at the facility on a CentOS driven server system, PostgreSQL 8.1 and this also drops every attempt to connect, even I can connect to this server with pgAdmin and psql, either. So, what is wrong? Am I a kind of blocked, stupid or something? I appreciate any help and hint and would present config files if necessary. Thanks, Oliver
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4756761A.1010408>