CN109005087A - The method that one key tests the Method of Database Secure Audit product packet loss of cross-server installation - Google Patents

The method that one key tests the Method of Database Secure Audit product packet loss of cross-server installation Download PDF

Info

Publication number
CN109005087A
CN109005087A CN201810999342.7A CN201810999342A CN109005087A CN 109005087 A CN109005087 A CN 109005087A CN 201810999342 A CN201810999342 A CN 201810999342A CN 109005087 A CN109005087 A CN 109005087A
Authority
CN
China
Prior art keywords
server
test
secure audit
database
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201810999342.7A
Other languages
Chinese (zh)
Other versions
CN109005087B (en
Inventor
黄琴
张丽萍
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujian Star Software Co Ltd
Original Assignee
Fujian Star Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Fujian Star Software Co Ltd filed Critical Fujian Star Software Co Ltd
Priority to CN201810999342.7A priority Critical patent/CN109005087B/en
Publication of CN109005087A publication Critical patent/CN109005087A/en
Application granted granted Critical
Publication of CN109005087B publication Critical patent/CN109005087B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L43/00Arrangements for monitoring or testing data switching networks
    • H04L43/50Testing arrangements
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L43/00Arrangements for monitoring or testing data switching networks
    • H04L43/08Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters
    • H04L43/0823Errors, e.g. transmission errors
    • H04L43/0829Packet loss

Abstract

The present invention provides a kind of method of the Method of Database Secure Audit product packet loss of key test cross-server installation, including using the test environment of one key of key initializtion script initialization second server, and sent the test script of playback of data package in first server by second server;Second server remote boot server is sent to the test script of the playback of data package in first server, sends packet data to the end Client of Method of Database Secure Audit product with the Agent end of simulated database security audit product;The packet drop of network interface card and the packet drop at the end Method of Database Secure Audit products C lient are monitored on second server, and save test result data;Test result data is fabricated to curve graph, and is showed.The invention has the advantages that the time cost of artificial default test environment can be significantly reduced, the treatment effeciency to test result data can be improved and avoid the error that may cause when artificially analyzing test result data.

Description

The method that one key tests the Method of Database Secure Audit product packet loss of cross-server installation
Technical field
The present invention relates to field of communication technology, in particular to a kind of database security of key test cross-server installation is examined The method for counting product packet loss.
Background technique
Database security auditing system is mainly used for monitoring and recording all kinds of operation behaviors to database server, passes through Analysis to network data in real time, intelligently parses the various operations to database server, and is logged into audit database In to be inquired, analyzed, to be filtered in the future, to realize the monitoring and audit to the user's operation of target database system. It, unavoidably will be to the Method of Database Secure Audit of cross-server installation during being managed to database security auditing system The network interface card packet drop of product is tested;But there are following defects for existing test method: 1, testing it in each round Before require artificially to interfere and go default test environment, and the lengthy and tedious complexity of test process;2, after test completion, test result is searched Collection needs to expend a large amount of manpower and goes to complete, it is also possible to because subjective human factor causes test error.
Summary of the invention
The technical problem to be solved in the present invention is that the database security for providing a kind of key test cross-server installation is examined The method for counting product packet loss can solve to need existing for existing test method artificially to interfere and remove default test wrapper by this method The collection in border, test result needs to expend a large amount of manpower and goes to complete and may be because that subjective human factor causes test to miss The problem of difference.
The present invention is implemented as follows: the side of the Method of Database Secure Audit product packet loss of key test cross-server installation Method, the method need to provide a first server and a second server, and the first server is communicated with second server Connection;Described method includes following steps:
Step S1, using the test environment of one key of key initializtion script initialization second server, and pass through the second clothes Business device sends the test script of playback of data package in first server;
Step S2, second server remote boot server is sent to the test script of the playback of data package in first server, Packet data is sent to the end Client of Method of Database Secure Audit product with the Agent end of simulated database security audit product;
Step S3, packet drop and the end Method of Database Secure Audit products C lient of network interface card are monitored on second server Packet drop, and save test result data;
Step S4, test result data is fabricated to curve graph, and is showed.
Further, in the step S1, the test environment of the initialization second server includes at least: refitting net Card driving, resetting network card interface parameter, clear data residual data of the library security audit product in last time test process and Set the parameter of Method of Database Secure Audit product.
Further, the step S2 specifically:
A driving playback script process is opened on second server, when second server is by the survey of playback of data package After training is originally sent to first server, by driving playback script process come the test foot of remote boot server playback of data package This;
After the test script of playback of data package is driven, Method of Database Secure Audit product in first server The end Client that Agent end starts the Method of Database Secure Audit product on second server sends packet data;Meanwhile second The end Client of Method of Database Secure Audit product on server starts the packet data that consumption receives.
Further, the step S3 specifically:
A monitoring packet loss process, the Method of Database Secure Audit product in first server are opened on second server Method of Database Secure Audit product of the Agent end on second server the end Client send packet data during, prison Control packet loss process monitors the packet drop of second server card of surfing Internet at set time intervals and database security is examined The packet drop at the end products C lient is counted, while the test result data monitored being saved into text;
After the Agent end of the Method of Database Secure Audit product in first server has sent packet data, database peace The Agent end of full audit product just sends a signal and gives monitoring packet loss process, stops monitoring with notice monitoring packet loss process.
Further, the time interval set is 1 second.
Further, the step S4 specifically:
Monitoring packet loss process stop monitoring after, by test report generator from text read test number of results According to, and test result data is fabricated to curve graph, and showed in the form of a web page.
The present invention has the advantage that 1, when carrying out each round test, one can be come using a key initializtion script Key initializes the test environment of second server, and entire test process is relatively simple, can be significantly reduced artificial default test The time cost of environment;
2, it is tested, can effectively avoid existing in the form of second server plays back packet data to first server There is tester to lead to dispersion attention due to needing while operating two-server, and cause test leakage situation occur, to lead Cause final test failure;
3, the test result data of monitoring is saved in text, and test knot is obtained by test report generator automatically Fruit data creating is showed at curve graph, while with more intuitive form web page, not only can be improved to test result data Treatment effeciency, and can be to avoid the error that may cause when artificially analyzing test result data.
Detailed description of the invention
The present invention is further illustrated in conjunction with the embodiments with reference to the accompanying drawings.
Fig. 1 is that the process of the method for the Method of Database Secure Audit product packet loss that a key of the invention tests cross-server installation is shown It is intended to.
Specific embodiment
Refering to Figure 1, the Method of Database Secure Audit product packet loss of present invention one kind one key test cross-server installation Method preferred embodiment, the method need to provide a first server and a second server, the first server It is communicated to connect with second server;In the inventive solutions, test main module is arranged on second server, database The Agent end of security audit product is arranged in first server, and the end the Client setting of Method of Database Secure Audit product is the On two servers.
Described method includes following steps:
Step S1, using the test environment of one key of key initializtion script initialization second server, and pass through the second clothes Business device sends the test script of playback of data package in first server;
In the step S1, the test environment of the initialization second server includes at least: refitting trawl performance, again Set network card interface parameter (for example, mtu, rx, tx etc.), clear data residual of the library security audit product in last time test process Data and the parameter for setting Method of Database Secure Audit product.In the specific implementation, can initialize according to actual needs The test environment of two servers writes a key initializtion script, and when carrying out each round test, can pass through a key Initializtion script realizes a key function of initializing.
Step S2, second server remote boot server is sent to the test script of the playback of data package in first server, Packet data is sent to the end Client of Method of Database Secure Audit product with the Agent end of simulated database security audit product;
The step S2 specifically:
A driving playback script process is opened on second server, when second server is by the survey of playback of data package After training is originally sent to first server, by driving playback script process come the test foot of remote boot server playback of data package This;
After the test script of playback of data package is driven, Method of Database Secure Audit product in first server Agent end start the Method of Database Secure Audit product on second server the end Client send packet data (that is, After the test script of playback of data package is driven, first server will start to play back packet data to second server); Meanwhile the end Client of the Method of Database Secure Audit product on second server starts the packet data that consumption receives.
Step S3, packet drop and the end Method of Database Secure Audit products C lient of network interface card are monitored on second server Packet drop, and save test result data;
The step S3 specifically:
A monitoring packet loss process, the Method of Database Secure Audit product in first server are opened on second server Method of Database Secure Audit product of the Agent end on second server the end Client send packet data during, prison Control packet loss process monitors the packet drop of second server card of surfing Internet at set time intervals and database security is examined The packet drop at the end products C lient is counted, while the test result data monitored being saved into text, to facilitate monitoring to tie Available test result data is analyzed and processed after beam;
After the Agent end of the Method of Database Secure Audit product in first server has sent packet data, database peace The Agent end of full audit product just sends a signal and gives monitoring packet loss process, stops monitoring with notice monitoring packet loss process.
In the preferred embodiment, the time interval set is 1 second.But the present invention is not limited to this, is having When body is implemented, other time intervals can also be set according to actual needs.
Step S4, test result data is fabricated to curve graph, and is showed;
The step S4 specifically: monitoring packet loss process stop monitoring after, by test report generator automatically from Read test result data in text, and test result data is fabricated to curve graph, and showed in the form of a web page.? It is more intuitive to curve graph progress for convenience to show in the preferred embodiment, using the form that shows of webpage, but this Invention is not limited to that, in the specific implementation, can also show form using others according to actual needs.
It is total described, the present invention has the advantage that
1, when carrying out each round test, key initialization second server can be carried out using a key initializtion script Environment is tested, and entire test process is relatively simple, the time cost of artificial default test environment can be significantly reduced;
2, it is tested, can effectively avoid existing in the form of second server plays back packet data to first server There is tester to lead to dispersion attention due to needing while operating two-server, and cause test leakage situation occur, to lead Cause final test failure;
3, the test result data of monitoring is saved in text, and test knot is obtained by test report generator automatically Fruit data creating is showed at curve graph, while with more intuitive form web page, not only can be improved to test result data Treatment effeciency, and can be to avoid the error that may cause when artificially analyzing test result data.
Although specific embodiments of the present invention have been described above, those familiar with the art should be managed Solution, we are merely exemplary described specific embodiment, rather than for the restriction to the scope of the present invention, it is familiar with this The technical staff in field should be covered of the invention according to modification and variation equivalent made by spirit of the invention In scope of the claimed protection.

Claims (6)

1. a kind of method of the Method of Database Secure Audit product packet loss of key test cross-server installation, it is characterised in that: described Method need to provide a first server and a second server, and the first server and second server communicate to connect;Institute The method of stating includes the following steps:
Step S1, using the test environment of one key of key initializtion script initialization second server, and pass through second server It sends the test script of playback of data package in first server;
Step S2, second server remote boot server is sent to the test script of the playback of data package in first server, with mould The Agent end of quasi- Method of Database Secure Audit product sends packet data to the end Client of Method of Database Secure Audit product;
Step S3, the packet drop of network interface card and losing for the Method of Database Secure Audit end products C lient are monitored on second server Packet situation, and save test result data;
Step S4, test result data is fabricated to curve graph, and is showed.
2. the method for the Method of Database Secure Audit product packet loss of key test cross-server installation according to claim 1, It is characterized by: in the step S1, the test environment of the initialization second server includes at least: refitting network interface card drives It moves, resetting network card interface parameter, clear data residual data and setting of the library security audit product in last time test process The parameter of Method of Database Secure Audit product.
3. the method for the Method of Database Secure Audit product packet loss of key test cross-server installation according to claim 1, It is characterized by: the step S2 specifically:
A driving playback script process is opened on second server, when second server is by the test foot of playback of data package Originally after being sent to first server, by driving playback script process come the test script of remote boot server playback of data package;
After the test script of playback of data package is driven, the Agent of the Method of Database Secure Audit product in first server The end Client that end starts the Method of Database Secure Audit product on second server sends packet data;Meanwhile second service The end Client of Method of Database Secure Audit product on device starts the packet data that consumption receives.
4. the method for the Method of Database Secure Audit product packet loss of key test cross-server installation according to claim 1, It is characterized by: the step S3 specifically:
A monitoring packet loss process is opened on second server, the Method of Database Secure Audit product in first server During the end Client of Method of Database Secure Audit product of the Agent end on second server sends packet data, monitoring Packet loss process monitors the packet drop and Method of Database Secure Audit of second server card of surfing Internet at set time intervals The packet drop at the end products C lient, while the test result data monitored being saved into text;
After the Agent end of the Method of Database Secure Audit product in first server has sent packet data, database security is examined The Agent end of meter product just sends a signal and gives monitoring packet loss process, stops monitoring with notice monitoring packet loss process.
5. the method for the Method of Database Secure Audit product packet loss of key test cross-server installation according to claim 4, It is characterized by: the time interval set is 1 second.
6. the method for the Method of Database Secure Audit product packet loss of key test cross-server installation according to claim 1, It is characterized by: the step S4 specifically:
Monitoring packet loss process stop monitoring after, by test report generator from text read test result data, and Test result data is fabricated to curve graph, and is showed in the form of a web page.
CN201810999342.7A 2018-08-30 2018-08-30 Method for testing packet loss of database security audit product installed across servers by one key Active CN109005087B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810999342.7A CN109005087B (en) 2018-08-30 2018-08-30 Method for testing packet loss of database security audit product installed across servers by one key

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810999342.7A CN109005087B (en) 2018-08-30 2018-08-30 Method for testing packet loss of database security audit product installed across servers by one key

Publications (2)

Publication Number Publication Date
CN109005087A true CN109005087A (en) 2018-12-14
CN109005087B CN109005087B (en) 2021-10-29

Family

ID=64594054

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810999342.7A Active CN109005087B (en) 2018-08-30 2018-08-30 Method for testing packet loss of database security audit product installed across servers by one key

Country Status (1)

Country Link
CN (1) CN109005087B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110278127A (en) * 2019-07-02 2019-09-24 成都安恒信息技术有限公司 A kind of Agent dispositions method and system based on secure transfer protocol

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102880535A (en) * 2012-07-24 2013-01-16 北京播思软件技术有限公司 Wireless automation testing device and method used for mobile equipment
CN104572405A (en) * 2014-12-12 2015-04-29 集时通(福建)信息科技有限公司 Pc server operation system and database operation environment monitoring alarm system
CN105205003A (en) * 2015-10-28 2015-12-30 努比亚技术有限公司 Automated testing method and device based on clustering system
CN106874197A (en) * 2017-02-08 2017-06-20 网易(杭州)网络有限公司 Method of testing and device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102880535A (en) * 2012-07-24 2013-01-16 北京播思软件技术有限公司 Wireless automation testing device and method used for mobile equipment
CN104572405A (en) * 2014-12-12 2015-04-29 集时通(福建)信息科技有限公司 Pc server operation system and database operation environment monitoring alarm system
CN105205003A (en) * 2015-10-28 2015-12-30 努比亚技术有限公司 Automated testing method and device based on clustering system
CN106874197A (en) * 2017-02-08 2017-06-20 网易(杭州)网络有限公司 Method of testing and device

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110278127A (en) * 2019-07-02 2019-09-24 成都安恒信息技术有限公司 A kind of Agent dispositions method and system based on secure transfer protocol
CN110278127B (en) * 2019-07-02 2020-12-01 成都安恒信息技术有限公司 Agent deployment method and system based on secure transmission protocol

Also Published As

Publication number Publication date
CN109005087B (en) 2021-10-29

Similar Documents

Publication Publication Date Title
Barse et al. Synthesizing test data for fraud detection systems
CN105426292B (en) A kind of games log real time processing system and method
US8621434B2 (en) System and method for distributed software testing
CN102902619B (en) The regression testing method of web application and device
US7757124B1 (en) Method and system for automatic correlation of asynchronous errors and stimuli
CN111147322B (en) Test system and method for micro service architecture of 5G core network
CN106815141A (en) A kind of method for testing software and device
US20160188445A1 (en) Conducting performance snapshots during test and using feedback to control test based on customer experience parameters
US8291068B2 (en) Automatic protocol detection
US11093349B2 (en) System and method for reactive log spooling
CN104125304B (en) A kind of session level application auditing method and system
CN105095207B (en) Retrieval, the method and apparatus for obtaining application software content
US20080243571A1 (en) Auditing advertisement presentations on a client device
CN107179995A (en) A kind of performance test methods of application program of computer network
CN109617910A (en) Loophole methods of risk assessment, device and storage medium, server
CN101013968A (en) Automated interface testing framework
CN104503910A (en) Product test method by monitoring users' using behavior
CN106506243A (en) A kind of webmaster method for diagnosing faults based on daily record data
CN112860569A (en) Automatic testing method and device, electronic equipment and storage medium
CN107995066A (en) A kind of method and apparatus of automatic test network interface card
CN110401580A (en) Webpage status monitoring method and relevant device based on heartbeat mechanism
CN104809057A (en) Application test system, application test method and storage medium
CN110245077A (en) A kind of response method and equipment of program exception
CN107256276A (en) A kind of mobile App content safeties acquisition methods and equipment based on cloud platform
CN110049313A (en) A kind of video measurement method and system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information
CB02 Change of applicant information

Address after: 350000 21 / F, building 5, f District, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province

Applicant after: FUJIAN SINOREGAL SOFTWARE Co.,Ltd.

Address before: Floor 20-21, building 5, area F, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province 350000

Applicant before: FUJIAN SINOREGAL SOFTWARE Co.,Ltd.

GR01 Patent grant
GR01 Patent grant