[FX.php List] MySQL 5 and FMS 9 (php)

[Caleb Ruth]

In case this helps anyone else the problem turned out to be PHP was  
looking in the wrong place for the MySQL socket file. When I edited  
the php.ini file, it still wouldn't use the new socket file. I ended  
up changing the my.cnf file so that MySQL wrote the socket file to  
the place PHP insisted on looking for it.

Note that I only had this problem on Mac OS X 10.4 (user license). OS  
X Server 10.4 did not have this problem.


-- 
Caleb Ruth | cr at fmarchitect.com  | 607-330-2058




On Jul 26, 2007, at 3:15 PM, Caleb Ruth wrote:

> Hi All,
>
> Having trouble making a connection from PHP to MySQL 5.0.45 with  
> the default Filemaker Server 9 PHP installation on Mac 10.4.
>
> PhpMyAdmin gives me this error when trying to connect:
> "#2002 - The server is not responding (or the local MySQL server's  
> socket is not correctly configured)"
>
> I've tested the MySQL install with CocoaMySQL and do connect, so I  
> believe that my problem is with the FMS9 PHP config.
>
> FYI when I use the Entropy PHP build (PHP 5.2.1 on another box) I  
> do connect to MySQL 5.
>
> The one difference I have noticed is that the Entropy build shows  
> this line in the MySQL info section:
> Client API version 	5.0.24a
>
> Whereas the FMS 9 PHP info shows this line:
> Client API version 	4.1.22
>
> Is it possible that FMS9 only supports MySQL 4.x and not 5? Is  
> there a way to include MySQL 5 support?
>
> Thanks,
> Caleb
>
>
>
> -- 
> Caleb Ruth | cr at fmarchitect.com  | 607-330-2058
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070803/3356b93a/attachment-0001.html