468,249 Members | 1,484 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,249 developers. It's quick & easy.

PostgreSQL drivers not working?

bue
I have PHP 5.3, PostgreSQL 8.2 and Apache 2.2 on my computer, and some
MySQL.
From PHP I can connect to MySQL, but not to PostgreSQL. Both drivers are
uncommented in php.ini, but phpinfo() shows support only for MySQL (nothing
for Postgres).

pg_connect() leads to status 500 (internal server error), and the PDO
version throws PDOException "could not find driver".

Thanks for any help.
Jun 27 '08 #1
27 7189
Greetings, bue.
In reply to Your message dated Sunday, June 8, 2008, 16:59:24,
I have PHP 5.3,
So sorry, but...

php.netPHP 5.2.6 Released
php.net[01-May-2008]
php.net>
php.netThe PHP development team would like to announce the
php.netimmediateavailability of PHP 5.2.6.
PostgreSQL 8.2 and Apache 2.2 on my computer, and some
MySQL.
From PHP I can connect to MySQL, but not to PostgreSQL. Both drivers are
uncommented in php.ini, but phpinfo() shows support only for MySQL (nothing
for Postgres).
Then I guess that php_pgsql wasn't loaded, most likely due to unavailability
of the required shared libraries to the php/apache (depends on the way you're
running your php).
pg_connect() leads to status 500 (internal server error),
You can see in Apache error log, what was the case of that 500.
and the PDO version throws PDOException "could not find driver".
Wrong configuration or connection string.
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #2
bue
AnrDaemon wrote:
Greetings, bue.
In reply to Your message dated Sunday, June 8, 2008, 16:59:24,
>I have PHP 5.3,

So sorry, but...

php.netPHP 5.2.6 Released
php.net[01-May-2008]
php.net>
php.netThe PHP development team would like to announce the
php.netimmediateavailability of PHP 5.2.6.
http://snaps.php.net/
I tried downgrading to 5.2, the same thing..
>PostgreSQL 8.2 and Apache 2.2 on my computer, and some
MySQL.
From PHP I can connect to MySQL, but not to PostgreSQL. Both drivers
are uncommented in php.ini, but phpinfo() shows support only for
MySQL (nothing for Postgres).

Then I guess that php_pgsql wasn't loaded, most likely due to
unavailability of the required shared libraries to the php/apache
(depends on the way you're running your php).
what "way"? :)
PHPIniDir is set in httpd.conf
As I said, mysql is working, so PHP obviously sees the extensions.. And the
mysql PDO support is also visible from phpinfo()
>pg_connect() leads to status 500 (internal server error),

You can see in Apache error log, what was the case of that 500.
Thanks.
"Call to undefined function pg_connect()"
>and the PDO version throws PDOException "could not find driver".

Wrong configuration or connection string.
What configuration? I guess that's what I'm asking :-/
Jun 27 '08 #3
bue wrote:
I have PHP 5.3, PostgreSQL 8.2 and Apache 2.2 on my computer, and some
MySQL.
From PHP I can connect to MySQL, but not to PostgreSQL. Both drivers are
uncommented in php.ini, but phpinfo() shows support only for MySQL (nothing
for Postgres).

pg_connect() leads to status 500 (internal server error), and the PDO
version throws PDOException "could not find driver".

Thanks for any help.
Have you ever been able to connect to PostGres on this system? Do you
have the PostGres client libraries installed on your computer (and
accessible)? Is the PostGres server running (on the computer you're
tying to connect to)?

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

Jun 27 '08 #4
bue
Jerry Stuckle wrote:
Have you ever been able to connect to PostGres on this system? Do you
have the PostGres client libraries installed on your computer (and
accessible)? Is the PostGres server running (on the computer you're
tying to connect to)?
What's PostGres client libraries? :)

Postgres service is up and running, and I'm able to connect to Postgres
server via pgAdmin.
Jun 27 '08 #5
Greetings, bue.
In reply to Your message dated Sunday, June 8, 2008, 21:41:30,
>>I have PHP 5.3,

So sorry, but...

