RRT Posted July 7, 2008 Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/ Share on other sites More sharing options...
btherl Posted July 7, 2008 Share Posted 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. Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583191 Share on other sites More sharing options...
RRT Posted July 7, 2008 Author Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583198 Share on other sites More sharing options...
btherl Posted July 7, 2008 Share Posted 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? Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583202 Share on other sites More sharing options...
RRT Posted July 7, 2008 Author Share Posted July 7, 2008 phpinfo() runs, but there is no separate module listed for PostgreSQL like there is for mysql, ldap, and others... Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583210 Share on other sites More sharing options...
btherl Posted July 7, 2008 Share Posted 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. Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583218 Share on other sites More sharing options...
RRT Posted July 7, 2008 Author Share Posted July 7, 2008 OK, I just added that... Restart the server now? Or just apachectl stop and then start? Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583257 Share on other sites More sharing options...
RRT Posted July 7, 2008 Author Share Posted 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: Zend Engine v2.2.0, Copyright © 1998-2007 Zend Technologies -------------------------------------------------------------------------------- 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. Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583267 Share on other sites More sharing options...
btherl Posted July 7, 2008 Share Posted 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. Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583270 Share on other sites More sharing options...
RRT Posted July 7, 2008 Author Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583293 Share on other sites More sharing options...
btherl Posted July 7, 2008 Share Posted 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. Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-583302 Share on other sites More sharing options...
RRT Posted July 8, 2008 Author Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-584740 Share on other sites More sharing options...
btherl Posted July 9, 2008 Share Posted 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. Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-584989 Share on other sites More sharing options...
RRT Posted July 14, 2008 Author Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-589938 Share on other sites More sharing options...
btherl Posted July 15, 2008 Share Posted 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) Quote Link to comment https://forums.phpfreaks.com/topic/113496-problem-with-php-in-regards-to-postgresql/#findComment-590127 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.