freakylolbat Posted December 18, 2013 Report Posted December 18, 2013 Hi, i am running a master/ slave configuration from the new revive adserver and i have a problem with the distributed statistics while running the maintainance-distributed.php So i have one master and one slave. When the crontab execute the maintainances-distributed.php on the slave he writes the following to the debug.log: [emergency] -111 :: Unable to disable the bin log - will not insert stats. [ info] Running Maintenance Distributed Engine [ debug] - Current time is 2013-12-18 22:41:27 UTC [ debug] - Will process data for all operation intervals before and up to start [ debug] time of 2013-12-18 21:00:00 UTC [ info] - Processing the revi_data_bkt_c table for data with operation interval start equal to or before 2013-12-18 21:00:00 UTC [ debug] - 7 records found [emergency] -111 :: Unable to disable the bin log - will not insert stats. I already tried to run the script with the disabled bin-log on the slave, but doesn t change something. Whats the right config for solving this problem ? Thanks a lot. Quote
Ilya Ber Posted December 19, 2013 Report Posted December 19, 2013 Is there a "super" privilege assigned to your Revive mysql user? If not, try setting it and don't forget to flush privileges afterwards: GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password'; Quote
freakylolbat Posted December 19, 2013 Author Report Posted December 19, 2013 Ok thanks this solved the problem with the message. Is there somewhere a documentation or something like that for the openx / revive adserver? since they relaunched there website there are no informations about the application especially for distributed statistics or setting up master slave.... Thanks Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.