LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-24-2009, 02:17 PM   #1
raktri4u
LQ Newbie
 
Registered: Feb 2009
Posts: 12

Rep: Reputation: 0
user administration in mysql-zrm


I have configured Amanda and ZRM for mysql.Both are running fine but i need to make different Sub administrators in amanda and ZRM mysql config.Now the scene is that i need one person responsible for backup and verifiaction of dumps for one location.i.e. in one location i will be the person to take care of backup but in other i want ABC to take care,it means i need to make it user dependent...but i am not finding any such option in amanda.conf.But in ZRM mysql we use one user/password for connecting mysql admin to ZRM.so we can have in that,but i dont know where we use this password as all the process is automatic...loll.can u guys help me out ..plzzzzzzzzz
 
Old 03-25-2009, 07:35 AM   #2
choogendyk
Senior Member
 
Registered: Aug 2007
Location: Massachusetts, USA
Distribution: Solaris 9 & 10, Mac OS X, Ubuntu Server
Posts: 1,197

Rep: Reputation: 105Reputation: 105
For Amanda, you would use Unix/Linux standard user/group access security approaches.

Amanda should be running as it's own user -- amanda or amandabackup, or something like that. The person responsible for the Amanda backups could have that user account password. I'm assuming they don't have root, otherwise they have access to everything.

You could also make use of sudo. On some of my servers, my boss and I are the only ones with root. Everything else is controlled by sudo. If someone needs to do a particular function, we set up just what they need, and nothing else, using sudo. Some of that is controlled by groups. We have an lpadmin group, an smbadmin group, a webadmin group. The lpadmin group can `sudo cancel jobid`, for example.
 
Old 03-30-2009, 03:50 PM   #3
raktri4u
LQ Newbie
 
Registered: Feb 2009
Posts: 12

Original Poster
Rep: Reputation: 0
thanks choogendyk,
bro i am still unable this to resolve this issue..as all the processes like,backup is automatically done but for restoration we have to do it from root whose passwd i cann't share with my team mates as they can do anything they want.and worse is that for restoration user should be root or root privileged user..
I have few more things to improve as below------
* Is there any GUI for amanda backp exists...I have found amrecgui but its not working
* in case of any specific record i want to restore then i have to restore the full DB in ZRM so can i have any such option which can do restoration record wise?
* lol the biggest one user administration.

Please help me in this..
I am continuously working and doing R&D for these but till now NO RESULTS...

thanks in advance
rak
 
Old 04-01-2009, 08:47 AM   #4
choogendyk
Senior Member
 
Registered: Aug 2007
Location: Massachusetts, USA
Distribution: Solaris 9 & 10, Mac OS X, Ubuntu Server
Posts: 1,197

Rep: Reputation: 105Reputation: 105
Recovering from backup is inherently a root type operation. I'm not sure how to get around that. I do use sudo a lot to configure systems so that non root users can do certain administrative things. But, once you've given them backup recovery, you've pretty much given them the keys to everything.

I thought ZRM could do portions of a DB and incrementals even to a point in time. I need to get into it more myself.

As far as GUI's are concerned, I don't have much use for them on my servers. My latest servers have been minimal OS installs with no GUI capability at all. No video cards. None of the packages installed that have anything to do with support of graphical interfaces. Just serial console to access ILOM.

If you have more specific questions, I'll try to get back to it in the next day or two.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: ZRM 2.1: Backing Up MySQL Partitioned Tables LXer Syndicated Linux News 0 12-19-2008 08:20 PM
LXer: MySQL Backup And Recovery With mysql-zrm On Debian Sarge LXer Syndicated Linux News 0 09-28-2006 08:21 AM
mysql user administration errors narutovsvegito Linux - Software 0 07-18-2006 11:35 AM
Mysql administration error lil_drummaboy Linux - Networking 1 10-18-2004 12:26 AM
MySQL administration kevincheung Linux - Software 6 09-16-2004 08:56 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:05 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration