- Zope - Zope lists

ANN: eGenix mxODBC Connect 1.0.1 - Python Database Interface
by eGenix Team: M.-A. Lemburg 19 Mar '09

19 Mar '09

________________________________________________________________________ ANNOUNCING eGenix.com mxODBC Connect Python Database Interface Version 1.0.1 Our new client-server product for connecting Python applications to relational databases - from all major platforms This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mxODBC-Connect-1.0.1-GA.html ________________________________________________________________________ INTRODUCTION The mxODBC Connect Database Interface for Python allows users to easily connect Python applications to all major databases on the market today in a highly portable and convenient way. Unlike our mxODBC Python extension, mxODBC Connect is designed as client-server application, so you no longer need to find production quality ODBC drivers for all the platforms you target with your Python application. Instead you use an easy to install Python client library which connects directly to the mxODBC Connect database server over the network. This makes mxODBC Connect the ideal basis for writing cross-platform database programs and utilities in Python, especially if you run applications that need to communicate with databases such as MS SQL Server and MS Access, Oracle Database, IBM DB2 and Informix, Sybase ASE and Sybase Anywhere, MySQL, PostgreSQL, SAP MaxDB and many more, that run on Windows or Linux machines. By removing the need to install and configure ODBC drivers on the client side, mxODBC Connect greatly simplifies setup and configuration of database driven client applications, while at the same time making the network communication between client and database server more efficient and more secure. For more information, please see the product page: http://www.egenix.com/products/python/mxODBCConnect/ ________________________________________________________________________ NEWS mxODBC Connect 1.0.1 is a patch-level release of our new mxODBC Connect product. * More Robust We have made the client and server more robust in case of communication failures. Even if the client applications fail to shutdown the server connection before exiting, the server will free up resources used by the client on the server side and rollback transactions as necessary. * More Platform Support With the 1.0.1 release we are also providing much better platform support for the mxODBC Connect Client: we have fixed a problem in 1.0.0 that prevented the installation of the pre-built clients on non-Linux systems. The mxODBC Connect Client can now be installed on most platforms supported by Python, since it is written in a platform independent, portable way. The pre-built archives also make it possible to integrate the clients into build system such as buildout (used in Zope and Plone) or other distutils-based deployment systems. * Ideal for Building Bridges As a result, connecting from e.g. Mac OS X to an SQL Server database has never been easier. You can even keep the data sources you already have configured on your Windows machine and connect to them as if your application were running on the database server itself. ________________________________________________________________________ UPGRADING You are encouraged to upgrade to this latest mxODBC Connect release. When upgrading, please always upgrade both the server and the client installations to the same version - even for patch level releases. Customers who have purchased mxODBC Connect 1.0 licenses can download and upgrade their existing installations without having to purchase new licenses or upgrades. The licenses will continue to work with version 1.0.1. Users of our stand-alone mxODBC product will have to purchase new licenses from our online shop in order to use mxODBC Connect. You can request 30-day evaluation licenses by visiting our web-site or writing to sales(a)egenix.com, stating your name (or the name of the company) and the number of eval licenses that you need. http://www.egenix.com/products/python/mxODBCConnect/#Evaluation ________________________________________________________________________ DOWNLOADS The download archives as well as instructions for installation and configuration of the product can be found on the product page: http://www.egenix.com/products/python/mxODBCConnect/ Evaluation licenses for the server part are available free of charge: http://www.egenix.com/products/python/mxODBCConnect/#Evaluation The client part of mxODBC Connect is always free of charge. _______________________________________________________________________ SUPPORT Commercial support for this product is available from eGenix.com. Please see http://www.egenix.com/services/support/ for details about our support offerings. Enjoy, -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Mar 19 2009) >>> Python/Zope Consulting and Support ... http://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ ________________________________________________________________________ ::: Try our new mxODBC.Connect Python Database Interface for free ! :::: eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611 http://www.egenix.com/company/contact/

1 0

Question about InvariantsValidator on a GroupForm (z3c.form)
by Oliver Roch 18 Mar '09

18 Mar '09

