2ge

just add two cents, here are SQL queries to run to clean up a bit: delete from ox_data_summary_ad_zone_assoc where expired < '2022-01-01'; optimize table ox_data_summary_ad_zone_assoc; delete from ox_data_intermediate_ad where interval_end < '2022-01-01'; optimize table ox_data_intermediate_ad; delete from ox_data_summary_ad_hourly where date_time < '2022-01-01'; optimize table ox_data_summary_ad_hourly; delete from ox_audit where updated < '2022-01-01'; optimize table ox_audit;

Hi nope, for some reason problem persist Communication with the update server timed out, so Revive Adserver is not able to check if a newer version is available at this stage. Please try again later. if you send me technical info, I can run some debug, not sure why it is failing

Hi all, installed latest 5.0.5, for some reason, when I go to Product Updates I get error message: You are currently using Revive Adserver v5.0.5 running on nginx 1.14.0, PHP 7.4.4 and MySQL 5.5.5-10.1.35-MariaDB. Communication with the update server timed out, so Revive Adserver is not able to check if a newer version is available at this stage. Please try again later. in log I see: Apr 17 05:51:18 +0000 OX-5e9943ccd174f [ error] Sync: No response from the remote XML-RPC server. How I can fix this ?

Hi Andrew, thats totally OK with me, I was just confused about some news it went to the latest version...please read this article: https://www.revive-adserver.com/blog/help-us-test-the-upgrade-of-geotargeting-rules-to-geoip2/ I suggest to update it, so there is no confusion about it. Thanks!

Hi guys, I would like to use Geo Targeting in RA 4.2.1 - I am not sure, if GEOIP2 is supported, and how to test it. I tried to download GEOIP legacy file and also GEOIP2 new format, but in RA banner limitations it doesn't show the option to set up GEO targeting. Any clues ? currently using Revive Adserver v4.2.1 running on lighttpd 1.4.45, PHP 7.3.0RC4 and MySQL 5.5.5-10.0.30-MariaDB. MaxMind GeoIP Plugin 1.3.6 downloaded, unpacked, path configured for https://geolite.maxmind.com/download/geoip/database/GeoLite2-Country.tar.gz But still in banner limitations I can not set GEO Please help, is GEO2 supported in 4.2.1 or it is not ? If it is, how to configure it ?

I am exactly looking for this information too. My revive_adserver database is taking now 17GB and it should be good to clean it. For example every stats which is older than 2017. Would be good to know how to do it, of course some script would be great.

Hi, yes, you can correct it like that (but be sure https works there), or even use src="//your.domain.com/image.jpg" in this case the same protocol type will be used (https or http)

Great, I finally found it. Was always clicking on my nickname instead of dropdown...

Andrew, thanks for fast answer. Sure, I was checking some FAQ before - https://www.revive-adserver.com/faq/troubleshooting-banner-delivery/ - I recommend to link https problem there. I will create ticket on github. Happy to be Patreon - happy to put this in my signature (if possible) - so maybe more members gets inspired.

Hi, maybe this will save a lot of time for somebody, I am leaving my story here as guide. I added new advertiser, new campaign, new banner, html banner was something like: <a href="..."><img src="http://..." /></a> then I saw my banner is not served (I check everything 10 times, logs, setup...everything...). I decided to upgrade RA from 3.2.4 to 4.0.1. Problem persist. Then I wanted to write my question here, but suddenly I remember if https is not issue. I got site on https, and banner is on http (image), so I try to go http://myadserver.com/1/www/delivery/afr.php?zoneid=1 and banner was showing! So of course I just change banner code to <a href="..."><img src="//..." /></a> and now everything is working. It took me like 5 hours... Anyway, it would be great if there is some message about this, for example in banner details - that this banner is not compatible with https or something... another note - I saw you add Patreon - https://www.patreon.com/revive_adserver - of course I become sponsor. I want to inform also other forum members, but I couldnt find setting where I can set up my signature. Thanks for this software!

something like this: ...you need to set some cookie first $_COOKIE['OAID'] = md5(rand(1,100000000)); ...and then you set up your params $_REQUEST['foo'] = 'bar'; require_once('/data/www/yourserver.com/www/delivery/alocal.php'); $adArray = view_local('', $zoneid, 0, 0, '', '', '0', $OA_context, '');

yes, I know what you mean. But if you check my first post, you can see, actually this small PHP code is taking the most time in request. I am experimenting with what I wrote, I will see results later, when server will be loaded. I am not sure how it is made, but I guess maintenance script compiles all active banners from activa campaigns and create the code, and then using eval() is made comparsion. The thing is, it MIGHT be done, that it is faster with keys. So for example it is more easy (and fast) compare if $_SERVER['HTTP_ACCEPT_LANGUAGE'] == 'en'then $_REQUEST = array( 'lang' => 'en', 'variable' => 1, 'variable2' => 2 );and comparing these, problem is with the keys are 2nd level, so in that case maybe foreach is used etc.... But it is just THEORY.

Thanks for really nice help. Well, I think PHP execution what it makes slow (see my first post), it is not database (no slow query...). To look inside for my scenario. I got 2 zones. Each zone got around 200 active banners. Each banner got this delivery limitation (approx): so, I am checking always only site variable, there is always lang, and then might be some other criteria, this example it is country (I am doing GEO targeting on source server). I think this it makes really slow, to compare all 200 criteria, CPU load on that server is really high. So I was thinking, if for example "lang" I can pass via "Client - language", it would make things faster, what you think ? Somebody have knowledge how RA executes these limitations ? Thanks.

Thanks for all replies. Well, I am running download server and ad server on the same server. Download server request ad using local tag, and then process it. I am thinking, if it would help to move RA to another server and run it there as single service. If yes, I had to call using http - ajs.php on my ad server to get banners, right ? In the same time I am thinking local delivery save some overhead to make new TCP connection and so on...

well, mysql is running on another box :) I was just hoping to get info on methods/functions I see in webgrind, why they take so much time and how possible to optimise them. I am using quite a lot of conditions via variables for banners delivery (example 'myvar' regex match 'ab|cd|ef' and 'othervar' equals 'this') I guess, campaigns which are not active are not evaluating - so deleting them will not help.