pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDebian 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