how i can give user space, how many mysql database will have

[StaraDama]

how i can give user space, how many mysql database will have.


I want to give my friend 100mb space , 3 mysql database, ftp access and http://mydomain/~hisnick access to web with public_html which will show data in net.

With with program i can do this.

Thnx.

[StaraDama]

anyone plis.

[DefconAlpha]

i don't know of any specific programs to do most of what you want, but...

for the 100mb of space, just use disk quotas, try emerging either sys-fs/quota or sys-fs/quotatool

for the 3 databases, that part is tricky. you will probably just want to create three databases with whatever name your buddy wants and deny all CREATEs except CREATE TABLE and definitely exclude his user from all databases except his specific db's. most of the pretty gui tools that do this are front ends that do essentially the same thing i just described.

ftp is easy, emerge proftpd and make sure you configure it to restrict to the ~ folder (home folder)

web is also easy, just emerge apache and set it up to use user_mod (by default this should work). all you will have to do is create a public_html folder that the apache process can read so either put apache in the users group *bad idea* or perhaps symlink public_html to somewhere that apache can read (probably a better idea)
_________________
In the end, the love you get is equal to the love you make
--John Lennon & Paul McCartney (The End - Abbey Road,

[StaraDama]

when i emerge quota and in webmin try to run qouta i get this

No local filesystems can support quotas.


why

[StaraDama]

[DefconAlpha]

Quota support is a kernel issue, if you don't have it built into your kernel, it won't happen.

The 'front-end' is a generic application that makes a harder utility easy to use (ie DVD::Rip and K3b). There is no 'front-end' for the database stuff, you will actually have to run the commands to create the table and assign passwords and privileges and such.
_________________
In the end, the love you get is equal to the love you make
--John Lennon & Paul McCartney (The End - Abbey Road,