Re: DBD::Pg...what I need?

[Thomas G. <to...@ad...>]

On Wed, 8 Aug 2001, Nicolas Lafferty wrote:

> What if authentication is required by postgres?

Is Pg using host based authentication?  Postgres doesn't require
authentication out of the box, even on redhat where install is
done using canned RPMs.  So if you have it turned on we can
temporarily turn it off and see if this is the snag.

In your data directory (/var/lib/pgsql on redhat) look at your
pg_hba.conf file.  If the only uncommented lines are the last
two then you don't need pg's host based user authentication.
(See man pg_passwd for more info on hba)

BTW, what web browser are you using?  Let's see if you can trap any
error messages.  I'm basically working blind...it would help if we
got one of the players to complain a little bit.

check out /var/lib/pgsql/pg_hba.conf and if it is not using
hba, edit your users/nick.config:

You can use admin.pl to do the same thing, if you prefer.

> > >   dbpasswd => '\'87)T-&%L;```',     #### remove btwn '' 
> > >   dbport => '5432',
> > >   dbtty => '',
> > >   dbuser => 'nick',                 #### same here

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------