Hi,
Thx for the reply.
On Mon, Jul 23, 2001 at 09:51:47PM +0200, Werner Stuerenburg wrote:
> Databases for MySQL are just subdirectories, as you may already
> know, so you may very easily restrict disc usage on those subdirs
> for each student.
I'm not sure how relevant this will be - but I suspect my handling of
the student home areas will get in the way thus:
the web server and mysql sit on a dedicated box, the studnet home
areas are quotaed and are served via NFS/automount from solaris
servers.
Whilst setting up apache to server web pages is easy enough via the
use of the public_html directive (ie http://webserver/~userid will
serve web pages from /home/userid/public_html) I'm not at all clear on
how I can make MySQL serve each database from a similar
structure. Additionally I'm not at all sure I want to have databases
being served via NFS. However it would be interesting if MySQL allowed
this - at least I could explore - but whenever I've compiled it I've
always had configure serve databases from one set directory - I'm not
sure what configure option would allow serving databases from multiple
directories based on their userid.
<Just thinking out aloud>
Actually I guess I could just create a quota on the MySQL server for
each user - to be active on the database directory. Hmmm - I must sit
down and play a little I guess.
</Just thinking out aloud>
> Also, you may use symbolic links and place those subdirs into the
> dir structure you provide for the students anyway.
I see what you're getting at - as per above I guess I must play a bit
with structures and quotas.
However I was hoping for something simpler controlled within MySQL.
Thanks for the reply,
Surinder
>
> Surinder S. Dio schrieb am Montag, 23. Juli 2001, 17:09:54:
>
> > I work in a university and need to give students access to a MySQL
> > database from their php enabled web server.
>
> > Ideally waht I'd like to do is to setup MySQL so that each student has
> > their own unique database, accessible from their own userid, this
> > would mean a large (1000) number of relatively small databases (I'm
> > hoping to restrict each student to approx 20Mb for Db usage) and they
> > could setup their own tables etc via something like phpMyAdmin. They
> > can have full access rights to their own individual db - but not see
> > any other students's.
>
> > ALso I want to restrict the size of the database for each studnet - as
> > this is only for learning php/mysql purposes and if theirs a more
> > serious project then I can provide other facilities.
>
> > Is this going to to be achievable - how are other Uni's or ISP who
> > provide MySQL dealing with this tpye of issue.
>
> > If I can't restrict the size of each database - should I be pursuing
> > some other db option?
------------------------------------------------------------------
Surinder Singh Dio , School of Computing and Mathematical Sciences
[EMAIL PROTECTED] , University of Greenwich, London, England.
---------------------------------------------------------------------
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
