JOY AT LAST! Thanks so much. When I saw there was no mysql in var I was considering making the dir to just fake it out... but wasn't sure if I'd need something in it. Was also checking to see if the ln command was ok, but reading man files at 7am (in NJ) is not the best fun...
Now I'm off to find what other joys await with cake. =Alan R. On May 14, 7:16 am, Graham Weldon <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
