<DIV>Hi Joe,</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Set($DatabaseType , 'Oracle');<BR>Set($DatabaseHost , 'localhost');<BR>Set($DatabaseRTHost , 'localhost');<BR>Set($DatabasePort , '1521');<BR>Set($DatabaseUser , 'test2');<BR>Set($DatabasePassword , 'tyson1');<BR>Set($DatabaseName , 'host=localhost; sid=RTDV2');<BR>$ENV{TWO_TASK}="LIVE";</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>................................</DIV>
<DIV> </DIV>
<DIV>I've installed RT 3.4.2, ran make initialize-database<BR>but it doesn't seem to be creating the 'root' user. <BR>It does create the tables though. My backend db is<BR>Oracle. I tried inserting a user into the USERS table<BR>via sqlplus but still no luck. I used the drop.Oracle<BR>script to remove the Oracle db but there were some<BR>errors, then I tried make initialize-database again<BR>and it creates the tables again, but I also see this:<BR><BR>CREATE SEQUENCE OBJECTCUSTOMFIELDS_seq<BR>ORA-00955: name is already used by an existing object<BR>(DBD ERROR: error possibly near <*> indicator at char<BR>18 in '<BR><BR><BR>Thoughts? <BR><BR>How can I manually create a user (if necessary)? <BR><BR>thanks,<BR><BR>joe<BR><BR></DIV><p>
<hr size=1> <a href="http://us.rd.yahoo.com/evt=34442/*http://www.yahoo.com/r/hs">Start your day with Yahoo! - make it your home page </a>