Re: [Zope] ZOracleDA
Avoid using Oracle 8.1.5 at all costs. It has mislinked executables and libraries, I can't believe Oracle could have released such a shit. Instead, download and try Oracle 8.1.6 R2 - the current release. It fixes a number of issues (though not all of them) and at least it works. Michal Bukovjan Citace Kiran Jonnalagadda <[EMAIL PROTECTED]>: > Hi, > > I'm trying to install ZOracleDA. I've managed to get DCOracle to build, > but the test fails with this traceback: > > - > [root@balrog src]# python DCOracle_test.py > Traceback (innermost last): > File "DCOracle_test.py", line 1, in ? > import Buffer, oci_, sys > ImportError: /u01/app/oracle/product/8.1.5/lib/libordvir8.so: undefined > symbol: __pure_virtual > - > > I'm running Zope 2.1.6 with Python 1.5.2 on Linux. DCOracle and > ZOracleDA are both the stab;e releases. Oracle is 8.1.5 (needed the > Setup file from this list). > > I added -lordvir8 a couple of times extra to Setup to see if this > problem went away, but it wouldn't. > > nm on libordvir8.so says that it contains the __pure_virtual symbol. > > Does anyone know how to get around this? > > -- > > Kiran Jonnalagadda > http://lunateks.com > > baby.sh: while true; do echo "^G^G^G^G^G"; sed -e 's/food/poop/'; > sync; sync; sleep 15; done > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Oracle 8i setup
Hey guys, I am now lucky to get the Oracle 8i connection working. Here is what I did : 1) Download and install the latest Oracle 8.1.6 Release 2. - the previous Oracle 8.0.5 and 8.1.5 are broken as hell, the executables will not even link and there is a lot of unresolved symbols. I wonder on which distro Oracle tested that, it will not work on Debian, definitely. Did not expect Oracle to be such CRAP!!! 8.1.6R2 is much better. - be sure not to want too much from Java wizards. They like to crash a lot, in both 8.1.5 and 8.1.6 1.1) When asked to run a script root.sh as root, first check the script and correct the path to awk. In script it thinks it is /bin/awk, on Debian it is /usr/bin/awk. Other distros may vary. Run the script as root. 2) Download latest beta of DCOracle 3) Download and install the latest beta of ZOracleDA. Replace DCOracle included in the product with the latest beta of DCOracle, which includes Setup-8.1.5 for linking with Oracle 8i. It should build now according to instructions. 4) Install ZOracleDA as outlined in docs 4.5) Not sure about this, but hell, my setup now works. So you may try... a) Put ORACLE_HOME, ORACLE_BASE, ORACLE_SID into /etc/profile, so that everyone has these set up. b) Symlink tnsnames.ora for $ORACLE_HOME/product/8.1.6/network/admin to /etc/tnsnames.ora. c) Double check file permissions on $ORACLE_HOME/* d) Edit /etc/oratab as needed, start up the databases. 5) Restart Zope. Now it works for me (Zope 2.1.4), and works for 2 days, did not try any heavy loads, etc, though. At least it connects and I can browse inside the database. It gave me some strange error like invalid connection string for some time, but probably after performing something from 4.5, it now works well, Zope will not freeze, and it works for two days now. Hope this helps anyone, we spent three+ days getting this f*cking Oracle to work :-( Michal Bukovjan "Alexandre A. Drummond Barroso" wrote: > You both had the same problem I have now: make Oracle 8i (in my case, Oracle > 8.1.6) work with Zope. > DCOracle is working well (Makefile attached to this message) but ZOracle > isn't running yet. > > We are posting e-mails about it on the list for a while and nobody answered, > so I must think that nobody on Zope universe is using Oracle 8i (neither NT > nor Linux Oracle 8i client). > There isn't any detailed documentation about it. The ZOracle installation > instructions are simple but, in my opinion, incomplete. > > To solve this situation, I'm making a call to everybody that uses or wants > to use Zope with Oracle 8i. My goal is finally document the installation > process and make it work properly. > > Please contact me ASAP. > > Regards, > > Alexandre A. Drummond Barroso. > > >Name: Makefile >MakefileType: unspecified type (application/octet-stream) >Encoding: quoted-printable ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] ZOracleDA woes - cannot connect
Please help!!! I am trying to connect to Oracle server. Running Zope 2.1.4, ZServer alone (for now), Debian frozen(potato). I have stable ZOracleDA 2.1.0. After a lot of work, I succeeded to compile the DCOracle package, and I am able to connect with the Python script DCOracle_test.py, which is included. I am only able to connect when I am a user 'oracle'. But when I try to connect from Zope, the connection never happens,and Zope returns "Document contained no data. Contact your network administrator". Sometimes, Zope dies. I am really desperate by now, as I try to make connection for three days now. I searched all FAQs on Zope site, nothing found. Any idea what I am doing wrong? Thanks, Michal Bukovjan ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] GUF and userList problems
That should work. You could try either to return the query object directly (in comments they say it is possible), and make sure that there are no spaces in the string returned from database. I was solving similar problem with PostgreSQL, when the username field was defined as CHAR(20), it always returned 20 characters regardless of the actual length of the username, the username was padded with spaces. Switching to VARCHAR solved my problem. Or you could try to strip the username. Michal Bukovjan "Mabe, Brad" wrote: > Greetings, > I am having problems with GUF authentication after including a call to a sql > method from within the GUF supplied userList method. I have GUF installed > correctly, and able to authenticate from a static list of users I created in > the userList method. When I attempt to call a sql method from within > userList, all authentications fail. Even for the list of static users. > > My sql method, "SQL_get_users", is very simple: > select user_account from user > > My modified userList Method is as follows: > > > > jorge > fred > mongo > > I have verified that the sql method returns users by selecting the > "User_list" tab from within the acl_users folder. I have tried numerous > things, but I cannot get any of the users to authenticate after adding the > statement. If I comment out the statement, the users > jorge, fred, and mongo can once again authenticate. At first I thought > maybe one of the sql method supplied users was conflicting with either > jorge, fred, or mongo in some way so I took out the > line, essentially calling the sql method but not returning anything from it. > Still couldn't authenticate anyone. > > Has anyone been successful in getting GUF userList to work with a sql > method? I have read through hippys how-to and think I have done everything > he has suggested. > > Systems specifics are: > Microsoft Windows NT 4.0 server, service pack 5 > Zope version 2.1.6 > GUF version 1.2.2 > Microsoft Access 2000 > > Any help at this point will be appreciated. I'm really pulling my hair out > over this. > >-=Brad=- > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
