Problem with PHP in regards to PostgreSQL

RRT · July 7, 2008

OK, here's what I'm running:

Fedora 2.6.23.1-42.fc8

PostgreSQL v. 8.2.6

Apache v. 2.2.6

PHP v. 5.2.4

Here's the problem I'm having:

I can create simple PHP pages like this, and it displays properly:


<html>
<head>
<title>Hello PHP World!</title>
</head>
<body>
<?php echo '<p>Hello World</p>; ?>
</body>
</html>

But, when I try something more complicated, such as seen below, the client's web browser just gets an HTTP 500 Internal Server Error.


<html>
<head>
<title>Connecting...</title>
</head>
<body>
<?php $dbconn = pg_connect("host=webserver1.domain.com port=5432 dbname=database1 user=postgres password=mypassword") or die('Could not connect: ' . pg_last_error()); 
?>
</body>
</html>

Any ideas? I've tried a million variations of this code all weekend, such as putting the IP address in place of them hostname, only passing the host= and the dbname= fields, etc. Any suggestions or advice would be appreciated!

Mark

btherl · July 7, 2008

It's possible that php is not configured to support postgres. Try adding this to the top of your script

<?php ini_set('display_errors', 1); ?>

That should give you more information about what's going wrong.

RRT · July 7, 2008

I tried both edits, neither one would work. Very strange!



<html>
<head>
<title>Connecting...</title>
</head>
<body>
<?php ini_set('display_errors', 1); ?>
<?php $dbconn = pg_connect("host=webserver1.domain.com port=5432 dbname=database1 user=postgres password=mypassword") or die('Could not connect: ' . pg_last_error()); 
?>
</body>
</html>



<html>
<head>
<title>Connecting...</title>
</head>
<body>
<?php ini_set('display_errors', 1);
$dbconn = pg_connect("host=webserver1.domain.com port=5432 dbname=database1 user=postgres password=mypassword") or die('Could not connect: ' . pg_last_error()); 
?>
</body>
</html>

Did I misunderstand what you wanted me to try?

Mark

btherl · July 7, 2008

Hmm that's worrying .. what about this on its own:

 <?php phpinfo(); ?>

With nothing else in the script.

Does that show that there is a pgsql module configured in php?

RRT · July 7, 2008

phpinfo() runs, but there is no separate module listed for PostgreSQL like there is for mysql, ldap, and others...

btherl · July 7, 2008

Aha, that's your problem then. Normally hat should be taken care of by the package system, but apparently it hasn't in your case.

Unfortunately I'm not sure exactly where the configuration will be on your system. You can try looking in /etc/php or /etc/php5. What you should see in your php.ini, or in a file under a conf.d directory, is a line like this:

# configuration for php PostgreSQL module
extension=pgsql.so

That tells php to load the pgsql module.

RRT · July 7, 2008

OK, I just added that... Restart the server now? Or just apachectl stop and then start?

RRT · July 7, 2008

It STILL isn't showing up! Here's when shows when phpinfo() is run:

================

PHP Version 5.2.4

System Linux server1 2.6.23.1-42.fc8 #1 SMP Tue Oct 30 13:55:12 EDT 2007 i686

Build Date Oct 16 2007 09:15:34

Configure Command './configure' '--build=i386-redhat-linux-gnu' '--host=i386-redhat-linux-gnu' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--without-mime-magic' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-odbc' '--disable-dom' '--disable-dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter' '--disable-json'

Server API Apache 2.0 Handler

Virtual Directory Support disabled

Configuration File (php.ini) Path /etc

Loaded Configuration File /etc/php.ini

Scan this dir for additional .ini files /etc/php.d

additional .ini files parsed /etc/php.d/dbase.ini, /etc/php.d/json.ini, /etc/php.d/ldap.ini, /etc/php.d/mysqli.ini, /etc/php.d/mysql.ini, /etc/php.d/pdo.ini, /etc/php.d/pdo_mysql.ini, /etc/php.d/pdo_sqlite.ini, /etc/php.d/zip.ini