php.netPHP 5.2.6 Released
php.net[01-May-2008]
php.net>
php.netThe PHP development team would like to announce the
php.netimmediateavailability of PHP 5.2.6.
http://snaps.php.net/
I tried downgrading to 5.2, the same thing..
>>PostgreSQL 8.2 and Apache 2.2 on my computer, and some
MySQL.
From PHP I can connect to MySQL, but not to PostgreSQL. Both drivers
are uncommented in php.ini, but phpinfo() shows support only for
MySQL (nothing for Postgres).

Then I guess that php_pgsql wasn't loaded, most likely due to
unavailability of the required shared libraries to the php/apache
(depends on the way you're running your php).
what "way"? :)
module or CGI executable.
PHPIniDir is set in httpd.conf
As I said, mysql is working, so PHP obviously sees the extensions.. And the
mysql PDO support is also visible from phpinfo()
>>pg_connect() leads to status 500 (internal server error),

You can see in Apache error log, what was the case of that 500.
Thanks.
"Call to undefined function pg_connect()"
That means, the PGSQL extension was not loaded.
Try to start CLI executable, it may tell you more about the problem (f.e. pops
up with "library xxxx not found in the path" message).
>>and the PDO version throws PDOException "could not find driver".

Wrong configuration or connection string.
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.
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #6
Greetings, bue.
In reply to Your message dated Sunday, June 8, 2008, 22:32:13,
>Have you ever been able to connect to PostGres on this system? Do you
have the PostGres client libraries installed on your computer (and
accessible)? Is the PostGres server running (on the computer you're
tying to connect to)?
What's PostGres client libraries? :)
Good question :/
Postgres service is up and running, and I'm able to connect to Postgres
server via pgAdmin.
Then google the PostGres documentation about "shared libraries" or
"redistributable libraries".
For example, in MySQL it is a libMySql library. (It is included in PHP
distribution, so you have no problem connectiong to MySQL servers after
loading MySQL extension).
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #7
bue wrote:
Jerry Stuckle wrote:
>Have you ever been able to connect to PostGres on this system? Do you
have the PostGres client libraries installed on your computer (and
accessible)? Is the PostGres server running (on the computer you're
tying to connect to)?

What's PostGres client libraries? :)

Postgres service is up and running, and I'm able to connect to Postgres
server via pgAdmin.
To access many external resources, you need functions the client program
can call. This includes things like PostGres, MySQL and even Windows.
They contain the necessary functions to interface between your program
and the external resource.

If these libraries are not available, PHP will still try to start up.
If the libraries are necessary for PHP operation, PHP will not run.
However, for optional libraries (like PostGres), PHP will still start
but disable that feature.

Usually, when you download server software, you get the client software
also. However, you can often also download the client software separately.

But no matter how you get the client libraries, you need to get them and
they need to be available to the Apache service. On Windows, this means
just ensuring the directory containing them are in the PATH statement
for the Apache process (or the entire system). You may also have to set
the security attributes for the files so the Apache user can access them.

I don't remember the lib name or directory offhand and don't have it on
my system here. You could ask in comp.databases.postgres if you're not
sure.

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

Jun 27 '08 #8
bue
AnrDaemon wrote:
>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?
Thanks for the idea and all the help.
Experimenting with namespaces in PHP can and obviously will wait :)
Jun 27 '08 #9
bue
Thanks for thorough explanation.
I guess it was the problem with the drivers then, or the combination of
apache and the drivers (seems more like it, because the former case would
have obviously been delt with within a day or two).
Jun 27 '08 #10
bue wrote:
Thanks for thorough explanation.
I guess it was the problem with the drivers then, or the combination of
apache and the drivers (seems more like it, because the former case would
have obviously been delt with within a day or two).
I don't know about PHP 5.3.x (haven't tried it yet), but all of the PHP
5.2.x versions should work fine. The fact they don't generally
indicates you're either loading the wrong php_pgsql.dll file or trying
to load more than one version of the Postgres client libraries.

The php_pgsql library is specific to the PHP version; when changing PHP
versions you must insure you are loading the correct library (among
other things, remember to change the ext= in your php.ini file).

