March 2000 - Zope - Zope lists

Help on MySQLDA
by Fabrice Frassaint 19 Mar '00

19 Mar '00

I tried to use MySQLDA without success. I have a redhat 6.1 and MySQL 3.22.29 installed. I even installed a unixODBC connection to MySQL that works. How can I access this database through ZOPE. When I try to make the MySQLDA extension a lot of errors come out of it : gcc -fPIC -I/usr/local/mysql-3.22.32/include/ -I/usr/include/mysql -g -O2 -I/us r/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H -c ./MySQLmodule.c ./MySQLmodule.c: In function `pythonify_row': ./MySQLmodule.c:238: warning: assignment from incompatible pointer type ./MySQLmodule.c: In function `pythonify_res_fields': ./MySQLmodule.c:384: invalid lvalue in unary `&' ./MySQLmodule.c: In function `STH_fetchdict': ./MySQLmodule.c:1125: invalid lvalue in unary `&' ./MySQLmodule.c:1147: invalid lvalue in unary `&' make: *** [MySQLmodule.o] Error 1 Can you help me ? Does DigitalCreation have a solution on connecting to MySQL on a Linux Platform (thanks to ODBC or something else). Thanks in advance. -- -------------------------------------------------------------------------- Fabrice FRASSAINT (fabrice.frassaint(a)o-technologies.com) O Technologies 136 Avenue des Champs Elysees PARIS 8ème 01 40 76 24 24

3 2

date manipulations
by Graham Chiu 19 Mar '00

19 Mar '00

I want to add an hour to a date... this doesn't work Closedate is: <dtml-var "closedate.aCommon()"> <dtml-call "REQUEST.set('newdate',closedate+1/24)"> Closedate + 1 hour is: <dtml-var "newdate.aCommon()"> But this does Closedate is: <dtml-var "closedate.aCommon()"> <dtml-call "REQUEST.set('newdate',closedate+.04167)"> Closedate + 1 hour is: <dtml-var "newdate.aCommon()"> Win32 2.1.3 ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin

2 1

Are You A Victim of Propaganda?
by galloway＠GEOG.UTORONTO.CA 19 Mar '00

19 Mar '00

FREE NetLinks Guaranteed To SAVE You MONEY! Please be advised, links presented in this email have been sent E-nonymously without the knowledge or consent of the domain owners. The Internet is World Public Domain, which can, and should be shared freely. Information Advocates Association "Knowledge is Power" Here are a few sites we found very useful. ----------------------------------------------------------------- ----------------------------- Music Anyone?: http://www.listen.com This site is guaranteed to be for everyone. It does'nt matter what your listening please may be they have it here. All songs available for dowmload and immediate use. N-Joy! Beware of Internet Scams: http://www.rcmp-grc.gc.ca If you are concerned with email ads or websites offering opportunities or programs that may seem suspicious, report it to this site. They have the latest and most common scams circulated on the net. Free Internet: http://www.thesimpsons.com Don't want to continue paying $19.95 or more just to Surf the Net? This site offers the future of the Internet, Today. Never pay to Surf again. In this case, Free Does Mean Free! Cheap Phone Rates: http://www.voicelinkinc.com We found a .04cents long distance rate, no switching, no fees and low international rates using 10-10 access numbers. If you can handle the 10 minute minimum, you're in business. Invention Fraud: http://www.inventorfraud.com If you are trying to submit your invention for patent be very cautious. The site list a number of companies that are out to get your money and ones that provide viable patent services. FREE 800 Number & Voice Mail: http://www.ureach.com Here you can get a FREE voicemail account and 800 number. Just sign up for the service. FREE Website Development: http://www.bigstep.com This site offers an opportunity for you to develop and design your very own website for FREE! They offer different ready to use formats that will assist you in the development of your site. Know Your Schedule: http://www.anyday.com This site offers an online personal calendar including a private address book and events schedule that can be accessed from anywhere. You also have the option of sharing your schedule with colleagues via the Net. Need To Send A Large File: http://www.whalemail.com The is a great service for sending large files up to 50 megs, your regular ISP just can't handle that kind of load. Go ahead, transfer you entire C Drive to the ones you love most. It's even FREE! Nice guys huh? Internet Service Providers: http://www.thelist.com Don't like the service you've been getting from your present Internet Service Provider? Take a look at the more than 8,000 ISP's you have to choose from. You're Not Stuck! Nothing But FREE Stuff: http://www.thefreesite.com Now who doesn't like Free Stuff that is really Free? This site is a ton-of-fun and there is something for everyone. It offers a multitude of freebies and we are sure you may find something that interest you. Free Fax Service: http://www.fax4free.com Here you can get a free fax phone number and receive your faxes on your computer. You can print your faxes out on your printer. Print quality is much higher than normal fax machines. Looking For A Job or Career? http://www.jobfinders.com This site is very user friendly. If you are in need of searching for that one job you can't seem to locate anywhere else, this site is up to the challenge. International Directory Assistance Online: http://www.infobel.com If you have ever gotten International Directory Assistance from AT&T then you are aware that you can easily pay up to $9.00 dollars for that information. Here is an online solution and it's free. Get Directions Anywhere: http://www.mapquest.com It does not matter where you're trying to go, this site will provide with complete details and instructions on how to get there. See for yourself. Traveling has never been easier! Looking For Someone? http://www.discreetdatasystems.com Yes, this site will assist you in finding that someone special or not so special, whatever the case maybe. You will need to have some basic information regarding your search, but the site does deliver.

