- Zope - Zope lists

- Zope-1.9.0 + Python-1.5.2b1 = BOOM
by Andy Dustman 24 Dec '98

24 Dec '98

When compiling, I get: ./../Components/ExtensionClass/ThreadLock.c:75: parse error before `type_lock' Apparently this is due to a renaming in Python between 1.5.1 and 1.5.2b1: thread.h -> pythread.h (which the code does look for) but apparently there has now been a renaming of type_lock -> PyThread_type_lock (also type_sema -> PyThread_type_sema) and free_lock -> PyThread_free_lock. I'm guessing the first change came with the 1.5.2a series and the latter came with 1.5.2b; 1.5.2b1's pythread.h definitely does not have all the renaming stuff in 1.5.1. Luckily I still had a 1.5.1 source tree lying around. Making the changes above SHOULD work for 1.5.1 as well, however, since it does do a bunch of renaming in thread.h, but if you're using 1.5.1, you probably don't need the patch. Patch attached. -- Andy Dustman You should always say "spam" and "eggs" ComStar Communications Corp. instead of "foo" and "bar" (706) 549-7689 | PGP KeyID=0xC72F3F1D in Python examples. (Mark Lutz) --- Zope-1.9.0-src/lib/Components/ExtensionClass/ThreadLock.c.orig Tue Nov 17 16:43:50 1998 +++ Zope-1.9.0-src/lib/Components/ExtensionClass/ThreadLock.c Thu Dec 24 16:41:23 1998 @@ -72,7 +72,7 @@ int count; long id; #ifdef WITH_THREAD - type_lock lock; + PyThread_type_lock lock; #endif } ThreadLockObject; @@ -82,7 +82,7 @@ cacquire(ThreadLockObject *self) { #ifdef WITH_THREAD - long id = get_thread_ident(); + long id = PyThread_get_thread_ident(); #else long id = 1; #endif @@ -99,7 +99,7 @@ { #ifdef WITH_THREAD Py_BEGIN_ALLOW_THREADS - acquire_lock(self->lock, 1); + PyThread_acquire_lock(self->lock, 1); Py_END_ALLOW_THREADS #endif self->count=0; @@ -120,7 +120,7 @@ crelease(ThreadLockObject *self) { #ifdef WITH_THREAD - long id = get_thread_ident(); + long id = PyThread_get_thread_ident(); #else long id = 1; #endif @@ -133,7 +133,7 @@ one. */ self->count--; #ifdef WITH_THREAD - if(self->count < 0) release_lock(self->lock); + if(self->count < 0) PyThread_release_lock(self->lock); #endif } else @@ -187,7 +187,7 @@ ThreadLock_dealloc(ThreadLockObject *self) { #ifdef WITH_THREAD - free_lock(self->lock); + PyThread_free_lock(self->lock); #endif PyMem_DEL(self); } @@ -248,7 +248,7 @@ UNLESS(self = PyObject_NEW(ThreadLockObject, &ThreadLockType)) return NULL; self->count=-1; #ifdef WITH_THREAD - self->lock = allocate_lock(); + self->lock = PyThread_allocate_lock(); if (self->lock == NULL) { PyMem_DEL(self); self = NULL; @@ -262,7 +262,7 @@ ident(PyObject *self, PyObject *args) { #ifdef WITH_THREAD - return PyInt_FromLong(get_thread_ident()); + return PyInt_FromLong(PyThread_get_thread_ident()); #else return PyInt_FromLong(0); #endif

1 0

- creating a MySQL login form
by Phil Wilson 24 Dec '98

24 Dec '98

I'm just starting with Zope and have some questions: 1. In the form below, it gives me this error when calling manage_open_connection:  what is wrong with the call? 2. If I change 'conn' to user in the manage_addZMySQLConnection(), how do I address user in manage_open_connection()? i.e. MySQL.manage_addZMySQLConnection(user, ...) MySQL.user.manage_open_connection() is what I'm trying to accomplish. 3. How do I trap exceptions in DTML (i.e. if login fails)? ---------------------     if successful do_something_interesting else notify_failure   <H2> </H2> <form action="login"> <table> <tr><td>User:</td><td><input type="text" name="user"></td></tr> <tr><td>Password:</td><td><input type="password" name="password"></td></tr> </table> <P> <input type="submit" value="Login"> </form>

1 0

- ZMySQLDA does not show up.
by Dave Goodrich 24 Dec '98

24 Dec '98

Ok now, I downloaded, compliled, and installed the MySQL release version 3.21.33. (Three tries) I downloaded and installed the ZMySQLDA package as per instructions, everything worked, no errors in the consol window and I created a "MySQLmodule.so" binary. Moved it into the ZMySQLDA product directory and restarted Zope. I did change the ZMySQLDA setup script to reflect the correct paths to my MySQL lib and include dirs. Make was completed fine. However when logging into my management screen I do not have the option to create a new database connection from the pull down menu. Any thoughts, did I miss a thread on this? DAve.

3 2

- Updating DTML cache?
by skip＠calendar.com 24 Dec '98

24 Dec '98

I know the new DocumentTemplates cache the parsed form. Does it recognize DTML file changes and reload/reparse? Skip Montanaro | Mojam: "Uniting the World of Music" http://www.mojam.com/ skip(a)calendar.com | Musi-Cal: http://concerts.calendar.com/ 518-372-5583

2 1

- Zope/ODBC and MS Sql Server 6.5 connection
by Vincent Joseph 24 Dec '98

24 Dec '98

Hi, Has anyone managed to connect to MS SQL Server 6.5 using Zope ODBC? The ODBC Data Source Administrator does not have a place where you can specify a user/id and password. So selecting the data source does not seem to be enough. The clients that I use (isqlw) always ask for a userid and password. How do I provide this information to Zope, while at the same time using ODBC? When I try to connect it gives me the following message [ec is my data source name]: <strong>Invalid connection string: </strong><CODE>ec</CODE><br>   I got the following from the SQL server books online, and tried both. >>A minimum complete SQL Server connection string has one of two forms: >>DSN=dsnname;UID=loginid;PWD=password; >>DRIVER={SQL Server};SERVER=server;UID=loginid;PWD=password; I also tried using the Sybase connection string pattern, to no avail. So how do I go about specifying the user id and password to get a successful login when using ODBC? Help would be much appreciated. Thanks in advance, Vincent --

1 0

- Status check
by Timothy J. Grant 24 Dec '98

24 Dec '98

Hi, Just curious, I just caught up with my message backlog and discovered that my traffic stopped on 12/17. Is the list down, or did I do something wrong?........... -- Stand Fast, tjg. =================================== Timothy J. Grant tjg(a)avalongroup.net Avalon Technology Group www.avalongroup.net (503) 246-3630 voice (503) 246-3124 fax This message may be digitally signed with PGP. A PGP signature guarantees that this message really did come from me. For more information regarding digital signatures and encryption, please contact me.

2 1

- Problem adding object on Win32 binary release
by Timothy J. Grant 24 Dec '98

24 Dec '98

Hi, Zope Zen might be approaching 0.01! I hope someone gets this as I have seen no traffic since 12/17, but the Mailman insists I am subscribed! I just downloaded the Win32 binary of the 1.9 final release, installed it, and finally decided that I was done playing around and reading about this tool, I was going to actually try and use it! Unfortunately Zope doesn't work with my favourite browser (Opera), so I have to use IE4. Most of the features work, but when I attempt to do an add from the top level folder, IE4 reports the following error: "Microsoft Internet Explorer cannot open the Internet site http://localhost:9673?%3amethod=manage_adddocumentform/. Invalid syntax" Any light that can be shed would be greatly appreciated. Happy holidays to all! -- Stand Fast, tjg. =================================== Timothy J. Grant tjg(a)avalongroup.net Avalon Technology Group www.avalongroup.net (503) 246-3630 voice (503) 246-3124 fax This message may be digitally signed with PGP. A PGP signature guarantees that this message really did come from me. For more information regarding digital signatures and encryption, please contact me.

1 0

- NT and IIS problem (argv)
by Vincent Joseph 24 Dec '98

24 Dec '98

Hi, The following problem has already been asked on this list, but I could'nt find a solution (I looked through the archive - no luck). [I searched the mailing list using argv as the search pattern.] Anyway here is the error I get when I browse to http://localhost/scripts/samples/zope1.exe/manage <body> Sorry, an error occurred.<p>  </body> BTW, I get the same error if I leave out the manage at the end of the URL. Help would be appreciated, Thanks, Vincent

4 5

- Re: Zope - YASQ (yet another stupid question)
by Chad Fowler 24 Dec '98

24 Dec '98

Amos, Thanks for your encouraging response. I think I should provide a little more detail. What I am specifically trying to do is look up a value from a DB table for every record returned from another DB table. For example, if I had a database of Overtime hours worked for company employees, for each record in the "OThours" table, I would look up "fullname" and "phonenumber" based on "employeenumber" out of the "Employees" table. So, what I have done (and, I'm sure it's somehow flawed) is create a SQL Method that returns multiple rows from the "OThours" table, and using the  Hours work:  Emp. Name: )"-->  Mood:   If I replace the offending line with: Emp. Name:  ....I can make it work. I'm sure I'm doing this backward or something. I've read all of the documentation I can find at this point. I'm sure this is a simple problem of me just going about it the wrong way. Sorry for the long and confusing email. Chad Fowler Amos Latteier wrote: > At 02:55 PM 12/23/98 -0600, Chad Fowler wrote: > > >Say you have an external method, or a SQL Method that accepts a > >parameter. > >You want that parameter to be dynamic (possibly based on a field from a > >DB). > >How can you pass a dynamic parameter to a method from within DTML? > > > >i.e.: > >)"--> > > What you've got is basically right, it's just a question of syntax. In > general you can refer to variables defined in the REQUEST by name: > >  > > Sometimes there are problems with this, if for example you want access to > special sequence-item variable. In these cases you can lookup variables in > the namespace mapping object (whose unpronounceable name is written '_') > like so: > >  > > For an example of how to use this namespace feature to include random bits > of content see: > > http://www.zope.org/Documentation/HowTo/RandomContent > > You should also check out the DTML Users Guide which spells out pretty well > how to use DTML: > > http://www.digicool.com/site/Principia/DTML.html > > Hope this helps. And BTW, DTML *is* complex; your question is not stupid. > > -Amos

2 1

RE: [Zope] - ODBC and zope on NT
by Paul Everitt 24 Dec '98

24 Dec '98

Vincent wrote: > On Zope(NT service)/IIS/NT I cannot find a place to add a Zope SQL > Database > Connection (when I try to add a Zope SQL Method it asks me for a > SQL connection). I read the Aqueduct users guide, and it stated that > I should find a "Add Aqueduct xxxx(=ODBC) Connection" under Add. This > is not there. Will this only appear if I install the ZODBCDA? Yes. Here's the idea: SQL Methods are database independent. You point them at an object that is connected to a database -- a Database Connetion. For ODBC, double click on the ZODBCDA tar.gz file and tell WinZip to extract it into your Zope directory. It will create some directories under lib/python/Products. When you shut down and restart your Zope site (via the Control Panel), voila, you can add a Database Connection object to a Folder. All you have to do then is select something you have defined in the Windows Control Panel's ODBC setup as an ODBC source. When you add an ODBC DA > The ZODBCDA file is a tar.gz file - is this for Unix only? I usually > work in Unix and this is not usually a problem - however I am on > NT for a short time, and am not sure/familiar with tar or gz for > NT. And I am trying out zope on NT/IIS. If the ZODBCA file is for > NT as well, could you please point me to some utilities, or provide > a .zip or .exe. WinZip can nicely handle tar.gz files (some versions require a little help with telling it the tar file is .tar instead of _tar). --Paul

2 1