Topic: php upgrade problems

[adam hampton]

ok I tried to update my php tonite. I followed the php upgrade how to and then found a post about using more updated files. everything went fine with the installations of the rpms . My problem is somehow.. and for some unknown reason my php will no longer work with mysql. my phpinfo does not show mysql set up. I know very little about php and mysql. Some places to check and or instruction on what to do now would be great.

[adam hampton]

This is my php info . I hope this helps
 PHP Version 4.0.6

Build System Linux rh7builder.arvin.dk 2.4.3-12 #1 Fri Jun 8 15:05:56 EDT 2001 i686 unknown
Build Date Aug 20 2001
Configure Command (note: tells you nothing about what extensions are currently installed)  './configure' '--prefix=/usr' '--with-apxs' '--libdir=/usr/lib/php4' '--includedir=/usr/include' '--datadir=/usr/share/php' '--with-config-file-path=/etc' '--enable-inline-optimization' '--enable-magic-quotes' '--enable-track-vars' '--enable-memory-limit' '--enable-bcmath' '--enable-sigchild' '--with-xml' '--with-expat-dir=/usr' '--with-mm' '--with-openssl' '--enable-ftp=shared' '--enable-exif=shared' '--with-gd=shared,/usr' '--enable-sysvsem=shared' '--enable-sysvshm=shared' '--enable-shmop=shared' '--with-unixODBC=shared' '--with-mysql=shared,/usr' '--with-ldap=shared' '--with-pgsql=shared' '--with-gettext=shared' '--with-pspell=shared' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-sybase-ct=shared,/usr' '--with-pdflib=shared' '--with-oci8=shared' '--with-swf=shared,/home/troels/rpm/BUILD/php-4.0.6/swflib' '--enable-sockets=shared' '--with-gmp=shared' '--with-dom=shared' '--with-qtdom=shared,/usr/lib/qt-2.3.0' '--with-iconv=shared' '--enable-wddx' '--with-curl=shared' '--enable-apc=shared' '--with-ming=shared' '--with-imlib=shared' '--with-recode=shared' '--with-zlib=/usr'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php.ini
ZEND_DEBUG disabled
Thread Safety disabled

 This program makes use of the Zend scripting language engine:
Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend Technologies

 


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

PHP 4.0 Credits

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

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference
 On On
allow_url_fopen
 1 1
arg_separator.input
 & &
arg_separator.output
 & &
asp_tags
 Off Off
auto_append_file
 no value no value
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_functions
 no value no value
display_errors
 On On
display_startup_errors
 Off Off
doc_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
 2039 2039
expose_php
 On On
extension_dir
 /usr/lib/php4 /usr/lib/php4
file_uploads
 1 1
gpc_order
 GPC GPC
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_user_abort
 Off Off
implicit_flush
 Off Off
include_path
 .:/usr/share/php/PEAR .:/usr/share/php/PEAR
log_errors
 Off Off
magic_quotes_gpc
 On On
magic_quotes_runtime
 Off Off
magic_quotes_sybase
 Off Off
max_execution_time
 30 30
memory_limit
 8M 8M
open_basedir
 no value no value
output_buffering
 Off Off
output_handler
 no value no value
post_max_size
 8M 8M
precision
 14 14
register_argc_argv
 On On
register_globals
 On On
safe_mode
 Off Off
safe_mode_exec_dir
 no value no value
sendmail_from
 no value no value
sendmail_path
 /usr/sbin/sendmail -t -i  /usr/sbin/sendmail -t -i  
short_open_tag
 On On
SMTP
 localhost localhost
sql.safe_mode
 Off Off
track_errors
 Off Off
upload_max_filesize
 2M 2M
upload_tmp_dir
 no value no value
user_dir
 no value no value
variables_order
 no value no value
y2k_compliance
 Off Off


xml
XML Support active
XML Namespace Support active
EXPAT Version expat_1.95.2


wddx
WDDX Support enabled


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
safe_mode_allowed_env_vars
 PHP_ PHP_
safe_mode_protected_env_vars
 LD_LIBRARY_PATH LD_LIBRARY_PATH
session.use_trans_sid
 1 1


session
Session Support enabled

Directive Local Value Master Value
session.auto_start
 Off Off
session.cache_expire
 180 180
session.cache_limiter
 nocache nocache
session.cookie_domain
 no value no value
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_maxlifetime
 1440 1440
session.gc_probability
 1 1
session.name
 PHPSESSID PHPSESSID
session.referer_check
 no value no value
session.save_handler
 files files
