From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-php@postgresql.org
Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 [UPDATE]
Date: Fri, 8 Apr 2011 07:02:09 -0700 (PDT)
Message-ID: <alpine.LNX.2.00.1104080700260.20437@salmo.appl-ecosys.com> (raw)
In-Reply-To: <alpine.LNX.2.00.1104070900530.397@salmo.appl-ecosys.com>
References: <alpine.LNX.2.00.1104070900530.397@salmo.appl-ecosys.com>
On Thu, 7 Apr 2011, Rich Shepard wrote:
> I'm migrating our Web site to CMS Made Simple, it worked here with
> postgres-8.4, but stopped working when I upgraded to postgres-9.0.0 (and I'm
> now running 9.0.3). This is with php-5.2.17 on Slackware-13.1. I need help
> since I don't know PHP or ADOdb.
Everyone:
I _think_ that I found the source of the problem, but I cannot seem to
get it fixed. When I looked more closely this morning at the configuration
section of the phpinfo() output I saw that the database was specified as
'postgreql-shared' and 'pdo-postgresql-shared'. I had done that a couple of
days ago when I re-built 5.2.17, then discoverdd that the actual name php
wants is 'pgsql.' So, I changed the options in the SlackBuild script to
reflect that:
--with-pgsql=shared,/usr \
--with-pdo-pgsql=shared,/usr \
and rebuilt the package. I then upgraded the installed package. However,
phpinfo() still showed
...ldap=shared' '--enable-mbstring=shared' '--enable-hash'
'--with-mhash=shared,/usr' '--with-postgresql=shared,/usr'
'--enable-pdo=shared' '--with-pdo-postgresql=shared,/usr' '--with-...
in the configure command section at the very top of the page.
Hmmm-m-m-m. So, just now I removed the package completely, rebuilt and
re-installed it. But, phpinfo() _still_ shows 'postgresql' rather than
'pgsql' and in the pdo section of the page only sqlite is shown. My
application still does not run.
The issue now is how to get rid of whatever phpinfo() is seeing so that it
can see (and use) the proper reference to the database. Why would phpinfo()
show the incorrect string if the configure options are correct?
Any ideas?
Rich
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: rshepard@appl-ecosys.com
Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 [UPDATE]
In-Reply-To: <alpine.LNX.2.00.1104080700260.20437@salmo.appl-ecosys.com>
References: <alpine.LNX.2.00.1104070900530.397@salmo.appl-ecosys.com> <alpine.LNX.2.00.1104080700260.20437@salmo.appl-ecosys.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox