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=<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.
Bye,
Joerg
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
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