PHP API 20041225

PHP Extension 20060613

Zend Extension 220060519

Debug Build no

Thread Safety disabled

Zend Memory Manager enabled

IPv6 Support enabled

Registered PHP Streams php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps, zip

Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls

Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*

This program makes use of the Zend Scripting Language Engine:

--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration

PHP Core

Directive Local Value Master Value

allow_call_time_pass_reference Off Off

allow_url_fopen On On

allow_url_include Off Off

always_populate_raw_post_data Off Off

arg_separator.input & &

arg_separator.output & &

asp_tags Off Off

auto_append_file no value no value

auto_globals_jit On On

auto_prepend_file no value no value

browscap no value no value

default_charset no value no value

default_mimetype text/html text/html

define_syslog_variables Off Off

disable_classes no value no value

disable_functions no value no value

display_errors Off Off

display_startup_errors Off Off

doc_root no value no value

docref_ext no value no value

docref_root no value no value

enable_dl On On

error_append_string no value no value

error_log no value no value

error_prepend_string no value no value

error_reporting 6143 6143

expose_php On On

extension_dir /usr/lib/php/modules /usr/lib/php/modules

file_uploads On On

highlight.bg #FFFFFF #FFFFFF

highlight.comment #FF8000 #FF8000

highlight.default #0000BB #0000BB

highlight.html #000000 #000000

highlight.keyword #007700 #007700

highlight.string #DD0000 #DD0000

html_errors On On

ignore_repeated_errors Off Off

ignore_repeated_source Off Off

ignore_user_abort Off Off

implicit_flush Off Off

include_path .:/usr/share/pear:/usr/share/php .:/usr/share/pear:/usr/share/php

log_errors On On

log_errors_max_len 1024 1024

magic_quotes_gpc Off Off

magic_quotes_runtime Off Off

magic_quotes_sybase Off Off

mail.force_extra_parameters no value no value

max_execution_time 30 30

max_input_nesting_level 64 64

max_input_time 60 60

memory_limit 32M 32M

open_basedir no value no value

output_buffering 4096 4096

output_handler no value no value

post_max_size 8M 8M

precision 14 14

realpath_cache_size 16K 16K

realpath_cache_ttl 120 120

register_argc_argv Off Off

register_globals Off Off

register_long_arrays Off Off

report_memleaks On On

report_zend_debug On On

safe_mode Off Off

safe_mode_exec_dir no value no value

safe_mode_gid Off Off

safe_mode_include_dir no value no value

sendmail_from no value no value

sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i

serialize_precision 100 100

short_open_tag On On

SMTP localhost localhost

smtp_port 25 25

sql.safe_mode Off Off

track_errors Off Off

unserialize_callback_func no value no value

upload_max_filesize 2M 2M

upload_tmp_dir no value no value

user_dir no value no value

variables_order EGPCS EGPCS

xmlrpc_error_number 0 0

xmlrpc_errors Off Off

y2k_compliance On On

zend.ze1_compatibility_mode Off Off

apache2handler

Apache Version Apache/2.2.6 (Fedora)

Apache API Version 20051115

Server Administrator root@localhost

Hostname:Port server1.my_domain.com:80

User/Group apache(48)/48

Max Requests Per Child: 4000 - Keep Alive: off - Max Per Connection: 100

Timeouts Connection: 120 - Keep-Alive: 15

Virtual Server No

Server Root /etc/httpd

Loaded Modules core prefork http_core mod_so mod_auth_basic mod_auth_digest mod_authn_file mod_authn_alias mod_authn_anon mod_authn_dbm mod_authn_default mod_authz_host mod_authz_user mod_authz_owner mod_authz_groupfile mod_authz_dbm mod_authz_default util_ldap mod_authnz_ldap mod_include mod_log_config mod_logio mod_env mod_ext_filter mod_mime_magic mod_expires mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_proxy mod_proxy_balancer mod_proxy_ftp mod_proxy_http mod_proxy_connect mod_cache mod_suexec mod_disk_cache mod_file_cache mod_mem_cache mod_cgi mod_php5 mod_perl mod_proxy_ajp mod_python mod_ssl

