Topic: mod_fcgid & PHP-MySQL problem.

[Computer Guru]

Hi All,

I'm currently running apache-2.2.6 (from Apache Lounge w/ the patches) and PHP from php5apache2_2.dll from the apache win32 community distribution.

I'd like to switch to FastCGI, so I downloaded and added your fcgid module to apache and configured httpd.conf to use fastcgi to run PHP - it works fine. With your fcgid module, PHP is running fast and secure without any issues.

HOWEVER, with mod_fcgid running PHP, PHP can no longer access MySQL.
When a php under fcgid attempts to access MySQL I get a socket creation error, and the connection fails. I do not have this issue with the isapi plugin.

Can anyone suggest a reason/solution for this weird behavior? Everything else works fine, the only thing is that PHP cannot connect to MySQL when running as FastCGI.

Thanks.

[James Blond]

With fcgi you also have to define the PHPIniDir in httpd.conf

I guess PHP runs with default values and you have to enable mysql extension in the php.ini for php fcgi.

[Computer Guru]

Thanks, that's fixed it

Another question: on IIS w/ FastCGI, I would point the FCGI wrapper to php-cgi.exe.... the fcgid docs point it to php.exe

Which is better? IS there a difference?

If I use php.exe I get a server 500 error, php-cgi.exe works just fine.

[James Blond]

The php docs are old at that point. The php-cgi.exe is the right one. Some time before there was php.exe (the cgi) and php-cli.exe. Some time a ago the files has been renamed php.exe to php-cgi.exe (to make it clear) and php-cli.exe to php.exe (cli = command line interface). New is the php-win.exe which is for php gtk.
Technical the php-cgi.exe send a content-type: text/html as a header for apache, what php.exe does not do.