Mysql user 'rt_user'@'localhost' privileges at appropriate level?

RT Users
1

Hi all.

I had to recreate the user rt_user@localhost in mysql.

Originally I couldn’t get access to the web interface at all
(“internal server error”),
I ended up recreating the rt_user@localhost account in mysql,
and granted all privs on the ‘rt3’ database.

This led to the web interface spitting back debugging messages
( example from error.log:
DBD::mysql::st execute failed: select command denied to user:
‘rt_user@localhost’ for table ‘Users’ at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 410.
RT::Handle=HASH(0x8c63c10) couldn’t execute the query ‘SELECT * FROM
Users WHERE Name = ?’ at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 417.
)

…I ended up doing
GRANT ALL PRIVILEGES ON . to ‘rt_user’@‘localhost’;
which definitely seems to have fixed things… :confused:

What privs are necessary for this user?
I have granted ‘all’ on the rt3 database, which is fine,
but what’s the most restrictive privs I can set up for the rest of the
mysql installation?

Thanks in advance,

–Benji Wakely

2

What privs are necessary for this user?

I usually pull it out of the install scripts when I need to remember.

I have granted ‘all’ on the rt3 database, which is fine,
but what’s the most restrictive privs I can set up for the rest of the
mysql installation?

The rt user doesn’t need any access to the rest of the mysql install,
so none…

seph