[Zope] Re: Some help required but no sarcastic comments this time pleasee
I understand people do use Win9x, but I would always recommend NT 4 workstation over 9x unless there is an overpowering need for USB. I don't use USB myself and have been using NT exclusively on the desktop since 94. When properly configured it is much more stable. Nowadays, NT5 (oops 2000) is a better choice for USB support and about as stable as 9x. But, that aside, I'm interested in your desktop uses for Zope. What sort of apps? From: Toby Dickenson [EMAIL PROTECTED] There are those of us who use Zope in desktop applications too (yes really), where Win9x is not an unreasonable choice. Toby Dickenson ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Re: Some help required but no sarcastic comments this time pleas ee
To clarify, W2k is probably pretty reliable now for the desktop, but the servers have a way to go. In addition to reliability issues, the resources required to do the same functions on the 2000 products (w2k, office 2K, access 2K) are much higher than the 97 and 4.0 versions. MS can't even keep their own sites going: http://www.zdnet.com/zdnn/stories/news/0,4586,2677896,00.html?chkpt=zdhpnews 01 Now I don't bash MS for a living, just as a hobby. They've been sliding steadily downhill since the 4.0 release. I provide computer services on MS and Novell networks for a living. I would not consider putting W2K servers into production until they are stabilized and still would not do so unless my client are planning a hardware upgrade as part of the process. We've seen too many black screens of death with W2K servers. The clients do appear more stable, but why sacrifice performance in a business environment when you gain nothing? I've used 4.0 without a crash for years. Why switch? It's faster and does everything I need. It will be interesting to see the Unix command-line loving community's reaction when MS releases their text mode server product. This will certainly interest the mouse-phobic. If I want USB for multimedia solutions, I'll probably do it under BeOS. Then again, I'll probably use firewire. (which should've been in windows instead of USB from the start. Alan -Original Message- From: Michelle Walden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 1:10 PM To: Capesius, Alan; zope Subject: RE: [Zope] Re: Some help required but no sarcastic comments this time pleas ee You could now recommend W2k as a much more stable *than either 95 or NT4* alternative that does USB support out of the box. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Capesius, Alan Sent: Wednesday, January 24, 2001 12:39 PM To: [EMAIL PROTECTED] Subject: [Zope] Re: Some help required but no sarcastic comments this time pleas ee I understand people do use Win9x, but I would always recommend NT 4 workstation over 9x unless there is an overpowering need for USB. I don't use USB myself and have been using NT exclusively on the desktop since 94. When properly configured it is much more stable. Nowadays, NT5 (oops 2000) is a better choice for USB support and about as stable as 9x. But, that aside, I'm interested in your desktop uses for Zope. What sort of apps? From: Toby Dickenson [EMAIL PROTECTED] There are those of us who use Zope in desktop applications too (yes really), where Win9x is not an unreasonable choice. Toby Dickenson ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Re: Some help required but no sarcastic comments this time pleas ee
Supposed to be in NT7 (after whistler) It will be a headless version. -Original Message- From: Gerald Gutierrez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 3:16 PM To: Capesius, Alan; [EMAIL PROTECTED] Subject: RE: [Zope] Re: Some help required but no sarcastic comments this time pleas ee It will be interesting to see the Unix command-line loving community's reaction when MS releases their text mode server product. This will certainly interest the mouse-phobic. What product is this? ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] ZODBC configuration problems
Are you running 2.2? Look at: http://www.egroups.com/message/zope/36392 Is the Access DB on the same server as Zope? If not, you may be running into problems accessing the network. The Zope service may need to be switched to run under a user account that has access to the network resource. The NT System account does not have network authority. http://msdn.microsoft.com/library/periodic/period98/ewn9824.htm http://support.microsoft.com/support/kb/articles/Q235/5/36.ASP Is the ODBC DSN a system DSN? Don't use User DSN. Alan Capesius, MCSE+21 Sysmex Corp of America Message: 17 Date: Tue, 28 Nov 2000 09:59:32 -0600 From: [EMAIL PROTECTED] Subject: ZODBC configuration problems The permissions on this database are such that any anonymous user can access its data so the error message appears to be inaccurate. I double checked the db permissions to make sure this is the case. I am running Zope on NT 4.0 and using Access 97. The logged-in user on the webserver is not a member of any Access-related workgroups so this eliminates most security-related access issues (I think) and none of the databases are passworded. There's some flakiness going on here. Any recommendations for isolating and resolving these problems? Thanks, P. Johnson ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) _ ___ _ ___ Message: 18 Date: Tue, 28 Nov 2000 11:41:50 -0500 From: "Chris McDonough" [EMAIL PROTECTED] Subject: Re: Factoids for supporting zope Our client thought that the recent VC money was about 1/2 what would be needed to make it fly. My argument is that money is leveraged by the active Zope community so a crux in my logic is how strong this community is. 1/2 of what would be needed to make it fly with Zope? Or 1/2 of what would be needed with any app server? Since they come from a non Zope context it would be from the general position and the onus is on me to bring in the Zope context in the construction of my argument. Ah. Well, my opinion is that it'd be fairly dangerous to make the assertion that (as great as they both are) Zope and the Zope community can "make up for" the other half of the capital they need to develop the software they want. So what's the decision they're trying to make? Whether to develop at all? ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) _ ___ _ ___ Message: 19 Date: Tue, 28 Nov 2000 17:28:11 +0100 From: "Max M" [EMAIL PROTECTED] Subject: RE: How do i write or? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stoonsdesign The thing is that I have this page (made by somebody else) wich is supposed to look up some words in a database by writing: Hi Stoons It really is impossible to answer that question without knowing how that page works. But maybe letter=* will work. Regards Max M Max M. W. Rasmussen,Denmark. New Media Director private: [EMAIL PROTECTED] work: [EMAIL PROTECTED] - Specialization is for insects. - Robert A. Heinlein ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) _ ___ _ ___ Message: 20 Date: Tue, 28 Nov 2000 12:34:59 -0400 From: "Dany Rioux" [EMAIL PROTECTED] Subject: RE: Possible disaster upgrading to 2.2.4 I was thinking about downloading the ZDiscussions product and install it but from what I can see, it looks like it needs some fixing. I intend to upgrade to zope 2.2.4 when it was proven that it is stable but I don't want to run into more troubles that I can chew on. I will need a Discussion board when the site go live so should I upgrade Zope and wait for another Discussion Product to come up or install ZDiscussion and hold on the Zope upgrade? TIA Dany -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Welch Sent:
[Zope] Multiple ZODBC sources
I need to join tables from two ODBC sources, one MS Access one SQL. ZODBC DA seems to be limited to one data source at a time. Is there any way to join tables from two different sources? Alan Capesius, MCSE+20 Technical Support Engineer Sysmex Corporation of America [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Multiple ZODBC sources
Thanks All, I was hoping I had missed a clean way to do this. :) Access provides link tables, but what if I had two SQL servers? I thought (still thinking) about the Access link table solution, but I'm not sure I want the ODBC linking through Access to get to SQL. MS SQL Server also supports server links via Transact-SQL/XML. The dtml-in/dtml-with technique suggested by Chris Gray looks the promising. That will eliminate cross-product problems too. Probably the closest thing I'll find to a true join. So, after some digging and trying I found that you can access multiple Databases on the same SQL server by setting the ODBC driver up WITHOUT a default table and qualifying the database as such: select * from DBNAME..TABLENAME This method sacrifices the ability to browse for tables through this DSN, but this can be recovered by creating a secondary table-specific DSN for browsing purposes. ODBC also supports a configuration that allows SERVERNAME.DBNAME..TABLENAME configurations but I haven't been able (yet) to get that working through Zope. This would support direct links to multiple SQL servers. Since the ODBC DSN is part of the ZODBC configuration parameters, I expect that ZODBC cannot provide support for different source types at the ZSQL Method level. As far as writing a method to copy from one table to another, this would be OK in my case because I am using small databases on this app, but not for larger dbs. That would result in (2 + #_of_records) queries against the SQL in a realtime database. My app uses a static table (once a day update) for the Access side, so just moving/migrating this once a day to SQL may be the best bet. The SQL source is a third party package so I'd rather not put my table into their database just in case. (Avoid all that finger pointing later on). The copy table method along with the ZODBC solution above allows me to add a database to the server outside of the 3rd party's database and join tables via Zope ZSQL. -Original Message- From: Chris Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 10:31 AM To: Andrew Kenneth Milton Cc: Capesius, Alan; [EMAIL PROTECTED] Subject: Re: [Zope] Multiple ZODBC sources I wonder if something like this would work: dtml-in selectFromTable1 dtml-in selectFromTable2 dtml-if idFromTable1 = idFromTable2 display parts of the two records /dtml-if /dtml-in /dtml-in Might be more efficient to make one of the dtml-ins a dtml-with and find the item with the matching id. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] ZODBCDA fails under 2.2
Title: RE: [Zope] ZODBCDA fails under 2.2 Thanks Petteri, That did the trick nicely. Alan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 2:18 AM To: [EMAIL PROTECTED] Subject: Re: [Zope] ZODBCDA fails under 2.2 Hi, update RDB.py, restart zope See : http://www.egroups.com/message/zope/36392 Regards, Petteri Soikkonen Tietopalvelut / Media TietoEnator Oyj PL 403 / Tietotie 6 FIN-02100 Espoo Finland p. 09-86252266 0407 510 045
Re: [Zope] Log Out
Title: Re: [Zope] Log Out There is a netscape guide to using cookies that might lend some insight into techniques for circumventing the HTTP authenticaion header problem at: http://developer.netscape.com:80/viewsource/bosamiya_tips.html Alan Capesius, MCSE Technical Support Engineer Sysmex Corporation of America [EMAIL PROTECTED]
[Zope] ZODBCDA fails under 2.2
Title: ZODBCDA fails under 2.2 I'm trying to access data via the ZODBCDA latest build and Zope 2.2 Whenever the ODBC query returns data, the user is challenged for authentication. Pages that do not use ODBC and database methods that return empty sets are not challenged. Has anyone else encountered this? In my configuration, anonymous has acquired Access, View and use db methods rights. I've also tried with explicit rights. Alan Capesius, MCSE Technical Support Engineer Sysmex Corporation of America [EMAIL PROTECTED]
[Zope] 2.2 Explicit/implicit problem.
Title: 2.2 Explicit/implicit problem. I'm able to take ownership of objects to a new user manager-level account. Object then switch to implicit mode. For some objects I've switched them to implicit for testing. Once switched, they do not switch back. The button displayed under Ownership indicates that they can switch, but does nothing when clicked. Anyone run into this? Alan Capesius, MCSE Technical Support Engineer Sysmex Corporation of America [EMAIL PROTECTED]
[Zope] Re: simple dtml-if question
Title: Re: simple dtml-if question Joel that's really an HTML question. Use BR in every table field that contains only dtml tags. It isn't required if there is any text in the table field. Alan Capesius, MCSE Technical Support Engineer Sysmex Corporation of America [EMAIL PROTECTED]
[Zope] RE: Slow ODBC source
Title: RE: Slow ODBC source I'm using an Access DB on NT Server without any trouble. It is very fast. How large is the data you are retrieving? (bytes per record I mean) My apps are typically running on a MDB with 10,000 records I've noticed some issues that relate to Access queries. Here they are in the order I'd check them: 1) If Zope is running in a DOS window (haven't used it on 98) you might be running into a background processing problem. Use a PIF file to start it and make sure that Background processing is allowed. There is a checkbox to suspend in background I believe. What happens is that the app gets shut off when if doesn't have the focus and runs extremely slow if at all. Also your performance settings in the system tuning are may be set to provide foreground apps higher priority. 2) The DB should be on the same machine as Zope 3) The way in which queries are built can cause some problems. You may want to create a query that presort preselects the results you want to obtain and then use that query as your data source in the Zope SQL Method. That way the results are pre-indexed and return quicker. This provided me a 97% performance improvement. (3 minutes down to 5 seconds) For Example: table-join query sorted by name-ZSQLMethod instead of table-ZSQLMethod (join sort) 4) You may want to run the Access database analysis tool and see if it recommends indexing. 5) You can adjust the number of records returned to improve performance in some cases. Sorry I'm an NT guy, and I agree 98 is for home user desktops not servers, NT workstation should be the bare minumim at the desktop IMHO. I don't want to get into the third grade OS wars either. It certainly isn't worth it to me to go thru the learning curve to switch to unix. The migration to NTW is much more tranparent. Alan Capesius, MCSE Technical Support Engineer Sysmex Corporation of America [EMAIL PROTECTED]
[Zope] Authentication, Anonymous and Public
Title: Authentication, Anonymous and Public I'm running into a problem after implementing jcNTUserFolder in a subfolder of my site. Users can access the root level or particular subfolders anonymously. Once a user accesses the protected NTUserFolder, the credentials are saved in the browser. If the user then returns to the anonymous area, they can no longer access th folder due to the browser credentials. Does Zope have a mechanism equivalent to the Novell NDS Public access? that is to say: Anonymous = not authenticated. Everyone = authenticated users (that are members of the group) Public = authenticated and anonymous users. I'd like the default access to be anybody and their brother rather than those people who haven't logged in
