On Nov 14, 2006, at 1:41 PM, James Sentman wrote:
Hi Folks,
I just sent some software using the MySQL database plugin to some
people to test and immediately I have a problem I wasn't aware of
at all. On OSX Server the "socket" file isn't in /tmp/mysql.sock
but in /var/mysql/mysql.sock. so it cannot make a connection
locally to that machine. Is there a way to change where the plugin
looks for this? Why is it looking for it at all when its supposed
to be a socket connection? Is there a work around that doesn't
involve reconfiguring MySQL on the server? There is no obvious
setting for where the RB plugin looks for it that I can see.
Thanks!
James
This issue with mysql is known and has been mentioned on the list
before (search archives for /tmp/mysql.sock)
Apple mentions it in their docs on PHP and mySQL on 10.4.4 http://
docs.info.apple.com/article.html?artnum=302977
It's mentioned here as well http://dev.mysql.com/doc/refman/5.0/en/
mac-os-x-installation.html
and a fix is listed
Attention Dreamweaver Users*
When attempting to connect to a database in Dreamweaver you will
get an error message like:
"Connection failed reason unknown" or
"Could not connect to '/var/mysql/mysql.sock'"
This is because, as listed above:
"The MySQL socket file is created as /tmp/mysql.sock by default."
To fix this you will need to create a new folder on your desktop
named "mysql" (minus quotes). Then open a terminal.
Change directory to "var" by typing "cd /var". Once in that
directory type:
"sudo mv /Users/<your user name here>/Desktop/mysql/ mysql"
You will be prompted for your password. After entering your
password you will see the folder dissappear from your desktop. If
you type "ls" at the prompt it should now be listed in the "var"
directory. Since copying of sockets is not allowed the mysql.sock
file located in the "tmp" directory will have to be moved.
So change your directory to "/var/mysql" which you just created.
Then at the prompt type:
"sudo mv /tmp/mysql.sock mysql.sock"
This should move "mysql.sock" to "/var/mysql" and you can once
again check by typing "ls".
Now, when you go back to Dreamweaver and hit that select button to
find your database, it should pop right up!
Just don't forget to tell your other MySQL helper apps like MySQL
Administrator where the new socket is.
This is only a temporary fix and will have to be done again if the
server is stopped.
I hope this is useful info. BTW the version of Dreamweaver this tip
is intended for is MX. I have no idea if this is a problem for
newer versions.
Lee Woodrough
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
