- Zope - Zope lists

Installation of MySQLDatabaseAdabpter : i have the error ' Impo rtError: No module named _mysql'
by Gostnerr 27 Feb '02

27 Feb '02

Hello, First of all, I have installed MySQL under /user/local/mysql ( it was the sorce version) then under /zopehome I have extract the ZMySQLDA-2.0.9b1.tar.gz ( it extracted to /zopehome/lib/python/Product/ZMySQLDA then under /zopehome/lib/python/Product I have extracted MySQL-python-0.9.0.tar.gz then i do ' python setup.py build ' ( there was an error message) then I edit the setup.py file under ' /zopehome/lib/python/Product/MySQL-python-09' ( because there was this error : mysql.h .. no such file or dirctory ) a) elif os.name == "posix": #most linux platforms include_dirs = ['usr/include/mysql'] libary_dirs = [' usr/lib/mysql'] ----------> include_dirs = ['usr/local/mysql/include/mysql'] libary_dirs = [' usr/local/mysql/lib/mysql'] (because there was the file mysql.h) after that i do ' python setup.py build ' ( there was no error message) and then ' python setup.py install' ( also no error message) After that all I started the zope server , and i received an Error Message Anybody knows why ?? I have no idea ! Roswitha ------------------------------------------- there is the bash output ---------------------------------------------------------------------- linux:/usr/local/ZopePark/Testserver/lib/python/Products/MySQL-python-0.9.0 # python setup.py build running build running build_py not copying CompatMysqldb.py (output up-to-date) not copying _mysql_exceptions.py (output up-to-date) not copying MySQLdb/__init__.py (output up-to-date) not copying MySQLdb/converters.py (output up-to-date) not copying MySQLdb/connections.py (output up-to-date) not copying MySQLdb/cursors.py (output up-to-date) not copying MySQLdb/sets.py (output up-to-date) not copying MySQLdb/times.py (output up-to-date) not copying MySQLdb/constants/__init__.py (output up-to-date) not copying MySQLdb/constants/CR.py (output up-to-date) not copying MySQLdb/constants/FIELD_TYPE.py (output up-to-date) not copying MySQLdb/constants/ER.py (output up-to-date) not copying MySQLdb/constants/FLAG.py (output up-to-date) not copying MySQLdb/constants/REFRESH.py (output up-to-date) not copying MySQLdb/constants/CLIENT.py (output up-to-date) running build_ext skipping '_mysql' extension (up-to-date) linux:/usr/local/ZopePark/Testserver/lib/python/Products/MySQL-python-0.9.0 # python setup.py install# invalid command name 'install#' linux:/usr/local/ZopePark/Testserver/lib/python/Products/MySQL-python-0.9.0 # python setup.py install running install running build running build_py not copying CompatMysqldb.py (output up-to-date) not copying _mysql_exceptions.py (output up-to-date) not copying MySQLdb/__init__.py (output up-to-date) not copying MySQLdb/converters.py (output up-to-date) not copying MySQLdb/connections.py (output up-to-date) not copying MySQLdb/cursors.py (output up-to-date) not copying MySQLdb/sets.py (output up-to-date) not copying MySQLdb/times.py (output up-to-date) not copying MySQLdb/constants/__init__.py (output up-to-date) not copying MySQLdb/constants/CR.py (output up-to-date) not copying MySQLdb/constants/FIELD_TYPE.py (output up-to-date) not copying MySQLdb/constants/ER.py (output up-to-date) not copying MySQLdb/constants/FLAG.py (output up-to-date) not copying MySQLdb/constants/REFRESH.py (output up-to-date) not copying MySQLdb/constants/CLIENT.py (output up-to-date) running build_ext skipping '_mysql' extension (up-to-date) running install_lib not copying build/lib.linux-i686-2.1/CompatMysqldb.py (output up-to-date) not copying build/lib.linux-i686-2.1/_mysql_exceptions.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/__init__.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/converters.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/connections.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/cursors.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/sets.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/times.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/__init__.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/CR.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/FIELD_TYPE.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/ER.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/FLAG.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/REFRESH.py (output up-to-date) not copying build/lib.linux-i686-2.1/MySQLdb/constants/CLIENT.py (output up-to-date) not copying build/lib.linux-i686-2.1/_mysql.so (output up-to-date) skipping byte-compilation of /usr/lib/python2.1/site-packages/CompatMysqldb.py to CompatMysqldb.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/_mysql_exceptions.py to _mysql_exceptions.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/__init__.py to __init__.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/converters.py to converters.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/connections.py to connections.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/cursors.py to cursors.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/sets.py to sets.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/times.py to times.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/__init__.py to __init__.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/CR.py to CR.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/FIELD_TYPE.py to FIELD_TYPE.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/ER.py to ER.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/FLAG.py to FLAG.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/REFRESH.py to REFRESH.pyc skipping byte-compilation of /usr/lib/python2.1/site-packages/MySQLdb/constants/CLIENT.py to CLIENT.pyc linux:/usr/local/ZopePark/Testserver/lib/python/Products/MySQL-python-0.9.0 # cd .. linux:/usr/local/ZopePark/Testserver/lib/python/Products # cd .. linux:/usr/local/ZopePark/Testserver/lib/python # cd .. linux:/usr/local/ZopePark/Testserver/lib # cd .. linux:/usr/local/ZopePark/Testserver # ./start & [1] 1239 linux:/usr/local/ZopePark/Testserver # ------ 2002-02-26T09:20:11 ERROR(200) Zope Could not import Products.ZMySQLDA Traceback (innermost last): File /usr/local/ZopePark/Testserver/lib/python/OFS/Application.py, line 563, in import_product File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/__init__.py, line 91, in ? File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/DA.py, line 92, in ? File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/db.py, line 89, in ? ImportError: No module named _mysql ------ 2002-02-26T09:20:11 PANIC(300) z2 Startup exception Traceback (innermost last): File /usr/local/ZopePark/Testserver/z2.py, line 564, in ? File <string>, line 1, in ? File /usr/local/ZopePark/Testserver/lib/python/Zope/__init__.py, line 110, in ? File /usr/local/ZopePark/Testserver/lib/python/ZODB/FileStorage.py, line 267, in __init__ File /usr/local/ZopePark/Testserver/lib/python/ZODB/lock_file.py, line 101, in lock_file StorageSystemError: Could not lock the database file. There must be another process that has opened the file. <p> [1]+ Done ./start linux:/usr/local/ZopePark/Testserver # ./stop linux:/usr/local/ZopePark/Testserver # ./start ------ 2002-02-26T09:21:45 ERROR(200) Zope Could not import Products.ZMySQLDA Traceback (innermost last): File /usr/local/ZopePark/Testserver/lib/python/OFS/Application.py, line 563, in import_product File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/__init__.py, line 91, in ? File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/DA.py, line 92, in ? File /usr/local/ZopePark/Testserver/lib/python/Products/ZMySQLDA/db.py, line 89, in ? ImportError: No module named _mysql ------ 2002-02-26T09:21:47 INFO(0) ZServer HTTP server started at Tue Feb 26 10:21:47 2002 Hostname: localhost Port: 8080 ------ 2002-02-26T09:21:47 INFO(0) ZServer FTP server started at Tue Feb 26 10:21:47 2002 Hostname: linux Port: 8021 ------ 2002-02-26T09:21:47 INFO(0) ZServer PCGI Server started at Tue Feb 26 10:21:47 2002 Unix socket: /usr/local/ZopePark/Testserver/var/pcgi.soc

