RT::Extension::Assets not working

Hi,

Wondering if anyone else has seen this ?
Using RT 4.2.3 and Installed RT::Extension::Assets from git using the
instructions at
http://bestpractical.com/docs/assets/latest/RT/Extension/Assets.html

However when I enable it in my RT_SiteConfig.pm and try to access the assets
option in the interface I get the following error in the logs

[31375] [Mon Apr 7 15:36:02 2014] [error]: No active catalogs.
(/opt/rt4/local/plugins/RT-Extension-Assets/lib/RT/Extension/Assets.pm:188)
[31375] [Mon Apr 7 15:36:02 2014] [error]: Can’t call method “Id” on an
undefined value at
/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Elements/SelectCatalog
line 65.

Stack:

[/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Elements/SelectCatalog:65]

[/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Elements/CreateInCatalog:51]

[/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Helpers/CreateInCatalog:48]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:680]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:368]
[/opt/rt4/share/html/autohandler:53]
(/opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm:211)
[31375] [Mon Apr 7 15:36:06 2014] [error]: No active catalogs.
(/opt/rt4/local/plugins/RT-Extension-Assets/lib/RT/Extension/Assets.pm:188)
[31375] [Mon Apr 7 15:36:06 2014] [error]: Can’t call method “Id” on an
undefined value at
/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Search/index.html line
50.

Stack:

[/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Search/index.html:50]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:680]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:368]
[/opt/rt4/share/html/autohandler:53]
(/opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm:211)

Once I disable the plugin its all fine again.

Any ideas ?

Keith

View this message in context: http://requesttracker.8502.n7.nabble.com/RT-Extension-Assets-not-working-tp57128.html

Wondering if anyone else has seen this ?
Using RT 4.2.3 and Installed RT::Extension::Assets from git using the
instructions at
http://bestpractical.com/docs/assets/latest/RT/Extension/Assets.html

However when I enable it in my RT_SiteConfig.pm and try to access the assets
option in the interface I get the following error in the logs

It sounds like you skipped this step:

http://bestpractical.com/docs/assets/latest/RT/Extension/Assets.html#make-initdb

You can confirm that by going to Admin → Tools → System
Configuration and searching for RT Upgrade history and looking for a
recent line showing an install of the RT::Extension::Assets data.

-kevin

I did that initially, and it didn’t throw any errors.

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.

KeithFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: 07 April 2014 18:38
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT::Extension::Assets not working

Wondering if anyone else has seen this ?
Using RT 4.2.3 and Installed RT::Extension::Assets from git using the
instructions at
http://bestpractical.com/docs/assets/latest/RT/Extension/Assets.html

However when I enable it in my RT_SiteConfig.pm and try to access the
assets option in the interface I get the following error in the logs

It sounds like you skipped this step:

http://bestpractical.com/docs/assets/latest/RT/Extension/Assets.html#make-initdb

You can confirm that by going to Admin → Tools → System Configuration and searching for RT Upgrade history and looking for a recent line showing an install of the RT::Extension::Assets data.

-kevin

[31375] [Mon Apr 7 15:36:02 2014] [error]: No active catalogs.
(/opt/rt4/local/plugins/RT-Extension-Assets/lib/RT/Extension/Assets.pm
:188) [31375] [Mon Apr 7 15:36:02 2014] [error]: Can’t call method
“Id” on an undefined value at
/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Elements/SelectC
atalog
line 65.

Stack:

[/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Elements/Select
Catalog:65]

[/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Elements/Create
InCatalog:51]

[/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Helpers/CreateInCatalog:48]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:680]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:368]
[/opt/rt4/share/html/autohandler:53]
(/opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm:211)
[31375] [Mon Apr 7 15:36:06 2014] [error]: No active catalogs.
(/opt/rt4/local/plugins/RT-Extension-Assets/lib/RT/Extension/Assets.pm
:188) [31375] [Mon Apr 7 15:36:06 2014] [error]: Can’t call method
“Id” on an undefined value at
/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Search/index.htm
l line 50.

Stack:

[/opt/rt4/local/plugins/RT-Extension-Assets/html/Asset/Search/index.html:50]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:680]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:368]
[/opt/rt4/share/html/autohandler:53]
(/opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm:211)

Once I disable the plugin its all fine again.

Any ideas ?

Keith


View this message in context:
http://requesttracker.8502.n7.nabble.com/RT-Extension-Assets-not-worki
ng-tp57128.html Sent from the Request Tracker - User mailing list
archive at Nabble.com.

RT Training - Dallas May 20-21
Training — Best Practical Solutions

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

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. :confused:

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://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

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.

Which means you also didn’t run acl, but since you’re on oracle it’s
less important.

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
[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)

If you say --datadir, RT looks for content in that directory. You have
to use --datafile, like make initdb does.

At this point, I would suggest dropping the assets tables and running
make initdb cleanly and allowing the extension to manage your database
changes rather than trying to piece it back together.

-kevin

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)
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.

Strangely the make install still didn’t work, I had to populate the initialdata file after the manual install.

All working now anyway so thanks for your help !

4.2.3 is great by the way ! Good work :smiley:

KeithFrom: Kevin Falcone-2 [via RequestTracker] [mailto:ml-node+s8502n57181h54@n7.nabble.com]
Sent: 09 April 2014 19:21
To: Clancy, Keith
Subject: Re: RT::Extension::Assets not working

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.

Which means you also didn’t run acl, but since you’re on oracle it’s
less important.

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
[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)

If you say --datadir, RT looks for content in that directory. You have
to use --datafile, like make initdb does.

At this point, I would suggest dropping the assets tables and running
make initdb cleanly and allowing the extension to manage your database
changes rather than trying to piece it back together.

-kevin

RT Training - Dallas May 20-21

[http://requesttracker.8502.n7.nabble.com/images/icon_attachment.gif]attachment0 (243 bytes) Download Attachmenthttp://requesttracker.8502.n7.nabble.com/attachment/57181/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-tp57127p57181.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-tp57127p57190.html

Strangely the make install still didn’t work, I had to populate the initialdata file after the
manual install.

make install won’t set up your database.
If make initdb didn’t work, we’d love to see a full log of the run and
how it failed.

-kevin