Skip navigation links

MySQL Forums :: Database Administration & Monitoring :: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)


Advanced Search

Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Posted by: Brian Hull ()
Date: May 09, 2008 08:44AM

help. I have tried every suggestion on this board and more with no luck. Here is the list of changes I have made. I am regularly restarting the Apache server after making changes with no luck. I have very little experience with PHP and none with MySQL. I am just trying to install phpMyAdmin on my local test server so that I can create a test environment for WordPress templates. Any suggestions you can provide would be greatly appreciated.

Here is what I have tried:
changed config.inc.php to designate $cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock';
chnaged socket in php.ini to mysql.default_socket = "/tmp/mysql.sock"
chnaged socket in php.ini to mysql.default_socket = /tmp/mysql.sock
changed php.ini - left blank mysql.default_socket =
added /r designation for Mac when using setup.php

Changed hostname 'localhost' with '127.0.0.1'
Changed hostname 'localhost' with http://192.168.1.129/


Here is my MySQL status report:
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.51b, for apple-darwin9.0.0b5 (i686) using readline 5.0

Connection id: 378
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.51b MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 12 min 34 sec

Threads: 1 Questions: 4 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6
Queries per second avg: 0.005


Here is my PHP info:
PHP Logo
PHP Version 5.2.5

System Darwin brian-hulls-macbook-pro.local 9.2.2 Darwin Kernel Version 9.2.2: Tue Mar 4 21:17:34 PST 2008; root:xnu-1228.4.31~1/RELEASE_I386 i386
Build Date Feb 20 2008 12:25:30
Configure Command '/SourceCache/apache_mod_php/apache_mod_php-44/php/configure' '--prefix=/usr' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--disable-dependency-tracking' '--with-apxs2=/usr/sbin/apxs' '--with-ldap=/usr' '--with-kerberos=/usr' '--enable-cli' '--with-zlib-dir=/usr' '--enable-trans-sid' '--with-xml' '--enable-exif' '--enable-ftp' '--enable-mbstring' '--enable-mbregex' '--enable-dbx' '--enable-sockets' '--with-iodbc=/usr' '--with-curl=/usr' '--with-config-file-path=/etc' '--sysconfdir=/private/etc' '--with-mysql-sock=/var/mysql' '--with-mysqli=/usr/bin/mysql_config' '--with-mysql=/usr' '--with-openssl' '--with-xmlrpc' '--with-xsl=/usr' '--without-pear'
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc
Loaded Configuration File /private/etc/php.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.zlib, https, ftps
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.*, zlib.*

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies

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 6143 6143
expose_php On On
extension_dir ./ ./
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 .: .:
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
max_execution_time 30 30
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 128M 128M
open_basedir no value no value
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
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.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.7l DAV/2 PHP/5.2.5
Apache API Version 20051115
Server Administrator you@example.com
Hostname:Port ::1:0
User/Group www(70)/70
Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 5
Virtual Server No
Server Root /usr
Loaded Modules core prefork http_core mod_so mod_authn_file mod_authn_dbm mod_authn_anon mod_authn_dbd mod_authn_default mod_authz_host mod_authz_groupfile mod_authz_user mod_authz_dbm mod_authz_owner mod_authz_default mod_auth_basic mod_auth_digest mod_cache mod_disk_cache mod_mem_cache mod_dbd mod_dumpio mod_ext_filter mod_include mod_filter mod_deflate mod_log_config mod_log_forensic mod_logio mod_env mod_mime_magic mod_cern_meta mod_expires mod_headers mod_ident mod_usertrack mod_setenvif mod_version mod_proxy mod_proxy_connect mod_proxy_ftp mod_proxy_http mod_proxy_ajp mod_proxy_balancer mod_ssl mod_mime mod_dav mod_status mod_autoindex mod_asis mod_info mod_cgi mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_imagemap mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_bonjour2 mod_php5


