CN105634800A - Data storage maintenance method based on SNMP and SQLite - Google Patents

Abstract

A data storage and maintenance method based on SNMP and SQLite. Firstly, SQLite is used to build a device information base, and the SQLite database access interface is written and encapsulated, so that the SNMP network management terminal generates SNMP data packets according to the command of obtaining or setting the managed device, and then in the The SNMP agent data packet gets SNMP commands and SNMP parameters, and finally judges the access authority level according to the SNMP commands and SNMP parameters, modifies or adds device information, until the data storage maintenance is completed. Compared with the prior art, the present invention adds the function of SQLite access on the basis of SNMP proxy service, realizes the flexible storage, modification or maintenance of managed device information, and can make arm-linux platform other application for real-time sharing.

Description

A Data Storage Maintenance Method Based on SNMP and SQLite

technical field

The invention relates to the field of data storage and management, in particular to a data storage and maintenance method based on SNMP and SQLite.

Background technique

With the increasing popularity of network applications and network devices, there are more and more network devices, and many devices are from different manufacturers. The complexity of the network is increasing, so the storage and management query of network information and network device information is also becoming more and more important. becomes more and more important. Most companies have to carry out a large number of network equipment inventory and asset adjustments every year. Taking communication operators as an example, operators not only need to carry out a large number of network equipment inventory every year, but also have hundreds of thousands of new equipment connected to the network, which makes their equipment mobilization management, storage and asset inventory work extremely difficult. And because assets are mobile, the devices or systems that store and manage network information also need to be mobile.

SNMP is a network management protocol formulated by the Internet Engineering Task Force IETF. It is simple and easy to implement. It is a communication protocol that follows the management/agent mode (Manager-Agent). Its network management reference model is shown in Figure 1, including SNMP network management Terminal (SNMPManager), SNMP agent terminal (SNMPAgent), communicate through SNMP protocol. Although the SNMP network management model can reflect the information of the managed devices in real time and accurately, after the SNMP agent obtains the information of the managed devices, it cannot provide an efficient and convenient data storage, management, and query service. Especially insufficient, therefore, other local applications on the agent side cannot conveniently share the data obtained by the SNMP agent, so a technology that can store, query or manage the required data online is needed in a timely, fast, safe and effective manner.

Contents of the invention

The technical problem solved by the present invention is: to overcome the deficiencies in the prior art, and to provide a SNMP-based SNMP system that realizes flexible modification or maintenance of managed device information by adding an SQLite database and an SQLite database access interface for device information at the SNMP agent end. and SQLite's data storage maintenance methods.

Technical solution of the present invention is: a kind of data storage maintenance method based on SNMP and SQLite, comprises the steps:

(1) Obtain the device information of the managed device through the SNMP agent and store it in the SQLite database in turn, and then construct the device information library. The attributes of the device information include the network interface working status, software resources, and hardware of the managed device Resource, access authority level, identifier, description information, wherein, description information includes database name, table name, data row, data row, data buffer head address; described SQLite database is set on SNMP agent end, SNMP agent Both the client and the SQLite database work in the arm-linux environment;

(2) Write the SQLite database access function and encapsulate to obtain the SQLite access interface, then the SQLite access interface is compiled into a dynamic link library by the arm-linux cross tool chain, and the dynamic link library is transplanted to the arm-linux platform; the SQLite access The interface includes reading SQLite access interface and writing SQLite access interface;

(3) monitor the SNMP network management terminal, when the SNMP network management terminal sends to the SNMP agent terminal to obtain or set the managed device instruction, make the SNMP network management terminal generate the SNMP packet and send it according to the obtained or set managed device instruction;

(4) After the SNMP data packet arrives at the arm-linux platform where the SNMP agent is located, analyze the IP protocol and UDP protocol in the SNMP data packet, and strip the link layer, network layer, and transport layer of the SNMP data packet to obtain the SNMP of the application layer protocol package;

(5) make SNMP agent end analyze SNMP protocol bag according to SNMP management protocol, BER decoding rule and obtain SNMP command, SNMP parameter; Described SNMP command comprises replacement, increase; Described SNMP parameter comprises access authority, equipment information that needs to be revised Identifier or modified device information attribute;

(6) If the current SNMP parameter access authority level is lower than the access authority level in the device information, go to step (3) until the data storage maintenance is completed, if the current SNMP parameter access authority level is not lower than the access authority level in the device information , then make the SNMP agent use the read access interface in the dynamic link library to traverse all the device information stored in the SQLite database according to the SNMP parameter identifier, and obtain the data buffer first address of the device information corresponding to the current SNMP parameter;