1 0

manage_change_history
by Zimmermann, Mark 27 Feb '02

27 Feb '02

hi, i heard about "manage_change_history" is there someone who can tell me how i could create a list of all history versions of a dtml document ? like dtml-in manage_change_history version number user date content of DTML Document /dtml-in I already use <dtml-if manage_change_history> <dtml-in manage_change_history mapping> <dtml-if sequence-start> <dtml-var user_name> </dtml-if> </dtml-in> </dtml-if> but this gives me only "one" user_name back :-(

1 0

RE: [Zope] Convert Help
by Smith, Neil 27 Feb '02

27 Feb '02

It sounds to me like you want a ZSQL method that contains code something like: Argument myList:list:int Code: <dtml-if myList> <dtml-in myList> <dtml-if "_['sequence-item']"> insert into myTable values (<dtml-var "_['sequence-item']">) <dtml-var sql_delimiter> </dtml-if> </dtml-in> </dtml-if> Neil -----Original Message----- From: Todd Loomis [mailto:tloomis@dmso.mil] Sent: 26 February 2002 18:26 To: zope(a)zope.org Subject: [Zope] Convert Help All: I need to take the elements in the list ['1', '2', '3'] and make them separate SQL Statements: insert into table values ('1') insert into table values ('2') insert into table values ('3') how can i do this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Todd Loomis SAIC - DMSO Support 1901 N. Beauregard Street, Suite 500 Alexandria, VA 22311 Office: 703.824.3407 Fax: 703.379.3778 tloomis(a)dmso.mil ********************************************************************** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify postmaster(a)npower.com (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy plc group of companies. **********************************************************************

1 0

Create Image on the Fly
by Zimmermann, Mark 27 Feb '02

27 Feb '02

Hi, last year i work with Perl and PHP and there i can create Text within images. Is there a ZOPE Product to create text within images ? I have a "empty" buttonimage and with this product i hope i can create textbuttons.

1 0

Zope hangs with the help section
by Juan Garcia Garcia 27 Feb '02

27 Feb '02

Hi, my problem is that Zope hangs when i want to enter in the Help section. I installed Zope a few months ago and it worked perfectly, but since yesterday i have the problem explained before. I haven't installed or upgraded nothing in the last weeks. I have Zope 2.4.2 in Debian/woody. Has anyone seen this problem before? Thanks. Bye Juan

1 0

Security issue with the Guest book example in Zope Book
by Joakim Nicander 27 Feb '02

27 Feb '02

Hi, I'm relatively new to Zope so I hope I haven't missed anything obvious. I'm building a small project manager for an intranet site. Normally I use MySQL to store data but this time I store the information in DTML Documents as the Guest book example. Text in the document and adding properties to the document. The information is added to Zope via an input form exactly as in the example. Then rendering the document with html_qoute so the cant sneak in html code. But it doesn't stop sneaking in DTML code as I found out when I tested. Ok maybe I missed something I thought, so I implemented the guest book from the Zope book. Still no protection against DTML code. I can get information form Zope and of course crash the guest book. I can easily change my project manager to add the text in a property so it wont render. Other suggestions? But I don't think an example in the Zope book should have this security issue. I hope I missed something. /Nocke

1 0

user accounts
by Richard Hewison 27 Feb '02

27 Feb '02

This is a problem that has dogged us for ages, and this is probably the third time we've asked for help here. Basically, new users added to specific folders within Zope (via the acl_users folder) cannot login to the system. The only account that seems to work fine is the one for the 'admin' user. The most annoying thing about this is that it *did* work when we first installed Zope, but somewhere down the line it stopped. This has happened on two different servers with two different operating systems (Sun SOlaris and now Linux) and two different versions of Zope (2.4.1 and 2.4.3). It's a fairly serious problem if we want to use Zope to handle our main web site in the future. Anyone had this and solved it? Does v2.5 have this as well? Richard H.

3 3

HOWTO collection
by Tille, Andreas 27 Feb '02

27 Feb '02

Hello, I just builded Debian packages from the Zope Book and Zope Development Guide. I consider the collection of the various HOWTOs as a valuable resource which I would like to check when developing offline. Thus I would like a tar archive of the HOWTO collection which I could easily handle (or even build a Debian package from it). Is there any possibility to get all the HOWTOs in a handy format? Kind regards Andreas.

1 0

Re: [Zope] Saving files to zope using Dreamweaver?
by Paul Browning 27 Feb '02

27 Feb '02

--On 26 February 2002 19:39 -0700 Enoch Norton <enochsnorton(a)yahoo.com> wrote: > I am a really new user of Zope. In going through the Zope book I am > stumped in the following section. I seem to be missing some very > important key piece of information. I have tried to save my Dreamweaver > templates to the ../index_html/source.html. However because index_html is > not a folder the ftp client in Dreamweaver will not allow me to access > the url. I guess I don't understand how one is supposed to save a file to > a URL when the file.Save As.. option is dependent upon directories. If > anyone has some insight to offer please let me know. I have to say (and I may be missing something fundamental here) that the source.html stuff seems like a red herring. What you need to do is have Dreamweaver access the webdav_source_port (so you get the unrendered DTML or ZPT code - search the list archives for more information about this). There's a proto-HowTo on using DW at: http://lib-srvr5.lib.bris.ac.uk:20080/zpt_test/weweb/dw4zope.pt This is also part of me learning how to use ZPT and so to understand why this page looks like it does see: http://lib-srvr5.lib.bris.ac.uk:20080/zpt_test/weweb/howto.htm When I'm more confident I'm doing the right things I'll move these on to the Zope site. I've played with GoLive too. I don't like the way DW forces you to work with a local and remote site - GoLive is nicer in this respect in that it allows you to edit the remote site directly. But DW has a more intuitive interface in terms of editing pages IMHO. Now: a question of others who've been using DW or GoLive - are you doing it over SSL? Both seem broken when it comes to https URLs. I've had some success using WebDrive 5.0 over SSL (version 4 doesn't work) but _only_ with GoLive. Dreamweaver insists on changing the mime-type of any ZPT is saves via WebDrive. Amazingly even FrontPage becomes a useful and benign ZPT wysiwyg editor when used via WebDrive! Any workarounds (or suggestions of same) for the DW-WebDrive problem (or inside information about when DW or GoLive are going to support secure protocols) greatly appreciated. Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning(a)bristol.ac.uk URL: http://www.bris.ac.uk/

1 0

Where to see Zope Syntax? Book? Grepping?
by lmckusic＠specialparents.com 27 Feb '02

27 Feb '02

After starting with the Zope Book and the 2.5.0 Tutorial I want to see more formal syntax so I can write form screens and ZSQL. So far the help screens and tutorial leave me puzzled. I don't understand enough Zope design and I don't understand enough Python to grep the source. Question One is: Please recommend the best next book. I need form syntax. I need to understand Zope ZSQL syntax and examples for dump, import, backup and transactions. Question Two is: If grepping the Zope source is the best way to understand Zope, could you please show me an sample grep?

2 1