Using TM in CMS

Submitted by ddistelhorst on Wed, 02/07/2008 - 23:41

I'm on a shared host. I use a CMS for my website. I'd like to implement TM to help 'tweak' the CMS database. I'm not sure how to implement TM.

TM currently displays every DB in MySQL (including those that belong to other customers on the hosted site). However, it does not let me manage any DB including my own. It will display my DB tables but not allow anything other than that.

I tried to modify settings.php and create a dbrestrict for my username and DB but then it doesn't even display my DB any more and simply displays Create & Restore panel (but these don't work since I'm not the MySQL admin.

Is there a way to use TM just to manage my DB on a shared host?

‹ WIll not work, need help

grants

Submitted by AppCreator on Thu, 03/07/2008 - 04:27.

Hi ddistelhorst,
From version 3 of the TM I started using the MySQl privilege system to restrict the functionality available to users. The theory was to remove buttons etc when a user didn't have the privileges to use them.
If you can go to write query: SHOW GRANTS; in the Write Query box, I would be interested to see the results.
If you would like to turn of the restrictions so that all the functionality shows in the file reuseable.php around line 1426 change:

return $rt;
to:
return TRUE;

I'll look at making that easier to control off in the next version.

Thanks for pointing out the issue with dbrestrict I can see what's wrong with that and it will be fixed in the next version. For now if you wish to make use of it just adding an extra database as the first item in the array should work eg:

<?php
case 'tester':
  $dbnamearray= array('extra',  'mydb');
  break;
?>

Let me know how it goes.