Hi Russell, Thanks for your detailed mail. I have installed oracle client and verified with sqlplus. It is working fine. I have setted all my env variables as you have advised, including witango.ini file. However, when starting witango am getting the following error:
[ 625] 2004-03-23 20:30:41 START WARNING Cannot initialize ODBC environment [ 625] 2004-03-23 20:30:41 START WARNING Cannot initialize Oracle Call Interface (OCI) environment What could be the reason? do I need to do any further settings? pls advice. Also if you can send me the startup script which you have. thanks, Srini -----Original Message----- From: Russell Stephany [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 9:36 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Reg Apache setup srini, bill has given you some info about apache, so i'll see what i can do about OCI...that's what i use on solaris/osx. i don't know anything about odbc. you will need to install the oracle client software on the witango server machine. this will give you an ORACLE_HOME. you need to configure Net*8 (SQL*Net) to find your database by manipulating the tnsnames.ora file in $ORACLE_HOME/network/admin. i would imagine that you know how to do this, since it's exactly the same as they way it is configured on the database server machine. once that has been setup (and verified with sqlplus), then you have to convince witango that you are using OCI....i have added the following lines to the script that starts witangod... export ORACLE_BASE=/mnt/san/agsmdbs/oracle_homes/forwitango export ORACLE_HOME=${ORACLE_BASE}/product (obviously, the ORACLE_BASE will be specfic to your machine...actually, only ORACLE_HOME is necessary, i just got pedantic) then, in the witango.ini file, you have to set OCILIBPATH...mine looks like this. OCILIBPATH=/mnt/san/agsmdbs/oracle_homes/forwitango/product/lib/ that has worked for me on solaris and osx (with appropriate changes to the paths). hope this helps. cheers, russell "Srinivasan" <[EMAIL PROTECTED]> wrote on 23/03/2004 05:44:49 AM: > Hi Bill, > Thanks for the response... > Am trying to setup WiTango/Apache on a Linux machine with oracle as the > database. > I have installed Apache2 and WiTango(Installer). Both the daemons are > running. I have configured the httpd.conf with the following: > LoadModule WitangoModule modules/wapache2.so > WitangoModule wapache2.so > However when I try to browse TAF pages from the browser it is popping up > with open/saveas window > It is RedHat Linux 9/WiTango 5.0.1 > How do I setup OCI/ODBC (Datasource) connectivity to my database. Previously > I was using Tango2000, which had a shell script (given along with installer) > that need to be ran to setup the database connectivity. How should I get > connected to the database with WiTango? > Thanks, > Srini > -----Original Message----- > From: Bill Conlon [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 23, 2004 12:06 AM > To: Witango-Talk > Subject: Re: Witango-Talk: Reg Apache setup > > Srini, > My ESP isn't working today. > 1. Is this a continuation of last week's issue or something new? > 2. What does it mean that Witango is running individually, but you need > integration help? > 3. What platform and versions are you using? > 4. What errors are you seeing. > >Hi, > > > >Can any one help me out in setting up Witango with Apache and Oracle. All > >the three applications are running individually fine. How do I integrate > >WiTango and Apache? How do I setup OCI/ODBC connectivity to the database > >(Oracle)? Please suggest me to make this work. > > > >Thanks, > > > >Srini > > > >________________________________________________________________________ > >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > Bill Conlon > To the Point > 345 California Avenue Suite 2 > Palo Alto, CA 94306 > office: 650.327.2175 > fax: 650.329.8335 > mobile: 650.906.9929 > e-mail: mailto:[EMAIL PROTECTED] > web: http://www.tothept.com > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ForwardSourceID:NT000101DE -------------------------------------------------------------- Russell Stephany Lead Developer, Information Technology Australian Graduate School of Management UNSW SYDNEY NSW 2052 Australia Tel: +61 2 9931-9263 Fax: +61 2 9931-9349 Email: [EMAIL PROTECTED] Web: http://www.agsm.edu.au The Australian Graduate School of Management is a School of both The University of Sydney & The University of New South Wales. CRICOS Provider Number: 00098G ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
