php+postgresql

vicent

Hi,
i have installed apache, mysql, php3 and postgresql in a debian using 'apt-get' (apache, php3, php3-mysql, mysql, php3-pgsql, postgresql). The php scripts to access to a mysql works but the php scripts to access to pgsql don't.
Pgsql works correctly.

Can you help me?

Thanks a lot.

Anon

What is apt-get and where did you obtain it.
Is is a ready configured system or is it merely you way of describing those tools?

Regards

Richard

Anon

Hi Richard,
'Apt-get' is a install and configuration utility used in debian systems.

Anon

Hi there.

What is the error message ?
Are you able to connect to the base using psql ?

Postgresql accept 2 kinds of connection: local and tcp/ip ones.

Starting postgre with postmaster -i will enable tcp/ip connection (well, you will have also to twinkle a bit with pg_hba.conf) so you will be able to use a pg_connect or whatever function with a host argument.

If postgre is not started with the -i option, have a try not to give a hostname in the connection function so it will try connecting locally.

Hopes this helps.

vicent

Hi,
when i call my page.php3 system returns 'call to unsupported or undefined function pg_connect() in page.php3 '.
It seems that php3 doesn't support pgsql, not a problem with pgsql.

frymaster

if you're running php 3 then you may need to use the "old" version of pg_connect() which is

pg_connect("", "", "", "", "foobardb");

NOT the pg_connect() with one big string. If you're getting an invalid number of parameters error this is probably why. I really suggest you use php4 tho' it's gotta be on apt-get or there should be a deb package out there somewhere (or, hey, you could compile it... not so tough to do).

Anon

looks like your php was not compiled with postgresql support.

Either recompile it if it was installed using a tarball, or install the package (rpm or deb) relative to postgre and php.