linux app to accept data from DSC SurGard II, then insert into MySQL table

In Progress

We will be using a DSC SurGard Central Station Receiver to accept transmitted signals from burglar and fire alarm panels. That system has a specific output format (see attached spec sheet). We need an app developed that will:

Easily install and run on CentOS 5

Listen on the TCP/IP port used by the SurGard receiver and accept properly formatted transmissions

Insert the data into a MySQL database specified by DNS name

On SQL Insertion error, insert the data into an identical table on a redundant MySQL server with a different DNS name

On successful SQL insertion, respond with a ACK back to the SurGard receiver

APPLICATION MUST NOT return ACK if the data is not successfully inserted into the primary or secondary SQL table

You will specify the fields needed based upon the attached SurGard spec sheet, and we will create them on our SQL servers (2).

Skills: Linux, MySQL

See more: surgard linux, linux surgard, primary data, need app developed, install an app, fire name, fire alarm system, centos dns server, ack, app port, tcp server centos, centos tcp, linux mysql create, linux tcp application, database error linux server, mysql inserted, centos server tcp, centos tcp server, linux app run, app dns, mysql create table fields, insert mysql table, dns name server, mysql output table, sheet app

About the Employer:
( 12 reviews ) Lakewood Ranch, United States

Project ID: #4014330

Awarded to:

Rujanist

Hello, I have experience in writing such kind of programs. Will write small clean app that will do what's needed.

$500 USD in 21 days
(0 Reviews)
0.0

7 freelancers are bidding on average $637 for this job

linuxfreak1985

Hi there, i am very interested to complete this project. please see my past reviews related to system administration lets complete this project

$700 USD in 2 days
(176 Reviews)
6.9
srinichal

I am an expert in customised scripts and can deliver the same after discussion

$620 USD in 12 days
(26 Reviews)
5.8
bistanil98

ready to start the project. I want to introduce our self, we are a group of freelancers have experience in web application development and design for different domain, please go through the attach portfolio for More

$890 USD in 24 days
(7 Reviews)
4.9
steven6

Hello, we are a group of programmers based in Sheffield, UK offering 7 years experience in php, .net, c#, jquery, css, python and c++. I am proposing to carry out tasks required for this project and deliver it within 4 More

$999 USD in 2 days
(16 Reviews)
5.0
zkutch

Hello. More 20 years programming experience. See pmb, please.

$250 USD in 0 days
(1 Review)
1.4
L91b5LUSq

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. <b><i>Removed by Admin</i></b>

$500 USD in 1 day
(0 Reviews)
0.0