<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
</style>
<![endif]-->
<p class="MsoNormal">Hi all, I am trying o configure RT-Authen-ExternalAuth, as
per the documentation with this I can see you can have more than one mode of
authentication (LDAP, DB etc).</p>
<p class="MsoNormal">Now my LDAP (AD) integration is fine, but what my issue now
is to get RT to authenticate against Oracle DB as its secondary authentication method,
and I am lost with this. </p>
<p class="MsoNormal"><b style="mso-bidi-font-weight:normal">Following are my
system details</b></p>
<p class="MsoNormal">OS – Redhat 5.4 (64bit)</p>
<p class="MsoNormal">Oracle – 10g2 (64bit)</p>
<p class="MsoNormal">RT - 3.8.8</p>
<p class="MsoNormal">Perl - v5.12.2)</p>
<p class="MsoNormal"><b style="mso-bidi-font-weight:normal">Modules which are
loaded:</b></p>
<p class="MsoNormal">DBD::Oracle</p>
<p class="MsoNormal">DBI</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><b style="mso-bidi-font-weight:normal">I have done the following
configuration </b></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal">Set($ExternalAuthPriority,<span style="mso-spacerun:yes"> </span>[<span style="mso-spacerun:yes">
</span>'My_LDAP', <span style="mso-spacerun:yes"> </span>'My_Oracle'<span style="mso-spacerun:yes"> </span>]);</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal">Set($ExternalInfoPriority,<span style="mso-spacerun:yes"> </span>[ 'My_LDAP', 'My_Oracle' ]);</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal">Set($ExternalServiceUsesSSLorTLS,<span style="mso-spacerun:yes"> </span>0);</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal">Set($AutoCreateNonExternalUsers,<span style="mso-spacerun:yes"> </span>0);</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"> </i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal">Set($ExternalSettings,<span style="mso-spacerun:yes"> </span>{<span style="mso-spacerun:yes">
</span># AN EXAMPLE DB SERVICE</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'My_Oracle'<span style="mso-spacerun:yes"> </span>=><span style="mso-spacerun:yes"> </span>{<span style="mso-spacerun:yes">
</span>## GENERIC SECTION</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The type of service (db/ldap/cookie)</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'type'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'db',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The server hosting the service</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'server'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>localhost,</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>## SERVICE-SPECIFIC SECTION</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The database name</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span>'database'<span style="mso-spacerun:yes"> </span>=><span style="mso-spacerun:yes"> </span>'RT',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The database table</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'table'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'USERS',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span># The user to connect
to the database as</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'user'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'rtdb1',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The password to use to connect with</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'pass'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'rtdb1secret',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The port to use to connect with (e.g. 3306)</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span><span style="mso-spacerun:yes"> </span>'port'<span style="mso-spacerun:yes"> </span>=><span style="mso-spacerun:yes"> </span>'1521',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The name of the Perl DBI driver to use (e.g. mysql)</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'dbi_driver'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'Oracle',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span>#
The field in the table that holds usernames</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'u_field'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'NAME',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The field in the table that holds passwords</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'p_field'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'PASSWORD',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span><span style="mso-spacerun:yes"> </span># The Perl package &
subroutine used to encrypt passwords</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># e.g. if the passwords are stored using the MySQL v3.23
"PASSWORD"</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># function, then you will need Crypt::MySQL::password, but for the</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># MySQL4+ password function you will need Crypt::MySQL::password41</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># Alternatively, you could use Digest::MD5::md5_hex or any other</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># encryption subroutine you can load in your perl installation</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'p_enc_pkg'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'Crypt::MySQL',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'p_enc_sub'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'password',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># If your p_enc_sub takes a salt as a second parameter,</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span># uncomment this line to add
your salt</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>#'p_salt'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'SALT',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>#</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span># The field and values in the table
that determines if a user should</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># be disabled. For example, if the field is 'user_status' and the values</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span># are ['0','1','2','disabled'] then
the user will be disabled if their</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># user_status is set to '0','1','2' or the string 'disabled'.</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># Otherwise, they will be considered enabled.</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'d_field'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'disabled',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'d_values'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>['0'],</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span>## RT
ATTRIBUTE MATCHING SECTION</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The list of RT attributes that uniquely identify a user</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'attr_match_list'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>[<span style="mso-spacerun:yes"> </span>'GECOS',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'NAME'</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>],</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span># The mapping of RT
attributes on to field names</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'attr_map'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>{<span style="mso-spacerun:yes"> </span>'Name' => 'NAME',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'EmailAddress' => 'EMAILADDRESS',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'ExternalAuthId' => 'NAME',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span>'Gecos'
=> 'GECOS'</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>}</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>},</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span># AN EXAMPLE
LDAP SERVICE</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes"> </span>'My_LDAP'<span style="mso-spacerun:yes"> </span>=><span style="mso-spacerun:yes">
</span>{<span style="mso-spacerun:yes"> </span>## GENERIC SECTION</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span># The type of service (db/ldap/cookie)</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-spacerun:yes">
</span>'type'<span style="mso-spacerun:yes">
</span>=><span style="mso-spacerun:yes"> </span>'ldap',</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"> </i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"><span style="mso-tab-count:3"> </span><span style="mso-spacerun:yes"> </span>……………………………………………….</i></p>
<p class="MsoNormal"><i style="mso-bidi-font-style:normal"> </i></p>
<p class="MsoNormal"><b style="mso-bidi-font-weight:normal">With the above
configuration, when I try to login to RT the IE displays following message.</b></p>
<p class="MsoNormal"><i style="">DBI
connect('database=RT;host=myhost.exampal.com;port=1521','rtdb1',...) failed:
Can't connect using this syntax without specifying a HOST and one of SID
INSTANCE_NAME SERVER SERVICE_NAME at
/usr/local/rt-3.8.8-ora/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm
line 440</i></p><p class="MsoNormal"><br></p><p class="MsoNormal">Thanks and Best Reagards<i style="mso-bidi-font-style:normal"><br></i></p>
</div>
</div></body></html>