Announcement

Collapse
No announcement yet.

ZeroTier Networking

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #76
    Curious, Which version of Java are you running? Maybe check your BIOS clock setting?? I'm headed to bed, but will check my times tomorrow. It looks like it is writing local time into the database maybe??

    Comment


    • #77
      Locals time is correct on pc but for some reason stamps are 24hrs out from local. So decoded thinks it's yesterdays date (incorrect local 7am/12hrs off)


      You've made me second guess now - 8.251

      But I couldn't recall if I expanded the whole dir or just the .jar so just over-wrote it now incase. Same same

      Even stranger from targethistory. With a from_unixtime(utcfadeout/1000) beside (Think that does local adjust). Which seems to as it also throws it 12hrs off current.. So right day, wrong time
      C82764 1598988395263 1598988435309 2020-09-02 07:27:15.3090 1325 ZKLJT
      I'd expect GMT to report 0700 on 2-9..

      1598988395263 - GMT: Tuesday, 1 September 2020 7:26:35.263 PM

      Might be because I'm on a +12 zone. I'll see what effect force setting the SQL server to different ones does.
      Posts not to be taken as official support representation - Just a helpful uploader who tinkers

      Comment


      • #78
        That may explain it. Cause local is out by -12 (auto deduction of TZ) so total -24 once UTC grabs hold

        Mysql may have gotten smart and realised depending on the code used to convert it to and auto adjusting again from what you give it
        Posts not to be taken as official support representation - Just a helpful uploader who tinkers

        Comment


        • #79
          Did I not mention this was Mysql not sqlite

          Bed first. Head scratching later! be like me and save late ones for weekends
          Posts not to be taken as official support representation - Just a helpful uploader who tinkers

          Comment


          • #80
            BiNGO
            1599037181772

            GMT: Wednesday, 2 September 2020 8:59:41.772 AM
            Your time zone: Wednesday, 2 September 2020 8:59:41.772 PM GMT+12:00 <- HUZZAH a match

            Now to clean up all the ones in the middle and import the last weeks of sqlite
            Posts not to be taken as official support representation - Just a helpful uploader who tinkers

            Comment


            • #81
              Probably broken something not bothering to update the metrics, Callsign and ModeStable down the track. (there's been a few insert errors already) but got the 8yrs + new stuff massaged in together. I doubt a proper playback would work

              Happy chap.


              If I wanted to try harder I would have re-ordered all the auto increment records. But possibly break other stuff.

              For some reason the Air2Air seems to get very little action. (might be my decode method) and altutude trend was a bit slow to update the target table I was pulling. So went back to a +/- 0 number rate method
              Posts not to be taken as official support representation - Just a helpful uploader who tinkers

              Comment


              • #82
                Trying to recover this thread with those who were active:

                I don't think the ADSB to SQL GitHub is alive anymore... and I'd like to resurrect something like this, a SQL DB cathering the JSON data for a 5 mile radius around me. If anyone still has the old code or can point fingers to a workable modern solution to suck this into a SQL DB I'd be appreciative for the pointers.

                Thanks!
                Brendan

                Comment

                Working...
                X