[rt-users] trouble in using the RT command line tools

[Bruce Campbell]

On Mon, 28 Jan 2002, Frank Rutzen wrote:

> I modified the suidperl as in the FAQ.
> Now it's going one step further and i get the Error:
> "No RT user found. Please consult your RT administrator."
>
> For testing i setup a user with the same name in the linux box and on my
> RT system and get the mentioned error.

Make sure that the User's 'Unix Login' is also set in their
User's Configuration.

> Do i need to allow a database connections for this linux user to the RT
> database?

That 'depends'.  If a given unix user can a) execute 'rt', and b)
config.pm is being read correctly (different error message if it isn't),
then the MySQL database is seeing a connection from the username and
password defined in config.pm.  The rough answer is 'no, only the rt_user
needs to access SQL, all other users effectively are the rt_user when
connecting to the databases'.

The next obvious thing to do is to verify that you are allowing that user
to connect from any host that has access to your RT installation... which
means the webserver you run RT on, and any hosts where 'rt' can be
executed on.  ( For myself, thats over a hundred hosts, so I have a
somewhat 'loose' SQL access list to my annoyance. )

However, you should get a rather obvious error message from the perl DB
libraries if the above paragraph is the case.



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