[Phpmyadmin-devel] Site management with phpMyAdmin
Hi, I just saw what is being done by some ISPs, maybe we could add this to phpMyAdmin, please comment. 1. The user authenticates himself (http or cookie mode). 2. We check in config if $cfgSiteManagement (or whatever) is allowed. 3. If allowed, we use stduser (or another account) with added privileges, to enable the user to create databases (with username_ as prefix), and we give all privileges to this user on this database. Maybe also a control mecanism to specify: - which users can use site management - maximum number of databases per user :) And because the user has grant access to his dbs, he could use some features of our user management panel to allow access to other users. This control mecanism could be implemented in the 'server config in database' feature. Marc
On Tue, Feb 12, 2002 at 09:52:03AM -0500, Marc Delisle wrote:
3. If allowed, we use stduser (or another account) with added privileges, to enable the user to create databases (with username_ as prefix), and we give all privileges to this user on this database. [...]
sounds interesting, but maybe also a bit complex to implement :) In my case, when an user account (webhosting) is created on one of our servers, everything is handled by "home made" scripts, creation of db and mysql user setup as well, and I don't really see how PMA could replace that. Let's see the other comments on the list :) Something that would still be nice to have IMHA is a web-based config.inc.php generator: an install.php3 which would ask a few questions (type of auth, type of server: unix->socket, nt->tcp, etc.) and then display the corresponding configuration. Could then simply be cut'n'pasted by the user (or directely saved if the chmod value is 0777, but maybe not so good...). Target "market": PMA newcommers, because the doc is maybe not yet really "newbie friendly" :) There are other projects using such an web-based installer: for example IMP or phpMyEdit if I recall correctely. Greetings from sunny Switzerland :) [ Zurich-Kloten, Switzerland (LSZH) 47-29N 008-32E 432M Temperature: 59 F (15 C), hey, we're in February! :) ] Olivier -- _________________________________________________________________ Olivier Mueller - om@8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
"Olivier M." a écrit :
On Tue, Feb 12, 2002 at 09:52:03AM -0500, Marc Delisle wrote:
3. If allowed, we use stduser (or another account) with added privileges, to enable the user to create databases (with username_ as prefix), and we give all privileges to this user on this database. [...]
sounds interesting, but maybe also a bit complex to implement :) In my case, when an user account (webhosting) is created on one of our servers, everything is handled by "home made" scripts, creation of db and mysql user setup as well, and I don't really see how PMA could replace that. Let's see the other comments on the list :)
Olivier, I don't see the complexity here: it's just a CREATE DATABASE and a GRANT, with some validation on the db name. And the new feature would enable users to create their own databases, a thing that your scripts can't do. Hmmm it looks like I want to implement this :)
Something that would still be nice to have IMHA is a web-based config.inc.php generator: an install.php3 which would ask a few questions (type of auth, type of server: unix->socket, nt->tcp, etc.) and then display the corresponding configuration.
Already asked as feature request 486080: Configuration files via the web. Marc
On Tue, Feb 12, 2002 at 10:37:13AM -0500, Marc Delisle wrote:
I don't see the complexity here: it's just a CREATE DATABASE and a GRANT, with some validation on the db name.
And the new feature would enable users to create their own databases, a thing that your scripts can't do.
hopefully :-) otherwise it could become quite difficult with quotas stuff, etc...
Hmmm it looks like I want to implement this :)
go go go .)
Something that would still be nice to have IMHA is a web-based config.inc.php generator: an install.php3 which would ask
Already asked as feature request 486080: Configuration files via the web.
right, already seen that in the past, but still assigned to nobody... well, maybe something for my next holidays... or if there is any volunter here? :) It's not a difficult task... Olivier -- _________________________________________________________________ Olivier Mueller - om@8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
"Olivier M." a écrit :
On Tue, Feb 12, 2002 at 10:37:13AM -0500, Marc Delisle wrote:
I don't see the complexity here: it's just a CREATE DATABASE and a GRANT, with some validation on the db name.
And the new feature would enable users to create their own databases, a thing that your scripts can't do.
hopefully :-) otherwise it could become quite difficult with quotas stuff, etc...
Olivier, how can you implement user quotas in MySQL? I tried but the dbs are owned by the user under which the server runs. Marc
On Tue, Feb 12, 2002 at 12:21:12PM -0500, Marc Delisle wrote:
hopefully :-) otherwise it could become quite difficult with quotas stuff, etc...
how can you implement user quotas in MySQL? I tried but the dbs are owned by the user under which the server runs.
man du ? :) (+ some perl) (no direct way...) Olivier -- _________________________________________________________________ Olivier Mueller - om@8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
"Olivier M." a écrit :
On Tue, Feb 12, 2002 at 12:21:12PM -0500, Marc Delisle wrote:
hopefully :-) otherwise it could become quite difficult with quotas stuff, etc...
how can you implement user quotas in MySQL? I tried but the dbs are owned by the user under which the server runs.
man du ? :) (+ some perl) (no direct way...)
I agree you can create a report of disk usage, and maybe charge for it, but this is not quota management (or does your perl DROP big tables? :). So I still don't see the difficulty of letting (optionally) the users create their dbs. Marc
Sorry guys, this is a feature already present in phpMyAdmin, by using normal wildcard db privileges. I will add a faq entry about this. Marc Delisle a écrit :
Hi,
I just saw what is being done by some ISPs, maybe we could add this to phpMyAdmin, please comment.
1. The user authenticates himself (http or cookie mode).
2. We check in config if $cfgSiteManagement (or whatever) is allowed.
3. If allowed, we use stduser (or another account) with added privileges, to enable the user to create databases (with username_ as prefix), and we give all privileges to this user on this database.
Maybe also a control mecanism to specify:
- which users can use site management - maximum number of databases per user :)
And because the user has grant access to his dbs, he could use some features of our user management panel to allow access to other users.
This control mecanism could be implemented in the 'server config in database' feature.
Marc
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
participants (2)
-
Marc Delisle -
Olivier M.