MySQL error after Ports upgrade
Craig Hoffman
choffman at eclimb.net
Tue May 4 07:33:29 PDT 2010
Hi Chris -
> "Show PHP information"
Nothing
> php -i
Here you go. Sorry about the long list...
phpinfo()
PHP Version => 5.3.2
System => Darwin Craig-Hoffmans-MacBook-Pro.local 10.3.0 Darwin Kernel Version 10.3.0: Fri Feb 26 11:58:09 PST 2010; root:xnu-1504.3.12~1/RELEASE_I386 i386
Build Date => May 4 2010 04:54:28
Configure Command => './configure' '--prefix=/opt/local' '--mandir=/opt/local/share/man' '--infodir=/opt/local/share/info' '--with-config-file-path=/opt/local/etc/php5' '--with-config-file-scan-dir=/opt/local/var/db/php5' '--disable-all' '--enable-bcmath' '--enable-ctype' '--enable-dom' '--enable-fileinfo' '--enable-filter' '--enable-hash' '--enable-json' '--enable-libxml' '--enable-pdo' '--enable-phar' '--enable-session' '--enable-simplexml' '--enable-tokenizer' '--enable-xml' '--enable-xmlreader' '--enable-xmlwriter' '--with-bz2=/opt/local' '--with-mhash=/opt/local' '--with-pcre-regex=/opt/local' '--with-readline=/opt/local' '--with-libxml-dir=/opt/local' '--with-zlib=/opt/local' '--disable-cgi' '--with-ldap=/usr' '--with-apxs2=/opt/local/apache2/bin/apxs' '--with-pear=/opt/local/lib/php'
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /opt/local/etc/php5
Loaded Configuration File => /opt/local/etc/php5/php.ini
Scan this dir for additional .ini files => /opt/local/var/db/php5
Additional .ini files parsed => /opt/local/var/db/php5/FreeImage.ini,
/opt/local/var/db/php5/calendar.ini,
/opt/local/var/db/php5/curl.ini,
/opt/local/var/db/php5/exif.ini,
/opt/local/var/db/php5/ftp.ini,
/opt/local/var/db/php5/gd.ini,
/opt/local/var/db/php5/geoip.ini,
/opt/local/var/db/php5/gettext.ini,
/opt/local/var/db/php5/gmagick.ini,
/opt/local/var/db/php5/http.ini,
/opt/local/var/db/php5/iconv.ini,
/opt/local/var/db/php5/imagick.ini,
/opt/local/var/db/php5/imap.ini,
/opt/local/var/db/php5/mbstring.ini,
/opt/local/var/db/php5/mcrypt.ini,
/opt/local/var/db/php5/memcache.ini,
/opt/local/var/db/php5/mysql.ini,
/opt/local/var/db/php5/odbc.ini,
/opt/local/var/db/php5/openssl.ini,
/opt/local/var/db/php5/pspell.ini,
/opt/local/var/db/php5/soap.ini,
/opt/local/var/db/php5/sqlite.ini,
/opt/local/var/db/php5/tidy.ini,
/opt/local/var/db/php5/xdebug.ini,
/opt/local/var/db/php5/zip.ini
PHP API => 20090626
PHP Extension => 20090626
Zend Extension => 220090626
Zend Extension Build => API220090626,NTS
PHP Extension Build => API20090626,NTS
Debug Build => no
Thread Safety => disabled
Zend Memory Manager => enabled
Zend Multibyte Support => disabled
IPv6 Support => enabled
Registered PHP Streams => compress.zlib, compress.bzip2, https, ftps, php, file, glob, data, http, ftp, phar, zip
Registered Stream Socket Transports => tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters => zlib.*, bzip2.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, http.*, convert.iconv.*
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with Xdebug v2.0.5, Copyright (c) 2002-2008, by Derick Rethans
Abort trap
Here's what's installed:
Craig-Hoffmans-MacBook-Pro:~ choffman$ port installed *php*
The following ports are currently installed:
php5 @5.3.2_0+apache2+darwin_10+fastcgi+imap+macosx+mysql5+pear+pspell+sqlite+tidy+universal
php5 @5.3.2_0+apache2+darwin_10+macosx
php5 @5.3.2_0+apache2+darwin_10+macosx+mysql5+pear (active)
php5 @5.3.2_0+apache2+darwin_10+macosx+universal
php5-calendar @5.3.2_0+universal (active)
php5-curl @5.3.2_0+universal (active)
php5-exif @5.3.2_0+universal (active)
php5-FreeImage @0.1_0+universal (active)
php5-ftp @5.3.2_0+universal (active)
php5-gd @5.3.2_1+universal (active)
php5-geoip @1.0.7_1+universal (active)
php5-gettext @5.3.2_0+universal (active)
php5-gmagick @1.0.3b5_1+universal (active)
php5-http @1.6.6_1+universal (active)
php5-iconv @5.3.2_0+universal (active)
php5-imagick @2.3.0_3+universal (active)
php5-imap @5.3.2_0+macosx+universal (active)
php5-mbstring @5.3.2_0+universal (active)
php5-mcrypt @5.3.2_0+universal (active)
php5-memcache @2.2.5_3+universal (active)
php5-mysql @5.3.2_0+mysql5+universal (active)
php5-odbc @5.3.2_0+universal (active)
php5-openssl @5.3.2_0+macosx+universal (active)
php5-pspell @5.3.2_0+universal (active)
php5-soap @5.3.2_0+universal (active)
php5-sqlite @5.3.2_0+universal (active)
php5-tidy @5.3.2_0+universal (active)
php5-xdebug @2.0.5_2+universal (active)
php5-zip @5.3.2_0+universal (active)
_______________________
Craig Hoffman
iChat / AIM: mountain.dog
_______________________
On May 4, 2010, at 7:22 AM, Chris Janton wrote:
> On 2010-05-04 , at 03:34 , Craig Hoffman wrote:
>>
>> I took this opportunity to upgrade to PHP 5.3 from 5.2.13 and perhaps learn a few things in the process. Anyhow, the upgrade process ran fine. PHP, MySQL and Apache came back online - all showing the correct versions. All me PHP/MySQL sites work just fine. PhpMyAdmin works.
>>
>> Apache outputs this:
>>> Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/0.9.8n DAV/2 PHP/5.3.2 Server at localhost Port 80
>>
>> Here's the really strange part, when I try to access a PHP script to show the install (<?php phpinfo(); ?>), Safari tells me "Safari can’t open the page “http://localhost/~choffman/index.php” because the server unexpectedly dropped the connection. This sometimes occurs when the server is busy. Wait for a few minutes, and then try again." Firefox wants to download the showphp.php (phpifo()) file. Very odd.
>
> OK - so if phpMyAdmin works what happens if you click on the link
>
> "Show PHP information"
>
> that shows up on the right column of the main page? That runs the phpinfo() if you have configured it to do so.
>
> What happens if you do
>
> php -i
>
> from the command line?
>
> Turn on full error reporting in PHP/Apache by making sure this is set in php.ini
>
> error_reporting = E_ALL
>
> PHP 5.3 definitely causes some "amusement", depending on what/how your php is configured
>
> face at mac:~:123 $ port installed *php*
> The following ports are currently installed:
> php5 @5.3.2_0+apache2+darwin_10+macosx+pear (active)
> php5-apc @3.1.3p1_2 (active)
> php5-calendar @5.3.2_0 (active)
> php5-curl @5.3.2_0 (active)
> php5-dba @5.3.2_0 (active)
> php5-exif @5.3.2_0 (active)
> php5-ftp @5.3.2_0 (active)
> php5-gd @5.3.2_1 (active)
> php5-gearman @0.7.0_0 (active)
> php5-gettext @5.3.2_0 (active)
> php5-gmp @5.3.2_0 (active)
> php5-iconv @5.3.2_0 (active)
> php5-imagick @2.3.0_3 (active)
> php5-imap @5.3.2_0+macosx (active)
> php5-mbstring @5.3.2_0 (active)
> php5-mcrypt @5.3.2_0 (active)
> php5-memcache @2.2.5_3 (active)
> php5-mssql @5.3.2_0 (active)
> php5-mysql @5.3.2_0+mysqlnd (active)
> php5-odbc @5.3.2_0 (active)
> php5-openssl @5.3.2_0+macosx (active)
> php5-pcntl @5.3.2_0 (active)
> php5-posix @5.3.2_0 (active)
> php5-postgresql @5.3.2_0+postgresql84 (active)
> php5-pspell @5.3.2_0 (active)
> php5-soap @5.3.2_0 (active)
> php5-sockets @5.3.2_0 (active)
> php5-SPL_Types @0.3.0_0 (active)
> php5-sqlite @5.3.2_0 (active)
> php5-tidy @5.3.2_0 (active)
> php5-wddx @5.3.2_0 (active)
> php5-web @5.3.0_0 (active)
> php5-xmlrpc @5.3.2_0 (active)
> php5-xsl @5.3.2_0 (active)
> php5-zip @5.3.2_0 (active)
>
> The following ports are currently installed:
> mysql5 @5.1.45_0
> mysql5 @5.1.46_0 (active)
> mysql5-server @5.1.45_0
> mysql5-server @5.1.46_0 (active)
>
> 8)
> ----------------------------------
> Chris Janton - face at CentosPrime dot COM
> Netminder for Opus1.COM
>
>
More information about the macports-users
mailing list