Postgresql and PHP problem

peteABK · 06-12-2003, 01:14 PM

I'm trying to make my first PHP / database page (basically out of bordom) but I'm having some trouble connecting to the psql. I've been searching for a while but all I've come up with is the pg_connect( string dbname) function. When I try to run the page I get an error stating that the function is undefined. Any tips are appreciated.

MArgRes · 06-26-2003, 03:54 PM

Here is a snippet that just tests whether you can connect or not. I'm assuming that you have all of the relevant software installed -- php, apache, mod_php, php-pgsql, postgres, etc.

Code:

<?php
        $conn = pg_connect('user=<user-name> dbname=<database-name>');
        if (!$conn)
        {
                echo "Connection failed!";
        }
        else
        {
                echo "Connection succeeded!!!";
        }
?>

If that doesn't work, post the error message(s)...

leed_25 · 06-28-2003, 11:34 PM

Quote:

Originally posted by peteABK
[. . .] When I try to run the page I get an error stating that the function is undefined. Any tips are appreciated.

when you compiled php did you remember to include this option

--with-pgsql

don't know? put this

phpinfo();

as the first executable statement of your script.

peteABK · 06-29-2003, 10:51 PM

I would like to thank both of you for your replies.

MArgRes, I've tried your snippet thank you, but I still get:

Call to undefined function: pg_connect() /home/user/directory/file.php

leed_25, I also want to say thanks, I'm just trying to use the version of php that came with RH9, should I download another and recompile it in? I ran phpinfo() and I couldn't find anything in ther about postresql or mysql.

MArgRes · 06-30-2003, 10:43 AM

Okay, you probably didn't install the php-pgsql package. This is needed to run the Postgresql stuff from PHP. What you need to do is install it with RPM. It's on the third disc of Redhat 9. Put the disc in, and install the package with this command:

rpm -Uvh php-pgsql-4.2.2-8.0.5.i386.rpm

Once that's done, try to run the code I gave you again...

abd_bela · 07-24-2003, 03:01 AM

Hi,
I have the same problem as our friend peteABK
Ive installed php-pgsql, php

I try exactly the script proposed by MArgRes , this is the error

Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1: IDENT authentication failed for user "bela" in /home/bela/public_html/bdEtud/index.php on line 3
Connection failed!

while rhe connection is correct on the xterm:
psql -U bela etudiant
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

etudiant=# \q

thanking for answer
bela

abd_bela · 07-24-2003, 03:20 AM

perhaps the answer ih here:

how to connect to user database bela for instance if jour are login in the unix as bela ??
look at these 2 examples:

[jijel@info-50 jijel]$ psql -U bela etudiant -W
Password:
psql: FATAL 1: IDENT authentication failed for user "bela"

here from jijel login : error ( passwd is correct )

[jijel@info-50 jijel]$ su - bela
Password:

login as bela

[bela@info-50 bela]$ psql -U bela etudiant -W
Password:
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

etudiant=# \q
[bela@info-50 bela]$

From php , you must precise the user ( otherwise you are anonymous )

thanks

bela

SandyTipper · 08-03-2003, 07:44 PM

As I see it, the problem is "undefined function", not authentication or connection errors.

I have the same problem (RedHat 9).

php-pgsql is installed.
php_info shows '--with-pgsql=shared'
(so recompiling seems unnecessary.)

/etc/php.d/pgsql.ini has in it:
; Enable pgsql extension module
extension=pgsql.so

The following files exist:
/usr/lib/php4/pgsql.so
/usr/lib/pgsql/plpgsql.so

This is a production web site that used to work before upgrading to RH9. HELP!!!!!!!