Re: PostgreSQL drivers not working?

AnrDaemon wrote:
Greetings, bue.
In reply to Your message dated Sunday, June 8, 2008, 23:36:39,

What configuration? I guess that's what I'm asking :-/
PHP configuration. As it seems you have configured it as Apache
module, you should make sure that the shared PGSQL libraries visible
to Apache. (i.e. set a system-wide PATH variable to include the
directory, add that DLL to the system DLL's list in registry (if you
have it on windows), or preload them in httpd.conf (LoadFile
directive) before loading PHP itself.

Wow.
The last thing might have given some answers.

With the PHP 5.3, the LoadFile gave an error when restarting Apache of "unknown module" (the one it returns on a non-existent file).

Then I downloaded PHP 5.2.6 and PHP 5.2.5 to see what happens with their drivers.
It returned the error of "unknown procedure".

Then I remembered that I was running PHP 5.2.1 before, and gave that a chance.
Guess what, it worked!!?! So now I replaced PHP 5.3 with 5.2.1, and I have it up and functional.

So it was the drivers somehow colliding with Apache afterall?

No, I think it was your mistake in configuration.
You should read manual pages a bit deeper, I suggest...

Here is what I have on my server (Jerry typically unhappy with this solution,
so I apologise for his reaction in advance, but I can't share PHP directory in
PATH as he might suggest)

[C:\]$ cat somewhere\apache\conf\old_sets\php-5.2.2.conf
LoadFile C:/usr/sbin/php-5.2-Win32/libeay32.dll
LoadFile C:/usr/sbin/php-5.2-Win32/ssleay32.dll

LoadFile C:/usr/sbin/php-5.2-Win32/libmysql.dll

LoadFile C:/usr/sbin/php-5.2-Win32/php5ts.dll

LoadModule php5_module "C:/usr/sbin/php-5.2-Win32/php5apache2_2_filter.dll"

<IfModule php5_module>
php_admin_value extension_dir "C:/usr/sbin/php-5.2-Win32/ext"
PHPIniDir "C:/usr/sbin/php-5.2-Win32"
</IfModule>




Wrong. You do NOT load mysql and other libraries that Apache itself does not call. This can just cause other problems - like loading the wrong versions of those libaries.

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

.

Relevant Pages

  • Help with php5 install under windows
    ... This includes moving php from the ... Enable the PHP scripting language engine under Apache. ... or per-virtualhost web server configuration file. ... The PHP directives register_globals, ...
    (php.general)
  • RE: Virtual hosts and PHP "downloads": php5 and apache22 on FreeBSD6.1-STABLE
    ... Apache web server. ... Subject: Virtual hosts and PHP "downloads": php5 and apache22 on ...
    (freebsd-questions)
  • Re: HELP: send binary replies back and forth ???
    ... > My php application needs to do the following: ... > My PHP script loops through all records and sends each of them ONE BY ONE. ... > other than to be able to communicate with apache. ... All communication is binary because the connection used is pricy and ...
    (comp.lang.php)
  • Re: approaches to PHP-based application interface?
    ... "safe" so that the applicable parts of it can run on a public server. ... One major advantage of sticking with PHP is that my fairly large ... stripped-down browser so it runs as a Windows application without any ... apache involvement. ...
    (comp.lang.php)
  • Re: PHP Tutorials
    ... >> In this tutorial we assume that your server has activated support for PHP ... install a web server locally (not just Apache). ...
    (comp.lang.php)