Hi all, i'm having a problem getting an InvariantsValidator working on a grouped form using z3c.form. Imagine the following setup: class GroupOne(Group): fields = Fields(IMyForm).select('second_attribute', 'third_attribute') class GroupTwo(Group): fields = Fields(IMyForm).select('fourth_attribute', 'fifth_attribute') class MyForm(GroupForm, Form): fields = Fields(IMyForm).select('first_attribute') groups = (GroupOne, GroupTwo) Now, the z3c.form.validator.Data object passed to my InvariantsValidator only contains the 'first_attribute'. I think this is caused by line 190 in field.py: def validate(self, data): fields = self.form.fields.values() Why is this method only looking for form.fields and not aggregating form.fields and possible form.groups? Is it an unsupported use case, or am i just not getting it? Thanks, Oliver

1 0

read-only-database
by Ulla Theiss 17 Mar '09

17 Mar '09

Hello list, I want to run the database in read-only mode from CD and configured it accordingly in the zope.conf: read-only-database on enable-product-installation off zserver-read-only-mode on Starting Zope, I get the following error: Traceback (most recent call last): File "\Programme\Zope\lib\python\Zope2\Startup\run.py", line 56, in ? run() File "\Programme\Zope\lib\python\Zope2\Startup\run.py", line 21, in run starter.prepare() File "E:\Programme\Zope\lib\python\Zope2\Startup\__init__.py", line 98, in pre pare self.startZope() File "E:\Programme\Zope\lib\python\Zope2\Startup\__init__.py", line 257, in st artZope Zope2.startup() File "E:\Programme\Zope\lib\python\Zope2\Startup\__init__.py", line 47, in sta rtup starter.setConfiguration(cfg) File "D:\Programme\Zope\lib\python\Zope2\App\startup.py", line 56, in startup File "D:\Programme\Zope\lib\python\DBTab\DBTab.py", line 96, in getDatabase File "D:\Programme\Zope\lib\python\DBTab\DBTab.py", line 113, in _createDataba se File "E:\Programme\Zope\lib\python\Zope2\Startup\datatypes.py", line 163, in o pen DB = self.createDB() File "E:\Programme\Zope\lib\python\Zope2\Startup\datatypes.py", line 160, in c reateDB return ZODBDatabase.open(self) File "D:\Programme\Zope\lib\python\ZODB\config.py", line 97, in open File "D:\Programme\Zope\lib\python\ZODB\config.py", line 133, in open File "D:\Programme\Zope\lib\python\ZODB\FileStorage\FileStorage.py", line 112, in __init__ File "D:\Programme\Zope\lib\python\ZODB\lock_file.py", line 57, in __init__ IOError: [Errno 13] Permission denied: '\\Zope-Instance/var/Data.fs.lock' r+ means opening the file for updating. This has not to do anything with read-only. Does anybody know what I have to configure additionaly, that read-only works? I run Zope 2.8.4 on windows. Many thanks in advance, Ulla.

4 6

Zope and SSL
by Catherine E. Reinehr 16 Mar '09

16 Mar '09

Hello, I'm trying to find out how to generate a CSR, and I can't find the information I need. All my research covers Zope and Apache or Zope and Linux, etc., but our server is running ONLY Zope. Version 2.6.2, to be exact. Unfortunately, I know next to nothing about setting up a secure server anyway. Any help you can offer would be much appreciated! Thanks, Cat ----- Catherine E. Reinehr Webmaster & Director of Publications Huntingdon College 1500 E. Fairview Ave. Montgomery, AL 36106 (334) 833-4429 / Flowers 218B

4 3

calling javascript method from dtml method
by Dvir Bar-lev 16 Mar '09

16 Mar '09

Hi Is there any way to call a javascript method from a dtml method somewhere in the body of it? The method cam be in a different js file which is preferable or in the dtml method if there is no other way, from what I found on the web it looks like I can't but I want to make sure that I didn't miss anything

3 2

CookieCrumbler question
by Dvir Bar-lev 12 Mar '09

12 Mar '09

