[rt-users] supplying database credentials to rt-fulltext-indexer

[Alex Hall]

Hi all,
I think I can say definitely that this is a bug. I added the DB credentials
to RT_SiteConfig.pm and, suddenly, the indexer started working perfectly.
Yet RT itself pulls the exact same credentials from
RT_SiteConfig.d/03-DBInfo.pm with no trouble. I have all my settings in
multiple files under RT_SiteConfig.d, and they all work. It's just
rt-fulltext-indexer that seems to have trouble accessing them. This
explains a lot, and hopefully gets fixed in the next release. Thanks for
everyone's suggestions and help.

On Sat, Dec 10, 2016 at 5:56 AM, Alex Hall <ahall at autodist.com> wrote:

> I thought it would, but it doesn't seem to be. My db credentials must be
> correct, because RT isn't complaining of any db problems, and is working
> fine. Is it possible that there's a bug in 4.4.1 that causes this indexer
> to get confused by the use of the RT_SiteConfig.d/* files? I use those
> instead of a single .pm file. I'll have to try putting my database
> credentials in the actual PM file later today, once I'm awake, to see if
> that helps.
>
> Sent from my iPhone
>
> > On Dec 10, 2016, at 03:47, Alex Vandiver <alex at chmrr.net> wrote:
> >
> > On Fri, 9 Dec 2016 17:30:31 -0500
> > Alex Hall <ahall at autodist.com> wrote:
> >> What this file never says is how to tell the indexer tool how to
> connect to
> >> the database. It clearly isn't pulling from the RT configuration, nor
> from
> >> /home/www-data/rtrc.
> >
> > The indexer reads and uses the database configuration from
> > your /opt/rt4/etc/RT_Config.pm and /opt/rt4/tec/RT_SiteConfig.pm
> > files.  rtrc files are _only_ used by the "bin/rt" tool, which is meant
> > to be run from other machines than your RT host.
> >
> > The rt-setup-fulltext-indexer wants to know your DBA username and
> > password because it needs to create new tables and indexes, which the
> > standard RT database user does not have permissions to do.  Once the
> > index is set up, updates to the index are done as RT's standard
> > database user.
> >
> > - Alex
>



-- 
Alex Hall
Automatic Distributors, IT department
ahall at autodist.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20161212/aecd63a3/attachment.htm>