The PostGres libraries are a little more flexible - PostGres maintains
as much compatibility as possible (as do most manufacturers). But you
still need to ensure you're only loading one version of the library.
You could be trying to load two different ones if, for instance, another
product or language loads one version of the library and PHP loads
another version. While not as common as using the wrong php_pgsql lib,
it does happen.

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

Jun 27 '08 #11
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>

--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #12
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.
js*******@attglobal.net
==================

Jun 27 '08 #13
Greetings, Jerry Stuckle.
In reply to Your message dated Monday, June 9, 2008, 00:24:40,
>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.
No, it all made to be sure I have loaded proper versions of every library.
Proper = one that works. Nothing less.

P.S.
I know, you likes to comment my posts. Please answer the other one, one
regarding "\n" translation.
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #14
bue
AnrDaemon wrote:
No, I think it was your mistake in configuration.
You should read manual pages a bit deeper, I suggest...
I'm not convinced.. :)

LoadFile <fileworks fine with one version of a driver, but fails with
another.
All config files being untouched in between.
Something else seems to be wrong :)
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)
Looks like too much & duplicating stuff, when you take php.ini into account.
Jun 27 '08 #15
Greetings, bue.
In reply to Your message dated Monday, June 9, 2008, 01:05:30,
AnrDaemon wrote:
>No, I think it was your mistake in configuration.
You should read manual pages a bit deeper, I suggest...
I'm not convinced.. :)
LoadFile <fileworks fine with one version of a driver, but fails with
another.
All config files being untouched in between.
Something else seems to be wrong :)
>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)
Looks like too much & duplicating stuff, when you take php.ini into account.
Seriously... read documentation.
There are absolutely no duplications.
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #16
bue wrote:
AnrDaemon wrote:
>No, I think it was your mistake in configuration.
You should read manual pages a bit deeper, I suggest...

I'm not convinced.. :)

LoadFile <fileworks fine with one version of a driver, but fails with
another.
All config files being untouched in between.
Something else seems to be wrong :)
>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)

Looks like too much & duplicating stuff, when you take php.ini into account.
You do NOT want to LoadFile the PostGresSQL libraries. It will just get
you into trouble later (i.e. when you change libraries and need to go
through all those files to see where it needs to be loaded). Let the
modules which are using the files load them.

The fact you are having problems with one version is an example of this
- you're trying to load one DLL in the httpd.conf file and a different
one in some other file. Now you need to find out where these files are
loaded.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jun 27 '08 #17
bue
AnrDaemon wrote:
>Looks like too much & duplicating stuff, when you take php.ini into
account.

Seriously... read documentation.
There are absolutely no duplications.
Apache loads sql module, then loads php module that loads the same sql
module?
Jun 27 '08 #18
Greetings, bue.
In reply to Your message dated Monday, June 9, 2008, 08:52:00,
>>Looks like too much & duplicating stuff, when you take php.ini into
account.

Seriously... read documentation.
There are absolutely no duplications.
Apache loads sql module, then loads php module that loads the same sql
module?
Wrong.
Apache loading shared libraries (MySQL, openSSL, PHP) to make them available
for any modules that need them.
Then Apache calling PHP Apache SAPI module.
It look aroung for php4ts and see it already loaded. "Fine!" though it and
feeding the php5ts with PHPIniDir and it reading the php-<SAPI>.ini file from
there (or default php.ini, if no corresponding SAPI configuration present)
Then it loading MySQL extension, that extension looks for libMySQL.dll and see it
already loaded in application. Same way.

That's how shared libraries work: if you have one loaded, it will be shared
between all modules of your application.

