
8th October 2009, 05:48
|
|
Senior Member
|
|
Join Date: Sep 2009
Location: Dallas, TX
Posts: 306
Thanks: 10
Thanked 35 Times in 22 Posts
|
|
Broken php5-mysql
I think that I havE over-stepped my Linux knowledge on this one!
I have been trying to install a cacher for php5 on a debian Lenny perfect server using falko's tutorial for the base system. I had installed xcache, but I uninstalled that and used eAccellerator. eAccellerator is not compatible with my version of php5 because I have installed the dotdeb.org updates to the system. I got rid of eAccellerator and apache2 restarts now, but none of the sites are connecting because php is missing the mysql extensions.
I have went through several forums to figure this out, but I have had no luck. The appropriate lines are uncommented in all php.ini files.
How can I fix this? Is there a way to completely reinstall php5 from scratch? I don't want to lose any of my sites that are on the server!
Thanks,
Drew
Last edited by dclardy; 8th October 2009 at 05:50.
Reason: Spelling
|

8th October 2009, 08:07
|
|
Senior Member
|
|
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 48 Times in 40 Posts
|
|
Have you installed php5-mysql package?
You can't loose the sites if you reinstall php.
|

8th October 2009, 13:02
|
|
Senior Member
|
|
Join Date: Sep 2009
Location: Dallas, TX
Posts: 306
Thanks: 10
Thanked 35 Times in 22 Posts
|
|
Yes the package is there. It seems that a relationship is missing somewhere.
What is the best way to remove and then reinstall php5?
|

8th October 2009, 19:26
|
|
Senior Member
|
|
Join Date: Sep 2009
Location: Dallas, TX
Posts: 306
Thanks: 10
Thanked 35 Times in 22 Posts
|
|
Any other ideas on this? My sites are not functioning because of this.
I uninstalled everything dealing with php5 by running this command:
apt-get remove --purge php5*
and then I reinstalled everything from the ISPConfig3 Perfect Server tutorial.
Any other things I can do? My sites are not functioning properly because of this.
|

8th October 2009, 21:22
|
|
Senior Member
|
|
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 48 Times in 40 Posts
|
|
What is the error you are getting when you type the url of the site? Is it PHP related or ?
|

8th October 2009, 22:45
|
|
Senior Member
|
|
Join Date: Sep 2009
Location: Dallas, TX
Posts: 306
Thanks: 10
Thanked 35 Times in 22 Posts
|
|
The error for one site is this:
Code:
Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
The other sites are drupal CMS installs. They get this error.
Code:
Site off-line
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.
--------------------------------------------------------------------------------
If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.
The mysqli error was: Unable to use the MySQLi database because the MySQLi extension for PHP is not installed. Check your <code>php.ini</code> to see how you can enable it..
|

