12 Feb
2002
12 Feb
'02
4:53 a.m.
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
12 Feb
12 Feb
5:20 a.m.
New subject: [Phpmyadmin-devel] Site management with phpMyAdmin - installer script?
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(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
5:38 a.m.
New subject: [Phpmyadmin-devel] Site management with phpMyAdmin - installer script?
"Olivier M." a écrit :
On Tue, Feb 12, 2002 at 09:52:03AM -0500, Marc Delisle wrote:
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 :)
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.
Already asked as feature request 486080: Configuration files via the
web.
Marc
5:48 a.m.
New subject: [Phpmyadmin-devel] Site management with phpMyAdmin - installer script?
On Tue, Feb 12, 2002 at 10:37:13AM -0500, Marc Delisle wrote:
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(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
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.
7:22 a.m.
New subject: [Phpmyadmin-devel] Site management with phpMyAdmin - installer script?
"Olivier M." a écrit :
On Tue, Feb 12, 2002 at 10:37:13AM -0500, Marc Delisle wrote:
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
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...
7:32 a.m.
New subject: [Phpmyadmin-devel] Site management with phpMyAdmin - installer script?
On Tue, Feb 12, 2002 at 12:21:12PM -0500, Marc Delisle wrote:
man du ? :) (+ some perl)
(no direct way...)
Olivier
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
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.
7:37 a.m.
New subject: [Phpmyadmin-devel] Site management with phpMyAdmin - installer script?
"Olivier M." a écrit :
On Tue, Feb 12, 2002 at 12:21:12PM -0500, Marc Delisle wrote:
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
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.
24 Feb
24 Feb
3:03 a.m.
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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
8232
days inactive
8244
days old
7 comments
2 participants
participants (2)
-
Marc Delisle -
Olivier M.