I would make sure the variable is set everywhere, the initial data is imported with the schema, that you commented out. Out of curiosity why are you commenting out the "schema" the only reason you would do this is if the database was already created with all the appropriate tables. Our oracle guys just setup the RT user as per the oracle readme and then we just ran initialize-database and it created the rest.
Justin Brodley From: Baytalskiy, Sal [mailto:[EMAIL PROTECTED] Sent: Thursday, May 17, 2007 10:34 AM To: Justin Brodley; [email protected] Subject: RE: [rt-users] Desperately ned Oracle help 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
