- Zope - Zope lists

New kinds of problems
by MANUEL JOSE AMADOR BRIZ 04 Nov '00

04 Nov '00

Thanks, here are my two cents: Mini quick howto to connect to a sybase ASA/ASE: Get any 2.2 linux distro installed, except red hat 7 (compiler problems, it WILL fail). GET from Sybase the RPMs called sybase-common and sybase-openclient, the latest versions. Install them. do a link from /opt/sybase to /opt/sybase- {currentversion} which should exist now. make sure you have $SYBASE set in your profile, to /opt/sybase. Download zope-2.2.2.src.tgz untar as root, then chown -R root.root /path/to/Zopefolder make sure you have python and python-devel RPMs or DEBs. cd to zope folder run \\\'python w_pcgi.py\\\' run \\\'python zpasswd.py access\\\', enter username, password, CLEARTEXT encoding and no domain get ZSybaseDAv2 b2 and place the targz file into the zope folder do a \\\'tar zxvmf ZSybaseDAv2.tar.gz0 in the zope folder Once more do a chown -R root.root * cd into lib/python/Products/ZSybaseDAv2/src cp Setup.linux or Setup.solaris to Setup make -f Makefile.pre.in boot make cd to the parent folder (cd ..) cp src/sy_occ.so . enter python and try to do \\\'import sy_occ\\\' if it works and doesn\\\'t spit errors, you\\\'re set. exit python and go to the zope folder, then run ./start if zope starts, you\\\'re all set now there is an executable called /opt/sybase/bin/dsedit that you will have to use to create network transports. Fill in the appropriate data. Now for the problems. I managed to connect to an ASA 7.0 database, and retrieved successfully a select * from systable, but can\\\'t execute stored procedures, it spits some kind of another operation on progress error or unknown data type returned error. I assume ASA and dsclient are talking incompatible protocols here. Can someone help me? By the way, the data source created with dsedit for our ASE server works fine. Everything runs OK. Please reply and CC: me because I\\\'m kinda lagged behind with the mailing list and I need a reply soon. Thanks. I hope these instructions help people in connecting to Sybase, given the poor support they have in some countries (I\\\'m thinking mine). Manuel ---------------------------------------------------------- Universidad Federico Santa Maria - Campus Guayaquil Enviado por: www.usm.edu.ec

3 3

Re: [Zope] Id ZopeStudio Dead?
by Simon Michael 04 Nov '00

04 Nov '00

Also, for windows try Zope Stud (products area). It's an alpha and doesn't do much but what's there works extremely well. It makes a nice wiki browser too.

1 0

PHP and Zope
by Vincent - D. Ertner 04 Nov '00

04 Nov '00