(7) If the current SNMP command is to replace, then access the current device information according to the first address of the data buffer obtained in step (6), and use the modified device attribute to replace the corresponding attribute in the current device information, if the current SNMP command is to increase, Then access the current device information according to the first address of the data buffer obtained in step (6), and after adding the modified device attribute to the corresponding attribute in the current device information, go to step (3) until the data storage maintenance ends.

The device information is an object type.

The SQLite database access function is written in C language.

The advantage of the present invention compared with prior art is:

(1) The present invention has added the function that SQLite visits on the basis of SNMP proxy service, has realized that the information of the managed equipment that will be obtained is carried out flexible data storage, modification or maintenance, and can make arm-linux platform other by SQLite database applications for real-time sharing;

(2) the present invention can flexibly load, unload the function of SQLite access database by the mode of dynamic link, thereby can flexibly configure the size of SNMP agent end server, be applicable to the limited characteristic of embedded resource;

(3) By introducing the SQLite database in the present invention, the SNMP agent or other application programs can conveniently implement data storage and maintenance of the acquired information.

Description of drawings

Fig. 1 is the schematic diagram of SNMP management end/agent end model among the present invention;

Fig. 2 is a principle flowchart of a data storage maintenance method based on SNMP and SQLite in the present invention.

detailed description

SQLite is a kind of portable lightweight database, provides a kind of compact, convenient, efficient, reliable data storage, management, query service for mobile working platform, therefore, the present invention is aimed at the deficiencies in the prior art, The SNMP protocol and the SQLite database are combined to complete accurate and fast reading, storage, query and management of equipment information and other data. The present invention will be described in detail below in conjunction with the accompanying drawings.

As shown in Figure 2, the inventive method realizes basic SNMP agent service under linux environment, then embeds SQLite database access interface above SNMP agent service, by SNMP protocol, SQLite database access interface, managed equipment information is stored in SQLite database, And can be accessed and modified at any time, the specific implementation steps are as follows

(1) Obtain the device information of the managed device and establish a device information database. The device information database includes the relevant information of the managed device, such as: the working status of the network interface, the software and hardware resources of the managed device, etc., which are used in the device information database. The object type describes the information of the managed device, and the description includes the text name of the managed object, the grammatical attribute of the managed object, the semantic description of the managed object, the access right of the managed object, and the implementation requirements of the managed object, etc.

The operation object managed by SNMP is an instance of device information. The device information library uniquely determines an instance of a managed device object through the object type identifier. The identifier of the managed object instance is in the following form:

Object instance identifier = managed object identifier + variable part

The managed object identifier adopts the private branch under the OID tree uniformly managed by the Internet Address Authorization Committee, and the variable part is performed according to the data type of the described managed device information. For example, an asset has been applied to the 42714 branch under the private branch, and the node name is asset. This device can be used as a gateway and terminal, has read and write permissions, and is an object that must be implemented by the snmp agent. Then the following statement can be used

(2) According to the attribute description information of the managed device in the device information database, write C language code to realize the access to the managed device instance. According to the properties of the managed devices, construct a structure containing the properties of the managed objects for each managed device, and through this structure, make the information of the managed devices into a linked list, and construct a function assetTable_handler The structure is traversed.

(3) The SNMP service adds the SQLite function library access function, uses the C language to write the SQLite database access function, and encapsulates it into an interface function. Compile the written SQLite interface function into a dynamic link library through the arm-linux cross tool chain. When the request object in step (2) is determined, information such as the table name, row, and column of the requested object in SQLite can be obtained. According to these information, the SNMP service provides the SQLite interface function with the database name, table name, row and column of the table where the data is located, and the first address of the buffer where the data content is stored, and opens the SQLite database to access the requested object.

(4) Put the C language code written in step (2) and step (3) into the NET-SNMP software package and use the arm-gcc cross tool chain to compile and link, and transplant the service obtained by compiling and linking to the ARM-LINUX platform, and The dynamic link library generated in step (3) is transplanted to the specified path of the arm-linux platform.

After the SNMP agent starts working, it first initializes the object instance identifier of the managed device so that it can be uniquely locked in SNMP management. Then register the data retrieval function asset_handler() written in step (2) into the SNMP agent service, and obtain the first address of the managed information attribute linked list written in step (2). When the SNMP network management end sends a request to the SNMP agent end, the SNMP request is first transmitted to the embedded linux operating system through the underlying network interface. The Linux operating system parses the IP protocol and UDP protocol in the SNMP data packet, strips the link layer, network layer and transport layer of the data packet from the received data packet, obtains the SNMP protocol packet of the application layer, and converts the SNMP packet Pass it to the SNMP agent of the application layer, and the SNMP agent analyzes the SNMP data packet according to the SNMP management protocol and BER decoding rules to obtain SNMP commands and parameters.

