Jump to content

andrewatfornax

Approved members
  • Posts

    2007
  • Joined

  • Last visited

Posts posted by andrewatfornax

  1. Understood, but if you have a lot of data, then yes, 6 months will take a long time to process and export.

    You may be better off querying the database separately if you have specific reporting requirements - or, write up a ticket in GitHub clearly explaining the use case and details of how it should work, and it might be something to consider for future releases.

  2. What? No, you don't need to put information into banners delivered with Revive Adserver to say that they include GeoIP2.

    That's the kind of thing that needs to go into Revive Adserver's documentation, when we support GeoIP2 (which we currently don't, but are working on). Just because someone delivers ads through Revive Adserver does not mean you have to call out an attribution for GeoIP.

     

  3. The ID is just a unique identifier for each item (i.e. the Advertiser ID, the Campaign ID, the Banner ID...) Everything in Revive Adserver gets a unique ID.

    Most statistics pages should have an option to download the stats in CSV or Excel format, from memory.

  4. Hi @Avindale,

    No, unfortunately, there isn't - it's so hard to recommend a specific level of hardware, because the possibilities for configuration are huge (O/S, webserver, database, opcode cache, all manner of Revive Adserver configuration options), and what people want to do with Revive vary as well (something to manage ads for their hobby site all the way up to commercial operations serving billions of impressions a month... maybe even a week or per day).

    My recommendation would be that if you're starting out, and you're not sure of hardware scale - don't buy any hardware! Get a VM from provider that will let you scale up (or down) as per your requirements - you can always migrate to dedicated physical hardware later on, if that's your desire, once you have an idea from using a cloud-VM first.

  5. Hi Ryan,

    I haven't actually run your query, so, just to clarify - is the issue that your query isn't returning the data you want (and you need help getting the right info), or is the issue that it takes a while to return (and you need help making it faster)?

    Thanks!

  6. There's no documentation that we have to help with this, sorry - this is essentially a systems management issue.

    1. Trace down what the internal server error is when you change the memory limit. That's something to do with PHP or the web server - not Revive Adserver. See the appropriate documentation for those products.

    2. The database error is pretty clear - Revive Adserver can't connect to your database. Check to make sure that it's possible to connect to the database from where Revive Adserver is hosted, and confirm the username and password. Then make sure all of those (hostname, ports, username, password, database name) are set correctly in Revive Adserver's configuration file.

  7. Before you convert, the most important thing to do would be to:

    • Backup the database.
    • Test the backup can be used to restore the database.
    • Test the conversion process on the restored database.
    • Test Revive Adserver on the converted test database.
    • Document everything so you can do it quickly when you need to.
    • Plan for how to revert if it all goes wrong.

    But you know all that already!

     

×
×
  • Create New...