Skip to content
  • MySensors
  • OpenHardware.io
  • Categories
  • Recent
  • Tags
  • Popular
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo
  1. Home
  2. Development
  3. SSMSG - Single file SQL MySensors Gateway

SSMSG - Single file SQL MySensors Gateway

Scheduled Pinned Locked Moved Development
8 Posts 4 Posters 3.0k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • DammeD Offline
    DammeD Offline
    Damme
    Code Contributor
    wrote on last edited by Damme
    #1

    This is what I've been working on, Exact purpose is still unknown, Probobly full of bugs and lacks functionallity.

    https://github.com/Damme/SSMSG

    start with no parameters and it will be running in background.

    • Requires version 1.4b
    YveauxY 1 Reply Last reply
    1
    • DammeD Damme

      This is what I've been working on, Exact purpose is still unknown, Probobly full of bugs and lacks functionallity.

      https://github.com/Damme/SSMSG

      start with no parameters and it will be running in background.

      • Requires version 1.4b
      YveauxY Offline
      YveauxY Offline
      Yveaux
      Mod
      wrote on last edited by
      #2

      @Damme said:

      Exact purpose is still unknown

      So leave it to us to figure out ;-)

      I think you want to create some middleware to send to/receive from sensor nodes without using Vera, right?

      http://yveaux.blogspot.nl

      DammeD 1 Reply Last reply
      0
      • YveauxY Yveaux

        @Damme said:

        Exact purpose is still unknown

        So leave it to us to figure out ;-)

        I think you want to create some middleware to send to/receive from sensor nodes without using Vera, right?

        DammeD Offline
        DammeD Offline
        Damme
        Code Contributor
        wrote on last edited by
        #3

        @Yveaux :) correct, I use a small php page for controlling some lights and stuff and a cron script that reads light value and calculate if it should turn on / off lights.
        the small scripts dont need any access to the usb device, only a DB connection.

        YveauxY ch3b7C 2 Replies Last reply
        0
        • DammeD Damme

          @Yveaux :) correct, I use a small php page for controlling some lights and stuff and a cron script that reads light value and calculate if it should turn on / off lights.
          the small scripts dont need any access to the usb device, only a DB connection.

          YveauxY Offline
          YveauxY Offline
          Yveaux
          Mod
          wrote on last edited by
          #4

          @Damme You might be interested in my post at http://forum.mysensors.org/topic/175/open-source-home-automation-software/19
          I experimented with MySensors and MQTT, a publish/subscribe messaging system.
          It also acts as a database, but you don't have to actively request sensor data as you can subscribe to them from e.g. the sensor nodes or a logging task. Once subscribed you simply get the data pushed when an update arrives!

          http://yveaux.blogspot.nl

          1 Reply Last reply
          0
          • hekH Offline
            hekH Offline
            hek
            Admin
            wrote on last edited by
            #5

            @Damme said:

            https://github.com/Damme/SSMSG

            Nice. Looking forward to see where it leads!

            1 Reply Last reply
            0
            • DammeD Damme

              @Yveaux :) correct, I use a small php page for controlling some lights and stuff and a cron script that reads light value and calculate if it should turn on / off lights.
              the small scripts dont need any access to the usb device, only a DB connection.

              ch3b7C Offline
              ch3b7C Offline
              ch3b7
              wrote on last edited by
              #6

              @Damme How the gateway recieve data and send to other sensor ? like "255;255;3;0;4;2\n" because if i send directly from arduino program work, but with other program connected to serial port not work.

              DammeD 1 Reply Last reply
              0
              • ch3b7C ch3b7

                @Damme How the gateway recieve data and send to other sensor ? like "255;255;3;0;4;2\n" because if i send directly from arduino program work, but with other program connected to serial port not work.

                DammeD Offline
                DammeD Offline
                Damme
                Code Contributor
                wrote on last edited by
                #7

                @ch3b7 Uhm, Might misunderstood you. You'll have to configure the serial port correctly and then send \n , if using echo you need to use echo -e -n "1;1;1;1;1;1\n"

                1 Reply Last reply
                0
                • ch3b7C Offline
                  ch3b7C Offline
                  ch3b7
                  wrote on last edited by
                  #8

                  @Damme said:

                  1;1;1;1;1;1\n

                  sorry im from argentina and my english is very bad xD the problem is... i can send "255;255;3;0;4;2\n" from vb.net programm to arduino gateway in COM port and then the gateway send the same command to the sensor to change de ID

                  vb.net --> arduino gw ---> sensor

                  but i think the gw dont read the incoming data

                  at now im use your script and work fine

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  14

                  Online

                  11.7k

                  Users

                  11.2k

                  Topics

                  113.1k

                  Posts


                  Copyright 2025 TBD   |   Forum Guidelines   |   Privacy Policy   |   Terms of Service
                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • MySensors
                  • OpenHardware.io
                  • Categories
                  • Recent
                  • Tags
                  • Popular