search

dream120 / common-schema

Automatically exported from code.google.com/p/common-schema
0 stars 0 forks source link

SUPER privilege error with Amazon RDS #62

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Version 2.2 of Common_Schema

The following error message is emitted several times when common_schema-2.2.sql 
is sourced:

ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is 
enabled (you *might* want to use the less safe log_bin_trust_function_creators 
variable)

RDS does not support the SUPER privilege.

Original issue reported on code.google.com by adogapan...@gmail.com on 28 May 2014 at 10:44

GoogleCodeExporter commented 9 years ago 
You do not necessarily need the SUPER privilege: you need SELECT privilege on 
mysql.* tables; for example on mysql.proc or mysql.user tables.

If you can't get such privilege, then some features in common_schema cannot be 
used.
Do import common_schema via mysql command line client --force, if possible.

Original comment by shlomi.n...@gmail.com on 29 May 2014 at 11:39

GoogleCodeExporter commented 9 years ago 
What do I need the SELECT privileges for?  Just installing the schema, or for 
actually using stored procedures etc. in the schema?  Who needs them?  A 
regular database user or the root user?

Thanks!

Original comment by adogapan...@gmail.com on 30 May 2014 at 9:39

GoogleCodeExporter commented 9 years ago 
To follow up, can I remove those grants after the schema is installed?

Original comment by adogapan...@gmail.com on 30 May 2014 at 9:41

GoogleCodeExporter commented 9 years ago 
Okay, I did the following:

grant select on mysql.* to <myrootuser>

SOURCE common_schema-2.2.sql

Same error.

ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is 
enabled (you *might* want to use the less safe log_bin_trust_function_creators 
variable)

Original comment by adogapan...@gmail.com on 30 May 2014 at 11:11

GoogleCodeExporter commented 9 years ago 
You need these grants for some grant-related views (such as sql_grants).
I'm going to need more details; I don't have your installation. What fails now?

try running 
"mysql < common_schema-2.2.sql"
(not SOURCE it from within mysql)

This should give you the line of error.

Original comment by shlomi.n...@gmail.com on 31 May 2014 at 4:44

GoogleCodeExporter commented 9 years ago 
I ran into the same error during installation of common_schema-2.2 to Amazon 
RDS. I tried the "mysql < common_schema-2.2.sql" and located the line of error 
as:

ERROR 1419 (HY000) at line 1160: You do not have the SUPER privilege and binary 
logging is enabled (you *might* want to use the less safe 
log_bin_trust_function_creators variable)

Original comment by kennethk...@peplink.com on 2 Sep 2014 at 4:53

GoogleCodeExporter commented 9 years ago 
This relates to the rdebug mechanism -- a stored routines debugger -- which you 
may not be using at all.

If you like to just ignore it, please remove lines 726 - 2484 (starting with 
`DROP procedure IF EXISTS _rdebug_analyze_routine` and ending with end of 
`rdebug_watch_variables()` routine.

Original comment by shlomi.n...@gmail.com on 2 Sep 2014 at 5:43