session.save_path
 /tmp /tmp
session.serialize_handler
 php php
session.use_cookies
 On On


posix
Revision $Revision: 1.28.2.1 $


pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.4 22-Aug-2000


openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.6 24 Sep 2000


bcmath
BCMath support enabled


zlib
ZLib Support enabled
'zlib:' fopen wrapper enabled
Compiled Version 1.1.3
Linked Version 1.1.3


apache
APACHE_INCLUDE  
APACHE_TARGET  
Apache Version Apache/1.3.20
Apache Release 10320100
Apache API Version 19990320
Hostname:Port www.d2net.com:80
User/Group www(100)/102
Max Requests Per Child: 100
Keep Alive: on
Max Per Connection: 100
Timeouts Connection: 300
Keep-Alive: 15
Server Root /etc/httpd
Loaded Modules mod_ssl, mod_php4, mod_setenvif, mod_so, mod_usertrack, mod_headers, mod_expires, mod_digest, mod_auth_external, mod_auth_db, mod_auth_anon, mod_auth, mod_access, mod_rewrite, mod_alias, mod_proxy, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_info, mod_status, mod_negotiation, mod_mime, mod_log_referer, mod_log_agent, mod_log_config, mod_env, http_core


Apache Environment
Variable Value
DOCUMENT_ROOT /home/e-smith/files/primary/html
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-gsarcade-launch, */*
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-us
HTTP_CONNECTION Keep-Alive
HTTP_HOST 66.92.96.7
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
REMOTE_ADDR 66.92.96.5
REMOTE_PORT 61848
SCRIPT_FILENAME /home/e-smith/files/primary/html/php.php
SERVER_ADDR 66.92.96.7
SERVER_ADMIN admin@d2net.com
SERVER_NAME 66.92.96.7
SERVER_PORT 80
SERVER_SIGNATURE  
SERVER_SOFTWARE Apache/1.3.19 (Unix)  (Red-Hat/Linux) mod_ssl/2.8.1 OpenSSL/0.9.6 PHP/4.0.6
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING  
REQUEST_URI /php.php
SCRIPT_NAME /php.php


HTTP Headers Information
HTTP Request Headers
HTTP Request GET /php.php HTTP/1.1
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-gsarcade-launch, */*
Accept-Encoding gzip, deflate
Accept-Language en-us
Connection Keep-Alive
Host 66.92.96.7
User-Agent Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
HTTP Response Headers
X-Powered-By PHP/4.0.6
Keep-Alive timeout=15, max=99
Connection Keep-Alive
Transfer-Encoding chunked
Content-Type text/html


Additional Modules
Session MM


Environment
Variable Value
PWD /
BOOT_FILE /boot/vmlinuz-2.2.19-7.0.8
HOSTNAME host3
CONSOLE /dev/console
PREVLEVEL N
AUTOBOOT YES
runlevel 7
MACHTYPE i386-redhat-linux-gnu
SHLVL 2
previous N
BOOT_IMAGE esmith
SHELL /bin/bash
HOSTTYPE i386
OSTYPE linux-gnu
HOME /root
TERM linux
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
RUNLEVEL 7
INIT_VERSION sysvinit-2.78
_ /bin/nice


