Hi Joerg,
* Joerg Budischewski <[EMAIL PROTECTED]> [180305, 22:21]:
>
> 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 the same.
> After having solved this, you are going to have a problem with the user
> authentication. Leave the "user=<your_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.
>
I did that: no different result ;(
Having a closer look at the postgres.log (and, maybe a better
understanding of what it says) I noticed that it doesn't record at all
the attempts I'm doing from OOo.
AAMOF, when I connect from the console ($ psql mydb), the postgres.log
registers the successfull connection with the row:
2005-03-19 01:25:00 [4325] LOG: connection authorized: user=ennio database=mydb
^^^^^^^^^^
which follows the various rows (two for each of my databases) saying:
2005-03-18 01:24:17 [5426] LOG: connection received: host=[local] port=
2005-03-18 01:24:17 [5426] LOG: connection authorized: user=postgres
database=odontolinux
^^^^^^^^^^^^^
So it seems that the sdbc driver is "not even knocking at postgres'
door" !
Any further suggestion will be appreciated.
Regards,
Ennio.
>
>
> Ennio-Sr wrote:
>
> > 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 the sdbc driver ?
> >>
> >
> > OOo-1.1.4: Tools > Data Sources; and then in the Dialog Box
> > General:
> > name > mydb
> > database_type > postgresql
> > data source URL > sdbc:postgresql:host=local user=real_name
> > or " " " " :host=localhost user=real_name dbname=mydb
> > and similar other combinations.
> >
> >
> >>Did you have a look at the postgres server log about the concrete error
> >>message of your authentication attempt ?
> >>
> >
> >
> > Yes, and it doesn't seem to give authentication errors. Here are a few
> > of its most significative lines:
> >
> > 2005-03-18 01:24:09 [5403] LOG: database system was shut down at
> > 2005-03-17 02:20:12 CET
> > 2005-03-18 01:24:09 [5403] LOG: checkpoint record is at 0/7B49508
> > 2005-03-18 01:24:09 [5403] LOG: redo record is at 0/7B49508; undo record
> > is at 0/0; shutdown TRUE
> > 2005-03-18 01:24:09 [5403] LOG: next transaction ID: 284222; next OID:
> > 59598
> > 2005-03-18 01:24:09 [5403] LOG: database system is ready
> > 2005-03-18 01:24:13 [5419] LOG: connection received: host=[local] port=
> > 2005-03-18 01:24:13 [5419] LOG: connection authorized: user=postgres
> > database=template1
> > [....same rows for other databases.....]
> > 2005-03-18 01:24:17 [5425] LOG: connection received: host=[local] port=
> > 2005-03-18 01:24:17 [5425] LOG: connection authorized: user=postgres
> > database=mydb
> > 2005-03-18 01:24:17 [5426] LOG: connection received: host=[local] port=
> > 2005-03-18 01:24:17 [5426] LOG: connection authorized: user=postgres
> > database=odontolinux
> >
> > Strange enough: I just tried to connect while the server was shut down
> > and received the same OOo error message I receive when postgresql is up:
> > "No connection could be established for the URL"
> > "sdbc:postgresql:host=local user=real_name"
> > "Please check the current settings, for example user name and passwd"
> >
> > Of course the password is the same password the user uses to log into
> > linux. [I'm using linux Debian/Sarge with kernel 2.4.27]
> >
> > Regards,
> > Ennio
> >
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