Directive Local Value Master Value

engine 1 1

last_modified 0 0

xbithack 0 0

Apache Environment

Variable Value

HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*

HTTP_REFERER http://server1.my_domain.com/portal/acme/

HTTP_ACCEPT_LANGUAGE en-us

HTTP_UA_CPU x86

HTTP_ACCEPT_ENCODING gzip, deflate

HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)

HTTP_HOST server1.my_domain.com

HTTP_CONNECTION Keep-Alive

PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

SERVER_SIGNATURE <address>Apache/2.2.6 (Fedora) Server at server1.my_domain.com Port 80</address>

SERVER_SOFTWARE Apache/2.2.6 (Fedora)

SERVER_NAME server1.my_domain.com

SERVER_ADDR 192.168.192.2

SERVER_PORT 80

REMOTE_ADDR 192.168.192.100

DOCUMENT_ROOT /var/www/html

SERVER_ADMIN root@localhost

SCRIPT_FILENAME /var/www/html/portal/acme/phpinfo.php

REMOTE_PORT 1254

GATEWAY_INTERFACE CGI/1.1

SERVER_PROTOCOL HTTP/1.1

REQUEST_METHOD GET

QUERY_STRING no value

REQUEST_URI /portal/acme/phpinfo.php

SCRIPT_NAME /portal/acme/phpinfo.php

HTTP Headers Information

HTTP Request Headers

HTTP Request GET /portal/acme/phpinfo.php HTTP/1.1

Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*

Referer http://server1.my_domain.com/portal/acme/

Accept-Language en-us

UA-CPU x86

Accept-Encoding gzip, deflate

User-Agent Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)

Host server1.my_domain.com

Connection Keep-Alive

HTTP Response Headers

X-Powered-By PHP/5.2.4

Connection close

Transfer-Encoding chunked

Content-Type text/html; charset=UTF-8

bz2

BZip2 Support Enabled

Stream Wrapper support compress.bz2://

Stream Filter support bzip2.decompress, bzip2.compress

BZip2 Version 1.0.4, 20-Dec-2006

calendar

Calendar support enabled

ctype

ctype functions enabled

curl

cURL support enabled

cURL Information libcurl/7.16.4 NSS/3.11.7.1 zlib/1.2.3 libidn/0.6.14

date

date/time support enabled

"Olson" Timezone Database Version 2007.6

Timezone Database internal

Default timezone America/Chicago

Directive Local Value Master Value

date.default_latitude 31.7667 31.7667

date.default_longitude 35.2333 35.2333

date.sunrise_zenith 90.583333 90.583333

date.sunset_zenith 90.583333 90.583333

date.timezone no value no value

exif

EXIF Support enabled

EXIF Version 1.4 $Id: exif.c,v 1.173.2.5.2.20 2007/06/10 20:12:45 iliaa Exp $

Supported EXIF Version 0220

Supported filetypes JPEG,TIFF

filter

Input Validation and Filtering enabled

Revision $Revision: 1.52.2.39 $

Directive Local Value Master Value

filter.default unsafe_raw unsafe_raw

filter.default_flags no value no value

ftp

FTP support enabled

gettext

GetText Support enabled

gmp

gmp support enabled

GMP version 4.2.2

hash

hash support enabled

Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv

iconv support enabled

iconv implementation glibc

iconv library version 2.7

Directive Local Value Master Value

iconv.input_encoding ISO-8859-1 ISO-8859-1

iconv.internal_encoding ISO-8859-1 ISO-8859-1

iconv.output_encoding ISO-8859-1 ISO-8859-1

json

json support enabled

json version 1.2.1

ldap

LDAP Support enabled

RCS Version $Id: ldap.c,v 1.161.2.3.2.11 2007/07/17 09:09:42 jani Exp $

Total Links 0/unlimited

API Version 3001

Vendor Name OpenLDAP

Vendor Version 20338

SASL Support Enabled

libxml

libXML support active

libXML Version 2.6.30