Hi I used the CookieCrumbler plugin the make a log in. I added the CookeCrumbler(standalone> from the ZMI , and now I have a log in form that acts oka but I want logout the user, so what I did was call the logout function of cookiecrumbler like this: <dtml-call expr="logout()"> And that does bring me to the logged_out dtml but if I push the back button and return to the logged_in and press the refresh button I still get the result as if the user is till logged in. Do I have to do anything else besides calling the logout function to make sure that the user is now back ti anonymus status?

2 4

Order of method calls of ZopePageTemplate
by Analog Kid 12 Mar '09

12 Mar '09

Hi All: I need to know the order of method calls inside ZopePageTemplate.py whenever a form from the PT is submitted or even when the PT is rendered. Can anyone shed some light on this please? TIA, AK

4 10

redirect timeout doesn't work
by Dvir Bar-lev 12 Mar '09

12 Mar '09

Hi I want to redirect a user from my page to another page after a certain time, I put this code in the dtml page at the top I want to redirect from: <dtml-call "REQUEST.RESPONSE.setHeader('Refresh', '5', 'URL Address')"> But although it does refresh after the timeout it stays in the same page instead of going to the address listed in URLAddress. Anyone knows what I did wrong? Or I even did it the right way?

4 6

session data object question
by Dvir Bar-lev 11 Mar '09

11 Mar '09

Hi I was wondering if there is a way to connect the creation of a session object to a button push. I'll explain in more detail: I have a log in from called login_form, and I have a dtml method called looged_in that is called when we push the submit button in the log in form. What I did is the following, in the log_in_form I get a session data object only if it exsists and I check how much time passed and act accordingly, in the looged_in method I create the data session oblject ans set the start time. Unfortuantly that is not good for me because if a user refreshes the page it resets the time in the session object, I was wondering if there is a way for me to know if I can reset the session data time only when the user clicks the submit button and not as a result of a refresh call. I tried looking on the web and in the zope book but I couldn't find anything.

3 7

Can't start Zope
by Ken Winter 10 Mar '09

10 Mar '09

I have done something to my Zope instance that has prevented Zope from starting (after many years of working fine). Can you help me find a way out? Here's the command and the results: dhatoffice@05 /usr/local/zope/instance3/bin # ./zopectl start /usr/local/zope/298/lib/python/persistent/__init__.py:19: RuntimeWarning: Python C API version mismatch for module cPersistence: This Python has API version 1013, module cPersistence has version 1012. from cPersistence import Persistent, GHOST, UPTODATE, CHANGED, STICKY /usr/local/zope/298/lib/python/persistent/__init__.py:19: RuntimeWarning: Python C API version mismatch for module TimeStamp: This Python has API version 1013, module TimeStamp has version 1012. from cPersistence import Persistent, GHOST, UPTODATE, CHANGED, STICKY /usr/local/zope/298/lib/python/persistent/__init__.py:20: RuntimeWarning: Python C API version mismatch for module cPickleCache: This Python has API version 1013, module cPickleCache has version 1012. from cPickleCache import PickleCache /usr/local/zope/298/lib/python/zope/interface/interface.py:156: RuntimeWarning: Python C API version mismatch for module _zope_interface_coptimizations: This Python has API version 1013, module _zope_interface_coptimizations has version 1012. from _zope_interface_coptimizations import SpecificationBase /usr/local/zope/298/lib/python/ExtensionClass/__init__.py:105: RuntimeWarning: Python C API version mismatch for module _ExtensionClass: This Python has API version 1013, module _ExtensionClass has version 1012. from _ExtensionClass import * /usr/local/zope/298/lib/python/AccessControl/ImplC.py:18: RuntimeWarning: Python C API version mismatch for module cAccessControl: This Python has API version 1013, module cAccessControl has version 1012. from cAccessControl import rolesForPermissionOn, \ /usr/local/zope/298/lib/python/Acquisition/__init__.py:3: RuntimeWarning: Python C API version mismatch for module _Acquisition: This Python has API version 1013, module _Acquisition has version 1012. from _Acquisition import * /usr/local/zope/298/lib/python/Record/__init__.py:59: RuntimeWarning: Python C API version mismatch for module _Record: This Python has API version 1013, module _Record has version 1012. from _Record import Record Traceback (most recent call last): File "/usr/local/zope/298/lib/python/Zope2/Startup/zopectl.py", line 329, in <module> main() File "/usr/local/zope/298/lib/python/Zope2/Startup/zopectl.py", line 287, in main options.realize(args) File "/usr/local/zope/298/lib/python/Zope2/Startup/zopectl.py", line 95, in realize ZDOptions.realize(self, *args, **kw) File "/usr/local/zope/298/lib/python/zdaemon/zdoptions.py", line 273, in realize self.load_schema() File "/usr/local/zope/298/lib/python/zdaemon/zdoptions.py", line 321, in load_schema self.schema = ZConfig.loadSchema(self.schemafile) File "/usr/local/zope/298/lib/python/ZConfig/loader.py", line 31, in loadSchema return SchemaLoader().loadURL(url) File "/usr/local/zope/298/lib/python/ZConfig/loader.py", line 65, in loadURL return self.loadResource(r) File "/usr/local/zope/298/lib/python/ZConfig/loader.py", line 159, in loadResource schema = ZConfig.schema.parseResource(resource, self) File "/usr/local/zope/298/lib/python/ZConfig/schema.py", line 27, in parseResource xml.sax.parse(resource.file, parser) File "/usr/local/lib/python2.5/xml/sax/__init__.py", line 33, in parse parser.parse(source) File "/usr/local/lib/python2.5/xml/sax/expatreader.py", line 107, in parse xmlreader.IncrementalParser.parse(self, source) File "/usr/local/lib/python2.5/xml/sax/xmlreader.py", line 123, in parse self.feed(buffer) File "/usr/local/lib/python2.5/xml/sax/expatreader.py", line 207, in feed self._parser.Parse(data, isFinal) File "/usr/local/lib/python2.5/xml/sax/expatreader.py", line 301, in start_element self._cont_handler.startElement(name, AttributesImpl(attrs)) File "/usr/local/zope/298/lib/python/ZConfig/schema.py", line 99, in startElement getattr(self, "start_" + name)(attrs) File "/usr/local/zope/298/lib/python/ZConfig/schema.py", line 475, in start_schema keytype, valuetype, datatype = self.get_sect_typeinfo(attrs) File "/usr/local/zope/298/lib/python/ZConfig/schema.py", line 201, in get_sect_typeinfo datatype = self.get_datatype(attrs, "datatype", "null", base) File "/usr/local/zope/298/lib/python/ZConfig/schema.py", line 194, in get_datatype return self._registry.get(dtname) File "/usr/local/zope/298/lib/python/ZConfig/datatypes.py", line 398, in get t = self.search(name) File "/usr/local/zope/298/lib/python/ZConfig/datatypes.py", line 423, in search package = __import__(n, g, g, component) File "/usr/local/zope/298/lib/python/Zope2/Startup/datatypes.py", line 21, in <module> import OFS.Uninstalled File "/usr/local/zope/298/lib/python/OFS/Uninstalled.py", line 20, in <module> import SimpleItem, Globals, Acquisition File "/usr/local/zope/298/lib/python/OFS/SimpleItem.py", line 26, in <module> import AccessControl.Role, AccessControl.Owned, App.Common File "/usr/local/zope/298/lib/python/AccessControl/__init__.py", line 17, in <module> from Implementation import setImplementation File "/usr/local/zope/298/lib/python/AccessControl/Implementation.py", line 98, in <module> setImplementation("C") File "/usr/local/zope/298/lib/python/AccessControl/Implementation.py", line 51, in setImplementation from AccessControl import ImplC as impl File "/usr/local/zope/298/lib/python/AccessControl/ImplC.py", line 18, in <module> from cAccessControl import rolesForPermissionOn, \ File "/usr/local/zope/298/lib/python/AccessControl/SimpleObjectPolicies.py", line 82, in <module> from DocumentTemplate.DT_Util import TemplateDict File "/usr/local/zope/298/lib/python/DocumentTemplate/__init__.py", line 21, in <module> from DocumentTemplate import String, File, HTML, HTMLDefault, HTMLFile File "/usr/local/zope/298/lib/python/DocumentTemplate/DocumentTemplate.py", line 112, in <module> from DT_String import String, File File "/usr/local/zope/298/lib/python/DocumentTemplate/DT_String.py", line 19, in <module> from DT_Util import ParseError, InstanceDict, TemplateDict, render_blocks, str File "/usr/local/zope/298/lib/python/DocumentTemplate/DT_Util.py", line 19, in <module> from html_quote import html_quote, ustr # for import by other modules, dont remove! File "/usr/local/zope/298/lib/python/DocumentTemplate/html_quote.py", line 4, in <module> from ustr import ustr File "/usr/local/zope/298/lib/python/DocumentTemplate/ustr.py", line 18, in <module> nasty_exception_str = Exception.__str__.im_func AttributeError: 'wrapper_descriptor' object has no attribute 'im_func' If anyone thinks it will help, I'll try to explain what I did that apparently caused the problem. ~ TIA ~ Ken

2 1