[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-22 Thread Ennio-Sr
Hi Justin, please disregard my previous message of a couple hours ago: in the end I was able to connect, either with ODBC or SDBC. But still there are some doubts that I would possibly like to be clarified. * Justin Clift <[EMAIL PROTECTED]> [230305, 02:20]: > > >2005-03-21 00:37:48 [5241] FATAL:

Re: [dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-22 Thread Justin Clift
Ennio-Sr wrote: 2005-03-21 00:37:48 [5241] LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused 2005-03-21 00:37:48 [5241] FATAL: IDENT authentication failed for user "ennio" > Could it have something to do with the firewall? (I have an iptables but I havn

[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-22 Thread Ennio-Sr
Hi Joerg, finally something in the /var/post*/postgres.log! I tried from OOo :sdbc:postgresql:host=127.0.0.1 port=5432 and got this in the log: 2005-03-21 00:35:01 [5232] LOG: connection received: host=[local] port= 2005-03-21 00:35:01 [5232] LOG: connection authorized: user=postgres database=o

[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-20 Thread Ennio-Sr
Hi Joerg, I apologize for messing up the mailing of my last message: I'm getting your answers from gmane, forwarding them to my e-mail, editing, etc. [I sent a 'subscribe-me' mail to dev#openoffice.org yesterday but got no answer ;( ] * Joerg Budischewski <[EMAIL PROTECTED]> [190305, 21:21]: > Hi

[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-20 Thread Ennio-Sr
Hi Joerg, I apologize for messing up the mailing of my last message: I'm getting your answers from gmane, forwarding them to my e-mail, editing, etc. [I send a 'subscribe-me' mail a few hours ago but got no answer ;( ] * Joerg Budischewski <[EMAIL PROTECTED]> [190305, 21:21]: > Hi, > > >>is your

[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-20 Thread Joerg Budischewski
Hi, >>hat does a> >>netstat -a | grep PGSQL >> > > This yealds nothing ;( I think, this points to the source of the problem. You use the postgresql shipping with debian, can it be possible, that they patched the default connection path to something else ? Try a netstat -a | grep 5432 and when this

[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-19 Thread Joerg Budischewski
Hi, is your server configured to serve tcp/ip requests (-i option) ? If not, try leaving away the "host=local" phrase, the driver will then use unix domain sockets. OK, I commented out the tcp/ip option in hba.conf, left away all that follows the "sdbc:postgres:" string but the result is always

Re: [dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-19 Thread Joerg Budischewski
Hi, After having solved this, you are going to have a problem with the user authentication. Leave the "user=" phrase away, and hit the 'unnamed' tab within the data source dialog between General and Table, fill in your user name and check the "password required" flag. Can you explain why this i

Re: [dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-19 Thread Lawrence Harriott
Hi Joerg, On Fri, 2005-03-18 at 22:21 +0100, Joerg Budischewski wrote: > Hi again, > > is your server configured to serve tcp/ip requests (-i option) ? If not, > try leaving away the "host=local" phrase, the driver will then use > unix domain sockets. > > After having solved this, you are go

Re: [dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-18 Thread Joerg Budischewski
Hi again, is your server configured to serve tcp/ip requests (-i option) ? If not, try leaving away the "host=local" phrase, the driver will then use unix domain sockets. After having solved this, you are going to have a problem with the user authentication. Leave the "user=" phrase away, and

[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-18 Thread Ennio-Sr
Hi Joerg, thank you for answering my post. * Joerg Budischewski <[EMAIL PROTECTED]> [170305, 22:58]: > Hi, > > >I tried SDBC connection also and I'm getting the same error: complaining > >about user and password (that, of course, are correct). > How do you pass user and password currently with th

Re: [dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-17 Thread Joerg Budischewski
Hi, I tried SDBC connection also and I'm getting the same error: complaining about user and password (that, of course, are correct). How do you pass user and password currently with the sdbc driver ? Did you have a look at the postgres server log about the concrete error message of your authentica

[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-17 Thread Ennio-Sr
* Marc Santhoff <[EMAIL PROTECTED]> < > [2005-03-11]: > > [...cut...] > > Try "isql" from the ODBC-package and see if it can connect. If not, > check your odbc configuration. > > [...cut...] --- My first attempt with isql was not successful. May be I must clear some configuration mess: I