Hmm - I'd seen the ln trick elswhere but forgot! Gave it at try ln -s /var/mysql/mysql.sock /Applications/XAMPP/xamppfiles/var/mysql/ mysql.sock ln says: ln: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock: File exists
I went to /var and there is no mysql directory there either! WTF?? :-) being a bit rusty with my unix-stuff, what is ln telling me? On May 14, 6:53 am, Graham Weldon <[email protected]> wrote: > You can always create a symlink to solve your issues. > > ln -s /var/mysql/mysql.sock > /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock > > That will create a symlink to the location that PHP is looking for the > MySQL socket. > And it means you can revert to the default settings for php.ini and > my.cnf as they were. > > Try that, and again, let me know how you go. > > Cheers, > Graham > > harrzack wrote: > > Graham - > > > Thanks - but still no joy! :-( > > When I cd to the app directory, do 'cake bake', the do a C for > > Controller I still get the flood of warnings that start: > > > "Warning: mysql_connect(): Can't connect to local MySQL server through > > socket '/var/mysql/mysql.sock' " > > > My undersandting is that message-stream says cake is using the OS X > > CLI php > > There must be yet another burried .ini/cfg file I'm missing. > > I am using virtual host and the Apache httpd-vhosts.cnf but pretty > > sure that has no effect on this stuff. > > > php.ini is now set to: > > ; Default socket name for local MySQL connects. If empty, uses the > > built-in > > ; MySQL defaults. > > mysql.default_socket = /Applications/XAMPP/xamppfiles/var/mysql/ > > mysql.sock > > > and my.cnf.ini has: > > > # The following options will be passed to all MySQL clients > > [client] > > #password = your_password > > password = xyzzy > > port = 3306 > > socket = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock > > > On May 14, 2:35 am, Graham Weldon <[email protected]> wrote: > > >> Hey, > > >> What is your php.ini value for "mysql.default_socket" set to? > >> This will tell PHP where your socket file is for MySQL, and help get you > >> connected. > > >> You can check this file location by looking in your MySQL my.cnf file > >> for the line indicating "socket = " > > >> For example, a MAMP install has the following socket definition in my.cnf > >> socket = /Applications/MAMP/tmp/mysql/mysql.sock > > >> Hope this helps. Do let us know how you go > > >> Cheers, > >> Graham > > >> harrzack wrote: > > >>> This is on OS X 10.4.11 with latest XAMPP install. > > >>> Having probs getting cake bake to use the correct PHP. When I try to > >>> bake a contoller I'm getting the famous error message(s): > > >>> "Warning: mysql_connect(): Can't connect to local MySQL server > >>> through socket '/var/mysql/mysql.sock' (2) in /WebDev/site.IOI/IOI/ > >>> cake/libs/model/datasources/dbo/dbo_mysql.php on line 375" > > >>> I've searched the web, seen most answers - it is still broke. Have set > >>> my paths in .profile, edited php.ini to have the xampp path to php, > >>> and still cake seems to want to use the built-in PHP which uses the > >>> wrong socket. I've p**sed away several hours and nothing I do seems to > >>> fix this. > > >>> I've cd'd to the app directory, cake is showing the correct path... > >>> there must be some other config file I need to edit to get cake to > >>> stop using the built-in CLI PHP. > > >>> Any new clues to this PITA issue? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
