[rt-users] Oracle DB connection problem

[Erwin Pasia]

hi TJ,
 
 
Im also trying to connect an RT to an Oracle, schemas and tables were already created but on certain user creation its failing. Below is the error once the script is run. Would appreciate help on what Im specifically missing on the config. Thanks. 
 

Now creating a database for RT.
...skipped as rtts_test2 is not test2 or we're working with Oracle.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Now inserting RT core system objects
Checking for existing system user...not found.  This appears to be a new installation.
Creating system user...[Wed Aug  3 07:45:01 2005] [crit]: Found a principal () that was neither a user nor a group 
 
(/opt/rt3.4.2/lib/RT/Principal_Overlay.pm:127)
[Wed Aug  3 07:45:01 2005] [crit]: Can't call method "Id" on an undefined value at /opt/rt3.4.2/lib/RT/Group_Overlay.pm line 
 
573.
 (/opt/rt3.4.2/lib/RT.pm:285)

.............

Set($DatabaseType , 'Oracle');
Set($DatabaseHost   , 'localhost');
Set($DatabaseRTHost , 'localhost');
Set($DatabasePort , '1521');
Set($DatabaseUser , 'test2');
Set($DatabasePassword , 'tyson1');
Set($DatabaseName , 'host=localhost; sid=RTDV2');
$ENV{TWO_TASK}="LIVE";
 
 
Erwin 
 
 
.....................
 
 
 
I figured out what the problem was - turns out when I was starting apache as
"sudo /etc/init.d/httpd restart" from my own user that
the user it was running as under sudo did not have the environment variable
set for the oracle library path.
 
I tried this instead:
 
sudo su root
export LD_LIBRARY_PATH=/opt/oracle/OraHome1/lib
/etc/init.d/httpd restart
 
and it resolved all of my problems!  Now RT is running speedily on Oracle at
our site.
 
T.J. Maciak

Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713
F: (616)456-3448


		
---------------------------------
 Start your day with Yahoo! - make it your home page 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050804/b88b0014/attachment.htm>