Write some Software for receiving data from socket and storing in a mysql database
$250-750 USD
ปิดแล้ว
โพสต์ มากกว่า 8 ปีที่ผ่านมา
$250-750 USD
ชำระเงินเมื่อส่งงาน
we require two applications that will run as demons on a unbutu x64 boxs
the front end is https://www.freelancer.com/projects/Electronics/Design-arduino-other-Micro-board-9208111
first program will need to lisen on a telnet session to SERVER:portNUM as described in Config File and receive data string that looks like 7879021725ff0389a0ffffffff01009787 in HEX and is made up of
All communication starts with data header “7879” and ends with trailer “9787” and is 10+N Bytes
Format Length(Byte)
Start Bit 2
Packet Length 1
Protocol Number 1
Information Content N
Serial Number 2
Error Check 2
Stop Bit 2
then write data into a mysql database and provide a response code and/or take a action like Possible responses
OK {Do Nothing}
RSSH or Rtelnet
BATT {upload to server BATT Level/Votage}
RELOAD {try to ping TFTP Server then download new config file via tftp or FTP then reboot with new file}
ERROR {Resend Last Message}
REBOOT {Reboot Device and restart}
ALARM {trigger alarm with BUZZ1 and LED1 to Red and LIGHT1 on}
ALARMSTOP {turn off alarm with BUZZ1 and LED1 to Red and LIGHT1 on}
LIGHT { Turn LIGHT1 on}
AUDIOON {turn on Mic and Place outgoing call to CALL_NUM in Config File}
AUDIOOFF {turn off Mic and Drop outgoing call to CALL_NUM in Config File}
PING [VAR} {Ping the var that comes after Ping response}
TEST {pulse LED1,LED2 red blue green and buzz1 and light1 at 1 sec on off intervals for 10 sec and send test data to server with MAC,WIFIMAC, STATUS OF ETH,WIFI,GSM,,CONF_VER, BATT , and anything else important }
INFO {send test data to server with STATUS OF ETH,WIFI,GSM,,CONF_VER, BATT last reboot }
second program will/may run on another server and will read the mysql database and write into the central database then flag the record with time and date uploaded into two fields
a detailed spec is available
time frame now