========================================================================= Date: Sat, 23 Mar 1996 16:37:24 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jeff Rawlings March 23, 1996 Dear NaviSoft Customer: NaviSoft has always offered our customers the best web products and services available. Over the past year we have continued to refine our features and enhance our customer support. In October, we announced the launch of NaviService, which integrated both NaviPress and NaviServer into a powerful web hosting service. We are now integrating our web hosting service into GNN (Global Network Navigator), America Online's flagship Internet Service Provider, and we announce four exciting new developments: - Renaming of the NaviSoft tools and services as GNN tools and services. - Creation of GNN Hosting Service, a powerful upgrade to our hosting technology. - Availability of our software, with full support and service, to GNN Hosting Service customers. - Availability of our tools for free, without support, to anyone on the Internet. WE'RE CHANGING OUR NAME Because of the rapid growth and success of NaviService, we have integrated our web hosting service into GNN. A subsidiary of America Online, GNN offers a total solution to the Internet, with dial-up access, a full-featured browser, e-mail, exciting content, and high-quality technical support and service. We have renamed NaviService as "GNN Hosting Service," NaviPress as "GNNpress," and NaviServer as "GNNserver." We continue our commitment to original products and services under our new name. GNN HOSTING SERVICE More than a name change, GNN Hosting Service is a powerful upgrade of our hosting technology. It offers our customers the same great features and products found in NaviService, with many new enhancements. Information about the GNN Hosting Service is available at our website: http://www.gnnhost.com/. Some highlights of the features available are: - 20 hours FREE GNN Internet Access per month - Counter Programs - SendForm Scripts for Web Page Feedback - FTP access - Enhanced Control Panel (web site administration and statistics) - SSL (Commercial and Dedicated only) - Enhanced scripting and CGI capability (Commercial and Dedicated only) - GNNpress 1.1 with authoring Wizards The GNN Hosting Service prices for each level are listed below. All service levels include 20 hours FREE Internet access. - Personal Service: $14.95 monthly and NO startup fee=20 (as part of the standard GNN Service) - Domain Service: $99 monthly, $99 startup fee - Commercial Service: $199 monthly, $149 startup fee - Dedicated: $1,499 monthly, $399 startup fee Current NaviService customers are automatically part of the GNN Hosting Service. However, to take advantage of the new features available, customers must register for the GNN Service. Before May 1, 1996, we will send all current customers information about the registration details. SOFTWARE AND SUPPORT To enhance their role and visibility in the GNN Hosting Service, we are now distributing GNNserver and GNNpress to hosting service customers, with the complete support of our customer service and technical staff. GNNpress 1.1 contains the complete functionality currently available in NaviPress 1.1, along with some enhancements. GNNserver is the latest release of NaviServer, version 2.02. We will continue to strengthen our offerings in both product and service. For all current customers, including resellers and distributors, who have purchased copies of NaviPress or NaviServer, we will provide full technical support and service through December 1996. GNN Hosting Service customers should obtain GNNpress 1.1 and GNNserver at our website: http://www.gnnhost.com/. FREE SOFTWARE We also offer unsupported versions of the standalone GNNserver and GNNpress products for free over the Internet. These replace NaviServer and NaviPress, which are no longer marketed and sold under those names. These are not "trial" versions of the products, but fully functional tools of the highest quality. These free, unsupported versions of GNNpress and GNNserver are available at http://www.tools.gnn.com. This website also contains documentation, self-help information, and answers to frequently asked questions. SUMMARY The new names for NaviSoft's tools and their incorporation into America Online's flagship Internet service are evidence of our ongoing commitment to provide the finest web hosting and web authoring and publishing tools available. We believe that the GNN Hosting Service is the finest hosting solution available today. We assure you that all the current NaviSoft staff, including Development, Customer Service, and Technical Support, will continue to provide the high-quality innovation and service that you have enjoyed in the past. If you have any questions, please contact us at (800) 879-6882 or Email info@gnnhost.com. Regards, Carlie Ross Director, GNN Hosting Services ========================================================================= Date: Sat, 23 Mar 1996 14:31:48 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Stephen Shub What will the new mailing lists & technical support sites be named? >March 23, 1996 > >Dear NaviSoft Customer: > >NaviSoft has always offered our customers the best web products and services >available. Over the past year we have continued to refine our features and >enhance our customer support. In October, we announced the launch of >NaviService, which integrated both NaviPress and NaviServer into a powerful >web hosting service. > >We are now integrating our web hosting service into GNN (Global Network >Navigator), America Online's flagship Internet Service Provider, and we >announce four exciting new developments: > >- Renaming of the NaviSoft tools and services as GNN tools and services. >- Creation of GNN Hosting Service, a powerful upgrade to our hosting > technology. >- Availability of our software, with full support and service, to GNN > Hosting Service customers. >- Availability of our tools for free, without support, to anyone on the > Internet. > >WE'RE CHANGING OUR NAME > >Because of the rapid growth and success of NaviService, we have integrated >our web hosting service into GNN. A subsidiary of America Online, GNN offers >a total solution to the Internet, with dial-up access, a full-featured >browser, e-mail, exciting content, and high-quality technical support and >service. > >We have renamed NaviService as "GNN Hosting Service," NaviPress as >"GNNpress," and NaviServer as "GNNserver." We continue our >commitment to original products and services under our new name. > >GNN HOSTING SERVICE > >More than a name change, GNN Hosting Service is a powerful upgrade of our >hosting technology. It offers our customers the same great features and >products found in NaviService, with many new enhancements. Information about >the GNN Hosting Service is available at our website: > > http://www.gnnhost.com/. > >Some highlights of the features available are: > >- 20 hours FREE GNN Internet Access per month >- Counter Programs >- SendForm Scripts for Web Page Feedback >- FTP access >- Enhanced Control Panel (web site administration and statistics) >- SSL (Commercial and Dedicated only) >- Enhanced scripting and CGI capability (Commercial and Dedicated only) >- GNNpress 1.1 with authoring Wizards > >The GNN Hosting Service prices for each level are listed below. All service >levels include 20 hours FREE Internet access. > >- Personal Service: $14.95 monthly and NO startup fee=20 > (as part of the standard GNN Service) >- Domain Service: $99 monthly, $99 startup fee >- Commercial Service: $199 monthly, $149 startup fee >- Dedicated: $1,499 monthly, $399 startup fee > >Current NaviService customers are automatically part of the GNN Hosting >Service. However, to take advantage of the new features available, customers >must register for the GNN Service. Before May 1, 1996, we will send all >current customers information about the registration details. > >SOFTWARE AND SUPPORT > >To enhance their role and visibility in the GNN Hosting Service, we are now >distributing GNNserver and GNNpress to hosting service customers, with the >complete support of our customer service and technical staff. GNNpress 1.1 >contains the complete functionality currently available in NaviPress 1.1, >along with some enhancements. GNNserver is the latest release of NaviServer, >version 2.02. > >We will continue to strengthen our offerings in both product and service. >For all current customers, including resellers and distributors, who have >purchased copies of NaviPress or NaviServer, we will provide full technical >support and service through December 1996. > >GNN Hosting Service customers should obtain GNNpress 1.1 and GNNserver at >our website: http://www.gnnhost.com/. > >FREE SOFTWARE > >We also offer unsupported versions of the standalone GNNserver and GNNpress >products for free over the Internet. These replace NaviServer and NaviPress, >which are no longer marketed and sold under those names. These are not >"trial" versions of the products, but fully functional tools of the >highest quality. > >These free, unsupported versions of GNNpress and GNNserver are available at >http://www.tools.gnn.com. This website also contains documentation, >self-help information, and answers to frequently asked questions. > >SUMMARY > >The new names for NaviSoft's tools and their incorporation into America >Online's flagship Internet service are evidence of our ongoing commitment >to provide the finest web hosting and web authoring and publishing tools >available. We believe that the GNN Hosting Service is the finest hosting >solution available today. We assure you that all the current NaviSoft staff, >including Development, Customer Service, and Technical Support, will >continue to provide the high-quality innovation and service that you have >enjoyed in the past. > >If you have any questions, please contact us at (800) 879-6882 or Email >info@gnnhost.com. > >Regards, > >Carlie Ross >Director, GNN Hosting Services <<>><<>><<>><<>><<>><<>><<>><<>><<>><<>> < Stephen Shub > < S.M.I. Innovations > < 510-339-1700 > < www.crafts.net / www.deadart.com > < www.deadart.com/deadwatch > < here, there & everywhere! > <<>><<>><<>><<>><<>><<>><<>><<>><<>><<>> ========================================================================= Date: Sun, 24 Mar 1996 23:31:38 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: dave whittle Subject: Re: And another one, this one easy. Comments: To: Doug McKee Comments: cc: naviserver-users@NAVISOFT.COM In-Reply-To: <199603221945.LAA29321@navisoft.com> On Fri, 22 Mar 1996, Doug McKee wrote: > 1. Do what we do and create a C module that initializes the > Tcl. If you're not writing any other C, then this is > unnecessary. What is the syntax to do this? I have a case where the Tcl can not be loaded until after my module is loaded, so the script (or something to init it) can not exist in the base dir to be started during the server startup. I would be most grateful for that piece of code. Thanks, Dave ========================================================================= Date: Mon, 25 Mar 1996 11:23:30 MET Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: "Jacek Banaszczyk `Baniaczek`" Organization: Agora Gazeta Subject: Thanks: NaviServer @ NT Comments: To: naviserver-users@NAVISOFT.COM Thanks to everybody for advices. All forms like printf("Content-type: text/html\n\n"); printf("Test Page"); printf("Hellooooooo!!\n"); works fine. -------------------------------------- It was enough to put printf("\n"); as the first output from my program. This one works both as CGI and SSI: #include int main () { printf("\n"); printf("Hello - why not ?\n"); return 0; } #----------------------------------------------------------------- #- Jacek Banaszczyk `Wielki Baniaczek`, Network Supervisor, CNE #- Agora Gazeta, Nowy Swiat 27, 00-029 Warszawa, Poland #- Tel: (0-22) 263015, Fax: (0-22) 261434, e-mail: golem@gazeta.pl #- P.S. Wszystkie nazwiska, imiona, nazwy, fakty i terminy zostaly zmienione. .... Wszelka zbieznosc z rzeczywistoscia jest przypadkowa .... i nie byla zamierzona. P.S. All names, facts and terms have been changed. .... Any convergence to reality is incidental and was not intended. ========================================================================= Date: Mon, 25 Mar 1996 15:34:25 +0100 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Gaute Amundsen Subject: Full text crashes.. Comments: To: naviserver-users@NAVISOFT.COM First, thanks a lot for all the response to my questions about TCL initilalisation and tables vs. database. The smal script from Doug McKee works perfectly, and the thread about tables vs. database conviced me to use a separate DB. Now I have another problem, after finaly getting the fulltext search working on our 2.0 NT3.51 sever by adding "|\.HTM$|\.HTML$" to /nstext/sync.tcl like this proc gethtmlfiles {dir} { getallfiles $dir {\.htm$|\.html$|\.HTM$|\.HTML$} } I discovered that a search for our company name, GIL, or Grafisk InterLink will crash the server. Not just the virtual server either, but the whole lot, drwatson32 reporting "access voilation". The drwatson32 log is bitt large to include here. Has anyone had a similar expirience, or can shed any light on this? Gaute -- ----------------------------------------------------------------- Gaute Amundsen "Technology today is the campfire gaute@nipnett.no around which we tell our stories. There's this attraction to light and to this kind of power, which is both warm and destructive." Laurie Anderson http://www.gil.no/users/g/gaute -------------------------------------------------------------------- ========================================================================= Date: Mon, 25 Mar 1996 15:52:56 +0100 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Michael Juergens Organization: Crocodial Communications Jeff Rawlings wrote: > > March 23, 1996 > > Dear NaviSoft Customer: > FREE SOFTWARE > > We also offer unsupported versions of the standalone GNNserver and GNNpress > products for free over the Internet. These replace NaviServer and NaviPress, > which are no longer marketed and sold under those names. These are not > "trial" versions of the products, but fully functional tools of the > highest quality. > > These free, unsupported versions of GNNpress and GNNserver are available at > http://www.tools.gnn.com This website also contains documentation, > self-help information, and answers to frequently asked questions. > What about the illustra Database. When I download the ilustra Database, the only way to get a license key is by registering as a trial user. How can I get a permanent key and what does it cost? Best regards, Michael Juergens michael@crocodial.de Crocodial Communications Ophagen 16a D-20257 Hamburg Tel: +49.40.853264-0 Fax: +49.40.853264-64 ------------------------- ========================================================================= Date: Mon, 25 Mar 1996 13:21:51 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Aleotta@aol.com Subject: Simple TCL Example Hi, I downloaded the Post Script Doc sets, printed them out, and created a simple database. Is there a quick simple example written in TCL that does the following: Connects to a named database Does a select, Prints the result set to an HTML page. Does an insert, Prints the status to an HTML page. Does an update, Prints the status to an HTML page. Does an delete, Prints the status to an HTML page. (Yes I did study the code that Naviservice uses for database table maintenance....but isn't it just a little bit too complicated and very poorly documented.) I have used TCl before (with TK) to make GUI apps. I have a great deal of experience with Illustra and SQL, so that's not the problem....The problem is the ns_db call... and other ns database calls. They are poorly documented. Good documentation, has an example of the use of each call on the man page. In the NS doc set the all of the options of the ns_db call are lumped onto two pages!!! Really you can do better than that!!! I will be going to the dedicated service soon, and I plan to build all by stuff in C++, but for now I want to do some stuff and all I have is TCL.. Can anybody please help??? -Tony ========================================================================= Date: Mon, 25 Mar 1996 12:32:47 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee Subject: Re: And another one, this one easy. In-Reply-To: (message from dave whittle on Sun, 24 Mar 1996 23:31:38 -0500) >>>>> "Dave" == dave whittle writes: Dave> On Fri, 22 Mar 1996, Doug McKee wrote: >> 1. Do what we do and create a C module that initializes the >> Tcl. If you're not writing any other C, then this is >> unnecessary. Dave> What is the syntax to do this? I have a case where the Tcl Dave> can not be loaded until after my module is loaded, so the Dave> script (or something to init it) can not exist in the base Dave> dir to be started during the server startup. I would be most Dave> grateful for that piece of code. Here's a function (Ns_MyInitTcl) that shows what you want. You'll want to call it from your module initialization routine. static int MyInterpInit(Tcl_Interp *interp, void *context) { char *init; init = (char *) context; if (Tcl_Eval(interp, init) != TCL_OK) { Ns_TclLogError(interp); Ns_Log(Error, "Could not initialize mymodule Tcl."); return NS_ERROR; } } int Ns_MyInitTcl(char *hServer, char *hModule) { static char init[] = "ns_inittcl mymodule"; /* MyInterpInit will be called with each Tcl interpreter allocated for this virtual server. */ return (Ns_TclInitInterps(hServer, MyInterpInit, (void *) init)) } ========================================================================= Date: Mon, 25 Mar 1996 12:56:08 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee Subject: Re: Full text crashes.. In-Reply-To: (message from Gaute Amundsen on Mon, 25 Mar 1996 15:34:25 +0100) > after finaly getting the fulltext search working on our 2.0 NT3.51 sever > by adding "|\.HTM$|\.HTML$" to /nstext/sync.tcl like this > > proc gethtmlfiles {dir} { > getallfiles $dir {\.htm$|\.html$|\.HTM$|\.HTML$} > } This will work; it is a bug that is fixed in the latest release (GNNserver 2.02) by making the getallfiles function case insensitive for NT. > I discovered that a search for our company name, GIL, or Grafisk > InterLink will crash the server. Not just the virtual server > either, but the whole lot, drwatson32 reporting "access voilation". This sounds bad; I've never seen it before. Put your database pool in verbose mode so that the SQL for the search is written to the log. Then try executing this SQL through nsql, msql, or IQT -- does it crash Illustra or give any weird errors? doug -- ---------------------------------------------------------------- Doug McKee America Online, Inc. Email: doug@tools.gnn.com 511 Bath Street Voice: (800) 529-9166 Santa Barbara, CA (805) 882-2350 93101 Fax: (805) 899-4316 http://www.tools.gnn.com ---------------------------------------------------------------- ========================================================================= Date: Mon, 25 Mar 1996 13:10:50 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee In-Reply-To: <3156B348.13C8@crocodial.de> (message from Michael Juergens on Mon, 25 Mar 1996 15:52:56 +0100) > What about the illustra Database. When I download the ilustra > Database, the only way to get a license key is by registering as a > trial user. How can I get a permanent key and what does it cost? If you register to download Illustra at the http://www.tools.gnn.com web site, you will be mailed a 10-year host-independant license key that will let you use Illustra with the GNNserver or with the "nsql" program that comes with GNNserver. nsql is a command-line SQL interpreter that will not let you execute some advanced Illustra commands including: create/drop aggregate create/drop cast create/drop function create/drop operator create/drop type create/drop version open, close, fetch, declare cursor To use these commands, you need a full Illustra license. For more information about doing so, contact Jim Mongillo (monge@illustra.com) at Illustra. So, the short answer is, even GNNserver is now free, you still get Illustra! doug -- ---------------------------------------------------------------- Doug McKee America Online, Inc. Email: doug@tools.gnn.com 511 Bath Street Voice: (800) 529-9166 Santa Barbara, CA (805) 882-2350 93101 Fax: (805) 899-4316 http://www.tools.gnn.com ---------------------------------------------------------------- ========================================================================= Date: Mon, 25 Mar 1996 18:31:07 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jeff Rawlings Subject: User Groups for GNN hosting and tools Comments: To: gnnhost-l@services.web.aol.com By now, I think you've all seen our announcement that NaviService and NaviSoft are joining GNN. Along with that change, we are making a couple of minor modifications to our User Groups (electronic mailing lists). Formerly we had the naviservice-l list and the naviserver-users list. Those lists have become gnnhost-l and gnndeveloper-l. This change has already happened and should be transparent to you, although you might have noticed receiving list traffic from a new address. Both of our user groups are open to anyone, although each has a different focus (described in more detail below). To join or signoff either list, you can go to our website: http://www.gnnhost.com/develop/group/group.htm Or, you can send mail to listserv@services.web.aol.com with instructions, such as: signoff GNNHOST-L subscribe GNNDEVELOPER-L set GNNHOST-L nodigest set GNNDEVELOPER-L digest The following is a description of topics for each list. GNNHOST-L Creating and editing Web pages with GNNpress software. Web hosting issues, including tips for getting the most out of the GNN Hosting Service. Internet marketing tips and discussion. Helpful critiques of your Web site. Who should join: All members of the GNN Hosting Service. Anyone using GNNpress to author websites. GNNDEVELOPER-L Managing and administering sites with GNNserver software. Creating database-enabled Web applications. Extending GNNserver with Tcl scripts or C modules. Who should join: Commercial and Dedicated members of the GNN Hosting Service. Anyone using GNNserver 2.0 software. If you have any questions, please feel free to ask! That's what these lists are for. Cheers, Jeff Rawlings rawlings@gnnhost.com Webmaster, GNN Hosting Service http://www.gnnhost.com/ Moderator, gnnhost-l and gnndeveloper-l For inquiries about Web Hosting, send email to ========================================================================= Date: Mon, 25 Mar 1996 17:30:44 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: David Sklar Subject: gnnserver accepting connections, not stopping nicely In-Reply-To: <199603252110.NAA25298@navisoft.com> I am having a weird problem with GNNserver on windows NT. Every so often, between 5 minutes and a few hours, my lone virtual server on port 80 will stop sending stuff out. It still accepts connections on port 80, just returns no data. the setup server works fine. Everything was working fine until about a week ago. Since then, I've upgraded from NaviServer 2.0 to GNNserver 2.02 to no avail. The only difference in what's on the server is some new Tcl scripts. The scripts work fine, though, and since the setup server always returns nice and speedily, I don't think it's a matter of a script running amok and eating resources. Any thoughts? thanks. -dave ========================================================================= Date: Mon, 25 Mar 1996 17:42:48 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: David Sklar Subject: gnnserver logfile analysis with webtrends In-Reply-To: <199603252110.NAA25298@navisoft.com> After a brief and unsatisfying flirt with wwwstat, I'm trying to to logfile analysis with WebTrends. It, however, is complaining that my logfiles aren't in Common Log Format. I save referrer and user-agent to the logfile, and I thought that this adheres to the "Combined Log File Format" standard which WebTrends professes to support. Is there some perlification I need to run my logfiles through to make the true-blue Combined Log Files or should I be complaining to WebTrends? Thanks. -dave ========================================================================= Date: Mon, 25 Mar 1996 15:57:31 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jim Davidson Subject: Re: gnnserver accepting connections, not stopping nicely At 05:30 PM 3/25/96 -0500, David Sklar wrote: >I am having a weird problem with GNNserver on windows NT. Every so often, >between 5 minutes and a few hours, my lone virtual server on port 80 will >stop sending stuff out. It still accepts connections on port 80, just >returns no data. the setup server works fine. > >Everything was working fine until about a week ago. Since then, I've >upgraded from NaviServer 2.0 to GNNserver 2.02 to no avail. The only >difference in what's on the server is some new Tcl scripts. The scripts >work fine, though, and since the setup server always returns nice and >speedily, I don't think it's a matter of a script running amok and eating >resources. I'm guessing the connection threads of your virtual server are getting hung up on idle connections because the Timeout parameter of the nssock module is not set or set to 0 (infinite) which was the old default of NaviServer 2.0. Try setting Timeout to 120 (two minutes) and see if the problem goes away. -Jim _________________________________________________ Jim Davidson | jimbo@navisoft.com Navisoft Inc. | Voice: (800) 529-9166 511 Bath Street | Fax: (805) 899-4316 Santa Barbara, CA 93101 | ========================================================================= Date: Mon, 25 Mar 1996 16:43:45 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jim Davidson Subject: Re: gnnserver logfile analysis with webtrends At 05:42 PM 3/25/96 -0500, David Sklar wrote: >After a brief and unsatisfying flirt with wwwstat, I'm trying to to >logfile analysis with WebTrends. It, however, is complaining that my >logfiles aren't in Common Log Format. > >I save referrer and user-agent to the logfile, and I thought that this >adheres to the "Combined Log File Format" standard which WebTrends >professes to support. > >Is there some perlification I need to run my logfiles through to make the >true-blue Combined Log Files or should I be complaining to WebTrends? Hello, I just looked at the combined log format at NCSA and I think what might be the problem is that GNNserver doesn't always surround the referer and user-agent fields with double quotes. It only adds quotes if there are embedded spaces in the fields and referrer doesn't normally have spaces. We don't have WebTrends here so I can't test it. Try adding quotes and see if WebTrends is happy. If so, I'll patch the nslog module for the 2.03 release. Cheers, -Jim _________________________________________________ Jim Davidson | jimbo@navisoft.com Navisoft Inc. | Voice: (800) 529-9166 511 Bath Street | Fax: (805) 899-4316 Santa Barbara, CA 93101 | ========================================================================= Date: Mon, 25 Mar 1996 17:10:45 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Stephen Shub Subject: what's the difference What's the difference between NaviServer 2.0 & GNNServer 2.02. Should I download it or not? <<>><<>><<>><<>><<>><<>><<>><<>><<>><<>> < Stephen Shub > < S.M.I. Innovations > < 510-339-1700 > < www.crafts.net / www.deadart.com > < www.deadart.com/deadwatch > < here, there & everywhere! > <<>><<>><<>><<>><<>><<>><<>><<>><<>><<>> ========================================================================= Date: Mon, 25 Mar 1996 20:42:47 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: David Sklar Subject: Re: gnnserver accepting connections, not stopping nicely In-Reply-To: <2.2.32.19960325235731.0073873c@199.221.53.18> On Mon, 25 Mar 1996, Jim Davidson wrote: > I'm guessing the connection threads of your virtual server are getting hung > up on idle connections because the Timeout parameter of the nssock module is > not set or set to 0 (infinite) which was the old default of NaviServer 2.0. > Try setting Timeout to 120 (two minutes) and see if the problem goes away. This didn't help. I also tried smaller timeouts (like 30) and larger timeouts (like 360). I also tried send and receive buffer sizes from 2048 - 8192 bytes and max connections held from 24 to 64 with no luck. -dave ========================================================================= Date: Mon, 25 Mar 1996 18:50:01 -0700 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: "Anderson, Hans" Organization: M@RSweb Subject: Re: gnnserver logfile analysis with webtrends David Sklar wrote: > > After a brief and unsatisfying flirt with wwwstat, I'm trying to to > logfile analysis with WebTrends. It, however, is complaining that my > logfiles aren't in Common Log Format. > > I save referrer and user-agent to the logfile, and I thought that this > adheres to the "Combined Log File Format" standard which WebTrends > professes to support. > > Is there some perlification I need to run my logfiles through to make the > true-blue Combined Log Files or should I be complaining to WebTrends? > > Thanks. > > -dave Dave, I had the same trouble, what you need to do is go to the server setup, then to the virtual server you are working on, and finally to the nslog.dll module setup screen. Make sure the upper right corner has "expert," click it if it doesn't. The third or fourth option on this screen is for logging user-agents, turn it off. Restart Naviserver and cycle your log to eliminate any user-agent loggins. Now Webtrends will work. The problem I had was not wanting to leave the server open and logged in when I wasn't around. I couldn't figure out a way to let Webtrends run in the background while no one was logged in. If you figure one out, let me know, I'm no NT expert. Personally, I moved on to Access Watch, though it's a slow PERL script, it does a super job and it's really easy to set up. I'm waiting for the Statbot(SP?) port to NT, I've heard that program rules. -- Hans Anderson -=-=-=-=-=-=-=-= M@RSweb, Internet Services Montana http://www.marsweb.com | http://www.ism.net webmaster@marsweb.com | (406) 721-6277 288 Expressway, Missoula, MT 59806 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Things usually turn out best for those who make the best of the way things turn out. ========================================================================= Date: Tue, 26 Mar 1996 02:03:57 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug Lakin Subject: Steve Case: Are you listening? Comments: cc: gnnhost-l@SERVICES.WEB.AOL.COM Once again, a very large and well funded start-up is making in-roads on AOL's Internet turf. This is a full-frontal assault by bringing a Web hosting service FRANCHISE to the customer's front door: USWeb is a joint venture among the management team of the company, Ziff-Davis Publishing, and Softbank, Inc., a multi-billion dollar enterprise and the largest software distributor in Japan, whose holdings in the United States include Ziff-Davis Publishing and the COMDEX trade show. In an investment from Softbank, Crosspoint Venture Partners of Los Altos, CA, and the Cutler Group of Newport Beach, CA, USWeb Corporation received approximately $17 million in capital commitments. Beyond Softbank's capital contribution, Softbank and Ziff-Davis are committed to leveraging their collective resources to advance the USWeb enterprise. A significant number of new strategic initiatives linking USWeb, Ziff-Davis, and Softbank ventures will be announced over coming months. USWeb's central hosting services will come on-line this year, enabling you to provide your customers with the pinnacle in performance, reliability, and scalability for their remote-hosted Web sites. You or your customers continue to manage the hosted content directly, and we help make sure that the systems meet your needs. USWeb is also creating and building what will become one of the world's largest libraries of sophisticated templates for building leading-edge Web sites. This year, USWeb's Application Library will provide reusable media and logic components and templates built around customer business processes, dramatically simplifying the process of building robust, immersive Web sites. USWEB NETWORK To accomplish this mission, USWeb Corporation is establishing the USWeb Network - a worldwide affiliation of local USWeb Centers, each providing a consistent level of Web-related professional services, along with resale of Internet access, hardware, and software products from third parties. USWeb Corporation and its partners will provide economies of scale to USWeb affiliates, enabling them to offer unparalleled services to their customers. For the big picture on this, this diagram says it all: http://www.usweb.com/intro/co/netdia.html Of course, this is all too familiar to us: http://www.telecommerce.com/users/t/telcmktg/pr.MW2/pr951006.html We just didn't have the $17 mil to pull it off 8^\ (not whining, just dejected...). prez://Doug Lakin from://TeleCommerce, Inc./9452 Telephone Road #246/Ventura CA/93004 phon://805-658-0201 TeleCommerce, Inc. is.....Internets, Intranets, Virtual Private Nets, Web Services, Electronic Commerce, Enterprise E-mail, Surf 'N' Pub, Design2Web, Fax2Web, Voice2Web, Video2Web, Print2Web, http://www.TeleCommerce.com, ..... ========================================================================= Date: Tue, 26 Mar 1996 12:03:59 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: David Sklar Subject: Re: gnnserver logfile analysis with webtrends In-Reply-To: <2.2.32.19960326004345.00970610@199.221.53.18> On Mon, 25 Mar 1996, Jim Davidson wrote: > I just looked at the combined log format at NCSA and I think what might be > the problem is that GNNserver doesn't always surround the referer and > user-agent fields with double quotes. It only adds quotes if there are > embedded spaces in the fields and referrer doesn't normally have spaces. We > don't have WebTrends here so I can't test it. Try adding quotes and see if > WebTrends is happy. If so, I'll patch the nslog module for the 2.03 release. Yup, that did the trick. Here's the bit of perl that i used to do it, if anyone else is interested... while (<>) { ($host, $rfc931, $authuser, $timestamp, $request, $status, $bytes, $referrer, $agent) = /^(\S+) (\S+) (\S+) \[(.+)\] \"(.+)\" (\S+) (\S+) (\S+) \"([\S ]+)\"$/; print "$host $rfc931 $authuser [$timestamp] \"$request\" $status $bytes \"$referrer\" \"$agent\"\n"; } -dave ========================================================================= Date: Tue, 26 Mar 1996 09:53:41 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Wendy Liu Subject: Re: gnnserver accepting connections, not stopping nicely Hi, I'm running also NaviServer 2.0, but on Solaris, and I think we are having exactly the same symptom. I also just tried using the timeout value of 120 as suggested, and it got hung up again right away within 10 minutes. Please help! Thanks! Wendy Liu Infowave Communications >On Mon, 25 Mar 1996, Jim Davidson wrote: > >> I'm guessing the connection threads of your virtual server are getting hung >> up on idle connections because the Timeout parameter of the nssock module is >> not set or set to 0 (infinite) which was the old default of NaviServer 2.0. >> Try setting Timeout to 120 (two minutes) and see if the problem goes away. > >This didn't help. I also tried smaller timeouts (like 30) and larger >timeouts (like 360). I also tried send and receive buffer sizes from 2048 >- 8192 bytes and max connections held from 24 to 64 with no luck. > >-dave > ========================================================================= Date: Tue, 26 Mar 1996 13:18:18 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: David Sklar Subject: more on gnnserver accepting connections and then not sending stuff out In-Reply-To: <31574D49.4A93@marsweb.com> When a request for a page generated by a Tcl script is made, and the server is in a state that it doesn't send anything out on that socket, this gets written to the server.log: [i turned on all the debugging]: [26/Mar/1996:13:13:07 -0500][171.43] Debug: Ns_TclAllocateInterp(student_net): Waiting for queue event. What does this mean? It seems like the server is getting in this state after an 'ns_db select' that returns a lot followed by a loop with lots of 'ns_db getrow's Also, sometimes in this state the server can serve pages that are static files, sometimes it just doesn't send anythng out. -dave ========================================================================= Date: Tue, 26 Mar 1996 14:55:37 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Kristofer Munn Subject: Sending mail from NT Server CGI script I'm running GNNServer 2.0 on Win NT 3.51 Server and I'm looking to send mail from a Perl CGI script. Normally under Unix, I'd simply write a script to spoof the sendmail daemon with whatever from and to address I wanted. Under NT, I am unsure as to how to proceed. Any suggestions or sample scripts? Thanks. Kristofer Munn NetLive Communications kmunn@NetLiveCom.com Manhattan, NY, USA ========================================================================= Date: Tue, 26 Mar 1996 13:56:12 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jim Davidson Subject: Re: more on gnnserver accepting connections and then not sending stuff out At 01:18 PM 3/26/96 -0500, David Sklar wrote: >When a request for a page generated by a Tcl script is made, and the >server is in a state that it doesn't send anything out on that socket, >this gets written to the server.log: [i turned on all the debugging]: > >[26/Mar/1996:13:13:07 -0500][171.43] Debug: Ns_TclAllocateInterp(student_net): Waiting for queue event. > >What does this mean? This means that a connection thread tried to allocate a Tcl interpreter from the pool and found that they were all in use in which case it goes to sleep waiting for the "interp ready" event. This is normal operation assuming an interpreter eventually becomes ready. >It seems like the server is getting in this state after an 'ns_db >select' that returns a lot followed by a loop with lots of >'ns_db getrow's How many is a lot? >Also, sometimes in this state the server can serve pages that are static >files, sometimes it just doesn't send anythng out. This makes sense - you have DB related scripts which are hanging up and not releasing the Tcl interpreters. Ordinary connections can keep running as long as they don't need a Tcl interpreter. Of course if more requests for the script keep coming in, eventually the server will hang altogether as all the connection threads are waiting for the Tcl queue event described below. All this sounds like the problem is in your Tcl script. Is it possible the script is going into an infinite loop? Can you send a fragment from the script which is hanging? Cheers, -Jim _________________________________________________ Jim Davidson | jimbo@navisoft.com Navisoft Inc. | Voice: (800) 529-9166 511 Bath Street | Fax: (805) 899-4316 Santa Barbara, CA 93101 | ========================================================================= Date: Tue, 26 Mar 1996 17:19:06 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jeff Rawlings Subject: Re: Sending mail from NT Server CGI script At 02:55 PM 3/26/96 -0500, you wrote: >I'm running GNNServer 2.0 on Win NT 3.51 Server and I'm looking to send >mail from a Perl CGI script. Normally under Unix, I'd simply write a >script to spoof the sendmail daemon with whatever from and to address I >wanted. Under NT, I am unsure as to how to proceed. > >Any suggestions or sample scripts? Thanks. If you use the server's Tcl API, you can use ns_sendmail... There are a couple of example scripts in the Developer's Corner: http://www.gnnhost.com/develop/code/index.htm Regards, Jeff Rawlings rawlings@gnnhost.com Webmaster, GNN Hosting Service http://www.gnnhost.com/ Moderator, gnnhost-l and gnndeveloper-l For inquiries about Web Hosting, send email to ========================================================================= Date: Tue, 26 Mar 1996 21:37:51 GMT Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Ken Fricklas Organization: Boulder Community Net/AND Interactive Subject: Re: gnnserver logfile analysis with webtrends In-Reply-To: <31574D49.4A93@marsweb.com> You wrote ... > >The problem I had was not wanting to leave the server open and logged in >when I wasn't around. I couldn't figure out a way to let Webtrends run >in the background while no one was logged in. If you figure one out, >let me know, I'm no NT expert. >-- >Hans Anderson > The NT Resource kit ships with a utility called SRVANY.EXE, which allows you to run any NT 32-bit app as a service. Have it start automatically, or run the scheduler as a service and have it kick off Webtrends for you. ==================================================== Ken Fricklas -- AND Interactive. Boulder Community Net A&E Coordinator http://bcn.boulder.co.us/ ==================================================== ========================================================================= Date: Tue, 26 Mar 1996 17:04:34 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: "Peter M. Jansson" Subject: ns_user documented? I see from reading the Tcl scripts for nsperm that there is a function called ns_user which can be used to create new user accounts, but I can't find documentation on it online. Where is this function documented? I'm trying to set up something where I would collect more registration information when establishing a new user, so I want to do more than the current new user script. Pete. ========================================================================= Date: Tue, 26 Mar 1996 18:17:23 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: David Sklar Subject: Re: more on gnnserver accepting connections and then not sending stuff out In-Reply-To: <2.2.32.19960326215612.0082f7e0@199.221.53.18> > >It seems like the server is getting in this state after an 'ns_db > >select' that returns a lot followed by a loop with lots of > >'ns_db getrow's > > How many is a lot? anything more than about 500 > All this sounds like the problem is in your Tcl script. Is it possible the > script is going into an infinite loop? Can you send a fragment from the > script which is hanging? I will rescrutinize my scripts -- I sort of suspected that this might be the cause of the problem, but all of my scripts appear (to the end user) to be working OK -- pages get returned, db operations done, so the loop is really sneaky, I guess... -dave ========================================================================= Date: Wed, 27 Mar 1996 10:37:12 +1100 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Chris Smoother Subject: Re: ns_user documented? The users.tcl script in the nsperm directory is where the adduser and adduserform procedures live. By modifying the adduserform proc in users.tcl you can change the layout and form data of the add user form, which is where you would add the form data you require for new users. The adduser proc lets you modify the processing of the form data and the creation of the new user. We modified this section of the script to create new user directories in the root directory rather than /users/initial/user which is the default. I'm not aware of any documentation on these scripts, but maybe someone at Navisoft/GNN can point you to something. >I see from reading the Tcl scripts for nsperm that there is a function >called ns_user which can be used to create new user accounts, but I can't >find documentation on it online. Where is this function documented? I'm >trying to set up something where I would collect more registration >information when establishing a new user, so I want to do more than the >current new user script. > >Pete. Regards Chris Smoother chris@firmware.com.au ========================================================================= Date: Tue, 26 Mar 1996 17:18:45 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Infowave Subject: Re: more on gnnserver accepting connections and then not sending stuff out Hi Jim, Well, looks like our situation is different from David's afterall. I also truned on all the debugging, and could not see anything about "waiting for queue event" in our log. So I assume our problem is different. But the symptom sure looks similar. Currently we have in our configuation file, maxthread=200, sendbuffersize and receivebuffersize=32K, and timeout=120. And every now and then, it's not sending back any response at all. From the browser, you would only the message "Server contacted, waiting for reply", and it hangs there for quite a long time (long from a surfer's point of view). Looking at the server.log, it typically prints out "wating for connection, and new connection accepted very fast". But when the hang up symptom occurs, it seems to be stuck with "wating for connection". Any clue what is going on?? Thanks in advance, Wendy Liu http://www.ccchome.com ========================================================================= Date: Wed, 27 Mar 1996 09:34:09 -0700 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: "Anderson, Hans" Organization: M@RSweb Subject: Re: Sending mail from NT Server CGI script Kristofer Munn wrote: > > I'm running GNNServer 2.0 on Win NT 3.51 Server and I'm looking to send > mail from a Perl CGI script. Normally under Unix, I'd simply write a > script to spoof the sendmail daemon with whatever from and to address I > wanted. Under NT, I am unsure as to how to proceed. > > Any suggestions or sample scripts? Thanks. > > Kristofer Munn NetLive Communications > kmunn@NetLiveCom.com Manhattan, NY, USA There is a NT command line e-mail program called Blat! (do a search in at webcrawler) that you can refer to in order to send e-mail messages. It needs the TO: FROM: SUBJECT: and body, and it has quite a few switches to go with it. I'm sure there are other ways, but that is a program I have used before, though not for your purpose. I have had several friends use it for similar purposes with great success. -- Hans Anderson -=-=-=-=-=-=-=-= M@RSweb, Internet Services Montana http://www.marsweb.com | http://www.ism.net webmaster@marsweb.com | (406) 721-6277 288 Expressway, Missoula, MT 59806 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Things usually turn out best for those who make the best of the way things turn out. ========================================================================= Date: Wed, 27 Mar 1996 12:37:53 -0600 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jack Lemcke Subject: Counter I have attemped to setup the counter.so on the irix gnnserver. I noticed the counter.c file as well. It was brought to my attention that the counter file has EOL characters and will not work on unix. Do the EOL have to be removed from the counter.c file and then recompiled to the module format? Thanks, jack ========================================================================= Date: Wed, 27 Mar 1996 12:55:51 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Alex Khassin Subject: Illustra Debug Logging In-Reply-To: <199603252110.NAA25298@navisoft.com> I remember seeing somewhere either in the installation program or in the setup server or some sort of documentation that it is possilbe to enable Debug-type logging for Illustra, so that all the SQL statements are logged. Can't seem to be able to find that information now. How can this be done? ------------ Alex Khassin AM Computers The Source for Advanced Computing Solutions http://am.net ========================================================================= Date: Wed, 27 Mar 1996 13:29:43 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jim Davidson Subject: Re: Counter At 12:37 PM 3/27/96 -0600, Jack Lemcke wrote: >I have attemped to setup the counter.so on the irix gnnserver. I noticed >the counter.c file as well. It was brought to my attention that the >counter file has EOL characters and will not work on unix. Do the EOL have >to be removed from the counter.c file and then recompiled to the module >format? The counter module comes pre-compiled and ready to use. You shouldn't need to recompile it. Cheers, -Jim _________________________________________________ Jim Davidson | jimbo@navisoft.com Navisoft Inc. | Voice: (800) 529-9166 511 Bath Street | Fax: (805) 899-4316 Santa Barbara, CA 93101 | ========================================================================= Date: Wed, 27 Mar 1996 14:23:11 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee Subject: Re: Illustra Debug Logging In-Reply-To: <19960327205551.akhassin@am.net> (message from Alex Khassin on Wed, 27 Mar 1996 12:55:51 -0800) >>>>> "Alex" == Alex Khassin writes: Alex> I remember seeing somewhere either in the installation Alex> program or in the setup server or some sort of documentation Alex> that it is possilbe to enable Debug-type logging for Alex> Illustra, so that all the SQL statements are logged. Alex> Can't seem to be able to find that information now. How can Alex> this be done? If you put your database pool in Verbose mode, the server will log all SQL statements. You can do this through the Setup Server. doug -- ---------------------------------------------------------------- Doug McKee America Online, Inc. Email: doug@tools.gnn.com 511 Bath Street Voice: (800) 529-9166 Santa Barbara, CA (805) 882-2350 93101 Fax: (805) 899-4316 http://www.tools.gnn.com ---------------------------------------------------------------- ========================================================================= Date: Wed, 27 Mar 1996 16:33:02 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Michael Kmiec Subject: Re: Illustra Debug Logging In the [ns\module\nsdb\pool\] section of the config file, there is a radio option to turn "Verbose" on, off or unspecified. This sends all the SQL calls right to the server.log. Not particularly interesting reading, but helpful nonetheless. At 12:55 PM 3/27/96 -0800, you wrote: >I remember seeing somewhere either in the installation program or in the >setup server or some sort of documentation that it is possilbe to enable >Debug-type logging for Illustra, so that all the SQL statements are logged. > >Can't seem to be able to find that information now. How can this be done? > > >------------ >Alex Khassin >AM Computers >The Source for Advanced Computing Solutions >http://am.net > > ------------------------------------------------------ Michael Kmiec PFN Incorporated 26 Landsdowne Street Cambridge, MA 02139 mike@pfn.com 617.494.9980 ========================================================================= Date: Wed, 27 Mar 1996 16:25:43 -0700 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: "Anderson, Hans" Subject: TCL mail script Jeff, I was wondering if there was a way to include an attachment in your sendmail.tcl script... I would like to send a .jpf file as an auto-reply, but it doesn't appear to be a function, at least in the auto-reply template. Any ideas? BTW, I was also wondering if you could update the nslog.dll file to include a cycle by date... I would like to have the logs based on months (cycle on the 1st, or something), instead of by size. Thanks for your help, Hans ______M@RSweb, Montana's Premiere Web Site_______ Hans Anderson | Webmaster | webmaster@marsweb.com http://www.marsweb.com | http://www.ism.net (406) 721-MARS | 288 Expressway | Missoula, MT 59806 *** Why be yourself when you can be someone *really* interesting? - Richard Bandler ========================================================================= Date: Thu, 28 Mar 1996 10:06:37 -0600 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: James Cholke Subject: access dbase Is there anyone who is using MS-Access as their Web database, and if so, can I take a look? I'm considering MS-Access for some Web Applications, but I'm not sure of it's power. Thank you! ========================================================================= Date: Thu, 28 Mar 1996 11:22:34 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee Subject: Re: TCL mail script In-Reply-To: <19960327232542914.AAA121@1.ns1.barrnet.net> (hans@marsweb.com) >>>>> "Hans" == Anderson, Hans writes: Hans> Jeff, I was wondering if there was a way to include an Hans> attachment in your sendmail.tcl script... I would like to Hans> send a .jpf file as an auto-reply, but it doesn't appear to Hans> be a function, at least in the auto-reply template. Any Hans> ideas? At the moment, there are no primitives for doing attachments. Hans> BTW, I was also wondering if you could update the nslog.dll Hans> file to include a cycle by date... I would like to have the Hans> logs based on months (cycle on the 1st, or something), Hans> instead of by size. In GNNserver 2.1 (scheduled for beta release in the next month or so) you can set your server to roll the access logs weekly or daily. You can also specify a script to be run on each log as it is rolled. doug -- ---------------------------------------------------------------- Doug McKee America Online, Inc. Email: doug@tools.gnn.com 511 Bath Street Voice: (800) 529-9166 Santa Barbara, CA (805) 882-2350 93101 Fax: (805) 899-4316 http://www.tools.gnn.com ---------------------------------------------------------------- ========================================================================= Date: Thu, 28 Mar 1996 11:31:04 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jim Davidson Subject: Re: access dbase At 10:06 AM 3/28/96 -0600, James Cholke wrote: >Is there anyone who is using MS-Access as their Web database, and if so, can >I take a look? > >I'm considering MS-Access for some Web Applications, but I'm not sure of >it's power. Thank you! Hello, We've used an Access database file through the GNNserver ODBC interface before. There were two problems that we found: 1. Only a single user could be updating the database at a time which isn't surprising given the simplicity of the "Jet" database engine in the ODBC driver. 2. We found that some inserts were simply lost. I think that after we rebuilt the database through the ODBC control panel the rows reappeared but by that time we had switched to an Illustra database. If you have a very simple app which can tolerate only a single user accessing the database at a time I'd say an Access database file should work o.k. Otherwise, I'd consider using Illustra or SQL Server. With SQL server you can access the data from the Access program through ODBC. Illustra has an ODBC driver as well but it would cost you extra. -Jim _________________________________________________ Jim Davidson | jimbo@navisoft.com Navisoft Inc. | Voice: (800) 529-9166 511 Bath Street | Fax: (805) 899-4316 Santa Barbara, CA 93101 | ========================================================================= Date: Thu, 28 Mar 1996 10:21:00 PST Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Peter Odehnal Subject: Re: access dbase >Is there anyone who is using MS-Access as their Web database, and if so, can >I take a look? > >I'm considering MS-Access for some Web Applications, but I'm not sure of >it's power. Thank you! > Don't bother using MS-Access for anything but a "prototype" database. It's flexibility in changing tables on-the-fly is helpful at design time but the ODBC driver is very poor. Accessing the MS-Access database from a 3rd party application, via ODBC, doesn't even give you transaction support. For mid-sized applications, two good 'departmental class servers', appropriate for Web app deployment are Btrieve's new database engine running on Windows NT or Sybase SQL Anywhere on NT. The Sybase ODBC drivers are mature, stable and are the native API... so performance is excellent. Regards, Peter Odehnal ========================================================================= Date: Thu, 28 Mar 1996 13:24:35 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: BKD879A@BAFCO.BELL-ATL.COM Subject: Illustra Database Sorry for this novice question. I followed the instructions on the NaviSoft site for setting up the Illustra database and the daemon seems to start successfully. However, when I execute the command: > msql -U miadmin template1 I get the error: > XVL011:license manager: SERVER FEATURE > MI_LIB_USAGE: Can't login to server > can't login to template1 on server default, host iw018340 > Not currently connected to a database Any ideas on where to begin? Is there some setup that is not mentioned in the NaviSoft instructions that must be completed first? Thanks Rick Austin richard.w.austin@bell-atl.com 703-212-6861 ========================================================================= Date: Thu, 28 Mar 1996 14:32:04 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug Patton Subject: Perl ? Comments: To: "naviserver-users@navisoft.com" Has anyone attach the Miperl interface for illustra to the GNNserver . and if so how? Also is anyone using perl to talk to the GNNserver, if so how and is there an archive of perl interfaces of scripts. Thanx in advance. ========================================================================= Date: Thu, 28 Mar 1996 12:35:20 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee Subject: Re: Illustra Database In-Reply-To: <0031600002361502000002*@MHS> (BKD879A@BAFCO.BELL-ATL.COM) >>>>> "Rick" == BKD879A writes: Rick> Sorry for this novice question. I followed the Rick> instructions on the NaviSoft site for setting up the Rick> Illustra database and the daemon seems to start Rick> successfully. However, when I execute the command: >> msql -U miadmin template1 Rick> I get the error: >> XVL011:license manager: SERVER FEATURE >> MI_LIB_USAGE: Can't login to server can't login to template1 on >> server default, host iw018340 Not currently connected to a >> database Rick> Any ideas on where to begin? Is there some setup that Rick> is not mentioned in the NaviSoft instructions that must be Rick> completed first? Apologies to all who ran into this problem: our instructions for using and installing Illustra were just plain wrong. You'll need to use the program "nsql" which lives in the bin subdirectory of the GNNserver installation directory. The Illustra license key we now distribute is a host-independant 10-year key that will let the GNNserver and nsql talk to the database, but not msql or IQT (the Windows NT Illustra Query Tool). nsql is a command-line SQL interpreter that will not let you execute some advanced Illustra commands including: create/drop aggregate create/drop cast create/drop function create/drop operator create/drop type create/drop version open, close, fetch, declare cursor To use these commands, you need a full Illustra license. For more information about doing so, contact Jim Mongillo (monge@illustra.com) at Illustra. Sorry again, doug -- ---------------------------------------------------------------- Doug McKee America Online, Inc. Email: doug@tools.gnn.com 511 Bath Street Voice: (800) 529-9166 Santa Barbara, CA (805) 882-2350 93101 Fax: (805) 899-4316 http://www.tools.gnn.com ---------------------------------------------------------------- ========================================================================= Date: Thu, 28 Mar 1996 12:55:48 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: rogerko@ciinc.com Subject: Re: access dbase Comments: cc: jcholke@mail.state.mo.us In-Reply-To: <199603281606.KAA27114@services> Hi, >Is there anyone who is using MS-Access as their Web database, and if so, can >I take a look? > >I'm considering MS-Access for some Web Applications, but I'm not sure of >it's power. Thank you! Check out our WebLink for VB (VB4 has bulit-in Access engine). It is very fast with Access database. Many real-world users in 14 countries, across 4 contenents, including some Fortune 500 companies. Please visit our web. Roger Ko RogerKo@ciinc.com http://www.weneedu.com/weblink/ Ofiice 919/676-8855 x 158, Computer Lab 919/467-7769 CompuServe 72350,3454, fax 919/676-8484 ========================================================================= Date: Thu, 28 Mar 1996 15:10:14 -0600 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Krish Menon Subject: Changing Unix Passwords I don't suppose anyone has a module/script that allows users to change their Unix passwords? Krish -krish -- krish menon - webspinner, graphic designer - krish@iw.net iway internet services, sioux falls, sd - http://www.iw.net = when you fall, pick something up. ======================== ========================================================================= Date: Thu, 28 Mar 1996 17:27:57 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: rogerko@ciinc.com Subject: Re[2]: access dbase Comments: cc: petero@WIMSEY.COM, jcholke@mail.state.mo.us In-Reply-To: Hi, Peter: >Don't bother using MS-Access for anything but a "prototype" database. It's >flexibility in changing tables on-the-fly is helpful at design time but the >ODBC driver is very poor. >Accessing the MS-Access database from a 3rd party application, via ODBC, >doesn't even give you transaction support. >For mid-sized applications, two good 'departmental class servers', >appropriate for Web app deployment are Btrieve's new database engine running >on Windows NT or Sybase SQL Anywhere on NT. The Sybase ODBC drivers are >mature, stable and are the native API... so performance is excellent. You are right that, if you use ODBC with Access, the performance is poor. But, with our WebLink for VB, there is no ODBC or DDE. Web server directly interfaces with VB/Access, the speed is over 10 times than any other ODBC/SQL solutions, not to mention the full VB (or VFP) programming capacity. It is also a lot simpler to program. There are real-world customers in 14 countries use our WebLink for VB/VFP in most heavy CGI traffics. WebLink for VB supports NaviServer (or GNNserver) 2.0. Please visit our web to see "Advantages", "How it works", "FAQs", "Real app in production", "Free eval version", etc. Roger Ko RogerKo@ciinc.com http://www.weneedu.com/weblink/ Ofiice 919/676-8855 x 158, Computer Lab 919/467-7769 CompuServe 72350,3454, fax 919/676-8484 ========================================================================= Date: Thu, 28 Mar 1996 16:01:34 -0600 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: bondo Subject: Help? Access Control Setup? I tried to setup the access control as the documentation for 2.0 says, but I don't get to the access control link. I have the nsperm module loaded for a single virtual server (server1). Everything else seems to be working. I have the home directory field filled out and the GNNserver user name. All others fields are blank. Should I fill out all the rest to be able to add a new user? It never mentions that these fields MUST be completed in order to use the permissions and access controls. From my interputation of the instructions these fields are optional and filling them out or not doing so doesn't effect the use of the access control capability. The documentation says that I only have to do the following after adding the nsperm.dll module. >1. From a Page window in GNNpress choose the Tools-> Administer Server menu item. >Choose your server from the server selection dialog that appears. If it is not >listed, type in http:// followed by the name of the host where the server is >running. A page containing links to several server functions appears. If you >are using another browser, go to the /NS/Admin page on your server. > > >2.Follow the Access Control link on the GNNserver Administration page. I don't find an /NS directory or a NS/Admin page. I found an admin.tcl file but that is all. Thanks, John ========================================================================= Date: Fri, 29 Mar 1996 02:36:40 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Aleotta@aol.com Subject: Re: access dbase I will be testing a ODBC product by Intersolv on my Solaris machines. I will start by connecting to Sybase, but I will set up a MS Access database on a Windows 95 box, connected via TCP/IP to the Unix machine. I will have the results of these tests in 1-2 weeks. Tony Leotta ========================================================================= Date: Fri, 29 Mar 1996 02:40:21 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Aleotta@aol.com Subject: My TCL Question I did not see my questions about more TCL example code. I have gotten no answers about it. What is the reason for this? Tony Leotta ========================================================================= Date: Fri, 29 Mar 1996 09:17:41 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: John Mitchell Subject: Re: Changing Unix Passwords In-Reply-To: <199603282110.PAA15798@iway1.iw.net> On Thu, 28 Mar 1996, Krish Menon wrote: > I don't suppose anyone has a module/script that allows users to change their > Unix passwords? DONT DO THIS ON A UNSECURE SERVER -- the "Basic" authentication protocol that all webservers support does *not* encrypt passwords! It "uuencodes" them, which makes the password not human-readable, but it is easily reversible. HTTP "users" should only be used for lightweight identification, but not for something critical like real unix accounts or creditcard info, etc. - john :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: John Mitchell Magnet Interactive Studios net: johnm@magnet.com Advanced Products 3255 Grace St. tel: 202-625-1111 Group Washington, DC 20007 fax: 202-625-1352 ========================================================================= Date: Fri, 29 Mar 1996 12:53:47 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: "Peter M. Jansson" Subject: Shared Tcl scripts? How can I set up a GNNServer running under NT so that virtual servers have their own Tcl directories, while having access to a shared library of Tcl goodies? The on-line documentation shows how to give a virtual server its own Tcl directory, but that seems to cut off that vs's Tcl scripts from the rest of the world. ========================================================================= Date: Fri, 29 Mar 1996 16:37:48 -0500 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Jeff Rawlings Subject: fwd: Returning a file to a client with the proper name This is a forwarded message from: >veillon@chbs.ciba.com >Hi, > >I am setting up a download service and I have a problem with the name of >the files received by the clients. All files when they arrive have the >name of the last component of the URL used by the client to activate the >download script (which do several things,like registering the user ID ...and >ultimately dispatching the file ) .I have tried many setups of varying >complexity (GET and POST methods) ,all of them end with the same result.To >simplify : >executing (GET method) a script called simple.tcl with the one and only >statement > >ns_respond $conn -status 200 -type application/octet-stream -file mini.zip > >the client gets the file mini.zip BUT with the name simple.tcl ! > >There is a choice of obvious things to explain /excuse my problem >1)i am overlooking something simple and/or fundamental ! >2) your documentation is terse... to say the least ! >3) the solution of the problem is neither to name the script after the name >of the file which the user wants to download..nor to have the user rename >the file when asked where to copy it! > >so... what do I have to do,to have the file dispatched with the right name ? > >Thanks in advance, >francois veillon >ciba-geigy >veillon@chbs.ciba.com > >PS / I am an altogether happy user of the NT implementation of naviserver >2 ,and would like to know if there are any good reasons to " upgrade" to >the version posted on the GNN server ? > > ========================================================================= Date: Fri, 29 Mar 1996 14:04:47 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee Subject: Re: Simple TCL Example In-Reply-To: <960325132150_255458658@emout05.mail.aol.com> (Aleotta@AOL.COM) Hi Tony, Tony> I did not see my questions about more TCL example Tony> code. I have gotten no answers about it. Your message was definitely posted to the list, but I didn't see any answers posted either. Tony> What is the reason for this? Probably that everyone on the list has better things to do than to write sample code for you! :) :) Admittedly, the documentation is a bit short on the subjects you asked about, and we are rectifying the situation for version 2.1. We're even commenting the currently "poorly documented" code. >>>>> "Tony" == Aleotta writes: Tony> Hi, Tony> I downloaded the Post Script Doc sets, printed them out, and Tony> created a simple database. Is there a quick simple example Tony> written in TCL that does the following: Tony> Connects to a named database Tony> Does a select, Prints the result set to an HTML page. Tony> Does an insert, Prints the status to an HTML page. Tony> Does an update, Prints the status to an HTML page. Tony> Does an delete, Prints the status to an HTML page. There is certainly an example of the first two in the short Tcl Interface Tutorial (http://www.tools.gnn.com/server/docs/2.01/tcl-ch3.htm) # /example/getemps queries a database in the default # pool and returns a list of all the employees listed # in the employees table. It assumes a table called # employees exists with the column emp_name. # # Things to notice: # # * Use "ns_dbgethandle" to get a handle for the database. # It assumes that there is a database pool named "default". # # * Use "ns_db select" to query the database and # "ns_db getrow" to retrieve data. # # * Rows are returned as ns_sets. # ns_register_proc GET /example/getemps getemps proc getemps {conn context} { set ul "
    " set db [ns_db gethandle default] set row [ns_db select $db \ "select emp_name from employees order by emp_name;"] while {[ns_db getrow $db $row]} { append ul "
  • [ns_set get $row emp_name]\n" } append ul "
