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 <[email protected]> escribió: Asunto: Re: [Maria-discuss] SPIDER Maria10 ->My55 Para: "Federico Razzoli" <[email protected]> Fecha: domingo, 25 de mayo, 2014 20:02 Hi Federico, > 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). 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 <[email protected]>: > Hi all. > Can a SPIDER table, on MariaDB 10.0, connect to a remote MySQL 5.5 table? I can't find this info. > 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). > > Federico > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
