Create the directory.
mkdir /var/mysql ln -s /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock /var/mysql/mysql.sock Note that I switched the ln command arguments around. I made a mistake before. Try that. Cheers, Graham harrzack wrote: > 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 -~----------~----~----~----~------~----~------~--~---
