On Wednesday 05 September 2007, Jim Lynch wrote:
> Lamar,
>
> Thanks for testing, thanks for the success report and the shout out :)
Sure. I'm glad somebody decided to pick it up; I've not run OpenACS is some
time now, and really didn't have the need or time to further maintain the
PostgreSQL d
Lamar,
Thanks for testing, thanks for the success report and the shout out :)
Everyone,
Hi, the more people testing this the better :) if there are changes
you don't understand enough to use, please post here and I'll respond
by editing the README (so please read that beforehand; thanks)...
I'm
On Tuesday 26 June 2007, Dossy Shiobara wrote:
> A new version of the nspostgres module is now available for download at
> SourceForge, nspostgres-4.1.
>
> In this version, Jim Lynch made some improvements to the build process,
> and cleaned up the error reporting code.
And looks to have done a fi
On 2007.06.27, Agustin Lopez <[EMAIL PROTECTED]> wrote:
> For us it will be useful. Restart our OpenACS instances waste aprox.
> 3-4 minutes. Moreover, we are working
> with 4 aolservers in cluster. We have to restart all the aolserver
> instances.
Have you tried "ns_db bouncepool poolname"? W
You say you want to reconnect the driver to a postgres that has been shut
down,,, at this moment, I'm not quite understanding: you can't connect to a
server which is not running.
Ok. I want to say shutdown / start. Sorry.
But, if you mean that you start the server after that and expect aols
On 27 Jun 2007, at 11:54, Jim Lynch wrote:
I don't believe it would be useful to require aolserver to have to
watch for
dropped connections to aolserver; that takes an extra process or
thread and
CPU time that should be used for what aolserver's job is.
The postgres driver could easily do a q
Hi,
You say you want to reconnect the driver to a postgres that has been shut
down,,, at this moment, I'm not quite understanding: you can't connect to a
server which is not running.
But, if you mean that you start the server after that and expect aolserver
to be watching for this, it would requi
Hi!
Thanks for your work!
We are using that module with OpenACS several years. It always has
worked Ok.
The only problem is that it do not reconnect if we shutdown the Postgres DB.
Any pointer to solucionate this?
Best regards,
Agustin
Dossy Shiobara escribió:
A new version of the nspostg
A new version of the nspostgres module is now available for download at
SourceForge, nspostgres-4.1.
In this version, Jim Lynch made some improvements to the build process,
and cleaned up the error reporting code.
Download:
http://sourceforge.net/project/showfiles.php?group_id=3152&package_
On 2007.06.26, Martin Matuska <[EMAIL PROTECTED]> wrote:
> I have noticed that the nspostgres module was tagged with the
> "nspostgres_v4_r1" tag.
> Is this version going to be released?
>
> URL: http://aolserver.cvs.sourceforge.net/aolserver/nspostgres/
Absolute
I have noticed that the nspostgres module was tagged with the
"nspostgres_v4_r1" tag.
Is this version going to be released?
URL: http://aolserver.cvs.sourceforge.net/aolserver/nspostgres/
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send a
Likely you are installing into a directory you don't have permission. Sudo to
root for make install.
For intall the .so file needs to go into the bin directory for your aolserver
install.
tom jackson
On Wednesday 07 February 2007 05:04, Arturo Mardones wrote:
> On 2/6/07, Dave Bauer <[EMAIL PR
On 2/6/07, Dave Bauer <[EMAIL PROTECTED]> wrote:
On 2/6/07, Arturo Mardones <[EMAIL PROTECTED]> wrote:
> Hi,
>
> i'm trying install nspostgres and throw me this error...
>
> [EMAIL PROTECTED] nspostgres-4.0]# make install POSTGRES=/usr/bin
You have POSTGRES pointing to /usr/bin which is probably
On 2/6/07, Arturo Mardones <[EMAIL PROTECTED]> wrote:
Hi,
i'm trying install nspostgres and throw me this error...
[EMAIL PROTECTED] nspostgres-4.0]# make install POSTGRES=/usr/bin
You have POSTGRES pointing to /usr/bin which is probably not the right
place. It should point to wherever postgr
Probably your LD_LIBRARY_PATH is not set, or you don't have postgres
installed?
You are missing the libpq-fe.h header file.
tom jackson
On Tuesday 06 February 2007 13:49, Arturo Mardones wrote:
> In file included from nspostgres.c:32:
> nspostgres.h:48:22: error: libpq-fe.h: No such file or dir
Hi,
i'm trying install nspostgres and throw me this error...
[EMAIL PROTECTED] nspostgres-4.0]# make install POSTGRES=/usr/bin ACS=1
INST=/usr/local/aolserver AOLSERVER=/usr/local/aolserver
gcc -pipe -DBIND_EMULATION -I/usr/bin/include -DFOR_ACS_USE -O2 -Wall
-Wno-implicit-int -fno-strict-alias
Heh, more like my vision is blurry.
Thanks,
Nate
On Tue, 14 Dec 2004 17:37:23 -0500, Dossy Shiobara <[EMAIL PROTECTED]> wrote:
> On 2004.12.14, Nathaniel Haggard <[EMAIL PROTECTED]> wrote:
> > That lib is already included in the compile:
> > make PGINC="/sm/include" POSTGRES="/sm" NSHOME="/sm/ao
On 2004.12.14, Nathaniel Haggard <[EMAIL PROTECTED]> wrote:
> That lib is already included in the compile:
> make PGINC="/sm/include" POSTGRES="/sm" NSHOME="/sm/aolserver"
> ACS=/sm/aolserver
> /bin/rm -f nspostgres.so
> cc -bundle -L/sm/aolserver/lib -o nspostgres.so nspostgres.o -L/sm/lib
> -lpq
That lib is already included in the compile:
make PGINC="/sm/include" POSTGRES="/sm" NSHOME="/sm/aolserver" ACS=/sm/aolserver
/bin/rm -f nspostgres.so
cc -bundle -L/sm/aolserver/lib -o nspostgres.so nspostgres.o -L/sm/lib
-lpq -lnsthread -lnsd -framework Tcl -lpthread -framework
CoreFoundation
l
On 2004.12.14, Nathaniel Haggard <[EMAIL PROTECTED]> wrote:
> When compiling nspostgres on the mac it gives the following errors:
> ld: Undefined symbols:
> _Ns_DbDriverName
> _Ns_DbRegisterDriver
> _Ns_TclDbGetHandle
> make: *** [nspostgres.so] Error 1
>
> I'm assuming this is a shared library pro
When compiling nspostgres on the mac it gives the following errors:
ld: Undefined symbols:
_Ns_DbDriverName
_Ns_DbRegisterDriver
_Ns_TclDbGetHandle
make: *** [nspostgres.so] Error 1
I'm assuming this is a shared library problem. Any ideas out there?
This is nspostgres4.0beta1 and postgresql 7.4.
I am having issues compiling nspostgres for aolserver. When I compile
the driver is compiles but throws errors. The resulting module loads
but when go to use it with openACS I get the error:
Your Postgres driver is either too old or was not compiled with |ACS=1|.
Please update to a version 2.3 or
* tammy <[EMAIL PROTECTED]>, 2004-03-08 19:26 +0100:
> Hi
>
> Here's how I made nspostgres on OS X.
>
> >## nspostgres ###
> do this as root;)
> ># postgres driver from aolserver
> ># postgres must be installed prior to nspostgres install.
> >
> >cd $SRCDIR/oacs-modules/nspostgres
>
d Fink, and have a precompiled, working PostgreSQL 7.4
installed.
Both reside in /usr/local. The thing is, there's a problem with
nspostgres-4.0.
[EMAIL PROTECTED]:~/Desktop/CleanMeUp/AOLserver/nspostgres-4.0$ make
POSTGRES=/usr/local/pgsql ACS=1
gcc -pipe -DBIND_EMULATION -I/usr/local/pgsql/inc
piled aolserver 4.0.1 under Mac OS X 10.3
Panther with
X-Tools 1.1 and Fink, and have a precompiled, working PostgreSQL 7.4
installed.
Both reside in /usr/local. The thing is, there's a problem with
nspostgres-4.0.
[EMAIL PROTECTED]:~/Desktop/CleanMeUp/AOLserver/nspostgres-4.0$ make
POSTGRES=/usr/l
rary_init
_SSL_load_error_strings
_SSL_new
_SSL_read
_SSL_set_ex_data
_SSL_set_fd
_SSL_shutdown
_SSL_write
_TLSv1_method
_X509_NAME_get_text_by_NID
_X509_NAME_oneline
_X509_check_private_key
_X509_free
_X509_get_subject_name
make: *** [nspostgres.so] Error 1
[EMAIL PROTECTED]:~/Desktop/C
On Mon, Oct 20, 2003 at 02:28:23PM -0500, Tom Brown wrote:
> ** Here is the first run, without Andrew Piskorski's fix.
> ** Here is the 2nd run, with Andrew Piskorski's fix. Changed nsadmin's
> default group to "web."
What are the differences in behavior between the two exactly?
> **
** Here is the first run, without Andrew Piskorski's fix.
[EMAIL PROTECTED]:/usr/local/aolserver/bin#
[20/Oct/2003:13:51:30][12277.1024][-main-]
Notice: tbrown.tcl: starting to read config file...
[20/Oct/2003:13:51:30][12277.1024][-main-] Fatal: config: script error:
/usr/loc
al/pgsql/lib/li
On Sun, Oct 19, 2003 at 10:29:17PM -0500, Tom Brown wrote:
> >Does that user have read and execute access to /, /usr, /usr/local,
> >/usr/local/pgsql, and /usr/local/pgsql/lib?
>
> User "nsadmin" has its own group, "nsadmin", and is a member of group "web".
That's probably your problem then. AOL
insert at the top of your config file the lines
ns_log Notice [exec /usr/bin/file /usr/local/pgsql/lib/libpq.so.2]
ns_log Notice [exec /usr/bin/file /usr/local/pgsql/lib/libpq.so.2.2]
ns_log Notice [exec /bin/ls -lF /usr/local/pgsql/lib/]
exit
(assuming those paths are correct for your "file" and
At 10:45 AM 10/13/03 -0500, you wrote:
+-- On Oct 12, Tom Brown said:
| I am running Aolserver (3.3.1_ad13) without the OACS system. I created an
| aolserver config file using the nspostgres.so driver, version 1.6,
| 2002/12/16, and code from OpenACS' sample aolserver config. I am starting
+-- On Oct 12, Tom Brown said:
| I am running Aolserver (3.3.1_ad13) without the OACS system. I created an
| aolserver config file using the nspostgres.so driver, version 1.6,
| 2002/12/16, and code from OpenACS' sample aolserver config. I am starting
| the server with nsd-postgres.
Are yo
I am running Aolserver (3.3.1_ad13) without the OACS system. I created an
aolserver config file using the nspostgres.so driver, version 1.6,
2002/12/16, and code from OpenACS' sample aolserver config. I am starting
the server with nsd-postgres.
This appears to be the final error to clear:
Notice:
On Fri, 27 Jun 2003 14:52:10 -0700
tammy <[EMAIL PROTECTED]> wrote:
> Hi
>
> Change:
> ns_section "ns/db/pool1"
>
> To:
> ns_section ns/db/pool/pool1
>
> and the same for your other pools
Thank you for the quick response. The database driver works fine. I must buy an
eye-glasses. 8-))
Kind
On Friday 27 June 2003 02:47 pm, you wrote:
> Hello All,
>
> I have an AOLserver installed on NetBSD-current with Zoran's help. It works
> fine but I can't connect to a postgres database. The PostgreSQL version is
> 7.3.3, the AOLserver version is 4b8, the nspostgres driver version is
> 4.0-beta1.
Hi
Change:
ns_section "ns/db/pool1"
To:
ns_section ns/db/pool/pool1
and the same for your other pools
t
On Friday, June 27, 2003, at 02:47 PM, Kulcsár Ferenc wrote:
Hello All,
I have an AOLserver installed on NetBSD-current with Zoran's help. It
works fine but I can't connect to a
Hello All,
I have an AOLserver installed on NetBSD-current with Zoran's help. It works fine but I
can't connect to a postgres database. The PostgreSQL version is 7.3.3, the AOLserver
version is 4b8, the nspostgres driver version is 4.0-beta1. After the server startup
it gives the following mess
I try to avoid changing makefiles so I created two symbolic links. See this
"patch" which I submitted tgo the ACS docs:
I took stock AOLserver 3.3+ad13 and the makefiles make some assumptions about
include and bin file locations that are not correct on Debian. I rather use
symbolic li
Downloaded postgresql-contrib, -doc, -dev. Postgresql-client was already
installed. Make clean, then make. Still returned errors. So I applied Andrew
Piskorski's Makefile Debian tweaks. Muffed it a few times before I got the
file right.
Presto, /usr/lib/aolserver/bin/nspostgres.so. Now to set u
> nspostgres.h:45: libpq-fe.h: No such file or directory
I'm not sure how its done on other distros, but with RedHat you
would need the postgresql development package. It is separate
from the main package.
Daniel P. Stasinski
Software Engineer
Mayor Pharmaceutical Laboratories
[EMAIL PROTECTED]
to: /var/log/postgres.log
Here's the patch for my nspostgres/Makefile:
$ cvs stat Makefile
===
File: Makefile Status: Needs Merge
Working revision:1.4
Repository r
On Tuesday 27 May 2003 13:10, Tom Brown wrote:
> As a consequence I am having difficulty installing nspostgres. I just
> finished one round of altering the Makefile ($NSHOME path) which helped
> overcome several "can't find file or directory" type errors. Here is the
> current roadblock.
>nspo
Debian appears to have an odd idea about where binaries belong. Apt-get on
our box puts binaries in /usr/lib, not /usr/local. So aolserver and
postgresql binaries are located in /usr/lib/aolserver/bin and
/usr/lib/postgresql/bin.
As a consequence I am having difficulty installing nspostgres. I
nsdb did the trick!
thanks for the help everyone!
wj
-Original Message-
From: Brett Schwarz [mailto:[EMAIL PROTECTED]]
Sent: Mon 2/10/2003 12:39 PM
To: [EMAIL PROTECTED]
Cc:
Subject:Re: [AOLSERVER] nspostgres and aolserver4beta1 and beta2
This is what I have in my
This is what I have in my nsd.tcl:
#
# Modules to load
#
ns_section "ns/server/${servername}/modules"
ns_param nsdb ${bindir}/nsdb${ext}
ns_param nssock ${bindir}/nssock${ext}
ns_param nslog ${bindir}/nslog${ext}
ns_param nsresult ${bindir}/nsresult${e
I checked the nsd.tcl and I have these now:
ns_section "ns/db/drivers"
ns_param postgres ${bindir}/nspostgres.so
ns_section "ns/db/pools"
ns_param main "Main Pool"
ns_section "ns/db/pool/main"
ns_param Driver postgres
ns_param Connections 5
ns_param DataSource
Did you change the config file to load the nsdb module in
ns_section ns/server/$server/modules ?
Jamie
Wes James wrote:
Well, I tried an adp page that would access a database and now I get this:
[10/Feb/2003:10:52:57][2412.40966][-conn:server1::0] Error: invalid command
name "ns_db"
invalid co
Well, I tried an adp page that would access a database and now I get this:
[10/Feb/2003:10:52:57][2412.40966][-conn:server1::0] Error: invalid command
name "ns_db"
invalid command name "ns_db"
while executing
"ns_db gethandle"
I looked at the startup info for aols4b1 and noticed that there is
/2003 9:05 AM
To: [EMAIL PROTECTED]
Cc:
Subject:Re: [AOLSERVER] nspostgres
Pull the CVS copy of nspostgres -- I believe that one works with
AOLserver 4.x, but hasn't been packaged for a release yet.
On Monday 10 February 2003 11:05, Scott Goodwin wrote:
> Pull the CVS copy of nspostgres -- I believe that one works with
> AOLserver 4.x, but hasn't been packaged for a release yet.
That would be correct. I probably should package it up, though.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
Pull the CVS copy of nspostgres -- I believe that one works with
AOLserver 4.x, but hasn't been packaged for a release yet.
/s.
On Monday, February 10, 2003, at 09:22 AM, Wes James wrote:
I tried to compile nspostgres 3.5 and I get compile errors with aols4.
I
then try it again with aols351 t
I tried to compile nspostgres 3.5 and I get compile errors with aols4. I
then try it again with aols351 to make sure it will compile. It does. How
do I get the driver to compile for aols4?
wj
Wes,
The nspostgres-3.5 driver at the AOLserver SourceForge site is the most
current. Right now the only difference between the SF version and the
OpenACS cvs version is an improved makefile in the SF version.
--Tom Jackson
Wes James wrote:
So should I use the nspostgres 3.5 or the postgres dri
So should I use the nspostgres 3.5 or the postgres driver at openacs?
wj
On Monday 23 December 2002 23:51, Marc Spitzer wrote:
> Lamar Owen <[EMAIL PROTECTED]> wrote:
> > Having been no bug reports on 3.5beta1, 3.5 is now released. The only
> > change from 3.5beta1 is to comments, the README, and the ChangeLog.
> > No code has changed.
> will this work with the aolser
I got it to compile, but I had to modify it a bit. I had to add nsdb.h
to nspostgres.h.
I haven't done any significant testing on it though...
--brett
On Mon, 2002-12-23 at 20:51, Marc Spitzer wrote:
> On Mon, 23 Dec 2002 19:14:33 -0500
> Lamar Owen <[EMAIL PROTECTED]> wrote:
>
> > Having be
On Mon, 23 Dec 2002 19:14:33 -0500
Lamar Owen <[EMAIL PROTECTED]> wrote:
> Having been no bug reports on 3.5beta1, 3.5 is now released. The only
> change from 3.5beta1 is to comments, the README, and the ChangeLog.
> No code has changed.
>
will this work with the aolserver 4 also?
thanks
marc
On Mon, Dec 23, 2002 at 07:14:33PM -0500, Lamar Owen wrote:
> Having been no bug reports on 3.5beta1, 3.5 is now released. The only change
> from 3.5beta1 is to comments, the README, and the ChangeLog. No code has
> changed.
>
> TODO:
> Have the dropping out of postmaster not crash AOLserver (dri
Having been no bug reports on 3.5beta1, 3.5 is now released. The only change
from 3.5beta1 is to comments, the README, and the ChangeLog. No code has
changed.
TODO:
Have the dropping out of postmaster not crash AOLserver (driver fault).
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
--
http://prdownloads.sourceforge.net/aolserver/nspostgres-3.5beta1.tar.gz?download
is a direct link.
This driver is working well for me on an OpenACS CVS HEAD installation.
If no major problems are found in two weeks, this beta will be promoted to
full release 3.5.
Many thanks to Scott Goodwin
Yikes! I will switch. Thanks!
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: [EMAIL PROTECTED]
On Thursday 14 June 2001 11:56, you wrote:
> Thanks for the tip, but I got the one from aolserver.com already and made
> the tiny fix required.
> It is a very tiny fix...
The one at aolserver.com is unsupported.
The one at openacs.org is actively supported.
--
Lamar Owen
WGCR Internet Radio
1 P
Thanks for the tip, but I got the one from aolserver.com already and made the tiny fix
required.
It is a very tiny fix...
Ian
: AOLserver Discussion [mailto:[EMAIL PROTECTED]]On Behalf
Of Ian Harding
Sent: Wednesday, June 13, 2001 19:26
To: [EMAIL PROTECTED]
Subject: [AOLSERVER] nspostgres
Actually, the length of the query string seems not to be my problem. What
is happening is that any ERROR being returned from postgresql
Sorry for the noise. I am new to this kind of thing...
I found it in the bug tracker: [ #406160 ] nspostgres.c segfaults on postgres error
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: [EMAIL PROTECTED]
Actually, the length of the query string seems not to be my problem. What is
happening is that any ERROR being returned from postgresql is causing nsd to fall on
its face with a segmentation fault. NOTICEs seem to be handled fine.
I assume this is not the typical response to a database error
I have been looking for information relative to this module and have not found much.
There seems to be a limit to the length of the query string that can be sent to
postgresql. Is this the same as the limit in psql? Is there any way around it?
Thanks,
Ian A. Harding
Programmer/Analyst II
T
67 matches
Mail list logo
