Thanks a lot, Justin!!! This is very valuable info! However, i'm not at that step yet. I've just built RT with Oracle support and was trying to run 'make initialize-database' I've commented out the 'insert_schema()' method call, cause schema is already in place. I was expecting the thing to insert the initial RT data into the DB. But that's where it was failing. Do you think i should set the variable you mentioned in the shell and try running it again?
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Justin Brodley Sent: Thursday, May 17, 2007 1:20 PM To: Baytalskiy, Sal; [email protected] Subject: RE: [rt-users] Desperately ned Oracle help Sal- It has to do with Apache and your CGI handler not knowing the oracle parameters. We use Fast CGI on Redhat connecting to a remote Oracle servers. I had to add the following lines to my httpd.conf file: # RT STUFF FOR APACHE SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/10.2.0/client_1/lib SetEnv ORACLE_HOME /u01/app/oracle/product/10.2.0/client_1 SetEnv ORACLE_SID rt SetEnv TWO_TASK rt (change above variables to your implementation) In Httpd conf I also had to change the initialization string for Fastcgi, this is the line in my config. FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4 -initial-env LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/client_1/lib -initial-env ORACLE_HOME=/u01/app/oracle/product/10.2.0/client1 -initial-env ORACLE_SID=rt -initial-env TWO_TASK=rt Some of this might be a bit excessive but I was trying everything and spent a ton of time on the fastcgi and apache websites trying to figure this out. Once this was all completed I was successful in getting DBI Searchbuilder working. This took about a 12 hours of research and trial and error on my part, and I've meant to go back and put this information in the wiki but haven't had a chance. Justin Brodley From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baytalskiy, Sal Sent: Wednesday, May 16, 2007 9:49 PM To: [email protected] Subject: [rt-users] Desperately ned Oracle help Hey everyone! As ive already mentioned - i'm being forced to use Oracle for my RT 3.6.3 instance. Well, today i finally got an Oracle 10g instance up and loaded the schema.Oracle file into it. Did the ./configure for RT(./configure --prefix=/usr/local/rt3_ora --with-db-type=Oracle --with-db-host=clorad1.example.com --with-db-port=1521 --with-db-rt-host=localhost --with-db-dba=rtusr --with-db-database=clorad1 --with-db-rt-user=rtusr --with-db-rt-pass=***** ) Everything was ok. While doing make initialize-database i got this error: Unable to load DBIx::SearchBuilder database handle for 'Oracle'. Realized that i don't have DBD::Oracle installed, so i downloaded that from CPAN and installed that. There were errors during the install and i found a workaround to delete -xarch=v9 from the Makefile. After that install finished. Then i followed the Wiki and commented out the insert_schema() method call. But i'm still getting errors trying to init the DB. Test suggested by the Wiki (TWO_TASK=FOO perl -MDBI -le 'DBI->connect("DBI:Oracle:", "rt3", "rt3")') seems to be successful. Or at least it doesn't give any errors. This is the error i get while doing make initialize-database : DSN component 'CLORAD1' is not in 'name=value' format at /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627 DBI connect('CLORAD1;port=1521','rtusr',...) failed: Can't connect using this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103 Failed to connect to dbi:Oracle:CLORAD1;port=1521 as rtusr: Can't connect using this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103, <STDIN> line 1. make: *** [initialize-database] Error 255 PLEASE HELP !!! Thanks in advance, Sal.
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
