ZF-10075: PDO_MYSQL - can't find /var/lib/mysql/mysql.sock on remote shared server (rackspace cloud or webfaction)


I have a very simple zend framework application that works on a local server, but when i upload it to a shared server, either rackspace cloud, or webfaction, the application fails to connect.

my application.ini file specifies the connection parameters accordingly:

resources.db.params.charset = UTF8 resources.db.params.hostname = my_host_name resources.db.params.username = my_user_name resources.db.params.password = my_password resources.db.params.dbname = my_db_name

i have also tried specifying the unix socket, as follows to no effect.

resources.db.params.unix_socket = /var/lib/mysql/mysql.sock

Exception information:

Message: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Stack trace:

0 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()

1 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Adapter/Abstract.php(448): Zend_Db_Adapter_Pdo_Mysql->_connect()

2 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE `movie...', Array)

3 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Adapter/Pdo/Mysql.php(156): Zend_Db_Adapter_Pdo_Abstract->query('DESCRIBE `movie...')

4 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Table/Abstract.php(823): Zend_Db_Adapter_Pdo_Mysql->describeTable('movies', NULL)

5 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Table/Abstract.php(862): Zend_Db_Table_Abstract->_setupMetadata()

6 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Table/Abstract.php(969): Zend_Db_Table_Abstract->_setupPrimaryKey()

7 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Table/Select.php(100): Zend_Db_Table_Abstract->info()

8 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Table/Select.php(78): Zend_Db_Table_Select->setTable(Object(Application_Model_DbTable_Movies))

9 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Table/Abstract.php(1005): Zend_Db_Table_Select->__construct(Object(Application_Model_DbTable_Movies))

10 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Db/Table/Abstract.php(1303): Zend_Db_Table_Abstract->select()

11 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/application/controllers/IndexController.php(17): Zend_Db_Table_Abstract->fetchAll()

12 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Controller/Action.php(513): IndexController->indexAction()

13 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('indexAction')

14 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))

15 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()

16 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()

17 /mnt/stor1-wc1-dfw1/387484/www.playdev441.com/web/content/public/index.php(26): Zend_Application->run()

18 {main}

Request Parameters:

array ( 'controller' => 'index', 'action' => 'index', 'module' => 'default', )

************************** PHP INFO INFORMATION FOLLOWS *******************************

PHP Version 5.2.13

System Linux php5-n12 2.6.18-164.15.1.el5.noaccess #1 SMP Thu Mar 25 11:18:24 CDT 2010 x86_64 Build Date May 6 2010 15:36:11 Configure Command './configure' '--build=x86_64-linux-gnu' '--host=x86_64-linux-gnu' '--target=x86_64-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/lib64' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib64' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--with-kerberos' '--enable-ucd-snmp-hack' '--enable-shmop' '--enable-calendar' '--with-mime-magic' '--with-libxml-dir=/usr' '--enable-xml' '--with-system-tzdata' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-unixODBC' '--disable-dom' '--disable-dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter' '--disable-json' '--without-pspell' '--disable-wddx' '--without-curl' '--disable-posix' '--disable-sysvmsg' '--disable-sysvshm' '--disable-sysvsem' 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/bcmath.ini, /etc/php.d/browscap.ini, /etc/php.d/curl.ini, /etc/php.d/dba.ini, /etc/php.d/dbase.ini, /etc/php.d/dom.ini, /etc/php.d/gd.ini, /etc/php.d/imagick.ini, /etc/php.d/imap.ini, /etc/php.d/ioncube.ini, /etc/php.d/json.ini, /etc/php.d/ldap.ini, /etc/php.d/libpdf_php.ini, /etc/php.d/mbstring.ini, /etc/php.d/mcrypt.ini, /etc/php.d/memcache.ini, /etc/php.d/mhash.ini, /etc/php.d/mssql.ini, /etc/php.d/mysql.ini, /etc/php.d/mysqli.ini, /etc/php.d/ncurses.ini, /etc/php.d/odbc.ini, /etc/php.d/pdo.ini, /etc/php.d/pdo_dblib.ini, /etc/php.d/pdo_mysql.ini, /etc/php.d/pdo_odbc.ini, /etc/php.d/pdo_pgsql.ini, /etc/php.d/pdo_sqlite.ini, /etc/php.d/pgsql.ini, /etc/php.d/pspell.ini, /etc/php.d/snmp.ini, /etc/php.d/soap.ini, /etc/php.d/sqlite.ini, /etc/php.d/sybase_ct.ini, /etc/php.d/tidy.ini, /etc/php.d/uploadprogress.ini, /etc/php.d/wddx.ini, /etc/php.d/xmlreader.ini, /etc/php.d/xmlrpc.ini, /etc/php.d/xmlwriter.ini, /etc/php.d/xsl.ini, /etc/php.d/yaz.ini, /etc/php.d/zend.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 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-2010 Zend Technologies with the ionCube PHP Loader v3.3.16, Copyright (c) 2002-2010, by ionCube Ltd., and with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies with Zend Optimizer v3.3.9, Copyright (c) 1998-2009, by Zend Technologies

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 /etc/browscap.ini /etc/browscap.ini 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 leak,posix_getpwuid,posix_getpwnam,posix_getgrid,posix_getgrnam,posix_getgroups leak,posix_getpwuid,posix_getpwnam,posix_getgrid,posix_getgrnam,posix_getgroups 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 Off Off error_append_string no value no value error_log /someserver.com/logs/php_errors.log no value error_prepend_string no value no value error_reporting 6135 6135 expose_php Off Off extension_dir /usr/lib64/php/modules /usr/lib64/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 /mnt//www.someserver.com/web/content/application/../library:/someserver.com/web/content/library:.:/usr/share/pear .:/usr/share/pear log_errors On On 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 max_execution_time 30 30 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 60 60 memory_limit 32M 32M open_basedir no value no value output_buffering no value no value output_handler no value no value post_max_size 8M 8M precision 14 14 realpath_cache_size 4M 4M 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 /tmp /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