P.S.
Dear Jerry, if I need to move from one library to another, I will include
other .conf file, with different library set. Obviously.
The "truble" you have mentioned is a "normal" problem of poor-minded computer
user, who don't know, how the program he are using works.
LoadFile intended to use it the way i'm ising it.
Sorry if I ruined your day :(
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #19
AnrDaemon wrote:
Greetings, bue.
In reply to Your message dated Monday, June 9, 2008, 08:52:00,
>>>Looks like too much & duplicating stuff, when you take php.ini into
account.
Seriously... read documentation.
There are absolutely no duplications.
>Apache loads sql module, then loads php module that loads the same sql
module?

Wrong.
Apache loading shared libraries (MySQL, openSSL, PHP) to make them available
for any modules that need them.
Then Apache calling PHP Apache SAPI module.
It look aroung for php4ts and see it already loaded. "Fine!" though it and
feeding the php5ts with PHPIniDir and it reading the php-<SAPI>.ini file from
there (or default php.ini, if no corresponding SAPI configuration present)
Then it loading MySQL extension, that extension looks for libMySQL.dll and see it
already loaded in application. Same way.

That's how shared libraries work: if you have one loaded, it will be shared
between all modules of your application.

P.S.
Dear Jerry, if I need to move from one library to another, I will include
other .conf file, with different library set. Obviously.
The "truble" you have mentioned is a "normal" problem of poor-minded computer
user, who don't know, how the program he are using works.
LoadFile intended to use it the way i'm ising it.
Sorry if I ruined your day :(

Yep, the trouble is a problem with a poor-minded computer user (such as
yourself) who unnecessarily complicates matters by loading the same
modules in multiple places.

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

Jun 27 '08 #20
Greetings, Jerry Stuckle.
In reply to Your message dated Monday, June 9, 2008, 18:55:34,
AnrDaemon wrote:
>Greetings, bue.
In reply to Your message dated Monday, June 9, 2008, 08:52:00,
>>>>Looks like too much & duplicating stuff, when you take php.ini into
account.
Seriously... read documentation.
There are absolutely no duplications.
>>Apache loads sql module, then loads php module that loads the same sql
module?

Wrong.
Apache loading shared libraries (MySQL, openSSL, PHP) to make them available
for any modules that need them.
Then Apache calling PHP Apache SAPI module.
It look aroung for php4ts and see it already loaded. "Fine!" though it and
feeding the php5ts with PHPIniDir and it reading the php-<SAPI>.ini file from
there (or default php.ini, if no corresponding SAPI configuration present)
Then it loading MySQL extension, that extension looks for libMySQL.dll and see it
already loaded in application. Same way.

That's how shared libraries work: if you have one loaded, it will be shared
between all modules of your application.

P.S.
Dear Jerry, if I need to move from one library to another, I will include
other .conf file, with different library set. Obviously.
The "truble" you have mentioned is a "normal" problem of poor-minded computer
user, who don't know, how the program he are using works.
LoadFile intended to use it the way i'm ising it.
Sorry if I ruined your day :(

Yep, the trouble is a problem with a poor-minded computer user (such as
yourself) who unnecessarily complicates matters by loading the same
modules in multiple places.
kk, tell me how to point PHP to specific 3rd party library?
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #21
AnrDaemon wrote:
Greetings, Jerry Stuckle.
In reply to Your message dated Monday, June 9, 2008, 18:55:34,
>AnrDaemon wrote:
>>Greetings, bue.
In reply to Your message dated Monday, June 9, 2008, 08:52:00,

>Looks like too much & duplicating stuff, when you take php.ini into
>account.
Seriously... read documentation.
There are absolutely no duplications.
Apache loads sql module, then loads php module that loads the same sql
module?
Wrong.
Apache loading shared libraries (MySQL, openSSL, PHP) to make them available
for any modules that need them.
Then Apache calling PHP Apache SAPI module.
It look aroung for php4ts and see it already loaded. "Fine!" though it and
feeding the php5ts with PHPIniDir and it reading the php-<SAPI>.ini file from
there (or default php.ini, if no corresponding SAPI configuration present)
Then it loading MySQL extension, that extension looks for libMySQL.dll and see it
already loaded in application. Same way.

That's how shared libraries work: if you have one loaded, it will be shared
between all modules of your application.

P.S.
Dear Jerry, if I need to move from one library to another, I will include
other .conf file, with different library set. Obviously.
The "truble" you have mentioned is a "normal" problem of poor-minded computer
user, who don't know, how the program he are using works.
LoadFile intended to use it the way i'm ising it.
Sorry if I ruined your day :(

>Yep, the trouble is a problem with a poor-minded computer user (such as
yourself) who unnecessarily complicates matters by loading the same
modules in multiple places.

kk, tell me how to point PHP to specific 3rd party library?

You're so smart. You figure it out. Hint: ensure your environment is
set up properly!

But don't push your crap on other people.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jun 27 '08 #22
Greetings, Jerry Stuckle.
In reply to Your message dated Monday, June 9, 2008, 20:30:31,
AnrDaemon wrote:
>Greetings, Jerry Stuckle.
In reply to Your message dated Monday, June 9, 2008, 18:55:34,
>>AnrDaemon wrote:
Greetings, bue.
In reply to Your message dated Monday, June 9, 2008, 08:52:00,

>>Looks like too much & duplicating stuff, when you take php.ini into
>>account.
>Seriously... read documentation.
>There are absolutely no duplications.
Apache loads sql module, then loads php module that loads the same sql
module?
Wrong.
Apache loading shared libraries (MySQL, openSSL, PHP) to make them available
for any modules that need them.
Then Apache calling PHP Apache SAPI module.
It look aroung for php4ts and see it already loaded. "Fine!" though it and
feeding the php5ts with PHPIniDir and it reading the php-<SAPI>.ini file from
there (or default php.ini, if no corresponding SAPI configuration present)
Then it loading MySQL extension, that extension looks for libMySQL.dll and see it
already loaded in application. Same way.

That's how shared libraries work: if you have one loaded, it will be shared
between all modules of your application.

P.S.
Dear Jerry, if I need to move from one library to another, I will include
other .conf file, with different library set. Obviously.
The "truble" you have mentioned is a "normal" problem of poor-minded computer
user, who don't know, how the program he are using works.
LoadFile intended to use it the way i'm ising it.
Sorry if I ruined your day :(

>>Yep, the trouble is a problem with a poor-minded computer user (such as
yourself) who unnecessarily complicates matters by loading the same
modules in multiple places.

kk, tell me how to point PHP to specific 3rd party library?

You're so smart. You figure it out. Hint: ensure your environment is
set up properly!
But don't push your crap on other people.
PHP, not entire system.
It is not production environment. I have 3 MySQL servers installed, 2 Apache
and 2 PHP installations.

And I'm loading needed modules only once every time i'm loading them.
It is how operating system works. If you don't know anything about base OS
functionality, sorry.
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #23
AnrDaemon wrote:
Greetings, Jerry Stuckle.
In reply to Your message dated Monday, June 9, 2008, 20:30:31,
>AnrDaemon wrote:
>>Greetings, Jerry Stuckle.
In reply to Your message dated Monday, June 9, 2008, 18:55:34,

AnrDaemon wrote:
Greetings, bue.
In reply to Your message dated Monday, June 9, 2008, 08:52:00,
>
>>>Looks like too much & duplicating stuff, when you take php.ini into
>>>account.
>>Seriously... read documentation.
>>There are absolutely no duplications.
>Apache loads sql module, then loads php module that loads the same sql
>module?
Wrong.
Apache loading shared libraries (MySQL, openSSL, PHP) to make them available
for any modules that need them.
Then Apache calling PHP Apache SAPI module.
It look aroung for php4ts and see it already loaded. "Fine!" though it and
feeding the php5ts with PHPIniDir and it reading the php-<SAPI>.ini file from
there (or default php.ini, if no corresponding SAPI configuration present)
Then it loading MySQL extension, that extension looks for libMySQL.dll and see it
already loaded in application. Same way.
>
That's how shared libraries work: if you have one loaded, it will be shared
between all modules of your application.
>
P.S.
Dear Jerry, if I need to move from one library to another, I will include
other .conf file, with different library set. Obviously.
The "truble" you have mentioned is a "normal" problem of poor-minded computer
user, who don't know, how the program he are using works.
LoadFile intended to use it the way i'm ising it.
Sorry if I ruined your day :(
>
>
Yep, the trouble is a problem with a poor-minded computer user (such as
yourself) who unnecessarily complicates matters by loading the same
modules in multiple places.
kk, tell me how to point PHP to specific 3rd party library?

>You're so smart. You figure it out. Hint: ensure your environment is
set up properly!
>But don't push your crap on other people.

PHP, not entire system.
It is not production environment. I have 3 MySQL servers installed, 2 Apache
and 2 PHP installations.

And I'm loading needed modules only once every time i'm loading them.
It is how operating system works. If you don't know anything about base OS
functionality, sorry.

Believe me, I know a hell of a lot more about OS's than you do. And
once again, you've proven it.

You have no idea how to properly set up the OS environment to do what
you want with out the crap you have.

For the record, I have *production systems* set up with different MySQL
and PHP versions. And they all do it WITHOUT extraneous LoadModule
statements in the httpd.conf.

The fact you don't know how to do it properly is no excuse.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jun 27 '08 #24
Greetings, Jerry Stuckle.
In reply to Your message dated Monday, June 9, 2008, 21:57:09,
>>>>>>>>Looks like too much & duplicating stuff, when you take php.ini into
>>>>account.
>>>Seriously... read documentation.
>>>There are absolutely no duplications.
>>Apache loads sql module, then loads php module that loads the same sql
>>module?
>Wrong.
>Apache loading shared libraries (MySQL, openSSL, PHP) to make them available
>for any modules that need them.
>Then Apache calling PHP Apache SAPI module.
>It look aroung for php4ts and see it already loaded. "Fine!" though it and
>feeding the php5ts with PHPIniDir and it reading the php-<SAPI>.ini file from
>there (or default php.ini, if no corresponding SAPI configuration present)
>Then it loading MySQL extension, that extension looks for libMySQL.dll and see it
>already loaded in application. Same way.
>>
>That's how shared libraries work: if you have one loaded, it will be shared
>between all modules of your application.
>>
>P.S.
>Dear Jerry, if I need to move from one library to another, I will include
>other .conf file, with different library set. Obviously.
>The "truble" you have mentioned is a "normal" problem of poor-minded computer
>user, who don't know, how the program he are using works.
>LoadFile intended to use it the way i'm ising it.
>Sorry if I ruined your day :(
>>
>>
Yep, the trouble is a problem with a poor-minded computer user (such as
yourself) who unnecessarily complicates matters by loading the same
modules in multiple places.
kk, tell me how to point PHP to specific 3rd party library?

>>You're so smart. You figure it out. Hint: ensure your environment is
set up properly!
>>But don't push your crap on other people.

PHP, not entire system.
It is not production environment. I have 3 MySQL servers installed, 2 Apache
and 2 PHP installations.

And I'm loading needed modules only once every time i'm loading them.
It is how operating system works. If you don't know anything about base OS
functionality, sorry.

Believe me, I know a hell of a lot more about OS's than you do. And
once again, you've proven it.
You have no idea how to properly set up the OS environment to do what
you want with out the crap you have.
For the record, I have *production systems* set up with different MySQL
and PHP versions. And they all do it WITHOUT extraneous LoadModule
statements in the httpd.conf.
The fact you don't know how to do it properly is no excuse.
That most likely because you're using CGI interface. It is only one way to
have specific libMySQL loaded from the same directory as where executable
resides. (Besides recompilation of everything)

And to the "extraneous" - it is documented behaviour and as I said, it is
intended to be used that way.
http://httpd.apache.org/docs/2.2/mod....html#loadfile

Nex time, please, if you do not have other arguments, than "I'm right because
I'm old", hold 'em with yourself. They are not related to the truth.

And you still not answered to my two other posts, where you have argued the
same manner. Forgot or lost them? It is one about quoting characters and
expanding "\n" to "\r\n" in PHP under Windows.
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #25
AnrDaemon wrote:
Greetings, Jerry Stuckle.
In reply to Your message dated Monday, June 9, 2008, 21:57:09,
>>>>>>>>>Looks like too much & duplicating stuff, when you take php.ini into
>>>>>account.
>>>>Seriously... read documentation.
>>>>There are absolutely no duplications.
>>>Apache loads sql module, then loads php module that loads the same sql
>>>module?
>>Wrong.
>>Apache loading shared libraries (MySQL, openSSL, PHP) to make them available
>>for any modules that need them.
>>Then Apache calling PHP Apache SAPI module.
>>It look aroung for php4ts and see it already loaded. "Fine!" though it and
>>feeding the php5ts with PHPIniDir and it reading the php-<SAPI>.ini file from
>>there (or default php.ini, if no corresponding SAPI configuration present)
>>Then it loading MySQL extension, that extension looks for libMySQL.dll and see it
>>already loaded in application. Same way.
>>>
>>That's how shared libraries work: if you have one loaded, it will be shared
>>between all modules of your application.
>>>
>>P.S.
>>Dear Jerry, if I need to move from one library to another, I will include
>>other .conf file, with different library set. Obviously.
>>The "truble" you have mentioned is a "normal" problem of poor-minded computer
>>user, who don't know, how the program he are using works.
>>LoadFile intended to use it the way i'm ising it.
>>Sorry if I ruined your day :(
>>>
>>>
>Yep, the trouble is a problem with a poor-minded computer user (such as
>yourself) who unnecessarily complicates matters by loading the same
>modules in multiple places.
kk, tell me how to point PHP to specific 3rd party library?
>
>
You're so smart. You figure it out. Hint: ensure your environment is
set up properly!
But don't push your crap on other people.
PHP, not entire system.
It is not production environment. I have 3 MySQL servers installed, 2 Apache
and 2 PHP installations.

And I'm loading needed modules only once every time i'm loading them.
It is how operating system works. If you don't know anything about base OS
functionality, sorry.

>Believe me, I know a hell of a lot more about OS's than you do. And
once again, you've proven it.
>You have no idea how to properly set up the OS environment to do what
you want with out the crap you have.
>For the record, I have *production systems* set up with different MySQL
and PHP versions. And they all do it WITHOUT extraneous LoadModule
statements in the httpd.conf.
>The fact you don't know how to do it properly is no excuse.

That most likely because you're using CGI interface. It is only one way to
have specific libMySQL loaded from the same directory as where executable
resides. (Besides recompilation of everything)
Nope.
And to the "extraneous" - it is documented behaviour and as I said, it is
intended to be used that way.
http://httpd.apache.org/docs/2.2/mod....html#loadfile

Nex time, please, if you do not have other arguments, than "I'm right because
I'm old", hold 'em with yourself. They are not related to the truth.

And you still not answered to my two other posts, where you have argued the
same manner. Forgot or lost them? It is one about quoting characters and
expanding "\n" to "\r\n" in PHP under Windows.

No, I haven't forgotten them. I'm just tired of arguing with an idiot.

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

Jun 27 '08 #26
Greetings, Jerry Stuckle.
In reply to Your message dated Tuesday, June 10, 2008, 01:21:25,
>And you still not answered to my two other posts, where you have argued the
same manner. Forgot or lost them? It is one about quoting characters and
expanding "\n" to "\r\n" in PHP under Windows.
No, I haven't forgotten them. I'm just tired of arguing with an idiot.
Ah, it's a typical Jerry's answer to any topic, where he were proved to be wrong.
:)
You've made my evening, i'm going to sleep very happy.
--
Sincerely Yours, AnrDaemon <an*******@freemail.ru>

Jun 27 '08 #27
AnrDaemon wrote:
Greetings, Jerry Stuckle.
In reply to Your message dated Tuesday, June 10, 2008, 01:21:25,
>>And you still not answered to my two other posts, where you have argued the
same manner. Forgot or lost them? It is one about quoting characters and
expanding "\n" to "\r\n" in PHP under Windows.
>No, I haven't forgotten them. I'm just tired of arguing with an idiot.

Ah, it's a typical Jerry's answer to any topic, where he were proved to be wrong.
:)
You've made my evening, i'm going to sleep very happy.

Whatever trips your trigger, idiot.

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

Jun 27 '08 #28

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Thomas Köhler | last post: by
13 posts views Thread by Zlatko Matiæ | last post: by
18 posts views Thread by Marc G. Fournier | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.