[rt-users] Bad TMPDIR

[merchant+rt at oceanwave.com]

After turning on logging, I found out that this is why none of my searches are
working within the GUI (but work just find when I do them by hand with mysql):


DBD::mysql::st execute failed: Can't create/write to file '/usr/home/user/tmp/#sqle341_2212_1.MYI' (Errcode: 13) at /usr/local/lib/perl5/site_perl/5.005/DBIx/SearchBuilder.pm line 139, <GEN0> chunk 51.
DBIx::SearchBuilder error:Can't create/write to file '/usr/home/user/tmp/#sqle341_2212_1.MYI' (Errcode: 13)
        Query String is SELECT DISTINCT main.* FROM Users main   WHERE
((main.Disabled = '0')) AND ((main.Name LIKE '%user%'))  ORDER BY main.Name ASC
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/lib/perl5/site_perl/5.005/DBIx/SearchBuilder.pm line 157, <GEN0> chunk 51.

/usr/home/user/tmp is the TMPDIR ENV setting of the person who built all of
the modules (via the FreeBSD ports collection) and installed RT on the web
server.

Apache itself was started by root, who has no TMPDIR environment variable.
Running the printenv script that comes with apache doesn't list a TMPDIR ENV
variable, either.

Where is RT getting it's TMPDIR setting from?  How can I force it NOT to use a
user's personal tmp directory?