Re: Access Problem After Version Upgrade -- Update

looks like perl/DBD::Pg is looking for libpq.so.3 but postgresql 8.1.X supplies libpq.so.4. You need to rebuild DBD::Pg
to get this to work (atleast that is what I have been doing for my upgrades from 7.4.X to 8.1.2)

Jim

---------- Original Message -----------
From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: Doug McNaught <doug(at)mcnaught(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Sent: Thu, 26 Jan 2006 09:30:05 -0800 (PST)
Subject: Re: [GENERAL] Access Problem After Version Upgrade -- Update

> On Thu, 26 Jan 2006, Doug McNaught wrote:
>
> > That's a webserver error usually meaning a CGI script crashed or gave bad
> > output. Look in the webserver error log file to see what happened.
>
> Doug,
>
> Sigh. All I see there are references to SQL-Ledger scripts not finding
> libraries (which are installed where SQL-Ledger is looking for them), and
> it's login.pl script failing to run. When I posted on that mail list, Dieter
> pulled the thread and wrote me an angry message that SQL-Ledger is not
> broken, but PostgreSQL is.
>
> The postmaster is running, and I (as an individual) can now see what
> databases are there. So, that permission error on the socket is fixed and it
> looks like postgres is doing just what it should be doing.
>
> Dieter Simander tells me there's nothing wrong with SL. Here's
> /var/log/apache/error_log:
>
> [Thu Jan 26 08:59:36 2006] [error] [client 127.0.0.1] Premature end of script headers: /usr/local/sql-ledger/login.pl
> install_driver(Pg) failed: Can't load '/usr/lib/perl5/site_perl/5.8.7/i486-linux/auto/DBD/Pg/Pg.so' for module
> DBD::Pg: libpq.so.3: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.7/i486-
> linux/DynaLoader.pm line 230. at (eval 8) line 3 Compilation failed in require at (eval 8) line 3. Perhaps a
> required shared library or dll isn't installed where expected at SL/User.pm line 116 Compilation failed in
> require at /usr/local/sql-ledger/login.pl line 92.
> [Thu Jan 26 09:03:29 2006] [error] [client 127.0.0.1] Premature end of script headers: /usr/local/sql-ledger/login.pl
>
> Now, when I point firefox at:
> http://eia.appl-ecosys.com/webcollab-1.70/index/php
>
> Up comes the Webcollab login page and I can log in.
>
> This suggests to me that there's nothing wrong with apache (httpd), either.
>
> Checkmate.
>
> Thanks,
>
> Rich
>
> --
> Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental
> Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic"
> <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
------- End of Original Message -------