Re: [AOLSERVER] Generating .pdf Files on the Fly
I've used Apache FOP. It works pretty well but it's in Java. You don't really need to know Java to use it since it relies on XML and stylesheets On Jul 14, 2004, at 4:32 PM, Nathan Folkman wrote: Is anyone doing this? More importantly, is anyone doing this via Tcl? Any pointers would be appreciated. Thanks! -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] A slight change of subject......
Your numbers are very interesting. I've been telling people Sun hardware is just as fast but cheaper and they look at me like I've got 3 eyes or something. v240 2 processor 2 gig ram 2 x 73 gig drives Solaris 9 $6895 1747 c/s Compaq DL 360 2 processor 2 gig ram 2 x 73 gig drives Redhat AS 2.1 $7405 1835 c/s On the low end I run Sun X1's off ebay for $400 or the V100 for $995. Even if they only manage 1% of the v240 numbers that's 17 c/s. More than enough for development and most sites. The Sun is a 64 bit machine and has LOM so you can manage it completely from the serial port. I've never used Compaq. Can you power it up and install it without being there? Not that is matters but did you test the 1 gig or 1.28 gig Sun box. the 1.28 just came out. Also in that config the v210 would be $4945 with the 1 gig processors. Basically $2500 cheaper than the Compaq and within 10% of the performance. Given the variability of benchmarks I'd call it a dead heat in performance and price/performance. It's really more which you'd rather use. I personally think you need a 64bit box to run a database and I'd rather have all Sun than mix Solaris and Linux. I would like to see Xserve numbers. I have run the Xraid and it's very impressive Barry On Jun 23, 2004, at 6:58 PM, Adam Leff wrote: Sure. I think the Ops guys there might still have an Xserve laying around. He's right... we do. I'm still not sure if it's ever been turned on. ;) The bigger question is what the bench marks would be exactly. Bingo. It all depends on the application. Most of the testing that's done on webservers is *usually* how it deals under duress serving static pages... yes, there are dynamic testing benchmarks out there. There are so many flippin' ways we use AOLserver just at AOL that it's completely unfair to say that AOLserver X.X is better on Solaris than it is on Linux. You have to take so many things into consideration (external dependencies, databases, compilation options, OS tuning parameters). Comparing AOLserver as used by AOL.com to AOLserver as used by Moviefone.com or even AOLserver as a backend application layer isn't fair. So that's why we do our best to test each application and its dependencies. Sadly, usually the testing is done after the hardware is purchased. Yay for compressed timeframes. But then again, the prices of x86 hardware (and the associated support contracts) make executives happy. :) That being said, I did a test a little bit ago slamming the begeezus out of an .adp page with a bunch of ns_adp_puts in it (so I was exercising the Tcl interpreters, not just the fastpath stuff) on a few platforms: Sun Fire V240, Solaris 9, AOLserver 3.5.10: 1871 conns/sec Sun Fire V240, Solaris 9, AOLserver 4.0.1: 1747 conns/sec Compaq DL 360, RH AS 2.1, AOLserver 3.5.10: 1880 conns/sec Compaq DL 360, RH AS 2.1, AOLserver 4.0.1: 1835 conns/sec Compaq Proliant, RH AS 3.0, AOLserver 3.5.10: 2220 conns/sec Compaq Proliant, RH AS 3.0, AOLserver 4.0.1: 2256 conns/sec As predicted, Red Hat Advanced Server 3.0 came out on top, most likely due to NPTL. The boxes were all hovering between 60-80% CPU utilization... network saturated. ~Adam Adam Leff AOL Web Operations -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] A slight change of subject......
It supprised me also. I had switched to Intel because of cost but lately I've switch back to Sun. It would be interesting to compare numbers between a Compaq and Dell. You would think they would be similar but I think there is a great deal of difference between a $400 2.8 gig P4 and an $800 2.8 gig P4. I did switch from Dell to Sun, but I never did any detailed beachmarking. My informal testing made me think the Sun was as fast or faster. I've run on Intel (Windows and Linux), OSX and Sun. The great thing about AOLServer is you can switch platforms with very little effort. I've even developed on Sun and deployed on Windows with no problems. I did look up the wattage on the Sun and Compaq and they are similar. I suspect the Sparc chip uses less power but by the time you run the rest of the stuff inside the machine there is not much difference. The X1/V100's are a different story. I think they use around 30 watts, but it probably takes 5 to 10 of them to equal a v240. Whatever you pick take a look at the Apple Xraid. 3.5 terabytes and fibre channel for 10K is a good deal and they work just fine with a v240 and Solaris. I even used Apple's fibre channel card in the Sun box. Rumor has it they also work with Linux. Not only are the cheap per gig I think they beat scsi on performance because for the same price you can get nearly 3x the number of spindles while scsi only has 2x the rotation speed. Barry On Thursday, June 24, 2004, at 02:04PM, Bas Scheffers [EMAIL PROTECTED] wrote: Adam Leff said: The Sun V240 is a 2x1Ghz UltraSparcIIIi running Sol9... I didn't have a 1.28Ghz box available at the time I was doing the tests. The DL 360 is a 2x2.8Ghz Xeon. The Proliant is a 2x3.2Ghz Xeon. All with 2 GB of Wow, that's closer than I thought! Mind you, you can get a 2x 3.2GHz/2GB/2x73GB15K machine for a lot less from Dell than from HP/Compaq. But in the end, I guess when you buy brands, it doesn't seem to matter much in price if you go with Sun or any other. I wonder if these 1GHz Suns also need less juice and stay cooler. Not an unimportant consideration; apperantly Google settled on 1GHz machines for their Ireland data centre for that same reason as they could fit more machines in and thus have more CPU power in total. RAM. So yes, you could argue that the Proliant results are possible skewed because of the difference in processor speed. And cache? That 2.8 probably has 512K, the 3.2 likely 1MB, possibly 2. Bas. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] exec in AOLserver
I have not tracked it specifically to the Oracle libs but that's my best guess. I'm not running the nsjk2 module. Currently I got around the problem by building the TCL Posix signal routines and reseting the signal. I think I've other discussion about the jvm catching SIGCHLD. On Tuesday, June 08, 2004, at 12:14PM, Dossy [EMAIL PROTECTED] wrote: On 2004.06.08, Nathaniel H [EMAIL PROTECTED] wrote: AOlserver 4.0.0 to AOlserver 4.0.1 introduces an exec problem. On 4.0.0 I can run both: 1. [exec /bin/bash -c ls -al] 2. [exec /bin/bash -c /opt/myscript] But on AOLserver 4.0.1 (with nsjk2) number 2. fails with this error. error waiting for process to exit: child process lost (is SIGCHLD ignored or trapped?) while executing You should also know that, thanks to Elizabeth nsjk2, I am running nsjk2 on the problem 4.0.1 version. This sounds exactly like the problem that Barry Books reported earlier on this list about nsora and exec. The newer Oracle client library apparently either installs its own SIGCHLD signal handler, or throws SIGCHLD itself. This interferes with Tcl's SIGCHLD handler, therefore when Tcl's [exec] executes something, it wants to be able to catch the SIGCHLD of the child process when it dies. Unfortunately, the signal gets handled elsewhere, so Tcl doesn't see it, and thus [exec] complains about it. I'm guessing that nsjk2 or the JVM, too, installs a SIGCHLD handler replacing Tcl's handler. I don't know enough about nsjk2 or the various JVMs to know the answer to this. -- Dossy -- Dossy Shiobara mail: [EMAIL PROTECTED] Panoptic Computer Network web: http://www.panoptic.com/ He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on. (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
[AOLSERVER] Solaris 9 SIGCHLD problem
I'm running aol 4.01 with tcl8.4.6 on Solaris 9 with ACS. Whenever exec is used I get [28/May/2004:07:35:09][3876.7][-conn:openacs::3] Warning: pa_load_images: error parsing file data /var/tmp/haa_.aGKh Error: 1704 2272 JPEG 306067 16 8cf7d9d1f62df14cf028dee16135f6bd2ae9a7c49ef5b66433f483919a45c662 error waiting for process to exit: child process lost (is SIGCHLD ignored or trapped?) In my logs. Exec seems to work fine in tclsh. Anyone else seen this? thanks, barry -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Solaris 9 SIGCHLD problem
I upgraded AOLSERVER to v40_r3 but I still have the same problem
Here is a sample that breaks
set files [exec ls]
Server Error
There was a server error processing your request. We apologize.
Here is a detailed dump of what took place at the time of the error,
which may assist a programmer in tracking down the problem:
bin
config.tcl
include
lib
log
man
modules
sample-config.tcl
servers
error waiting for process to exit: child process lost (is SIGCHLD
ignored or trapped?)
while executing
exec ls
invoked from within
set files [exec ls]
(uplevel body line 3)
invoked from within
uplevel {
set files [exec ls]
On May 28, 2004, at 8:46 AM, Dossy wrote:
On 2004.05.28, Barry Books [EMAIL PROTECTED] wrote:
I'm running aol 4.01 with tcl8.4.6 on Solaris 9 with ACS. Whenever
exec
is used I get
[28/May/2004:07:35:09][3876.7][-conn:openacs::3] Warning:
pa_load_images: error parsing file data /var/tmp/haa_.aGKh Error: 1704
2272 JPEG 306067 16
8cf7d9d1f62df14cf028dee16135f6bd2ae9a7c49ef5b66433f483919a45c662
error waiting for process to exit: child process lost (is SIGCHLD
ignored or trapped?)
In my logs. Exec seems to work fine in tclsh. Anyone else seen this?
Doing an [exec] from within an nsd is Frowned Upon(tm) as it forks the
whole nsd process.
However, that's a performance and memory usage issue -- totally
unrelated to the error you're seeing. Lets look at the error more
closely ...
Can you provide us the snippet of Tcl code that calls exec which is
generating this error in your log?
-- Dossy
--
Dossy Shiobara mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/
He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on. (p. 70)
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to
[EMAIL PROTECTED] with the
body of SIGNOFF AOLSERVER in the email message. You can leave the
Subject: field of your email blank.
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of
your email blank.
Re: [AOLSERVER] Solaris 9 SIGCHLD problem
I built the tcl posix signal interface and wrote this
ns_log Notice [package require Signal]
signal delete SIGCHLD
ns_log Notice Signals [signal print]
set files [exec ls]
The output is (no error)
Main Site
bin config.tcl include lib log man modules sample-config.tcl servers
So I think something is catching SIGCHLD after the webserver starts
On Friday, May 28, 2004, at 10:14AM, Dossy [EMAIL PROTECTED] wrote:
On 2004.05.28, Barry Books [EMAIL PROTECTED] wrote:
I upgraded AOLSERVER to v40_r3 but I still have the same problem
Here is a sample that breaks
set files [exec ls]
[...]
error waiting for process to exit: child process lost (is SIGCHLD
On 2004.05.28, Barry Books [EMAIL PROTECTED] wrote:
I'm running aol 4.01 with tcl8.4.6 on Solaris 9 with ACS. [...]
OK, this error is coming from tcl/generic/tclPipe.c in
TclCleanupChildren().
I just tested on Solaris 8, AOLserver 4.0.2, Tcl 8.4.4 and everything
works as expected:
dci:nscp 1 catch {exec ls} output
0
dci:nscp 2 llength $output
5
Maybe it would throw an error in an ADP page, but there's no reason why
it should. Lets test anyway:
%
set res [catch {exec ls} output]
ns_adp_puts $res [llength $output]
%
Hit that ADP page in a browser, and I get 0 5 -- exactly what I would
expect.
Could this be an issue with how you're compiling Tcl and AOLserver?
How did you execute configure for each? Check the first 7 or so lines
of the config.status files in your Tcl and AOLserver build directories
and see what they say:
head -7 config.status | tail -1
-- Dossy
--
Dossy Shiobara mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/
He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on. (p. 70)
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with
the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of
your email blank.
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of
your email blank.
Re: [AOLSERVER] Solaris 9 SIGCHLD problem
The default for tcl appears to be /usr/local I just installed this box about 2 weeks ago and I think the only tcl on it is the one I built I'll rebuild tcl and nsd more like yours Here is what ldd says dev1$ ldd nsd libnsd.so = /usr/local/aolserver/lib/libnsd.so libnsthread.so =/usr/local/aolserver/lib/libnsthread.so libtcl8.4.so = /usr/local/lib/libtcl8.4.so libdl.so.1 =/usr/lib/libdl.so.1 libsocket.so.1 =/usr/lib/libsocket.so.1 libnsl.so.1 = /usr/lib/libnsl.so.1 libpthread.so.1 = /usr/lib/libpthread.so.1 libm.so.1 = /usr/lib/libm.so.1 librt.so.1 =/usr/lib/librt.so.1 libc.so.1 = /usr/lib/libc.so.1 libgcc_s.so.1 = /usr/local/lib/libgcc_s.so.1 libmp.so.2 =/usr/lib/libmp.so.2 libaio.so.1 = /usr/lib/libaio.so.1 libmd5.so.1 = /usr/lib/libmd5.so.1 libthread.so.1 =/usr/lib/libthread.so.1 /usr/platform/SUNW,UltraAX-i2/lib/libc_psr.so.1 /usr/platform/SUNW,UltraAX-i2/lib/libmd5_psr.so.1 On Friday, May 28, 2004, at 12:13PM, Dossy [EMAIL PROTECTED] wrote: On 2004.05.28, Barry Books [EMAIL PROTECTED] wrote: AOLSERVER config # # ./configure Here's how I built my AOLserver: # ./configure --prefix=/home/aolserver/4.0.3 --with-tcl=/usr/lib/tcl8.4 --enable-shared TCL config # # ./configure --enable-threads Where does your Tcl install to? /usr/local? The concern I have here is: could AOLserver be building against another version of Tcl installed on your machine that was built without --enable-threads? I'm only assuming that AOLserver's configure script will abort if the Tcl it's building against wasn't built with threads ... What's the output of ldd nsd say? Which libtcl*.so does it want to use? I also made this file ns_log Notice start set files [exec ls] ns_log Notice start $files and get dev1$ ./nsd -f -t /tmp/c.tcl [28/May/2004:10:43:29][17613.1][-main-] Notice: start [28/May/2004:10:43:29][17613.1][-main-] Notice: start init.tcl [...] [28/May/2004:10:43:29][17613.1][-main-] Fatal: nsmain: no servers defined It doesn't give you the SIGCHLD error? Interesting ... that's because in server start-up processing of the init .tcl file (in this case, your c.tcl file) ... it does the [exec] inside the main nsd process, not inside a child thread. Interesting ... -- Dossy -- Dossy Shiobara mail: [EMAIL PROTECTED] Panoptic Computer Network web: http://www.panoptic.com/ He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on. (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Solaris 9 SIGCHLD problem
Welcome to openacs running at /usr/local/aolserver/bin/nsd (pid 19746)
AOLserver/4.0.3 (aolserver4_0) for solaris built on May 28 2004 at 13:12:53
CVS Tag: $Name: aolserver_v40_r3 $
openacs:nscp 1 proc puts {. str} { lappend ::o $str }
parray tcl_platform
join $::o \n
openacs:nscp 2
openacs:nscp 3
tcl_platform(byteOrder) = bigEndian
tcl_platform(machine) = sun4u
tcl_platform(os)= SunOS
tcl_platform(osVersion) = 5.9
tcl_platform(platform) = unix
tcl_platform(threaded) = 1
tcl_platform(user) =
tcl_platform(wordSize) = 4
dev1$ gcc -v
Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.9/3.3.2/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld
--disable-nls
Thread model: posix
gcc version 3.3.2
On Friday, May 28, 2004, at 01:56PM, Dossy [EMAIL PROTECTED] wrote:
On 2004.05.28, Barry Books [EMAIL PROTECTED] wrote:
The default for tcl appears to be /usr/local
I just installed this box about 2 weeks ago and I think the only tcl
on it is the one I built
OK.
Here is what ldd says
dev1$ ldd nsd
libnsd.so = /usr/local/aolserver/lib/libnsd.so
libnsthread.so =/usr/local/aolserver/lib/libnsthread.so
libtcl8.4.so = /usr/local/lib/libtcl8.4.so
OK, this looks good so far.
libdl.so.1 =/usr/lib/libdl.so.1
libsocket.so.1 =/usr/lib/libsocket.so.1
libnsl.so.1 = /usr/lib/libnsl.so.1
libpthread.so.1 = /usr/lib/libpthread.so.1
libm.so.1 = /usr/lib/libm.so.1
librt.so.1 =/usr/lib/librt.so.1
libc.so.1 = /usr/lib/libc.so.1
libgcc_s.so.1 = /usr/local/lib/libgcc_s.so.1
What version of GCC are you using? What's gcc -v say?
libmp.so.2 =/usr/lib/libmp.so.2
libaio.so.1 = /usr/lib/libaio.so.1
libmd5.so.1 = /usr/lib/libmd5.so.1
libthread.so.1 =/usr/lib/libthread.so.1
/usr/platform/SUNW,UltraAX-i2/lib/libc_psr.so.1
/usr/platform/SUNW,UltraAX-i2/lib/libmd5_psr.so.1
OK, can you connect to the nscp and execute the following commands
and tell me what output it sends back:
proc puts {. str} { lappend ::o $str }
parray tcl_platform
join $::o \n
It should look something like this:
tcl_platform(byteOrder) = littleEndian
tcl_platform(machine) = i686
tcl_platform(os)= Linux
tcl_platform(osVersion) = 2.6.5
tcl_platform(platform) = unix
tcl_platform(threaded) = 1
tcl_platform(user) =
tcl_platform(wordSize) = 4
(Gripe: why does [parray] do a [puts stdout ...] instead of returning
a string with \n's in it? Grrr.)
-- Dossy
--
Dossy Shiobara mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/
He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on. (p. 70)
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with
the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of
your email blank.
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of
your email blank.
Re: [AOLSERVER] Solaris 9 SIGCHLD problem
dev1$ make -v GNU Make 3.80 Copyright (C) 2002 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. dev1$ uname -a SunOS dev1 5.9 Generic_112233-12 sun4u sparc SUNW,UltraAX-i2 For what it's worth it happens on my other solaris box but I just copied the binarys up. If you like you can just ssh into my box. Send me an email directly and I'll send you a login. barry On Friday, May 28, 2004, at 03:51PM, Dossy [EMAIL PROTECTED] wrote: On 2004.05.28, Barry Books [EMAIL PROTECTED] wrote: tcl_platform(threaded) = 1 OK, that confirms that, at least. dev1$ gcc -v Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.9/3.3.2/specs Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls Thread model: posix gcc version 3.3.2 What version of make? make -v ... I'm now in the process of trying to find myself a Solaris 9 dev box so I can see if this is reproducible on another machine ... if it is, then I'll start walking the code to see where the problem lies. It's not reproducible on the Solaris 8 machine I have, as well as on x86 Linux. -- Dossy -- Dossy Shiobara mail: [EMAIL PROTECTED] Panoptic Computer Network web: http://www.panoptic.com/ He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on. (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Problem compiling aolserver on Solaris 9
I think you have to do a make distclean or something like that. This url will tell you, unfortunatly I can't get to it right now http://sourceforge.net/tracker/index.php?func=detailaid=800570group_id=3152atid=103152 On Monday, May 17, 2004, at 10:29AM, Trenton Cameron [EMAIL PROTECTED] wrote: I tried that and tried again with both make and gmake and received the same results any other ideas would be greatly appreciated. Rob Crittenden wrote: Try: % export CC=gcc % make clean all rob Trenton Cameron wrote: Aolserver is not compiling for me on solaris 9. The make and install of tcl8.4.5 ran just fine. I am not getting an error message that I know how to interpet. I am getting the source for Aolserver 4.0r3. The ouput from my ./configure and make follow bash-2.05# ./configure --with-threads=/usr/local/lib loading cache ./config.cache checking for Tcl configuration... (cached) found /usr/local/lib/tclConfig.sh checking for existence of /usr/local/lib/tclConfig.sh... loading checking for build with symbols... no checking for timegm... (cached) no checking for fork1... (cached) no checking for poll... (cached) no checking for drand48... (cached) no checking for random... (cached) no checking for _NSGetEnviron... (cached) no checking how to run the C preprocessor... (cached) cc -E checking for mach-o/dyld.h... (cached) yes checking for dl.h... (cached) yes checking need for dup high... no checking msg_controllen in struct msghdr... no checking how to build server image... shared creating ./config.status creating include/Makefile.global creating include/Makefile.module bash-2.05# make make[1]: Entering directory `/usr/local/src/aolserver/aolserver/nsthread' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/usr/local/src/aolserver/aolserver/nsthread' make[1]: Entering directory `/usr/local/src/aolserver/aolserver/nsd' gcc -pipe -O -Wall -Wconversion -Wno-implicit-int -fPIC -I../include -I/usr/local/include -DNO_CONST -DHAVE_UNISTD_H=1 -DHAVE_LIMITS_H=1 -DTCL_THREADS=1 -DUSE_THREAD_ALLOC=1 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DHAVE_PTHREAD_ATTR_SETSTACKSIZE=1 -DHAVE_READDIR_R=1 -DTCL_WIDE_INT_TYPE=long\ long -DHAVE_STRUCT_DIRENT64=1 -DHAVE_STRUCT_STAT64=1 -DHAVE_TYPE_OFF64_T=1 -DWORDS_BIGENDIAN=1 -DHAVE_GETCWD=1 -DHAVE_OPENDIR=1 -DHAVE_STRSTR=1 -DHAVE_STRTOL=1 -DHAVE_STRTOLL=1 -DHAVE_STRTOULL=1 -DHAVE_TMPNAM=1 -DHAVE_WAITPID=1 -DHAVE_UNISTD_H=1 -DHAVE_SYS_PARAM_H=1 -DUSE_TERMIOS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SYS_TIME=1 -DHAVE_TZNAME=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_TIMEZONE_VAR=1 -DHAVE_ST_BLKSIZE=1 -Dstrtod=fixstrtod -DSTDC_HEADERS=1 -DNO_UNION_WAIT=1 -DHAVE_SIGNED_CHAR=1 -DHAVE_LANGINFO=1 -D_REENTRANT=1 -D_POSIX_PTHREAD_SEMANTICS=1 -DHAVE_SYS_IOCTL_H=1 -DHAVE_SYS_FILIO_H=1 -DUSE_DYLD=1 -DUSE_DLSHL=1 -DNsdInit=_init -c -o adpcmds.o adpcmds.c In file included from adpcmds.c:38: nsd.h:67: warning: `POLLIN' redefined /usr/include/sys/poll.h:37: warning: this is the location of the previous definition nsd.h:68: warning: `POLLOUT' redefined /usr/include/sys/poll.h:39: warning: this is the location of the previous definition nsd.h:69: warning: `POLLPRI' redefined /usr/include/sys/poll.h:38: warning: this is the location of the previous definition In file included from adpcmds.c:38: nsd.h:70: redefinition of `struct pollfd' adpcmds.c:36: warning: `RCSID' defined but not used make[1]: *** [adpcmds.o] Error 1 make[1]: Leaving directory `/usr/local/src/aolserver/aolserver/nsd' make: *** [all] Error 1 I am not really sure where to go from here any help would be appreciated. Thanks -Trenton Cameron -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] nspostgres on Mac OS X Panther
I'm not sure it will fix the whole problem but you are missing -lnsdb in the second cc line. You might try this link for other suggestions http://openacs.org/forums/message-view?message_id=135917 barry On Mar 8, 2004, at 3:48 AM, Andre Berger wrote: Hi there, I have successfully compiled 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/local/pgsql ACS=1 gcc -pipe -DBIND_EMULATION -I/usr/local/pgsql/include -DFOR_ACS_USE -Os -Wall -Wconversion -Wno-implicit-int -fno-common -DMAC_OSX_TCL -DHAVE_CFBUNDLE -DUSE_VFORK -DTCL_DEFAULT_ENCODING=\utf-8\ -I/usr/local/aolserver/include -I/System/Library/Frameworks/Tcl.framework/Versions/8.4/Headers -DNO_CONST -DHAVE_UNISTD_H=1 -DHAVE_LIMITS_H=1 -DTCL_THREADS=1 -DUSE_THREAD_ALLOC=1 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DHAVE_PTHREAD_ATTR_SETSTACKSIZE=1 -DHAVE_READDIR_R=1 -DTCL_WIDE_INT_TYPE=long\ long -DHAVE_GETCWD=1 -DHAVE_OPENDIR=1 -DHAVE_STRSTR=1 -DHAVE_STRTOL=1 -DHAVE_STRTOLL=1 -DHAVE_STRTOULL=1 -DHAVE_TMPNAM=1 -DHAVE_WAITPID=1 -DNO_VALUES_H=1 -DHAVE_UNISTD_H=1 -DHAVE_SYS_PARAM_H=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SYS_TIME=1 -DHAVE_TM_ZONE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_TM_GMTOFF=1 -DHAVE_ST_BLKSIZE=1 -DSTDC_HEADERS=1 -DHAVE_SIGNED_CHAR=1 -DHAVE_PUTENV_THAT_COPIES=1 -DHAVE_LANGINFO=1 -DHAVE_SYS_IOCTL_H=1 -DHAVE_SYS_FILIO_H=1 -DHAVE_TIMEGM=1 -DHAVE_POLL=1 -DHAVE_DRAND48=1 -! DHAVE_RANDOM=1 -DHAVE__NSGETENVIRON=1 -DUSE_DYLD=1 -DHAVE_CMMSG=1 -c -o nspostgres.o nspostgres.c nspostgres.c: In function `Ns_PgTableList': nspostgres.c:679: warning: passing arg 3 of `Tcl_DStringAppend' as signed due to prototype nspostgres.c: In function `encode3': nspostgres.c:749: warning: passing arg 1 of `enc_one' with different width due to prototype nspostgres.c:750: warning: passing arg 1 of `enc_one' with different width due to prototype nspostgres.c:751: warning: passing arg 1 of `enc_one' with different width due to prototype nspostgres.c:752: warning: passing arg 1 of `enc_one' with different width due to prototype nspostgres.c: In function `decode3': nspostgres.c:772: warning: passing arg 1 of `get_one' with different width due to prototype nspostgres.c:773: warning: passing arg 1 of `get_one' with different width due to prototype nspostgres.c:774: warning: passing arg 1 of `get_one' with different width due to prototype nspostgres.c:775: warning: passing arg 1 of `get_one' with different width due to prototype nspostgres.c: In function `stream_actually_write': nspostgres.c:864: warning: passing arg 3 of `write' as unsigned due to prototype nspostgres.c: In function `blob_send_to_stream': nspostgres.c:980: warning: `fd' might be used uninitialized in this function nspostgres.c:982: warning: `conn' might be used uninitialized in this function nspostgres.c: In function `parse_bind_variables': nspostgres.c:1211: warning: unused variable `first_bind' nspostgres.c: In function `PgBindCmd': nspostgres.c:1327: warning: unused variable `value_frag_len' /bin/rm -f nspostgres.so cc -bundle -L/usr/local/aolserver/lib -o nspostgres.so nspostgres.o -L/usr/local/pgsql/lib -lpq -lnsthread -lnsd -framework Tcl -lpthread -framework CoreFoundation ld: Undefined symbols: _Ns_Db0or1Row _Ns_Db1Row _Ns_DbDML _Ns_DbDriverName _Ns_DbExec _Ns_DbGetRow _Ns_DbRegisterDriver _Ns_DbSelect _Ns_DbSetException _Ns_TclDbGetHandle _SSL_pending _BIO_free _BIO_new_mem_buf _DH_check _DH_generate_parameters _DH_size _ERR_get_error _ERR_reason_error_string _EVP_PKEY_free _PEM_read_DHparams _PEM_read_PrivateKey _PEM_read_X509 _PEM_read_bio_DHparams _SSL_CTX_ctrl _SSL_CTX_free _SSL_CTX_load_verify_locations _SSL_CTX_new _SSL_CTX_set_tmp_dh_callback _SSL_CTX_set_verify _SSL_CTX_set_verify_depth _SSL_connect _SSL_free _SSL_get_error _SSL_get_ex_data _SSL_get_peer_certificate _SSL_library_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/CleanMeUp/AOLserver/nspostgres-4.0$ ls CVS/ ChangeLog*Makefile* READMEnspostgres.c* nspostgres.h* nspostgres.o Of course I can provide more information if you tell me what you need. I'm no programmer... Thanks! -Andre -- May as well be hung for a sheep as a lamb -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the
Re: [AOLSERVER] Why are there several bugs filed against building on Solaris?
One of the Solaris 9 build problems is mine. It's been a while since I built it, but the problem as I recall is it finds a mach-o/dyld.h include file and decides to use the Max OS X shared lib functions. Currently I don't have a solaris 9 machine so I cannot try and build it. Deleting the defines -DUSE_DYLD=1 -DUSE_DLSHL=1 makes the build succed. I think the lines in configure.in that causes the problem are AC_CHECK_HEADER(mach-o/dyld.h,[AC_DEFINE(USE_DYLD)],) AC_CHECK_HEADER(dl.h,[AC_DEFINE(USE_DLSHL)],) Barry On Tuesday, February 24, 2004, at 06:47AM, Dossy [EMAIL PROTECTED] wrote: Just reviewing the SourceForge bug tracker and I notice several bugs filed against building AOLserver on Solaris. They all seem to be similar/related -- does anyone know why folks are having these problems? I'd like to document it somewhere (say, on the wiki) as to why AOLserver won't build cleanly if you don't meet prerequisites X, Y and Z ... and then just refer people to the page. The following bugs are the ones I'm referring to: [ 663846 ] AOLserver build fails under Solairs 9 (Sparc) [ 800570 ] solaris 9 build problem [ 897678 ] Compiling on Solaris 9 -- Dossy -- Dossy Shiobara mail: [EMAIL PROTECTED] Panoptic Computer Network web: http://www.panoptic.com/ He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on. (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
[AOLSERVER] Oracle 9i
I'm moving an ACS site to 9i and Aolserver 4.0. I've built nsoracle-2.6 and
linked with the oci9 libs and I started getting this in my logs. It appears
from the Oracle site there is a change in the drivers that requires
initilizing bind variables. I'm assuming this requires a driver change. Does
anyone have a patch?
thanks
barry
[17/Sep/2003:14:32:28][2360.6][-conn:openacs::2] Error: SQL():
ora8.c:3370:ora_tcl_command: error in `OCIStmtExecute ()': ORA-01480:
trailing null missing from STR bind value
The code is
set out [ns_ora exec_plsql $db {
declare
status number;
linevarchar2(4000);
ret varchar2(32000);
begin
status := 0;
ret := ' ';
while status = 0 loop
dbms_output.get_line(line,status);
if ( status = 0 ) then
ret := ret || line || 'br';
end if;
end loop;
:1 := ret;
end;
} ]
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of
your email blank.
[AOLSERVER] Ns_parseheader or _ns_http_gets problem
Has anyone had issues with ns_parseheader or _ns_http_gets. I have a
function that pulls an XML document from another server and it returns
httppost invalid header: HTTP/1.1 200 OK
Every now and then under load. I'm running aol33.
In looking at the C code it appears ns_parseheader is expecting an ns_set
and headers excluding the status line. The code is from acs and does
set http [util_httpopen POST $url $timeout $http_referer]
set rfd [lindex $http 0]
set wfd [lindex $http 1]
#headers necesary for a post and the form variables
_ns_http_puts $timeout $wfd Content-type:
application/x-www-form-urlencoded \r
_ns_http_puts $timeout $wfd Content-length: [string length
$formvars]\r
_ns_http_puts $timeout $wfd \r
_ns_http_puts $timeout $wfd $formvars\r
flush $wfd
close $wfd
set rpset [ns_set new [_ns_http_gets $timeout $rfd]]
while 1 {
set line [_ns_http_gets $timeout $rfd]
if ![string length $line] break
ns_parseheader $rpset $line
}
set headers $rpset
set response [ns_set name $headers]
set status [lindex $response 1]
So I guess what this does is create a set named by the status line???, then
for each header line call ns_parseheader. It appears the first _ns_http_gets
is not getting the status line from the response causing ns_parseheader to
blow up. I've verified this by adding
set n [_ns_http_gets $timeout $rfd]
ds_comment $n
ns_log ERROR httppost %$n%
if { $n == } {
set n [_ns_http_gets $timeout $rfd]
ds_comment $n
ns_log ERROR httppost2 %$n%
}
The strange this is _ns_http_gets should not return a empty string.
Barry Books
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of
your email blank.
Re: [AOLSERVER] Personal Certificate
Have you tried Safari 1.0? I've had SSL problems on my Mac also but for the most part they seem to be fixed since I upgraded. I don't know if it supports personal certificates though, but if you mean self signed I think you can now access sites with invalid certificates. barry -Original Message- From: Mark Aufflick [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 10:02 AM To: [EMAIL PROTECTED] Subject: [AOLSERVER] Personal Certificate Hi all, I have a quirky issue - when i connect ot my openacs (aolserver 3.3+ad13) site from mac ie, it refuses to access ssl pages, and complains that it (mac ie) does not support personal certificates. Further investigations shows that mac ie has a bug that won't let you access a site that ALLOWS personal certificates, even if it is optional. Now I didn't even know that ns_openssl supported personal certificates, maybe current openssl library calls need a flag to tell them not to support personal certificates. Before I go and get my hands good and dirty, does anyone have any ideas? Mark. DISCLAIMER: this post contains nothing regarding p0und proxies or any sub-function of ns_conn ;) -- Mark Aufflick e: [EMAIL PROTECTED] w: www.pumptheory.com p: +61 438 700 647 -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Personal Certificate
I think 1.0 allows some control over what certs it will accept. I'm not in front of my mac but I think under the security settings you can allow expired certs etc. It may be under the Debug menu which makes it much less useful. barry -Original Message- From: Janine Sisk [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 10:27 AM To: [EMAIL PROTECTED] Subject: Re: [AOLSERVER] Personal Certificate Unfortunately Safari has it's own quirky issue with SSL. Some people are reporting that you can't get to https URLs if you are behind a proxy server and I have found that to be true at Sloan; I've had to go back to using Mozilla when I'm in the office. I admit I haven't tried very hard to work around the problem, though, since it seems to be a known issue and probably not under user control. janine On Monday, July 21, 2003, at 11:19 AM, Barry Books wrote: Have you tried Safari 1.0? I've had SSL problems on my Mac also but for the most part they seem to be fixed since I upgraded. I don't know if it supports personal certificates though, but if you mean self signed I think you can now access sites with invalid certificates. barry -Original Message- From: Mark Aufflick [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 10:02 AM To: [EMAIL PROTECTED] Subject: [AOLSERVER] Personal Certificate Hi all, I have a quirky issue - when i connect ot my openacs (aolserver 3.3+ad13) site from mac ie, it refuses to access ssl pages, and complains that it (mac ie) does not support personal certificates. Further investigations shows that mac ie has a bug that won't let you access a site that ALLOWS personal certificates, even if it is optional. Now I didn't even know that ns_openssl supported personal certificates, maybe current openssl library calls need a flag to tell them not to support personal certificates. Before I go and get my hands good and dirty, does anyone have any ideas? Mark. DISCLAIMER: this post contains nothing regarding p0und proxies or any sub-function of ns_conn ;) -- Mark Aufflick e: [EMAIL PROTECTED] w: www.pumptheory.com p: +61 438 700 647 -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] turn database verbosity on/off?
Here is my db_exec function. The subst happens after the database call so
the database sees the bind variables but developer support sees the values.
It's kludgy and is easily fooled but works 99+% of the time. I'm sure it
could be done better but I think this runs fast ( I use this in production
). Picking up the dbms_output is helpfull also since you can output from
large plsql functions and see the stuff at the bottom of your page.
Otherwise debuging large plsql blocks is nearly impossible.
barry
ad_proc -private db_exec { type db statement_name sql args } {
A helper procedure to execute a SQL statement, potentially binding
depending on the value of the $bind variable in the calling environment
(if set).
} {
set start_time [clock clicks]
set out
catch {
set out [ns_ora exec_plsql $db {
declare
status number;
linevarchar2(4000);
ret varchar2(32000);
begin
status := 0;
ret := ' ';
while status = 0 loop
dbms_output.get_line(line,status);
if ( status = 0 ) then
ret := ret || line || 'br';
end if;
end loop;
:1 := ret;
end;
} ]
} err
if { $out != } {
ds_comment dbmsOutput: $out
}
ns_ora dml $db {
begin
dbms_output.enable(10);
end;
}
set vars test
set errno [catch {
upvar bind bind
if { [info exists bind] [llength $bind] != 0 } {
if { [llength $bind] == 1 } {
append vars $bind
return [eval [list ns_ora $type $db -bind $bind $sql] $args]
} else {
set bind_vars [ns_set create]
foreach { name value } $bind {
ns_set put $bind_vars $name $value
append vars $name=$value
}
return [eval [list ns_ora $type $db -bind $bind_vars $sql]
$args]
}
} else {
append vars none
return [uplevel 2 [list ns_ora $type $db $sql] $args]
}
} error]
regsub -all {:([a-zA-z])} $sql {$\1} sql
catch {
set sql [uplevel 2 [list subst $sql]]
} err
ad_call_proc_if_exists ds_collect_db_call $db $type $statement_name $sql
$start_time $errno $error
if { $errno == 2 } {
return $error
}
global errorInfo errorCode
return -code $errno -errorinfo $errorInfo -errorcode $errorCode $error
}
-Original Message-
From: Andrew Piskorski [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 8:53 AM
To: [EMAIL PROTECTED]
Subject: Re: [AOLSERVER] turn database verbosity on/off?
On Tue, May 28, 2002 at 03:59:55AM -0500, Barry Books wrote:
I patched the ACS database routines somthing like
catch {
regsub {:} $sql {$} sql
set sql [subst $sql]
} err
The regsub makes the bind variables TCL variables and subst replaces them
with the value. The catch fixes dumb problems like where a = ':abc'. This
goes right before the developer support call in the db routines. I also
patched them so you can do dbms_output and capture it. I can dig up the
exact patch later if you need it.
Barry, so you effectively eliminated all use of bind variables? That
doesn't seem like a good idea - I WANT to use bind variables. I'd
just like some convenient way of including the values of the bind vars
in any error message. Perhaps there's a simpler way, but I suspect
I'd need to add that to the database driver (Oracle in this case).
--
Andrew Piskorski [EMAIL PROTECTED]
http://www.piskorski.com
Re: [AOLSERVER] turn database verbosity on/off?
I patched the ACS database routines somthing like
catch {
regsub {:} $sql {$} sql
set sql [subst $sql]
} err
The regsub makes the bind variables TCL variables and subst replaces them
with the value. The catch fixes dumb problems like where a = ':abc'. This
goes right before the developer support call in the db routines. I also
patched them so you can do dbms_output and capture it. I can dig up the
exact patch later if you need it.
barry
-Original Message-
From: Andrew Piskorski [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 27, 2002 6:36 PM
To: [EMAIL PROTECTED]
Subject: Re: [AOLSERVER] turn database verbosity on/off?
On Mon, May 27, 2002 at 06:49:58PM -0400, Peter M. Jansson wrote:
ns_db verbose usually works for me, on a per-pool basis.
Oh, right, I forgot aobout that. No per statement setting though,
bummer.
Also, keep in mind that the LogSQLErrors parameter tells the
database pool manager to log an SQL statement that generates an
error return, even of verbose is off. In production, I'd usually
recommend that you run with verbose off and LogSQLErrors on.
Yes, that's definitely an improvement, thanks. Unfortunately, when
using the ACS db-api the values of the bind variables do not show up
in the error message, and with verbose turned off, they of course
never show up in the log at all. Maybe there's some way to get the
bind variable stuff into the error message, but I haven't looked into
it.
On Mon, 27 May 2002, Andrew Piskorski wrote:
Is there any way to turn the Verbose parameter setting for a
database pool on or off on a per-query or per handle basis? Or to
change it on the fly after server startup in any fashion?
--
Andrew Piskorski [EMAIL PROTECTED]
http://www.piskorski.com
[AOLSERVER] XML Parser
Does anyone have any recommendations for xml parsers that work under aol server and the relative merits of each? I need to parse documents that may exceed 1 meg and have more than 1000 elements. Since these will be done on a page request I need to do that in less than a second. Thanks Barry
[AOLSERVER] 502 Error Code
Hello, I had a client call last evening saying they were unable to access my website. The error returned was 502 Too many users. I looked up 502 and it's Bad Gateway. Grepping thru the source I could find no reason why AOL server would return this. I'm running AOL 33 with arsdigital patches and ACS 4.2 on Solaris. One interesting thing I noticed. I have some log entries that I believe were from the client and it appears they are an AOL user. Could it be the AOL Internet gateway had too many users? Barry
[AOLSERVER] 502 error
Hello, I had a client call this evening saying they were unable to access my website. The error returned was 502 Too many users. I looked up 502 and it's Bad Gateway. Grepping thru the source I could find no reason why AOL server would return this. I'm running AOL 33 with arsdigital patches and ACS 4.2 on Solaris. One interesting thing I noticed. I have some log entries that I believe were from the client and it appears they are an AOL user. Could it be the AOL Internet gateway had too many users? Barry
Re: [AOLSERVER] URGENT AOLSERVER + ACS + SOLARIS
Did you turn on clustering? I think tasks only run on the master in a cluster. Barry Books -Original Message- From: Allan Regenbaum DP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 8:03 AM To: [EMAIL PROTECTED] Subject: [AOLSERVER] URGENT AOLSERVER + ACS + SOLARIS We are running a production AOLServer 3.3.1 + ad13 on solaris We have 2 machines, duplicates of each other. Machine A suddenly, without error messages stops running scheduled procs !! Machine B continues to perform flawlessly The machine is running acs classic 4.2 tcl, 90% webmail which has been running perfectly well under stress and load for months... Urgent help/suggestions are appreciated .. Allan Regenbaum Digital People
Re: [AOLSERVER] AOLserver on Solaris 8
I have it running on Solaris 8 (sparc X1) with ACS/Oracle and Scott's ssl. I don't recall having any problems compling or running. Barry - Original Message - From: Brian Fenton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 31, 2001 5:35 AM Subject: [AOLSERVER] AOLserver on Solaris 8 Hi there, Are there any known problems with AOLserver 3.x and Sun Solaris 8? The AOLserver website says it is known to compile and run on Solaris 2.6 and 7 (SPARC and x86). Has anyone any tales from the front? This is for an ACS Classic setup, BTW, so any ACS/Oracle stories would be interesting too. Cheers, Brian
[AOLSERVER] nsvhr
Does anyone know the status of nsvhr? It does not appear in the current release and the code on sourceforge appears to be about 6 months old. I was thinking about using it to build an SSL proxy. That way I could have a set of servers to handle SSL connections and load balance the requests back to a set of servers not running SSL. That way I can have one SSL client session talking to multiple servers on the server side. Has anyone tried this or have any other suggestions? Thanks Barry
Re: [AOLSERVER] .ida code red worm crashes AOLserver 2.1 on Win 2k
502 -Original Message- From: Michael E. Duffy [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 3:58 PM To: [EMAIL PROTECTED] Subject: Re: [AOLSERVER] .ida code red worm crashes AOLserver 2.1 on Win 2k More important, what response did AOLserver return for the request? I show 404 for AOLserver (2.3 and 3.2), and 400 for Apache. I presume IIS returned a 200 or a 5xx - anyone know for sure? Mike http://www.mikeduffy.com
Re: [AOLSERVER] Oracle driver problem (solved)
It turns out the code to put the clob into the datebase was incorrect
The call was
db_dml update_trans {
update bv_transactions
set transaction = :xml
where transaction_id = :transaction_id
returning transaction into :1
} -clobs [list $xml]
but should be
db_dml update_trans {
update bv_transactions
set transaction = empty_clob()
where transaction_id = :transaction_id
returning transaction into :1
} -clobs [list $xml]
however it's interesting that the incorrect code kills the database instance.
It's also interesting that the first code works until the XML document becomes
larger than 64k
Barry Books wrote:
Hello,
I'm working on an Oracle driver problem and I'm curious if anyone else has
seen it. I'm running the win32 version 2.4 driver with Oracle 8.1.6 on NT
(client and server)
The problem is if I try and update a column with a clob greater that 64k I
get
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
ns_ora clob_dml: binding variable xml
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
ns_ora clob_dml: binding variable transaction_id
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
ns_ora clob_dml: binding variable 1
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4543:unknown:
bind variable 1 is a lob
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:2763:unknown:
entry
[07/May/2001:16:16:29][610.601][-conn0-] Error: SQL():
H:\src\aD\root\oracle-driver\ora8.c:4601:unk
nown: error in `OCIStmtExecute ()': ORA-01480: trailing null missing from
STR bind value
SQL:
update bv_transactions
set transaction = :xml
where transaction_id = :transaction_id
returning transaction into :1
At first I thought I had not set LobBufferSize but the logs contain:
[07/May/2001:16:02:07][610.218][-main-] Notice: modload: loading
'd:/acs/aol32/bin/ora8.dll'
[07/May/2001:16:02:07][610.218][-main-] Notice: ora8 driver LobBufferSize =
50
[07/May/2001:16:02:07][610.218][-main-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:920:unknown: e
ntry (hdriver 00417640, config_path ns/db/driver/ora8)
[07/May/2001:16:02:07][610.218][-main-] Notice: Loaded ArsDigita Oracle
Driver version 2.4, built on
16:05:38/Nov 14 2000
The config section:
ns_section ns/db/driver/ora8
ns_param Debug true
ns_param LobBufferSize 50
All of this would not be so bad but when this happens the Oracle instance
quits without even putting anything in the event log
The dml statement is:
db_dml update_trans {
update bv_transactions
set transaction = :xml
where transaction_id = :transaction_id
returning transaction into :1
} -clobs [list $xml]
Has anyone else seen this?
Thanks
Barry
Re: [AOLSERVER] Retrieving files from form's...
I had this problem on NT. If you remove enctype=multipart/form-data you get the fields but no file. I had to rewrite the file upload code to work on NT. It's currently pretty ugly and slow but it works. I'll post it somewhere if you need it barry - Original Message - From: "Damian Czupryn" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 5:13 AM Subject: Re: [AOLSERVER] Retrieving files from form's... Franclim Flix Bento wrote: Hello, First of all, thank you for your help. But I still have a problem. When I use ns_getform to get the form, I don't have any fields on the set. I think this is because of the "enctype='multipart/form-data'". If I use this enctype in any form, no matter the kind of fields in it, I can't retrieve the content of that form. If I use "ns_conn form" instead, to retrieve a form with an input type='file', I get just one field with a very strange name/value... I wonder if any one could help me solving this problem. Thanks once more. Frank -Original Message- From: AOLserver Discussion [mailto:[EMAIL PROTECTED]]On Behalf Of Tuncay Baskan Sent: quinta-feira, 5 de Abril de 2001 15:59 To: [EMAIL PROTECTED] Subject: Re: [AOLSERVER] Retrieving files from form's... Hi, form enctype='multipart/form-data' method=POST input type=file name=img1 input type=file name=img2 /form When you do a ns_getform in your handler, form set should have the following keys: img1.content-type img1.tmpfile img2.content-type img2.tmpfile You can get them with "ns_set get" command. On 2001.04.05 17:02:50 +0300 Franclim Flix Bento wrote: Hi, I've one doubt (not realy just one but for now :-)... When I want to retrieve a file content posted in a form with more than just one input field of the type "file", what should I do ? Thanks -- Tuncay Baskan. IT Manager @ Paramedya.com Hi, You may use "ns_queryget" instead of "ns_getform": Example: -- set channel_id [open [ns_queryget "img1.tmpfile"]] -- set what_user_has_uploaded [read $channel_id] -- close $channel_id Regards, Damian Czupryn.
