<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><!--[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]-->


<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">In the end I just went with a local mysql install, our Oracle DBAs are about as trusting as Russia (giving rights on your database)</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US">Performance is far better as well, since its local although I think that’s down to network latency between the App server and Oracle
 box. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US">Strangely the make install still didn’t work, I had to populate the initialdata file after the manual install.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US">All working now anyway so thanks for your help !
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US">4.2.3 is great by the way ! Good work :D
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US">Keith<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Kevin Falcone-2 [via RequestTracker] [mailto:ml-node+<a href="/user/SendEmail.jtp?type=node&node=57190&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>]
<br>
<b>Sent:</b> 09 April 2014 19:21<br>
<b>To:</b> Clancy, Keith<br>
<b>Subject:</b> Re: RT::Extension::Assets not working<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">On Tue, Apr 08, 2014 at 01:41:13AM -0700, helmutderhaas wrote:
<br>
>    Ah that makes sense, when I ran make initdb the wrong account was in the RT_Siteconfig so I
<br>
>    ran it manually .. should have checked as I only ran schema. <br>
<br>
Which means you also didn't run acl, but since you're on oracle it's <br>
less important. <br>
<br>
>    root@requesttracker:/tmp/Assets/rt-extension-assets-master# /usr/bin/perl -Ilib
<br>
>    -I/opt/rt4/local/lib -I/opt/rt4/lib /opt/rt4/sbin/rt-setup-database --action insert --datadir
<br>
>    etc --dba rt --prompt-for-dba-password  --package RT::Extension::Assets --ext-version 1.0
<br>
>    [12305] [Tue Apr  8 09:29:37 2014] [warning]: Unable to open etc/content: No such file or
<br>
>    directory at /opt/rt4/sbin/rt-setup-database line 374. (/opt/rt4/sbin/rt-setup-database:374)
<br>
<br>
If you say --datadir, RT looks for content in that directory. You have <br>
to use --datafile, like make initdb does. <br>
<br>
At this point, I would suggest dropping the assets tables and running <br>
make initdb cleanly and allowing the extension to manage your database <br>
changes rather than trying to piece it back together. <br>
<br>
-kevin <br>
<br>
-- <br>
RT Training - Dallas May 20-21 <br>
<a href="http://bestpractical.com/training" target="_top" rel="nofollow" link="external">http://bestpractical.com/training</a><o:p></o:p></p>
<div>
<p class="MsoNormal"><br>
<img border="0" id="_x0000_i1025" src="http://requesttracker.8502.n7.nabble.com/images/icon_attachment.gif"><strong>attachment0</strong> (243 bytes)
<a href="http://requesttracker.8502.n7.nabble.com/attachment/57181/0/attachment0" target="_top" rel="nofollow" link="external">
Download Attachment</a><o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" noshade="" style="color:#CCCCCC" align="center">
</div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:#444444">If you reply to this email, your message will be added to the discussion below:<o:p></o:p></span></b></p>
</div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:#444444"><a href="http://requesttracker.8502.n7.nabble.com/RT-Extension-Assets-not-working-tp57127p57181.html" target="_top" rel="nofollow" link="external">http://requesttracker.8502.n7.nabble.com/RT-Extension-Assets-not-working-tp57127p57181.html</a>
<o:p></o:p></span></p>
</div>
<div style="margin-top:4.8pt">
<p class="MsoNormal" style="line-height:18.0pt"><span style="font-size:8.5pt;font-family:"Tahoma","sans-serif";color:#666666">To unsubscribe from RT::Extension::Assets not working,
<a href="" target="_top" rel="nofollow" link="external">
click here</a>.<br>
<a href="http://requesttracker.8502.n7.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" target="_top" rel="nofollow" link="external"><span style="font-size:7.0pt;font-family:"Times New Roman","serif"">NAML</span></a>
<o:p></o:p></span></p>
</div>
</div>




        
        
        
<br/><hr align="left" width="300" />
View this message in context: <a href="http://requesttracker.8502.n7.nabble.com/RT-Extension-Assets-not-working-tp57127p57190.html">RE: RT::Extension::Assets not working</a><br/>
Sent from the <a href="http://requesttracker.8502.n7.nabble.com/Request-Tracker-User-f3.html">Request Tracker - User mailing list archive</a> at Nabble.com.<br/>