apache2handler Apache Version Apache/2.2 Apache API Version 20051115 Server Administrator root@localhost Hostname:Port localhost:0 User/Group www-data(33)/33 Max Requests Per Child: 750 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 10 - Keep-Alive: 5 Virtual Server No Server Root /etc/httpd Loaded Modules core itk http_core mod_so mod_auth_basic mod_authn_file mod_authz_host mod_authz_user mod_authz_groupfile mod_authz_default mod_include mod_log_config mod_env mod_expires mod_headers mod_setenvif mod_mime mod_status mod_autoindex mod_negotiation mod_dir mod_alias mod_rewrite mod_actions mod_unique_id mod_auth_mysql mod_deflate mod_nogzip mod_rpaf-2 mod_php5

Directive Local Value Master Value engine 1 1 last_modified 0 0 xbithack 0 0

Apache Environment Variable Value REDIRECT_UNIQUE_ID TCpFeqwRAmYAAC1jiyoAAAAB REDIRECT_SCRIPT_URL /index/info REDIRECT_SCRIPT_URI http://www.someserver.com/index/info REDIRECT_PHP_DOCUMENT_ROOT /someserver.com/web/content REDIRECT_STATUS 200 UNIQUE_ID TCpFeqwRAmYAAC1jiyoAAAAB SCRIPT_URL /index/info SCRIPT_URI http://www.someserver.com/index/info PHP_DOCUMENT_ROOT /someserver.com/web/content HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv: Gecko/20100625 Firefox/3.6.6 FirePHP/0.4 HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8 HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5 HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7 HTTP_HOST www.someserver.com HTTP_KEEP_ALIVE 115 HTTP_X_MOSSO_DT PHP5-10 HTTP_X_CLUSTER_CLIENT_IP HTTP_COOKIE X-Mapping-goahfekk=1F3DAF595499EBA20EC0A9FD230C1A14 HTTP_CONNECTION keep-alive HTTP_ACCEPT_ENCODING gzip,deflate PATH /sbin:/usr/sbin:/bin:/usr/bin SERVER_SIGNATURE

Apache/2.2 Server at www.someserver.com Port 80

SERVER_SOFTWARE Apache/2.2 SERVER_NAME www.someserver.com SERVER_ADDR SERVER_PORT 80 REMOTE_ADDR DOCUMENT_ROOT /var/www/html SERVER_ADMIN root@localhost SCRIPT_FILENAME /someserver.com/web/content/public/index.php REMOTE_PORT 47378 REDIRECT_URL /index/info GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /index/info SCRIPT_NAME /public/index.php

