[rt-users] create default root user - oracle backend

[Erwin Pasia]

Hi Joe,
 
Im having same problem with Oracle, were you able to make a workaround. Would appreciate your guidance. Btw, below is the setting under my RT_SiteConfig.pm. Thanks.
 
 
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";
 
 
 
 
 
 
................................
 
I've installed RT 3.4.2, ran make initialize-database
but it doesn't seem to be creating the 'root' user. 
It does create the tables though.  My backend db is
Oracle.  I tried inserting a user into the USERS table
via sqlplus but still no luck. I used the drop.Oracle
script to remove the Oracle db but there were some
errors, then I tried make initialize-database again
and it creates the tables again, but I also see this:

CREATE SEQUENCE OBJECTCUSTOMFIELDS_seq
ORA-00955: name is already used by an existing object
(DBD ERROR: error possibly near <*> indicator at char
18 in '


Thoughts?  

How can I manually create a user (if necessary)?  

thanks,

joe



		
---------------------------------
 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/ec390090/attachment.htm>