Converting Exisiting RT installation to Oracle

RT Developers
1

Greetings from Australia,

This is my first post to the RT Developer’s list, excuse me if I’m covering
old ground.

We have an existing modified RT installation using MySQL locally on the
same server. Everything is running fine.

The powers that be want to convert this installation to use an Oracle
8.1.7 DB hosted on another machine.

Could someone give me (or point me in the direction to) the steps required
to accomplish this? I have modified the Config.pm file to use Oracle as
the DBIx driver and changed the host name to the Oracle box we are using.
What else do I need to do? How should I change SearchBuilder?

Thanks in Advance,

Brian Houston

This email and any files transmitted with it, are confidential and is intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please notify the system manager.

This footnote also confirms that this email message has been scanned by AUSTAR Communications content and virus scanning applications
for the presence of computer viruses.

2

Greetings,

We are in the middle of converting RT from MySQL to Oracle 8.1.7 and are
running into some difficulties.

We have the RT application on one Linux box, and the Oracle DB on another.
Here are the steps that we have completed so far:

  1. Manually recreated all tables from MySQL DB to Oracle DB.
  2. Edited the config.pm file to provide the new database name, hostname,
    password etc.
  3. Edited the webmux.pl file to include the local ORACLE_BASE and
    ORACLE_HOME directories.

On restarting the Apache server, everything seems to be fine, no errors are
thrown- but on accessing RT via the Web Interface, I’m getting the
typical “cannot find server or DNS error” as if Apache isn’t even
started… I’ve checked the apache error log and the rt error log, and
also the
rt application log in /var/logs/rt none of them give any indications of a
problem.

Can anyone give me a hint where I’m going wrong here? Any clues would be
greatly appreciated.

Thanks and cheers,

Brian Houston

This email and any files transmitted with it, are confidential and is intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please notify the system manager.

This footnote also confirms that this email message has been scanned by AUSTAR Communications content and virus scanning applications
for the presence of computer viruses.

3

Can anyone give me a hint where I’m going wrong here? Any clues would be
greatly appreciated.

Excuse me asking the obvious… do you know for sure that DBI is working
with the Oracle server?

Dan Shearer
Open Source Manager
Mob: +61 411 49 1800
Tel: +61 8 8130 3104
dan@tellurian.com.au

4

---- Dan Shearer said: ----

Can anyone give me a hint where I’m going wrong here? Any clues would be
greatly appreciated.

Excuse me asking the obvious… do you know for sure that DBI is working
with the Oracle server?
Yes. SearchBuilder did not.
–sdg

5

Greetings,

We are in the middle of converting RT from MySQL to Oracle 8.1.7 and are
running into some difficulties.

Unless you’ve done extensive internal work to port RT to Oracle 8, I’d
strongly recommend against running RT 2.0.x on Oracle in production.
Really. A port of RT3 to oracle is underway, but the work done on 2.0
was prototype level at best.

Best,
Jesse

»|« Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

6

The obvious is usually right, and in this case it was too. We didn’t have
the DBD::Oracle configure properly.

Thanks and cheers,

Brian

(Embedded image moved to file: pic09248.pcx)

Dan Shearer dan@tellurian.com.au 25/10/2002 15:37
(Embedded image moved to file: pic26018.pcx)To: Brian Houston/NCO/CEtv BHouston@austar.com.au
cc: rt-devel@lists.fsck.com

Subject: Re: [rt-devel] Converting Exisiting RT installation to Oracle

Can anyone give me a hint where I’m going wrong here? Any clues would
be
greatly appreciated.

Excuse me asking the obvious… do you know for sure that DBI is working
with the Oracle server?

Dan Shearer
Open Source Manager
Mob: +61 411 49 1800
Tel: +61 8 8130 3104
dan@tellurian.com.au

This message has been scanned for viruses by AUSTAR Communication’s
antivirus and content checking applications.

Austar Communications

This email and any files transmitted with it, are confidential and is intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please notify the system manager.

This footnote also confirms that this email message has been scanned by AUSTAR Communications content and virus scanning applications
for the presence of computer viruses.

pic09248.pcx (14.7 KB)

pic26018.pcx (1.05 KB)