1 0

Getting all exceptions into log file
by Jon Prettyman 18 Mar '00

18 Mar '00

Is there a way to get all exceptions errors that are shown to a user also sent to the STUPID log? -Jon

1 0

SQLSESSION problem
by Graham Chiu 18 Mar '00

18 Mar '00

I've just started to try this out ... I set the variable thus... <dtml-call "SESSION.set('muserid',LOGIN)"> but later on when I try and use this session variable ... <INPUT maxLength="30" name="LOGIN" size="30" TYPE="TEXT" value=" <dtml-if "SESSION.has_key('muserid')"> <dtml-var "SESSION['muserid']"> </dtml-if>" /> It dies with ... Error Type: NameError Error Value: upper with the following traceback File D:\zope2\lib\python\DocumentTemplate\DT_Util.py, line 335, in eval (Object: SESSION['muserid']) (Info: SESSION) File <string>, line 0, in ? File D:\zope2\lib\python\DocumentTemplate\DT_Util.py, line 161, in careful_getitem File d:\zope2\lib\python\Products\SQLSession\SQLSession.py, line 99, in __getitem__ File d:\zope2\lib\python\Products\SQLSession\SQLSession.py, line 389, in sqlattr (Object: NoBrains) NameError: (see above) ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin

1 0

SQL Server ODBC Error
by Guy Davis 18 Mar '00

18 Mar '00

I am having some trouble getting Zope to work with a MS SQL Server database. I can set the ODBC connection on the server and then add ZODBC connection to a folder matching that connection. I can browse the new connection and see the tables, but when I try to test any simple SQL I get the following error: ValueError unpacked sequence of wrong size Any clues? Thanks. -- Guy Davis mailto:davis@arc.ab.ca (403) 210-5334 Alberta Research Council

3 2

setting the client namespace for a DTML Method
by gyst＠nfg.nl 18 Mar '00

18 Mar '00

