Attachment Index?

I’ve noticed these recurring errors popping up in my httpd error log and am not sure what to make of them
New RT5 instance with mysql and shib authentication on CENTOS7.
I generated some test tickets with attachments and they go thru fine although the attachments themselves don’t seem to be stored in the directly I had specified.

my RT_SiteConfig.pm file contains the following:

enable external file storage

Set(%ExternalStorage,
Type => ‘Disk’,
Path => ‘/opt/rt5-attcs’,

yet when I check that directory, nothing there for attachments so not sure where they are getting dumped. More disconcerting is the errors in httpd. Ideas?

What’re the errors you’re seeing? I’d check webserver rights to read that dir and make sure you have the cron script running:

The files are initially stored in the database when RT receives them; this guarantees that the user does not need to wait for the file to be transferred to disk or to the cloud, and makes it durable to transient failures of cloud connectivity. The provided sbin/rt-externalize-attachments script, to be run regularly via cron, takes care of moving attachments out of the database at a later time.

https://docs.bestpractical.com/rt/5.0.0/RT/ExternalStorage.html

error messages are as follow:

[7854] [Mon Nov 23 14:50:35 2020] [warning]: DBD::mysql::db selectrow_array failed: Table ‘rt5.AttachmentsIndex’ doesn’t exist at /opt/rt5/sbin/…/lib/RT/Config.pm line 784. (/opt/rt5/sbin/…/lib/RT/Config.pm:784)
[7854] [Mon Nov 23 14:50:35 2020] [error]: External table AttachmentsIndex does not exist (/opt/rt5/sbin/…/lib/RT/Config.pm:787)

I believe AttachmentsIndex is the default name for the full text index, do you have that feature enabled but haven’t run the sbin/rt-setup-fulltext-index script?

I believe so…this is my RT_SiteConfig.pm portion:

enable FullTextSearch

Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Column => ‘ContentIndex’,
Table => ‘AttachmentsIndex’,

I’ve not run that script…is that a one time deal or should that be cron’d?

That one you run once then there is the /opt/rt5/sbin/rt-fulltext-indexer --quiet script that you can have cron run periodically to update the index

1 Like

thx very much…believe I have it squared away now