Tripwire stops following

Issue #301 resolved
Former user created an issue

It shows correctly my Login-Status, but no ship or Location Status. runs perfectly since yesterday, but now, without chancing any Settings, sync does no longer work.

Comments (4)

  1. tashinski

    Make sure to activate SQL event_scheduling (--event_scheduler=ON) and be sure the definer events below from tripwire.sql are configured as 'root@localhost'

    CREATE DEFINER=`root`@`10.132.116.78` EVENT `jumpsClean` ON SCHEDULE EVERY 1 HOUR STARTS '2017-01-27 04:24:28' ON COMPLETION NOT PRESERVE ENABLE DO DELETE FROM `jumps` WHERE wormholeID NOT IN (SELECT id FROM signatures WHERE life IS NOT NULL AND type <> 'GATE')$$
    
    CREATE DEFINER=`root`@`10.132.116.78` EVENT `trackingClean` ON SCHEDULE EVERY 15 SECOND STARTS '2017-01-30 17:34:38' ON COMPLETION NOT PRESERVE ENABLE DO DELETE FROM tracking WHERE userID NOT IN (SELECT userID FROM active)$$
    
  2. maurice leblanc

    when i get this, i logout and relog and usually things are ok. i think the auth token is not valid anymore (server reboot or?)

  3. Ashy

    Thanks Tashinski.

    For people using public Tripwire please do as Maurice says or give it some time (CCP issues usually)

  4. Log in to comment