Distributed Statistics Problem On Slave

[freakylolbat]

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.

[Ilya Ber]

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';

[freakylolbat]

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