[ This message never made it to the list somehow, reposting now... ] X-From-Line: nobody Thu Mar 16 12:09:02 2000 X-Face: QmL':f1ZwaRtW?E^9)c*r4r[',ky+1<e`?s,[rt'*s@6awNjJQ?,s8ArMu7TD"pJW(KI!I% BY-c##<^KlGL@'#YWptcmBOP0\1\y/$(OO*3-V~>8?<2\;7#Dwh,9ut}(dpQCo}ydCZZ~,? X-Attribution: gyst Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: text/plain; charset=US-ASCII Message-ID: <87n1nz894w.fsf(a)wiz.wiz> X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald" Lines: 56 Xref: wiz.wiz sent-mail:4525 X-Gnus-Article-Number: 4525 Thu Mar 16 12:09:02 2000 When Zen borders on Kamikaze..... DTML Document --> product method --> DTML method I've been banging my head against this for 4 days in a row now. I want to call a DTML method, via a product method, from a DTML document, but I don't succeed in setting the client namespace for the DTML method to the original DTML Document's namespace. I'd appreciate any help! I have a DTML document. It has a valid aq_parent. From this DTML document, I'm calling a product method, passing the DTML documents's aq_parent as an argument: <dtml-var "NFGnavCore.aqqy(aq_parent)"> This method has access to the aq_parent object all right, tested OK. Next, the DTML method is called from the product python method and the original aq_parent object is given as the new acquisition context: def aqqy(self, context=None): """ some test method""" retval= "Hi! I'm the aqqy method, called with context.id %s" % context.id return retval + self.aqqy_helper(client=context) The DTML method 'aqqy_helper' is called all right, but has no access to the context object passed in. Any attempt to access objects that should be in the acquired namespace, for example: My aq_parent id= <dtml-var "aq_parent.id"> results in an error message: You are not authorized to access aq_parent. Which, if I'm not mistaken, is caused by the validate routine called from OFS/DTMLMethod.py as documented in 'oldvalidate()': if inst is parent: raise 'Unauthorized', ( 'You are not authorized to access %s.' % name) So what am I doing wrong, and what is the right way to call DTML methods from product methods? :*CU# -- *** Guido A.J. Stevens *** mailto:gyst@nfg.nl *** *** Net Facilities Group *** tel:+31.43.3618933 *** *** http://www.nfg.nl *** fax:+31.43.3560502 *** By 2003, most industrial countries wil log and analyze the movements of every citizen. [Pearson, ISBN 0-02-862089-5, p.62]

1 0

hmmm - newly upgraded to 2.1.5 from source
by Dr. Ross Lazarus 18 Mar '00

18 Mar '00

sunos 5.6 source distribution upgraded with 2.1.x to 2.1.5 and recompiled, fastcgi -> apache... I just noticed this on the console that I started my newly upgraded 2.1.5 zope from zope on sin~/zope215/lib/python>Unhandled exception in thread: Traceback (innermost last): File "/usr/local/zope/zope215/ZServer/PubCore/ZServerPublisher.py", line 97, i n __init__ response._finish() File "/usr/local/zope/zope215/ZServer/FCGIServer.py", line 699, in _finish 'log_request')) File "/usr/local/zope/zope215/ZServer/FCGIServer.py", line 564, in push if send: self.initiate_send() File "/usr/local/zope/zope215/ZServer/medusa/asynchat.py", line 206, in initia te_send self.refill_buffer() File "/usr/local/zope/zope215/ZServer/medusa/asynchat.py", line 190, in refill _buffer self.producer_fifo.pop() File "/usr/local/zope/zope215/ZServer/medusa/asynchat.py", line 264, in pop del self.list[0] IndexError: list assignment index out of range anyone ? I'll drop it in the collector. -- Dr Ross Lazarus Associate Professor and Sub-Dean for Information Technology Faculty of Medicine, Room 126A, A27, University of Sydney, Camperdown, NSW 2006, Australia Tel: (+61 2) 93514429 Mobile: +61414872482 Fax: (+61 2) 93516646 Email: rossl(a)med.usyd.edu.au

1 0

FYI: Trip to Colorado
by Paul Everitt 18 Mar '00

18 Mar '00

Howdy folks. Sorry for the late announcement, but I've just confirmed a trip to the Colorado Linux Info Quest: http://www.thecliq.org/ I'll be doing a demo and a BOF. If anybody in the area would like to chat, please drop by! --Paul

2 1

security
by sam 18 Mar '00

18 Mar '00

Besides the AUTHORIZED_USER field in the http header what else does zope use to identify an http packet from a browser ?. I am just wondering can I not masquerade as a user by setting the http header using httplib or some such utility ?. I have not seen any session ids in the REQUEST variable which is supposed to contain all the variables in the browser request thanks sathya -- ########################## necessity is the mother of invention ##########################

3 3