After the SNMP agent receives SNMP commands and parameters, the management process involves data storage, retrieval, manipulation and other aspects. Data retrieval means that the agent uses the registered retrieval function asset_handler() to retrieve which attribute of the managed device the SNMP command requests. The contents of the structure are matched. This function traverses the linked list composed of the managed device structure, and compares the elements in the structure with the received parameters, so as to determine which attribute of the managed device the received command operates on. The agent end is according to the storage location (the table name at the attribute value place, the row and column in the table) of the operated attribute value in SQLite, and the SNMP agent calls the SQLite library function in step (3) to open the SQLite database. The manipulation of data involves the response to the request command, and the request category (read request or write request) sent by the SNMP command to the SNMP agent is obtained by analyzing the SNMP data packet according to the SNMP agent. According to the request category of the SNMP management terminal, the function of reading the SQLite database interface and writing the interface function of the SQLite database are respectively called to complete different operations. The SNMP agent provides location parameters to the called API according to the location of the attribute value in SQLite, and then realizes the access to SQLite on the SNMP agent side.

The SQLite database created by the SNMP agent is shared. That is, other applications on the arm-linux local platform can also access the SQLite database by installing the dynamic link library generated in step (3), thereby reading or updating the device information of the database, so as to share the device information obtained by the SNMP agent the goal of.

In addition, if for some reason the SNMP server no longer needs the function of accessing the database, for the sake of saving embedded platform resources, the dynamic link library generated in step (3) can be removed on the arm-linux platform.

The content that is not described in detail in the description of the present invention belongs to the well-known technology of those skilled in the art.

Claims (3)

1. the data storage system maintenance method based on SNMP and SQLite, it is characterised in that comprise the steps:

(1) obtain the equipment information of managed devices by SNMP agent end and it is stored in SQLite database successively, and then structure obtains equipment information storage, the attribute of described equipment information comprises the network interface working order of managed devices, software resource, hardware resource, access permission level, identifier, descriptor, wherein, descriptor comprises data library name, table name, data are expert at, data column, first address, data buffer; Described SQLite database is arranged on SNMP agent end, under SNMP agent end, SQLite database are all operated in arm-linux environment;

(2) write SQLite database access function and carry out encapsulation and obtain SQLite access interface, then SQLite access interface is compiled into dynamic link storehouse by arm-linux cross tool chain, arm-linux platform is transplanted in dynamic link storehouse; Described SQLite access interface comprises reading SQLite access interface, writes SQLite access interface;

(3) monitor SNMP network management terminal, when SNMP network management terminal obtains to the transmission of SNMP agent end or arranges managed devices instruction, make SNMP network management terminal that according to acquisition or managed devices instruction generation SNMP data packet send is set;

(4) after SNMP data packet arrives SNMP agent end place arm-linux platform, resolve the IP agreement in SNMP data packet, udp protocol, the link layer of SNMP data packet, network layer, transport layer are peeled off the snmp protocol bag of the layer that is applied;

(5) SNMP agent end is made to decode rule parsing snmp protocol bag obtain SNMP order, SNMP parameter according to snmp management agreement, BER; Described SNMP order comprises replacement, increases; Described SNMP parameter comprises access rights, the equipment information indicating of needs amendment accords with or equipment information attribute after amendment;

(6) if current SNMP parameter access authority grade is lower than the access permission level in equipment information, then forward step (3) to until data storage system maintenance terminates, if the access permission level that current SNMP parameter access authority grade is not less than in equipment information, then make SNMP agent end use all devices information stored in the traversal SQLite database of the reading access interface in dynamic link storehouse according to SNMP parameter indexing symbol, obtain the first address, data buffer of equipment information corresponding to current SNMP parameter;

(7) if current SNMP order is for replacing, current equipment information is accessed in the first address, data buffer then obtained according to step (6), and the device attribute using amendment replaces the corresponding attribute in current equipment information, if current SNMP order is for increasing, current equipment information is accessed in the first address, data buffer then obtained according to step (6), and after the corresponding attribute being increased in current equipment information by the device attribute of amendment, forward step (3) to until data storage system maintenance terminates.

2. a kind of data storage system maintenance method based on SNMP and SQLite according to claim 1, it is characterised in that: described equipment information is object type.

3. a kind of data storage system maintenance method based on SNMP and SQLite according to claim 1 and 2, it is characterised in that: described SQLite database access function is write for using C language.