pg_connect

Anon

I have a problem.
Making test for learn PHP I copied and modified a PHP program on my web space. After many little corrections I stopped on this error message.

Fatal error: Call to undefined function: pg_connect() in ./lib.inc.php on line 90

I think it's about user authentication, but I don't know what I have to do.

The program I copie is phpPgAdmin 2.1
on site: http://www.phpwizard.net/projects/phpPgAdmin/index.html
I have a MYSQL database create in my web.
Please HELP ME.

Anon

pg_connect() is a function being called from some other include file, which you probably dont have.

see, if the function is local to the same file, and then check the spellings. or if it mentions some where check the source file of the pg_connect() function.

from the name phpPgAdmin, looks like they might have some kind of common.inc file too, so get that aswell.

Anon

I have this file but there is something doesn't work right.
In this file write:

if ($dbh = pg_connect("user=$cfgServer[stduser] password=$cfgServer[stdpass] host=$cfgServer[host] dbname=$db port=$cfgServer[port]")) {
$sql_get_auth = "SELECT usename, passwd FROM pg_shadow WHERE usename = '$PHP_AUTH_USER'"; if ($cfgUsePass) {
$sql_get_auth .= "AND passwd = '$PHP_AUTH_PW'";
}
$rs = @pg_exec($dbh, $sql_get_auth if (!pg_numrows($rs)) {
$PHP_AUTH_USER = "";
Header("status: 401 Unauthorized");
Header("HTTP/1.0 401 Unauthorized");
if (empty($cfgServer['port'])) {
Header("WWW-authenticate: basic realm=\"$cfgProgName on " . $cfgServer['host'] . "\"");
} else {
Header("WWW-authenticate: basic realm=\"$cfgProgName on " . $cfgServer['host'] . ":" . $cfgServer['port'] . "\"");
} echo "<HEAD><TITLE>" . $strAccessDenied . "</TITLE></HEAD>\n";
echo "<BODY BGCOLOR=#FFFFFF><BR><BR><CENTER><H1>" . $strWrongUser . "</H1>\n";
echo "</CENTER></BODY>";
exit;

Is it wrong or I have to set something.

Giulio

Anon

Guilio,

You do not have postgres extensions compiled into PHP. Pg_connect is the basic function to connect to your postgres database.

-Dan
phpPgAdmin author

Anon

Dear all,
I'm sorry for this 'belated'.
I am having the same problem with Giulio
"Call to undefined function: pg_connect()"
I am new in PHP programming. At this moment, I am using RedHat, PHP 4 and just installed PosgreSQL 7.0.3.
Do you have any suggestions, so I can use / access the PostgreSQL functions and database with PHP ?
Should I install any new modules to PHP ? Pls advice me.
Any help would be very much appreciated.

Thank you in advance.
Kiky

Anon

[meta: keywords: fatal error pg_connect pg_pconnect
mysql_connect mysql_pconnect linux turbolinux]

Here\\'s what I did to resolve the issue:

Added the following to the php.ini file:

extension_dir   =  <ext_dir>
extension        = ldap.so
extension        = mysql.so
extension        = pgsql.so

Where, on my system, <ext_dir> just happened to be:
/usr/lib/php/extensions/no-debug-non-zts-20001214

Then, bounced the apache server; watch for errors on
restart with a \\"$ tail -f /etc/httpd/logs/error_log\\"

Observations made while pounding head:

- you don\\\'t need to add any path to /etc/ld.so.conf
- or run /sbin/ldconfig
- or alter /etc/httpd/conf/httpd.conf
- if the above shared libs came from an rpm,
   you can find out which and where using (from bash):
   $ rpm -qa | grep php | while read rpm ; do \\\\  
       rpm -ql $rpm | grep pgsql.so && echo $rpm; done
- to reassure that this shared lib has what you want:
   $ nm <ext_dir>/pgsql.so | grep \\\' T .*pg_p*connect\\\'
- use the above \\\"rpm -qa\\\" sequence to find out where
   your php.ini file is, if not in /etc/httpd.

The above assumes php is properly working; to check:
- create a php file, say \\"test.php\\", and with the following:
<body><?php phpinfo(); ?></body>
- bring up the page in your browser; you should see
a series of pretty purple tables, listing all sorts of
goodies, one especially relevant table row is the
\\"Configure Command\\" (got \\'--with-pgsql=shared\\'?).

If no \\'--with-pgsql=shared\\' (or \\'mysql\\', \\'ldap\\', or other
desired module), the apache server will need to be
reconfigured (beyond the scope of this reply, or my
knowledge, frankly).

If no phpinfo() at all, php isn\\'t even set up. Mine was mostly
configured with the rpm install scripts. You\\'ll need to have
a libphp4.so shared lib (if php4), on your system. Use the
above \\"rpm -qa\\" sequence to find out where it resides. You
may also get a better understanding of what\\'s involved by
reviewing the install and unstall scripts for the rpm; here\\'s
what I had:

- $ rpm -q -scripts php-4.0.4
   postinstall script (through /bin/sh):
   /usr/sbin/apxs -i -a -n php4 /usr/lib/php/libphp4.so
   postuninstall script (through /bin/sh):
   if [ \\\"$1\\\" = 0 ]
   then
     cat /etc/httpd/conf/httpd.conf \\\\  
      | grep -v \\\"LoadModule php4_module\\\" \\\\  
      | grep -v \\\"AddModule mod_php4.c\\\" \\\\  
      > /etc/httpd/conf/httpd.conf.new
     mv /etc/httpd/conf/httpd.conf.new  \\\\  
          /etc/httpd/conf/httpd.conf
     rm -f /usr/libexec/apache/libphp4.so
   fi

So basically, you\\'ll need to call \\"apxs\\" (as above), and
add a few lines to your /etc/httpd/conf/httpd.conf file:

LoadModule php4_module  /usr/libexec/apache/libphp4.so
AddModule mod_php4.c
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

Bounce apache, and that\\'d be it.