November 2004 - Zope

Mysql get/set blob
by baptiste Ancey 22 Nov '04

22 Nov '04

hi, I use Zope for my website with a Mysql Database. I just want to store a python dictionary to a blob column of my table. And my problem is that i don't know how to set and get var to a blob from a script for example... I see some blob example on the web but always with file variable (thumbnails ...) never with the other kind of variable. I hope anybody can help me with an "HelloWorld" example Thx Baptiste -- Derivexperts Paris Cyber Village 101-103 Boulevard Mac Donald 75019 Paris 01 44 89 47 49

5 6

[NEWBIE] Where are application root objects documented?
by d.j.potts＠bcs.org.uk 21 Nov '04

21 Nov '04

Hello, I'm just learning Zope and have just stumbled over the ZopeTime object. I can't seem to find a list of objects like ZopeTime that are globally available. Can someone point me at any docs please? Cheers, Dave.

4 6

Mysql get/set blob
by Jason Leach 19 Nov '04

19 Nov '04

Hi, I think you'll have to pickle the object first, then dump it into the db. Have a look at Python's pickle features. Jason.

1 0

Announce: November Zope Bug Day!
by Chris Withers 19 Nov '04

19 Nov '04

Hi All, Well, October came and went with no bug day. Apologies to all :-S However, the November bug day will shortly be upon us! What? Zope Bug Day working from http://collector.zope.org/Zope When? Friday 26th November - from when you wake up until when the day ends! Where? #zope-dev on irc.zope.org Come along and help if you've got a chance! Read this if you want to know how: http://dev.zope.org/CVS/BugDays cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

1 0

Problem with new 2.7.3 and adding Products
by Anthu Nguyen 19 Nov '04

19 Nov '04

Hi all, I've just installed 2.7.3 (notes below). But when I try to add a simple Product (the "hello" example from the documentation), I am asked for a login & password. My inituser login/password do not work, and I get this error (with VerboseSecurity): * You are not authorized to access this resource.* Username and password are not correct. (Also, an error occurred while attempting to render the standard error message.) Any help would be appreciated. Thanks, AnThu ===========Build notes================ Retrieve the following shareware gzip gtar make (gnu) gcc-3.4.1-sol8-sparc-local libiconv-1.8-sol8-sparc-local As root # pkgadd -d gcc-3.4.1-sol8-sparc-local # pkgadd -d libiconv-1.8-sol8-sparc-local /export/home/Python-2.3.4 As zopeuser ./configure Got this error checking term.h presence... yes configure: WARNING: term.h: present but cannot be compiled configure: WARNING: term.h: check for missing prerequisite headers? configure: WARNING: term.h: proceeding with the preprocessor's result configure: WARNING: ## ------------------------------------ ## configure: WARNING: ## Report this to bug-autoconf(a)gnu.org. ## configure: WARNING: ## ------------------------------------ ## checking for term.h... yes make As root setenv LD_LIBRARY_PATH /usr/local/lib # make install #################### Zope ################### Become the zope user gzip -d gtar xvf cd /export/home/Zope-2.7.3-0 zopeuser(a)nwsops35.sfbay% ./configure --prefix=/usr/local/Zope-2.7.3-0 zopeuser(a)nwsops35.sfbay% make # The world has read/write on /usr/local on this system # allowing the zope user to install in /usr/local zopeuser(a)nwsops35.sfbay% make install ... Zope binaries installed successfully. Now run '/usr/local/Zope-2.7.3-0/bin/mkzopeinstance.py' zopeuser(a)nwsops35.sfbay% /usr/local/Zope-2.7.3-0/bin/mkzopeinstance.py Please choose a directory in which you'd like to install Zope "instance home" files such as database files, configuration files, etc. Directory: /usr/local/Zope-2.7.3-0 Please choose a username and password for the initial user. These will be the credentials you use to initially manage your new Zope instance. Username: zopeuser Password: zope4u Verify password: zope4u Clean up the version.txt files If you have trouble during the makes look for this issue. I ran into a bug where ./lib/python/version.txt was being corrupted. A -n was being put in the file. It should look like this: Zope 2.7.3-0 Not this: -n Zope 2.7.3-0 Clean this up and the make should work. Modify etc/zope.conf effective-user zopeuser http-server address to 80 <http-server> # valid keys are "address" and "force-connection-close" # address 8080 address 80 # force-connection-close on </http-server> --------------------------------------------------------------------- #### Errors ######## # make make: Fatal error in reader: makefile, line 78: Macro assignment on dependency l ine Solution: you don't have GNY make in your path. copy it to /usr/local/bin and make sure it is the first make in your path. ------------- # which make Picks up the wrong make even though /usr/local/bin/make is in your path. Solution: Make sure the executable bit is set on make (gtra, gzip) ------------- zopeuser(a)nwsops35.sfbay% ./runzope Traceback (most recent call last): ... File "/usr/local/Zope-2.7.3-0/lib/python/App/version_txt.py", line 45, in _pre p_version_data dict = expr.match(s).groupdict() AttributeError: 'NoneType' object has no attribute 'groupdict' This is caused by zopeuser(a)nwsops35.sfbay% more ./lib/python/version.txt -n Zope 2.7.3-0 which needs to be modified to be Zope 2.7.3-0 ----

