Hello list.
Does anybody of you use PHP 5.0.4 from "CentOS plus" repo and PostgreSQL 8.1.x from www.postgresql.org (rpms for RHLE 4 AS)? (php-pgsql.rpm I have installed)
On my machine PHP don't connect to PostgreSQL. Anybody of you set it up?
On the other server I use PHP and PostgreSQL included into CentOS 4.x and it works fine.
Regards. -- _________________________________________________________________ D o m i n i k S k ł a d a n o w s k i
On 4/27/06, Dominik Składanowski dskladanowski@gmail.com wrote:
Hello list.
Does anybody of you use PHP 5.0.4 from "CentOS plus" repo and PostgreSQL 8.1.x from www.postgresql.org (rpms for RHLE 4 AS)? (php-pgsql.rpm I have installed)
You need the compatibility layer, or you can use the rpms from dev.centos.org/ which contains a repository with postgresql 8.1.3, which works with a couple other rpms there as a drop in replacement for the rpms in centos.
-- This message has been double ROT13 encoded for security. Anyone other than the intended recipient attempting to decode this message will be in violation of the DMCA
06-04-28, Jim Perrin jperrin@gmail.com napisał(a):
On 4/27/06, Dominik Składanowski dskladanowski@gmail.com wrote:
Does anybody of you use PHP 5.0.4 from "CentOS plus" repo and PostgreSQL 8.1.x from www.postgresql.org (rpms for RHLE 4 AS)? (php-pgsql.rpm I have installed)
You need the compatibility layer, or you can use the rpms from dev.centos.org/ which contains a repository with postgresql 8.1.3, which works with a couple other rpms there as a drop in replacement for the rpms in centos.
I have installed this packages: compat-postgresql-libs-3-3PGDG.i686.rpm postgresql-libs-8.1.2-1PGDG.i686.rpm postgresql-8.1.2-1PGDG.i686.rpm postgresql-server-8.1.2-1PGDG.i686.rpm
I can't login to PostgreSQL using phppgadmin. psql works.
Regards. -- _________________________________________________________________ D o m i n i k S k ł a d a n o w s k i VOLVO 740GL (B230E) rocznik 1991 Warszawa
On Friday 28 April 2006 06:20, Dominik Składanowski wrote:
I can't login to PostgreSQL using phppgadmin. psql works.
There's a couple of things you can do. First, use the connection string for PHP that uses Unix domain socket connections (as I don't use PHP currently for anything, I don't know what that might be for PHP 5). Second, enable tcp/ip socket listening in PostgreSQL. This is enabled in /var/lib/pgsql/data/postgresql.conf (been a while since I've looked, but that's the default location I remember). The mechanism by which this is enabled has changed between 7.4 (RHEL/CentOS default) and 8.1; read the file itself, it is well-commented. If you want external machines to connect, you also need to enable the connection port in your firewall (iptables) config.
-
Dominik Składanowski -
Jim Perrin -
Lamar Owen