Ah that makes sense, when I ran make initdb the wrong account was in the RT_Siteconfig so I ran it manually … should have checked as I only ran schema.
However now when I run insert I get the following:
root@requesttracker:/tmp/Assets/rt-extension-assets-master# /usr/bin/perl -Ilib -I/opt/rt4/local/lib -I/opt/rt4/lib /opt/rt4/sbin/rt-setup-database --action insert --datadir etc --dba rt --prompt-for-dba-password --package RT::Extension::Assets --ext-version 1.0
In order to create or update your RT database, this script needs to connect to your Oracle instance on (port ‘’) as rt
Please specify that user’s database password below. If the user has no database
password, just press return.
Password:
Working with:
Type: Oracle
Host:
Port:
Name: ELRTPDG
User: rt
DBA: rt
Now inserting data.
[12305] [Tue Apr 8 09:29:37 2014] [warning]: Unable to open etc/content: No such file or directory at /opt/rt4/sbin/rt-setup-database line 374. (/opt/rt4/sbin/rt-setup-database:374)
[12305] [Tue Apr 8 09:29:37 2014] [warning]: readline() on closed filehandle $handle at /opt/rt4/sbin/rt-setup-database line 375. (/opt/rt4/sbin/rt-setup-database:375)
Couldn’t finish ‘insert’ step.
ERROR: Couldn’t load data from ‘etc/content’ for import:
ERROR:Can’t locate etc/content in @INC (@INC contains: /opt/rt4/sbin/…/local/lib /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib /opt/rt4/sbin/…/lib lib /opt/rt4/local/lib /opt/rt4/lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at /opt/rt4/sbin/…/lib/RT/Handle.pm line 815.
Looks like its expecting a file in the etc directory called ‘content’ that isn’t there. 
Keith Clancy
EBS Global Commodities & Wholesale
Telephone: +49 211 73275 5417 (This line is not recorded)
Mobile: +49 171 552 6709
Email: keith.clancy@eon.commailto:keith.clancy@eon.com
E.ON Business Services GmbH
Völklinger Straße 4
40219 Düsseldorf
www.eon.comhttp://www.eon.com
www.eon.comhttp://www.eon.com/
Vorsitzender des Aufsichtsrats/Chairman of the Supervisory Board: Jørgen
Kildahl, Vorstand/Board of Management: Klaus Schäfer (Vorsitzender/Chairman),
Christopher Delbrück, Gareth Griffiths, Dr. Egbert Laege, Sitz/Registered
Office: Düsseldorf, Amtsgericht/District Court: Düsseldorf HRB 61123From: Kevin Falcone-2 [via RequestTracker] [mailto:ml-node+s8502n57134h97@n7.nabble.com]
Sent: 07 April 2014 20:12
To: Clancy, Keith
Subject: Re: RT::Extension::Assets not working
In the section you describe it lists:
RT::Extension::Assets (Not currently loaded)
Action Date Elapsed RT::Extension::Assets Version
Schema updates from /tmp/Assets/rt-extension-assets-master/etc Mon Apr 07 17:08:32 2014 0 seconds 1.0
Didn’t seem to give any errors regarding permissions.
There should be 3 entries, Schema, ACL and Insert.
The fact that you only have one means make initdb didn’t finish
properly. Do you have a log from when you ran it?
Did you run make initdb or did you attempt to do the database
initialization by hand?
-kevin
RT Training - Dallas May 20-21
http://bestpractical.com/training
[http://requesttracker.8502.n7.nabble.com/images/icon_attachment.gif]attachment0 (243 bytes) Download Attachmenthttp://requesttracker.8502.n7.nabble.com/attachment/57134/0/attachment0
If you reply to this email, your message will be added to the discussion below:
http://requesttracker.8502.n7.nabble.com/RT-Extension-Assets-not-working-tp57127p57134.html
To unsubscribe from RT::Extension::Assets not working, click herehttp://requesttracker.8502.n7.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=57127&code=a2VpdGguY2xhbmN5QGVvbi5jb218NTcxMjd8LTIwNTkwNjkzMA==.
NAMLhttp://requesttracker.8502.n7.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html!nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers!nabble%3Aemail.naml-instant_emails!nabble%3Aemail.naml-send_instant_email!nabble%3Aemail.naml
View this message in context: http://requesttracker.8502.n7.nabble.com/RT-Extension-Assets-not-working-tp57127p57155.html