2 2

ANNOUNCE: ZSyncer 0.6.0 released
by Paul Winkler 19 Nov '04

19 Nov '04

ZSyncer is a project that allows live zope objects to be synchronized from one Zope to another without doing the tedious export / file transfer / import dance. It is very easy to use. ZSyncer also allows you to see at a glance which objects are out-of-sync. ZSyncer also allows you to view a diff against the destination object, for several types of objects. Download it here: http://sourceforge.net/projects/zsyncer/ --------- Highlights of changes since 0.5.1: This new features release is NOT BACKWARDS COMPATIBLE with versions 0.5.1 or earlier. You must upgrade ZSyncer on *all* servers that will sync to each other. You will probably have to reconfigure your ZSyncers too, and check your users' permissions since we changed the permission name. - Thanks to Dieter Maurer we now use ZPublisher.Client and cPickle instead of xmlrpc. May help with mixed-encoding data. This should improve speed and memory performance too, since we don't have to do base64 encoding / decoding of the pickles. - Merged Sascha Ottolski's patch to make it easier to add Sync tab to classes. These go in Config.py. - syncing an ordered folder preserves order, patch contributed by sbrauer. - added ability to blacklist meta-types, not just whitelist, patch contributed by sbrauer. - changed permission name to "ZSyncer: Use ZSyncer" to be consistent with the usual idiom. - added _callRemote(), experimental code which allows you to do just about anything on the remote server with security checks. This is intended to be used for remotely twiddling configuration, properties, and the like. - better handling and formatting of diff errors - Improved error messages when comparisons fail - It's now possible to use paths relative to zsyncer placement. This allows you to A) use a different absolute path between source and target servers, and B) prevent users from syncing anything above the folder where the syncer lives. - We now use RESPONSE.write() to stream output messages. The old method of RESPONSE.redirect() frequently failed if you synced too many objects (query string got too long). - No more html in the syncer log! - UI now shows local size if available - Time now shown somewhat like ls -l (i.e. show year if old, hour/minute if current year). Show in the source zsyncer's localtime, not GMT. - Tons of code cleanup & refactoring: better method & argument names, normalized argument order, normalized whitespace, etc. If you have code that calls API methods of ZSyncer you will probably have to make changes. -- Paul Winkler http://www.slinkp.com

5 5

help from zope argentina
by gus 19 Nov '04

19 Nov '04

How are you Iam migration from zope 2.7.0 to 2.7.3 but when I run zope I have these error File "/root/raec/instance/lib/python/OFS/Application.py, line 405 in install_tempfolder_and_sdc period_secs=period_spec TypeError:__init__() got an unexpected keywork argument ' period_secs? Could you help me.. thanks gus

8 12

