Jump to content

andrewatfornax

Approved members
  • Posts

    2007
  • Joined

  • Last visited

Posts posted by andrewatfornax

  1. Hard to be sure, but looks like there were some permissions issues and possible database access issues as part of the initial installation.

    Also, I'm not sure if the use of checking the code into git, and then checking it out on the server you're installing it on might have affected things?

    Anyway, take a look at https://documentation.revive-adserver.com/display/DOCS/Directory+Permissions for the list of directories (and all files/directories underneath these) that must be able to be written to by the web server.

    Also, please make sure that your database connection has full access to the Revive Adserver database. 

     

  2. On 8/22/2018 at 10:45 PM, Display Name said:

    I say it before...

    Actually, I don't think you did say it before - this is the first time that I remember you saying specifically what you have done in terms of setup.

    So - now that I know that you installed Revive Adserver using the IP address of 127.0.0.1, and you're trying to access it using a different IP address - then finally, your "problem" makes sense. This is intentional behaviour.

    Please see: https://documentation.revive-adserver.com/display/DOCS/Managing+Configuration+Files

  3. It's been a while since I used MyISAM, but I suspect the issue is not slow queries - once the queries get access to the table, they should run quickly enough. The issue will be that while any once process is writing to a table, all other access to the table will be locked at that time.

    That could be why you get threads timing out - they just don't get a chance to access the table for their query, as others have the table locked the whole time, and eventually, the thread is timed out.

    MyISAM might have a reporting option on locking or queuing that may be more relevant than slow queries - take a look there perhaps before committing to InnoDB?

    I would definitely stop your web server and halt all database activity during the backup and migration process!

×
×
  • Create New...