By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,240 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

RE : mod_auth_pgsql 2.0.1 don't close the backend connection

P: n/a
> Yes, the mod_auth_pgsql series for Apache 2 is broken as you
describe. It does not release the connection, but the change
is intentional. Looking at the Changelog I see:

- now we reuse database connection, 2x speedup !!

Perhaps this is a good thing with different MPMs, but the
standard prefork module can exhaust the available connections
quite quickly as you describe. Here is a patch for
mod_auth_pgsql 2.0.1 that reverts it to the previous behavior
of a new connection per authentication.
I'm getting many errors when I do the make on the patched files. Is
there other people that have compiled successfully the patched
mod_auth_pgsql 2.0.1 ?

I've attached to this email the error log. Do you have the same errors
than me or do I have missed something ?
I have added the maintainer to the cc: list, perhaps he has
some input?


I don't know, I've written to the maintainer but until now I never
received any answer from him. Is there a CVS somewhere with that project
?

Regards,

---------------------------------------
Bruno BAGUETTE - pg******@baguette.net
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a


On Fri, 3 Oct 2003, Bruno BAGUETTE wrote:
I'm getting many errors when I do the make on the patched files. Is
there other people that have compiled successfully the patched
mod_auth_pgsql 2.0.1 ?

I've attached to this email the error log. Do you have the same errors
than me or do I have missed something ?
It cannot find the necessary pg header files. If you haven't installed
them you need to do so. If you've installed them someplace other than
/usr/local/pgsql/include you need to adjust the Makefile to reflect that.
I don't know, I've written to the maintainer but until now I never
received any answer from him. Is there a CVS somewhere with that project


Not that I know of.

Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2

P: n/a
> It cannot find the necessary pg header files. If you haven't
installed them you need to do so. If you've installed them
someplace other than /usr/local/pgsql/include you need to
adjust the Makefile to reflect that.


You were right, now the compilation is OK :-)

But, now, when I try to access to a mod_auth_pgsql protected directory,
Apache 2.0.47 have a segmentation fault errorr :

Here's an extract of the error log :

[Sun Oct 05 21:33:49 2003] [notice] child pid 2553 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:49 2003] [notice] child pid 2552 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:51 2003] [notice] child pid 2554 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:52 2003] [notice] child pid 2556 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:52 2003] [notice] child pid 2555 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:53 2003] [notice] SIGHUP received. Attempting to
restart
[Sun Oct 05 21:33:53 2003] [notice] seg fault or similar nasty error
detected in the parent process

If I do an apachectl start and retry I have the same error... :-(

Any idea to fix that ? Do you want me to recompile it with debug options
? (If that can help, I will do)
I don't know, I've written to the maintainer but until now I never
received any answer from him. Is there a CVS somewhere with that
project


Not that I know of.


Do you think that the mod_auth_pgsql module is still maintained ? We can
wait one week (maybe Giuseppe Tanzilli in on vacations) before
re-talking about it. However I am asking myself some questions because
this bug is so big (the mod_auth_pgsql for Apache2 is broken) and the
latest mod_auth_pgsql is seven months old.

Either that project is maintained or not, a CVS could be usefull to
allow multiple people submitting patches and documentation improvements
for the mod_auth_postgresql module. I would be interested to improve the
documentation of this module in order to make easier for people to use
that module (and, in the same time, promoting PostgreSQL).

Regards,

---------------------------------------
Bruno BAGUETTE - pg******@baguette.net


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #3

P: n/a
Hello,
I'm working on a new release to fix this,
the connection reuse logic will be different and
will be off by default.
Hope to release something in the evening.
bye,
Giuseppe

Bruno BAGUETTE Scrive:
It cannot find the necessary pg header files. If you haven't
installed them you need to do so. If you've installed them
someplace other than /usr/local/pgsql/include you need to
adjust the Makefile to reflect that.


You were right, now the compilation is OK :-)

But, now, when I try to access to a mod_auth_pgsql protected directory,
Apache 2.0.47 have a segmentation fault errorr :

Here's an extract of the error log :