Hi Zopers, I learned PHP and now discovered Zope. So I'd like to put a simple question: What's the best way to incorporate the advantages of PHP and Zope? Should I focus on one and forget the other? Okay, these are two questions and I honestly doubt that anyone would suggest to drop Zope ;-))) Anyway: Please gimme some starting hints on my way to the perfect content managed web site! Thanx in advance! Cheers, Vince ''' ô¿ô -

2 1

Local Time Zone
by Daniel Rusch 04 Nov '00

04 Nov '00

Hey all, I know I can get the users language preference like this: <dtml-var "REQUEST['HTTP_ACCEPT_LANGUAGE']"> The question then is, is there a similar method of getting the users Local Time Zone??? Thanks, Dan

2 1

Manually inc. sequence.
by Jason C. Leach 04 Nov '00

04 Nov '00

hi, How do you manually move to the next item in a sequence? Also, how do you break one? j. ...................... ..... Jason C. Leach ... University College of the Cariboo. ..

1 0

error in Zope book
by michael angelo ruberto 04 Nov '00

04 Nov '00

in chapter 5 the example Creating a File Library has an error in the sorting method. <dtml-var standard_html_header> <h1>File Library</h1> <table> <tr> <th><a href="&dtml-URL0;?sort=name">File</a></th> <th><a href="&dtml-URL0;?sort=date">Last Modified</a></th> </tr> <dtml-if expr="_.has_key('sort') and sort=='date'"> ---ERROR-------------------------------------------------------------------- ------- <dtml-in expr="objectValues('File')" ~this should be <dtml-in expr="PARENTS[0].objectValues(['File'])" ~it doesn't work otherwise. ---ERROR-------------------------------------------------------------------- ------- sort="bobobase_modification_time" reverse> <tr> <td><a href="&dtml-absolute_url;"><dtml-var title_or_id></a></td> <td><dtml-var bobobase_modification_time fmt="aCommon"><td> </tr> </dtml-in> <dtml-else> ---ERROR-------------------------------------------------------------------- ------- <dtml-in expr="objectValues('File')" sort="id"> ~same as above. ---ERROR-------------------------------------------------------------------- ------- <tr> <td><a href="&dtml-absolute_url;"><dtml-var title_or_id></a></td> <td><dtml-var bobobase_modification_time fmt="aCommon"><td> </tr> </dtml-in> </dtml-if> </table> <dtml-var standard_html_footer> -<mike>-

2 1

Refrencing.
by Jason C. Leach 04 Nov '00

04 Nov '00

hi, if I do something like: <dtml-let x=sequence-item> What is the sintax to refrence that object? <img src=<dtml-var x.id> ? Thanks, j. ...................... ..... Jason C. Leach ... University College of the Cariboo. ..

2 2

Securing an FTP server.
by Jason C. Leach 04 Nov '00

04 Nov '00

hi, I'd like to secure the FTP server so that when Bob loges in, he is sent to folder X and can not exit X. And when Jain loges in, she is put into Y and can not exit that folder. Is this possible. Someone once suggested working with site rules, but that's a bit hokey; unless someone has implemented an elagent solution like this. Thanks, j. ...................... ..... Jason C. Leach ... University College of the Cariboo. ..

2 2

Another Aiieee.....
by Jon Prettyman 03 Nov '00

03 Nov '00

I am once again encountering the mysterious Aiieee error with core dumps from Zope/Python on a Solaris boxen. SunOS sparky 5.7 Generic_106541-08 sun4m sparc SUNW,SPARCstation-20 Python 1.5.2 (#1, Oct 24 2000, 11:56:43) [GCC 2.8.1] on sunos5 Zope-2.2.2 DCOracle 1.3.2 448M ram I get the following in my STUPID_LOG 2000-11-03T20:42:10 ERROR(200) zdaemon zdaemon: Fri Nov 3 14:42:10 2000: Aiieee! 17537 exited with error code: 139 /usr/include/sys/errno.h looks like this: #define ECONNABORTED 130 /* Software caused connection abort */ #define ECONNRESET 131 /* Connection reset by peer */ #define ENOBUFS 132 /* No buffer space available */ #define EISCONN 133 /* Socket is already connected */ #define ENOTCONN 134 /* Socket is not connected */ /* XENIX has 135 - 142 */ #define ESHUTDOWN 143 /* Can't send after socket shutdown */ #define ETOOMANYREFS 144 /* Too many references: can't splice */ #define ETIMEDOUT 145 /* Connection timed out */ #define ECONNREFUSED 146 /* Connection refused */ #define EHOSTDOWN 147 /* Host is down */ #define EHOSTUNREACH 148 /* No route to host */ What is a 139 error code? Is it an errno? I do get core dumps but for some reason I can't get gdb to read it. Arghhh. Crashes appear random. The box has at most two people accessing Zope. It appears ``manage'' related, but I can't be sure. There is an identical instance of this Zope application running on a Linux box that does not have this problem. It is very stable. We'd like to use this Solaris boxen for our development work. -jon

1 0

Help with general purpose ZSQL Method
by Jon Prettyman 03 Nov '00

03 Nov '00

I want to write a generic table browser ZSQL method and am having trouble getting the output that I want. Given a ZSQLMethod that looks like this: ID: browse_table Arguments: table:string="" Script: SELECT * FROM <dtml-var table> I'm trying to write a DTML method to display the results of this method WITH COLUMN NAMES. For the life of me, I can't figure out how to do this. Basically, I have: <dtml-in "browse_table(table='xxxx')" size=1> <dtml-in sequence-item> <dtml-var sequence-item> </dtml-in> </dtml-in> The inner sequence-item gives me the data, but how to I determine the column name? -jon

1 0