Posted by Jerry Stuckle on 05/31/07 11:47

jm wrote:
> I am setting up Apache 2.0, PHP5, and PostgreSQL 8.2 on Windows XP. I
> have setup everything correctly in the past but recently had to do a
> reformat and have to do the installs all over again.
>
> First, I installed Apache with no problems what so ever.
>
> Next, PHP. Again smooth install. With a little tweaking of the
> httpd.conf file, Apache was working with PHP.
>
> Next was PostgreSQL. Again, the install went fine and I could use
> pgAdmin to connect to the databases.
>
> When I run a PHP file that uses pg_connect() for example, it fails and
> says that it is an unrecognized function. I know that the PostgreSQL
> extension is in the extension directory.
>
> To start the troubleshooting process, I create a file with phpinfo()
> to see what is going on. It says that the php.ini file can be found
> in C:\WINDOWS when there is no php.ini file in that directory. I can
> do a search on the hard drive for 'php.ini' and the only php.ini file
> that is listed is the one in C:\PHP.
> My Apache httpd.conf has: PHPIniDir "C:\PHP\"
> Also the phpinfo() says that the extension_dir is C:\php5 when it is
> not. In C:\PHP\php.ini the extension directory is listed as C:\PHP
> \ext.
>
> Lastly, when I do a restart of the computer, try to pull up localhost,
> instead of showing any PHP errors, it just shows the PHP source code
> in plain text like it has no idea what PHP is, and suddenly the
> phpinfo() page that I created is just blank.
>
> If anyone has some ideas to help me out, it would be much appreciated,
> I don't want to have to pull out any more of my hair. :)
>
> j
>

XAMP won't solve your problem because you want PostGres SQL, not MySQL.
No use installing all that MySQL code if you're not going to use it.

As to your problem. It looks like PHP isn't finding the file. Do you
have your PHPiniDir before the LoadModule statement for PHP? Also, I
always use forward slashes - they work fine, even in Windows (except the
command processor), and sometimes backslashes cause problems. You might
try putting PHPiniDir "C:/PHP".

Or, you can handle one problem at a time and for now just copy your
php.ini file to c:\windows (you can always move it once you get things
working, if you wish). Ensure your PostGres dll is loaded in the
extensions section.

I find it interesting that it worked before you restarted. What changes
did you make to your httpd.conf file?


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]