I have been trying for over 2 weeks now to get my server setup properly. After visiting forum after forum and reading the same useless information about the same useless errors with PHP, I have decided to give it 1 last attempt before I scrub my server and wash my hands with PHP/SQL on IIS all together! I have never been so frustrated or disappointed in all my life as I am currently with PHP/SQL and how extremely difficult it is to get them working properly! :mad:

Server:
Acer Altos G530 Server with Xeon CPU's
4gb of ECC DDR2
300gb SCSI 10k rpm HDD
Windows Server 2003 R2

Apps:
php-5.3.6-nts-Win32-VC9-x86.zip - Can get PHP_Info page! Tha is all!
phpMyAdmin-3.3.10-all-languages.zip - Useless software that won't work!
mysql-essential-5.1.56-win32.msi - I think it is working!
mysql-workbench-gpl-5.2.29-win32.msi - Stupidest GUI I have ever used!
fcgisetup_1.5_rtw_x86.msi - No way of telling if it works or not!

IIS is up and running just fine!

Please, I am trying to do this for the local children and have many people waiting on me. I am sleeping every other night working on this and am about to try my 32nd attempt at setting this not-so-user-friendly software up!

Is there anyone looking for a challenge? This is it! If you can help me, please let me know and I will either tell you what I have done so far or I will completely format/reinstall everything from scratch (Windows and all) as I need to have something served in the next 4 days. Oh, good news, I am certified in various IT related fields believe it or not so I should be easy to teach!

Thanks in advance,
Mike :o

    You say you can get a [man]phpinfo/man page to work? What else have you tried that didn't work?

      9 days later

      Sorry guys but I took a break for just a bit to rethink my plans but now I am back and having even more problems then I did the last time! I don't understand why this PHP/FastCGI+mySQL on IIS6 combo is giving me such a hard time. I am normally very, very good at this kinda thing! Learning something new comes easy but this is frustrating the hell out of me. Now I can't even get the PHP Info page to display. It is a problem with FastCGI but I can't figure it out.

      FastCGI Error

      The FastCGI Handler was unable to process the request.

      Error Details:

      •The FastCGI process exited unexpectedly
      •Error Number: -2147467259 (0x80004005).
      •Error Description: Unspecified error
      HTTP Error 500 - Server Error.
      Internet Information Services (IIS)

      I had the other FastCGI arror that is ever so popular but I was able to remedy that easy enough! If you could help me I would appreciate it very much as I have people waiting for me to complete this.

        0x80004005 is a security permissions/ACL error.

        So, make sure the IIS worker group (e.g. IIS_WPG) has at least read/execute permissions on all files (including PHP binaries/libraries/configs/etc.) involved.

          Excellent man! Thank you so very much as I am now 1 step closer and PHP Info page displays now. I had to do axactly what you said and change security on the files individually as for some reason I couldn't get them to simply inherent. But it is up and that, like I said, gets me one step closer so now I am going to install mysql and phpMyAdmin and will post back in a few minutes!

          Thanks again bradgrafelman

            h8tingPHP wrote:

            I had to do axactly what you said and change security on the files individually as for some reason I couldn't get them to simply inherent.

            Oi - I wasn't advocating individual file permissions; having the correct set of permissions inherited from the containing folder(s) is a much easier/manageable setup.

              Well I am back with more problems! The installation of mySQL went great with no problems but I have no idea how to install phpMyAdmin. I placed the folder in the root folder of my webserver and attempted to load the setup\index.php to configure everything but I get this error...

              PHP Warning: require(): open_basedir restriction in effect. File(C:\Inetpub\wwwroot\MainSite\phpMyAdmin-3.3.10\setup\lib\common.inc.php) is not within the allowed path(s): (”C:\Inetpub) in C:\Inetpub\wwwroot\MainSite\phpMyAdmin-3.3.10\setup\index.php on line 15 PHP Warning: require(C:\Inetpub\wwwroot\MainSite\phpMyAdmin-3.3.10\setup\lib\common.inc.php): failed to open stream: Operation not permitted in C:\Inetpub\wwwroot\MainSite\phpMyAdmin-3.3.10\setup\index.php on line 15 PHP Fatal error: require(): Failed opening required './lib/common.inc.php' (include_path='.;c:\php\includes') in C:\Inetpub\wwwroot\MainSite\phpMyAdmin-3.3.10\setup\index.php on line 15

              Do I have to add the mentioned directories to open_basedir line in php.ini?
              My open_basedir line is as follows so far...

              open_basedir ="C:\PHP;C:\Inetpub\;C:\Windows\TEMP\"

              I have copied it to Windows directory as well each time I edit it as to keep the copies the same!

                bradgrafelman;10978379 wrote:

                EDIT: Also, never move any PHP-related file (e.g. php.ini) outside of the main PHP directory.

                I followed a tut online that told me I was required to make sure a copy of php.ini is within the Windows directory. Should I remove it from there? And thanks for all your help.

                  h8tingPHP wrote:

                  I followed a tut online that told me I was required to make sure a copy of php.ini is within the Windows directory

                  Promptly disregard anything and everything that tutorial said and discontinue using that source.

                  h8tingPHP wrote:

                  Should I remove it from there?

                  Yup.

                  You should have one and only one copy of php.ini, and it is often placed in the same directory as the one that PHP is installed in (e.g. C:\PHP).

                    As I mentioned, I am completely new at this! I followed what I believed to be a good tutorial but I guess it isn't! What should I have list in there? If you wouldn't mind! lol, sorry for the noobness of my questions.

                      h8tingPHP wrote:

                      What should I have list in there?

                      Whatever you want and/or whatever makes sense for the environment you're working with.

                      Is there a reason you're using the open_basedir directive at all?

                        I made the changes you showed me but I am still unable to open the setup\index.php page. I get the following error...

                        PHP Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\Inetpub\PHPsessions";N;; ; ; where N is an integer. Instead of storing all the session files in ; /path, what this will do is use subdirectories N-levels deep, and ; store the session data in those directories. This is useful if you ; or your OS have problems with lots of files in one directory, and is ; a more efficient layout for servers that handle lots of sessions. ; ; NOTE 1: PHP will not create this directory structure automatically. ; You can use the script in the ext/session dir for that purpose. ; NOTE 2: See the section on garbage collection below if you choose to ; use subdirectories for session storage ; ; The file storage module creates files using mode 600 by default. ; You can change that by using ; ; session.save_path = N) in Unknown on line 0

                        The bolded " isn't in my php.ini file anymore and I have removed php.ini from the windows sirectory so why it is showing up I have no idea.

                        If you want, I can post my php.ini and if you wouldn't mind taking a look to see what I am doing wrong.

                          No need to post the entire config - just post the line where you set the session.save_path directive.

                            I did an IISRESET at the CMD and I am able to load into phpMyAdmin! yay, now configuring everything! Anyway, I guess problems so far are solved thanks to you bradgrafelman. I hope to pick your brain again if you let me. I am sure more issues will arise soon enough!

                              Write a Reply...