CN115277657B - Method and equipment for operating and maintaining database protocol - Google Patents
Method and equipment for operating and maintaining database protocol Download PDFInfo
- Publication number
- CN115277657B CN115277657B CN202210602776.5A CN202210602776A CN115277657B CN 115277657 B CN115277657 B CN 115277657B CN 202210602776 A CN202210602776 A CN 202210602776A CN 115277657 B CN115277657 B CN 115277657B
- Authority
- CN
- China
- Prior art keywords
- maintenance
- web server
- protocol
- database
- data stream
- 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.)
- Active
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/02—Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/08—Protocols specially adapted for terminal emulation, e.g. Telnet
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/14—Session management
- H04L67/141—Setup of application sessions
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/22—Parsing or analysis of headers
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Computer Security & Cryptography (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The application aims to provide a method and equipment for operating and maintaining a database protocol, wherein a web server is connected with an operation and maintenance audit module through a web operation and maintenance agent, and the web server is connected with a hosting center through the operation and maintenance audit module loading a remote connection protocol; opening a corresponding database client tool based on parameter information sent by a web server so that the web server and a database are connected; acquiring a remote connection protocol data stream based on a web server, and carrying out protocol analysis on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture; and acquiring operation and maintenance operations based on the web server and the operation and maintenance picture, transmitting the operation and maintenance operations to the hosting center through the web operation and maintenance agent and the operation and maintenance auditing module, and completing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operations so as to realize the database operation and maintenance of a local client-free terminal.
Description
Technical Field
The present disclosure relates to the field of computers, and in particular, to a method and apparatus for operating and maintaining a database protocol.
Background
The client-free page operation and maintenance is a new database operation and maintenance method, which converts the operation and maintenance mode of a client/server model (C/S) into a browser/server mode (B/S) by using a web server and a page operation and maintenance agent, so that operation and maintenance operations can be realized in a browser by operation and maintenance personnel without installing an operation and maintenance client. At present, due to protocol analysis and agent reasons, the operation and maintenance of four protocols, namely SSH, telnet, RDP and VNC, are only realized by the operation and maintenance of the page without a client.
A database is a repository that organizes, stores and manages data according to a data structure. The databases in the prior art are mainly two types of relational databases and non-relational databases, wherein the relational databases are mainly Oracle, sybase, mysql, DB, sqlServer and the like. The database class protocols described herein are primarily directed to these relational databases.
Existing operation and maintenance audit products can be generally divided into two modes when supporting database type protocol operation and maintenance, wherein one mode is local operation and maintenance, and the other mode is operation and maintenance through a hosting center. The local operation and maintenance is a client tool for locally installing database type protocols, such as PLSQL, winSQL, mySQLclient, and the local operation and maintenance is connected to an agent program of an operation and maintenance audit product through the client tool during operation and maintenance, and then connected to a target database server through the agent program. This approach requires the user to install different database clients locally, occupies space and consumes memory, and most of this approach does not audit video.
The database client tool is installed on a single piece of equipment through the hosting center operation and maintenance, is called a hosting center, and then is connected to the hosting center from a local machine by utilizing a remote desktop function of remoteAPP, and the client tool installed on the hosting center operation and maintenance is opened to be connected to the target database service end. This approach does not require the installation of various client tools locally and supports video auditing functions. However, this approach requires that mstsc be used on Windows systems by means of a native RDP client, and that different Windows versions are used, and that the mstsc versions are adapted. In addition, the Linux system does not support a hosting center operation and maintenance mode at present.
Disclosure of Invention
An object of the present application is to provide a method and an apparatus for operating and maintaining a database protocol, which solve the problems in the prior art that a Linux system does not support operation and maintenance of a hosting center, a Windows system needs to adapt to multiple versions of mstsc, a local operation and maintenance mode wastes system resources, and video auditing cannot be performed without a client.
According to one aspect of the present application, there is provided a method of database protocol operation and maintenance, the method comprising:
establishing connection between a web server and an operation and maintenance auditing module through a web operation and maintenance agent, and establishing connection between the web server and a hosting center through the operation and maintenance auditing module loaded with a remote connection protocol;
opening a corresponding database client tool based on parameter information sent by a web server so that the web server and a database are connected;
acquiring a remote connection protocol data stream based on a web server, and carrying out protocol analysis on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture;
and acquiring operation and maintenance operation based on the web server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the web operation and maintenance agent and the operation and maintenance audit module, and completing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation.
Optionally, the establishing connection between the web server and the operation and maintenance audit module through the page operation and maintenance agent includes:
obtaining initial parameters from a webpage server, and adding a path of a host center main control program and related parameters into the initial parameters to obtain parameter information, wherein the initial parameters comprise an IP address, port information, user account information, password information and operation and maintenance protocol of target equipment;
and sending the parameter information to the page operation and maintenance agent, and establishing a connection relation between the web server and the operation and maintenance audit module through the page operation and maintenance agent.
Optionally, the establishing the connection between the web server and the hosting center through the operation and maintenance auditing module loading the remote connection protocol includes:
analyzing the parameter information through the operation and maintenance audit module to determine an analysis result;
and loading a remote connection protocol through the operation and maintenance audit module based on the analysis result, and establishing connection between the webpage server and the hosting center, wherein the remote connection protocol comprises a remote desktop protocol.
Optionally, the opening a corresponding database client tool based on the parameter information sent by the web server, so that the web server establishes a connection with the database, including:
acquiring parameter information sent by a web server, and starting a main control program of a hosting center based on the parameter information;
and opening a corresponding database client tool based on the parameter information by using the main control program so as to enable the web server to establish connection with a database.
Optionally, the performing protocol analysis on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture includes:
and converting the remote connection protocol data stream into a preset format data stream through the page operation and maintenance agent, wherein the preset format data stream comprises a text data stream or a picture data stream.
Optionally, after the protocol analysis is performed on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture, the method includes:
and displaying the operation and maintenance picture in the browser.
According to another aspect of the present application, there is also provided an apparatus for database protocol operation and maintenance, the apparatus comprising:
the first connection module is used for establishing connection between the web server and the operation and maintenance audit module through the page operation and maintenance agent, and establishing connection between the web server and the hosting center through the operation and maintenance audit module loaded with a remote connection protocol;
the second connection module is used for opening a corresponding database client tool based on the parameter information sent by the web server so that the web server and the database are connected;
the data analysis module is used for acquiring a remote connection protocol data stream based on a web server, and carrying out protocol analysis on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture;
the data processing module is used for acquiring operation and maintenance operation based on the web server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the web operation and maintenance agent and the operation and maintenance auditing module, and completing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation. According to yet another aspect of the present application, there is also provided a computer readable medium having stored thereon computer readable instructions executable by a processor to implement a method as claimed in any one of the preceding claims.
According to yet another aspect of the present application, there is also provided an apparatus for database protocol operation and maintenance, the apparatus comprising:
one or more processors; and
a memory storing computer readable instructions that, when executed, cause the processor to perform the operations of the method of any of the preceding claims.
Compared with the prior art, the method and the system have the advantages that the web server is connected with the operation and maintenance audit module through the web operation and maintenance agent, and the web server is connected with the hosting center through the operation and maintenance audit module loaded with the remote connection protocol; opening a corresponding database client tool based on parameter information sent by a web server so that the web server and a database are connected; acquiring a remote connection protocol data stream based on a web server, and carrying out protocol analysis on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture; and acquiring operation and maintenance operation based on the web server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the web operation and maintenance agent and the operation and maintenance audit module, and completing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation. Thus, the operation and maintenance of the database protocol can be realized in the browser without a An Zhuangyun operation and maintenance tool of the user.
Drawings
Other features, objects and advantages of the present application will become more apparent upon reading of the detailed description of non-limiting embodiments, made with reference to the following drawings, in which:
FIG. 1 illustrates a method flow diagram of a database protocol operation and maintenance provided in accordance with an aspect of the present application;
FIG. 2 is a flow chart of a method of database protocol operation and maintenance in an alternative embodiment of the present application;
fig. 3 illustrates a device framework structure diagram for database protocol operation and maintenance according to another aspect of the subject application.
The same or similar reference numbers in the drawings refer to the same or similar parts.
Detailed Description
The present application is described in further detail below with reference to the accompanying drawings.
In one typical configuration of the present application, the terminal, the device of the service network, and the trusted party each include one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer readable media, as defined herein, does not include non-transitory computer readable media (transmission media), such as modulated data signals and carrier waves.
Current database class protocol operations require the installation of a database class protocol client tool locally or by means of a local RDP client on a separate piece of equipment. According to the method, the operation and maintenance method based on the database protocol can be provided, a user does not need to resort to any client tool at the local machine, and only needs to support the page protocol by a browser of the user.
FIG. 1 illustrates a method flow diagram of a database protocol operation and maintenance provided in accordance with an aspect of the present application, the method comprising: step S100 to step S400, wherein in S100, a web server is connected with an operation and maintenance audit module through a web operation and maintenance agent, and the web server is connected with a hosting center through the operation and maintenance audit module loaded with a remote connection protocol; in S200, opening a corresponding database client tool based on the parameter information sent by the web server, so that the web server establishes a connection with the database; in S300, a remote connection protocol data stream is acquired based on a web server, and protocol analysis is carried out on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture; in S400, an operation is acquired based on the web server and the operation and maintenance picture, the operation and maintenance is transferred to the hosting center through the web server and the operation and maintenance agency, and the operation and maintenance process on the database protocol is completed based on the hosting center according to the operation and maintenance operation. Thus, the operation and maintenance of the database protocol can be realized in the browser without a An Zhuangyun operation and maintenance tool of the user.
It should be noted that, the above step reference signs are only used to identify different steps, and do not represent the execution sequence of the steps.
Specifically, in S100, a connection is established between a web server and an operation and maintenance audit module through a web operation and maintenance agent, and between the web server and a hosting center through an operation and maintenance audit module loading a database protocol. The objective here is to connect a web server (web server) to a hosting center, to connect a web server to a database protocol loaded by a web server and a web server to the hosting center by connecting the web server to an web server audit module.
In S200, a corresponding database client tool is opened based on the parameter information sent by the web server, so that the web server establishes a connection with the database. The hosting center is a single device, and is provided with a database client tool, and after parameter information sent by the web server is acquired, corresponding analysis is performed, so that a link of the corresponding database client tool can be obtained, and the web server is connected with the database.
In S300, a remote connection protocol data stream is acquired based on a web server, and the remote connection protocol data stream is subjected to protocol analysis by the web server to obtain an operation and maintenance picture. The remote connection protocol data stream sent by the hosting center can be acquired through the page operation and maintenance agent, the remote connection protocol data stream is transmitted to the webpage server based on the agent protocol, the webpage server analyzes the remote protocol data stream and draws an operation and maintenance picture, and the operation and maintenance processing can be completed in the browser based on the operation and maintenance operation acquired by the webpage server and the drawn operation and maintenance picture.
In S400, an operation is acquired based on the web server and the operation and maintenance picture, the operation and maintenance is transferred to the hosting center through the web server and the operation and maintenance agency, and the operation and maintenance process on the database protocol is completed based on the hosting center according to the operation and maintenance operation. And when the operation of the user is acquired, the operation is transmitted to the hosting center through a proxy protocol and a remote connection protocol and is effective on an operation tool of the hosting center, so that the operation and maintenance processing of the database protocol is completed. Thus, the operation and maintenance of the database protocol can be realized in the browser without a An Zhuangyun operation and maintenance tool of the user.
In an optional embodiment of the present application, in S100, an initial parameter is obtained from a web server, and a path of a hosting center main control program and related parameters are added in the initial parameter to obtain the parameter information, where the initial parameter includes an IP address, port information, user account information, password information, and an operation and maintenance protocol of a target device; and sending the parameter information to the page operation and maintenance agent, and establishing a connection relation between the web server and the operation and maintenance audit module through the page operation and maintenance agent. Here, the path of the host center main control program and related parameters are added to the initial parameters to obtain parameter information, so that the host center main control program analyzes the parameter information to start a corresponding database client tool, and the purpose of the method is to immediately open the database client tool when the host center is connected, as if the database client is installed locally, and on the other hand, an operator can only operate the opened database client tool and cannot operate other applications on the host center. And then, establishing a connection relation between the web server and the operation and maintenance audit module through the page operation and maintenance agent, so that after the connection between the page operation and maintenance agent and the operation and maintenance audit module is established, the operation and maintenance audit module analyzes the parameter information, and loads a database protocol to be connected to a hosting center.
In an optional embodiment of the present application, in S100, the operation and maintenance auditing module analyzes the parameter information to determine an analysis result; and loading a remote connection protocol through the operation and maintenance audit module based on the analysis result, and establishing connection between the webpage server and the hosting center, wherein the remote connection protocol comprises a remote desktop protocol. In this case, the remote desktop protocol (RDP protocol) supporting remoteAPP is used as a remote connection protocol by the page operation and maintenance agent when implementing, and the remote desktop protocol is loaded by the operation and maintenance audit module, so that audit video can be implemented while no client database protocol operation and maintenance is implemented, and a user does not need to install different database clients in a local machine, thereby reducing occupation of system space memory.
In an optional embodiment of the present application, in S200, parameter information sent by a web server is obtained, and a main control program of a hosting center is started based on the parameter information; and opening a corresponding database client tool based on the parameter information by using the main control program so as to enable the web server to establish connection with a database. The method comprises the steps that parameter information sent by a web server is obtained, a main control program is executed based on a path of a host center main control program added in the parameter information and related parameters, and because a remoteAPP function is used, when connection with the host center is established, the main control program is executed at the first time, and the main control program analyzes the parameter information to open a corresponding database client tool, so that the web server is connected with a database, and operation and maintenance of a client-free database protocol are conveniently realized.
In an optional embodiment of the present application, in S300, the remote connection protocol data stream is converted into a preset format data stream through the page operation and maintenance agent, where the preset format data stream includes a text data stream or a picture data stream. The page operation and maintenance agent establishes connection with the target database, converts the remote connection protocol data stream into text or picture stream and transmits the text or picture stream to the web server, so that the web server can analyze the protocol and draw operation and maintenance pictures.
In an optional embodiment of the present application, after the remote connection protocol data stream is subjected to protocol analysis by the web server to obtain an operation and maintenance picture, the operation and maintenance picture is displayed in a browser. Here, the data processing module 400 may be used to display the operation and maintenance screen in the browser after performing protocol analysis on the remote connection protocol data stream through the web server to obtain the operation and maintenance screen. The operation and maintenance picture is drawn after the web server and the database are connected, and after the connection between the RDP protocol and the hosting center is actually established for the operation and maintenance of the database protocol, the web server is equivalent to realizing the mstsc function, converting RDP data flow into graphic data and displaying the graphic data in the browser, and meanwhile, the operation and maintenance operation such as mouse and keyboard actions are transferred to the hosting center, so that the interaction purpose is realized.
Fig. 2 is a schematic flow chart of a method for operating and maintaining a database protocol in an alternative embodiment of the present application, where the first two parts are cores of the operation and maintenance of a page without a client, and the web server is responsible for backward transferring parameters, such as information of an IP address, a port, a user name, a password, an operation and maintenance protocol of a connected target device, when transferring parameters, a path and related parameters of a main control program on a hosting center need to be added, parameter information after the path and related parameters of the main control program are added is transferred to a page operation and maintenance agent, and after the web server and the database are connected, an operation and maintenance picture is drawn in a browser. Here, since the parameter information is implemented in key-value pairs such as "attribute" and "value", it is convenient to add a new parameter. The operation and maintenance of the database protocol is actually realized by means of the RDP protocol, after connection is established, the web server is equivalent to realizing the function of mstsc, RDP data flow is converted into graphic data and displayed in a browser, and meanwhile, the operation and maintenance operation such as mouse and keyboard actions are transferred to a target end, so that the interaction purpose is realized.
With the above embodiment, the page operation agent is responsible for loading the protocol, and may support four protocols, ssh, telnet, RDP and VNC, where the protocols refer to RDP protocols, because database operation is ultimately implemented by RDP protocols. The page operation and maintenance agent is used as a client to establish connection with an operation and maintenance auditing system. The web server acts as an operation client and operation tool in conjunction with the page operation agent, respectively. It should be noted that, when implementing, the page operation agent must use RDP protocol supporting remoteAPP, such as FreeRDP, otherwise, no client-side database protocol operation can be implemented.
And then, after the page operation and maintenance agent establishes connection with the operation and maintenance auditing system, the operation and maintenance auditing system analyzes parameters, loads an RDP protocol and connects to the hosting center. Because of the remoteAPP function, the master control program is executed at the first time when the remote control program is connected to the hosting center, and the master control program opens the corresponding database client tool to connect through analyzing parameters, so that the database client tool is opened immediately when the remote control program is connected to the hosting center, and the purpose of the remote control program is to enable the database client tool to be opened as if the database client is installed locally, and on the other hand, an operator can only operate the opened database client tool and cannot operate other applications on the hosting center. At this time, the page operation and maintenance agent establishes connection with the target database, converts the protocol data stream into text or picture stream and transmits the text or picture stream to the web server, and the web server analyzes the protocol and performs picture drawing to present remote display. The final operation and maintenance flow is as follows: the operation and maintenance personnel clicks an operation and maintenance button in an operation and maintenance audit system, a new tab page is opened in a current browser, the page displays an operation and maintenance picture, operation and maintenance operation of the operation and maintenance personnel is transferred to a hosting center through an RDP protocol, and operation and maintenance of a database protocol are completed based on a client tool of the hosting center. Mouse and keyboard operations of operation and maintenance personnel on the page can be transmitted to the back end, so that the operations of adding, deleting and checking the database are realized. Thus realizing the operation and maintenance of the database protocol in the browser without the An Zhuangyun operation and maintenance tool of the user.
Embodiments of the present application also provide a computer readable medium having stored thereon computer readable instructions executable by a processor to implement a method of database protocol operation and maintenance as described above.
Corresponding to the above-described method, the present application further provides a terminal, which includes modules or units capable of performing the steps of the method described in fig. 1 or fig. 2 or the respective embodiments, where the modules or units may be implemented by hardware, software or a combination of hardware and software, and the present application is not limited thereto. For example, in an embodiment of the present application, there is further provided an apparatus for database protocol operation and maintenance, where the apparatus includes:
one or more processors; and
a memory storing computer readable instructions that, when executed, cause the processor to perform the operations of the aforementioned method of one database protocol operation.
For example, computer-readable instructions, when executed, cause the one or more processors to:
establishing connection between a web server and an operation and maintenance auditing module through a web operation and maintenance agent, and establishing connection between the web server and a hosting center through the operation and maintenance auditing module loaded with a remote connection protocol; opening a corresponding database client tool based on parameter information sent by a web server so that the web server and a database are connected; acquiring a remote connection protocol data stream based on a web server, and carrying out protocol analysis on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture; and acquiring operation and maintenance operation based on the web server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the web operation and maintenance agent and the operation and maintenance audit module, and completing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation.
FIG. 3 illustrates a device framework structure diagram for database protocol operation and maintenance, in accordance with another aspect of the subject application, the device comprising: the first connection module 100 is configured to connect a web server with an operation and maintenance audit module through a page operation and maintenance agent, and connect the web server with a hosting center through the operation and maintenance audit module loaded with a remote connection protocol; a second connection module 200, configured to open a corresponding database client tool based on parameter information sent by a web server, so that the web server establishes a connection with a database; the data analysis module 300 is configured to obtain a remote connection protocol data stream based on a web server, and perform protocol analysis on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture; the data processing module 400 is configured to obtain an operation based on the web server and the operation and maintenance picture, transmit the operation and maintenance to the hosting center through the web server and the operation and maintenance agent, and complete the operation and maintenance processing on the database protocol based on the hosting center according to the operation and maintenance operation. Thus, the operation and maintenance of the database protocol can be realized in the browser without a An Zhuangyun operation and maintenance tool of the user.
It should be noted that, the contents executed by the first connection module 100, the second connection module 200, the data analysis module 300, and the data processing module 400 are the same as or corresponding to the contents in the above steps S100, S200, S300, and S400, respectively, and are not described herein for brevity.
It will be apparent to those skilled in the art that various modifications and variations can be made in the present application without departing from the spirit or scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims and the equivalents thereof, the present application is intended to cover such modifications and variations.
It should be noted that the present application may be implemented in software and/or a combination of software and hardware, for example, using Application Specific Integrated Circuits (ASIC), a general purpose computer or any other similar hardware device. In one embodiment, the software programs of the present application may be executed by a processor to implement the steps or functions as described above. Likewise, the software programs of the present application (including associated data structures) may be stored on a computer readable recording medium, such as RAM memory, magnetic or optical drive or diskette and the like. In addition, some steps or functions of the present application may be implemented in hardware, for example, as circuitry that cooperates with the processor to perform various steps or functions.
Furthermore, portions of the present application may be implemented as a computer program product, such as computer program instructions, which when executed by a computer, may invoke or provide methods and/or techniques in accordance with the present application by way of operation of the computer. Program instructions for invoking the methods of the present application may be stored in fixed or removable recording media and/or transmitted via a data stream in a broadcast or other signal bearing medium and/or stored within a working memory of a computer device operating according to the program instructions. An embodiment according to the present application comprises an apparatus comprising a memory for storing computer program instructions and a processor for executing the program instructions, wherein the computer program instructions, when executed by the processor, trigger the apparatus to operate a method and/or a solution according to the embodiments of the present application as described above.
It will be evident to those skilled in the art that the present application is not limited to the details of the foregoing illustrative embodiments, and that the present application may be embodied in other specific forms without departing from the spirit or essential characteristics thereof. The present embodiments are, therefore, to be considered in all respects as illustrative and not restrictive, the scope of the application being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned. Furthermore, it is evident that the word "comprising" does not exclude other elements or steps, and that the singular does not exclude a plurality. The terms first, second, etc. are used to denote a name, but not any particular order.
Claims (8)
1. A method of database protocol operation, the method comprising:
establishing connection between a web server and an operation and maintenance audit module through a web operation and maintenance agent, and establishing connection between the web server and a hosting center through the operation and maintenance audit module loaded with a remote connection protocol, wherein the remote connection protocol is an RDP protocol;
acquiring parameter information sent by a web server, and starting a main control program of a hosting center based on the parameter information;
using the main control program to open a corresponding database client tool based on the parameter information so as to enable the web server to establish connection with a database;
acquiring a remote connection protocol data stream based on a web server, and carrying out protocol analysis on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture;
and acquiring operation and maintenance operations based on the webpage server and the operation and maintenance picture, transmitting the operation and maintenance operations to the hosting center through the webpage operation and maintenance agent and the operation and maintenance auditing module, and carrying out operation and maintenance processing on a database protocol by the hosting center based on the acquired operation and maintenance operations by using a client tool.
2. The method of claim 1, wherein the connecting the web server to the operation and maintenance audit module through the web operation and maintenance agent comprises:
obtaining initial parameters from a webpage server, and adding a path of a host center main control program and related parameters into the initial parameters to obtain parameter information, wherein the initial parameters comprise an IP address, port information, user account information, password information and operation and maintenance protocol of target equipment;
and sending the parameter information to the page operation and maintenance agent, and establishing a connection relation between the web server and the operation and maintenance audit module through the page operation and maintenance agent.
3. The method of claim 2, wherein the establishing the connection of the web server with the hosting center through the operation and maintenance auditing module that loads the remote connection protocol comprises:
analyzing the parameter information through the operation and maintenance audit module to determine an analysis result;
and loading a remote connection protocol through the operation and maintenance audit module based on the analysis result, and establishing connection between the webpage server and the hosting center, wherein the remote connection protocol comprises a remote desktop protocol.
4. The method according to claim 1, wherein the performing protocol parsing on the remote connection protocol data stream by the web server to obtain an operation and maintenance picture includes:
and converting the remote connection protocol data stream into a preset format data stream through the page operation and maintenance agent, wherein the preset format data stream comprises a text data stream or a picture data stream.
5. The method according to claim 1, wherein after the protocol parsing of the remote connection protocol data stream by the web server to obtain an operation and maintenance picture, the method comprises:
and displaying the operation and maintenance picture in the browser.
6. An apparatus for database protocol operation, the apparatus comprising:
the first connection module is used for establishing connection between the web server and the operation and maintenance audit module through the page operation and maintenance agent, and establishing connection between the web server and the hosting center through the operation and maintenance audit module loaded with a remote connection protocol, wherein the remote connection protocol is an RDP protocol;
the second connection module is used for acquiring parameter information sent by the web server, starting a main control program of the hosting center based on the parameter information, and opening a corresponding database client tool based on the parameter information by using the main control program so as to enable the web server to be connected with a database;
the data analysis module is used for acquiring a remote connection protocol data stream based on a web server, and carrying out protocol analysis on the remote connection protocol data stream through the web server to obtain an operation and maintenance picture;
the data processing module is used for acquiring operation and maintenance operations based on the web server and the operation and maintenance picture, transmitting the operation and maintenance operations to the hosting center through the web page operation and maintenance agent and the operation and maintenance auditing module, and carrying out operation and maintenance processing on a database protocol by the hosting center based on the acquired operation and maintenance operations by using a client tool.
7. A computer readable medium having stored thereon computer readable instructions executable by a processor to implement the method of any of claims 1 to 5.
8. An apparatus for database protocol operation, the apparatus comprising:
one or more processors; and
a memory storing computer readable instructions that, when executed, cause the processor to perform the operations of the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210602776.5A CN115277657B (en) | 2022-05-30 | 2022-05-30 | Method and equipment for operating and maintaining database protocol |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210602776.5A CN115277657B (en) | 2022-05-30 | 2022-05-30 | Method and equipment for operating and maintaining database protocol |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115277657A CN115277657A (en) | 2022-11-01 |
| CN115277657B true CN115277657B (en) | 2023-06-13 |
Family
ID=83759513
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210602776.5A Active CN115277657B (en) | 2022-05-30 | 2022-05-30 | Method and equipment for operating and maintaining database protocol |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115277657B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116112559A (en) * | 2022-12-09 | 2023-05-12 | 浙江安巽科技有限公司 | Remote server management control method, system and storage medium |
| CN116743728B (en) * | 2023-08-11 | 2023-10-20 | 深圳竹云科技股份有限公司 | Application operation and maintenance method, system, equipment and storage medium |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002006967A1 (en) * | 2000-07-14 | 2002-01-24 | Conxion Corporation | Apparatus and method for remote maintenance of hosted network services |
| CN103281210A (en) * | 2013-06-08 | 2013-09-04 | 山东瑞宁信息技术有限公司 | Version management system for configuration files of network equipment |
| CN103973488A (en) * | 2014-04-29 | 2014-08-06 | 上海上讯信息技术股份有限公司 | Operation and maintenance management system and method based on RDP protocol |
| CN107122674A (en) * | 2017-04-12 | 2017-09-01 | 成都安恒信息技术有限公司 | A kind of access method of oracle database applied to O＆M auditing system |
| JP2017175316A (en) * | 2016-03-23 | 2017-09-28 | 京セラドキュメントソリューションズ株式会社 | System and method for remote maintenance |
| CN107612736A (en) * | 2017-09-21 | 2018-01-19 | 成都安恒信息技术有限公司 | A kind of web browser operation audit method based on container |
| CN108270822A (en) * | 2016-12-30 | 2018-07-10 | 中移(苏州)软件技术有限公司 | A kind of control inverting method and device based on Remote Desktop Protocol RDP |
| CN108366090A (en) * | 2018-01-09 | 2018-08-03 | 国网安徽省电力公司阜阳供电公司 | A kind of system that dispatch data net remotely accesses reinforcing and Centralized Monitoring |
| CN109446036A (en) * | 2018-11-02 | 2019-03-08 | 深圳竹云科技有限公司 | A method of novel maintenance is carried out by webpage |
| CN109643312A (en) * | 2016-09-01 | 2019-04-16 | 亚马逊科技公司 | Trustship query service |
| CN111082998A (en) * | 2019-12-30 | 2020-04-28 | 上海数熙科技有限公司 | Architecture system of operation and maintenance monitoring campus convergence layer |
| CN111177617A (en) * | 2019-12-06 | 2020-05-19 | 上海上讯信息技术股份有限公司 | Web direct operation and maintenance method and device based on operation and maintenance management system and electronic equipment |
| CN111193602A (en) * | 2018-11-15 | 2020-05-22 | 顺丰科技有限公司 | Automatic operation and maintenance management system and method |
| CN111984971A (en) * | 2020-08-10 | 2020-11-24 | 成都安恒信息技术有限公司 | Method for automatically producing and managing operation and maintenance data |
| CN114389831A (en) * | 2020-10-22 | 2022-04-22 | 山东华软金盾软件股份有限公司 | TCP proxy method based on remote desktop protocol |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020026507A1 (en) * | 2000-08-30 | 2002-02-28 | Sears Brent C. | Browser proxy client application service provider (ASP) interface |
| US20170046013A1 (en) * | 2015-08-14 | 2017-02-16 | Microsoft Technology Licensing, Llc | Web-browser based desktop and application remoting solution |
-
2022
- 2022-05-30 CN CN202210602776.5A patent/CN115277657B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002006967A1 (en) * | 2000-07-14 | 2002-01-24 | Conxion Corporation | Apparatus and method for remote maintenance of hosted network services |
| CN103281210A (en) * | 2013-06-08 | 2013-09-04 | 山东瑞宁信息技术有限公司 | Version management system for configuration files of network equipment |
| CN103973488A (en) * | 2014-04-29 | 2014-08-06 | 上海上讯信息技术股份有限公司 | Operation and maintenance management system and method based on RDP protocol |
| JP2017175316A (en) * | 2016-03-23 | 2017-09-28 | 京セラドキュメントソリューションズ株式会社 | System and method for remote maintenance |
| CN109643312A (en) * | 2016-09-01 | 2019-04-16 | 亚马逊科技公司 | Trustship query service |
| CN108270822A (en) * | 2016-12-30 | 2018-07-10 | 中移(苏州)软件技术有限公司 | A kind of control inverting method and device based on Remote Desktop Protocol RDP |
| CN107122674A (en) * | 2017-04-12 | 2017-09-01 | 成都安恒信息技术有限公司 | A kind of access method of oracle database applied to O＆M auditing system |
| CN107612736A (en) * | 2017-09-21 | 2018-01-19 | 成都安恒信息技术有限公司 | A kind of web browser operation audit method based on container |
| CN108366090A (en) * | 2018-01-09 | 2018-08-03 | 国网安徽省电力公司阜阳供电公司 | A kind of system that dispatch data net remotely accesses reinforcing and Centralized Monitoring |
| CN109446036A (en) * | 2018-11-02 | 2019-03-08 | 深圳竹云科技有限公司 | A method of novel maintenance is carried out by webpage |
| CN111193602A (en) * | 2018-11-15 | 2020-05-22 | 顺丰科技有限公司 | Automatic operation and maintenance management system and method |
| CN111177617A (en) * | 2019-12-06 | 2020-05-19 | 上海上讯信息技术股份有限公司 | Web direct operation and maintenance method and device based on operation and maintenance management system and electronic equipment |
| CN111082998A (en) * | 2019-12-30 | 2020-04-28 | 上海数熙科技有限公司 | Architecture system of operation and maintenance monitoring campus convergence layer |
| CN111984971A (en) * | 2020-08-10 | 2020-11-24 | 成都安恒信息技术有限公司 | Method for automatically producing and managing operation and maintenance data |
| CN114389831A (en) * | 2020-10-22 | 2022-04-22 | 山东华软金盾软件股份有限公司 | TCP proxy method based on remote desktop protocol |
Non-Patent Citations (3)
| Title |
|---|
| 云应用引擎技术的研究与策略;范平平;;科技视界(第28期);全文 * |
| 基于Hadoop的电力运维审计系统的设计;苏林萍;安然;李为;崔文超;张晓良;;计算机与现代化(第01期);全文 * |
| 基于应用代理的运维堡垒机研究;吴耀芳;来学嘉;;微型电脑应用(第08期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115277657A (en) | 2022-11-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN115277657B (en) | Method and equipment for operating and maintaining database protocol | |
| US11222001B2 (en) | Augmenting middleware communication services | |
| CN108470302B (en) | Interaction method and device of client and server | |
| CN110971655A (en) | Offline client playback and synchronization | |
| CN110232091B (en) | Method, system and apparatus for synchronizing data | |
| US9654576B2 (en) | Database triggered push notification | |
| US12088685B2 (en) | Platform for multi-stream sampling and visualization | |
| CN109582317B (en) | Method and apparatus for debugging hosted applications | |
| CN112631590B (en) | Component library generation method, device, electronic equipment and computer readable medium | |
| CN112671876B (en) | Method and equipment for page operation and maintenance | |
| CN113553260B (en) | Test method, test apparatus, device, and medium | |
| CN114840379A (en) | Log generation method, device, server and storage medium | |
| US10931781B2 (en) | Mobile device cache updating | |
| US20060155817A1 (en) | Web services integration systems and methods | |
| US20170302764A1 (en) | Unifying realtime and static data for presenting over a web service | |
| CN109889402B (en) | Method and apparatus for generating information | |
| CN114219643A (en) | Transaction calling method, device, equipment and storage medium | |
| US20060112372A1 (en) | Method, system and program product for implementing java server page (JSP) containers as java server faces (JSF) components | |
| US12003371B1 (en) | Server configuration anomaly detection | |
| CN113360417B (en) | Test method, session modifier, electronic device and medium | |
| WO2023230797A1 (en) | Cross-system test method and apparatus | |
| US11755681B2 (en) | Real-time equivalent user interaction generation | |
| CN111090485B (en) | Multi-cluster-oriented help data processing method and device, medium and equipment | |
| US20240036831A1 (en) | An extensible binding mechanism for translating between application programming interface description languages | |
| CN110099122B (en) | Method and apparatus for sending network request |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |