#60 nbmasta should require root mysql user

[Anonymous]

If nbmasta attempts to install a nodeball as a user who
doesn't have the ability to create databases, and that
nodeball attempts to create a dummy DB, then the
nodeball gets half-installed and your only option is to
remove the nodeball and reinstall as the MySQL root user.

It would be better if nbmasta either checked to see if
the nodeball were going to create a dummy DB and then
verify that the user really wants to install if so, or
just always require that nodeballs be installed as the
root user. Otherwise we'll continue to encounter these
problems.

[Jay Bonci]

Logged In: YES
user_id=391769

But you should assume that you can create databases,
otherwise you can't create/edit nodes of type dbtable
either. I don't really see how this is a bug, because
that's the expected behaviour for a user with that
permission. The install_esite script grants all
permissions to the user that we have dominion over for
that reason.

Now if you think there is a need for more discrete
permissions associated with the mysql database user,
that's an option, but generally, I don't think this is an
issue if you use install_esite.

[chromatic]

Logged In: YES
user_id=2274

I'm leaning towards creating temporary tables instead of
temporary databases. That's one less thing we have to
delete manually at the end of an installation.