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

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

On Wed, 1 Aug 2001, Nicolas Lafferty wrote:

> Well. I ran the nifty lil script. I gave me the feedback "posgres" Does that
> mean that it's working fine?

Roger that!  So that means that the problem lies in the web server
itself - most likely.

If you run this from a shell prompt:

psql -c "\d" DBNAME

where DBNAME is the name of the database into which you installed
sql ledger, you will see table names like:  ar ap tax
and so on.  If these tables are present then we have ruled out
Pg and Perl DBI being the problem and we zoom in on the web server.

> ----- Original Message -----
> From: "Thomas Good" <to...@ad...>
> To: <sql...@li...>
> Sent: Wednesday, August 01, 2001 4:02 PM
> Subject: Re: DBD::Pg...what I need?
> 
> 
> > On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> >
> > > Well. I have DBI installed. And Pg. Still no dice. See my just posted
> > > Subject "Pg not the problem" on the list. Hrmph. This is driving me
> nuts.
> >
> > So, I'm unclear.  Can you connect to Pg using DBI at all?
> > If not sure save the following as test.pl, make executable (chmod 755
> test.pl)
> > and run it from the shell prompt: ./test.pl
> >
> > #!/usr/bin/perl
> > use DBI;
> >
> > $dbh = DBI->connect("dbi:Pg:dbname=template1", '', '') || die
> "$DBI::errstr";
> > $query = qq |select usename from pg_user|;
> > $sth=$dbh->prepare($query);
> > $sth->execute || die "$DBI::errstr";
> > @row=$sth->fetchrow_array;
> > $sth->finish;
> > $dbh->disconnect;
> >
> > print "\n@row\n\n";
> >
> >
> >
> 
> 


--------------------------------------------------------------------
               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...             */
--------------------------------------------------------------------