Re: DBI

[Richard L. <ri...@th...>]

On Wednesday 02 January 2002 20:09, you wrote:
> Although the following steps are for SuSE 7.3, I believe some of the 
> details may help you get through the installation on Red Hat, as well:

Well...  This was timely as I was stuck about there.  BUT:  RedHat is 
different.  As far as I have discovered the differences are:

 
 INSTALLATION INSTRUCTIONS: 
 PostgreSQL and Perl DBD on RH7.1 versus SuSE 7.3
 
> 1. <snip> instead of YaST2, RH has

RPMs: postgresql-devel-7.0.3-8.i386.rpm  (I needed this cos of deps.)
      perl-DBD-Pg-0.95-1.i386.rpm
      perl-DBI-1.14-10.i386.rpm (thanks to those here who pointed 
                                  me to these)
RPMs installed for me quite happily (I had already installed 
postgresql).


> 2. Setup directories and paths for PostgreSQL:
> 
> su -     (change to root)               ;
>                                         ; I didn't need to do
>   Setup disk directory for your db:     ; all this -- the directory
> # mkdir /var/lib/pgsql/data             ; was already there and 
> # chown postgres /var/lib/pgsql/data    ; chowned (I suppose by rpm)

> - Put PostgreSQL path /usr/bin/psql     ; not sure abt this. RH has
> into PATH in /etc/profile.local         ; no /etc/profile.local. There
                                          ; is /etc/profile, but I opted
                                          ; not to fiddle with this     
                                          ; shell script unless it      
                                          ; proves necessary.
 
> 3. Initialize the database, start it, and test it:
> 
> # /usr/local/pgsql/bin/initdb -D /var/lib/pgsql/data ; it wouldn't
                                                       ; let me: db
                                                       ; already exists

> # rcpostgresql start                    ; in RH that is (I believe)
                                          ; # service postgresql start

>   Quick-test the server:
> # su postgres                           ; something very similar was
> > psql -d template1                     ; fine on my RH system
>   \q to exit psql

>   Setup another db user:
> > createuser <db-user>     <snip>       ; no problem here either 
 
> 4. Verify the existence of the following, 
> which are required for the DBD:
> 
> - /usr/include/pgsql/libpq-fe.h         ; I don't have this
> - /usr/lib/libpq.so                     ; I do have this
> 
> 5. Download DBD <snip>                  ; already done as rpm         
        
> 6. to 9. <large snip>                   ; not relevant, therefore

So it looked as though I had it easier than those with SuSE in this 
instance.  BUT (there is always a 'but'...)
               When I try to connect to 
               http://localhost/sql-ledger/admin.pl
               I get "Error.  Permission denied: users/members"

So something ain't right yet.  Anyone help me out here?

--
richard