RRT

I am looking for help trying to select multiple checkboxes to delete entries from a DB via a php web page. I know the SQL syntax on *how* to delete a row of data within a SQL database, just not how to create a php array where I can do multiple delete commands at once. For example, if I have a PostgreSQL database with the following rows: database1=# SELECT * FROM table1; cid | home_location | asking_price ----+---------------------+----------------- 1 123 Main Street 200000 2 345 First Ave 210000 3 456 Frontage Rd 199900 4 678 5th Street 205000 5 1001 Elm Street 225000 I would like to display the results of this SELECT ALL query onto a php web page with checkboxes next to each row, giving me the ability to check multiple rows and then delete them from the database. The php code to display the selections looks something like this: <?php // Connecting to the database server $dbconnect = pg_connect("host=aaa.bbb.ccc.ddd dbname=database1 user=user1 password=password1") or die("Could not connect: " . pg_last_error()); //Performing the SQL query $removequery = sprintf("DELETE FROM table1 WHERE CID="?"); How would you suggest that i put all the desired queries together to be able to delete various ones at the same time? I assume that I need to create some sort of array and then be able to delete them all at once, just not sure of how to go about coding that to work.

That did it! THANKS!!! I had to use "pg_escape_string" instead of "mysql_real_escape_string" since I am using postgres, but other than that its similar. Besides string data, do they make escape methods for other types of data, such as integers, floats, etc? Maybe those types aren't suseptable to exploit? That would make sense to me, as commands aren't numbers but strings of words.

Thanks for the info about the SQL injection, I will take that into account. So you are suggesting that I change my code to something like this, right?: ======================= $query = sprintf("INSERT INTO inventory VALUES ('%s','%s','%s','%s', '%s','%s','%s','%s','%s','%s')";, mysql_real_escape_string($CID), mysql_real_escape_string($ImageFile), mysql_real_escape_string($ItemTitle), mysql_real_escape_string($ItemNo), mysql_real_escape_string($Barcode), mysql_real_escape_string($Description), mysql_real_escape_string($Dept), mysql_real_escape_string($Price), mysql_real_escape_string($Quantity), mysql_real_escape_string($Shipping)); mysql_query($query); =======================

I can't do an INSERT via a web query. Can you look at my syntax and see if I have a typo below?: ------------------------------------- <?php $CID = $_POST['CID']; $ImageFile = $_POST['ImageFile']; $ItemTitle = $_POST['ItemTitle']; $ItemNo = $_POST['ItemNo']; $Barcode = $_POST['Barcode']; $Description = $_POST['Description']; $Dept = $_POST['Dept']; $Price = $_POST['Price']; $Quantity = $_POST['Quantity']; $Shipping = $_POST['Shipping']; . . . $query = 'INSERT INTO inventory (cid, image_pic, item_title, item_no, barcode, description, dept, price, quantity, ship_rate) VALUES ('$CID','$ImageFile','$ItemTitle','$ItemNo', '$Barcode','$Description','$Dept','$Price','$Quantity','$Shipping')'; ------------------------------------- This is what I get back when I try to submit the query (Line 20 is the query line posted above.): Parse error: syntax error, unexpected T_VARIABLE in /perform_insert.php on line 20

I tried the solution to Q.7 but it didn't fix it. I tried "python", "import yum" but it fails saying >>> import yum Traceback (most recent call last): File "<stdin>", line 1, in ? File "yum/__init__.py", line 23, in ? import rpm ImportError: No module named rpm >>>