HTTP Headers Information HTTP Request Headers HTTP Request GET /index/info HTTP/1.1 User-Agent Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv: Gecko/20100625 Firefox/3.6.6 FirePHP/0.4 Accept text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8 Accept-Language en-us,en;q=0.5 Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7 Host www.someserver.com Keep-Alive 115 X-Mosso-DT PHP5-10 X-Cluster-Client-Ip Cookie X-Mapping-goahfekk=1F3DAF595499EBA20EC0A9FD230C1A14 Connection keep-alive Accept-Encoding gzip,deflate HTTP Response Headers

bcmath BCMath support enabled

bz2 BZip2 Support Enabled Stream Wrapper support compress.bz2:// Stream Filter support bzip2.decompress, bzip2.compress BZip2 Version 1.0.3, 15-Feb-2005

calendar Calendar support enabled

ctype ctype functions enabled

curl cURL support enabled cURL Information libcurl/7.15.5 OpenSSL/0.9.8b zlib/1.2.3 libidn/0.6.5

date date/time support enabled "Olson" Timezone Database Version 2010.2 Timezone Database internal Default timezone Europe/London

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 Europe/London 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.26 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 293036 2010-01-03 09:23:27Z sebastian $ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF

filter Input Validation and Filtering enabled Revision $Revision: 293051 $

Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value

ftp FTP support enabled

gd GD Support enabled GD Version bundled (2.0.34 compatible) FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.2.1 GIF Read Support enabled GIF Create Support enabled JPG Support enabled PNG Support enabled WBMP Support enabled XPM Support enabled XBM Support enabled

gettext GetText Support enabled

gmp gmp support enabled GMP version 4.1.4

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

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

imagick imagick module enabled imagick module version 2.2.1 imagick classes Imagick, ImagickDraw, ImagickPixel, ImagickPixelIterator ImageMagick version ImageMagick 6.2.8 03/31/08 Q16 file:/usr/share/ImageMagick-6.2.8/doc/index.html ImageMagick copyright Copyright (C) 1999-2006 ImageMagick Studio LLC ImageMagick release date 03/31/08 ImageMagick Number of supported formats: 153 ImageMagick Supported formats A, ART, AVI, AVS, B, BMP, BMP2, BMP3, C, CACHE, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CUR, CUT, DCM, DCX, DNG, DOT, DPS, DPX, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, FAX, FITS, FRACTAL, G, G3, GIF, GIF87, GRADIENT, GRAY, HISTOGRAM, HTM, HTML, ICB, ICO, ICON, INFO, JNG, JPEG, JPG, K, LABEL, M, M2V, MAP, MAT, MATTE, MIFF, MNG, MONO, MPC, MPEG, MPG, MSL, MTV, MVG, NULL, O, OTB, OTF, P7, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PFA, PFB, PGM, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG24, PNG32, PNG8, PNM, PPM, PREVIEW, PS, PS2, PS3, PSD, PTIF, PWP, R, RAS, RGB, RGBA, RGBO, RLA, RLE, SCR, SCT, SFW, SGI, SHTML, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, TIFF, TILE, TIM, TTC, TTF, TXT, UIL, UYVY, VDA, VICAR, VID, VIFF, VST, WBMP, WMF, WMZ, WPG, X, XBM, XC, XCF, XPM, XV, XWD, Y, YCbCr, YCbCrA, YUV

Directive Local Value Master Value imagick.locale_fix 0 0

imap IMAP c-Client Version 2004 SSL Support enabled Kerberos Support enabled

json json support enabled json version 1.2.1

ldap LDAP Support enabled RCS Version $Id: ldap.c 293036 2010-01-03 09:23:27Z sebastian $ Total Links 0/unlimited API Version 3001 Vendor Name OpenLDAP Vendor Version 20343 SASL Support Enabled

libxml libXML support active libXML Version 2.6.26 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

mcrypt mcrypt support enabled Version 2.5.8 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes Supported modes cbc cfb ctr ecb ncfb nofb ofb stream

Directive Local Value Master Value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value

