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

[Gjermund Gusland Thorsen]

so my.cnf was only serving on localhost?

Was that it?

Gjermund

On 8/3/07, Caleb Ruth <cr at fmarchitect.com> wrote:
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>