[BlueOnyx:16946] Re: MySQL attribute create is unknown error in GUI

[Dan Porter]

The CCEd restart did the trick - thanks!   I will have to add that to my
bag of tricks when I get stuck.   Appreciate all you do Michael.

Dan Porter
Twin Wolf Technology Group, LLC

On Mon, Feb 2, 2015 at 9:26 PM, Michael Stauber <mstauber at blueonyx.it>
wrote:

> Hi Dan,
>
> > I have submitted this problem via the GUI support ticket system but am
> > getting no response from Gregg/Michael the past 5 days.   Perhaps someone
> > here can help...
>
> Sorry, I have been incredibly busy with 5209R development.
>
> > I created a new VPS and then created the first site.   When I try to
> enable
> > a MySQL database in the GUI I get an error response that says:
> >
> > Sorry, an internal server error occurred. The attribute create is
> unknown.
>
> Restart cced: "/sbin/service cced.init restart"
>
> Most likely CCEd was not restarted after base-mysql got updated.
>
> Afterwards: Make sure to not auto-create MySQL users with more rights
> than supported by your MySQL version. So if you have more options ticked
> under "Server Management" / "MySQL Configuration" than supported, the
> create will fail.
>
> You can use phpMyAdmin to review which permissions your version of MySQL
> supports.
>
> For 5107R/5108R and 5207R/5208R these are:
>
> Data: All
>
> Structure: All except for "SHOW VIEW", "CREATE ROUTINE", "ALTER ROUTINE"
> and "CREATE VIEW"
>
> Administration: All but "CREATE USER". But you really don't want to set
> that many.
>
> --
> With best regards
>
> Michael Stauber
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20150203/39816eeb/attachment.html>