Re: [HACKERS] Authentication Woes

On Tue, 20 Jan 1998, James Hughes wrote:

>
>
> On Tue, 20 Jan 1998, The Hermit Hacker wrote:
>
> >
> >     v6.1.0 would have used TCP/IP for communications exclusively...
> > v6.3 moved to using Unix Domain Sockets as default, with TCP/IP disabled
> > by default.  To "mirror" the old behavior, add the -i option to your
> > startup script and youshould be okay...
> >
> >
>
> OK, I should have said that the only way I can run psql is after making
> an entry in pg_hba.conf to enable passwords, starting the postmaster
> with the "-i" option then using the "-u" option with psql. The
> createuser and createdb scripts will not run regardless.
>
> Maybe I have other problems?? I am going to dig a little bit deeper :)

I have the same problem with 6.2.1. Authentication using passwords works,
but createuser (and probably the other scripts) fail. 'createuser -a
password' fails to use -u to actually ask for username/password. To
prevent having to type this 10 times during createuser, you could get it
from the script and then do 'echo "username\npassword" | psql ...'. I
tried this on another program (one of mine which uses the
prompt_for_password function from psql) and it works.

Maarten

_____________________________________________________________________________
|     Maarten Boekhold, Faculty of Electrical Engineering TU Delft,   NL    |
|           Computer Architecture and Digital Technique section             |
|                          M.Boekhold@et.tudelft.nl                         |
-----------------------------------------------------------------------------