" ns_returnnotice $conn 200 "Employee list" $ul } To insert a row or update a row, use "ns_db dml" as in: ns_db dml $db "insert into employees (name) values ('Bob')" If the the statement fails, a Tcl error is signaled. If this is likely, you may want to wrap your statement in a Tcl catch: if [catch { ns_db dml $db "insert into employees (name) values ('Bob')" } errMsg] { return [ns_dbreturnerror $conn $db "Could not insert row" } Tony> (Yes I did study the code that Naviservice uses for database Tony> table maintenance....but isn't it just a little bit too Tony> complicated and very poorly documented.) I would agree with the latter and that it is too complicated to serve as good example code. Tony> I have used TCl before (with TK) to make GUI apps. I have a Tony> great deal of experience with Illustra and SQL, so that's Tony> not the problem....The problem is the ns_db call... and Tony> other ns database calls. They are poorly documented. Do you have any particular questions? Tony> Good documentation, has an example of the use of each call Tony> on the man page. In the NS doc set the all of the options Tony> of the ns_db call are lumped onto two pages!!! Really you Tony> can do better than that!!! Yes; we will. Tony> I will be going to the dedicated service soon, and I plan to Tony> build all by stuff in C++, but for now I want to do some Tony> stuff and all I have is TCL.. You may want to stick with Tcl; we find it much easier to develop in, and when there is something we can't do in Tcl, we just extend Tcl with some new commands in C and then go back to Tcl. ========================================================================= Date: Fri, 29 Mar 1996 21:28:03 UT Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Coby Pachmayr Subject: Commercial Level Developers? Are there any Commercial Level developers on this list? I see many using either the dedicated server, or are using GNN server on their own system. I would like to talk to some developers who are using the Commercial level. Also, has anyone found a really good TCL reference, one that is for people new to TCL, and in particular, using it on the Web. Thanks- Coby D. Pachmayr InterMed Technologies email: pachmayr@msn.com ========================================================================= Date: Sat, 30 Mar 1996 12:14:37 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee Subject: Re: fwd: Returning a file to a client with the proper name In-Reply-To: <2.2.32.19960329213748.00655ea8@gore.navisoft.com> (message from Jeff Rawlings on Fri, 29 Mar 1996 16:37:48 -0500) >> I am setting up a download service and I have a problem with >> the name of the files received by the clients. All files when >> they arrive have the name of the last component of the URL used >> by the client to activate the download script (which do several >> things,like registering the user ID ...and ultimately >> dispatching the file ) .I have tried many setups of varying >> complexity (GET and POST methods) ,all of them end with the >> same result.To simplify : executing (GET method) a script >> called simple.tcl with the one and only statement >> >> ns_respond $conn -status 200 -type application/octet-stream >> -file mini.zip >> >> the client gets the file mini.zip BUT with the name simple.tcl! The primary problem is that the BROWSER is what decides the name of the file, and it does this based on the last part of the URL it submits. There is no place (that I know of) in HTTP for the server to send back a suggested filename. BUT, there may be a solution. You can try having your script do what it needs to do (e.g., register user id) and then return a redirect to the URL of the file itself -- OR a script whose sole purpose is to return files and whose URL's end in the filename. I would make sure that your script is invoked with a GET since most browsers will apply the same method to the URL that you are redirecting to. That is, if your script is invoked with a POST and it returns a redirect, the browser will most likely POST to the URL returned -- NOT necessarily what you want. >> PS / I am an altogether happy user of the NT implementation of >> naviserver 2 ,and would like to know if there are any good >> reasons to " upgrade" to the version posted on the GNN server ? Yes; some important bugs have been fixed -- see the next message posted to this list announcing the availability of GNNserver 2.03. doug -- ---------------------------------------------------------------- Doug McKee America Online, Inc. Email: doug@tools.gnn.com 511 Bath Street Voice: (800) 529-9166 Santa Barbara, CA (805) 882-2350 93101 Fax: (805) 899-4316 http://www.tools.gnn.com ---------------------------------------------------------------- ========================================================================= Date: Sat, 30 Mar 1996 12:26:26 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee Subject: GNNserver 2.03 GNNserver version 2.03 is now available for download. To do so, visit: http://www.tools.gnn.com/server/overview.htm The complete release notes are at: http://www.tools.gnn.com/server/relnotes.htm GNNserver 2.03 includes a few new features and bug fixes not found in the GNNserver 2.02 release: * Bug fixes to CGI, ns_sendmail, threads interface on SGI, and the Illustra database driver. * New option for the nslog Access Logging module to log in the NCSA combined logged format (note that the combined format is slightly different that using the LogRefer and LogUserAgent options). To enable the new format, add "LogCombined=yes" to the nslog configuration section of the nsd.ini file. * The "-i" option to run GNNserver from /etc/inittab. For example: web1:23:respawn:/local/ns/bin/nsd -ic /local/ns/nsd.ini Using init is an excellent way to run GNNserver because init will automatically restart the server if it happens to exit. New to the GNNserver 2.03 release is a special upgrade program for the Intel Windows NT release! To upgrade from NaviServer 2.0 or GNNserver 2.02 on Intel Windows NT, simply download and launch the self extracting upgrade program below: http://www.tools.gnn.com/download/server/gs203upg.exe ftp://gnnserver@ftp.tools.gnn.com/gnnserver/gs203upg.exe Current Unix users of NaviServer 2.0 or GNNserver can upgrade by making a backup of their existing installation and untarring the distribution file over the existing installation. This process will not replace your configuration file, any new Tcl files you may have created, or any virtual server data (including pages). The Tcl files distributed with the server will be overwritten, so if you have edited them, you may want to upgrade and put the patches you've made into the new files by hand. All users are encouraged to upgrade to the 2.03 release. But what about GNNserver 2.02, the first release of GNNserver? What was different in that release from NaviServer 2.0? * First of all, there was a new price tag - free! * Second, all internal references to NaviServer were changed to GNNserver and the NaviServer logo was changed to the new GNNserver logo. * In addition, there were a few minor bug fixes incorporated into the 2.02 release. If anyone has any particular questions about this release, feel free to ask! doug -- ---------------------------------------------------------------- Doug McKee America Online, Inc. Email: doug@tools.gnn.com 511 Bath Street Voice: (800) 529-9166 Santa Barbara, CA (805) 882-2350 93101 Fax: (805) 899-4316 http://www.tools.gnn.com ---------------------------------------------------------------- ========================================================================= Date: Sat, 30 Mar 1996 15:19:55 -0800 Reply-To: Web Development with GNNserver Sender: Web Development with GNNserver From: Doug McKee Subject: Special note for Linux users Just a quick note: Linux users are especially encouraged to upgrade to GNNserver 2.03 -- this version gets around a known bug in the pthreads package (used by GNNserver) and should be much more reliable. doug -- ---------------------------------------------------------------- Doug McKee America Online, Inc. Email: doug@tools.gnn.com 511 Bath Street Voice: (800) 529-9166 Santa Barbara, CA (805) 882-2350 93101 Fax: (805) 899-4316 http://www.tools.gnn.com ----------------------------------------------------------------