Mysql privileges for rt_user

RT Users
1

It seems that our mysql database corrupted a bit when we lost power this
past Thursday and the mysql privileges for the rt_user have been lost. Can
someone send me a list of which mysql privileges the rt_user needs?

Thanks,
Christian

Christian Gilmore
Technology Leader
GeT Support Application Development
IBM Software Group

2

It seems that our mysql database corrupted a bit when we lost power this
past Thursday and the mysql privileges for the rt_user have been lost. Can
someone send me a list of which mysql privileges the rt_user needs?

Thanks,
Christian

Christian Gilmore
Technology Leader
GeT Support Application Development
IBM Software Group

In /path/to/rt/etc/ you have a acl. which sets the rt_user
permissions. In the file:
“GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON
${RT::DatabaseName}.* TO ${RT::DatabaseUser}
@${RT::DatabaseRTHost} IDENTIFIED BY
‘${RT::DatabasePassword}’;”);

But verify it against your own version of acl..

I would think this i the best way to recover it, since I don’t know your
RT version. The statement I posted is for mysql and RT 3.0.4.

/rhb