PostgreSQL and PHP3

Anon

I'm trying to set up an on-line database on my server for an inventory-type system. PHP is installed and working properly, and from everything I've seen and done so far, so is PostgreSQL (I've created the database, created tables and added records to the tables). Now I put some PHP code into my webpage so that I could see some of the records on a web page, but when I accessed the web page, the page appeared and only showed the HTML code that I had entered for the title and field headings. Above the field headings, I got this error:

Fatal error: Call to unsupported or undefined function pg_connect() in /home/httpd/html/eparts/eparts.php3 on line 21

I get the impression that PostgreSQL isn't installed properly, but it was installed when I installed the server and I have never had a problem using any of the commands and such.

Could anyone tell me what could be causing this and perhaps a way to fix it?

Thanks,
Mike

Anon

Hi,
Do you do ./configure --with-pgsql for php ?
If not pls, do so.

REgards

Anon

Apache and PHP were installed when I installed the server so I'm not sure if "--with-pgsql" was used or not. I downloaded the newest version of Apache and the newest verson of PHP, configured and compiled them together and made sure I used the "--with-pgsql". So now I've got a new 'httpd' binary. The only problem is that I can't find any help on upgrading Apache.

Is there some way I can change the way my current PHP is configured so that I can get that "--with-pgsql" in there?

Mike

Anon

Hi,
For the php*.tar.gz file, you can run the ./configure --with-pgsql --with-apxs (for module in apache) and do the make, make install again. This will help. But pls, backup the php.ini file first.
Btw, I would often stop my httpd service before I do a make install.

Regards

Anon

Dear Thomas,
Sorry for this 'belated', but I need help badly :-)
I am having the same problem. I put some PHP code into my webpage to connect to a postgreSQL database using pg_connect. I also get this error :
"Fatal error: Call to unsupported or undefined function pg_connect()"

I use RedHat 6.2, PHP 4 and PosgreSQL 7.0.3.
I have run ./configure --with-pgsql, make and make install. Everything seems fine, but still can not fix the problem.
Do you have any suggestion to fix this problem ?

Any help would be very much appreciated.

Thank you in advance.
Ay Ling

Anon

hi,
May I know what's your source (pg_connect) like ? Btw, you're not compiling a apache module , am I right ?

Regards

Anon

Dear Thomas,
Thank's for your reply.
This is my code for pg_connect : $db_conn = pg_connect ("host=localhost dbname=testdb");
I have made the testdb database in postgres.
I'm new in Linux, PHP and PostgreSQL, so if I use the wrong code, pls do advice me :-)

I tried to put <? dl(pgsql.so); ?> in my PHP code.
But got this error :
Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20000809/pgsqlso' -/usr/local/lib/php/extensions/no-debug-non-zts-20000809/pgsqlso:
cannot open shared object file: No such file or directory in /home/httpd/html/coba.php on line 2

The strange thing is I can't find the php.ini file.
When I installed RedHat 6.2, I got PHP3, now the php3.ini file is still in /etc/httpd.
Then, I upgraded the PHP3 to PHP4. I installed the PHP4 and I've tried to write some simple programs using PHP4, everything seems fine.
But now I can't find the php.ini file for my PHP4, I only have php.ini-dist and php.ini-optimized which their contents look like php.ini file.
It's really confusing :-)

Yes, you are right. I'm not compiling the apache module. Should I ?

Thank's for your kind attention. Your help is very much appreciated.

Sincerely,
Ay Ling

Anon

Hi,
May I know :
1. Are you using rpm version of php4 ?
2. Are you using the default apache setting by RH ?

Ok, let me confess. I use Redhat but not their accessory. I get my own apache, php , postgresql source (all .tar.gz) and cleanly built it.

Maybe you should do the same. Try to
"erase" the apache and get the source (1.3.14) .
And follow the http://www.php.net/manual/install.unix.php
guide above.
Btw, do consider to enable other module/option during compilation.

ps next query direct to my mail twong@aamsin.com .

Regards