andrewatfornax

That's a nice problem to have!
Yes, I see your point about wanting to scale horizontally. Distributed statistics, as a concept, is what is needed. Unfortunately, distributed statistics won't work on Postresql (I just checked with fellow Revive Adserver core project team member Matteo Beccati).
There are other options, though. If you like we could have a conversation about your requirements and how my company could help you to meet them. For example, we've got a piece of software (a Revive Adserver plugin actually) that uses nosql for caching and raw delivery statistics logging, and intermediate maintenance steps. We use this at huge scale on our hosting platform at https://www.aquaplatform.com too.
You can contact me via the form at https://www.aquaplatform.com/contact/ and I'll get back to you.

Totally digging Revive and the plugins!
Thought I would pass on issue was having and how I solved.
When trying to access the "Video Ads - Player Info" area always got an error (like 404 or 403 can't remember) and just gave up. Got some spare time and looking at the files in the videoReport folder, saw that many were set to 777. Changed them to 755 and everything started working.
I am sure it is known that many servers puke at 777 these days so 755 should maybe be default?
Thanks for the great platform, we use it for many school related projects and helps us make a few bucks:)
Susan

Sure enough, I had an ad blocker enabled and didn't even realize it.  With the ad blocker disabled it's showing just fine in Chrome.  
 

Hi, 
In advertiser add/edit page there is option available as "Display only one banner from this advertiser on a web page", chose this and save changes.
This option will prevent same ads showing from same advertiser on same page where multiple zone placed.  In each zone different advertiser ads only will be shown. Hope this will work.

I would suggest having a look in the preferences table (probably called 'b_preferences' in your case) and finding out if a row exists there for timezone with preference_name "timezone".
I've seen cases where that row disappeared (but have never been able to explain why).
If so, just add one row and make sure it has a unique preference ID and event_name equals "timezone" (lower case). Account_type must be "MANAGER" (all caps).
Once that's done, you should be able to set your time zone preference, although you might want to first remove that invalid row with preference_id = 0.

Hi, @andrewatfornax.
Right, the user no longer shows in the User Access page under Inventory, but that does not prevent the user from logging in.
I've deleted the user from the database, so now he cannot log in.
Thank you very much for your help.

I'd suggest just using the regular iframe or async tags, instead of that code you built yourself.

Hi @gniver,
Possibly the final part of http://documentation.revive-adserver.com/display/DOCS/No+Statistics re: UI preferences?

Hi @gniver,
Possibly the final part of http://documentation.revive-adserver.com/display/DOCS/No+Statistics re: UI preferences?

Hi, I tried to use this but it doesn't work :
I create a subdomain.mydomain.com.conf.php with this code inside :
 
 
But I don't have any ad when I put the tag code with the new subdomain. The subdomain alias is working fine.
How can I do please ?
Thanks.
EDIT : I resolved the problem, I needed to go in the admin panel using the subdomain.mydomain.com URL to get a new tag code.

MAC addresses are not part of an http request, and thus they are not available to a web server nor the ad server.

Hello.
I have one zone with two banner on Revive Adserver v3.2.2. I placed iframe-tag on web-page. Banners are displayed.
I wanted to look at the statistics. It was empty.
I executed maintenance-script from console.
Now statistics are displayed. But "Impr." column is still empty. Why?

UPD: Problem is solved. AdBlock blocks /delivery/lg.php

OpenX Source became an open source project and was renamed to Revive Adserver in September of 2013. You can read about it here:
http://www.revive-adserver.com/blog/openx-announces-sale-of-openx-source/
 
You can read more about Revive Adserver's functionality on our documentation pages at http://documentation.revive-adserver.com/display/DOCS/Revive+Adserver+Documentation

Hello sa_bhardwaj,
 
how Erik meintioned, it is a open source project and you can download it. You can test it on a local webserver or by and wished hosting server.
 
 
Best Regards,

Useful documentation here..http://documentation.revive-adserver.com/display/DOCS/No+Statistics... but dosen't answer the issue that I'm seeing.
 
Thanks!
Aditya

Hi, 
 
Request log records will store on this table "rv_data_bkt_r". And Impressions on "rv_data_bkt_m" table.

The script tries to use "LOAD DATA INFILE ..." because it's faster.
 
If it can't (for any reason) do this, then it falls back to using standard SQL INSERT statements instead.
 
There is effectively no difference except from a performance perspective.
 
Remain calm

Well, that's one of those things, isn't it?
Creating an all new plugin for Revive Adserver to handle a new way of detecting browsers etc. might take someone who knows what they are doing a month or so of effort? Unfortunately, we don't have any corporate sponsors who want to pay myself (or the other core team members who donate their time) to work full time on Revive Adserver, so, either we might chip away at this problem over the course of a year or two and get it done, and then everyone can have it for free, or, someone either needs to sponsor that specific feature on a commercial basis to be built as open source, or, someone has to take a chance, put in the time and build it, but then try to sell it for enough money to cover their costs. We all, unfortunately, need to make a living somehow!
That's why there are commercial plugins for Revive that do cost hundred, or thousands...

Hi @Matt Glover,
As an employee of OpenX at the time the move to the new aggregated stats tables happened in OpenX Source 2.8, I suppose we could more technically say that non-aggregate data collection doesn't scale well using a MySQL-based relational database - and that was the key concern for the business at the time!
While other relational databases may offer scaling through sharding, OpenX at the time wasn't about to consider a move away from MySQL for it's systems, and alternatives like Cassandra, Mongo or Redis weren't considered to be mature enough - so the decision was made to go to aggregated logging.
I agree that now, it would very much be possible to use another engine other than MySQL to allow scalable, high performance logging that includes the ability to report on things like the referer, or geotargeting information, etc.
However, one of the long-standing advantages of Revive Adserver has been that you need very little technical knowledge or access to be able to install it. If MySQL or PostgreSQL is installed, and you have FTP access to a server with PHP, then that's about it. The more we add to Revive Adserver - especially in terms of adding another logging engine - the more we have to maintain. If we were going to make a change like this, I would want to make the new logging engine the default, and drop support for logging to MySQL/PostgreSQL, otherwise maintenance of logging will become a real burden.
But, how many existing Revive Adserver users would this then mean can no longer afford to run the server, because they are on really cheap hosts and can't afford a "proper" host that has root access, and wouldn't be able to manage the server anyway if they did have access?
I'm not saying "no way" - updating the logging engine would be a really fun project! But is it the right direction for the product? Do we keep things simple, and accept that it won't suit everyone - or do we make Revive Adserver more fully featured, and accept that some lower end users will end up being left behind?
Something to think about, and perhaps we'll get a survey out to the community in the near future about what direction the project needs to head in...

It's a bug, an update should be available shortly.

It's a bug, an update will be available shortly!

Hi, 
Banner dimension and zone dimension should be match. Then only banners will be available to link with zones.

What version is your "Invocation Tags Plugin" - see https://matt-sparkeleven.tinytake.com/sf/NTMxMTk3XzI3NzQzMzY
If you go into the settings of this module - is asynch enabled? See: https://matt-sparkeleven.tinytake.com/sf/NTMxMTk4XzI3NzQzMzc
 
 
 

Not very patient, are you? You seem to be missing the point that this is a community project.
See http://www.reviveconsultant.com/articles/can-revive-adserver-do-geotargeting/

Checked paths..... 
All me...   fixed - thanks