LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 09-03-2009, 12:17 AM   #1
Mamsaac
LQ Newbie
 
Registered: Sep 2009
Posts: 6

Rep: Reputation: 0
Sharing MySQL in a partition with two distributions.


Not too difficult and I got a partial solution to the problem already, but I was looking for a better one.

I got Fedora 12 and Ubuntu Jaunty installed in this computer (as well as Windows Vista, but last time it was used was several weeks ago). I got a partition of MySQL (mounted, in both OS, on /media/MySQL). The thing is, that when I'm on Fedora, I have to change the owner in order to have MySQL working, and when I get back to Ubuntu, I have to change the permissions yet again.

For the moment, I just have a script that runs when the system starts (... ok, not a script but a command ).

chown -R mysql:mysql /media/MySQL

So, it works... but I don't think it's ok to have it changing permissions every time the system starts. Is there a more natural way of sharing permissions in two different installations? I got different software in each OS that uses the same databases.

And if you ask me "why have to distributions?", let's just say I have to =) At least for the following month.

Thanks in advance.
 
Old 09-03-2009, 12:44 AM   #2
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
'Sounds like you might be better off booting to one OS (or the other), then running the other one as a VM (e.g. in VMWare or VBox).

PS:
I assume you've already tried setting ownership to the *same* user and group ... and making sure they have the *same* numeric uid and gid on both OS's...
 
Old 09-03-2009, 12:44 AM   #3
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Ubuntu 12.04, Antix19.3
Posts: 3,794

Rep: Reputation: 282Reputation: 282Reputation: 282
I think the problem is in the uid and gid of the mysql user/group on the different distros. If so, you need to get those the same but that might be a tricky exercise. If it's only for a month, I would live with it.

Quote:
but I don't think it's ok to have it changing permissions every time the system starts
Why not? Exceptional circumstances require exceptional solutions Just my
 
Old 09-03-2009, 12:46 AM   #4
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,790

Rep: Reputation: 653Reputation: 653Reputation: 653Reputation: 653Reputation: 653Reputation: 653
Hi Maamsaac,

You just need to make the uid and gid for mysql the same in both distributions, find ones that are available on both distros.

eg.
Code:
groupmod -g 123 mysql
usermod -u 123 -g 123 mysql
cheers,

<sorry... late reply >
kbp

Last edited by kbp; 09-03-2009 at 12:47 AM. Reason: Late reply
 
Old 09-03-2009, 10:33 AM   #5
Mamsaac
LQ Newbie
 
Registered: Sep 2009
Posts: 6

Original Poster
Rep: Reputation: 0
Thanks for the help. That last commands are what I needed =)

I had Fedora running in VirtualBox before the installation. The idea is to make a slow transition from Ubuntu to Fedora (and by slow I mean 2-3 months), because there's a lot of software running already in Ubuntu and because I want to see how stable Fedora is (I'm running the Alpha of Fedora 12... meaning it won't be much stable, although so far it's been good. When 12 comes as stable, I will most likely make the change).
 
Old 09-03-2009, 11:25 PM   #6
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,355

Rep: Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751
Well, each Fedora only lasts 13 mths, why not go Centos (== RHEL but free) which lasts 7+ yrs?
 
Old 09-04-2009, 12:05 AM   #7
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Ubuntu 12.04, Antix19.3
Posts: 3,794

Rep: Reputation: 282Reputation: 282Reputation: 282
I second chrism01's opinion regarding Fedora's short life cycle. At this moment I don't second his opinion on Centos 5.3 (there are some stories going around about late updates). chrism01 might be able to indicate if that's still the case.

Ubuntu server has 5 years support on the LTS versions (8.04 currently).
 
Old 09-04-2009, 12:05 AM   #8
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Ubuntu 12.04, Antix19.3
Posts: 3,794

Rep: Reputation: 282Reputation: 282Reputation: 282
I second chrism01's opinion regarding Fedora's short life cycle. At this moment I don't second his opinion on Centos 5.3 (there are some stories going around about late updates). chrism01 might be able to indicate if that's still the case.

Ubuntu server has 5 years support on the LTS versions (8.04 currently).
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
2 distributions on one partition? neolithic_psyche Linux - Newbie 2 04-07-2008 12:42 PM
Sharing /home between distributions debeus Linux - General 7 06-13-2007 07:53 PM
Sharing partitions between several distributions on the same machine ninjabob7 Linux - General 3 12-24-2005 08:48 PM
Are multiple distributions on the same partition possible? khurdp Linux - Distributions 6 02-06-2005 04:00 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 07:22 PM.

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