Re: [Zope] Installing DCOracle2 in AIX 5.1
by Debojit Hazarika 19 Nov '04

19 Nov '04

The libclntsh.a file does exist in $ORACLE_HOME/lib. The problem here is when i try to build the "dco2.so" pointing $ORACLE_HOME to an oracle 8 installation with the below command it builds the "dco2.so" file successfully. /myapp/python/lib/python2.1/ld_so_aix gcc -bI:/myapp/python/lib/python2.1/python.exp build/temp.aix-5.1-2.1/dco2.o -L$ORACLE_HOME/lib -lclntsh -o build/lib.aix-5.1-2.1/dco2.so But when i try to build th"e dco2.so" pointing $ORACLE_HOME to an oracle 9 installation i end up getting the following errors: /myapp/python/lib/python2.1/ld_so_aix gcc -bI:/myapp/python/lib/python2.1/python.exp build/temp.aix-5.1-2.1/dco2.o -L$ORACLE_HOME/lib -lclntsh -o build/lib.aix-5.1-2.1/dco2.so ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet ld: 0711-317 ERROR: Undefined symbol: .OCIEnvCreate ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach ............................................... ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. collect2: ld returned 8 exit status Any idea why i am getting this error? However i don't have the "libclntsh.so" file in $ORACLE_HOME/lib, is that the reason??? If so how to get this "libclntsh.so" file? Can anyone please suggest some hints on this. Many thanks, Regards Deb Taewook Kang <twkang(a)gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt@Zentrale > cc: Subject: Re: [Zope] Installing DCOracle2 in AIX 5.1 19/11/04 13:40 Please respond to Taewook Kang How about checking existence of libclntsh.a in $ORACLE_HOME/lib? or if You have 64bit oracle, and 32 bit python compiled by gcc, it might be matters. Anyway, those not-found symbols are in libclntsh.a, and you need that file for linking. :) Good luck On Fri, 19 Nov 2004 12:43:30 +0530, Debojit Hazarika <debojit.hazarika(a)db.com> wrote: > > Hello Taewook, > > Following your suggestion i tried compiling DCOracle2 for Oracle 8i and it was successfull. > But unfortunately i was not able to do the same for Oracle9i (*which is my actual requirement*) > I failed with the following errors: > > ******************************************************************************************************************* > /myapp/python/lib/python2.1/ld_so_aix gcc -bI:/myapp/python/lib/python2.1/python.exp build/temp.aix-4.3-2.1/dco2.o -L/applications/oracle/products/9.2.0.5/lib -lclntsh -o build/lib.aix-4.3-2.1/dco2.so > ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet > ld: 0711-317 ERROR: Undefined symbol: .OCIEnvCreate > ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc > ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach > ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet > ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin > ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd > ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach > ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree > ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit > ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare > ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback > ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet > ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet > ld: 0711-317 ERROR: Undefined symbol: .OCIDescribeAny > ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare > ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos > ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName > ld: 0711-317 ERROR: Undefined symbol: .OCIBindDynamic > ld: 0711-317 ERROR: Undefined symbol: .OCIBindArrayOfStruct > ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute > ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos > ld: 0711-317 ERROR: Undefined symbol: .OCIDefineDynamic > ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch > ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc > ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree > ld: 0711-317 ERROR: Undefined symbol: .OCILobIsTemporary > ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary > ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength > ld: 0711-317 ERROR: Undefined symbol: .OCILobRead > ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary > ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite > ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim > ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. > collect2: ld returned 8 exit status > ******************************************************************************************************************* > > Any idea why it is failing for Oracle9i, how will i be able to fix this "Undefined symbol" error. > > Many thanks, > > regards > Deb > > Taewook Kang > <twkang(a)gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt@Zentrale > > cc: zope(a)zope.org > Subject: Re: [Zope] Installing DCOracle2 in AIX 5.1 > 19/11/04 11:55 > > > Please respond to > Taewook Kang > > I only use Oracle 8, and DCOracle2, so I can't help you. > But previously I had compiled DCOracle with Oracle 8 and Python 2.3, > and it worked. > If you compiled DCOracle in your box without problem, > I think it should work. > > Regards. > > On Fri, 19 Nov 2004 11:00:33 +0530, Debojit Hazarika > <debojit.hazarika(a)db.com> wrote: > > > > > > Hello Taewook, > > > > I have another question on the same topic, can you please fetch me and answer. > > > > Can i use DCOracle ( *not DCOracle2* ) with Oracle 9i. > > > > I got the following error while trying to use DCOracle with Oracle 9i > > > > ********************************************************************************************************* > > >>> import DCOracle > > Traceback (most recent call last): > > File "<stdin>", line 1, in ? > > File "/myapp/python/lib/python2.1/site-packages/DCOracle/__init__.py", line 66, in ? > > from ocidb import Connect, error > > File "/myapp/python/lib/python2.1/site-packages/DCOracle/ocidb.py", line 50, in ? > > import oci_, ociCurs, ociProc > > ImportError: from module /myapp/python/lib/python2.1/site-packages/oci_.so Exec format error > > can't load library: /myapp/python/lib/python2.1/site-packages/oci_.so > > /myapp/oracle/products/9.2.0.5/lib/libclntsh.a shr.o > > /myapp/oracle/products/9.2.0.5/lib/libclntsh.a shr.o > > can't load library: /myapp/oracle/products/9.2.0.5/lib/libclntsh.a > > /myapp/oracle/products/9.2.0.5/lib/libclntsh.a > > ********************************************************************************************************* > > > > Is there a way out (maybe some patch) to make DCOracle work with Oracle 9i? > > > > > > > > Many thanks in advance. > > > > Regards > > Deb > > > > Taewook Kang > > <twkang(a)gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt@Zentrale > > > cc: > > Subject: Re: [Zope] Installing DCOracle2 in AIX 5.1 > > 19/11/04 06:37 > > Please respond to > > Taewook Kang > > > > You must manually edit setup.py to make it work in AIX. > > Modify CFLAGS, LFLAGS as > > CFLAGS = ["-DNDEBUG", "-DORACLE9i", "-DUSEOBJECT", "-D_REENTRENT"] > > LFLAGS = [] > > and remove following lines - AIX doesn't have 'ldd' command. but you > > must be sure > > python compiled with thread support. - > > > > <code> > > st,outp=commands.getstatusoutput('ldd %s' % sys.executable) > > if string.find(outp,'libpth.so')!=-1: > > raise exceptions.RuntimeError,'Python interpreter is linked > > against -lpth. But Python must be linked against -lpthread' > > > > st,outp=commands.getstatusoutput('ldd %s' % sys.executable) > > if string.find(outp,'libpthread')==-1: > > raise exceptions.RuntimeError,'Python must be linked against -lpthread' > > </code> > > > > Now, you can do 'python setup.py install' > > Good luck. > > > > On Thu, 18 Nov 2004 17:36:20 +0530, Debojit Hazarika > > <debojit.hazarika(a)db.com> wrote: > > > Hello, > > > > > > I am trying to install DCOracle2 (DCOracle2-1.2.tar) in an AIX 5.1 box. > > > > > > I have tried various options but it does not seem to work. > > > > > > When i try to *make* i get the below error > > > > > > ********************************************************************************************************* > > > >make > > > (cd src; ./testora python) > > > -n Checking ORACLE_HOME... > > > passed. > > > -n Checking for Oracle version... > > > failed. > > > /u01/app/oracle/product/9.2.0/lib/libclntsh.so not readable; unable to > > > determine your oracle version. > > > make: 1254-004 The error code from the last command is 2. > > > > > > Stop. > > > ********************************************************************************************************* > > > > > > Later i tried to follow the instructions in the below link to install it. > > > > > > http://mail.zope.org/pipermail/zope/2002-June/116009.html > > > > > > But this time i got a different error message as mentioned below > > > > > > ********************************************************************************************************** > > > >python setup.py install > > > Traceback (most recent call last): > > > File "setup.py", line 36, in ? > > > raise exceptions.RuntimeError,'Python must be linked against -lpthread' > > > RuntimeError: Python must be linked against -lpthread > > > ********************************************************************************************************** > > > > > > Can someone please provide me some suggestion to make this right and get > > > DCOracle2 installed for Oracle 9i. > > > > > > Many thanks in advance, > > > > > > Regards > > > Deb > > > > > > -- > > > > > > Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. > > > > > > This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. > > > > > > _______________________________________________ > > > Zope maillist - Zope(a)zope.org > > > http://mail.zope.org/mailman/listinfo/zope > > > ** No cross posts or HTML encoding! ** > > > (Related lists - > > > http://mail.zope.org/mailman/listinfo/zope-announce > > > http://mail.zope.org/mailman/listinfo/zope-dev ) > > > > > > > -- > > > > Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. > > > > This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. > > > > > > -- > > Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. > > This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. > > -- Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

1 0

Re: [Zope] Installing DCOracle2 in AIX 5.1
by Debojit Hazarika 19 Nov '04

19 Nov '04

Hello Taewook, Following your suggestion i tried compiling DCOracle2 for Oracle 8i and it was successfull. But unfortunately i was not able to do the same for Oracle9i (*which is my actual requirement*) I failed with the following errors: ******************************************************************************************************************* /myapp/python/lib/python2.1/ld_so_aix gcc -bI:/myapp/python/lib/python2.1/python.exp build/temp.aix-4.3-2.1/dco2.o -L/applications/oracle/products/9.2.0.5/lib -lclntsh -o build/lib.aix-4.3-2.1/dco2.so ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet ld: 0711-317 ERROR: Undefined symbol: .OCIEnvCreate ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet ld: 0711-317 ERROR: Undefined symbol: .OCIDescribeAny ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName ld: 0711-317 ERROR: Undefined symbol: .OCIBindDynamic ld: 0711-317 ERROR: Undefined symbol: .OCIBindArrayOfStruct ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos ld: 0711-317 ERROR: Undefined symbol: .OCIDefineDynamic ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree ld: 0711-317 ERROR: Undefined symbol: .OCILobIsTemporary ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength ld: 0711-317 ERROR: Undefined symbol: .OCILobRead ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. collect2: ld returned 8 exit status ******************************************************************************************************************* Any idea why it is failing for Oracle9i, how will i be able to fix this "Undefined symbol" error. Many thanks, regards Deb Taewook Kang <twkang(a)gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt@Zentrale > cc: zope(a)zope.org Subject: Re: [Zope] Installing DCOracle2 in AIX 5.1 19/11/04 11:55 Please respond to Taewook Kang I only use Oracle 8, and DCOracle2, so I can't help you. But previously I had compiled DCOracle with Oracle 8 and Python 2.3, and it worked. If you compiled DCOracle in your box without problem, I think it should work. Regards. On Fri, 19 Nov 2004 11:00:33 +0530, Debojit Hazarika <debojit.hazarika(a)db.com> wrote: > > > Hello Taewook, > > I have another question on the same topic, can you please fetch me and answer. > > Can i use DCOracle ( *not DCOracle2* ) with Oracle 9i. > > I got the following error while trying to use DCOracle with Oracle 9i > > ********************************************************************************************************* > >>> import DCOracle > Traceback (most recent call last): > File "<stdin>", line 1, in ? > File "/myapp/python/lib/python2.1/site-packages/DCOracle/__init__.py", line 66, in ? > from ocidb import Connect, error > File "/myapp/python/lib/python2.1/site-packages/DCOracle/ocidb.py", line 50, in ? > import oci_, ociCurs, ociProc > ImportError: from module /myapp/python/lib/python2.1/site-packages/oci_.so Exec format error > can't load library: /myapp/python/lib/python2.1/site-packages/oci_.so > /myapp/oracle/products/9.2.0.5/lib/libclntsh.a shr.o > /myapp/oracle/products/9.2.0.5/lib/libclntsh.a shr.o > can't load library: /myapp/oracle/products/9.2.0.5/lib/libclntsh.a > /myapp/oracle/products/9.2.0.5/lib/libclntsh.a > ********************************************************************************************************* > > Is there a way out (maybe some patch) to make DCOracle work with Oracle 9i? > > > > Many thanks in advance. > > Regards > Deb > > Taewook Kang > <twkang(a)gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt@Zentrale > > cc: > Subject: Re: [Zope] Installing DCOracle2 in AIX 5.1 > 19/11/04 06:37 > Please respond to > Taewook Kang > > You must manually edit setup.py to make it work in AIX. > Modify CFLAGS, LFLAGS as > CFLAGS = ["-DNDEBUG", "-DORACLE9i", "-DUSEOBJECT", "-D_REENTRENT"] > LFLAGS = [] > and remove following lines - AIX doesn't have 'ldd' command. but you > must be sure > python compiled with thread support. - > > <code> > st,outp=commands.getstatusoutput('ldd %s' % sys.executable) > if string.find(outp,'libpth.so')!=-1: > raise exceptions.RuntimeError,'Python interpreter is linked > against -lpth. But Python must be linked against -lpthread' > > st,outp=commands.getstatusoutput('ldd %s' % sys.executable) > if string.find(outp,'libpthread')==-1: > raise exceptions.RuntimeError,'Python must be linked against -lpthread' > </code> > > Now, you can do 'python setup.py install' > Good luck. > > On Thu, 18 Nov 2004 17:36:20 +0530, Debojit Hazarika > <debojit.hazarika(a)db.com> wrote: > > Hello, > > > > I am trying to install DCOracle2 (DCOracle2-1.2.tar) in an AIX 5.1 box. > > > > I have tried various options but it does not seem to work. > > > > When i try to *make* i get the below error > > > > ********************************************************************************************************* > > >make > > (cd src; ./testora python) > > -n Checking ORACLE_HOME... > > passed. > > -n Checking for Oracle version... > > failed. > > /u01/app/oracle/product/9.2.0/lib/libclntsh.so not readable; unable to > > determine your oracle version. > > make: 1254-004 The error code from the last command is 2. > > > > Stop. > > ********************************************************************************************************* > > > > Later i tried to follow the instructions in the below link to install it. > > > > http://mail.zope.org/pipermail/zope/2002-June/116009.html > > > > But this time i got a different error message as mentioned below > > > > ********************************************************************************************************** > > >python setup.py install > > Traceback (most recent call last): > > File "setup.py", line 36, in ? > > raise exceptions.RuntimeError,'Python must be linked against -lpthread' > > RuntimeError: Python must be linked against -lpthread > > ********************************************************************************************************** > > > > Can someone please provide me some suggestion to make this right and get > > DCOracle2 installed for Oracle 9i. > > > > Many thanks in advance, > > > > Regards > > Deb > > > > -- > > > > Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. > > > > This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://mail.zope.org/mailman/listinfo/zope > > ** No cross posts or HTML encoding! ** > > (Related lists - > > http://mail.zope.org/mailman/listinfo/zope-announce > > http://mail.zope.org/mailman/listinfo/zope-dev ) > > > > -- > > Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. > > This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. > > -- Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

