473,241 Members | 1,612 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,241 software developers and data experts.

RE : mod_auth_pgsql 2.0.1 don't close the backend connection

> 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
5 1742


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

Similar topics

3
by: Molly Gibson | last post by:
Hi all, I have recently installed Apache/1.3.28 + mod_auth_pgsql-0.9.12 (http://www.giuseppetanzilli.it/mod_auth_pgsql/) The only way I have been able to get it to successfully authenticate...
1
by: Chris | last post by:
I have a frontend that has some tables which are linked to a backend. Now I want to make the backend password protected and when I try to run it password protected I can't open it. In the first...
3
by: Ryan Riehle | last post by:
Hi All! Trying to upgrade to Apache 2.0.49 and getting compile errors related to mod_auth_pgsql, any clue?: make: Entering directory `/usr/src/httpd-2.0.49'...
6
by: Sharon | last post by:
Hi all. I'm trying first time async socket connection. In all the examples i've seen, the server connection is closed when the message is complete. Is it common to close the connection after...
13
by: rdemyan via AccessMonster.com | last post by:
My front-end code manually links to the backend file. I was wondering what stops Access from linking to the system tables in the backend file. Is it just by virtue that they are hidden? This...
4
by: ashleycvernon | last post by:
I am using MS Access forms as a front end to a backend SQL Server Database. I am trying to use an ADO connection to return a Select Statement from the SQL Server to an Access form to be viewable...
9
by: fniles | last post by:
I am using VB.NET 2003 and SQL 2005. To use connection pooling and avoid the error "There is already an open DataReader associated with this Connection which must be closed first." , I understand...
8
by: mark_aok | last post by:
Hi all, I have a split database. Both the forms, and the tables are stored on a shared network drive (this is Access 2003). The users use the forms, and the tables on the network drive, there...
7
by: =?Utf-8?B?Sm9obiBTdGFnZ3M=?= | last post by:
Hello, Please read this all before giving an answer :) I'm doing some troubleshooting on a web application that my company wrote. It's written in asp.net 1.1. The error that the Event viewer...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...

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.