quasar accounting on ubuntu??

[Brian Walker]

Many thanks Shot

On 7/20/05, Shot - Piotr Szotkowski <shot at hot.pl> wrote:
> 
> Hello.
> 
> Brian Walker:
> 
> > brian at ubuntu:~$ psql -h localhost -U xxx template1
> >
> > psql: FATAL: IDENT authentication failed for user "xxx"
> 
> By default, PostgreSQL accepts only the user that tries to establish
> the connection - in your case you should be able to log in as brian
> (provided that you created the brian user in PostgreSQL before).
> 
> If you want to allow local connections as other users, you have to
> sudoedit the /etc/postgresql/pg_hba.conf file and change the "ident
> sameuser" method to "md5" for "All other connections by UNIX sockets"
> (and, possibly, for "All IPv4 connections from localhost" as well).
> 
> Remember to reload the settings afterwards
> with `sudo /etc/init.d/postgresql reload`.


Yes - I had to change the IPv4 as well, and then the connection worked. Now 
to the next problem .... digging today to sort this out once and for all. 

All the best

Brian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20050721/8c41836e/attachment.html>