Thanks for the response Joshua,
That is an option - however not one I would be very comfortable with. I have
a similar setup for virtual hosts generally - wanted something more flexible
and powerful for a virtual server implementation without taxing the actual
server too much.
For example, the mail server (qmail) is not chrooted as such - however pop
is chrooted via tcpserver, delivering messages to users in a virtual env.
SMTP works the same way, chrooting to say "/home/user/etc/tcp.cdb" to check
relay.
Unfortunately, I know little about the actual "how-does-it-work" part of
MySQL and need some direction :)
I am going to try something in the next 3-4 days and hopefully I'll post a
positive outcome.
If this works, I'll write a HowTo :)
Thanks again for your response.
Mustafa.
> OS: debian-2.2.19
----- Original Message -----
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To: "Mustafa Hashmi" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 1:51 PM
Subject: Re: Virtualizing MySQL
> The short answer is that you can't, if you're using a named pipe
> (/tmp/mysql.sock, or some such). That would require every user having
their
> own installation of MySQL, which may be what you want.
>
> Why not have the users connect via TCP/IP, and just set permissions
> correctly? They would be able to list the other databases on the server,
but
> if permissions are set correctly, they will only be able to have access to
> their own databases.
>
> Hope that helps.
>
> j----- k-----
>
> On Thursday 30 August 2001 12:21, Mustafa Hashmi wrote:
> > Gerhard,
> >
> > Thank you for your response.
> >
> > Emphasizing that I am new to this, could you describe in a bit more
detail
> > how I could put this in the new root structure? (client's chrooted
> > structure)
> >
> > If this is too extensive to properly explain, is there some
documentation
> > available which might help?
> >
> > I appreciate your help.
> >
> > Regards,
> > Mustafa.
> >
> > ----- Original Message -----
> > From: "Gerald Clark" <[EMAIL PROTECTED]>
> > To: "Mustafa Hashmi" <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Thursday, August 30, 2001 1:03 PM
> > Subject: Re: Virtualizing MySQL
> >
> > > Two problems.
> > > The clients don't have access to the databases, the server does.
> > >
> > > Chrooted clients will not be able to read and write the named pipe
> > > unless it is in their new root structure.
> > >
> > > Mustafa Hashmi wrote:
> > > > Hi all,
> > > >
> > > > I am in the process of creating a Virtual Server - and pretty much
all
> > > > aspects have been completed to my liking. This includes web / mail /
> > > > ftp
> >
> > and
> >
> > > > ssh.
> > > >
> > > > The next hurdle is virtualizing MySQL, and I would like to do this
by
> > > > sharing the same MySQL server across multiple chrooted clients. This
> >
> > way,
> >
> > > > they can have unlimied databases / tables under their userID without
> >
> > looking
> >
> > > > at, or disrupting, any of the other clients in their chroot.
> > > >
> > > > I am also rather new to this, so please feel free to point me to a
URL
> >
> > which
> >
> > > > may help. I've tried though - couldn't find anything relevant to my
> >
> > cause.
> >
> > > > I appreciate your time.
> > > >
> > > > Cheers,
> > > > Mustafa.
> > > >
> > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > > > Before posting, please check:
> > > > http://www.mysql.com/manual.php (the manual)
> > > > http://lists.mysql.com/ (the list archive)
> > > >
> > > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > > To unsubscribe, e-mail
> >
> > <[EMAIL PROTECTED]>
> >
> > > > Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
> > >
> > > --
> > > Gerald L. Clark
> > > [EMAIL PROTECTED]
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> --
> Joshua Kugler, Information Services Director
> Associated Students of the University of Alaska Fairbanks
> [EMAIL PROTECTED], 907-474-7601
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