memcache memcache support enabled Active persistent connections 0 Version 2.2.3 Revision $Revision: 1.98 $

Directive Local Value Master Value memcache.allow_failover 1 1 memcache.chunk_size 8192 8192 memcache.default_port 11211 11211 memcache.hash_function crc32 crc32 memcache.hash_strategy standard standard memcache.max_failover_attempts 20 20

mhash MHASH support Enabled MHASH API Version 20060101

mime_magic mime_magic support enabled

Directive Local Value Master Value mime_magic.debug Off Off mime_magic.magicfile /etc/httpd/conf/magic /etc/httpd/conf/magic

mssql MSSQL Support enabled Active Persistent Links 0 Active Links 0 Library version FreeTDS

Directive Local Value Master Value mssql.allow_persistent On On mssql.batchsize 0 0 mssql.charset no value no value mssql.compatability_mode Off Off mssql.connect_timeout 5 5 mssql.datetimeconvert Off Off mssql.max_links Unlimited Unlimited mssql.max_persistent Unlimited Unlimited mssql.max_procs Unlimited Unlimited mssql.min_error_severity 10 10 mssql.min_message_severity 10 10 mssql.secure_connection Off Off mssql.textlimit Server default Server default mssql.textsize Server default Server default mssql.timeout 60 60

mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 5.0.77 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib64/mysql -lmysqlclient

Directive Local Value Master Value mysql.allow_persistent Off Off 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.77 Client API header version 5.0.77 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

ncurses ncurses support enabled ncurses library version 5.5 color support yes

odbc ODBC Support enabled Active Persistent Links 0 Active Links 0 ODBC library unixODBC ODBC_INCLUDE -I/usr/include ODBC_LFLAGS -L/usr/lib64 ODBC_LIBS -lodbc

Directive Local Value Master Value odbc.allow_persistent On On odbc.check_persistent On On odbc.default_cursortype Static cursor Static cursor odbc.default_db no value no value odbc.default_pw no value no value odbc.default_user no value no value odbc.defaultbinmode return as is return as is odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes odbc.max_links Unlimited Unlimited odbc.max_persistent Unlimited Unlimited

openssl OpenSSL support enabled OpenSSL Version OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008

pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 6.6 06-Feb-2006

Directive Local Value Master Value pcre.backtrack_limit 100000 100000 pcre.recursion_limit 100000 100000

pdf PDF Support enabled PDFlib GmbH Binary-Version 7.0.2 PECL Version 2.1.3 Revision $Revision: $

PDO PDO support enabled PDO drivers dblib, mysql, odbc, pgsql, sqlite

pdo_dblib PDO Driver for FreeTDS/Sybase DB-lib enabled Flavour freetds

pdo_mysql PDO Driver for MySQL, client library version 5.0.77

PDO_ODBC PDO Driver for ODBC (unixODBC) enabled ODBC Connection Pooling Enabled, strict matching

pdo_pgsql PDO Driver for PostgreSQL enabled PostgreSQL(libpq) Version 8.1.18 Module version 1.0.2 Revision $Id: pdo_pgsql.c 293036 2010-01-03 09:23:27Z sebastian $

pdo_sqlite PDO Driver for SQLite 3.x enabled PECL Module version 1.0.1 $Id: pdo_sqlite.c 293036 2010-01-03 09:23:27Z sebastian $ SQLite Library 3.3.6

pgsql PostgreSQL Support enabled PostgreSQL(libpq) Version 8.1.18 Multibyte character support enabled SSL support enabled Active Persistent Links 0 Active Links 0

Directive Local Value Master Value pgsql.allow_persistent On On pgsql.auto_reset_persistent Off Off pgsql.ignore_notice Off Off pgsql.log_notice Off Off pgsql.max_links Unlimited Unlimited pgsql.max_persistent Unlimited Unlimited

pspell PSpell Support enabled

Reflection Reflection enabled Version $Id: php_reflection.c 293850 2010-01-22 14:21:17Z jani $

session Session Support enabled Registered save handlers files user sqlite memcache 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 1000 1000 session.gc_maxlifetime 1440 1440 session.gc_probability 0 0 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: 293036 $ Schema support enabled

snmp NET-SNMP Support enabled NET-SNMP Version

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