1 0

Re: [Zope] Installing DCOracle2 in AIX 5.1
by Taewook Kang 19 Nov '04

19 Nov '04

I only use Oracle 8, and DCOracle2, so I can't help you. But previously I had compiled DCOracle with Oracle 8 and Python 2.3, and it worked. If you compiled DCOracle in your box without problem, I think it should work. Regards. On Fri, 19 Nov 2004 11:00:33 +0530, Debojit Hazarika <debojit.hazarika(a)db.com> wrote: > > > Hello Taewook, > > I have another question on the same topic, can you please fetch me and answer. > > Can i use DCOracle ( *not DCOracle2* ) with Oracle 9i. > > I got the following error while trying to use DCOracle with Oracle 9i > > ********************************************************************************************************* > >>> import DCOracle > Traceback (most recent call last): > File "<stdin>", line 1, in ? > File "/myapp/python/lib/python2.1/site-packages/DCOracle/__init__.py", line 66, in ? > from ocidb import Connect, error > File "/myapp/python/lib/python2.1/site-packages/DCOracle/ocidb.py", line 50, in ? > import oci_, ociCurs, ociProc > ImportError: from module /myapp/python/lib/python2.1/site-packages/oci_.so Exec format error > can't load library: /myapp/python/lib/python2.1/site-packages/oci_.so > /myapp/oracle/products/9.2.0.5/lib/libclntsh.a shr.o > /myapp/oracle/products/9.2.0.5/lib/libclntsh.a shr.o > can't load library: /myapp/oracle/products/9.2.0.5/lib/libclntsh.a > /myapp/oracle/products/9.2.0.5/lib/libclntsh.a > ********************************************************************************************************* > > Is there a way out (maybe some patch) to make DCOracle work with Oracle 9i? > > > > Many thanks in advance. > > Regards > Deb > > Taewook Kang > <twkang(a)gmail.com To: Debojit Hazarika/Zentrale/DeuBaExt@Zentrale > > cc: > Subject: Re: [Zope] Installing DCOracle2 in AIX 5.1 > 19/11/04 06:37 > Please respond to > Taewook Kang > > You must manually edit setup.py to make it work in AIX. > Modify CFLAGS, LFLAGS as > CFLAGS = ["-DNDEBUG", "-DORACLE9i", "-DUSEOBJECT", "-D_REENTRENT"] > LFLAGS = [] > and remove following lines - AIX doesn't have 'ldd' command. but you > must be sure > python compiled with thread support. - > > <code> > st,outp=commands.getstatusoutput('ldd %s' % sys.executable) > if string.find(outp,'libpth.so')!=-1: > raise exceptions.RuntimeError,'Python interpreter is linked > against -lpth. But Python must be linked against -lpthread' > > st,outp=commands.getstatusoutput('ldd %s' % sys.executable) > if string.find(outp,'libpthread')==-1: > raise exceptions.RuntimeError,'Python must be linked against -lpthread' > </code> > > Now, you can do 'python setup.py install' > Good luck. > > On Thu, 18 Nov 2004 17:36:20 +0530, Debojit Hazarika > <debojit.hazarika(a)db.com> wrote: > > Hello, > > > > I am trying to install DCOracle2 (DCOracle2-1.2.tar) in an AIX 5.1 box. > > > > I have tried various options but it does not seem to work. > > > > When i try to *make* i get the below error > > > > ********************************************************************************************************* > > >make > > (cd src; ./testora python) > > -n Checking ORACLE_HOME... > > passed. > > -n Checking for Oracle version... > > failed. > > /u01/app/oracle/product/9.2.0/lib/libclntsh.so not readable; unable to > > determine your oracle version. > > make: 1254-004 The error code from the last command is 2. > > > > Stop. > > ********************************************************************************************************* > > > > Later i tried to follow the instructions in the below link to install it. > > > > http://mail.zope.org/pipermail/zope/2002-June/116009.html > > > > But this time i got a different error message as mentioned below > > > > ********************************************************************************************************** > > >python setup.py install > > Traceback (most recent call last): > > File "setup.py", line 36, in ? > > raise exceptions.RuntimeError,'Python must be linked against -lpthread' > > RuntimeError: Python must be linked against -lpthread > > ********************************************************************************************************** > > > > Can someone please provide me some suggestion to make this right and get > > DCOracle2 installed for Oracle 9i. > > > > Many thanks in advance, > > > > Regards > > Deb > > > > -- > > > > Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. > > > > This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://mail.zope.org/mailman/listinfo/zope > > ** No cross posts or HTML encoding! ** > > (Related lists - > > http://mail.zope.org/mailman/listinfo/zope-announce > > http://mail.zope.org/mailman/listinfo/zope-dev ) > > > > -- > > Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. > > This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. > >

1 0