473,327 Members | 1,920 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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 7490
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

125
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...
2
by: Thomas Köhler | last post by:
Hi, Just having read http://developer.postgresql.org/todo.php - seems like quite a few features for high availibility are still missing. So - what's the recommended way to get some kind of HA up...
13
by: Zlatko Matiæ | last post by:
Is it possible to use Access as front-end for POstgreSQL and how ? What about Access Projects (.adp) and PostgreSQL ?
18
by: Marc G. Fournier | last post by:
After several fixes were backpatches to the 7_4_STABLE branch, we have now released a 7.4.3. As the list of Changes since 7.4.2 is quite small, they are included in this email: * Fix temporary...
2
by: John | last post by:
As per subject, i'm considering migrating a database (still in development) from MaxDB to postgresql. The main reason for this is that the stored procedures (functions) in MaxDB are unreliable and...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.