I have installed Apache 2.2/PostgreSQL 8.3/PHP 5.2.6
When attempting to startup the apache server with pgsql support it fails:
Syntax error on line 546 of C:/Program Files/Apache Software Foundation/Apache2.2/conf/httpd.conf:
DBD: No driver for pgsql
MY httpd.conf file is as follows:
| CODE |
#PHP-------------------------------------------
ScriptAlias /php/ "c:/php/"
AddType application/x-httpd-php .php
# For PHP 4
#Action application/x-httpd-php "/php/php.exe"
# For PHP 5
Action application/x-httpd-php "/php/php-cgi.exe"
# For PHP 5 do something like this:
LoadModule php5_module "c:/php/php5apache2_2.dll"
AddType application/x-httpd-php .php
#POSTGRESQL-------------------------------------------
LoadModule dbd_module modules/mod_dbd.so
#Use the PostgreSQL driver
DBDriver pgsql |
Any help would be greatly appreciated, thank you very much
We didn't customize Apache to support PostgreSQL in our tutorial: we used PHP only. Did you uncomment "extension=php_pgsql.dll" in php.ini?
Correct, it has been uncommented, it seems to be more of an Apache issue than php, since changing the name will give the same error with a different name other than "pgsql", so its the DBDriver not finding the correct .dll file if I am assuming correctly.
Did you add this stuff to httpd.conf yourself?
| CODE |
#POSTGRESQL-------------------------------------------
LoadModule dbd_module modules/mod_dbd.so
#Use the PostgreSQL driver
DBDriver pgsql |
I don't think it's needed (Apache -> calls PHP; PHP -> calls postgreSQL), and it's very likely to be what causes the error IMO.