libXML streams enabled

mysql

MySQL Support enabled

Active Persistent Links 0

Active Links 0

Client API version 5.0.45

MYSQL_MODULE_TYPE external

MYSQL_SOCKET /var/lib/mysql/mysql.sock

MYSQL_INCLUDE -I/usr/include/mysql

MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

Directive Local Value Master Value

mysql.allow_persistent On On

mysql.connect_timeout 60 60

mysql.default_host no value no value

mysql.default_password no value no value

mysql.default_port no value no value

mysql.default_socket no value no value

mysql.default_user no value no value

mysql.max_links Unlimited Unlimited

mysql.max_persistent Unlimited Unlimited

mysql.trace_mode Off Off

mysqli

MysqlI Support enabled

Client API library version 5.0.45

Client API header version 5.0.45

MYSQLI_SOCKET /var/lib/mysql/mysql.sock

Directive Local Value Master Value

mysqli.default_host no value no value

mysqli.default_port 3306 3306

mysqli.default_pw no value no value

mysqli.default_socket no value no value

mysqli.default_user no value no value

mysqli.max_links Unlimited Unlimited

mysqli.reconnect Off Off

openssl

OpenSSL support enabled

OpenSSL Version OpenSSL 0.9.8b 04 May 2006

pcre

PCRE (Perl Compatible Regular Expressions) Support enabled

PCRE Library Version 7.3 2007-08-28

Directive Local Value Master Value

pcre.backtrack_limit 100000 100000

pcre.recursion_limit 100000 100000

PDO

PDO support enabled

PDO drivers mysql, sqlite

pdo_mysql

PDO Driver for MySQL, client library version 5.0.45

pdo_sqlite

PDO Driver for SQLite 3.x enabled

PECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.2 2007/03/23 14:30:00 wez Exp $

SQLite Library 3.4.2

posix

Revision $Revision: 1.70.2.3.2.16 $

pspell

PSpell Support enabled

Reflection

Reflection enabled

Version $Id: php_reflection.c,v 1.164.2.33.2.45 2007/08/20 17:01:22 sebastian Exp $

session

Session Support enabled

Registered save handlers files user

Registered serializer handlers php php_binary wddx

Directive Local Value Master Value

session.auto_start Off Off

session.bug_compat_42 Off Off

session.bug_compat_warn On On

session.cache_expire 180 180

session.cache_limiter nocache nocache

session.cookie_domain no value no value

session.cookie_httponly Off Off

session.cookie_lifetime 0 0

session.cookie_path / /

session.cookie_secure Off Off

session.entropy_file no value no value

session.entropy_length 0 0

session.gc_divisor 1000 1000

session.gc_maxlifetime 1440 1440

session.gc_probability 1 1

session.hash_bits_per_character 5 5

session.hash_function 0 0

session.name PHPSESSID PHPSESSID

session.referer_check no value no value

session.save_handler files files

session.save_path /var/lib/php/session /var/lib/php/session

session.serialize_handler php php

session.use_cookies On On

session.use_only_cookies Off Off

session.use_trans_sid 0 0

shmop

shmop support enabled

SimpleXML

Simplexml support enabled

Revision $Revision: 1.151.2.22.2.35 $

Schema support enabled

sockets

Sockets Support enabled

SPL

SPL support enabled

Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject

Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException

standard

Regex Library Bundled library enabled

Dynamic Library Support enabled

Path to sendmail /usr/sbin/sendmail -t -i

Directive Local Value Master Value

assert.active 1 1

assert.bail 0 0

assert.callback no value no value

assert.quiet_eval 0 0

assert.warning 1 1

auto_detect_line_endings 0 0

default_socket_timeout 60 60

safe_mode_allowed_env_vars PHP_ PHP_

safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH

url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry

user_agent no value no value

sysvmsg

sysvmsg support enabled

Revision $Revision: 1.20.2.3.2.6 $

tokenizer

Tokenizer Support enabled

wddx

WDDX Support enabled

WDDX Session Serializer enabled

xml

