Jump to content

RRT

Members
  • Posts

    25
  • Joined

  • Last visited

    Never

Posts posted by RRT

  1. 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.

     

  2. 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.

  3. 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);

     

     

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

     

     

  4. 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

  5. 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

    >>>

  6. 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.

     

  7. 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!

     

     

  8. 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

     

  9. 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.

     

  10. 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.

     

     

  11. :facewall:

    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?

     

     

  12. 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.

     

  13. 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

     

     

     

  14. 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

  15. 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

     

     

     

  16. 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.

     

     

  17. 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

     

     

  18. 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

     

     

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.