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]