XML Support active

XML Namespace Support active

libxml2 Version 2.6.30

zip

Zip enabled

Extension Version $Id: php_zip.c,v 1.1.2.38 2007/08/06 22:02:32 bjori Exp $

Zip version 2.0.0

Libzip version 0.7.1

zlib

ZLib Support enabled

Stream Wrapper support compress.zlib://

Stream Filter support zlib.inflate, zlib.deflate

Compiled Version 1.2.3

Linked Version 1.2.3

Directive Local Value Master Value

zlib.output_compression Off Off

zlib.output_compression_level -1 -1

zlib.output_handler no value no value

Additional Modules

Module Name

dbase

sysvsem

sysvshm

Environment

Variable Value

SSH_AGENT_PID 2080

HOSTNAME server1

DESKTOP_STARTUP_ID no value

TERM xterm

SHELL /bin/bash

XDG_SESSION_COOKIE 121d6142667cee2f96609c00477f8500-1215315866.321968-1477842974

HISTSIZE 1000

GTK_RC_FILES /etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2

WINDOWID 56623195

GTK_MODULES gnomebreakpad

USER root

LS_COLORS no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:

CCACHE_DIR /var/cache/ccache

SSH_AUTH_SOCK /tmp/ssh-BAZJdS2078/agent.2078

GNOME_KEYRING_SOCKET /tmp/keyring-d6vPS5/socket

SESSION_MANAGER local/unix:@/tmp/.ICE-unix/2078,unix/unix:/tmp/.ICE-unix/2078

PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

MAIL /var/spool/mail/root

PWD /etc/rc5.d

INPUTRC /etc/inputrc

CCACHE_UMASK 002

LANG en_US.UTF-8

SSH_ASKPASS /usr/libexec/openssh/gnome-ssh-askpass

HOME /root

SHLVL 4

GNOME_DESKTOP_SESSION_ID Default

LOGNAME root

CVS_RSH ssh

DBUS_SESSION_BUS_ADDRESS unix:abstract=/tmp/dbus-iAnr3Z5wAa,guid=7b12055f459ca93c27e3030048703f9a

LESSOPEN |/usr/bin/lesspipe.sh %s

WINDOWPATH 7

DISPLAY :0.0

G_BROKEN_FILENAMES 1

XAUTHORITY /root/.Xauthority

COLORTERM gnome-terminal

_ /usr/sbin/httpd

PHP Variables

Variable Value

_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*

_SERVER["HTTP_REFERER"] http://server1.my_domain.com/portal/acme/

_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us

_SERVER["HTTP_UA_CPU"] x86

_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate

_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)

_SERVER["HTTP_HOST"] server1.my_domain.com

_SERVER["HTTP_CONNECTION"] Keep-Alive