SQLite SQLite support enabled PECL Module version 2.0-dev $Id: sqlite.c 293036 2010-01-03 09:23:27Z sebastian $ SQLite Library 2.8.17 SQLite Encoding iso8859

Directive Local Value Master Value sqlite.assoc_case 0 0

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

sybase_ct Sybase_CT Support enabled Active Persistent Links 0 Active Links 0 Min server severity 10 Min client severity 10 Application Name PHP 5.2.13 Deadlock retry count 0

Directive Local Value Master Value sybct.allow_persistent On On sybct.deadlock_retry_count 0 0 sybct.hostname no value no value sybct.login_timeout -1 -1 sybct.max_links Unlimited Unlimited sybct.max_persistent Unlimited Unlimited sybct.min_client_severity 10 10 sybct.min_server_severity 10 10

tidy Tidy support enabled libTidy Release 14 June 2007 Extension Version 2.0 ($Id: tidy.c 293036 2010-01-03 09:23:27Z sebastian $)

Directive Local Value Master Value tidy.clean_output no value no value tidy.default_config no value no value

tokenizer Tokenizer Support enabled

uploadprogress uploadprogress support enabled Version 0.9.2

Directive Local Value Master Value uploadprogress.file.contents_template /tmp/upload_contents_%s /tmp/upload_contents_%s uploadprogress.file.filename_template /tmp/upt_%s.txt /tmp/upt_%s.txt uploadprogress.get_contents 0 0

wddx WDDX Support enabled WDDX Session Serializer enabled

xml XML Support active XML Namespace Support active libxml2 Version 2.6.26

xmlreader XMLReader enabled

xmlrpc core library version xmlrpc-epi v. 0.51 php extension version 0.51 author Dan Libby homepage http://xmlrpc-epi.sourceforge.net open sourced by Epinions.com

xmlwriter XMLWriter enabled

xsl XSL enabled libxslt Version 1.1.17 libxslt compiled against libxml Version 2.6.26 EXSLT enabled libexslt Version 1.1.17

yaz YAZ Support enabled PHP/YAZ Version 1.0.13 YAZ Version 3.0.16 Compiled with YAZ version 3.0.16

Zend Optimizer Optimization Pass 1 enabled Optimization Pass 2 enabled Optimization Pass 3 enabled Optimization Pass 4 enabled Optimization Pass 9 enabled Zend Loader enabled License Path no value Obfuscation level 3

zip Zip enabled Extension Version $Id: php_zip.c 293036 2010-01-03 09:23:27Z sebastian $ 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.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 ionCube Loader

Environment Variable Value TERM dumb PATH /sbin:/usr/sbin:/bin:/usr/bin PWD / LANG C SHLVL 2 _ /usr/sbin/httpd.itk

PHP Variables Variable Value _REQUEST["X-Mapping-goahfekk"] 1F3DAF595499EBA20EC0A9FD230C1A14 _COOKIE["X-Mapping-goahfekk"] 1F3DAF595499EBA20EC0A9FD230C1A14 _SERVER["REDIRECT_UNIQUE_ID"] TCpFeqwRAmYAAC1jiyoAAAAB _SERVER["REDIRECT_SCRIPT_URL"] /index/info _SERVER["REDIRECT_SCRIPT_URI"] http://www.someserver.com/index/info _SERVER["REDIRECT_PHP_DOCUMENT_ROOT"] /someserver.com/web/content _SERVER["REDIRECT_STATUS"] 200 _SERVER["UNIQUE_ID"] TCpFeqwRAmYAAC1jiyoAAAAB _SERVER["SCRIPT_URL"] /index/info _SERVER["SCRIPT_URI"] http://www.someserver.com/index/info _SERVER["PHP_DOCUMENT_ROOT"] /someserver.com/web/content _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv: Gecko/20100625 Firefox/3.6.6 FirePHP/0.4 _SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 _SERVER["HTTP_ACCEPT_LANGUAGE"] en-us,en;q=0.5 _SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7 _SERVER["HTTP_HOST"] www.someserver.com _SERVER["HTTP_KEEP_ALIVE"] 115 _SERVER["HTTP_X_MOSSO_DT"] PHP5-10 _SERVER["HTTP_X_CLUSTER_CLIENT_IP"] _SERVER["HTTP_COOKIE"] X-Mapping-goahfekk=1F3DAF595499EBA20EC0A9FD230C1A14 _SERVER["HTTP_CONNECTION"] keep-alive _SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate _SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin _SERVER["SERVER_SIGNATURE"]

