hampsterx Posted October 27, 2011 Report Share Posted October 27, 2011 hi there, Using Mysql backend but its kinda annoying that it creates a seperate database for each repository as we have a half dozen projects and we have backup policies at a per database level so its not all that convenient, let alone the plastic permissions requiring the ability to create databases, GRR. The databases are name rep_xx, how do I know which database corresponds to which repository and is it possible to rename them somehow? Sorry, bit of an odd request I suppose, Cheers, TiM Link to comment Share on other sites More sharing options...
manu Posted October 27, 2011 Report Share Posted October 27, 2011 Hi TiM, you can issue "cm lrep" this is going to give you the repository ID (rep_ID). I'm sorry but you can't rename the databases. regards, manu Link to comment Share on other sites More sharing options...
psantosl Posted November 8, 2011 Report Share Posted November 8, 2011 If you want to hack something (ok, at least learn about it) you can check the repositories database... there you'll find the mapping from repos to databases... We always thought having separate repositories was a good idea, what would be your proposal?? In Oracle we have a single database and multiple "users" (in their jargon) since creating databases is horribly expensive. Link to comment Share on other sites More sharing options...
hampsterx Posted November 8, 2011 Author Report Share Posted November 8, 2011 I see in repository table it uses an int field so it seems I can't rename them to rep_abc but at least I can reset the number back to 1,2,3 rather than 2,10 at present (oops, lots of experimentation). Presume if I shut down plastic service, rename row id's, rename databases, restart plastic server and it should be fine. Ie no other links in the tables elsewhere referencing ref_x directly other than this single table. That'll do for now sir, thnx~ Link to comment Share on other sites More sharing options...
psantosl Posted November 8, 2011 Report Share Posted November 8, 2011 Happy hacking! In fact, we should use repnames instead of ids... let me check if we can get rid of this limitation. Link to comment Share on other sites More sharing options...
psantosl Posted November 8, 2011 Report Share Posted November 8, 2011 Ok, the reason is to avoid having to rename the database (horrible) when you rename the repo... Link to comment Share on other sites More sharing options...
hampsterx Posted November 10, 2011 Author Report Share Posted November 10, 2011 thats fair enough. I'll probably pester you again about more friendly dialogues in the client when permission is denied to create a new database as the mysql account is locked down only to the databases it uses, ie denying create database operation. Cheers~ Link to comment Share on other sites More sharing options...
psantosl Posted November 16, 2011 Report Share Posted November 16, 2011 Sure! You will!! We'll be on it Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.