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.

Ian, everything what you wrote is true, but I will be more specific: server info: FreeBSD 10.1-STABLE #3 r274924M: Sun Nov 23 22:58:10 CET 2014 CPU: Intel(R) Xeon(R) CPU X5650 @ 2.67GHz (2666.82-MHz K8-class CPU) real memory = 25769803776 (24576 MB) FreeBSD/SMP: Multiprocessor System Detected: 24 CPUs PHP Version 5.6.13, php-fpm active for php-modules - I got them quite a lot, but I need them. Memcache of course enabled, automatic maintenance disabled (using cron). And using PHP OpCache (no stat on) also... I don't think there is much more optimise from my side. The thing is, the load on this server is not more 10 (24 CPU!), also in my case I don't use GEOIP (it is quite slow), so I really don't know what to improve more... I guess, there is now way optimise PHP code shown in screenshot of webgrind what I posted.

Hi guys, I am running latest revive ad server, I tuned absolutely everything what I could. Last month my RA serves 382 million banners (hosted on 1 server)... The thing is, I would like to optimise this even more. Playing with xdebug, I can see in my app this is slow down - the most time takes RA server to process. I am calling via local tag (xml-rpc was too slow). Here is screenshot of webgrind: I got couple of campaigns and banners, for banners I have to use REGEXP match (because no OR condition). I guess deleting inactive campaigns will not help. What I can do to improve speed? I saw you offer REDIS plugin, but I am not sure, if this helps in this case (mysql seems not a bottleneck here, I got it on SSD...) Thanks

Hi all, I am not sure, if it is just me, but links from forum posts (https?) are leading to the same page. Example: there is link: https://github.com/revive-adserver/revive-adserver/issues/597 code is: <a data-ipb="nomediaparse" href="" https: rel="external nofollow">https://github.com/revive-adserver/revive-adserver/issues/597</a> and clicking on this link leads to: http://forum.revive-adserver.com/topic/1890-update-delivery-limitations-plugin-for-os/

Hi all, is there some more-recent (responsive) custom template got Revive Adserver ? I want to offer my users to access stats and other features, would be nice to have custom template. Please let me know, I tried google, didn't find anything.

Hi guys, I get very strange error (without changing anything), sourcecode: https://github.com/revive-adserver/revive-adserver/blob/master/lib/OX/Extension/bannerTypeText/bannerTypeTextDelivery.php I fixed it that I add IF condition "if (!function_exists('Plugin_BannerTypeText_delivery_adRender')) {" My set up quite different from others: - I am using just text banners - I am using local delivery: - server setup + opcache settings: General info Zend OPcache 7.0.6-dev PHP 5.6.11 Host web4.xxx Server Software Lighttpd 1.4.x Start time 2015-07-30 12:49:32 Last reset 2015-07-30 13:03:32 Directives blacklist filename /data/www/opcache.blacklist.txt consistency checks no value dups fix false enable true enable cli false enable file override false error log no value fast shutdown true force restart timeout 180 inherited hack true interned strings buffer 4 load comments true log verbosity level 1 max accelerated files 1000 max file size no value max wasted percentage 0.05 memory consumption 33554432 optimization level 4294967295 preferred memory model no value protect memory false revalidate freq no value revalidate path false save comments true use cwd true validate timestamps false For me it is really strange, I don't know how is /data/www/ads/lib/OX/Extension/bannerTypeText/bannerTypeTextDelivery.php included, it is used "require(include)_once" ? Or it is connected with my server setup ? I tried restart php/clear opcache...nothing helps, I just had to put there "if" and now it is working... I saw in past post, it can be connected with APC or other php optimizer...

Thanks, thats a great news.

Hi guys, is there some update for Delivery Limitation Plugin ? Specially OS section, we got there old Windows versions, but new Windows is not there, also I believe there is some problem with OSX. On another side, I could imagine to have REGEXP in title, so one actually can see which string compared. If there is no update, I might to update it, I just don't want to reinvent wheel...

nope, and I don't think it is possible without modifying source codes. In the end I end up on local tag invocation - in my scenario it works good.

well, after little bit debugging and checking the code, and hit & miss technique, I found out, it is just enough write in script: $_REQUEST['variable'] = 'condition'; hope this will help somebody.

so big coincidence...I just wanted to find out exactly same...so I got same question. I am using site variables, with XML-RPC works good, but with local mode tag no success how to implement this. Please help