Announcement

Collapse
No announcement yet.

Any plans to support .HSD files?

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

    Any plans to support .HSD files?

    Bob, do you have any plans for the log monitor to support .HSD files?

    #2
    The HomeSeer log HSD file seems to be encrypted. It is not normal text
    Cheers,
    Bob
    Web site | Help Desk | Feature Requests | Message Board

    Comment


      #3
      Yeah, I am wondering if they provide an API or function to read / decrypt these files. I am guessing it's a proprietary database format.

      HSD = HomeSeer Database???

      Comment


        #4
        Yea it is likely their own format
        Cheers,
        Bob
        Web site | Help Desk | Feature Requests | Message Board

        Comment


          #5
          no, it's a standard sqlite database, you can see what's in there by downloading sqlite3.exe from http://www.sqlite.org/download.html

          then from command line:

          Code:
          sqlite3.exe HomeSeerLog.hsd
          select * from Log;

          Comment


            #6
            Thanks Spud.

            I am going to attempt to write a small plugin that monitors the HSD log file for changes, and then outputs the changed log entries to a text file.

            BLLogMonitor can then be used to monitor this text based log.

            I'd prefer a 'tick box' in the HS3 log options to output the log to a text file as well as the sql based file, but I am not sure that will happen.

            I understand the move to sql - the new log filtering options are great but I'd still like a standard text based log as well.

            Comment


              #7
              This appears to be working ok.

              Nothing fancy. It monitors the HSD file for changes, and if there are, it uses the hs.logGet() function to see what's new in the buffer and write this out to the TXT file.

              BLLogMonitor is working with the TXT file.

              Bob, it would be great if this functionality could be included in your plugin.
              Attached Files

              Comment


                #8
                Chrisgo
                Thanks for the plugin. Simple but effective. I was able to get its textfile loaded into Splunk. A little config work to do in splunk for meaningful analytics, but this PI made it possible.
                Paul

                Comment


                  #9
                  Originally posted by chrisgo View Post
                  This appears to be working ok.

                  Nothing fancy. It monitors the HSD file for changes, and if there are, it uses the hs.logGet() function to see what's new in the buffer and write this out to the TXT file.

                  BLLogMonitor is working with the TXT file.

                  Bob, it would be great if this functionality could be included in your plugin.
                  Thank you this works perfectly...
                  Regards,

                  Rien du Pre
                  The Netherlands
                  Using:
                  Homeseer PRO latest HS4 BETA on a Raspberry
                  Plugin's:
                  RFXCOM, mcsMQTT, Z-Wave

                  Comment


                    #10
                    Originally posted by spud View Post
                    no, it's a standard sqlite database, you can see what's in there by downloading sqlite3.exe from http://www.sqlite.org/download.html

                    then from command line:

                    Code:
                    sqlite3.exe HomeSeerLog.hsd
                    select * from Log;

                    I don`t think this is the case for HS3 ?

                    Code:
                    sqlite HomeSeerLogCopy.hsd 
                    Unable to open database "HomeSeerLogCopy.hsd": file is encrypted or is not a database
                    Nevermind it is working

                    Code:
                     sqlite3 HomeSeerLogCopy.hsd 
                    SQLite version 3.8.2 2013-12-06 14:53:30
                    Enter ".help" for instructions
                    Enter SQL statements terminated with a ";"
                    sqlite>

                    And after this i figured out my logging did not go back far enough. So i installed log2syslog made by Crisgo
                    Last edited by raymonvdm; June 2, 2016, 03:30 AM.

                    Comment

                    Working...
                    X