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

[Gjermund Gusland Thorsen]

I believe problem might be either in password or IP address that your
account is allowed to connect from...

at least that's what I have had problems with.

BTW Caleb I have a photo of you and 4 groupmembers:
http://file-making.com/files/pictures/FMDevCon2003/5xFMDiSC.jpg

ggt667

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