PHP Variables
Variable Value
PHP_SELF /php.php
HTTP_SERVER_VARS["DOCUMENT_ROOT"] /home/e-smith/files/primary/html  
HTTP_SERVER_VARS["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-gsarcade-launch, */*  
HTTP_SERVER_VARS["HTTP_ACCEPT_ENCODING"] gzip, deflate  
HTTP_SERVER_VARS["HTTP_ACCEPT_LANGUAGE"] en-us  
HTTP_SERVER_VARS["HTTP_CONNECTION"] Keep-Alive  
HTTP_SERVER_VARS["HTTP_HOST"] *******(commented out on purpose)
HTTP_SERVER_VARS["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)  
HTTP_SERVER_VARS["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin  
HTTP_SERVER_VARS["REMOTE_ADDR"] 66.92.96.5  
HTTP_SERVER_VARS["REMOTE_PORT"] 61848  
HTTP_SERVER_VARS["SCRIPT_FILENAME"] /home/e-smith/files/primary/html/php.php  
HTTP_SERVER_VARS["SERVER_ADDR"] ********** (commented out on purpose)
HTTP_SERVER_VARS["SERVER_ADMIN"] *********
HTTP_SERVER_VARS["SERVER_NAME"] *********
HTTP_SERVER_VARS["SERVER_PORT"] 80  
HTTP_SERVER_VARS["SERVER_SIGNATURE"]  
HTTP_SERVER_VARS["SERVER_SOFTWARE"] Apache/1.3.19 (Unix)  (Red-Hat/Linux) mod_ssl/2.8.1 OpenSSL/0.9.6 PHP/4.0.6  
HTTP_SERVER_VARS["GATEWAY_INTERFACE"] CGI/1.1  
HTTP_SERVER_VARS["SERVER_PROTOCOL"] HTTP/1.1  
HTTP_SERVER_VARS["REQUEST_METHOD"] GET  
HTTP_SERVER_VARS["QUERY_STRING"]  
HTTP_SERVER_VARS["REQUEST_URI"] /php.php  
HTTP_SERVER_VARS["SCRIPT_NAME"] /php.php  
HTTP_SERVER_VARS["PATH_TRANSLATED"] /home/e-smith/files/primary/html/php.php  
HTTP_SERVER_VARS["PHP_SELF"] /php.php  
HTTP_SERVER_VARS["argv"] Array
(
)

 
HTTP_SERVER_VARS["argc"] 0  
HTTP_ENV_VARS["PWD"] /  
HTTP_ENV_VARS["BOOT_FILE"] /boot/vmlinuz-2.2.19-7.0.8  
HTTP_ENV_VARS["HOSTNAME"] host3  
HTTP_ENV_VARS["CONSOLE"] /dev/console  
HTTP_ENV_VARS["PREVLEVEL"] N  
HTTP_ENV_VARS["AUTOBOOT"] YES  
HTTP_ENV_VARS["runlevel"] 7  
HTTP_ENV_VARS["MACHTYPE"] i386-redhat-linux-gnu  
HTTP_ENV_VARS["SHLVL"] 2  
HTTP_ENV_VARS["previous"] N  
HTTP_ENV_VARS["BOOT_IMAGE"] esmith  
HTTP_ENV_VARS["SHELL"] /bin/bash  
HTTP_ENV_VARS["HOSTTYPE"] i386  
HTTP_ENV_VARS["OSTYPE"] linux-gnu  
HTTP_ENV_VARS["HOME"] /root  
HTTP_ENV_VARS["TERM"] linux  
HTTP_ENV_VARS["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin  
HTTP_ENV_VARS["RUNLEVEL"] 7  
HTTP_ENV_VARS["INIT_VERSION"] sysvinit-2.78  
HTTP_ENV_VARS["_"] /bin/nice  


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.

[Dan Brown]

Well, without seeing for sure, it looks like php-mysql isn't installed--what does 'rpm -q php-mysql' say?

[adam hampton]

it said not installed for mysql. but if i do a rpm -Uvh it says package already installed . also ldap, imap are not installed either

[adam hampton]

Thanks for the quick response dan but since it was only my dev server I did a reinstall of e-smith and just ran the updates again. I beleive i had the wrong version of expat. I installed the version for 4.06 and not for 4.06-10 I think that screwed it all up. Plus a little practice at the command line didnt hurt me either. thanks again

[Adam]

Ok here I go again using dan browns updated php upgrade...(found on mailing list). I did verbatim what was asked ]
download packages.
[root@e-smith /root]# cd /path/to/downloaded/files
[root@e-smith /root]# rpm -Uvh *
[root@e-smith /root]# pico /etc/php.ini
display_errors and set that to Off.  (did that as well)
Since I am new to linux and pico i did control X to save and exit and wrote file as php.ini in the /etc/ directory.
And I am **pretty sure** I restarted my web server

Cool great run my little phpinfo script..
ok php works ldap mysql etc working great.
Add  phpmyadmin and get it working
I add my website (myphpnuke based)
cool every thing works
Several hours later i go to look up my web site and nothing but a blank page.
So run phpinfo script again.
ok php works....
but no mysql, ldap..etc.
Ok hit the shell
rpm -q php...-mysql. i686 (shortened )
rpm not installed
same thing with ldap, msql, etc.  and the php 4.06 packages downloaded. but phpinfo shows 4.06-10.
I have no idea whats going on. This was on a fresh install.. I dont beleive I had updated the blades to the second fix.
Also is it possible that by not restarting the web server that these things are working.

**** some additional info**** All rpms were dl's to a windoze box and then ftp'd in binary form to server.
****server info***
p3 450 mhz 1 gig ram 18 gig 10,000 rpm seagate scsi hard drive.
stand realtek network card working great.

The support here is great and I hope that i have provided enough info. I hope I can get this updated because I want to use things like my e- gallery and such. Thanks again.