pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Debian Package problems
4+ messages / 2 participants
[nested] [flat]

* Debian Package problems
@ 2001-04-13 15:00  Roberto Mello <rmello@cc.usu.edu>
  0 siblings, 2 replies; 4+ messages in thread

From: Roberto Mello @ 2001-04-13 15:00 UTC (permalink / raw)
  To: pgsql-sql

	Does anybody know what's going on with the Debian 7.1 RC4 packages? It
will not let me create any users or even talk to the backend.
	If I try to create a user (as user postgres), it asks me for a
password, but it's not the UNIX password because I tried that (I changed
the password right after I installed the packages).
	If I try to connect through psql, it asks me for the password again.
It looks like it's using password auth instead of ident auth, which used
to be the default.
	There's nothing pointed in the packages web pages, a caveat or
anything. I've looked.

	Thanks,

	-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
Ad astra, per ardua nostra.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Debian Package problems
@ 2001-04-13 15:22  Roberto Mello <rmello@cc.usu.edu>
  parent: Roberto Mello <rmello@cc.usu.edu>
  1 sibling, 1 reply; 4+ messages in thread

From: Roberto Mello @ 2001-04-13 15:22 UTC (permalink / raw)
  To: pgsql-sql

On Fri, Apr 13, 2001 at 09:00:45AM -0600, Roberto Mello wrote:

> 	If I try to connect through psql, it asks me for the password again.
> It looks like it's using password auth instead of ident auth, which used
> to be the default.
> 	There's nothing pointed in the packages web pages, a caveat or
> anything. I've looked.

	Okay, I feel dumb now. 
	It looks like Oliver Elphick (the package maintainer) changed the
default authentication methods. Before local users were "trust" now they
are "password". 
	Thing is, if it's password, how do you know the password for user
postgres?
	This (a note) should be in the package pages, or at least told the user 
during upgrade.

	-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
Go FORTH and C PASCAL play COBOL with an APL.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Debian Package problems
@ 2001-04-13 15:46  Oliver Elphick <olly@lfix.co.uk>
  parent: Roberto Mello <rmello@cc.usu.edu>
  0 siblings, 0 replies; 4+ messages in thread

From: Oliver Elphick @ 2001-04-13 15:46 UTC (permalink / raw)
  To: Roberto Mello <rmello@cc.usu.edu>; +Cc: pgsql-sql

Roberto Mello wrote:
  >On Fri, Apr 13, 2001 at 09:00:45AM -0600, Roberto Mello wrote:
  >
  >> 	If I try to connect through psql, it asks me for the password again.
  >> It looks like it's using password auth instead of ident auth, which used
  >> to be the default.
  >> 	There's nothing pointed in the packages web pages, a caveat or
  >> anything. I've looked.
  >
  >	Okay, I feel dumb now. 
  >	It looks like Oliver Elphick (the package maintainer) changed the
  >default authentication methods. Before local users were "trust" now they
  >are "password". 
  >	Thing is, if it's password, how do you know the password for user
  >postgres?
  >	This (a note) should be in the package pages, or at least told the user
      > 
  >during upgrade.
 
Noted.


If you do

 export PGHOST=localhost

you will be able to connect without a password, using the default method.
-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "I sought the LORD, and he heard me, and delivered me 
      from all my fears."    Psalms 34:41 





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Debian Package problems
@ 2001-04-13 15:50  Roberto Mello <rmello@cc.usu.edu>
  parent: Roberto Mello <rmello@cc.usu.edu>
  1 sibling, 0 replies; 4+ messages in thread

From: Roberto Mello @ 2001-04-13 15:50 UTC (permalink / raw)
  To: Stan Brown <stanb@awod.com>; +Cc: pgsql-sql

On Fri, Apr 13, 2001 at 11:38:18AM -0400, Stan Brown wrote:
 
> 	I don;t have a clue. But I also am having fits with the Debian package for
> 	"stable" It installs fine, and then I su to postgres. At that point in time
> 	psql will connect, but createuser fails :-(
> 
> 	I would be interested in what yu find out.

	I changed /etc/postgresql/pg_hba.conf so that local users are "trust"
again (instead of password).
	You are looking for this line (already changed):

local        all                                            trust

	That's probably not the safest way, but now that I can do something
(because postgres can actually talk to the DB), I will change it back to
password. 

> Windows 98: n.
> 	useless extension to a minor patch release for 32-bit extensions and
> 	a graphical shell for a 16-bit patch to an 8-bit operating system
> 	originally coded for a 4-bit microprocessor, written by a 2-bit 
> 	company that can't stand for 1 bit of competition.

	:) Remarkably accurate!

	-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
C program run.  C program crash.  C programmer quit.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-04-13 15:50 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-13 15:00 Debian Package problems Roberto Mello <rmello@cc.usu.edu>
2001-04-13 15:22 ` Roberto Mello <rmello@cc.usu.edu>
2001-04-13 15:46   ` Oliver Elphick <olly@lfix.co.uk>
2001-04-13 15:50 ` Roberto Mello <rmello@cc.usu.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox