[rt-users] Bad TMPDIR

[Bruce Campbell]

On Mon, 13 May 2002 merchant+rt at oceanwave.com wrote:

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

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

Hrm.  Its not set by RT itself (which could be a problem in overriding
nastys from the environment). RT::Interface::Web uses File::Temp, which in
the documentation mentions using the TMPDIR variable.  It is possible that
when installing the modules, the contents of this variable was hardcoded
into some libraries that RT depends on.

Setting the TMPDIR and reinstalling File::Temp on my FreeBSD testbox
does not result in this behaviour, so I'd suggest you do:

	find /usr/local/lib/perl5 -type f -print | xargs grep -lE "user\/tmp"

and see which file has it defined.


-- 
                             Bruce Campbell                            RIPE
                   Systems/Network Engineer                             NCC
                 www.ripe.net - PGP562C8B1B                      Operations