[Spacewalk-list] fe_sendauth: no password supplied

[Patrick Hurrelmann]

On 07.03.2012 14:05, Jan Pazdziora wrote:
> On Wed, Mar 07, 2012 at 12:18:59PM +0100, Patrick Hurrelmann wrote:
>> CREATE FUNCTION
>>  create_varnull_constriants
>> ----------------------------
>>                           0
>> (1 row)
>>
>> psql:/var/log/spacewalk/schema-upgrade/20120307-112200-script.sql:5172:
>> ERROR:  could not establish connection
>> DETAIL:  fe_sendauth: no password supplied
>>
>> CONTEXT:  SQL statement "SELECT  dblink_connect('at_conn', 'dbname=' ||
>> current_database())"
> 
> I assume you get the same error when you run
> 
> 	select * from dblink('dbname=' || current_database(), 'select 1 + 2') as t(id integer) ;
> 
> in your psql.
> 
> What is in your /var/lib/pgsql/data/pg_hba.conf?
> 

Hi Jan,

yes, the result is the same and there is no difference whether unix
socket or tcp/ip is used.

% psql -d spacewalk -U spacewalk -h localhost
Password for user spacewalk: xxxx
psql (8.4.9)
Type "help" for help.

spacewalk=# select * from dblink('dbname=' || current_database(),
'select 1 + 2') as t(id integer) ;
ERROR:  could not establish connection
DETAIL:  fe_sendauth: no password supplied

spacewalk=# \q
% psql -d spacewalk -U spacewalk
Password for user spacewalk:
psql (8.4.9)
Type "help" for help.

spacewalk=# select * from dblink('dbname=' || current_database(),
'select 1 + 2') as t(id integer) ;
ERROR:  could not establish connection
DETAIL:  fe_sendauth: no password supplied


PostgreSQL is running locally and the content of pg_hba.conf is:

local   all         all                               md5
host    all         all         127.0.0.1/32          md5
host    all         all         ::1/128               md5

So, all connections need md5.

Regards
Patrick

-- 
Lobster LOGsuite GmbH, Hauptstraße 67, D-82327 Tutzing

HRB 178831, Amtsgericht München
Geschäftsführer: Dr. Martin Fischer, Rolf Henrich