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

[Nicolas L. <nla...@pe...>]

Yep, All the tables are in place. I'm using the included. dnhttpd server in
my home directory.

----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Thursday, August 02, 2001 7:54 AM
Subject: Re: DBD::Pg...what I need?


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