Write a service for Linux Debian server (preferably in Perl) that gets SNMP data
- or -
Post a project like this3122
£55(approx. $68)
- Posted:
- Proposals: 4
- Remote
- #888011
- Awarded
Description
Experience Level: Intermediate
General information for the business: We sell equipment for the disabled
Description of requirements/functionality: We have a phone system on the network with an IP address of 192.168.5.10. At the end of every call it sends out SNMP data in SMDR text format like this:
02/09/15 03:08PM 322 05 Main Number 7999600 0'00 00:00'36
02/09/15 03:08PM 307 05 Main Number 7999600 0'00 00:00'52 TR
02/09/15 03:10PM 311 25 311Tristan 203 0'46 00:00'00 NA
02/09/15 03:11PM 308 08 07967397373 00:04'03
02/09/15 03:12PM 306 02 01322520560 00:02'49
02/09/15 03:13PM 500 07 Main Number 7999600 0'01 00:00'00
02/09/15 03:13PM 322 07 Main Number 7999600 0'00 00:00'16
02/09/15 03:13PM 500 02 Main Number 7999600 0'01 00:00'00
02/09/15 03:14PM 322 02 Main Number 7999600 0'00 00:00'21
02/09/15 03:15PM 305 01 Main Number 7999600 0'00 00:09'35 TR
02/09/15 03:16PM 319 02 Main Number 7999600 0'00 00:02'04 TR
Column headings are: Date, Time, Extension, CO, Dial Number, Ring, Duration, Acc Code, CD
I need a script that runs on the server that watches for this data, splits it up into columns, and puts it into a table with the same heading names in a MySQL database.
A new MySQL database will also need to be created on the server please. Perl modules are already fully installed and MySQL is already running.
Specific technologies required: Perl
OS requirements: Linux
Extra notes:
Description of requirements/functionality: We have a phone system on the network with an IP address of 192.168.5.10. At the end of every call it sends out SNMP data in SMDR text format like this:
02/09/15 03:08PM 322 05 Main Number 7999600 0'00 00:00'36
02/09/15 03:08PM 307 05 Main Number 7999600 0'00 00:00'52 TR
02/09/15 03:10PM 311 25 311Tristan 203 0'46 00:00'00 NA
02/09/15 03:11PM 308 08 07967397373 00:04'03
02/09/15 03:12PM 306 02 01322520560 00:02'49
02/09/15 03:13PM 500 07 Main Number 7999600 0'01 00:00'00
02/09/15 03:13PM 322 07 Main Number 7999600 0'00 00:00'16
02/09/15 03:13PM 500 02 Main Number 7999600 0'01 00:00'00
02/09/15 03:14PM 322 02 Main Number 7999600 0'00 00:00'21
02/09/15 03:15PM 305 01 Main Number 7999600 0'00 00:09'35 TR
02/09/15 03:16PM 319 02 Main Number 7999600 0'00 00:02'04 TR
Column headings are: Date, Time, Extension, CO, Dial Number, Ring, Duration, Acc Code, CD
I need a script that runs on the server that watches for this data, splits it up into columns, and puts it into a table with the same heading names in a MySQL database.
A new MySQL database will also need to be created on the server please. Perl modules are already fully installed and MySQL is already running.
Specific technologies required: Perl
OS requirements: Linux
Extra notes:
Tristan H.
100% (39)Projects Completed
45
Freelancers worked with
38
Projects awarded
38%
Last project
21 Feb 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies