[rt-users] RT + Oracle

[Brook Schofield]

Pawan Singh wrote on 16/05/2003 09:14:01 AM:

> I am using RT with the backend database as mysql, I need to use Oracle 
as
> the backend database. We are already are running Oracle databases and it
> would be easy for us to maintain one database. Pls guide

Pawan,

Oracle/RT is a work in progress (which is progressing quite well I think 
;-) but it still needs some finishing touches, debugging and polish and as 
such - you'd be best to subscribe to the rt-devel list and look through 
the archives regarding Oracle (you'll only need to check back from March 
at the earliest - because that is when the work started).

To get you up to speed you'll need to look at:
        http://rt3.fsck.com/Ticket/Display.html?id=2432
        http://rt3.fsck.com/Ticket/Display.html?id=2431
The login is guest/guest if you haven't come across this before. Which 
contains patches/file which aren't in RT-3.0.2

And some of this lists:
        http://lists.fsck.com/pipermail/rt-devel/2003-May/003954.html
        http://lists.fsck.com/pipermail/rt-devel/2003-May/003905.html
You'll also need the latest version of SearchBuilder 0.81_04 with patches 
scattered all over the place. I'm working on a change to the most recent 
SearchBuilder - which I should finish up soon - which will be easy to 
apply.

I've been slack and haven't got Oracle and RT successfully running on my 
OSX box - only on a Solaris box. Because of this (and the lack of 
instructions) Jesse has been hampered in debugging the remaining problems 
- and I don't think anyone else has stepped up to the plate - as you can 
see from the list - I seem to talk to myself quite often.

There are some Oracle/RT users out there - but they are either running 
Oracle/RT with a 2.0.x series of RT without any hassles or lack the 
resources to assist with the current development. The work is a little 
patchy so I hope you (or anyone else) isn't put off by this. I'm very 
interested in getting this working. I hope we can work collaboratively on 
this and get something out the door soon.

-Brook