[download blocked from server ips]

when i try to download the package e.g.

https://download.revive-adserver.com/revive-adserver-5.5.1.tar.gz

on one of our servers, download is rejected with forbidden.

From my local machine download works fine.

I tried different ways (curl, wget, ip4, ip6), to i think our ips (hetzner cloud) are blocked.

Please unblock or allow other ways (download with secret key in header etc).

[monitoring checks recommendation?]

what is the preferred way to run (nagios) monitoring checks on revive adserver?

- ad requests should not be counted for statistics and limits (is there some way to exclude via ip, special test param etc)

- or should we create a separate zone just for monitoring (but then we are not checking if the real ads are broken)?

 

[Clean out old data]

manually deletion is not recommended, but i did that successfully on test installation.

do not forget to backup your data before.

TRUNCATE TABLE `ox_data_intermediate_ad`;
TRUNCATE TABLE `ox_data_intermediate_ad_connection`;
TRUNCATE TABLE `ox_data_summary_ad_hourly`;
TRUNCATE TABLE `ox_data_summary_zone_impression_history`; 

(table name prefix may be different e.g. rv_, check your config file, i assumed ox_ because of your old installation)

partial deletion should be possible the same way by the datetime columns of each table (with higher risk of inconsistent data).

[secure sessionId prefix for admin]

i am trying to set prefix for admin cookie "sessionId". There is no conf entry for that so i tried via:

variables.php
$GLOBALS['_MAX']['MAX_COOKIELESS_PREFIX'] = '__Secure-';

but still not used.
Please tell me how to configure that (without hacking/forking the code)

[Problem with PHP 8.0.15]

i tried to run revive 5.3.1 on php 8.0.16 and finally give up and run on 7.4.28.

zones are broken. This is not related to the data in zones table, i truncated the table. Then add one new entry via ui, after that the view is broken (entry is not shown, add new zone is not shown anymore).

php error log says:

[03-Mar-2022 11:57:03] WARNING: [pool www] child 196800 said into stderr: "Stack trace:"
[03-Mar-2022 11:57:03] WARNING: [pool www] child 196800 said into stderr: "#0 {main}"
[03-Mar-2022 11:57:03] WARNING: [pool www] child 196800 said into stderr: "  thrown in /projects/local/revive-adserver-5.3.1/www/admin/affiliate-zones.php on line 123"
[03-Mar-2022 11:57:18] WARNING: [pool www] child 196800 said into stderr: "NOTICE: PHP message: PHP Fatal error:  Uncaught TypeError: Cannot access offset of type string on string in /projects/local/revive-adserver-5.3.1/www/admin/affiliate-zones.php:123"

there is similar error on ad delivery

[DB version out of sync]

database version is detected from the database.

don't forget to create a backup of your database before.

 

you can reset your installation like that if you missed the upgrade:

in var directory:

- delete INSTALLED

- create empty file UPGRADE (if you do this with root, check that webapp can write to this file, e.g. via chaning owner to www-data)

- delete *.log

- delete default.conf.php 

run web-ui and follow the upgrade process

upgrade will fail if you do some of the changes from the upgrade process manually.