_SERVER["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

_SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.6 (Fedora) Server at server1.my_domain.com Port 80</address>

_SERVER["SERVER_SOFTWARE"] Apache/2.2.6 (Fedora)

_SERVER["SERVER_NAME"] server1.my_domain.com

_SERVER["SERVER_ADDR"] 192.168.192.2

_SERVER["SERVER_PORT"] 80

_SERVER["REMOTE_ADDR"] 192.168.192.100

_SERVER["DOCUMENT_ROOT"] /var/www/html

_SERVER["SERVER_ADMIN"] root@localhost

_SERVER["SCRIPT_FILENAME"] /var/www/html/portal/acme/phpinfo.php

_SERVER["REMOTE_PORT"] 1254

_SERVER["GATEWAY_INTERFACE"] CGI/1.1

_SERVER["SERVER_PROTOCOL"] HTTP/1.1

_SERVER["REQUEST_METHOD"] GET

_SERVER["QUERY_STRING"] no value

_SERVER["REQUEST_URI"] /portal/acme/phpinfo.php

_SERVER["SCRIPT_NAME"] /portal/acme/phpinfo.php

_SERVER["PHP_SELF"] /portal/acme/phpinfo.php

_SERVER["REQUEST_TIME"] 1215316030

_ENV["SSH_AGENT_PID"] 2080

_ENV["HOSTNAME"] server1

_ENV["DESKTOP_STARTUP_ID"] no value

_ENV["TERM"] xterm

_ENV["SHELL"] /bin/bash

_ENV["XDG_SESSION_COOKIE"] 121d6142667cee2f96609c00477f8500-1215315866.321968-1477842974

_ENV["HISTSIZE"] 1000

_ENV["GTK_RC_FILES"] /etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2

_ENV["WINDOWID"] 56623195

_ENV["GTK_MODULES"] gnomebreakpad

_ENV["USER"] root

_ENV["LS_COLORS"] no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:

_ENV["CCACHE_DIR"] /var/cache/ccache

_ENV["SSH_AUTH_SOCK"] /tmp/ssh-BAZJdS2078/agent.2078

_ENV["GNOME_KEYRING_SOCKET"] /tmp/keyring-d6vPS5/socket

_ENV["SESSION_MANAGER"] local/unix:@/tmp/.ICE-unix/2078,unix/unix:/tmp/.ICE-unix/2078

_ENV["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

_ENV["MAIL"] /var/spool/mail/root

_ENV["PWD"] /etc/rc5.d

_ENV["INPUTRC"] /etc/inputrc

_ENV["CCACHE_UMASK"] 002

_ENV["LANG"] en_US.UTF-8

_ENV["SSH_ASKPASS"] /usr/libexec/openssh/gnome-ssh-askpass

_ENV["HOME"] /root

_ENV["SHLVL"] 4

_ENV["GNOME_DESKTOP_SESSION_ID"] Default

_ENV["LOGNAME"] root

_ENV["CVS_RSH"] ssh

_ENV["DBUS_SESSION_BUS_ADDRESS"] unix:abstract=/tmp/dbus-iAnr3Z5wAa,guid=7b12055f459ca93c27e3030048703f9a

_ENV["LESSOPEN"] |/usr/bin/lesspipe.sh %s

_ENV["WINDOWPATH"] 7

_ENV["DISPLAY"] :0.0

_ENV["G_BROKEN_FILENAMES"] 1

_ENV["XAUTHORITY"] /root/.Xauthority

_ENV["COLORTERM"] gnome-terminal

_ENV["_"] /usr/sbin/httpd

PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.

btherl · July 7, 2008

Which file did you edit? Restarting apache is enough, no need to restart the whole server.

Adding the line won't help if the module doesn't exist .. I'm not sure of Fedora's package system, but there's likely to be a package designed for adding postgres support to apache.

RRT · July 7, 2008

The file that I modified was /etc/php.ini. I added those 2 lines to it.

pgsql.so is not found on the system, however there is a file named libplpgsql.so It is located at /usr/local/postgresql-8.2.6/src/pl/plpgsql/src/libplpgsql.so. Is that not the right file? If it's not the right file, how do I get the correct one?

Mark

btherl · July 7, 2008

That doesn't look like the right file. What you need is a module compiled for php called pgsql.so. In Debian the package is called "php5-pgsql". You might try looking for a similarly named package in Fedora.

RRT · July 8, 2008

OK, I have read a lot, re-installed a lot, and one thing that I have noticed is that in the directory /etc/php.d/ there are different ini files for different programs, such as mysql, json, dbase, ldap, etc. SHOULD there be an pgsql.ini file (or something similar) in there. And if so, where can i get one from?

Mark

btherl · July 9, 2008

Yes there should be a pgsql file in there. And it comes from the package php5-pgsql, or another package with a similar name.

RRT · July 14, 2008

When you say "And it comes from the package php5-pgsql, or another package with a similar name" , do you mean that it resides within one of those RPMs? And if so, what is the easiest way to 'unzip' them so that I can retreive the ini file?

Mark

btherl · July 15, 2008

Installing the package ought to install the ini file for you. If it doesn't, then it's not a very good package You should install it the same way you install any other package (I'm being vague here, because I've never used Fedora)

Sign In

Problem with PHP in regards to PostgreSQL

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information