Re: [Netdisco] PostgreSQL permission problem??

[Max B. <ma...@wa...>]

Hi Brandon,

Please see this document.

http://www.postgresql.org/docs/7.4/interactive/client-authentication.html

Try opening up all permissions with : 

> # Allow any user on the local system to connect to any database under
> # any user name using Unix-domain sockets (the default for local
> # connections).
> #
> # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
> local   all         all                                             trust

Make sure to fully restart postgres to make it swallow the newe changes.
You should not have to touch your firewall unless it's firewalling the
localhost interface.

-m

On Fri, Oct 14, 2005 at 01:58:10PM -0400, Brandon Molnar wrote:
> Hi Alan,
> I'm running PostgreSQL 7.4.8   I added that line in my pg_hba.conf, reloaded PostgreSQL and it still didn't seem to work.  Is there a certain port I should allow on my firewall eventhough everything is running on the same server?
> 
> I double-checked netdisco_apache.conf and netdisco.conf and the password lines for both are the same.
> 
> I've got Webmin installed and can look at the granted privileges for the databases.  For some reason, I don't see any changes made after I update my pg_hba.conf file from the INSTALL doc OR from the line you just had me add.  I reload PostgreSQL after every change to pg_hba.conf  Any other way to give thet netdisco user full access to the netdisco database?
> 
> Brandon
> 
> 
> >>> <A.L...@lb...> 10/14/05 01:07PM >>>
> Hi,
> 
> > When I try to access /netdisco/ my Apache error_log shows:
> > [Fri Oct 14 10:26:45 2005] [error] DBI connect('dbname=netdisco','netdisco',...) failed: FATAL:  IDENT authentication failed for user "netdisco"\n at /usr/lib/perl5/vendor_perl/5.8.5/Apache/Session/Store/Postgres.pm line 47\n\t(in cleanup) DBI connect('dbname=netdisco','netdisco',...) failed: FATAL:  IDENT authentication failed for user "netdisco"\n at /usr/lib/perl5/vendor_perl/5.8.5/Apache/Session/Store/Postgres.pm line 47\n\nStack:\n  [/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm:874]\n  [/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm:814]\n  [/usr/local/netdisco/netdisco_apache.conf:48]\n  [/dev/null:0]\n
> > When I ran /usr/local/netdisco/netdisco -u admin as root, I got this error:
> > DBI connect('dbname=netdisco','netdisco',...) failed: FATAL:  IDENT authentication failed for user "netdisco"
> >  at /usr/local/netdisco//netdisco.pm line 1000
> > Can't connect to DB. FATAL:  IDENT authentication failed for user "netdisco"
> > 
> > But, when I su 'd to netdisco and ran it, it worked fine.  This is why I think it must be a permission error in PostgreSQL somewhere.  I changed the apache configs so then password was correct in all the files Netdisco uses, but I'm still getting errors.
> 
> you've not set the passwords right somewhere or your postgresql (what version?)
> doesnt like the ident (firewall rules)? try the following int he pg_hba.conf
> 
> local   netdisco        netdisco        md5
> 
> alan
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Netdisco mailing list
> net...@li...
> https://lists.sourceforge.net/lists/listinfo/netdisco-users