Re: [Maria-discuss] SPIDER Maria10 ->My55
![](https://secure.gravatar.com/avatar/06fb7e7f8217ef0e572a8334567b7559.jpg?s=120&d=mm&r=g)
Hi Kentoku
I think you answered directly to my address by mistake, so I'm sending this reply to the list.
I changed the values of those variables and now everything works.
Thank you!
Regards
Federico
--------------------------------------------
El dom, 25/5/14, kentoku
Can a SPIDER table, on MariaDB 10.0, connect to a remote MySQL 5.5 table? I can't find this info.
Yes, it can.
If it can, I have a problem I don't understand. I can create the table, but when I execute any query I get:
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation
(which is misleading in any case, since I have SUPER)
Nothing is written to the local error log (and I can't access the remote one).
Hi all. Can a SPIDER
If it can, I have a problem I don't understand. I can create the
Normally, Spider sends "set
sql_log_off" command to remote server
after connecting, and this command needs SUPER
privilege.
For fixing this error, please
perform one of the followings.
- add SUPER
privilege to user for Spider table on remote MySQL 5.5
server.
- set Spider options
"spider_internal_sql_log_off = 0" and
"spider_remote_sql_log_off = 0" in
configuration file.
Thanks,
Kentoku
2014-05-23 18:38 GMT+09:00
Federico Razzoli
ERROR 1227 (42000):
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
(which is misleading in any case, since I
have SUPER)
Nothing is written to the local error log (and I can't access the remote one).
Federico
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (1)
-
Federico Razzoli