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

[Caleb Ruth]

I'm using 2 parallel, single-machine, test environments:

-Server A has FMS9, PHP 5.2.1 (as installed by FMS9), MySQL 5.0.45
-Server B has PHP 5.2.2 (as installed by Entropy installer), MySQL  
5.0.37

MySQL is running and CocoaMySQL can connect on each local machine.

However PHP on Server A (with FMS9) is not connecting with the local  
MySQL daemon.

Downgrading to MySQL 4 didn't solve the problem.

-Caleb

On Jul 26, 2007, at 3:20 PM, Gjermund Gusland Thorsen wrote:

> Do you try to connect to MySQL from same IP when you connect from the
> different services? Are FMS9 php and entropy PHP on the same IP when
> querying MySQL, i. e.
>
> ggt667
>
> On 7/26/07, Caleb Ruth <cr at fmarchitect.com> 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