[Sun Oct 05 21:33:49 2003] [notice] child pid 2553 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:49 2003] [notice] child pid 2552 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:51 2003] [notice] child pid 2554 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:52 2003] [notice] child pid 2556 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:52 2003] [notice] child pid 2555 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:53 2003] [notice] SIGHUP received. Attempting to
restart
[Sun Oct 05 21:33:53 2003] [notice] seg fault or similar nasty error
detected in the parent process

If I do an apachectl start and retry I have the same error... :-(

Any idea to fix that ? Do you want me to recompile it with debug options
? (If that can help, I will do)
> I don't know, I've written to the maintainer but until now I never
> received any answer from him. Is there a CVS somewhere with that
> project


Not that I know of.


Do you think that the mod_auth_pgsql module is still maintained ? We can
wait one week (maybe Giuseppe Tanzilli in on vacations) before
re-talking about it. However I am asking myself some questions because
this bug is so big (the mod_auth_pgsql for Apache2 is broken) and the
latest mod_auth_pgsql is seven months old.

Either that project is maintained or not, a CVS could be usefull to
allow multiple people submitting patches and documentation improvements
for the mod_auth_postgresql module. I would be interested to improve the
documentation of this module in order to make easier for people to use
that module (and, in the same time, promoting PostgreSQL).

Regards,

---------------------------------------
Bruno BAGUETTE - pg******@baguette.net


-------------------------------------
Giuseppe Tanzilli
in**@giuseppetanzilli.it
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #4

P: n/a
Hello,
just published 2.0.2b1, it was on the way from some time.

Please test it,
feel free to send patches.

Bruno BAGUETTE Scrive:
It cannot find the necessary pg header files. If you haven't
installed them you need to do so. If you've installed them
someplace other than /usr/local/pgsql/include you need to
adjust the Makefile to reflect that.


You were right, now the compilation is OK :-)

But, now, when I try to access to a mod_auth_pgsql protected directory,
Apache 2.0.47 have a segmentation fault errorr :

Here's an extract of the error log :

[Sun Oct 05 21:33:49 2003] [notice] child pid 2553 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:49 2003] [notice] child pid 2552 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:51 2003] [notice] child pid 2554 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:52 2003] [notice] child pid 2556 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:52 2003] [notice] child pid 2555 exit signal
Segmentation fault (11)
[Sun Oct 05 21:33:53 2003] [notice] SIGHUP received. Attempting to
restart
[Sun Oct 05 21:33:53 2003] [notice] seg fault or similar nasty error
detected in the parent process

If I do an apachectl start and retry I have the same error... :-(

Any idea to fix that ? Do you want me to recompile it with debug options
? (If that can help, I will do)
> I don't know, I've written to the maintainer but until now I never
> received any answer from him. Is there a CVS somewhere with that
> project


Not that I know of.


Do you think that the mod_auth_pgsql module is still maintained ? We can
wait one week (maybe Giuseppe Tanzilli in on vacations) before
re-talking about it. However I am asking myself some questions because
this bug is so big (the mod_auth_pgsql for Apache2 is broken) and the
latest mod_auth_pgsql is seven months old.

Either that project is maintained or not, a CVS could be usefull to
allow multiple people submitting patches and documentation improvements
for the mod_auth_postgresql module. I would be interested to improve the
documentation of this module in order to make easier for people to use
that module (and, in the same time, promoting PostgreSQL).

Regards,

---------------------------------------
Bruno BAGUETTE - pg******@baguette.net


-------------------------------------
Giuseppe Tanzilli
in**@giuseppetanzilli.it
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #5

P: n/a
Hello,

I've just tested mod_auth_pgsql 2.0.2b1 using Auth_PG_connection_reuse
on and off and it seems OK for me :-)

By the way, is there a way to calculate the minimal number of PostgreSQL
connections I have to setup in the postgresql.conf on the basis of the
maximum request allowed in the Apache httpd.conf ?

Thanks a lot Giuseppe :-)

Regards,

----------------------------------------
Bruno BAGUETTE - pg******@baguette.net
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.