========================================================================= Date: Fri, 1 Nov 1996 14:09:08 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: Re: ns_db instruction problems. Comments: To: Kirk Zurell In-Reply-To: <199610311446.JAA03093@server.uwindsor.ca> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Thu, 31 Oct 1996, Kirk Zurell wrote: > Using AOLserver 2.1/Illustra (3.2?) on Windows NT Server 3.51 SP5. > > Have loaded module nsdb.dll into my virtual server. "Database Services" > appears as /NS/db/admin. Whenever I select any links on that page, the > server reports an error and the log shows any ns_db instruction as > an "invalid instruction". > > I imagine it's just a configuration problem, I'm new to NT Server. Is > there an easy fix, or should I move back to an earlier version of AOLserver? > > Thanks in advance, > Assuming you have the pools set up properly, this is most likely an Illustra installation problem (most likely ELM). I have seen this once before, quite a while back, but only the once. I suspect, this is just a guess, that when you installed Illustra, you were not logged in as the miadmin user, or something else small that could throw ELM off. Anyway, look at illustra for this one. Eric Klein eric@sb.aol.com > Kirk Zurell > Computer Consultant > University of Windsor > Windsor, Ontario, Canada > ========================================================================= Date: Fri, 1 Nov 1996 19:26:08 EST Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: "Allan W. Bart, Jr." Subject: Re: AOLSERVER Digest - 30 Oct 1996 to 31 Oct 1996 Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hello, I would like to hear from those who are running the linux version of this package. allan ------------------------------------- Name: Allan W. Bart, Jr. E-mail: butch@maestro.com Date: 11/1/96 Time: 7:26:08 PM This message was sent by Chameleon ------------------------------------- 11/1/967:26:08 PM ========================================================================= Date: Sat, 2 Nov 1996 16:20:10 +0100 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Willem van den Oord Organization: Academie van Bouwkunst Subject: Views with rownumbers and First characters of text columns MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I'm trying to make views with row numbers in a column so i can select ranges from that view by using that column. for example: select * from countries where row between 10 and 19 This would be a great method for selecting records with a scrollbar function i've made. I have found the following very ineffecient solution: create view countries as select distinct x.country, count(distinct y.country) as row from institutes x, institutes y where y.country < x.country group by x.country Strangly enough, the following is much faster when selecting from the countries view: create view dcountries as select distinct countries from institutes create view countries as select x.country, count(y.country) as row from dcountries x, dcountries y where y.country < x.country group by x.country Why? And do you know a better method for this? I'm trying to make a selection that shows only the first character from columns of type text. With a explicit conversion i get the following message: * select country::char1 from institutes X22001:data exception: string data, right truncation I think i have to use the substring function, but i don't know how to use it. I hope this isn't to much Illustra related. Thanks in Advance, Willem -- /* Willem v/d Oord */ int x,y=0;f(a,b,c)int a,b,c;{int s=(x-a)*(x-a)+(y-b) /* @ahk/ +31 .20 */ *(y-b)*4;return s>c*c&&s<(c+3)*(c+3);}main(){while(y /* .nl/ t: 6220188 */ ++<24){for(x=0;++x<80;)putchar(f(40,12,20)|f(32,9,2) /* __/ f: 6232519 */ |f(48,9,2)|f(40,12,13)&y>12?'*':' ');printf("\n");}} ========================================================================= Date: Mon, 4 Nov 1996 10:45:42 +0100 Reply-To: dormanns@kzs.hu Sender: Web Development with AOLserver and PrimeHost From: Dormanns Marcel Organization: Kossuth Zsuzsanna Tech. Highschool Subject: Virtual servers stopping Several times I read on this list about virtual servers stopping for no apparent reason. Happened to us too a couple of times, so I turned on verbose for our virtual server to find out what's the cause. From the huge amount of data I could conclude the next. - Thread cleanup, scheduled by default every 60 seconds, sometimes skips a few cleanups. This can be as much as 5-10 minutes. Not neccesarily an error, just suspicious. - Cleanup somehow gives up, or doesn't get a chance to run. I could see the number of threads steadily going up to 50 during a couple of hours, without cleanup taking place. As soon as it reaches 50 (the default) you've got a rock-solid server, which means it doesn't move an inch until restarted. Fortunately the setup-server still runs, so I can restart remotely. This morning I increased MaxThreads to 150, hoping this will help or at least delay the lockups. I'm afraid though it's not a permanent solution. I hope someone knows a real solution. Anybody who would like to take a look at the logfile, nsd.ini and access-log at the time of lockup can find them at http://www.kzs.hu/problem/default.htm. I edited out the irrelevant parts, so the largest file is only about 33k to download. Happy problem hunting ! --------------------------------------------------- Marcel Dormanns, system manager Kossuth Zsuzsanna Vocational and Grammar School 6800 Hodmezovasarhely, Kaszap u 29, Hungary Tel. +36-62-341811 Fax +36-62-344884 ========================================================================= Date: Fri, 1 Nov 1996 23:09:02 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: Re: SSL key certification Comments: To: Andre April In-Reply-To: <199610290841.JAA27757@spirou.cediti.be> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I looked at the source for this, and it appears to have been fixed in 2.1, so you might want to look into that. Eric Klein eric@sb.aol.com On Tue, 29 Oct 1996, Andre April wrote: > Andre April said: > > How can I certify the certificate request myself? I got the SSLeay package, > > but it does not recognize the certificate request. > > I found the solution after a few hours... > > The certificate request generated by aolserver is almost in PEM format. It > looks like: > > Webmaster: Andre.April@cediti.be > Phone: +32.71.259404 > Certificate Request generated by AOLserver 2.1/SSL Module v1.3: > Common Name: spirou.cediti.be > Organizational Unit: UCL > Organizational Name: CEDITI > Locality Name: 6041 Gosselies > State Or Province: Hainaut > Country Name: BE > > -----Begin New Certificate Request----- > MIFtMIEbAgEAMIG6MQswCQYDVQQGEwJCRTEQMA4GA1UECBMHSGFpbmF1dDEXMBUG > ... > 8x+Z1XDBNotDF0mzCNCAvGWmJXV7kCKv1bPf2r/Z138= > -----End New Certificate Request----- > > > Howether SSLeay expect something like > > -----BEGIN NEW CERTIFICATE REQUEST----- > MIFtMIEbAgEAMIG6MQswCQYDVQQGEwJCRTEQMA4GA1UECBMHSGFpbmF1dDEXMBUG > ... > 8x+Z1XDBNotDF0mzCNCAvGWmJXV7kCKv1bPf2r/Z138= > -----END NEW CERTIFICATE REQUEST----- > > i.e. in upper case only! Once this is done, you simply have to rename the > certificate request file to "newreq.pem" and execute "CA.sh -sign". The new > certificate will be stored in "newcert.pem". Copy this file to your > aolserver-2.1/servers/"virtual server name" directory and fill the filename > for the KeyFile and CertFile attributes in the ssl module configuration page > for your server. Restart the server... it's done. > > Andre. > > P.S. After installing SSLeay, you have to "initialize" your Certification > Authority. You first have to edit .../ssl/lib/ssleay.conf and then execute > "CA.sh -newca". > > P.P.S. The procedure for Windows NT should be similar (it will probably be > more difficult to compile and install SSLeay). > ========================================================================= Date: Fri, 1 Nov 1996 23:28:11 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: Re: TCL scripts and directory listing. Comments: To: dormanns@kzs.hu In-Reply-To: <1AF04B5F06@anett.kzs.hu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 30 Oct 1996, Dormanns Marcel wrote: > Since a while I'm using AOLserver + Illustra on NT 3.51, and I > encountered some (minor) problems which I could not solve yet. > > - Turning off directory browsing (DirectoryListing=none) inhibits > users from automatically receiving index.htm etc. I don't like users > just browsing around (call it paranoia if you want), but I do want > to send them index.htm or default.htm automatically if they call > plain http://www.kzs.hu. We used MS-IIS previously, and this can send > a default html-document while inhibiting directory listing. Did I > miss some parameter somewhere? Hmm, I'm having no problem with this. If you want, you can send me your nsd.ini and I can look at it, otherwise, there doesn't seem to be a problem with the server. > - I defined a tcl-script which registers itself as > http://www.kzs.hu/guestbook/default.htm , dynamically building a page > from the guestbook database (Illustra) and sending it to the client. > The problem here is that AOLpress somehow doesn't see the default.htm > when I create and use the guestbook miniweb. Pointing my browser to > http://www.kzs.hu/guestbook/ gives me a directory listing instead of > the default.htm. Any other deafult.htm documents work just fine, it's > the tcl-script that somehow differs from a static html-document. > Again, did I miss some setup parameters or are these effects expected > behaviour of AOLserver. Well, since it is a tcl procedure registered, you must call it by it's registered address. You could simply register the tcl script to handle http://www.kzs.hu/guestbook/ A tcl script however will not be defaulted to using the defaulting rules, as it actually looks for a file named index.html (or whatever), and not a script registered there. Happy Hunting Eric Klein eric@sb.aol.com ========================================================================= Date: Fri, 1 Nov 1996 23:16:17 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: Re: AOLServer hanging Comments: To: Valter Quenda In-Reply-To: <326CB83B.6F8F@crf.it> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Well, I've looked into it a bit, but can't find anything so far. If you could tell me what version of the server you are using, and send me a copy of your nsd.ini, it would be a great help. Thanx, Eric Klein eric@sb.aol.com On Tue, 22 Oct 1996, Valter Quenda wrote: > I have AOLserver running on an NT Intel computer;I realize that server hangs, I restart it and, when I > open the server.log to understand what happened, I find lines like these ones: > > [22/Oct/1996:11:28:57 +0100][77.85][-Scheduler-] Warning: crfserver: thread max (50) reached with 5 > connections waiting. > .... > omitted, one new line was written every minute until I restarted the server > .... > [22/Oct/1996:12:17:57 +0100][77.85][-Scheduler-] Warning: crfserver: thread max (50) reached with 43 > connections waiting. > > Why the server hangs in this situation? Is it sufficient to increase the value of MaxThreads variable? > My server is not an high-trafic server, it seems impossible that 50 connections arrived > simultaneously! > > Thanks to in advance for hints > > Valter Quenda (v.quenda@crf.it) > ========================================================================= Date: Sat, 2 Nov 1996 15:32:38 +0100 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Marcel Dormanns Subject: Re: TCL scripts and directory listing. Comments: To: Eric Klein Eric. Thanks for your quick response to my questions. I spent a couple of more hours experimenting with your suggestions and came up with some new (and sometimes unexpected) experiences. > > - Turning off directory browsing (DirectoryListing=none) inhibits > > users from automatically receiving index.htm etc. > > Hmm, I'm having no problem with this. If you want, you can send me your > nsd.ini and I can look at it, otherwise, there doesn't seem to be a > problem with the server. > > > - I defined a tcl-script which registers itself as > > http://www.kzs.hu/guestbook/default.htm , dynamically building a page > > from the guestbook database (Illustra) and sending it to the client. > > The problem here is that AOLpress somehow doesn't see the default.htm > > when I create and use the guestbook miniweb. Pointing my browser to > > http://www.kzs.hu/guestbook/ gives me a directory listing instead of > > the default.htm. Any other deafult.htm documents work just fine, it's > > the tcl-script that somehow differs from a static html-document. > > Well, since it is a tcl procedure registered, you must call it by it's > registered address. You could simply register the tcl script to handle > http://www.kzs.hu/guestbook/ > A tcl script however will not be defaulted to using the defaulting rules, > as it actually looks for a file named index.html (or whatever), and not a > script registered there. Turns out that it makes a difference whether the subdirectory is 'webbized' or not. Turning it into a miniweb using AOLpress and designating a homepage for that miniweb results in AOLserver sending the homepage in answer to an unqualified request, e.g. setting the homepage to default.htm in AOLpress and requesting http://www.kzs.hu/guestbook/ will get you to http://www.kzs.hu/guestbook/default.htm, regardless the setting of DirectoryListing. Delete the document.nvd file and you get the results I experienced (either a dirlisting or a forbidden response). Good to know is also that you must have a physical default.htm for AOLpress to accept this homepage setting, but AOLserver will send you the result of the TCL-script. This means that in case of a script and html-file with equal URL, the script takes precedence (I don't know however how reliable this is, it sure doesn't look healthy). My second question actually needs some clarification. The main problem is that when I webbize that subdirectory, the TCL-based default.htm doesn't show up in miniweb view. Therefore the need for a 'fake' default.htm if I want to designate it as homepage for that miniweb. To me it does seem logical however that this script-based URL should appear, after all it's a valid and existing URL. Applying your suggestion of registering the script as http://www.kzs.hu/guestbook/ results in even more confusion, many links suddenly don't work anymore. E.g. the link to the entry form gbk-sub.htm (which is in the /guestbook subdir) suddenly points to http://www.kzs.hu/gbk-sub.htm instead of http://www.kzs.hu/guestbook/gbk-sub.htm. This doesn't really surprise me. Summarizing, I'll be able to trick AOLserver by creating a fake default.htm but I'm not convinced this is the right way to handle. For AOLpress + AOLserver to treat script-based URLs and file-based URLs equally does sound to me as expected behaviour. Still doesn't solve the refusal of sending default.htm in case of an absent document.nvd and DirectoryListing=none however. The URLs I used here actually exist and function (I hope), so if you want to try just go ahead. At the moment I have directory browsing enabled and defined DirectoryFile=default.htm. Go to http://www.kzs.hu/guestbook/ and you'll get a directory listing. Go to http://www.kzs.hu/guestbook/default.htm and you'll get want I want the users to receive, our guestbook. I guess I gave some food for experimenting. Sorry for the long quote of the original message, I saw it as the only way to keep all info together. Marcel Dormanns. ========================================================================= Date: Mon, 4 Nov 1996 12:59:00 PST Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: JamesX Blakeman Subject: SELECTing from SQL Server 6.5 tables Hello, (I just subscribed to this list, so if this question is already covered in a FAQ, just let me know) I just installed AOLserver on NT4.0, and I'm trying to select from tables that have been set up in a SQL Server 6.5 db. AOL Server finds the tables, but when it tries to do an SQL select, I get the log text shown below. (Note: the last line has the error message: Invalid object name 'table_name')...even though the table exists (it showed up in AOL server's list!). I am able to select rows from tables that I have created with AOLserver's interface, but I can't select from tables that have been created directly in SQL server. - Has anyone encountered this problem? - Could this be because I'm using NT4.0 (ie. is it unsupported)? - Could this be related to the "Extended Table Info" setting on my database pool (I have to turn it off to avoid crashes)? Thanks for your help. -James jblakemx@ichips.intel.com >>>>> LOG TEXT >>>>> Notice: Ns_DbOpenDb(odbc): Opening datasource: newcvdb Notice: SQLConnect(newcvdb, webuser, password) Warning: ODBC message: SQLSTATE = 01000, Native err = 5701, msg = '[...][SQL Server]Changed database context to 'master'.' Warning: ODBC message: SQLSTATE = 01000, Native err = 5703, msg = '[...][SQL Server]Changed language setting to 'us_english'.' Warning: ODBC message: SQLSTATE = 01000, Native err = 5701, msg = '[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'cvweb'.' Warning: ODBC message: SQLSTATE = 01000, Native err = 5703, msg = '[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to 'us_english'.' Notice: SQL(newcvdb): select PLATFORM_ID, DESCP, STATION_ID, DATE_ENTERED, COMENT, ACTIVE from CVIS_PLATFORM where PLATFORM_ID like '%19%' Error: ODBC message: SQLSTATE = S0002, Native err = 208, msg = '[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'CVIS_PLATFORM'.' ========================================================================= Date: Tue, 5 Nov 1996 08:28:10 -0600 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Ashish Parikh Subject: Page dependant trailer text? Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Hello, Is it possible to disable the Trailer text for all but a few pages? Thanks, Ashish ========================================================================= Date: Tue, 5 Nov 1996 11:54:59 -0500 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Barlow Subject: Virtual server renameing Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Greetings: How do I rename a Virtual server after it has been created? I cannot find any referance to this in the manual other then deleting the server and creating a new one which I dont care to do at this time. I presume there is a simple way to rename buried somewheres Thanks again Kerry Soon to be..Barlow&Barlow computers Servers for you. http://204.181.7.192 barlow@servtech.com ========================================================================= Date: Tue, 5 Nov 1996 11:23:48 -0500 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Barlow Subject: bandwidth monitors Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Greetings all: Can anyone recommend a monitor for bandwidth/transfer rate, used by customers? I can use the access logs and manually add transfers, but this is a pain of course I want to have a system whereby I can verify how much bandwidth a particular customer is useing and thereby charge them extra for high useage Thanks again Kerry Kerry Soon to be..Barlow&Barlow computers Servers for you. http://204.181.7.192 barlow@servtech.com ========================================================================= Date: Tue, 5 Nov 1996 10:02:08 -0500 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: "Stephen A. Mattin" Subject: Re: Virtual servers stopping Comments: To: Dormanns Marcel Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Although my server configuration is quite different, I had very similar behavior to what you report, with virtual servers spawning large numbers of threads, then hanging. I also noted that the thread cleanup did not seem to be effective. Increasing MaxThreads did not help. I believe the cause is reverse domain name lookups from the "nslog" module. Disabling this "feature" in "nsd.ini": [ns/server/server1/module/nslog] EnableHostnameLookup=Off seemed to eliminate these problems for me. The problem is that failure to successfully resolve IP addresses to DNS names is very common and takes a long time, hanging the thread. Maybe the server could cache the failed addresses and not retry, but I think the general solution is to never enable this feature (in any Web server). The log file analysis software I use "wusage", does the name lookup offline for reporting purposes at off-peak (dead of night) hours. -- Stephen A. Mattin stephen@MediLife.COM ========================================================================= Date: Wed, 6 Nov 1996 10:10:53 -0500 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Marvin Allen Wolfthal Subject: Re: AOLSERVER Digest - 4 Nov 1996 to 5 Nov 1996 In-Reply-To: <199611060502.AAA16553@services.web.aol.com> Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII > Date: Tue, 5 Nov 1996 11:54:59 -0500 > From: Barlow > Subject: Virtual server renameing > > Greetings: How do I rename a Virtual server after it has been created? > I cannot find any referance to this in the manual other then deleting the > server and creating a new one which I dont care to do at this time. > I presume there is a simple way to rename buried somewheres > Thanks again > Kerry Assume you want to change "oldserver" to "newserver" Depending on whether or not you've done any customization, it could be as simple as: 1) stop the server 2) backup the current nsd.ini in the root directory of your aolserver installation 3) edit nsd.ini changing the section headings from, e.g. [ns/server/oldserver] to [ns/server/newserver] wherever relevant. If you've done some customization it may be more work... 4) restart the server Marvin Marvin Allen Wolfthal (maw@fsg.com) Technical Director Fusion Systems Group, Inc. 10 Winthrop Square, Boston, MA 02110 (617) 542-6130 Fax: 542-6248 ========================================================================= Date: Tue, 5 Nov 1996 18:38:50 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Alex Khassin Subject: Re: Virtual server renameing In-Reply-To: <1.5.4.32.19961105165459.002ca6c4@pop.servtech.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_06tW51g.bO1996u.N02d000A.r11Y.38:005574" Content-Transfer-Encoding: 7bit --=_06tW51g.bO1996u.N02d000A.r11Y.38:005574 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit On Tue, 5 Nov 1996 08:54:59 -0800 Barlow wrote: >Greetings: How do I rename a Virtual server after it has been created? Simply rename the v.server directory under \servers and replace all occurrences of with the in nsd.ini. --=_06tW51g.bO1996u.N02d000A.r11Y.38:005574 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="alexsig.txt" Content-Description: The Sender's Signature -- ---------------------------------------------------------------- Alex Khassin AM Computers mailto:akhassin@am.net 1040-B N. Dutton Ave Voice: (800) 579-2018 Santa Rosa, CA 95401 (707) 579-2010 http://am.net ---------------------------------------------------------------- The Source for Advanced Computing Solutions ---------------------------------------------------------------- am.net = The Best Hosting Service with integrated database, secure transactions, real-time credit card processing and more ---------------------------------------------------------------- --=_06tW51g.bO1996u.N02d000A.r11Y.38:005574-- ========================================================================= Date: Tue, 5 Nov 1996 23:25:27 +0100 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Stefan Arentz Organization: Luna Internet Subject: Re: Virtual server renameing In-Reply-To: <1.5.4.32.19961105165459.002ca6c4@pop.servtech.com>; from Barlow on Nov 5, 1996 11:54:59 -0500 Mime-Version: 1.0 I simply did a global search & replace in the nsd.ini file and then changed the directory name in the servers directory. Seems to work fine. - Stefan Barlow writes: > Greetings: How do I rename a Virtual server after it has been created? > I cannot find any referance to this in the manual other then deleting the > server and creating a new one which I dont care to do at this time. > I presume there is a simple way to rename buried somewheres > Thanks again > Kerry > Soon to be..Barlow&Barlow computers > Servers for you. > http://204.181.7.192 > barlow@servtech.com -- Stefan Arentz - Technical Director - Luna Internet stefan.arentz@luna.net / +31 (0)10 4656232 To err is human, to forgive is Not Company Policy. ========================================================================= Date: Wed, 6 Nov 1996 16:35:00 -0700 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Ron Patterson Subject: Re: Virtual servers stopping We are still having the problem of the nsd process halting with signal 13. We also turned off all reverse name lookups but we are continuing with the same problem at differing frequencies. It would seem that the AOLserver should be trapping ALL spurious signals and performing an appropriate restart action. We are running fully patched Solaris 2.4 on a SPARCserver. I now have the following script running as root under from cron every minute to check the status of the nsd processes and restart it if necessary. #!/usr/bin/ksh # script to check running of the AOLserver process # by Ron Patterson, MCI ps -ef | grep nsd 2>/dev/null >/tmp/nsd.$$ lcount=`wc -l /tmp/nsd.$$ | awk '{print $1}'` if [ $lcount -lt 3 ] then /pub/AOLserver/bin/nsd -c /pub/AOLserver/nsd.ini echo `date` - Restarted nsd fi rm /tmp/nsd.$$ >/dev/null This has generated the following results so far: Fri Nov 1 09:59:01 MST 1996 - Restarted nsd Sat Nov 2 23:28:01 MST 1996 - Restarted nsd Mon Nov 4 09:56:01 MST 1996 - Restarted nsd Tue Nov 5 09:12:01 MST 1996 - Restarted nsd Tue Nov 5 13:34:02 MST 1996 - Restarted nsd Tue Nov 5 13:38:01 MST 1996 - Restarted nsd Tue Nov 5 13:46:01 MST 1996 - Restarted nsd Wed Nov 6 10:17:01 MST 1996 - Restarted nsd Any other hints from the AOL folks? Regards, Ron ------------------------------ Date: Tue, 5 Nov 1996 10:02:08 -0500 From: "Stephen A. Mattin" Subject: Re: Virtual servers stopping Although my server configuration is quite different, I had very similar behavior to what you report, with virtual servers spawning large numbers of threads, then hanging. I also noted that the thread cleanup did not seem to be effective. Increasing MaxThreads did not help. I believe the cause is reverse domain name lookups from the "nslog" module. Disabling this "feature" in "nsd.ini": [ns/server/server1/module/nslog] EnableHostnameLookup=Off seemed to eliminate these problems for me. The problem is that failure to successfully resolve IP addresses to DNS names is very common and takes a long time, hanging the thread. Maybe the server could cache the failed addresses and not retry, but I think the general solution is to never enable this feature (in any Web server). The log file analysis software I use "wusage", does the name lookup offline for reporting purposes at off-peak (dead of night) hours. -- Stephen A. Mattin stephen@MediLife.COM ========================================================================= Date: Wed, 6 Nov 1996 17:33:33 -0500 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Jim Davidson Subject: Re: Virtual servers stopping Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 10:02 AM 11/5/96 -0500, Stephen A. Mattin wrote: >Although my server configuration is quite different, I had very similar >behavior to what you report, with virtual servers spawning large numbers >of threads, then hanging. I also noted that the thread cleanup did not >seem to be effective. Increasing MaxThreads did not help. > >I believe the cause is reverse domain name lookups from the "nslog" module. >Disabling this "feature" in "nsd.ini": > >[ns/server/server1/module/nslog] >EnableHostnameLookup=Off > >seemed to eliminate these problems for me. The problem is that failure to >successfully resolve IP addresses to DNS names is very common and takes a >long time, hanging the thread. Maybe the server could cache the failed >addresses and not retry, but I think the general solution is to never enable >this feature (in any Web server). Actually, the server does cache IP addresses resolved or failed to resolve but, as you've seen, it's not always enough. Basically, you shouldn't enable hostname lookup unless you know your site can only be accessed by hosts which can easily be resolved (e.g., you use it on an Intranet). It's off by default. -Jim _______________________ Jim Davidson jimbo@sb.aol.com Voice: (805) 882-2350 Fax: (805) 899-4316 ========================================================================= Date: Wed, 6 Nov 1996 17:57:48 -0400 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: James F Smallacombe Subject: Re: Virtual servers stopping Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" > >Date: Tue, 5 Nov 1996 10:02:08 -0500 >From: "Stephen A. Mattin" >Subject: Re: Virtual servers stopping > >Although my server configuration is quite different, I had very similar >behavior to what you report, with virtual servers spawning large numbers >of threads, then hanging. I also noted that the thread cleanup did not >seem to be effective. Increasing MaxThreads did not help. > >I believe the cause is reverse domain name lookups from the "nslog" module. >Disabling this "feature" in "nsd.ini": > >[ns/server/server1/module/nslog] >EnableHostnameLookup=Off > Some of the virtual servers that were stopping did not have hostnamelookup enabled in the nslog module. Today, I took Ray Davis's advice and also disabled hostnamelookup in the NSperm module. Only time will tell if this works. James Smallacombe Bucks County, PA Internet Access james@pil.net http://www.pil.net PlantageNet Internet Ltd. http://www.plantagenet.com "Get thee glass eyes, and like a scurvy politician, seem to see things thou dost not" - King Lear, IV.vi ========================================================================= Date: Wed, 6 Nov 1996 17:47:11 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Doug McKee Subject: Re: ns_db instruction problems. In-Reply-To: (message from Eric Klein on Fri, 1 Nov 1996 14:09:08 -0800) On Thu, 31 Oct 1996, Kirk Zurell wrote: > Have loaded module nsdb.dll into my virtual server. "Database Services" > appears as /NS/db/admin. Whenever I select any links on that page, the > server reports an error and the log shows any ns_db instruction as > an "invalid instruction". > > I imagine it's just a configuration problem, I'm new to NT Server. Is > there an easy fix, or should I move back to an earlier version of AOLserver? Oh boy, this is a bad one, and I've noticed a few people report it. Luckily, it's easy to fix: 0. Define at least one database pool (see the online documentation) 1. Goto the Setup server 2. Goto Setup Virtual Servers 3. Press the -> arrow to the left of your virtual server to "open it up" 4. Follow the link to Database Services 5. Press the Update button 6. Restart the server The 2.1 version of AOLserver won't initialize database services (e.g., add the ns_db Tcl command) unless the [ns/server/server1/db] exists in the nsd.ini file and sets the Pools parameter. doug -- ------------------------------------------------------------------- Doug McKee, Lead Engineer for Web Commerce & AOLserver Applications Email: doug@sb.aol.com America Online, Inc. Voice: (800) 529-9166 511 Bath Street (805) 882-2350 Santa Barbara, CA Fax: (805) 899-4316 93101 ------------------------------------------------------------------- ========================================================================= Date: Thu, 7 Nov 1996 09:44:38 -0500 Reply-To: max_batista@hp.com Sender: Web Development with AOLserver and PrimeHost From: Max Batista Subject: Fresh server install/user database restore Comments: cc: mjc@r3125sv2.atl.hp.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit We are in the process of reconfiguring our NT 3.51 Server operating system where our AOLServer is currently running. We would like to know the best way to re-install AOLServer after the reconfiguration of NT 3.51 Server OS. Should we install AOLServer first and then restore our datafiles? Should we retore our datafiles and then install AOLServer? In what order should the software be loaded/restored onto the server? Any assistance that you can provide with this matter would be greatly appreciated. Thank you, Max Batista ========================================================================= Date: Thu, 7 Nov 1996 17:03:00 PST Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: "Lustig, Rob ITT/FSC" Subject: Re: Virtual servers stopping >Date: Wed, 6 Nov 1996 17:33:33 -0500 >From: Jim Davidson >Subject: Re: Virtual servers stopping > >At 10:02 AM 11/5/96 -0500, Stephen A. Mattin wrote: ... >>I believe the cause is reverse domain name lookups from the "nslog" module. >>Disabling this "feature" in "nsd.ini": >> >>[ns/server/server1/module/nslog] >>EnableHostnameLookup=Off >Actually, the server does cache IP addresses resolved or failed to resolve >but, as you've seen, it's not always enough. Basically, you shouldn't >enable hostname lookup unless you know your site can only be accessed by >hosts which can easily be resolved (e.g., you use it on an Intranet). It's >off by default. Jim, I wonder how much gain this gives me: Does it do two lookups - one for NSLog and one for NSPerm? Shouldn't it already be in the cache for the second lookup? Does the setting in the NSPerm area only do lookups for those pages that have permissions listed by "Hosts to allow / deny"? Will it record this information in the log? Several sections are limited by the domain and I wonder if this will give me a performance gain? Will it cause me more headaches if I am linked to an SQL database? Regards, Rob Lustig - Network Engineer in Space and Missile Country: VAFB SMTP: LUSTIG@FSC.VAFB.AF.MIL or LustigR@FSC-PLANS.VAFB.AF.MIL (805) 734-8232 ext. 5-0473 Building:7015 3rd flr. dept:AP220 Vandenberg AFB, Ca 93437-5321 http://WWW.30SW.VAFB.AF.MIL/HOMEPAGE.HTM ========================================================================= Date: Fri, 8 Nov 1996 10:05:10 -0500 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Mark Nielsen Subject: Linux, AOLserver 2.1 and scripting problems MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello! I am having a bunch of scripting problems with AOLserver 2.1 installed on Linux. I am using RedHat 4.0 using kernel 2.0. I keep on getting the following errors on perl scripts. The perl scripts run fine manually. They also run fine on a apache server on a different port. [08/Nov/1996:09:16:09 -0500][8813.8820][server1] Error: Error waiting for exit of CGI /users/web/bin/news/GLN2: Illegal seek I have no idea what this means. It is like it finds the file, but then it decides something is wrong. I couldn't find a list of error descriptions in the manual for the CGI devleopers guide or the administrators guide. I tried defining the "environment" and "interps" variables, but even so, without defining "environment", "interps", it should still be possible to make a directory executible with the following command. GET /cgi-news /usr/local/bin/news POST /cgi-news /usr/local/bin/news so that any script in there is executible. Has someone actually gotten the scripts to work under Linux? I imagine they have. Thanks for any help!!!! Mark ========================================================================= Date: Mon, 11 Nov 1996 14:46:25 -0500 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Michael Kmiec Subject: Strange Happenings with 2.1 on UNIX Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Hello, Here's another chapter in my "I'm trying to work with AOLServer 2.1" saga. When the process is started with the decidedly average: bin/nsd -c INIS/ini.file (Well, average aside from the fact that I give my .inis different names in order to experiment.) After the process is polled with a ps -aef | grep nsd, I get: root 6647 1 12 12:26:15 ? 0:00 bin/nsd -c INIS/ini.file -i nsadmin 6648 6647 80 12:26:15 ? 0:07 bin/nsd -c INIS/ini.file -i -b5 The three things puzzling me: 1) Why two processes? The docs claim a separate "database daemon" that handles the web server/db server interaction, but I thought that had been shut off by removing the "ext" driver for the db and instead using the "normal" nsill.so. Is AOLServer doing something else like a separate thread manager or something? Hm. 2) What's going on with the extra flags? Docs claim that the -i is to run from inittab, and the -b is for the highly secretive "Internal Use Only" functions. Odd that I am getting them, considering I'm not specifying the former, and what's going on with my internals is my business.(Kidding...debug flag perhaps?) 3) Finally, the process was kicked off by a user as root...in earlier versions (Navi/GNN) when a server started as root, the process would "change hands" so that nsadmin would become the owner. This appears to be the case with pid #6648, but why should the parent pid remain with root? Thanks for any help I can get on this... Mike ------------------------------------------------------ Michael Kmiec PFN Incorporated 26 Landsdowne Street Cambridge, MA 02139 mike@pfn.com 617.494.9980 ========================================================================= Date: Mon, 11 Nov 1996 22:00:29 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Tom Kee Subject: Re: Linux, AOLserver 2.1 and scripting problems Comments: cc: men@AUTO.MED.OHIO-STATE.EDU Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" To catch up you up on the subject I have included a response to my posting from Jim Davidson about the same problem. I have since converted my script to TCL. I am using Slackware 96 2.0 kernel and have heard that RedHat RedHat 3.0.3, if I recall, works properly. I recently discovered ns_sendmail was not functioning properly and resorted to the following substitution for that function. ..... # This line did not work either # set fp [open "|/usr/sbin/sendmail $to" w] set name [ns_tmpnam] set fp [open $name w] puts $fp "From: $from" puts $fp "Subject: $subject" puts $fp $msg close $fp exec /usr/sbin/sendmail root <$name ..... Database functionality works great through the db proxy drivers and most other functions I have used work. I'm interested in how things turn out for you. Tom Kee -- Jim Davidson wrote .... The error message indicates that the CGI program died from signal 13 which is SIGPIPE. This means the process tried to read from a pipe with no writers or write to a pipe with no readers which shouldn't happen unless your CGI does something weird. Specifically, stdout is a pipe to the AOLserver and stderr is duped to the server.log. For stdin, on a POST it's a temp file with the content and on a GET it's duped from an fd which is always open on /dev/null (the same fd, in fact, which was giving you trouble being opened at startup before, right?). You can force stdin to be an empty file instead by enabling Debug mode, i.e.: [ns\server\server1\cgi] debug=1 In this case the server will create an empty file for input and will copy any output to another file (the files will be something like /usr/tmp/cgiInNNN and /usr/tmp/cgiOutNNN). If this stops the problem than there must be something still weird with /dev/null on your system. At 10:05 AM 11/8/96 -0500, Mark Nielsen wrote: >Hello! > >I am having a bunch of scripting problems with AOLserver 2.1 installed on >Linux. I am using RedHat 4.0 using kernel 2.0. I keep on getting the >following errors on perl scripts. The perl scripts run fine manually. >They also run fine on a apache server on a different port. > >[08/Nov/1996:09:16:09 -0500][8813.8820][server1] Error: Error waiting for >exit of CGI /users/web/bin/news/GLN2: Illegal seek > >I have no idea what this means. It is like it finds the file, but then it >decides something is wrong. I couldn't find a list of error descriptions >in the manual for the CGI devleopers guide or the administrators guide. > >I tried defining the "environment" and "interps" variables, but even so, >without defining "environment", "interps", it should still be possible >to make a directory executible with the following command. > >GET /cgi-news /usr/local/bin/news >POST /cgi-news /usr/local/bin/news > >so that any script in there is executible. > >Has someone actually gotten the scripts to work under Linux? >I imagine they have. > >Thanks for any help!!!! > >Mark > > ========================================================================= Date: Tue, 12 Nov 1996 11:57:44 +0100 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Valter Quenda Subject: Illustra Installation MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit Hi everybody I need to install Illustra on an NT server 3.51 (service pack 4) computer. The file system type is NTFS. Will the Illustra that comes with AOLserver work on this file system? I've read in the installation instructions that there could be problems, but I still hope... Thank for hints and suggestions, bye Valter Quenda (v.quenda@crf.it) ========================================================================= Date: Tue, 12 Nov 1996 14:35:09 -0500 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: "PGG Graphics, Inc" Subject: Re: AOLSERVER Digest - 8 Nov 1996 to 11 Nov 1996 I don't know if this or the hosting group is the right one, but awhile ago I asked about the dynamic creation and expiration of user ID's. I wondered if this 'membership' option had been implemented by anyone? We use TABS/WEB900 and some perl scripts, but their automated membership system won't work with the AOLServer layout. There should be a way to allow a user to enter a code, get a permission to set up an ID, create that ID, and have the ID expire at a certain time (perhaps a daily maint program looks at all the active ID's, and if their expire date is due, drops them to either 'public' or someother access level, or expunges them). Conceptually, I can see how this would be done, the database would make it fairly easy to keep track of, but I don't know enough about TCL or security problems to even begin to implement this. But, until there is some way to allow and track memberships on a server, they are severly limited in what they can do, and in the revenue they can generate. The 'storefront' is a good step, but adding a Membership option to that would be the next step. PGG Graphics, Inc. ========================================================================= Date: Tue, 12 Nov 1996 21:09:31 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: Re: SSL key certification Comments: To: Andre April In-Reply-To: <199611041122.MAA29713@spirou.cediti.be> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Mon, 4 Nov 1996, Andre April wrote: > eric@navisoft.com said: > > I looked at the source for this, and it appears to have been fixed in > > 2.1, so you might want to look into that. > > It is not fixed in 2.1. modules/tcl/nsssl/certs.tcl line 152 contains: > > set pem [osi_pem put "New Certificate Request" $req] > > in place of ...NEW CERTIFICATE REQUEST... Sorry about that, I was looking at the wrong thing. I have fixed the bug on this end, and it will be included in the next release. * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Tue, 12 Nov 1996 21:20:32 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: CGI problems on NT MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII >From: Bruce Hart > >We have Webspirs V3b5 for NT3.51 + sp4 running on Netscape Enterprise server >with no problems. > >We want to change it over to AOLServer so that we can do some >Illustra stuff on the same machine. > >When we try to run Webspirs (/cgi-bin/webspirs.cmd) under AOLServer it >says 'gateway error: can't make form pipe' ie the spawned process >can,t communicate with the parent process. > >The executables work OK in a command prompt > >cgi settings are GET /cgi-bin c:\aolserver\servers\cgi-bin > POST /cgi-bin c:\aolserevr\servers\cgi-bin > >It's like the program can't run (or at least communicate when run) as >a cgi but is OK with Netscape. > >System permissions are OK > >Have we missed something in the cgi setup ? > >Any ideas ? > I just noticed something that may also be part of your problem: You must have an interps section to run something that is not inherantly executable. So for your .cmd file you would need: [NS/Interps/name] .cmd=program-to-run That may also be something to look at. * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Tue, 12 Nov 1996 22:19:06 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: Re: Fresh server install/user database restore Comments: To: Max Batista Comments: cc: mjc@r3125sv2.atl.hp.com In-Reply-To: <3281F5D6.BAA@hp.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Thu, 7 Nov 1996, Max Batista wrote: > We are in the process of reconfiguring our NT 3.51 Server operating > system where our AOLServer is currently running. We would like to know > the best way to re-install AOLServer after the reconfiguration of NT > 3.51 Server OS. [snip] > In what order should the software be loaded/restored onto the server? Well, it generally doesn't matter, but I would install the server first, and then restore the data files. * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Tue, 12 Nov 1996 19:58:19 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: Re: TCL scripts and directory listing. Comments: To: Marcel Dormanns In-Reply-To: <4DF3FF6715@anett.kzs.hu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Sat, 2 Nov 1996, Marcel Dormanns wrote: > Turns out that it makes a difference whether the subdirectory is 'webbized' > or not. Turning it into a miniweb using AOLpress and designating a homepage > for that miniweb results in AOLserver sending the homepage in answer to an > unqualified request, e.g. setting the homepage to default.htm in AOLpress > and requesting http://www.kzs.hu/guestbook/ will get you to > http://www.kzs.hu/guestbook/default.htm, regardless the setting of > DirectoryListing. Delete the document.nvd file and you get the results I > experienced (either a dirlisting or a forbidden response). Good to know is > also that you must have a physical default.htm for AOLpress to accept this > homepage setting, but AOLserver will send you the result of the TCL-script. > This means that in case of a script and html-file with equal URL, the > script takes precedence (I don't know however how reliable this is, it sure > doesn't look healthy). Ahh. This makes far more sense. What is happening is that aolpress is grabbing the .nvd file, and that file tells press to get a file called default.htm, because that file is set as the homepage. What then happens is that since the script takes precedence over the actual page, the script is retrieved instead of the page. > My second question actually needs some clarification. The main problem is > that when I webbize that subdirectory, the TCL-based default.htm doesn't > show up in miniweb view. Therefore the need for a 'fake' default.htm if I > want to designate it as homepage for that miniweb. To me it does seem > logical however that this script-based URL should appear, after all it's a > valid and existing URL. Applying your suggestion of registering the script > as http://www.kzs.hu/guestbook/ results in even more confusion, many links > suddenly don't work anymore. E.g. the link to the entry form gbk-sub.htm > (which is in the /guestbook subdir) suddenly points to > http://www.kzs.hu/gbk-sub.htm instead of > http://www.kzs.hu/guestbook/gbk-sub.htm. This doesn't really surprise me. Once again, this makes sense in light of what is happening. I would strongly suggest thatyou make use of absolute URLs in the case of gbk-sub.htm, otherwise the solution can be more involved, because the server has the base set to the pageroot for a script registered at http://www.kzs.hu/guestbook/ Unfortunately, at the current time, there is no functionality in AOLpress to show Tcl scripts registered within a miniweb's area. I will however send a note on to the AOLpress developers about it. Anyway, I hope that all clears things up a bit. Eric Klein eric@sb.aol.com ========================================================================= Date: Tue, 12 Nov 1996 22:14:02 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: Re: Virtual server renameing Comments: To: Barlow In-Reply-To: <1.5.4.32.19961105165459.002ca6c4@pop.servtech.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 5 Nov 1996, Barlow wrote: > Greetings: How do I rename a Virtual server after it has been created? > I cannot find any referance to this in the manual other then deleting the > server and creating a new one which I dont care to do at this time. > I presume there is a simple way to rename buried somewheres > Thanks again It's pretty straightforward. Simply replace all occurances of the name of the old server in the nsd.ini file with the name of the new server. It's that simple. * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Wed, 13 Nov 1996 10:40:16 +0100 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Gaute Amundsen Subject: Re: Illustra DB Stale? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 13:18 17.09.96 -0400, you wrote: >Today I got this error on my 2.1b8 server. The TCL error is my fault, but >it failed because of the Illustra Stale DB error. What does Stale DB mean? >Thanks. > >Jim Did you ever get an explanation for that? I have the same message in my log, but it has not caused me any problems that I know of. gaute ========================================================================= Date: Wed, 13 Nov 1996 13:20:00 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Doug McKee Subject: Re: Strange Happenings with 2.1 on UNIX In-Reply-To: <2.2.32.19961111194625.006aab14@sunrah.pfn.com> (message from Michael Kmiec on Mon, 11 Nov 1996 14:46:25 -0500) >>>>> "Mike" == Michael Kmiec writes: Mike> Hello, Here's another chapter in my "I'm trying to work with Mike> AOLServer 2.1" saga. Mike> When the process is started with the decidedly average: Mike> bin/nsd -c INIS/ini.file Mike> (Well, average aside from the fact that I give my .inis Mike> different names in order to experiment.) Mike> After the process is polled with a ps -aef | grep nsd, I get: Mike> root 6647 1 12 12:26:15 ? 0:00 bin/nsd -c INIS/ini.file -i Mike> nsadmin 6648 6647 80 12:26:15 ? 0:07 bin/nsd -c INIS/ini.file -i -b5 Mike> The three things puzzling me: Mike> 1) Why two processes? The docs claim a separate "database Mike> daemon" that handles the web server/db server interaction, Mike> but I thought that had been shut off by removing the "ext" Mike> driver for the db and instead using the "normal" Mike> nsill.so. Is AOLServer doing something else like a separate Mike> thread manager or something? Hm. The process owned by root exists solely for restarting the server and needs be owned by root so that it can re-acquire any priviledged ports. Having this separate process lets you restart the server through the Setup Server instead of having to be at the console or telnet into it. Mike> 2) What's going on with the extra flags? Docs claim that the Mike> -i is to run from inittab, and the -b is for the highly Mike> secretive "Internal Use Only" functions. Odd that I am Mike> getting them, considering I'm not specifying the former, and Mike> what's going on with my internals is my Mike> business.(Kidding...debug flag perhaps?) The -b flag is used by the root-owned process so it knows where its going to get restart messages. I don't have an answer for the -i flags; they may be a extraneous remnant of a previous version. Mike> 3) Finally, the process was kicked off by a user as Mike> root...in earlier versions (Navi/GNN) when a server started Mike> as root, the process would "change hands" so that nsadmin Mike> would become the owner. This appears to be the case with pid Mike> #6648, but why should the parent pid remain with root? See answer to #1. Mike> Thanks for any help I can get on this... Hope this helps clear things up! doug ========================================================================= Date: Wed, 13 Nov 1996 09:32:11 -0500 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Alex Finkel Subject: Re: AOLSERVER Digest - 11 Nov 1996 to 12 Nov 1996 Comments: cc: Valter Quenda Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >------------------------------ >Date: Tue, 12 Nov 1996 11:57:44 +0100 >From: Valter Quenda >Subject: Illustra Installation > >Hi everybody > >I need to install Illustra on an NT server 3.51 (service pack 4) >computer. >The file system type is NTFS. >Will the Illustra that comes with AOLserver work on this file system? >I've read in the installation instructions that there could be problems, >but I still hope... It is recommended that you install Illustra on an NTFS partition under Windows NT. There were problems running Illustra on NT without Service Pack 4, and supposedly Illustra runs better on NT Workstation than on NT Advanced Server. If you can, avoid using FAT altogether. NTFS is more efficient and is more robust than FAT. Also, NT Service Pack 5 is now available on Microsoft's site, but I haven't tried it. Has anyone installed Service Pack 5? Any problems? - Alex -- Alex Finkel | 26 Landsdowne St. | Macintosh, Jr. Network Manager | University Park at MIT | PFN, Incorporated | Cambridge, MA 02139 | The power to crush afinkel@pfn.com | http://www.pfn.com/ | the other kids. ========================================================================= Date: Tue, 12 Nov 1996 23:10:54 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Eric Klein Subject: Re: Linux, AOLserver 2.1 and scripting problems Comments: To: Mark Nielsen In-Reply-To: <199611081505.KAA10269@auto.med.ohio-state.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Fri, 8 Nov 1996, Mark Nielsen wrote: > Hello! > > I am having a bunch of scripting problems with AOLserver 2.1 installed on > Linux. I am using RedHat 4.0 using kernel 2.0. I keep on getting the > following errors on perl scripts. The perl scripts run fine manually. > They also run fine on a apache server on a different port. > > [08/Nov/1996:09:16:09 -0500][8813.8820][server1] Error: Error waiting for > exit of CGI /users/web/bin/news/GLN2: Illegal seek Well, I can't find much right now, but if you could turn on the debug mode by setting Debug=On in [NS/Parameters] and send in the part of the log surrounding the error, it would help greatly. Thanx * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Wed, 13 Nov 1996 13:31:56 -0800 Reply-To: Web Development with AOLserver and PrimeHost Sender: Web Development with AOLserver and PrimeHost From: Doug McKee Subject: Re: AOLSERVER Digest - 8 Nov 1996 to 11 Nov 1996 In-Reply-To: <961112143508_348640121@emout13.mail.aol.com> (GirliPix@aol.com) >>>>> "PGG" == PGG Graphics, Inc writes: PGG> I don't know if this or the hosting group is the right one, PGG> but awhile ago I asked about the dynamic creation and PGG> expiration of user ID's. I wondered if this 'membership' PGG> option had been implemented by anyone? PGG> We use TABS/WEB900 and some perl scripts, but their automated PGG> membership system won't work with the AOLServer layout. PGG> There should be a way to allow a user to enter a code, get a PGG> permission to set up an ID, create that ID, and have the ID PGG> expire at a certain time (perhaps a daily maint program looks PGG> at all the active ID's, and if their expire date is due, PGG> drops them to either 'public' or someother access level, or PGG> expunges them). PGG> Conceptually, I can see how this would be done, the database PGG> would make it fairly easy to keep track of, but I don't know PGG> enough about TCL or security problems to even begin to PGG> implement this. PGG> But, until there is some way to allow and track memberships PGG> on a server, they are severly limited in what they can do, PGG> and in the revenue they can generate. PGG> The 'storefront' is a good step, but adding a Membership PGG> option to that would be the next step. We are in fact planning on extending Storefront with something similar to what you're describing. It will allow shoppers to login (or "autologin") upon entry entry to the site. The Storefront will then be able to hand out personalized pages, do session tracking, and fill in default billing/shipping information. At least some of this functionality will be available outside the Storefront, probably through Server-side includes. We'll be using this customer login facility to implement selling of "soft goods" (e.g., recipes, news articles, multimedia). We are considering using it to implement "subscription services" as well that would either time-out users when their subscription expired, or bill the user for another week/month/year. doug -- ------------------------------------------------------------------- Doug McKee, Lead Engineer for Web Commerce & AOLserver Applications Email: doug@sb.aol.com America Online, Inc. Voice: (800) 529-9166 511 Bath Street (805) 882-2350 Santa Barbara, CA Fax: (805) 899-4316 93101 ------------------------------------------------------------------- ========================================================================= Date: Wed, 13 Nov 1996 22:08:33 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Brian Bassett Organization: The Demented Writers of the Internet Subject: nsperm: How to add users? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" I'm trying to set up AOLserver on an NT box and I need to create user accounts so that everyone here in my department can publish pages. (We use Netscape Navigator 3.0 Gold) Anyway, I can't find where to add users. I've read the manual and it is absolutely no help. Can anyone help me? Or at least point me in the right direction? Brian +----------------------------------+---------------------------------+ | Brian Bassett | &bbassett = "322 Gannon Hall, | | EECS At WSU | Pullman, WA"; | +----------------------------------+ *bbassett = "Didn't your | | bbassett@eecs.wsu.edu | mother say 'It's not polite | | http://www.wsu.edu:8080/~brianb/ | to point'?"; | +----------------------------------+---------------------------------+ ========================================================================= Date: Wed, 13 Nov 1996 22:30:21 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Levent N Atasoy Subject: Re: AOLSERVER Digest - 12 Nov 1996 to 13 Nov 1996 In-Reply-To: <199611140503.AAA01239@services.web.aol.com> I posted a CSV file in my AOLserver which also has Full Text Pool installed. When I click on the CSV file, I get an "Upload CSV file" screen. It looks like the server processes the CSV files specially via some tcl. Is there any way to modify/tweak this behaviour or turn i off, or control it somehow? Which tcl is the one responsible? ========================================================================= Date: Wed, 13 Nov 1996 23:38:22 -0600 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Krish Menon Subject: Re: Virtual server renameing Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 10:14 PM 11/12/96 -0800, you wrote: >It's pretty straightforward. Simply replace all occurances of the name of >the old server in the nsd.ini file with the name of the new server. >It's that simple. Hi, Just a quick note to remind you to move the contents of [ns_home]/servers/[server_name] to [ns_home]/servers/[new_server_name]. Cheers, Krish Krish Menon, Webmaster Iway Internet Services krish@iw.net, http://www.iw.net ------------------------------- "Why the hell does a kamikaze pilot wear a helmet?" ========================================================================= Date: Thu, 14 Nov 1996 01:29:17 -0500 Reply-To: jim@meritnet.com Sender: Web Development with AOLserver From: Jim Wilcoxson Organization: Merit Software, Inc. Subject: Illustra DB Stale doesn't cause problems (knock on wood...) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I had submitted a query earlier about a "DB Stale" log entry. At the time I thought this was causing a TCL error, but actually the TCL error was caused by using a bad database handle. The DB Stale message is logged periodically (and no, I still don't know what it means), but appears harmless. Jim ========================================================================= Date: Thu, 14 Nov 1996 09:29:47 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: James F Smallacombe Subject: AOLserver virtual servers still stopping Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" There's been an ongoing thread about virtual servers randomly stopping on AOL 2.1, particularly with Solaris. Note that this is *not* the server daemon PID getting killed, just individual virtual servers. It has been suggested that threads hanging on reverse DNS lookup by the NSlog module may be causing this. Well, I've turned off reverse DNS in both the NSlog *and* NSperm modules for all 18 of my virtual servers, and am still seeing the problem. Outside of this problem, I really like AOLserver, and have had nothing but good things to say about it (ok, except the name ;-), but I may end up having to switch to Apache if my customers start defecting. James Smallacombe Bucks County, PA Internet Access james@pil.net http://www.pil.net PlantageNet Internet Ltd. http://www.plantagenet.com "Get thee glass eyes, and like a scurvy politician, seem to see things thou dost not" - King Lear, IV.vi ========================================================================= Date: Fri, 15 Nov 1996 04:32:19 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: "Larry W. Virden, x2487" Subject: Tcl and AOLserver development I have a plea for folk on this list. I try to keep development going on the Tcl FAQs at . There are two projects with which folk on this list can help. 1. One of the faqs that a co-hort , er, co-FAQer manages is the list of Commercial Uses of Tcl. If any of you have commercial software, or services which use Tcl, would you please consider spending a few moments looking over these FAQs and submitting your company's information? The goal is a mini-vendor's list of useful software, books, training, etc. that users of Tcl know should work well within their own Tcl environments. What you get out of this effort is free 'advertising' in a sense. The FAQ is free - and gets mirrored and posted to thet net on a regular basis. You will likely get new customers due to this addition - beware if you don't want more money, business, customers, etc. 2. The other place I need help is in locating software which users can download for free use, or at least free evaluation, which relates to Tcl, Tk, Expect, etc. If you have written such software, take a look at my Tcl software catalog, and consider submitting info for your packages. What you get in return for this is again, free advertising, as well as the likely benefit of lots of bug reports, fixes, updated doc, innovative new uses of your software, etc. Thanks for taking a moment to read this msg. -- Larry W. Virden INET: lvirden@cas.org <*> O- "We are all Kosh." Unless explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ========================================================================= Date: Fri, 15 Nov 1996 01:58:51 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Chris Umali Subject: nsperm: How to add users? Comments: To: brianb@mail.wsu.edu Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" hello Brian, You can add user by going in the /NS/Admin page on your site. Go to Access Control and there is a user and group section there. You need to create a group and user. A possible solution for your problem could be create the users you need and put them in just one group. You can have a group that edits specific sections on your site. YOu also need to create permissions for your group. You can give permissions to groups to modify the whole site or just portions of the sites. AOLserver is a great server. Supported by great tech's. Hope this helps you out in your problem. Have a nice day, THIS IS YOUR QUESTION: I'm trying to set up AOLserver on an NT box and I need to create user accounts so that everyone here in my department can publish pages. (We use Netscape Navigator 3.0 Gold) Anyway, I can't find where to add users. I've read the manual and it is absolutely no help. Can anyone help me? Or at least point me in the right direction? Brian Chris Umali Assistant WebMaster NetWerks http://www.netwerks.com ========================================================================= Date: Fri, 15 Nov 1996 10:39:27 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Levent N Atasoy Subject: Re: CSV File Comments: To: Chris Umali In-Reply-To: <2.2.32.19961115095901.006ad0f8@netwerks.com> Thanks Chris. Actually I was able to get around it by making the link point to http://server/NS/Sourc/file.csv as was done in the "Upload CSV file" instead of directly pointing to http://server/file.csv Even though this is workaround for links in the htm pages, still I want to learn about the mechanism causing this because 1. CSV files in automatic irectory listings do not have /NS/Source 2. I like the way this tcl turns CSV into HTML tables. I may want to use it in the future after small modifications. I now nothing about tcl, but I think I can learn enough to make such modifications. >>>>> On Fri, 15 Nov 1996 01:59:01 -0800, chris@netwerks.com (Chris Umali) said: CU> Hello Levent, CU> I've posted a csv file also, and when I clicked on it, it showed me CU> the upload csv file menu. I have not investigated this further in what tcl CU> script if any is responsible for it. You may want to check out the mime CU> types to see if its listed there. If you want people to download your csv CU> file, I suggest you just compress it. Hopefully the AOLserver tech can CU> suggest a explanation about the csv links showing "Upload CSV file" CU> Have a nice day, CU> Chris Umali CU> Assistant WebMaster CU> NetWerks CU> http://www.netwerks.com ========================================================================= Date: Fri, 15 Nov 1996 01:59:01 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Chris Umali Subject: CSV File Comments: To: Levent.Atasoy@macsch.com Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Hello Levent, I've posted a csv file also, and when I clicked on it, it showed me the upload csv file menu. I have not investigated this further in what tcl script if any is responsible for it. You may want to check out the mime types to see if its listed there. If you want people to download your csv file, I suggest you just compress it. Hopefully the AOLserver tech can suggest a explanation about the csv links showing "Upload CSV file" Have a nice day, Chris Umali Assistant WebMaster NetWerks http://www.netwerks.com ========================================================================= Date: Fri, 15 Nov 1996 17:09:57 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Valter Quenda Subject: CGI & Server push problems MIME-version: 1.0 Content-type: multipart/mixed; boundary="------------2389704077F5" Content-transfer-encoding: 7BIT This is a multi-part message in MIME format. --------------2389704077F5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi everybody Just two problems about the AOLserver's way to do CGI and server push... -Does anybody know if it's possible to have CGI scripts in subdirectories of CGI-BIN without having to declare these subdirectories in the configuration of AOLserver? -When I use a script to do server push to obtain a cycling page, I expect the browser showing the first page, the second and so on until the last page is reached. This usually works fine on all servers. The problem I'm having is that my c script (attached to this mail) makes the server send all the pages together when the script ends. I have tried to send an fflush at the end of each page, but it didn't work. I tried also to use write in place of printf to avoid use of bufferized output...it still doesn't work :-( The same script on an NCSA server works fine. Suggestions? Thank in advance for help Marina Berati (mc3478@mclink.it) You can send individual answers to v.quenda@crf.it Bye... --------------2389704077F5 Content-Type: text/plain; charset=us-ascii; name="prog.c" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="prog.c" #include #include #include main() { char S[300]; printf("Content-type: multipart/x-mixed-replace;boundary=Sep\n"); printf("\n--Sep\n"); printf("Content-type: text/plain\n\n"); printf("1111111111111\n"); printf("\n--Sep\n"); fflush(stdout); sleep(5); printf("Content-type: text/plain\n\n"); printf("helper eseguito\n"); printf("\n--Sep--\n"); fflush(stdout); exit(0); /* sprintf(S,"HTTP/1.0 200 OK\r\n"); write(1,S,strlen(S)); sprintf(S,"Content-type: multipart/x-mixed-replace;boundary=Sep\n"); write(1,S,strlen(S)); sprintf(S,"\n--Sep\n"); write(1,S,strlen(S)); sprintf(S,"Content-type: text/plain\n\n"); write(1,S,strlen(S)); sprintf(S,"1111111111111\n"); write(1,S,strlen(S)); sprintf(S,"\n--Sep\n"); write(1,S,strlen(S)); sleep(5); sprintf(S,"Content-type: text/plain\n\n"); write(1,S,strlen(S)); sprintf(S,"2222222222222\n"); write(1,S,strlen(S)); sprintf(S,"\n--Sep--\n"); write(1,S,strlen(S)); */ } --------------2389704077F5-- ========================================================================= Date: Fri, 15 Nov 1996 18:59:31 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Valter Quenda Subject: Image Animation MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit Hi all Anyone can tell me why the perl scripts I've found on the net to animate images don't work with AOLserver? They all use the content-type multipart/x-mixed-replace... Is this a content-type that will not work with AOLserver? thank for help, bye Valter Quenda (v.quenda@crf.it) ========================================================================= Date: Thu, 14 Nov 1996 10:28:14 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: "Stephen A. Mattin" Subject: Storefront for non-PrimeHost users? In-Reply-To: Automatic digest processor "AOLSERVER Digest - 12 Nov 1996 to 13 Nov 1996" (Nov 14, 12:02am) Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Are there any plans to offer Storefront to non-PrimeHost customers, i.e. those hosting their own AOLserver? -- Stephen A. Mattin stephen@MediLife.COM ========================================================================= Date: Fri, 15 Nov 1996 15:24:56 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Eric Klein Subject: CSV files MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII This is for everyone who is asking about the csv files. First of all, there is a tcl script controling how they are displayed. The file is: [server root]/modules/tcl/nsdb/gensql.tcl It contains the line: ns_register_proc GET /*.csv nsp_csvuploadform and the procedure nsp_cvsuploadform, which handles everything. If you wanted to you could quite easily alter this procedure. Happy hacking! * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Sat, 16 Nov 1996 12:43:26 +0000 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Howard Jones Subject: Re: Storefront for non-PrimeHost users? In-Reply-To: <9611141028.ZM10415@www.medilife.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Thu, 14 Nov 1996, Stephen A. Mattin wrote: > Are there any plans to offer Storefront to non-PrimeHost customers, i.e. > those hosting their own AOLserver? > I would be very interested in this also, before I start on developing a clone. Nice system guys! -- Howard Jones HELP! MY TYPEWRITER IS BROKEN! Voss Net Plc. - E.E.CUMMINGS Internet: hjones@vossnet.co.uk http://www.vossnet.co.uk/people/Howard/index.html ========================================================================= Date: Sun, 17 Nov 1996 11:12:37 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Bakki Kudva Organization: Navaco Subject: url's for tcl scripts don't work MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I had installed Hal's EasyTCL at our 'coomercial level' site which was working fine. I used it several times and found it very convenient. Today suddenly I get "The requested URL was not found on this server." error. I am having the same problem with all of the database query scripts which I modified from the pgbldr.tcl. I get "Could not find a procedure to handle method "POST" of URL "/research" on www.???.com." I have checked the permissions records and all seems to be fine. I re-initialized tcl but no use. What is going on here? What else can I do from this end? TIA, Bakki ========================================================================= Date: Sat, 16 Nov 1996 16:04:12 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Doug McKee Subject: Re: Storefront for non-PrimeHost users? In-Reply-To: (message from Howard Jones on Sat, 16 Nov 1996 12:43:26 +0000) >>>>> "Howard" == Howard Jones writes: Howard> On Thu, 14 Nov 1996, Stephen A. Mattin wrote: >> Are there any plans to offer Storefront to non-PrimeHost >> customers, i.e. those hosting their own AOLserver? >> Howard> I would be very interested in this also, before I start on Howard> developing a clone. Nice system guys! Currently, there are no plans to distribute Storefront outside of Primehost -- that doesn't mean it will never happen though! doug -- ------------------------------------------------------------------- Doug McKee, Lead Engineer for Web Commerce & AOLserver Applications Email: doug@sb.aol.com America Online, Inc. Voice: (800) 529-9166 511 Bath Street (805) 882-2350 Santa Barbara, CA Fax: (805) 899-4316 93101 ------------------------------------------------------------------- ========================================================================= Date: Tue, 19 Nov 1996 21:52:10 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: "PGG Graphics, Inc" Subject: Re: AOLSERVER Digest - 12 Nov 1996 to 13 Nov 1996 In a message dated 96-11-14 00:02:52 EST, you write: > We are in fact planning on extending Storefront with something similar > to what you're describing. It will allow shoppers to login (or > "autologin") upon entry entry to the site. The Storefront will then > be able to hand out personalized pages, do session tracking, and fill > in default billing/shipping information. At least some of this > functionality will be available outside the Storefront, probably > through Server-side includes. We'll be using this customer login > facility to implement selling of "soft goods" (e.g., recipes, news > articles, multimedia). We are considering using it to implement > "subscription services" as well that would either time-out users when > their subscription expired, or bill the user for another > week/month/year. I know I'm not alone, in that most of us are not selling 'products' or 'goods' but rather the information that is on the server itself. Having the subscription features would be a big help. It would also make the server and hosting services more viable, since what *MOST* people setting up a website are trying to sell is their 'information' ie: subscriptions. For someone who knows the system, and TCL it would not be too complex to set up a basic system. Even a basic system would be better than what exists now. Being able to provide access to 'groups' for a specified period of time, after purchasing a code, or entering a card number, would certainly make the system very viable. Because of the intricacies of the server, the regular permissions software does not work, it would seem to me that adding this functionality to the server would help a great number of people. Thanks ========================================================================= Date: Wed, 20 Nov 1996 17:41:27 +0200 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Matthias Schmitt Subject: Trouble sending mail from Perl script with Blat on NT Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Hello, In these days I am switching from my old web server to AOLserver 2.1 on WinNT 3.5.1. I ported all my Perl scripts and they are doing well, except those which are using the Blat mail program (version 1.5) for sending mail from my forms. When I am starting a Perl program which uses Blat direct from the DOS shell, it works fine and the mail will be sent. When I am using Blat from my CGI Perl script the script runs, but no mail will be send. Is it possible to start any programs from CGI scripts with the AOLserver ? The same script worked fine with my old web server. Any ideas ?? Matthias ______________ Mediatel Administrator (http://www.mediatel.lu) / ___ ____ / Matthias Schmitt (matthias.schmitt@crpht.lu) / / _/_ /_ / / Centre de Recherche Henri Tudor / / / /_/ / / / Centre de Ressources Multimedia / / / / / / L-1359 Luxembourg - Kirchberg / /_/ /_/ / 6, rue Coudenhove - Kalergi /_____________/ Tel : +352 425991-1 Fax : +352 436523 ========================================================================= Date: Wed, 20 Nov 1996 15:01:58 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Michael Kmiec Subject: Socket Error Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Hello all... Here's the latest in the AOLServer 2.1 saga. Every so often, the server.log gives me this: [20/Nov/1996:14:48:59 -0500][9696.6][-Sockets-] Error: SocketAccept(http://server.pfn.com): setsockopt(266) failed: Broken pipe This happens, oddly enough, when a one of a Netscape browser's frames receives focus. Has anyone else seen anything like this? Mike ------------------------------------------------------ Michael Kmiec PFN Incorporated 26 Landsdowne Street Cambridge, MA 02139 mike@pfn.com 617.494.9980 ========================================================================= Date: Thu, 21 Nov 1996 15:02:19 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Gaute Amundsen Subject: SSL for NT & export ??? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" We have been using the server since the Navisoft days, and are quite pleased with it. How ever we are coming to a point where we REALY need SSL. It would be a pitty if I had to switch to another server to get that... Could somone please tell me what plans ther are for an NT and/or export version. Gaute Amundsen ========================================================================= Date: Thu, 21 Nov 1996 15:28:03 +0000 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver Comments: Authenticated sender is From: Christof Schmidbauer Organization: Ferengi Institute for Business Ethics Subject: Re: Trouble sending mail from Perl script with Blat on NT MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT One of the unsolved problems in AOLServer. AOLServer blocs every winsock-call from a cgi-program. The question why AOlserver behaves in this way was often asked in this forum, but no answer from the developer team so far. I moved our site and other to Netscape Enterprise or MS IIS for this reason, although I really prefer the AOLserver over Netscapes Enterprise Server or MS IIS. On 20 Nov 96 at 17:41, Matthias Schmitt wrote: > ... I ported all my Perl scripts and they are doing well, except > those which are using the Blat mail program (version 1.5) for sending mail > from my forms. When I am starting a Perl program which uses Blat direct > from the DOS shell, it works fine and the mail will be sent. When I am > using Blat from my CGI Perl script the script runs, but no mail will be > send. > > Is it possible to start any programs from CGI scripts with the AOLserver ? Christof Schmidbauer jwgi@wiwi.uni-frankfurt.de http://caladan.wiwi.uni-frankfurt.de/VTAD/ ========================================================================= Date: Sun, 24 Nov 1996 14:26:42 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Marco Coletti Subject: Re: SSL for NT & export ??? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 15.02 21/11/96 +0100, you wrote: >We have been using the server since the Navisoft days, >and are quite pleased with it. >How ever we are coming to a point where we REALY need SSL. > >It would be a pitty if I had to switch to another server to get that... > >Could somone please tell me what plans ther >are for an NT and/or export version. My experience: the AOLserver 2.1 .pdf manual is a bit outdated about SSL for NT export version. Look at the online version of the manual for some details. The good news is that you already have the SSL module export version as \bin\nssle.dll You can add the module through the add module form for a virtual server. The TCL code that manages the SSL configuration is somewhat buggy and you should pay attention to the order of the necessary configuration steps. The main problem is that you cannot enter the key file path or the certificate file path in the add module form because then the SSL module doesn't start (the key and cert files are not yet in place) and you can't proceed to generate the private-public key file. This is not such a problem, but if you don't enter the file paths in the add module form then you will find that the module configuration form lacks the widgets for inputting that data!! My suggestion is: 1. Add the SSL module through the add module form; specify the file paths (something like \key.pem and \cert.pem). Don't restart the server now. 2. Edit the server configuration file (\nsd.ini) and: - comment out or delete the two rows referring to the files key.pem and cert.pem - search for "nssl.dll" and replace with "nssle.dll" 3. Restart the server 4. Go to /NS/Admin, choose the link for SSL configuration, generate a new private-public key pair (give \key.pem as output file) and generate a certificate request file. 5. E-mail the cert request file to VeriSign (the server suggests Navisoft-request-id@verisign.com, while the manual says aolserver-request-id@verisign.com; I took the second) and, when you get the reply, follow the online procedure at VeriSign site. (I'm at this point now) 6. When you receive the cert file, put it in place (\cert.pem) and restore the deleted rows in nsd.ini 7. Restart the server and cross the fingers... Ciao. -= MarCo =- ========================================================================= Date: Mon, 25 Nov 1996 08:58:14 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Valter Quenda Subject: virtual server stopping also on NT MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit Hi folks Sone weeks ago I posted a message titled "AOLserver hanging", in which I was reporting that my server was randomly stopping having reached the maximum number of threads. Well, reading the messages of the past digests I realized that it's the same problem reported in the discussion named "virtual server stopping". I tried to turn off all DNS calls from the NSD.INI but it didn't work. The only contribute that I can give to the discussion is that this behaviour happens also on an NT 3.51 Server machine. If I'm not missing something, I've read of this behaviour only on Unix platforms; well, the bug is not system-dependant, the same thing happens on NT platforms too...:-(... Valter Quenda (v.quenda@crf.it) ========================================================================= Date: Mon, 25 Nov 1996 10:05:33 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Valter Quenda Subject: Multipart and AOLserver MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit Hi folks I'm experiencing a problem reported to the list some weeks ago; I'm trying to do an upload via AOLserver via cgi-bin but it doesn't work. In addition, as I wrote some days ago to the mailing list, I have also problems in doing some image-animation. The common part to these two situations is the use of the multipart/... mime type, which AOLserver seems not to interpret well. Has anybody found a workaround to the problem of uploading and doing image animation in these days? If yes please write it to the list. This is becoming a seriuos AOLserver's limitation... (P.S. I'm using AOLserver 2.1 on an NT 3.51 Server platform) Valter Quenda ========================================================================= Date: Mon, 25 Nov 1996 13:50:35 +0000 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver Comments: Authenticated sender is From: Paul d'Haens Subject: Getting width & height of an image in TCL I want to store all information about my gif & jpg in an illustra table. Ideally I want to have a script that scans the ASSET directory for image files and creates a record for each new image found. This script should fill the colums 'width' & 'height' automatically. Is there a TCL command (extension) that returns the pixel size of a specified gif or jpg file ? If not, can someone recommend a small command-line utility program for NT that writes this information to standard output. Thanks, ------- Paul d'Haens - Cornhill Marketing Ltd Belgium: Tel: +32 3 6646180 Fax: 6647674 England: Tel: +44 1789 470055 Fax: 470770 ========================================================================= Date: Mon, 25 Nov 1996 14:01:12 +0000 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver Comments: Authenticated sender is From: Paul d'Haens Subject: Keyword Search on Tables How do I setup a keyword search on data stored in a illustra table (say Products) iso HTML pages. In terms of : - Table & Index Definition - SQL select statement Is it possible to use the full text search facilities like stopwords & stemwords for this kind of search. ------- Paul d'Haens - Cornhill Marketing Ltd Belgium: Tel: +32 3 6646180 Fax: 6647674 England: Tel: +44 1789 470055 Fax: 470770 ========================================================================= Date: Mon, 25 Nov 1996 17:18:40 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Gaute Amundsen Subject: Warning: User: user does not exist.... Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" I get several of these in the log when I restart the server.. >[12/Nov/1996:15:10:41 +0100][391.368][gil] Warning: User: listed in group >public(Alle og en hver!) does not exist However there has been no complaints, so apparently this causes no problem. Should I worry? What does it mean? What can I do about it? Thanks for any ideas. gaute -- ----------------------------------------------------------- Gaute Amundsen Grafisk InterLink TCL/CGI & Drift Din kurs leverandor gaute@gil.no http://www.GIL.no ----------------------------------------------------------- ========================================================================= Date: Wed, 27 Nov 1996 13:32:46 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Marco Coletti Subject: BUG in renaming access.log Comments: cc: fausto.jori@eurofin.it Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" AOLserver 2.1 on Windows NT 3.51 sp4 on P166 64 MB RAM Every midnight my virtual server eurofin21 attempts to rename access.log and open a new access.log. Excerpt from server.log: [27/Nov/1996:00:00:00 +0100][96.105][-Scheduler-] Error: AccessLog(eurofin21): rename(e:/AOLserver/servers/eurofin21/modules/nslog/access.log, e:/AOLserver/servers/eurofin21/modules/nslog/access.log.96-11-27-00:00) failed: Invalid argument(22) I'm pretty sure that ":" is an invalid character for filenames on NT filesystem, so this appears to be a bug in AOLserver. Can someone confirm that? -= MarCo =- ========================================================================= Date: Wed, 27 Nov 1996 08:16:11 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Daniel Andresen Subject: Request fulfilment question Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Folks, I'm doing some digital library work for the Alexandria Digital Library project at UCSB. I want to do the following: 1. Intercept certain requests. (Easily done, just use part of the URLspace) 2. Analyze these requests using a C++ DLL. (Easily done.) 3. The analysis adds arguments to the request, and indicates whether the request should be done locally or be redirected to another server. E.g., the request 'GET /mytest/mycgi.prog?CGI_ARG=4' might go to 'GET /mycgi.prog?CGI_ARG=4&ANAL_RESULT=3'. 4. If desired, redirect the request with the new arguments. (Reasonably straightforward, I think.) 5. If not, tell AOLServer to take the modified request and fulfil it, essentially starting over on it but not performing my analysis. I'm having difficulty with part 5. 'Ns_httpget' imposes a nasty performance penalty and I can't seem to get the modified arguments to it either. The modified URL could be for a normal file, embedded TCL procedure, or a CGI script. Any thoughts? Regards, Dan ---------------------------------- Dan Andresen, dandrese@cs.ucsb.edu ---------------------------------- ========================================================================= Date: Fri, 22 Nov 1996 18:57:15 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Infowave Customer Support Subject: Unrelated to AOLServer, but a real nightmare Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Hi, I've received good responses from this community before, so I thought I post a question here, though unrelated to the AOLserver itself. Recently, we have a person coming to our website's chat room and started using really nasty languages, offending everyone. We had stated our ground, even to the extent of removing this person's comments and usernames time after time. However, the person keeps coming back using different username. This person even threatens to put out virus on our system. We know this person's IP address, and was able to know it's coming off from a school. I know AOLserver provides ability to block an IP. But that's only a preventive measure. We want to take a more severe action, such as sending an email to this school's administration for investigation. Anyone has any idea how we should handle this? Thank you very much, Wendy Liu InfoWave Communications Corp. ========================================================================= Date: Sat, 23 Nov 1996 20:09:19 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Domenico di Girolamo Subject: Re: Random Web Images MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Chris Umali wrote: > > Hello, > Has anyone implemented a random image generator in their web site? > Would using tcl be a great option, or cgi? This image generator would > display random banners like the Yahoo and CNet web sites. Any suggestions, > or clues? > > Have a nice day, > > Chris Umali > Assistant WebMaster > Envision Group, NetWerks > chris@netwerks.com > http://www.netwerks.com > 310-523-2000 I have not tested much this TCL but it should work # author: Domenico di Girolamo (Infoway) (www.puglia.com) #............................................................... # Random image generator #............................................................... #... HTML CODE ... # #............................................................... ns_register_proc POST /Tcl/Prndimg RndImage ns_register_proc GET /Tcl/Grndimg RndImage proc RndImage {conn context} { #...Insert URL that contain images ... set ImageDir "http://www.puglia.com/Microchip/" #............................................................... set ImageSetID [ns_set new MySetImage] #...Insert image names ... ns_set put $ImageSetID Image1 bprev.gif ns_set put $ImageSetID Image2 bstoria.gif ns_set put $ImageSetID Image3 bmarchi.gif #............................................................... set NumImage [ns_set size $ImageSetID] set NumSelImage [RndNum $NumImage] set KeyImage [ns_set key $ImageSetID $NumSelImage] set SelImage [ns_set get $ImageSetID $KeyImage] append ImageDir $SelImage set headers [ns_set new myheaders] ns_set put $headers location $ImageDir ns_respond $conn -status 301 -type image/gif -string "display" -headers $headers } proc RndNum {Range} { set LocTime [lindex [ns_localtime] 1] append LocTime [lindex [ns_localtime] 0] if { $LocTime == "" } { set NumTime 0 } else { scan $LocTime "%04d" NumTime } set NumRnd [expr (($NumTime*1103515245)/65536)%$Range] return $NumRnd } -- ___________________________________________________________ Domenico di Girolamo (Software developer) firm : InfoWay di Domenico di Girolamo e-mail : girolamo@puglia.com http : www.puglia.com Tel. : 39.80.5567699 ___________________________________________________________ / ___ __ \ \/ / / /| / /_ / / \ /\ / /\ \ / / / |/ / /__/ \/ \/ /--\ | ___________________________________________________________ ========================================================================= Date: Fri, 29 Nov 1996 12:50:32 +0000 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Keith McAlister Subject: AOL Server & Postgres Mime-Version: 1.0 Content-Type: Text/plain; charset=ISO-8859-1 I am running AOLserver on Linux and have compiled and installed the Postgres95 DBmodule. Postgres is happily running on my system and the query front end (psql) talks to the back end. However I am haveing trouble getting AOLServer to talk to postgres at all through the standard database interface. The AOLServer log files reprt a failure in the tcl, and it claims that ns_db is not a vaild comand. I have tried the /NS/DB/Admin interfaces all of which fail with tcl errors suggesting that a) the nddb module is not loading and b) the database connection to Postgres is not being made. My nsd.ini file has an entry for the postgres.so driver [ns/db/drivers] postgres=postgres.so [ns/db/pool/server1] DemandBuild=off Driver=postgres connections=2 DefaultSource=localhost:port:database (with my real values) User=postgres Verbose=on When AOLserver starts there is quite a bit of info written to the log file, but none of it relates to nsdb.so starting or connections being opened. I am pretty sure that my nsd.ini is wrong, but I am not sure how to fix it! Has anyone got this working and can offer advice or a working nsd.ini file?? Regards Keith McAlister ========================================================================= Date: Tue, 26 Nov 1996 02:53:01 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Toni Pamies Subject: cgi on Aolserver 2.1 MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hello, I'm using Aolserver on my Linux Box, and when i try to execute a cgi, the server every time display an error. I see the log file and apperars: Error: Process 2410 exited from signal 13 Error: Error waiting for exit of CGI /usr/local/RSServer/cgi/proves: Illegal seek Can you help me ? Thanks in advance. \\|// (@ @) +--------ooO--(_)--Ooo-----------------+------------------------------------+ | Antoni Pamies Olive | Et Portem el mon a casa | | Equip Webmestres | | | Ready Soft | http://www.readysoft.es | | Av. Paisos Catalans, 44 1r | webmaster@readysoft.es | | Reus (Catalunya) | | +--------------------------------------+------------------------------------+ ========================================================================= Date: Wed, 27 Nov 1996 14:43:18 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: wpowell@edu.att.com Subject: Growing Log Sizes MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I couldn't find this topic in those newsletters I have archived, BUT... What is causing my server logs to grow beyond the 128k limit I have specified in the NSD.INI file? I have one that is over 2 meg again! I have tried wiping out ALL of them in the odd chance that after a logfile grows beyond the limit, it won't "roll over". Help? TIA, Bill Powell wpowell@att.com ========================================================================= Date: Fri, 29 Nov 1996 14:33:37 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Eric Klein Subject: Re: Tcl sript using "ns_table info" In-Reply-To: <199611170001.QAA24655@dork.navisoft.com.navisoft.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII > Date: Sat, 16 Nov 1996 16:25:47 +0100 > From: Nils-Olov Fransson > X-Mailer: Mozilla 3.0 (WinNT; I) > MIME-Version: 1.0 > To: serverbugs@sb.aol.com@sb.aol.com > Subject: Tcl sript using "ns_table info" > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Hello! > > I'm learning to write tcl-scripts to control the aolserver. I have > followed the examples in the documentation and found the following > error. > > In example 5, desribing a database table, the function ns_table dont > work with the option info. To exclude errors in the DBHANDLE and TABLE > variables I modified the script and tested with the options exists and > bestrowid, and both worked well. It seems to me that ther is at least a > documentation error. I came across this problem a while back, and the problem isn't ns_table, but rather the example #5. The example is using and older version of the ns_table function that has been changed (there actually is no ns_table info in 2.1) The example #5 has been fixed and send up the ladder, so it will be in the docs correctly in the next release, and online before long. * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Fri, 29 Nov 1996 14:56:22 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Eric Klein Subject: Re: BUG in renaming access.log Comments: To: Marco Coletti Comments: cc: fausto.jori@eurofin.it In-Reply-To: <2.2.32.19961127123246.006a83fc@mail.bearnet.it> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 27 Nov 1996, Marco Coletti wrote: > AOLserver 2.1 on Windows NT 3.51 sp4 on P166 64 MB RAM > > Every midnight my virtual server eurofin21 attempts to rename access.log and > open a new access.log. > > Excerpt from server.log: > > [27/Nov/1996:00:00:00 +0100][96.105][-Scheduler-] Error: > AccessLog(eurofin21): > rename(e:/AOLserver/servers/eurofin21/modules/nslog/access.log, > e:/AOLserver/servers/eurofin21/modules/nslog/access.log.96-11-27-00:00) > failed: Invalid argument(22) > > I'm pretty sure that ":" is an invalid character for filenames on NT > filesystem, so this appears to be a bug in AOLserver. > > Can someone confirm that? Yes, it does appear to be a bug in the server, and I have reported it as such. Thanx. * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Fri, 29 Nov 1996 15:03:20 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Eric Klein Subject: Re: cgi on Aolserver 2.1 Comments: To: Toni Pamies In-Reply-To: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 26 Nov 1996, Toni Pamies wrote: > Hello, > > I'm using Aolserver on my Linux Box, and when i try to execute a cgi, the > server every time display an error. I see the log file and apperars: > > Error: Process 2410 exited from signal 13 > Error: Error waiting for exit of CGI /usr/local/RSServer/cgi/proves: > Illegal seek My first question is whether you have an interps section in the nsd.ini The error is most common when you are tring to run a perl script (or some other generally non-executable file) and you don't have a interps section in your code. Let me know if that helps. * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Fri, 29 Nov 1996 14:21:29 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Eric Klein Subject: Stale DB handle messages Comments: cc: frank-overton@go-explore.com MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII For everyone who has been wondering about the stale DB handle messages, I have your grail. The message is sent when someone tries to use a DB handle that has been retired. A handle is retired based on the MaxOpen, and MaxIdle parameters of [ns/db/pools/pool-name]. MaxIdle and MaxOpen are both measured in seconds. MaxIdle is the number of seconds a handle is allowed to remain idle before it is retired, MaxOpen is the total amount a time a handle is allowed to remain open. I hope that this points in a helpfull direction for everyone. Happy Hunting * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Fri, 29 Nov 1996 14:26:08 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Eric Klein Subject: CSV tcl handling MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII This is an update to a post I send a while back regarding CSV handling in the tcl. I wanted to note that this is only available in 2.1, and so that those using 2.033 and earlier will not be able to use it. Note also for those who merely wish to disable it, you can go to the file where it is contained server-root/modules/tcl/nsdb/gensql.tcl and comment it out (using the tcl comment operator #) and restart the server. This will disable that feature. Happy Hacking once again. * Eric Klein * AOL Santa Barbara * eric@sb.aol.com * 511 Bath St. * Phone: (805) 882-2350 * Santa Barbara, CA 93101 * Fax: (805) 899-4316 * ========================================================================= Date: Sat, 30 Nov 1996 11:43:36 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Doug McKee Subject: Re: Keyword Search on Tables In-Reply-To: <199611251317.OAA14639@phobos.glo.be> (xenia@GLO.BE) >>>>> "Paul" == Paul d'Haens writes: Paul> How do I setup a keyword search on data stored in a illustra Paul> table (say Products) iso HTML pages. Paul> In terms of : Paul> - Table & Index Definition Paul> - SQL select statement Paul> Is it possible to use the full text search facilities like Paul> stopwords & stemwords for this kind of search. You can actually go two different routes. First, you can take advantage of Illustra's Text data blade and create columns of type doc; e.g., create table foo name text, body doc and then insert elements with something like insert into foo (name, body) values ('title', 'format(ascii),NoCopyText:/absolute/path/name/of/file') You'll have to buy the documentation (see www.primehost.com) to get complete details, but the above should work for the most part. Your other option is loading the nstext module, and using the ns_htmltoquery function to do stemming, stopwording, and duplicate removing. e.g., [ns_htmltoquery "cats and dogs and cats"] == "dog cat" You can then manufacture SQL queries that aren't super fast, but do something approximating full text search. Hope this helps! doug ========================================================================= Date: Sat, 30 Nov 1996 11:46:36 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Doug McKee Subject: Re: Getting width & height of an image in TCL In-Reply-To: <199611251317.OAA14615@phobos.glo.be> (xenia@GLO.BE) >>>>> "Paul" == Paul d'Haens writes: Paul> I want to store all information about my gif & jpg in an Paul> illustra table. Ideally I want to have a script that scans Paul> the ASSET directory for image files and creates a record for Paul> each new image found. This script should fill the colums Paul> 'width' & 'height' automatically. Paul> Is there a TCL command (extension) that returns the pixel Paul> size of a specified gif or jpg file ? Paul> If not, can someone recommend a small command-line utility Paul> program for NT that writes this information to standard Paul> output. Here's some C code that adds a command to Tcl to return the width and height of a gif image; it's up to you to compile and load it: /* Returns a list of 2 elements, width and height */ static int GifSizeCmd(ClientData dummy, Tcl_Interp *interp, int argc, char **argv) { int fd; unsigned char buf[0x300]; int depth, colormap, dx, dy; if (argc != 2) { Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], " gif\"", NULL); return TCL_ERROR; } fd = open(argv[1],O_RDONLY); if (fd == -1) { Tcl_AppendResult(interp, "Could not open file \"", argv[1],"\"",NULL); return TCL_ERROR; } if (read(fd,buf,6) == -1) { badfile: close(fd); Tcl_AppendResult(interp, "Bad file \"", argv[1],"\"",NULL); return TCL_ERROR; } if(strncmp((char *) buf, "GIF87a", 6) && strncmp((char *) buf, "GIF89a", 6)) { goto badfile; } if (read(fd,buf,7) == -1) { goto badfile; } depth = 1 << ((buf[4] & 0x7) + 1); colormap = (buf[4] & 0x80 ? 1 : 0); if (colormap) { if (read(fd,buf,3*depth) == -1) { goto badfile; } } outerloop: if (read(fd,buf,1) == -1) { goto badfile; } if (buf[0] == '!') { unsigned char count; if (read(fd,buf,1) == -1) { goto badfile; } innerloop: if (read(fd, (char *) &count, 1) == -1) { goto badfile; } if (count == 0) { goto outerloop; } if (read(fd,buf,count) == -1) { goto badfile; } goto innerloop; } else if (buf[0] != ',') { goto badfile; } if (read(fd,buf,9) == -1) { goto badfile; } dx = 0x100 * buf[5] + buf[4]; dy = 0x100 * buf[7] + buf[6]; sprintf(buf,"%d",dx); Tcl_AppendElement(interp,buf); sprintf(buf,"%d",dy); Tcl_AppendElement(interp,buf); close(fd); return TCL_OK; } static int InterpInit(Tcl_Interp *interp, void *context) { Tcl_CreateCommand(interp, "ns_gifsize", GifSizeCmd, NULL, NULL); } DllExport int Ns_ModuleInit(char *hServer, char *hModule) { return Ns_TclInitInterps(hServer, InterpInit, NULL); }