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 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. > Can you explain why this is? I am referring to this matter of authentication you just addressed. Assuming that the user name, password and permissions are set, then why is this procedure necessary, at least in some cases?
Lawrence > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
