Jump to content


  • Content Count

  • Joined

  • Last visited

Reputation Activity

  1. Upvote
    andrewatfornax got a reaction from dwell in Invocation Code Selection Not Loading   
  2. Upvote
    andrewatfornax reacted to Ravi Patel in Installation failed to create the core tables   
    Hey Guys,
    Very late here to answer this,
    I also got into this same error, And Here are my findings for this error :
    I was selecting "MyIsam" in Table type Instead of InnoDB.
    Check the below screenshots : 
    First Click : "See More Database Details"

    Then Select "InnoDB" from Table Type.

    And Done 😄
  3. Upvote
    andrewatfornax reacted to AngryWarrior in Serve only to a language country? [Not working/bug??]   
    i think I actually managed to solve this issue. :-)
    I deactivated and then deleted the Geo targeting plugin. Downloaded a fresh installation package of Revive Unzipped the package locally on my pc. I then uploading the geo targeting plugin zip file from the folder  etc/plugins/reviveMaxMindGeoIP2.zip
    Then as administrator head to plugins in the administrator dashboard  e.g. https://yourdomain.com//www/admin/plugin-index.php?selection=plugins and upload the zip package and enable it. (it should happen automatically):
    Then in that interface "plugins" chose the geo targeting plugin and click "Details" --> Settings --> License key. Go to Maxmind and generate a new license key https://www.maxmind.com/en/account/login 

    and then enter that new license key in the license field and hit "save". 
    Ok so next thing we need to do is to force Revive to initiate the download of the Maxmind database. So what yu need to do is to go back to the admin interface as admin and go to "plugins" e.g. https://yourdomain.com/www/admin/plugin-index.php.

    The way this is done is simple by clicking "disable" then wait a minute and then re-enable the plugin again by clicking "Activate". This will force Revive to start downloading the database from Maxmind.
    After the former step is done, then go to your Maxmind account and see if Revive has used your new key (confirms that it is working), result:

    As you can see in my case Revive has now done a data query for the Maxmind database and used the license key. :-) 
      Ok so the final step is to see that it is finally working and that Geo targeting is working and added to your drop down list in banner settings click your Banner --> Deliver options --> Add deliver rule dropdown. Final Result:

    So the whole problem I guess lies in the Revive never have downloaded the Maxmind database and thus it will therefor e not display the Geo targeting options in the Banner setting delivery options drop down for that reason. The solution is to follow the steps I provided above.  I hope this might help others that may encounter the same issue as I have and be a helpful solution. :-)

    Cheers everyone. 
    Kind regards
  4. Upvote
    andrewatfornax reacted to victortoo in Changing Menu Names.   
    Thanks solved my issue.
    The language pack files are found in
    lib/max/language  folder in case anyone has an issue finding them.
  5. Upvote
    andrewatfornax reacted to lunaraurora in 5.0.5 upgrade but can not change database password   
    thanks, that's useful .. i will look into it
  6. Upvote
    andrewatfornax reacted to Ryan G in Statistics Will Not Show No Matter What, Help Sought   
    Thanks for this documentation @andrewatfornax - I was able to address this issue on my end. Was related to my plugins issue: https://forum.revive-adserver.com/topic/5683-upgrade-error-unable-to-locate-one-or-more-plugin-files/?tab=comments#comment-14335
  7. Upvote
    andrewatfornax got a reaction from Ryan G in Statistics Will Not Show No Matter What, Help Sought   
    In addition to the above, @Turbo212, I notice that your oxcd_data_bkt_m table is MyISAM. 
    This table type only supports table level locking.
    If you're under high load, it's possible that the table will be locked by delivery processes queued up to write their data when the hourly maintenance process wants to lock the table to make updates. Are you sure that's not happening? Your MySQL logs might give you more information on this.
  8. Upvote
    andrewatfornax got a reaction from Ryan G in Upgrade Error: Unable to locate one or more plugin files   
    Just to round out the thread and confirm, when you upgrade, the upgrade wizard will ask you where the old installation is located, so that it can find the previous installation's plugin files, and copy them over (so that any 3rd party plugins are retained) and upgrade them (if they are core Revive Adserver plugins and need to be updated).
  9. Upvote
    andrewatfornax reacted to bobdobs in HTML5 banner: Impression count too low v5.0.5   
    I figured it out myself 😀 The HTML5 banner relies on javascript to create an image that calls /www/delivery/lg.php. Now that js wasn't executing because it was in my Vue template, so I had to create a workaround. The stats collected in rv_data_bkt_m now match requests to /www/delivery/lg.php perfectly. 
  10. Upvote
    andrewatfornax reacted to Ian vM in Can't log in   
    try a password reset
  11. Like
    andrewatfornax got a reaction from Marc in Dashboard Broken   
  12. Upvote
    andrewatfornax reacted to adus in Extra redundancy   
    Thanks for the speedy reply!
    Yeah we make heavy use of AWS and RDS so sadly cant put the code on the DB server but I always meant to double check for scaling purposes if the task could lock as most of the php nodes would just be exact mirrors.
    I may spin a low end box up to handle the tasks but if I at least know it works as a mirrored then I can get under way with scaling anyway.
  13. Upvote
    andrewatfornax reacted to raulfg in ERROR IN GLOBAL STATS (Revive 5.0.5)   
    Forget this!
    Sorry ! The problem the check of production site is disabled! when i enable the check the warning dissapear! 
    The warnings appears on php 7.2 & 7.3 (I dont know what happen in inferior versions... )
  14. Like
    andrewatfornax got a reaction from adus in Extra redundancy   
    The maintenance process does have locking in place, to ensure that only once instance is triggered at a time, but personally, whenever I was managing a setup like that, I would put the Revive Adserver code on the central DB server too (even though it would not serve ads from there), and then run maintenance on that machine, so that there's no need for network traffic off-server to run maintenance.
    Every millisecond counts, right? 🙂
  15. Upvote
    andrewatfornax reacted to JLW in An error occurred while accessing the database   
    Resolved.... thank you for your comments.
  16. Upvote
    andrewatfornax reacted to scott001 in Issue with Upgrade to 5.0   
    Ok, it might take me a week or so, but I'll get it together...
  17. Upvote
    andrewatfornax reacted to Artistan in Insecure Cookies Warnings - Non-SSL Cookies   
    Our load balancer forwards requests to the web servers via port 80 (insecure on the local network)
    due to that, the web server + Revive does not automatically know that is should be serving secure links and cookies.
    In order to resolve this we had to add a forwarded header to the load balancer that tells the server + Revive code that the connection is secure from the users browser.
    search for `function setupConfigVariables` in the code to see what i am talking about, there are many different server settings to allow `$GLOBALS['_MAX']['SSL_REQUEST'] = true;`
  18. Upvote
    andrewatfornax reacted to tbobker in Using Google Adsense With Revive Adserver   
    Hi James,  you can setup a banner and connect the banner to any number of zones from multiple publishers. Is that what you wanted?
  19. Upvote
    andrewatfornax reacted to Artistan in Insecure Cookies   
    looks like this may be fixed in 
    Revive Adserver 5.0.4
  20. Like
    andrewatfornax got a reaction from Sudhir in 403 Error on Adding a new banner   
    HTTP 403 is a permission error. Check you webserver logs.
  21. Upvote
    andrewatfornax reacted to mitchems in Administrator Login loop on upgrade   
    I figured it out. I was installing the upgrade on a new AWS instance so that I wouldn't interrupt the old one. I found that it was still requiring HTTPS but I didn't have a cert on that server. By going into the host.domain,conf.php and changing requireSSL=1 to =0, that fixed my issue.
  22. Upvote
    andrewatfornax reacted to stapel_eliz in error messages since update to v4.2.1   
    The problem turned out to be that my server host hadn't actually updated PHP from version 5-point-somthing, despite my request that they do so (and assurances that they had). When Revive did the update (via cPanel's Softaculous), it asked if it could update the version of PHP but, though I'd said "yes", the update didn't apparently go through.
    The solution was to do the update myself.
    Thank you!
  23. Like
    andrewatfornax got a reaction from levarberry in Does Revive provide an api interface   
    Yes, there is - there's an XML-RPC API for this. 
    Unfortunately, documentation for this is still on my todo list... But the API is there!
  24. Upvote
    andrewatfornax reacted to AgentPublishing in Redirected After Banner Upload   
    It does look like resetting cookies has helped! Thanks!
  25. Upvote
    andrewatfornax got a reaction from Keval SMS in Upload banners on Amazon S3 Bucket   
    There is no native support for this, no.
    However, depending on your system, you may be able to mount the S3 Bucket as a filesystem, and point Revive Adserver to that mount point for image storage.
  • Create New...