<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Seliteteksti Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.SelitetekstiChar
{mso-style-name:"Seliteteksti Char";
mso-style-priority:99;
mso-style-link:Seliteteksti;
font-family:"Tahoma","sans-serif";}
span.Shkpostityyli19
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:70.85pt 56.7pt 70.85pt 56.7pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1461992203;
mso-list-type:hybrid;
mso-list-template-ids:1103781580 -961636242 67829763 67829765 67829761 67829763 67829765 67829761 67829763 67829765;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
@list l1
{mso-list-id:2119325326;
mso-list-type:hybrid;
mso-list-template-ids:-274938880 771372670 67829763 67829765 67829761 67829763 67829765 67829761 67829763 67829765;}
@list l1:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=FI link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US>Hi all<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>As a background, I’m quite familiar with Oracle and mostly know my way with Linux, too, but I’ve no experience on PERL nor RT before.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>What I’m trying to do is install RT 3.8.8 on Oracle Linux 5.5 and configure it to use an existing remote Oracle 10g database. I’ve used this installation document <a href="http://requesttracker.wikia.com/wiki/CentOS5InstallPlusSome">http://requesttracker.wikia.com/wiki/CentOS5InstallPlusSome</a> as my guideline, with minor differences in versions etc, and the biggest difference probably is trying to use Oracle DB instead of MySQL, as that’s my and the company’s clear preference.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>README.Oracle says “You don't need to create anything beforehead.” It seems to be partly true as there should be nothing that needs to be created in the database before installing RT. But for using remote database it seems that Oracle client setup needs to be done on the RT host. Unfortunately I haven’t found instructions for that, so I’ve been trying to figure out the steps myself.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>So far I’ve tried several Oracle client configurations. Each time I’ve prepared the environment so that I could successfully tnsping the target database and connect using sqlplus. However, no success with make fixdeps yet:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>- First tried a light Oracle client version, Oracle Instant Client v10.1 and 11.2 (11g chosen because it installs more cleanly on Oracle Linux 5.5). Failed with missing .mk files.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>- Then I tried with normal Oracle Client 11.2 with same problem.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>- Then I figured out from the error messages that more Oracle SW is needed and found out that to get suitable .mk files installes I must install either whole Oracle database locally or install Oracle demo stuff. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>- So I installed Oracle DB demo stuff in the Instant Client home first. The .mk problem disappeared, but still it didn’t look good because of several errors.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>- I decided to try the same with standard Oracle 11.2 client home. Again, .mk problem disappeared, but still make fixdeps is unable to connect to the target Oracle database. This time the output starting from the error is as follows:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>===<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>…<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>t/10general.t ........... Bailout called. Further testing stopped: Unable to connect to Oracle (ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin))<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>DBI connect('','scott/tiger',...) failed: ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin) at t/10general.t line 22<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>FAILED--Further testing stopped: Unable to connect to Oracle (ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin))<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>make[1]: *** [test_dynamic] Error 255<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>make[1]: Leaving directory `/root/.cpan/build/DBD-Oracle-1.27-5tgtqm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> PYTHIAN/DBD-Oracle-1.27.tar.gz<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> /usr/bin/make test -- NOT OK<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>//hint// to see the cpan-testers results for installing this module, try:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> reports PYTHIAN/DBD-Oracle-1.27.tar.gz<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Running make install<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> make test had returned bad status, won't install without force<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>SMTP dependencies:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Net::SMTP ...found<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>STANDALONE dependencies:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Net::Server ...found<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> HTTP::Server::Simple >= 0.34 ...found<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> HTTP::Server::Simple::Mason >= 0.09 ...found<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>SOME DEPENDENCIES WERE MISSING.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>ORACLE missing dependencies:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> DBD::Oracle ...MISSING<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 /opt/rt3/rt-3.8.8)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>make: *** [fixdeps] Error 1<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>===<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>1.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Any suggestions what to try next?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>There’s a hint above that I don’t know how to apply. I probably should know some PERL basics.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>2.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>There’s probably a way to install DBD::Oracle manually somehow. Could it solve my problem? Can anyone assist / provide steps required to do it?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>3.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Btw, I’ve executed these installation steps (and basically all setup tasks before except Oracle client installation) as root in /etc/rt3/rt-3.8.8:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal>./configure<span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal>make testdeps<o:p></o:p></p><p class=MsoNormal><span lang=EN-US>PERL_MM_USE_DEFAULT=1 make fixdeps<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Is it ok or does it cause problems? Should I create some other account and use it? <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><div><p class=MsoNormal><span lang=EN-US>Regards, Tapio Tirkkola<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>tapio.tirkkola@csolutor.fi<o:p></o:p></span></p></div></div></body></html>