Apache Environment
Variable Value
HTTP_HOST localhost
HTTP_USER_AGENT Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
HTTP_ACCEPT text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5
HTTP_ACCEPT_ENCODING gzip,deflate
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_KEEP_ALIVE 300
HTTP_CONNECTION keep-alive
PATH /usr/bin:/bin:/usr/sbin:/sbin
SERVER_SIGNATURE no value
SERVER_SOFTWARE Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.7l DAV/2 PHP/5.2.5
SERVER_NAME localhost
SERVER_ADDR 127.0.0.1
SERVER_PORT 80
REMOTE_ADDR 127.0.0.1
DOCUMENT_ROOT /Library/WebServer/Documents
SERVER_ADMIN you@example.com
SCRIPT_FILENAME /Library/WebServer/Documents/test.php
REMOTE_PORT 49271
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /test.php
SCRIPT_NAME /test.php

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.45
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/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/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


PHP Variables
Variable Value
_SERVER["HTTP_HOST"] localhost
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
_SERVER["HTTP_ACCEPT"] text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us,en;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_KEEP_ALIVE"] 300
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["PATH"] /usr/bin:/bin:/usr/sbin:/sbin
_SERVER["SERVER_SIGNATURE"] no value
_SERVER["SERVER_SOFTWARE"] Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.7l DAV/2 PHP/5.2.5
_SERVER["SERVER_NAME"] localhost
_SERVER["SERVER_ADDR"] 127.0.0.1
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 127.0.0.1
_SERVER["DOCUMENT_ROOT"] /Library/WebServer/Documents
_SERVER["SERVER_ADMIN"] you@example.com
_SERVER["SCRIPT_FILENAME"] /Library/WebServer/Documents/test.php
_SERVER["REMOTE_PORT"] 49271
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /test.php
_SERVER["SCRIPT_NAME"] /test.php
_SERVER["PHP_SELF"] /test.php
_SERVER["REQUEST_TIME"] 1210343196
_SERVER["argv"]


I hope that provides enough information for people to make recommendations. Please help a newbie out if possible.

Thank you,
Brian

Options: ReplyQuote


Subject Written By Posted
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) jamal mahdi 01/18/2006 01:21AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Viktor Berke 02/04/2006 10:27AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Niko Atmadja 02/25/2006 12:24AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Hikmat Rizal 03/11/2006 07:59AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Clinton Jones 03/16/2006 03:29AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Zhonghai Deng 09/19/2008 12:56AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Kuppu Sammy 12/30/2008 04:20AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Michael Felt 03/19/2006 05:41AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) baiewola 03/21/2006 03:23PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Michael Felt 03/31/2006 01:31AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Anil Vattalai 09/22/2006 12:56AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Yoga Nandiwardhana 01/29/2007 02:33AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) alex trimbee 06/13/2008 08:44AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) alex trimbee 06/13/2008 08:45AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Michael Valentiner 07/08/2008 01:54PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Yichao Wang 07/08/2008 11:13PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Luciano Mariante 11/07/2008 10:52AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Diana Brewster 12/09/2008 12:08PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) John Uz 12/25/2007 01:17AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Justin Lindberg 07/13/2008 01:10AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Abdelmageed khalil 08/26/2008 10:18PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) mithun zakir 11/09/2008 04:03PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Sarbjeet Singh 07/24/2007 06:33PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) manju valsan 12/11/2007 01:20AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) John Uz 12/25/2007 01:18AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) kevin yin 02/27/2008 11:02PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Radovan Hrabcak 05/02/2008 07:02AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Brian Hull 05/09/2008 08:44AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Hicham El Barouti 06/10/2008 12:43PM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Travis Crowder 09/30/2008 09:23AM
Re: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) Luciano Mariante 11/07/2008 10:37AM
<<< THE SOLUTION - SOLUTION SUMMARY >>> <<< READ THIS FIRST >>> Roel Van de Paar 03/26/2009 09:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.