Apache/2.2 Server at www.someserver.com Port 80

_SERVER["SERVER_SOFTWARE"] Apache/2.2 _SERVER["SERVER_NAME"] www.someserver.com _SERVER["SERVER_ADDR"] _SERVER["SERVER_PORT"] 80 _SERVER["SERVER_ADMIN"] root@localhost _SERVER["SCRIPT_FILENAME"] /someserver.com/web/content/public/index.php _SERVER["REMOTE_PORT"] 47378 _SERVER["REDIRECT_URL"] /index/info _SERVER["GATEWAY_INTERFACE"] CGI/1.1 _SERVER["SERVER_PROTOCOL"] HTTP/1.1 _SERVER["REQUEST_METHOD"] GET _SERVER["QUERY_STRING"] no value _SERVER["REQUEST_URI"] /index/info _SERVER["SCRIPT_NAME"] /public/index.php _SERVER["DOCUMENT_ROOT"] /someserver.com/web/content _SERVER["REMOTE_ADDR"] _SERVER["PHP_SELF"] /public/index.php _SERVER["REQUEST_TIME"] 1277838714 _SERVER["argv"]

Array ( )

SERVER["argc"] 0 _ENV["TERM"] dumb _ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin _ENV["PWD"] / _ENV["LANG"] C _ENV["SHLVL"] 2 _ENV[""] /usr/sbin/httpd.itk

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.


This cannot be fixed within zf. Apparently PHP or the Pdo extension was compiled with /var/lib/mysql/mysql.sock as the location of the mysql socket. Your host will either have to recompile the extension; or move the location of the socket (which can also be done through a symlink).

Good luck working this out with your webhost.

Alternatively; what you could do is connect over tcp/ip to your mysql server by using host 'localhost' then with '' and then with the public ip.

that would have been great, if "localhost" or "" would have worked - but no such luck.

it seems odd to me that this is a problem with the webhost - if it is, then it's a problem with two webhosts as i've tried it in at two different providers. both were exactly the same result.

also, the application works fine using zend framework 1.7.1. The database is accessible using a zend 1.7.1 application at: http://www.nanocrowd.com

even if the pdo extension at the web host is compiled into the application as "/var/lib/mysql/mysql.sock" and stored elsewhere, wouldn't this also be an issue with zend 1.7.1? the zend 1.7.1 application also uses the PDO classes.

I hate to spoil you're game; but that's impossible ;)

If you want to you can check it yourself; search for the term mysql.sock in ZF, you will find out that there is no file containing that phrase. On the other hand; take a look at the info of your phpinfo() output. The path is displayed there twice ;) As said, you're really gonna have to take this up with your host.

it seems odd to me that this is a problem with the webhost - if it is, then it's a problem with two webhosts as i've tried it in at two different providers. both were exactly the same result. It isn't really. The thing is, PHP uses /var/lib/mysql/mysql.sock as mysql's default socket location. Some distro's put the socket in /tmp/mysqld.sock. So if nobody configures anything, on certain distributions it will fail by default ;)

before submitting this report, i searched ZF for "mysql.sock". that's the reason i'm asking for some guidance here.

clearly i don't know as much as you - without a doubt i'm not understanding what's impossible.

  • it's impossible that i'm using zend 1.7.1 on a rackspace server to access a mysql db - also on a rackspace server?

  • it's impossible that the same problem exists at two separate web hosts?

    1) rackspace 2) webfaction

  • have you actually tested the same functionality on a cloud server? the reason i ask is that Rackspace is not a mom and pop shop player. they're huge. suggesting that they don't know how to set up mysql is going a bit out on a limb. i guarantee that this application: http://www.nanocrowd.com is a zend 1.7.1 application connecting to a mysql 5.x database for it's content.

i have yet another mysql server sitting on a cloud server. it's completely separate from the site that's hosting the zend application. i'm going to try connecting to it to see if the same problem exists.