========================================================================= Date: Fri, 2 Jul 1999 11:57:45 EDT Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Jay Ridgeway Subject: Re: AOLSERVER Digest - 28 Jun 1999 to 29 Jun 1999 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit In a message dated 6/29/99 11:41:28 PM Eastern Daylight Time, LISTSERV@SERVICES.WEB.AOL.COM writes: << Does anyone here use Illustra (on NT) in a heavy load environment for indexing/searching site content? I am considering it, but am wondering about performance, scalabilty, etc. Any horror/hero stories about it? >> Try PLS; http://www.pls.com. It's fun, fast and free. jay ========================================================================= Date: Thu, 8 Jul 1999 14:34:44 -0400 Reply-To: philg@mit.edu Sender: Web Development with AOLserver From: Philip Greenspun Subject: AOLserver source code at http://aolserver.lcs.mit.edu/ AOLserver 3.0 source code is available at http://aolserver.lcs.mit.edu/ where we also hope to get a good community of developers together. Enjoy, Philip p.s. Version 1.6 of the ArsDigita Community System is also released as of today (see http://photo.net/doc/version-history.html for what's new and interesting). ========================================================================= Date: Fri, 9 Jul 1999 12:24:40 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Justin Alcorn Organization: OhioOnline, Inc. Subject: DB2 Driver MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Before I dive into this, has anyone written an AOLserver Db2 Driver (Specifically for 2.3, I need SSL)? Has anyone tried and failed, and is this a fool's errand? I've got some DB2 UDB data I've got to put on the web - we've got the Oracle and PostGres interfaces working fine, but the live data is DB2. Thanks for any help... -- Justin Alcorn, Director of Network Applications OhioOnline, Inc., Cleveland, OH ========================================================================= Date: Sat, 10 Jul 1999 00:20:39 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Dominic Tracey Subject: Sequences MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Does anyone have a slick way to get the next value out of a sequence in a concurrent-safe, efficient manner? In Solid (which I'm using) you can reference the next value in an ns_db dml INSERT statement: INSERT INTO table (id) VALUES (id_sequence.NEXTVAL); but I can't seem to think of a clean way to find out what the value is that I'm putting in (so that I can put it into some other associative tables). I suppose you could do a: SELECT MAX(id) FROM table; and get an ns_set that contains the row you are looking for but this seems like a pretty expensive way to do an insert. Also, I'm not entirely sure that this couldn't get tripped up in some locking schemes where the second part returns a row that someone else inserted after we inserted our row. Thanks for any thoughts you can offer. D ========================================================================= Date: Fri, 9 Jul 1999 23:39:21 -0700 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: jim@rubylane.com Subject: Re: Sequences Comments: cc: dominic@AQUILON.COM In-Reply-To: <3786CA17.373C7E34@aquilon.com> from "Dominic Tracey" at Jul 10, 99 00:20:39 am Content-Type: text I have a TCL function that generates persistent sequences. It uses mutexes to protect against concurrency problems and is database independent. It handles multiple sequences (i.e., a userid sequence, part number sequence, ...) Example of usage: set userid [qrnextid regusers.userid] If you are interested, let me know and I'll email it. Jim www.rubylane.com > > Does anyone have a slick way to get the next value out of a sequence in > a concurrent-safe, efficient manner? In Solid (which I'm using) you can > reference the next value in an ns_db dml INSERT statement: > > INSERT INTO table (id) VALUES (id_sequence.NEXTVAL); > > but I can't seem to think of a clean way to find out what the value is > that I'm putting in (so that I can put it into some other associative > tables). I suppose you could do a: > > SELECT MAX(id) FROM table; > > and get an ns_set that contains the row you are looking for but this > seems like a pretty expensive way to do an insert. Also, I'm not > entirely sure that this couldn't get tripped up in some locking schemes > where the second part returns a row that someone else inserted after we > inserted our row. > > Thanks for any thoughts you can offer. > > D > ========================================================================= Date: Sat, 10 Jul 1999 06:31:51 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Dave Weis Subject: DB2 Driver In-Reply-To: <199907100404.AAA29079@services.web.aol.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII > Date: Fri, 9 Jul 1999 12:24:40 -0400 > From: Justin Alcorn > Subject: DB2 Driver > Before I dive into this, has anyone written an AOLserver Db2 Driver > (Specifically for 2.3, I need SSL)? Has anyone tried and failed, and is > this a fool's errand? I got the first linux beta of db2 and was considering it to connect to an as/400, but the readme said that that version 1. didn't connect to remote datasources and 2. wasn't thread safe. i have the 6.whatever cd on the way now though. we will definitely need to write one here at some point, just not sure when. contact me off the list if you would like to discuss it. i'm a better C person than db2 dba :-) dave -- David Weis | 10520 New York Ave, Des Moines, IA 50322 djweis@plconline.com | Voice 515-278-0133 Ext 231 When they took the Fourth Amendment, I was quiet because I didn't deal drugs. When they took the Sixth Amendment, I was quiet because I was innocent. When they took the Second Amendment, I was quiet because I didn't own a gun. Now they've taken the First Amendment and I can't say anything. ========================================================================= Date: Fri, 16 Jul 1999 22:26:03 -0600 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: "Michael A. Cleverly" Subject: Trouble with Sybase & AOLserver 2.3.3 MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I've used Solid 2.3 and AOLserver for over a year and a half now, with almost no headaches. Recently I decided to give Sybase and AOLserver 2.3.3 (under RH Linux 5.2) a try and now I've got two problems I hope someone on this list can shed some light on. (I found people asking about problems that sound disturbingly like the ones I'm facing on photo.net/wtr/ though their questions have gone unanswered there for some time. See: http://photo.net/bboard/q-and-a-fetch-msg.tcl?msg_id=000S3t and http://photo.net/bboard/q-and-a-fetch-msg.tcl?msg_id=000Op0 for examples.) First, the ExtDb driver logs an error when it tries to close the connection, although from the db side the connection appears to be closed (my aolserver sybase user does not show up as being logged in when I go into isql and run sp_who). [16/Jul/1999:20:12:50 -0600][13484.13672] Error: DbProxyCheckStatus: database error message: "DbClose: ct_cmd_drop() failed closing connection: livraria:dbook" [16/Jul/1999:20:12:50 -0600][13484.13672] Error: Ns_ExtCloseDb(External): Error closing connection #0. Is this a result of misconfiguration on my part, or just a quirk I need to learn to live with? (Also, when I call ns_shutdown or ns_shutdown -restart the external db proxy processes don't shutdown. Is this the expected behavior?) The second error, concerns me much more: [15/Jul/1999:21:15:18 -0600][13484.13947][store] Notice: Ns_DbOpenDb(sybext): Opening datasource: livraria:dbook [15/Jul/1999:21:15:19 -0600][13484.13947][store] Notice: Ns_ExtOpenDb(External): Openeddatasource: livraria:dbook with Sybase Proxy Daemon v1.0 [15/Jul/1999:21:17:15 -0600][13484.13950][store] Warning: ExtDb: Proxy I/O timeout (exceeded 60 seconds). I can't consistantly reproduce this error, but sometimes after doing a (usually) large number of selects in a row I'll get this error which causes the current call to ns_db getrow or (ns_db 0or1row, etc. if I'm in a foreach loop doing multiple individual queries) to fail and my tcl script to blow up. When it decides to freeze up and stop responding appears to be totally random. Usually rerunning the script and executing the same SQL statement will work perfectly, or fail later than it did the first time. The intermittent nature of this timeout problem has been driving me crazy... Are there any AOLserver+Sybase gurus on this list who can point me in the right direction towards solving these problems? Michael ========================================================================= Date: Sat, 17 Jul 1999 14:33:41 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Colin Summers Subject: Database Services Mime-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" v 2.3 My AOLserver installation is up and running, and I compiled ArsDigita's driver and loaded that. I edited the .ini file as shown in the example. It initialized without error. I do not see a link for Database Services. I thought I might just try out some table creation and data entry from the built-in forms in AOLserver before I started writing my own. It doesn't matter that much, I will write some simple ones now instead, to test it, but how do I get to the section mentioned in the manual? (The method mentioned, load the NS/Admin page and then follow the link for Database Services doesn't work since there isn't a link. Thanks, --Colin ========================================================================= Date: Sat, 17 Jul 1999 14:52:10 -0700 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Jeff Huber Subject: Re: Database Services MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You did configure your virtual server to use the database, right? We could help you more if you posted your nsd.ini (don't forget to take the passwords out) Colin Summers wrote: > > v 2.3 > > My AOLserver installation is up and running, and I compiled ArsDigita's > driver and loaded that. I edited the .ini file as shown in the example. > It initialized without error. > > I do not see a link for Database Services. I thought I might just try out > some table creation and data entry from the built-in forms in AOLserver > before I started writing my own. > > It doesn't matter that much, I will write some simple ones now instead, > to test it, but how do I get to the section mentioned in the manual? > > (The method mentioned, load the NS/Admin page and then follow the link > for Database Services doesn't work since there isn't a link. > > Thanks, > --Colin -- ---------------------------------------------- | Jeff Huber | Web Applications Developer | | jeff@am.net | AM.net - http://am.net | ---------------------------------------------- ========================================================================= Date: Sat, 17 Jul 1999 15:32:24 -0700 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Colin Summers Subject: Re-source Mime-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" I have put my copy of Greenspun's utilities.tcl file in the modules directory and it is loading perfectly as AOLserver starts. Is there a way, other than restarting the server (v 2.3) to tell it to source that file again? I ask, obviously, not for utilities.tcl but for files I might want to put there myself, that would change as I worked. --Colin ========================================================================= Date: Sun, 18 Jul 1999 06:11:30 EDT Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Kevin Lawver Subject: Re: AOLSERVER Digest - 10 Jul 1999 to 17 Jul 1999 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Colin, If you go to /NS/Tcl/Admin, you should see a link to re-initialize your private Tcl directory. This will re-source all of the .tcl files in Date: Sat, 17 Jul 1999 15:32:24 -0700 > From: Colin Summers > Subject: Re-source > > I have put my copy of Greenspun's utilities.tcl file in the modules > directory and it is loading perfectly as AOLserver starts. > > Is there a way, other than restarting the server (v 2.3) to tell it to > source that file again? > > I ask, obviously, not for utilities.tcl but for files I might want to put > there myself, that would change as I worked. > > --Colin ========================================================================= Date: Sun, 18 Jul 1999 21:04:47 -0700 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Colin Summers Subject: Nevermind Mime-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" No need to post my nsd.ini file, I realized that I was confusing the /NS/Admin area on my regular server port with the setup server on the special port. I see "Database Services" and all the rest now. Suggesting any changes to this is pointless, since all this has been stripped out of 3.0, right? --Colin ========================================================================= Date: Mon, 19 Jul 1999 15:32:42 -0700 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: MICHAEL JULIAN CHAN Subject: Re: AOLSERVER Digest - 10 Jul 1999 to 17 Jul 1999 In-Reply-To: <199907180404.AAA22217@services.web.aol.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII about the sybase and AOLServer 2.3.3... i've encountered that problem too.. it's not a bug though... the proxy IS timing out, and the default is 60 seconds (if you ahave a query that takes longer than 60 seconds, like a ton of selects, the link between the server and database will die... this itself hasn't caused corruption of the database as far as i can tell, but it is rather annoying... you can either split your selects into smaller units that take less than 60 seconds to complete, so you can open up new connections... OR you should increase the timeout on the proxy. (i've decided on the latter) but if you have a AOLServer SQL statement that takes 60 seconds to complete... you probably want to get faster hardware...are.. =p Snotty e/c ========================================================================= Date: Tue, 20 Jul 1999 10:16:28 -0600 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: "Michael A. Cleverly" Subject: Re: AOLSERVER Digest - 10 Jul 1999 to 17 Jul 1999 In-Reply-To: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Perhaps I'm completely blind, but where do I go to change the ext. drivers proxy i/o timeout? Is it a setting in nsd.ini? As far as needing better hardware, I'm running AOLserver 2.3.3 on a development (read: no traffic other than myself yet) dual P3-500 machine with a gig of ram and no other real services running (other than AOLserver & Sybase). I'd hope that would be sufficient... Also, where the proxy I/O errors tend to crop up is during a call to ns_db 0or1 row, so I can't break things out any smaller. Specifically, I'm building a database of books. I am using a Tcl array to cache certain info, by isbn, such as title, author, price, stock, etc. that I derive from a multi-table join. My search routine works like this: Do a like query on the books table for all the books that match the search criteria. Return a list of all the ISBNs. Then, iterate over the list of ISBNs: if the ISBN is in the cache, stream the info out to the browser; if not, do a call to ns_db 0or1row to get the info for that ISBN, cache it, and then stream it out. The ISBN is, of course, the primary key, so Sybase ought to be able to find it immediately. It seems odd that this process would work for the first 1500 books, and then randomly, take longer than 60 seconds for it to do the select on the 1501st book.... (of course, I'm new to Sybase--having used AOLserver and Solid for the past 18 months--and hence haven't tuned it much.) If I flush my internal cache and re-run the query it's never yet died at the same spot, though sometimes it has died earlier or later. I've only seen it die once before having streamed out (and hence looked up) 400 products. Wierd. Michael A. Cleverly michael@cleverly.com On Mon, 19 Jul 1999, MICHAEL JULIAN CHAN wrote: > about the sybase and AOLServer 2.3.3... i've encountered that problem > too.. it's not a bug though... the proxy IS timing out, and the default is > 60 seconds (if you ahave a query that takes longer than 60 seconds, like a > ton of selects, the link between the server and database will die... this > itself hasn't caused corruption of the database as far as i can tell, but > it is rather annoying... you can either split your selects into smaller > units that take less than 60 seconds to complete, so you can open up new > connections... OR you should increase the timeout on the proxy. (i've > decided on the latter) but if you have a AOLServer SQL statement that > takes 60 seconds to complete... you probably want to get faster > hardware...are.. > =p > > Snotty e/c > ========================================================================= Date: Tue, 20 Jul 1999 10:46:26 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Bakki Kudva Organization: Navaco Subject: Prime Host alternative??? Comments: To: prorealty MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit One of my clients just received notification that their PrimeHost account will be sold/moved to Verio, Inc. To my surprise the new service doesn't offer AOLServer/Illustra combination. My client had invested a fair amount of dollars for their Real Estate Listing site (http://www.prorealty.com/) and now is faced with the prospect of having to convert all TCL scripts to CGI/Perl scripts...and suffer a performance penalty on top of that. This seems so unfair to companies who trusted the AOL brand name and invested not only upfront but also a hefty monthly fee for the commercial level service ($199/month) to get the benefits of the AOLServer. I cannot believe that AOL chose to leave them high and dry. Does any one on this list have any info on other sites which offer AOLServer so we can avoid rewriting all the scripts and get the same level of performance. I suppose if Illustra is a problem and only mSQL or MySQL are the databases available we can still use the old scripts with minimal mods. Appreciate any help. Thank you. -bakki kudva Navaco ========================================================================= Date: Tue, 20 Jul 1999 17:31:39 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: George Nachman Subject: AOLserver 3.0 beta 2 released In-Reply-To: <199907200400.AAA10742@services.web.aol.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Important announcement! AOLserver 3.0 beta 2 has been released. As before, the binaries can be downloaded from ftp://ftp.aolserver.com/ and the source code from http://aolserver.lcs.mit.edu/. This new beta resolves a number of issues. In particular, support for Unixware and FreeBSD has been added, the Postgres module is back, the database weirdness that some people had noticed is fixed, and all open bugs with the control port have been resolved. For all the dirt, check the release notes on our web site, http://www.aolserver.com/. --George Nachman AOLserver Lead Developer ========================================================================= Date: Wed, 21 Jul 1999 00:28:58 -0400 Reply-To: philg@mit.edu Sender: Web Development with AOLserver From: Philip Greenspun Subject: Primehost alternative Comments: To: bakki@navaco.com In-Reply-To: <199907210406.AAA24608@services.web.aol.com> (message from Automatic digest processor on Wed, 21 Jul 1999 00:03:05 -0400) Date: Tue, 20 Jul 1999 10:46:26 -0400 From: Bakki Kudva Subject: Prime Host alternative??? One of my clients just received notification that their PrimeHost account will be sold/moved to Verio, Inc. To my surprise the new service doesn't offer AOLServer/Illustra combination. That IS surprising. Illustra is such a high quality system that you'd think any hosting firm would be delighted to run it for their clients... My client had invested a fair amount of dollars for their Real Estate Listing site (http://www.prorealty.com/) and now is faced with the prospect of having to convert all TCL scripts to CGI/Perl scripts...and suffer a performance penalty on top of that. This seems so unfair to companies who trusted the AOL brand name and invested not only upfront but also a hefty monthly fee for the commercial level service ($199/month) to get the benefits of the AOLServer. I cannot believe that AOL chose to leave them high and dry. Does any one on this list have any info on other sites which offer AOLServer so we can avoid rewriting all the scripts and get the same level of performance. I suppose if Illustra is a problem and only mSQL or MySQL are the databases available we can still use the old scripts with minimal mods. I think am.net is the place for you. Their monthly rates aren't too different from Primehost's and their staff is much more technical. If your client balks at am.net's rates, have them ask for a quote from us (arsdigita.com)! Philip ========================================================================= Date: Wed, 21 Jul 1999 09:54:01 EDT Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Kevin Lawver Subject: Re: AOLSERVER Digest - 19 Jul 1999 to 20 Jul 1999 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Bakki, As a former PrimeHost customer myself, I can feel your pain. Since my site was just for fun, I've decided just to let it die than to go through the painful process of finding a new host to support all of my cool little tcl widgets. The only place I know of that has a list of hosting services running an AOLserver / Db configuration is found at www.arsdigita.com. Kevin Lawver Webmaster: wacky.org In a message dated 7/20/99 11:42:27 PM Eastern Daylight Time, LISTSERV@SERVICES.WEB.AOL.COM writes: > Date: Tue, 20 Jul 1999 10:46:26 -0400 > From: Bakki Kudva > Subject: Prime Host alternative??? > > One of my clients just received notification that their PrimeHost account > will > be sold/moved to Verio, Inc. To my surprise the new service doesn't offer > AOLServer/Illustra combination. My client had invested a fair amount of > dollars for their Real Estate Listing site (http://www.prorealty.com/) and > now > is faced with the prospect of having to convert all TCL scripts to CGI/Perl > scripts...and suffer a performance penalty on top of that. This seems so > unfair to companies who trusted the AOL brand name and invested not only > upfront but also a hefty monthly fee for the commercial level service > ($199/month) to get the benefits of the AOLServer. I cannot believe that AOL > chose to leave them high and dry. > > Does any one on this list have any info on other sites which offer AOLServer > so we can avoid rewriting all the scripts and get the same level of > performance. I suppose if Illustra is a problem and only mSQL or MySQL are > the > databases available we can still use the old scripts with minimal mods. > > Appreciate any help. Thank you. > > -bakki kudva > Navaco ========================================================================= Date: Wed, 21 Jul 1999 22:33:05 -0700 Reply-To: janine@furfly.net Sender: Web Development with AOLserver From: Janine Sisk Organization: furfly.net, LLC Subject: Re: Primehost alternative MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > Date: Wed, 21 Jul 1999 00:28:58 -0400 > From: Philip Greenspun > Subject: Primehost alternative > > I think am.net is the place for you. Their monthly rates aren't too > different from Primehost's and their staff is much more technical. They can also contact my company, furfly.net (www.furfly.net). We offer AOLserver/Oracle, not Illustra, but our prices are in the same ballpark as Primehost's and Oracle is usually considered to be the database of choice when it's available. We aren't an ISP like Primehost and am.net; our primary focus is on developing sites and then hosting them, not on hosting outside developers. But we have had so many requests that we have concocted a compromise between securing our systems and giving developers a place to deploy, and it seems to be well received so far. Sorry about the shameless plug, but I just couldn't let this one go by! I e-mailed Bakki privately when he first posted, but when the discussion continued I figured I'd better jump in. janine ========================================================================= Date: Thu, 22 Jul 1999 01:40:42 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Patrick Giagnocavo Subject: Re: AOLSERVER Digest - Primehost alternative MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Automatic digest processor wrote: > Topics of the day: > > 1. Primehost alternative > Date: Wed, 21 Jul 1999 00:28:58 -0400 > From: Philip Greenspun > Subject: Primehost alternative > > Date: Tue, 20 Jul 1999 10:46:26 -0400 > From: Bakki Kudva > Subject: Prime Host alternative??? > > One of my clients just received notification that their PrimeHost account will > be sold/moved to Verio, Inc. To my surprise the new service doesn't offer > AOLServer/Illustra combination. > > That IS surprising. Illustra is such a high quality system that you'd > think any hosting firm would be delighted to run it for their > clients... I know that advertising is frowned upon in mailing lists; but I am in the midst of starting a web service/hosting company that will offer AOLserver + Postgres and/or Solid. I have used Apache and it is very fast, very good - but the interesting sites do not just serve static pages these days, which is what Apache excels at. What is needed is a fast threaded server with builtin database access, that doesn't require a bazillion modules to be compiled into it so that it does something interesting. Static site users won't know or care as long as things load quickly. But dynamic site users will be happy about the performance. I might run a LISP web server on 8080 just to see what Phil says though :-) . Cordially Patrick Giagnocavo a222@redrose.net patrick@zill.net www.zill.net (very soon) ========================================================================= Date: Thu, 22 Jul 1999 13:49:40 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Farshad Nayeri Subject: Re: Primhost alternative MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit FYI, furfly.net also hosts sites running AOLserver with Oracle backends. I have exchanged e-mail with them regarding their services and they seem pretty reasonable about the terms (but I haven't used their services yet...) > I think am.net is the place for you. Their monthly rates aren't too > different from Primehost's and their staff is much more technical. ========================================================================= Date: Fri, 23 Jul 1999 10:34:02 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Bakki Kudva Organization: Navaco Subject: Re: Primehost alternative MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > 1. Primehost alternative Thank you all for responding with alternate AOLServer sites. We are pusuing all possibilities. I certainly appreciated the fast responses. -Bakki Kudva Navaco ========================================================================= Date: Mon, 26 Jul 1999 10:19:20 -0800 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Colin Summers Subject: Chron Mime-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Boy, this is a beautiful program when it is hustling along. I cannot find anything in the manual about querying the scheduling list and removing items from it. If I have scheduled a proc, can I unschedule it? If I am going to be doing a lot of scheduling, like building a web service with calendar and reminder functions, am I better off making my own database of scheduled events, sorting so the most recent is at top, and just scheduling proc every minute that checks to see if that even needs doing? Thanks, --Colin ========================================================================= Date: Mon, 26 Jul 1999 10:58:21 -0700 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Jeff Huber Subject: Re: Chron MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Colin, Yes it is possible to unschedule a procedures in AOLserver. All the ns_schedule_* commands return an id which if passed to ns_unschedule_proc will unschedule the procedure. When you do the original ns_schedule_* you need to save this id in a ns_share (or global variable). Here is some example code to schedule an item: ns_share am_scheduleid # This info exists make sure we don't schedule it twice. if ![info exists am_scheduleid(something)] { # Schedule to run at 4AM set id [ns_schedule_daily 4 0 { ...do stuff... }] set am_scheduleid(something) $id ns_log Notice "AM something scheduled" } else { ns_log Notice "AM something already scheduled" } Then to unschedule you would do a: ns_share am_scheduleid ns_unschedule_proc $am_scheduleid(something) It's important to make sure you don't schedule a procedure more then once. With out the info exists code the procedure would be schedule every time your Tcl code is sourced. In regard to your database question, you'll be better off building your own database of scheduled events (you'll have to do this anyway) and checking the database at a regular interval. Especially if you're going to have a lot of items spanning a large amount of time. Colin Summers wrote: > > Boy, this is a beautiful program when it is hustling along. > > I cannot find anything in the manual about querying the scheduling list > and removing items from it. If I have scheduled a proc, can I unschedule > it? > > If I am going to be doing a lot of scheduling, like building a web > service with calendar and reminder functions, am I better off making my > own database of scheduled events, sorting so the most recent is at top, > and just scheduling proc every minute that checks to see if that even > needs doing? > > Thanks, > --Colin -- ---------------------------------------------- | Jeff Huber | Web Applications Developer | | jeff@am.net | AM.net - http://am.net | ---------------------------------------------- ========================================================================= Date: Mon, 26 Jul 1999 13:12:04 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Rob Mayoff Subject: Re: Chron In-Reply-To: <199907261741.NAA12680@services.web.aol.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII | I cannot find anything in the manual about querying the scheduling list | and removing items from it. If I have scheduled a proc, can I unschedule | it? In 3.0, there is no way to query the list - I checked the source. You can unschedule a proc if you save the id that was returned when you registered it. In C, use Ns_UnscheduleProc. In Tcl, use ns_unschedule_proc. | If I am going to be doing a lot of scheduling, like building a web | service with calendar and reminder functions, am I better off making my | own database of scheduled events, sorting so the most recent is at top, | and just scheduling proc every minute that checks to see if that even | needs doing? It seems to me that you'll have to keep your own list of scheduled events in your database since you can't query AS's list anyway, plus it seems likely that you'll want to use SQL queries that return scheduled events. ========================================================================= Date: Mon, 26 Jul 1999 13:20:51 -0700 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: jim@rubylane.com Subject: Re: Chron In-Reply-To: <199907261741.NAA12680@services.web.aol.com> from "Colin Summers" at Jul 26, 99 10:19:20 am Content-Type: text Procs are scheduled to run either periodically or only once. Since you would have to reschedule all the procedures at every server restart, I'd suggest you take the second approach you mentioned and have one procedure that runs every n minutes and checks for events that have occurred. If there is a chance of your scheduled procedure running longer than a minute, then you may want to schedule it using -once, then at then end of the procedure schedule it to run again in a minute. This keeps the server from starting the procedure when it is already running, plus if the procedure bombs because of a bug, it won't continue bombing every minute. You'll need to keep an ns_share variable with the last time you did a query, figure out the interval between then and now, and do the db query for the interval. Be careful with <, <=, >, >= tests and your time values, or you will have a window where events will be missed. You probably will want to store the "time last checked" variable in a file to handle server reboots. Jim www.rubylane.com > > Boy, this is a beautiful program when it is hustling along. > > I cannot find anything in the manual about querying the scheduling list > and removing items from it. If I have scheduled a proc, can I unschedule > it? > > If I am going to be doing a lot of scheduling, like building a web > service with calendar and reminder functions, am I better off making my > own database of scheduled events, sorting so the most recent is at top, > and just scheduling proc every minute that checks to see if that even > needs doing? > > Thanks, > --Colin > ========================================================================= Date: Mon, 26 Jul 1999 16:42:51 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Rob Mayoff Subject: Re: Chron In-Reply-To: <19990726202051.12100.qmail@london.rubylane.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII | If there is a chance of your scheduled procedure running longer than a | minute, then you may want to schedule it using -once, then at then end | of the procedure schedule it to run again in a minute. This keeps the | server from starting the procedure when it is already running, plus if | the procedure bombs because of a bug, it won't continue bombing every | minute. Perhaps even better would be to schedule the procedure to run when the next scheduled event is due, instead of every minute. ========================================================================= Date: Mon, 26 Jul 1999 16:15:58 -0700 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: jim@rubylane.com Subject: Re: Chron In-Reply-To: from "Rob Mayoff" at Jul 26, 99 04:42:51 pm Content-Type: text > > | If there is a chance of your scheduled procedure running longer than a > | minute, then you may want to schedule it using -once, then at then end > | of the procedure schedule it to run again in a minute. This keeps the > | server from starting the procedure when it is already running, plus if > | the procedure bombs because of a bug, it won't continue bombing every > | minute. > > Perhaps even better would be to schedule the procedure to run when the > next scheduled event is due, instead of every minute. > Could work, but the code would be trickier I think. When a new event is recorded, you would have to see if it occurs before or after the currently scheduled "next" event, unschedule the proc if the new event occurs sooner and reschedule the proc for the new event. Plus, events could be coming in during all of this, so the proc scheduling would need to be coordinated with event queueing, i.e., the web page queueing events and computing the "next" scheduled wakeup would have to be single-threaded) ========================================================================= Date: Mon, 26 Jul 1999 23:29:51 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: The Voks Sayeth Subject: TclXML MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii dunno if this package has already been discussed here.. Tcl support for generating and parsing XML. http://www.zveno.com/zm.cgi/in-tclxml/ arun _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ========================================================================= Date: Wed, 28 Jul 1999 15:36:45 -0700 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Bob Terek Subject: weird date problem MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Anyone seen this behavior? I'm using aolserver 2.3.3 on Solaris 2.5.1 and I noticed that the access.log periodically has an entry with an incorrect date. The time, year, and month are correct, but the day is wrong. Eg., 207.8.1.21 - - [27/Jul/1999:15:46:12 -0700] "GET ... 205.218.18.56 - - [38/Jul/1999:15:46:12 -0700] "GET ... 209.101.53.125 - - [27/Jul/1999:15:46:12 -0700] "GET ... The 38th of July?? It appears to happen randomly, and only a couple of times per day (out of 400,000 lines, 4 are incorrect). The incorrect day is not consistent, I have 38, 17, 28, and 21 instead of the correct day of 27. nslog just uses time, localtime_r, and strftime, right? What could be going wrong? Thanks, ------------------------------------------------------------------------ Bob Terek Web YP, Inc. Systems Engineer 291 Geary St. rterek@worldpages.com Suite 310 (415) 782-6800 x16 San Francisco, CA 94102 http://www.worldpages.com ========================================================================= Date: Fri, 30 Jul 1999 00:22:22 -0600 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: "Michael A. Cleverly" Subject: Simultaneous DB access crashes AOLserver 2.3.3 MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII For most of the past year and a half I've been running AOLserver 2.3.x on a single processor Pentium 200 running Linux 2.0.x. Recently I purchased a dual P3-500 (running Linux 2.0.36 / glibc2). I'm getting ready to deploy a new website. I tried using Sybase as the db backend but can't get AOLserver + Sybase + the ext. db driver to send data back at anything greater than 75 rows/sec. So, I decided to stick with Solid... I've found, however, that if I have two seperate page requests that hit the Solid database at the same time (grabbing only two out of the 5 db handles I have configured) that AOLserver will without fail catch an exception and die, and restart itself. (This also happens if I setup two seperate pools and have each script get a handle from a different pool.) I've tried this with Solid 2.3, Solid 2.3 MT, Solid 3.0, and Solid 3.0 MT. I can also get the server to restart from the Evaluate SQL admin page just by doing a select * from foo (where foo is a large table so it would take a sec or two to prepare the results) and then toggling to another browser window and repeating a simillar query. Again, it doesn't make a difference whether they come from the same pool or not. I've never noticed this behavior before on my old machine. I'm kind of at a loss as to what to try. I figure configuring AOLserver to only access a single pool that only has 1 handle would fix the problem, but that is obviously far from ideal.... I NEED HELP! Anyone run into this? :-) Michael A. Cleverly michael@cleverly.com ========================================================================= Date: Fri, 30 Jul 1999 14:29:00 -0600 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Ron Patterson Organization: MCI WorldCom Subject: ns_sendmail enhancement... Comments: cc: Radek Filarski , "Paul B. Wagner" Included here is a handy little hack to the _ns_sendmail proc in sendmail.tcl. Without effecting the original ns_sendmail signature you can now include a CC list (as opposed to BCC) to include in the send. It's done through the extraheaders argument. Basically, if a CC extraheader is seen then it's comma delimited items are lappended to the tolist for actual sending. For example: set body "Here is some email for you." set to "to@foo.com" set cc "to2@foo.com,to3@foo.com" set ccset [ns_set new ccset] ns_set put $ccset CC $cc ns_sendmail $to "somebody@foo.com" "Here it is" $body $ccset And here is the slightly modified _ns_sendmail code snippet: proc _ns_sendmail {smtp smtpport timeout tolist bcclist \ from subject body extraheaders} { ... ## Insert extra headers, if any (not for BCC) if ![string match "" $extraheaders] { set size [ns_set size $extraheaders] for {set i 0} {$i < $size} {incr i} { append msg "\n[ns_set key $extraheaders $i]: [ns_set value $extraheaders $i]" # ron - if CC headers, add to the To list if {[ns_set key $extraheaders $i] == "CC"} { foreach x [split [ns_set value $extraheaders $i] ","] { lappend tolist $x } } } } ... Note that this should work with all AOLserver 2.0+ and 3.0. Have fun, Ron =============================================================== Ron Patterson | MCI WorldCom (warehouseMCI) Ron.Patterson@wcom.com | 5775 Mark Dabling Blvd. 601-2386@mcimail.com | Dept. 2001/786 719-535-5727 | Colorado Springs, CO 80919 Fax: 719-535-6164 | AOL/IM: RonPDude ========================================================================= Date: Sat, 31 Jul 1999 21:19:55 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Rob Mayoff Subject: Re: Simultaneous DB access crashes AOLserver 2.3.3 In-Reply-To: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII | For most of the past year and a half I've been running AOLserver 2.3.x on | a single processor Pentium 200 running Linux 2.0.x. Recently I purchased | a dual P3-500 (running Linux 2.0.36 / glibc2). | | I'm getting ready to deploy a new website. I tried using Sybase as the db | backend but can't get AOLserver + Sybase + the ext. db driver to send | data back at anything greater than 75 rows/sec. I would just like to mention that I tested Sybase on my Linux box and discovered (by running it under strace) that it does not open its files with O_SYNC and it does not call fsync or sync. So your data is in danger of corruption if your Linux box crashes.