PHP List,
As was suggested on this list by Paul and Richard, I've resolved the
Zend studio/MySQL socket issue by creating a symbolic link from
/tmp/mysql.socl to /var/run/mysqld/mysqld.sock.
( ln -s /var/run/mysqld/mysql.sock /tmp/mysql.sock )
But, clearly in my earlier attempts to find a solution, I've munged up
my php.ini file or something, because now not only does phpMyAdmin not
connect, no PHP script that I run locally will work.
To resolve this, I tried to retrace my steps and put everything back the
way it was. I also reinstalled MySQL, PHP, and phpMyAdmin from the
Ubuntu repositories using apt-get.
Despite these efforts, whatever it is that I've done to mess up my
system remains in place.
When I start a PHP script that calls upon MySQL, I get the following error:
Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to
local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in
/web_sites/web/db_fns.php on line 6.
So far as I can remember, the only places I made edits were in
/etc/php5/apache2/php.ini, and /etc/mysql/my.cnf.
In /etc/php5/apache2/php.ini, here is what the relevant section looks
like now:
- - - - - - - - -
; Default port number for mysql_connect(). If unset, mysql_connect()
will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will
only look
; at MYSQL_PORT.
mysql.default_port = 3306
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =
- - - - - - - - -
My understanding of the above is that if the socket variable is left
empty, it should go with the MySQL default. I have tried specifying
"mysql.default_socket = /var/run/mysqld/mysql.sock" and
"mysql.default_socket = /tmp/mysql.sock", but that hasn't helped.
As for /etc/mysql/my.cnf, it says:
- - - - - - - - -
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysql.sock
- - - - - - - - -
I am unsure where to look to diagnose this problem further.
Any advice would be much appreciated. Thank you.
--
Dave M G
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
