2ge

I was upgrading my old Revive Adserver and found out it was hacked. Classical idiotic stuff on prepend code in zones, but what is new is automatically creating Admin access. Here is info - even if I delete this user, is recreated: user_id contact_name email_address username password language default_account_id comments active sso_user_id date_created date_last_login email_updated 1000 Revive Adserver Service [email protected] service 8cef76d7d9862db25d9244a4e2721634 en 1 NULL 1 NULL NULL NULL NULL for this reason various aspects of site doesnt work (reset password, login for some users etc). I am going to clean install and if official developers want source code/db I will back it up for further study. I tried to find out where this user is created, in which php, but no avail. I dont know when or which RA was hacked (version)

I have the same issue with latest Revive Adserver v5.5.2 devs: please try to reset password - it doesnt work. (so I can not set up password for users in GUI, so I have to go to DB. And are you storing password as md5() with no salt ? Well, thats more than easy to hack in miliseconds. https://crackstation.net/

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.