OK, I am taking your advice and trying to get yum fixed, but keep getting this Python error: ----------------------------------------- yum check-update php5 There was a problem importing one of the Python modules required to run yum. The error leading to this problem was: cannot import name flagToString Please install a package which provides this module, or verify that the module is installed correctly. It's possible that the above module doesn't match the current version of Python, which is: 2.4.1 (#1, May 16 2005, 15:19:29) [GCC 4.0.0 20050512 (Red Hat 4.0.0-5)] If you cannot solve this problem yourself, please go to the yum faq at: http://wiki.linux.duke.edu/YumFaq ----------------------------------------- Any ideas as to what I need to do to get this issue fixed? I am running yum version 3.2.23 and Python version 3.1.1. Thanks.

OK, I'm really starting to get irked about his whole PHP configuration issue; I've been working on this problem for over a month. Modifying the httpd.conf and adding LoadModule php5_module "/full/path/to/php/php5apache2_2.so" AddType application/x-httpd-php .php has not informed the server to parse PHP files as PHP. Here's another thing, why are their so many php.ini and httpd.conf files? Shouldn't there just be one of each? Here's the locations I am finding on my server: /usr/local/apache2/conf/httpd.conf /usr/local/apache2/conf/original/httpd.conf /usr/local/apache2/docs/conf/httpd.conf /etc/httpd/conf/httpd.conf /etc/httpd/conf.d/php.conf /usr/local/lib/php.ini /usr/local/php/php-5.2.9/php.ini /etc/php.ini /etc/php.d/php.ini I just want to get this thing working correctly so I can get the server to parse PHP files as PHP. I need to get past this so that I can move forward onto other things... Thanks!

OK. What does this error mean? There is no text containing "sqlite3ExprDelete" anywhere within the httpd.conf file: # apachectl start httpd: Syntax error on line 57 of /usr/local/apache2/conf/httpd.conf: Cannot load /usr/local/php/php-5.2.9/libs/libphp5.so into server: /usr/local/php/php-5.2.9/libs/libphp5.so: undefined symbol: sqlite3ExprDelete

These are the .so files that I could find on my server. Which module(s) should I load to get PHP working with Apache?: ============ /usr/lib/httpd/modules/libphp5.so /usr/lib/httpd/modules/mod_imap.so /usr/lib/httpd/modules/mod_vhost_alias.so /usr/lib/httpd/modules/mod_unique_id.so /usr/lib/httpd/modules/mod_info.so /usr/lib/httpd/modules/mod_alias.so /usr/lib/httpd/modules/mod_mem_cache.so /usr/lib/httpd/modules/mod_access.so /usr/lib/httpd/modules/mod_asis.so /usr/lib/httpd/modules/mod_headers.so /usr/lib/httpd/modules/mod_auth_digest.so /usr/lib/httpd/modules/mod_dav.so /usr/lib/httpd/modules/mod_logio.so /usr/lib/httpd/modules/mod_include.so /usr/lib/httpd/modules/mod_autoindex.so /usr/lib/httpd/modules/mod_env.so /usr/lib/httpd/modules/mod_proxy_ftp.so /usr/lib/httpd/modules/mod_negotiation.so /usr/lib/httpd/modules/mod_ldap.so /usr/lib/httpd/modules/mod_status.so /usr/lib/httpd/modules/mod_ext_filter.so /usr/lib/httpd/modules/mod_usertrack.so /usr/lib/httpd/modules/mod_python.so /usr/lib/httpd/modules/mod_proxy_http.so /usr/lib/httpd/modules/mod_userdir.so /usr/lib/httpd/modules/mod_actions.so /usr/lib/httpd/modules/mod_disk_cache.so /usr/lib/httpd/modules/mod_speling.so /usr/lib/httpd/modules/mod_mime_magic.so /usr/lib/httpd/modules/mod_auth_ldap.so /usr/lib/httpd/modules/mod_perl.so /usr/lib/httpd/modules/mod_cgid.so /usr/lib/httpd/modules/mod_dir.so /usr/lib/httpd/modules/mod_rewrite.so /usr/lib/httpd/modules/mod_auth.so /usr/lib/httpd/modules/mod_file_cache.so /usr/lib/httpd/modules/mod_dav_fs.so /usr/lib/httpd/modules/mod_log_forensic.so /usr/local/apache2/modules/libphp5.so /usr/local/apache2/lib/apr-util-1/apr_dbd_pgsql-1.so /usr/local/apache2/lib/apr-util-1/apr_dbd_sqlite3.so /usr/local/apache2/lib/apr-util-1/apr_dbd_pgsql.so /usr/local/php/OLD/php-5.2.8/modules/pgsql.so /usr/local/php/OLD/php-5.2.8/.libs/libphp5.so /usr/local/php/OLD/php-5.2.8/ext/pgsql/.libs/pgsql.so /usr/local/php/php-5.2.9/.libs/libphp5.so /usr/local/php/php-5.2.9/libs/libphp5.so ============ I didn't see any .so file named "php5apache2_2.so", unless you were just making up that filename as an example. Thanks.

I'm on Fedora 2.6.11-1.1369_FC4 on that particular server. I'm running PHP 5.2.9 which I downloaded directly from the php web site, then untarred, ran make, and make install commands as described in the php INSTALL file that was included with the distribution.. ================== Example 2-4. Installation Instructions (Apache 2 Shared Module Version) 1. gzip -d httpd-2_0_NN.tar.gz 2. tar xvf httpd-2_0_NN.tar 3. gunzip php-NN.tar.gz 4. tar -xvf php-NN.tar 5. cd httpd-2_0_NN 6. ./configure --enable-so 7. make 8. make install ================== You will probably try to talk me into using yum, which I have already tried to do, but it will not work on my system; it always fails on 'setting up repositories'. Fixing this will have to be another project on its own and in th future.

How to I set it to do that? I am running Apache version 2.2.11.

PHP pages won't open at all on my server. HTML pages open fine, but when going to the PHP pages that are on my server, the browser tries to download the page like a file instead of presenting it by the browser. What can I do to make the PHP processor to be handled properly? Do I need to recompile it again, and if so, what switches should I use?

This issue is still not solved. If I can't get Yum to work correctly, then that means that I will have to config and compile manually. Any suggestions on what I should try next?

When I try that I guess this: Setting up Install Process Setting up repositories Cannot find a valid baseurl for repo: updates-released That is as far as I get. Do I need to run some other command to setup yum first?

Did this fix your issue? Would I do the same thing for Postgres, such as this: yum install php-postgres Any ideas?

YUM always fails when I try to run it. I get these messages back: === [root@server1 ~]# yum check-update Setting up repositories Cannot find a valid baseurl for repo: updates-released === What does this error mean? Plus, I don't know YUM that well, so I figured installing it manually was the most direct path, instead of getting diverted trying to fix another issue that I could try to tackle later... especially since I am trying to get the PHP fixed first.

System specs: OS: Linux, Fedora v.2.6.11-1.1369_FC4 HTTPD: Apache v.2.2.11 PHP v.5.2.9 DBMS: PostgreSQL v. 8.3.7 I have PHP v. 5.2.9 installed on my web server running Apache v.2.2.11, but it is not processing PHP commands on web pages hosted on that same machine. For example, I have a page that I created named phpinfo.php, which solely runs the phpinfo() command. It works on my other web server, but not this one. Here is the code for that entire phpinfo.php: <?php phpinfo() ?> When I try to access the phpinfo.php web page from a browser on another desktop computer, it treats it like its trying to download a file, asking me whether I want to Save or Open the file, not execute the code within the browser as it should be doing. However, if I try to browse to the phpinfo.php file hosted on my other web server, it processes the phpinfo() command as it is supposed to and displays the results of the function. When I installed PHP on the problematic server, I ran these commands as root: ./configure --with-pgsql=/usr/local/pgsql/bin --with-apxs2=/usr/local/apache2/bin/apxs make make install There were no errors, everything installed fine. Whenever you install a newer version of PHP, are you supposed to re-run the Apache installation for it to successfully be able to "talk" to PHP? I'm fairly new to this... Thanks. RRT

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

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

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

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.

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

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

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

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