8th October 2009, 22:46
|
|
Senior Member
|
|
Join Date: Sep 2009
Location: Dallas, TX
Posts: 306
Thanks: 10
Thanked 35 Times in 22 Posts
|
|
Here is my phpinfo()
Code:
PHP Version 5.2.11-0.dotdeb.1
System Linux server.clardyhost.info 2.6.26-2-686 #1 SMP Wed Aug 19 06:06:52 UTC 2009 i686
Build Date Sep 20 2009 09:36:06
Server API CGI/FastCGI
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php5/cgi
Loaded Configuration File /etc/php5/cgi/php.ini
Scan this dir for additional .ini files /etc/php5/cgi/conf.d
additional .ini files parsed /etc/php5/cgi/conf.d/gd.ini, /etc/php5/cgi/conf.d/imagick.ini, /etc/php5/cgi/conf.d/imap.ini, /etc/php5/cgi/conf.d/mcrypt.ini, /etc/php5/cgi/conf.d/mysql.ini, /etc/php5/cgi/conf.d/mysqli.ini, /etc/php5/cgi/conf.d/pdo.ini, /etc/php5/cgi/conf.d/pdo_mysql.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 https, ftps, compress.zlib, compress.bzip2, php, file, data, http, ftp, zip
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed
This server is protected with the Suhosin Patch 0.9.7
Copyright (c) 2006 Hardened-PHP Project
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies
This program was built by Dotdeb.
--------------------------------------------------------------------------------
PHP Credits
--------------------------------------------------------------------------------
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
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 On On
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 6135 6135
expose_php On On
extension_dir /usr/lib/php5/20060613+lfs /usr/lib/php5/20060613+lfs
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/php:/usr/share/pear .:/usr/share/php:/usr/share/pear
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
mail_extra_headers On On
max_execution_time 30 30
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 128M 128M
open_basedir /var/www/clients/client1/web1 /var/www/clients/client1/web1
output_buffering no value no value
output_handler no value no value
post_max_size 8M 8M
precision 12 12
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
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
suhosin.log.phpscript 0 0
suhosin.log.phpscript.is_safe Off Off
suhosin.log.phpscript.name no value no value
suhosin.log.sapi no value no value
suhosin.log.script no value no value
suhosin.log.script.name no value no value
suhosin.log.syslog no value no value
suhosin.log.syslog.facility no value no value
suhosin.log.syslog.priority no value no value
suhosin.log.use-x-forwarded-for Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir /var/www/clients/client1/web1/tmp /var/www/clients/client1/web1/tmp
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
bcmath
BCMath support enabled
bz2
BZip2 Support Enabled
Stream Wrapper support compress.bz2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.5, 10-Dec-2007
calendar
Calendar support enabled
cgi-fcgi
Directive Local Value Master Value
cgi.check_shebang_line 1 1
cgi.fix_pathinfo 1 1
cgi.nph 0 0
cgi.rfc2616_headers 0 0
fastcgi.logging 1 1
ctype
ctype functions enabled
date
date/time support enabled
"Olson" Timezone Database Version 2009.13
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
dba
DBA support enabled
Supported handlers cdb cdb_make db4 inifile flatfile
dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.32
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled
exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c 287371 2009-08-16 14:31:27Z iliaa $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF
filter
Input Validation and Filtering enabled
Revision $Revision: 288083 $
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
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
libxml
libXML support active
libXML Version 2.6.32
libXML streams enabled
mbstring
Multibyte Support enabled
Multibyte string engine libmbfl
Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) version 4.4.4
Multibyte regex (oniguruma) backtrack check On
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value
mime_magic
mime_magic support invalid magic file, disabled
Directive Local Value Master Value
mime_magic.debug Off Off
mime_magic.magicfile /usr/share/file/magic.mime /usr/share/file/magic.mime
openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.8g 19 Oct 2007
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 7.9 2009-04-11
Directive Local Value Master Value
pcre.backtrack_limit 100000 100000
pcre.recursion_limit 100000 100000
posix
Revision $Revision: 286880 $
Reflection
Reflection enabled
Version $Id: php_reflection.c 287991 2009-09-03 14:02:51Z sebastian $
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 On On
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 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 0 0
session.hash_bits_per_character 4 4
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/www/clients/client1/web1/tmp /var/www/clients/client1/web1/tmp
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: 272374 $
Schema support enabled
soap
Soap Client enabled
Soap Server enabled
Directive Local Value Master Value
soap.wsdl_cache 1 1
soap.wsdl_cache_dir /tmp /tmp
soap.wsdl_cache_enabled 1 1
soap.wsdl_cache_limit 5 5
soap.wsdl_cache_ttl 86400 86400
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=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent no value no value
sysvmsg
sysvmsg support enabled
Revision $Revision: 272374 $
tokenizer
Tokenizer Support enabled
wddx
WDDX Support enabled
WDDX Session Serializer enabled
xml
XML Support active
XML Namespace Support active
libxml2 Version 2.6.32
xmlreader
XMLReader enabled
xmlwriter
XMLWriter enabled
zip
Zip enabled
Extension Version $Id: php_zip.c 287723 2009-08-26 02:16:41Z guenter $
Zip version 1.8.11
Libzip version 0.9.0
zlib
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.1.1
Linked Version 1.2.3.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
PHPRC /etc/php5/cgi/
PHP_DOCUMENT_ROOT /var/www/clients/client1/web1
PATH /usr/local/bin:/usr/bin:/bin
PWD /var/www/php-fcgi-scripts/web1
SHLVL 0
PHP_FCGI_MAX_REQUESTS 5000
PHP Variables
Variable Value
_SERVER["PHPRC"] /etc/php5/cgi/
_SERVER["PHP_DOCUMENT_ROOT"] /var/www/clients/client1/web1
_SERVER["PATH"] /usr/local/bin:/usr/bin:/bin
_SERVER["PWD"] /var/www/php-fcgi-scripts/web1
_SERVER["SHLVL"] 0
_SERVER["PHP_FCGI_MAX_REQUESTS"] 5000
_SERVER["FCGI_ROLE"] RESPONDER
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, */*
_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; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.1; MS-RTC LM 8)
_SERVER["HTTP_HOST"] www.drewclardy.info
_SERVER["HTTP_CACHE_CONTROL"] max-stale=0
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_X_BLUECOAT_VIA"] FB13EFD2B8BD65AE
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.9 (Debian) PHP/5.2.11-0.dotdeb.1 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g Server at www.drewclardy.info Port 80</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.2.9 (Debian) PHP/5.2.11-0.dotdeb.1 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g
_SERVER["SERVER_NAME"] www.drewclardy.info
_SERVER["SERVER_ADDR"] 192.168.1.197
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 12.6.128.8
_SERVER["DOCUMENT_ROOT"] /var/www/drewclardy.info/web
_SERVER["SERVER_ADMIN"] webmaster@drewclardy.info
_SERVER["SCRIPT_FILENAME"] /var/www/drewclardy.info/web/info.php
_SERVER["REMOTE_PORT"] 5939
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /info.php
_SERVER["SCRIPT_NAME"] /info.php
_SERVER["PHP_SELF"] /info.php
_SERVER["REQUEST_TIME"] 1255034740
_SERVER["argv"] Array
(
)
_SERVER["argc"] 0
_ENV["PHPRC"] /etc/php5/cgi/
_ENV["PHP_DOCUMENT_ROOT"] /var/www/clients/client1/web1
_ENV["PATH"] /usr/local/bin:/usr/bin:/bin
_ENV["PWD"] /var/www/php-fcgi-scripts/web1
_ENV["SHLVL"] 0
_ENV["PHP_FCGI_MAX_REQUESTS"] 5000
_ENV["FCGI_ROLE"] RESPONDER
_ENV["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, */*
_ENV["HTTP_ACCEPT_LANGUAGE"] en-us
_ENV["HTTP_UA_CPU"] x86
_ENV["HTTP_ACCEPT_ENCODING"] gzip, deflate
_ENV["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.1; MS-RTC LM 8)
_ENV["HTTP_HOST"] www.drewclardy.info
_ENV["HTTP_CACHE_CONTROL"] max-stale=0
_ENV["HTTP_CONNECTION"] Keep-Alive
_ENV["HTTP_X_BLUECOAT_VIA"] FB13EFD2B8BD65AE
_ENV["SERVER_SIGNATURE"] <address>Apache/2.2.9 (Debian) PHP/5.2.11-0.dotdeb.1 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g Server at www.drewclardy.info Port 80</address>
_ENV["SERVER_SOFTWARE"] Apache/2.2.9 (Debian) PHP/5.2.11-0.dotdeb.1 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g
_ENV["SERVER_NAME"] www.drewclardy.info
_ENV["SERVER_ADDR"] 192.168.1.197
_ENV["SERVER_PORT"] 80
_ENV["REMOTE_ADDR"] 12.6.128.8
_ENV["DOCUMENT_ROOT"] /var/www/drewclardy.info/web
_ENV["SERVER_ADMIN"] webmaster@drewclardy.info
_ENV["SCRIPT_FILENAME"] /var/www/drewclardy.info/web/info.php
_ENV["REMOTE_PORT"] 5939
_ENV["GATEWAY_INTERFACE"] CGI/1.1
_ENV["SERVER_PROTOCOL"] HTTP/1.1
_ENV["REQUEST_METHOD"] GET
_ENV["QUERY_STRING"] no value
_ENV["REQUEST_URI"] /info.php
_ENV["SCRIPT_NAME"] /info.php
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.
|

8th October 2009, 23:39
|
|
Senior Member
|
|
Join Date: Sep 2009
Location: Dallas, TX
Posts: 306
Thanks: 10
Thanked 35 Times in 22 Posts
|
|
Please help me! I know that my little server is not a big deal to everyone else, but it means a lot to me. Any ideas here?
|

9th October 2009, 09:49
|
|
Senior Member
|
|
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 48 Times in 40 Posts
|
|
Whats the output of:
/etc/init.d/mysql status
and
dpkg --list | grep php5-mysql
|
| Thread Tools |
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT +2. The time now is 09:08.
|
|
Recent comments
1 day 8 hours ago
1 day 11 hours ago
1 day 13 hours ago
1 day 14 hours ago
1 day 16 hours ago
1 day 17 hours ago
1 day 18 hours ago
2 days 10 hours ago
2 days 11 hours ago
2 days 15 hours ago