CN115277657A - Method and device for operation and maintenance of database protocol - Google Patents
Method and device for operation and maintenance of database protocol Download PDFInfo
- Publication number
- CN115277657A CN115277657A CN202210602776.5A CN202210602776A CN115277657A CN 115277657 A CN115277657 A CN 115277657A CN 202210602776 A CN202210602776 A CN 202210602776A CN 115277657 A CN115277657 A CN 115277657A
- Authority
- CN
- China
- Prior art keywords
- maintenance
- protocol
- database
- server
- 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.)
- Granted
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
Abstract
The method comprises the steps that a webpage server is connected with an operation and maintenance auditing module through a page operation and maintenance agent, and the webpage server is connected with a hosting center through the operation and maintenance auditing module loaded with a remote connection protocol; opening a corresponding database client tool based on the parameter information sent by the web server so as to establish connection between the web server and the database; acquiring a remote connection protocol data stream based on a webpage server, and carrying out protocol analysis on the remote connection protocol data stream through the webpage server to obtain an operation and maintenance picture; and acquiring operation and maintenance operation based on the webpage server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the webpage operation and maintenance agent and the operation and maintenance auditing module, and finishing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation so as to realize local database operation and maintenance without a client.
Description
Technical Field
The present application relates to the field of computers, and in particular, to a method and an apparatus for database protocol operation and maintenance.
Background
The operation and maintenance without the client side page is a new database operation and maintenance method, and the operation and maintenance mode of a client side/server model (C/S) is converted into a browser/server mode (B/S) by using a web server and a page operation and maintenance agent, so that operation and maintenance personnel can realize operation and maintenance in a browser without installing an operation and maintenance client side. At present, due to protocol analysis and proxy reasons, operation and maintenance without a client page only realize operation and maintenance of four protocols, namely SSH, telnet, RDP and VNC.
A database is a repository that organizes, stores, and manages data according to a data structure. Databases in the prior art mainly include a relational database and a non-relational database, wherein the relational database mainly includes Oracle, sybase, mysql, DB2, and SqlServer. The database-like protocols described herein are primarily directed to these relational databases.
The existing operation and maintenance auditing products can be generally divided into two modes when supporting database protocol operation and maintenance, 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 client tools for installing database protocols locally, such as PLSQL, winSQL, mysqclient and the like, and the operation and maintenance is connected to an agent program of an operation and maintenance audit product through the client tools and then is connected to a target database server through the agent program. The method requires a user to install different database clients on the local computer, occupies space and consumes memory, and most of the method does not adopt audit video.
The database client tool is installed on a single device through a hosting center operation and maintenance, the device is called a hosting center, then the remote desktop function of remoteAPP is utilized to be connected to the hosting center from the local device, the client tool installed on the hosting center is opened, and the client tool is connected to the target database server. The method does not need to install various client tools on the local computer and supports the video audit function. However, this method needs to use mstsc on the Windows system by means of the native RDP client, and different Windows versions, different versions of mstsc are used, and the mstsc of various versions needs to be adapted. In addition, a trusteeship center operation and maintenance mode is not supported on the Linux system at present.
Disclosure of Invention
An object of the present application is to provide a method and a device for operation and maintenance of 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 be adapted with multi-version 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 application, a method for operation and maintenance of a database protocol is provided, and the method comprises the following steps:
establishing connection between a webpage server and an operation and maintenance auditing module through a page operation and maintenance agent, and establishing connection between the webpage server and a hosting center through an operation and maintenance auditing module loading a remote connection protocol;
opening a corresponding database client tool based on parameter information sent by a web server so as to establish connection between the web server and a database;
acquiring a remote connection protocol data stream based on a webpage server, and carrying out protocol analysis on the remote connection protocol data stream through the webpage server to obtain an operation and maintenance picture;
and acquiring operation and maintenance operation based on the webpage server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the webpage operation and maintenance agent and the operation and maintenance auditing module, and finishing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation.
Optionally, the establishing a connection between the web server and the operation and maintenance auditing module through the page operation and maintenance agent includes:
acquiring initial parameters from a webpage server, and adding a path and related parameters of a hosting center main control program in the initial parameters to obtain the parameter information, wherein the initial parameters comprise an IP address, port information, user account information, password information and an operation and maintenance protocol of target equipment;
and sending the parameter information to the page operation and maintenance agent, and establishing the connection relation between the webpage server and the operation and maintenance auditing module through the page operation and maintenance agent.
Optionally, the establishing a connection between the web server and a hosting center through an operation and maintenance auditing module loading a remote connection protocol includes:
analyzing the parameter information through the operation and maintenance auditing module to determine an analysis result;
and loading a remote connection protocol through the operation and maintenance auditing 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 to enable the web server to establish a connection with the database includes:
acquiring parameter information sent by a webpage server, and starting a master 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 webpage 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 performing protocol analysis on the remote connection protocol data stream by the web server to obtain an operation and maintenance picture, the method includes:
and displaying the operation and maintenance picture in a browser.
According to another aspect of the present application, there is also provided an apparatus for database protocol operation and maintenance, the apparatus including:
the first connection module is used for establishing connection between the webpage server and the operation and maintenance auditing module through the page operation and maintenance agent and establishing connection between the webpage server and the hosting center through the operation and maintenance auditing module loading the 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 as to establish connection between the web server and the database;
the data analysis module is used for acquiring a remote connection protocol data stream based on a webpage server and carrying out protocol analysis on the remote connection protocol data stream through the webpage server to obtain an operation and maintenance picture;
and the data processing module is used for 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 finishing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operations. According to yet another aspect of the application, there is also provided a computer readable medium having computer readable instructions stored thereon, the computer readable instructions being executable by a processor to implement the method of any of the preceding claims.
According to another aspect of the present application, there is also provided an apparatus for operation and maintenance of a database protocol, the apparatus including:
one or more processors; and
a memory having computer readable instructions stored thereon that, when executed, cause the processor to perform the operations of any of the preceding methods.
Compared with the prior art, the method has the advantages that the webpage server is connected with the operation and maintenance auditing module through the webpage operation and maintenance agent, and the webpage server is connected with the hosting center through the operation and maintenance auditing module loading the remote connection protocol; opening a corresponding database client tool based on parameter information sent by a web server so as to establish connection between the web server and a database; acquiring a remote connection protocol data stream based on a webpage server, and carrying out protocol analysis on the remote connection protocol data stream through the webpage server to obtain an operation and maintenance picture; and acquiring operation and maintenance operation based on the webpage server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the webpage operation and maintenance agent and the operation and maintenance auditing module, and finishing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation. Therefore, the operation and maintenance of the database protocol can be realized in the browser under the condition that the operation and maintenance client and the operation and maintenance tool do not need to be installed on the user local machine.
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:
FIG. 1 is a schematic flow chart illustrating a method for database protocol operation and maintenance provided in accordance with an aspect of the present application;
FIG. 2 is a flow chart illustrating a method for database protocol operation and maintenance according to an alternative embodiment of the present application;
FIG. 3 illustrates an apparatus framework architecture diagram for database protocol operations and maintenance according to another aspect of the subject application.
The same or similar reference numbers in the drawings identify the same or similar elements.
Detailed Description
The present application is described in further detail below with reference to the attached drawing figures.
In a typical configuration of the present application, the terminal, the device serving the network, and the trusted party each include one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both permanent and non-permanent, removable and non-removable media, may implement the 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 computer storage media 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 Disks (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic 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. As defined herein, computer readable media does not include non-transitory computer readable media (transient media), such as modulated data signals and carrier waves.
The current database type protocol operation and maintenance needs to install a client tool of the database type protocol locally or install the database client tool on a single device by means of a local RDP client. According to the method, the user does not need any client tool on the local computer, and only needs the browser of the client to support the page protocol.
Fig. 1 is a schematic flow chart illustrating a method for database protocol operation and maintenance, according to an aspect of the present application, the method includes: step S100-step S400, wherein in step S100, a webpage server is connected with an operation and maintenance auditing module through a page operation and maintenance agent, and the webpage server is connected with a hosting center through an operation and maintenance auditing module loading 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 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; in S400, an operation and maintenance operation is obtained based on the web server and the operation and maintenance screen, the operation and maintenance operation is transmitted to the hosting center through the page operation and maintenance agent and the operation and maintenance auditing module, and the operation and maintenance processing on a database protocol is completed based on the hosting center according to the operation and maintenance operation. Therefore, the operation and maintenance of the database protocol can be realized in the browser under the condition that the operation and maintenance client and the operation and maintenance tool are not required to be installed in the user local machine.
It should be noted that the step numbers are only used for identifying different steps, and do not represent the execution sequence of the steps.
Specifically, in S100, a web server is connected to an operation and maintenance auditing module through a page operation and maintenance agent, and the web server is connected to a hosting center through an operation and maintenance auditing module for loading a database protocol. The aim is to establish connection between a web page server (web server) and a hosting center, establish connection between a page operation and maintenance agent and an operation and maintenance auditing module, and connect a database protocol loaded by the web page server and the page operation and maintenance agent to the hosting center.
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, is provided with a database client tool, acquires parameter information sent by the web server, and then performs corresponding analysis to obtain a link of the corresponding database client tool, so that the web server is connected with the database.
In S300, a remote connection protocol data stream is obtained based on the 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 obtained 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 obtained by the webpage server and the drawn operation and maintenance picture.
In S400, an operation and maintenance operation is obtained based on the web server and the operation and maintenance screen, the operation and maintenance operation is transmitted to the hosting center through the page operation and maintenance agent and the operation and maintenance auditing module, and the operation and maintenance processing on a database protocol is completed based on the hosting center according to the operation and maintenance operation. The operation and maintenance operation of the user is obtained based on the webpage server and the operation and maintenance picture, the operation and maintenance picture is drawn based on the remote protocol data stream, and after the operation and maintenance operation of the user is obtained, the operation and maintenance operation is transmitted to the hosting center through the proxy protocol and the remote connection protocol and takes effect on an operation and maintenance tool of the hosting center, so that the operation and maintenance processing of the database protocol is completed. Therefore, the operation and maintenance of the database protocol can be realized in the browser under the condition that the operation and maintenance client and the operation and maintenance tool do not need to be installed on the user local machine.
In an optional embodiment of the present application, in S100, an initial parameter is obtained from a web server, and a path and related parameters of a hosting center main control program are added to the initial parameter to obtain the parameter information, where the initial parameter includes an IP address of a target device, port information, user account information, password information, and an operation and maintenance protocol; and sending the parameter information to the page operation and maintenance agent, and establishing the connection relationship between the webpage server and the operation and maintenance auditing module through the page operation and maintenance agent. The path and the related parameters of the host center main control program are added to the initial parameters to obtain parameter information, so that the main control program of the host center analyzes the parameter information to start a corresponding database client tool, the purpose of the operation is to immediately open the database client tool when the main control program is connected to the host center, and the operation is the same as the case that the database client is installed locally, and on the other hand, operation and maintenance personnel can only operate the opened database client tool but cannot operate other applications on the host center. And then, establishing a connection relation between the webpage server and the operation and maintenance auditing module through the page operation and maintenance agent, so that the operation and maintenance auditing module analyzes parameter information and loads a database protocol to connect to a hosting center after the connection between the page operation and maintenance agent and the operation and maintenance auditing module is established.
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 auditing 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. Here, when the page operation and maintenance agent is implemented, a remote desktop protocol (RDP protocol) supporting remoteAPP, such as FreeRDP, is used as a remote connection protocol, and the operation and maintenance auditing module loads the remote desktop protocol, so that when the operation and maintenance of a client-side-free database protocol is implemented, audit video recording can be implemented, a user does not need to install different database clients on a local machine, and occupation of a system space memory is reduced.
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 webpage server to establish connection with a database. The method comprises the steps of obtaining parameter information sent by a webpage server, executing a main control program based on a path and related parameters of a main control program of a hosting center added in the parameter information, executing the main control program at the first time when connection with the hosting center is established due to the remoteAPP function, and opening a corresponding database client tool by the main control program through analyzing the parameter information so that the webpage server is connected with a database, and operation and maintenance of a database protocol without a client are facilitated.
In an optional embodiment of the present application, in S300, the remote connection protocol data stream is converted into a preset format data stream by 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 a text or picture stream and transmits the text or picture stream to the web server through the agent protocol, so that the web server can analyze the protocol and draw operation and maintenance pictures conveniently.
In an optional embodiment of the 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 operation and maintenance screen may be displayed in a browser after the data processing module 400 performs 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, the operation and maintenance of the database protocol are actually realized by means of the RDP protocol and the hosting center, the web server realizes the mstsc function at the moment, the RDP data stream is converted into graphic data and displayed in a browser, and the web server is also responsible for transmitting operation and maintenance operations such as mouse and keyboard actions to the hosting center to achieve the purpose of interaction.
Fig. 2 is a schematic flow chart of a method for operation and maintenance of a database protocol in an optional embodiment of the present application, where the first two parts are cores of operation and maintenance without a client-side page, a web server is responsible for transferring parameters backward, 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 the 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 an operation and maintenance picture is drawn in a browser after a connection is established between the web server and a database. Here, since the parameter information is implemented as a key value pair such as "attribute" in conjunction with "value", it is convenient to add a new parameter. The operation and maintenance of the database protocol actually uses the RDP protocol, after the connection is established, the web server realizes the mstsc function, converts the RDP data stream into graphic data, displays the graphic data in the browser, and simultaneously is responsible for transmitting operation and maintenance operations such as mouse and keyboard actions to a target end to realize the interaction purpose.
In the above embodiment, the page operation and maintenance agent is responsible for loading the protocol, and may support four protocols, namely ssh, telnet, RDP, and VNC, where the protocol is referred to as RDP protocol, because the database operation and maintenance is finally implemented by RDP protocol. The page operation and maintenance agent is used as a client to establish connection with the operation and maintenance auditing system. The web server is combined with the page operation and maintenance agent to respectively serve as an operation and maintenance client and an operation and maintenance tool. It should be noted that, when the page operation and maintenance agent is implemented, it must use RDP protocol supporting remotepapp, such as FreeRDP, otherwise, it cannot implement the operation and maintenance without client database protocol.
And then, after the connection between the page operation and maintenance agent and the operation and maintenance auditing system is established, the operation and maintenance auditing system analyzes the parameters, loads the RDP protocol and connects to the hosting center. Because the remoteAPP function is used, the main control program can be executed at the first time when the mobile terminal is connected to the hosting center, the main control program opens the corresponding database client side tool for connection through parameter analysis, the purpose of doing so is to immediately open the database client side tool when the mobile terminal is connected to the hosting center, and the operation and maintenance personnel can only operate the opened database client side tool and cannot operate other applications on the hosting center. At the moment, the page operation and maintenance agent is connected with the target database, the page operation and maintenance agent converts the protocol data stream into a text or picture stream and transmits the text or picture stream to the web server through the agent protocol, and the web server analyzes the protocol, draws pictures and displays the pictures at a far end. The final operation and maintenance process comprises the following steps: and the operation and maintenance personnel click an operation and maintenance button in the operation and maintenance auditing system, a new tab page is opened in the current browser, the page displays an operation and maintenance picture, the operation and maintenance operation of the operation and maintenance personnel is transmitted to the hosting center through an RDP (remote desktop protocol), and the operation and maintenance of the database protocol is completed based on a client tool of the hosting center. The operation of the mouse and the keyboard on the page by the operation and maintenance personnel can be transmitted to the back end, so that the operation of increasing, deleting, modifying and checking the database is realized. Therefore, the operation and maintenance of the database protocol are realized in the browser under the condition that the operation and maintenance client and the operation and maintenance tool are not required to be installed in the user local machine.
Embodiments of the present application further provide a computer-readable medium, on which computer-readable instructions are stored, where the computer-readable instructions are executable by a processor to implement the foregoing method for database protocol operation and maintenance.
Corresponding to the method described above, the present application also provides a terminal, which includes modules or units capable of executing the method steps described in fig. 1 or fig. 2 or various embodiments, and these 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 also provided an apparatus for database protocol operation and maintenance, where the apparatus includes:
one or more processors; and
a memory having computer readable instructions stored thereon that, when executed, cause the processor to perform the operations of the one database protocol operation and maintenance method described above.
For example, the computer readable instructions, when executed, cause the one or more processors to:
establishing connection between a webpage server and an operation and maintenance auditing module through a page operation and maintenance agent, and establishing connection between the webpage server and a hosting center through an operation and maintenance auditing module loading a remote connection protocol; opening a corresponding database client tool based on parameter information sent by a web server so as to establish connection between the web server and a database; acquiring a remote connection protocol data stream based on a webpage server, and carrying out protocol analysis on the remote connection protocol data stream through the webpage server to obtain an operation and maintenance picture; and acquiring operation and maintenance operation based on the webpage server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the webpage operation and maintenance agent and the operation and maintenance auditing module, and finishing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation.
FIG. 3 is a block diagram of an apparatus framework for database protocol operations and maintenance, according to another aspect of the present application, the apparatus comprising: the first connection module 100 is used for establishing connection between a webpage server and an operation and maintenance auditing module through a page operation and maintenance agent, and establishing connection between the webpage server and a hosting center through the operation and maintenance auditing module loading 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; and the data processing module 400 is configured to obtain an operation and maintenance operation based on the web server and the operation and maintenance screen, transmit the operation and maintenance operation to the hosting center through the page operation and maintenance agent and the operation and maintenance auditing module, and complete operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation. Therefore, the operation and maintenance of the database protocol can be realized in the browser under the condition that the operation and maintenance client and the operation and maintenance tool are not required to be installed in the user local machine.
It should be noted that the content executed by the first connection module 100, the second connection module 200, the data analysis module 300, and the data processing module 400 is respectively the same as or corresponding to the content executed in the above steps S100, S200, S300, and S400, and for the sake of brevity, no further description is repeated here.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.
It should be noted that the present application may be implemented in software and/or a combination of software and hardware, for example, implemented using Application Specific Integrated Circuits (ASICs), general purpose computers or any other similar hardware devices. In one embodiment, the software programs of the present application may be executed by a processor to implement the steps or functions described above. Likewise, the software programs (including associated data structures) of the present application may be stored in a computer readable recording medium, such as RAM memory, magnetic or optical drive or diskette and the like. Further, some of the 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.
Additionally, some portions of the present application may be applied as a computer program product, such as computer program instructions, which, when executed by a computer, may invoke or provide the method and/or solution according to the present application through the operation of the computer. Program instructions which invoke the methods of the present application may be stored on a fixed or removable recording medium and/or transmitted via a data stream on a broadcast or other signal-bearing medium and/or stored within a working memory of a computer device operating in accordance with 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 perform a method and/or a solution according to the aforementioned embodiments of the present application.
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 attributes 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 obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. The terms first, second, etc. are used to denote names, but not any particular order.
Claims (9)
1. A method for database protocol operation, the method comprising:
establishing connection between a webpage server and an operation and maintenance auditing module through a page operation and maintenance agent, and establishing connection between the webpage 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 the parameter information sent by the web server so as to establish connection between the web server and the database;
acquiring a remote connection protocol data stream based on a webpage server, and carrying out protocol analysis on the remote connection protocol data stream through the webpage server to obtain an operation and maintenance picture;
and acquiring operation and maintenance operation based on the webpage server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the webpage operation and maintenance agent and the operation and maintenance auditing module, and finishing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation.
2. The method of claim 1, wherein the connecting the web server with the operation and maintenance auditing module through the page operation and maintenance agent comprises:
acquiring initial parameters from a webpage server, and adding a path and related parameters of a hosting center main control program in the initial parameters to obtain parameter information, wherein the initial parameters comprise an IP address, port information, user account information, password information and an operation and maintenance protocol of target equipment;
and sending the parameter information to the page operation and maintenance agent, and establishing the connection relation between the webpage server and the operation and maintenance auditing module through the page operation and maintenance agent.
3. The method of claim 2, wherein the connecting the web server with a hosting center through an operation and maintenance auditing module loading a remote connection protocol comprises:
analyzing the parameter information through the operation and maintenance auditing module to determine an analysis result;
and loading a remote connection protocol through the operation and maintenance auditing 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 of claim 2, wherein opening a corresponding database client tool based on the parameter information sent by the web server to enable the web server to establish a connection with the database comprises:
acquiring parameter information sent by a webpage server, and starting a master 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 webpage server to establish connection with a database.
5. The method of claim 1, wherein the performing protocol parsing on the remote connection protocol data stream by the web server to obtain an operation and maintenance screen comprises:
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 character data stream or a picture data stream.
6. The method according to claim 1, wherein after the performing protocol parsing on the remote connection protocol data stream by the web server to obtain an operation and maintenance screen, the method comprises:
and displaying the operation and maintenance picture in a browser.
7. An apparatus for database protocol operation, the apparatus comprising:
the first connection module is used for establishing connection between the webpage server and the operation and maintenance auditing module through the page operation and maintenance agent and establishing connection between the webpage server and the hosting center through the operation and maintenance auditing module loading the 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 as to establish connection between the web server and the database;
the data analysis module is used for acquiring a remote connection protocol data stream based on a webpage server and carrying out protocol analysis on the remote connection protocol data stream through the webpage server to obtain an operation and maintenance picture;
and the data processing module is used for acquiring operation and maintenance operation based on the webpage server and the operation and maintenance picture, transmitting the operation and maintenance operation to the hosting center through the webpage operation and maintenance agent and the operation and maintenance auditing module, and finishing operation and maintenance processing on a database protocol based on the hosting center according to the operation and maintenance operation.
8. A computer readable medium having computer readable instructions stored thereon which are executable by a processor to implement the method of any one of claims 1 to 6.
9. An apparatus for database protocol operation, the apparatus comprising:
one or more processors; and
memory storing computer readable instructions that, when executed, cause the processor to perform the operations of the method of any of claims 1 to 6.
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 true CN115277657A (en) | 2022-11-01 |
| CN115277657B 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) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116743728A (en) * | 2023-08-11 | 2023-09-12 | 深圳竹云科技股份有限公司 | Application operation and maintenance method, system, equipment and storage medium |
Citations (17)
| 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 |
| US20020026507A1 (en) * | 2000-08-30 | 2002-02-28 | Sears Brent C. | Browser proxy client application service provider (ASP) interface |
| 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 |
| US20170046013A1 (en) * | 2015-08-14 | 2017-02-16 | Microsoft Technology Licensing, Llc | Web-browser based desktop and application remoting solution |
| 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 |
-
2022
- 2022-05-30 CN CN202210602776.5A patent/CN115277657B/en active Active
Patent Citations (17)
| 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 |
| US20020026507A1 (en) * | 2000-08-30 | 2002-02-28 | Sears Brent C. | Browser proxy client application service provider (ASP) interface |
| 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 |
| US20170046013A1 (en) * | 2015-08-14 | 2017-02-16 | Microsoft Technology Licensing, Llc | Web-browser based desktop and application remoting solution |
| 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 |
|---|
| 吴耀芳;来学嘉;: "基于应用代理的运维堡垒机研究", 微型电脑应用, no. 08 * |
| 苏林萍;安然;李为;崔文超;张晓良;: "基于Hadoop的电力运维审计系统的设计", 计算机与现代化, no. 01 * |
| 范平平;: "云应用引擎技术的研究与策略", 科技视界, no. 28 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116743728A (en) * | 2023-08-11 | 2023-09-12 | 深圳竹云科技股份有限公司 | Application operation and maintenance method, system, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115277657B (en) | 2023-06-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8321450B2 (en) | Standardized database connectivity support for an event processing server in an embedded context | |
| US8387076B2 (en) | Standardized database connectivity support for an event processing server | |
| US9037555B2 (en) | Asynchronous collection and correlation of trace and communications event data | |
| US8060863B2 (en) | Conformance control module | |
| US20080133617A1 (en) | Change log handler for synchronzing data sources | |
| US9747353B2 (en) | Database content publisher | |
| CN108470302B (en) | Interaction method and device of client and server | |
| US9654576B2 (en) | Database triggered push notification | |
| US20040193644A1 (en) | Exposing a report as a schematized queryable data source | |
| CN115277657B (en) | Method and equipment for operating and maintaining database protocol | |
| CN112671876B (en) | Method and equipment for page operation and maintenance | |
| JP2019125330A (en) | System and protocol for integrating service providers for different fields, using platform | |
| US9258311B2 (en) | Virtual federation of remote portals | |
| CN111143310B (en) | Log recording method and device and readable storage medium | |
| CN112202598B (en) | Log recording method and device | |
| US20060155817A1 (en) | Web services integration systems and methods | |
| CN114219643A (en) | Transaction calling method, device, equipment and storage medium | |
| US7617482B2 (en) | Method, system and program product for implementing java server page (JSP) containers as java server faces (JSF) components | |
| US20210176335A1 (en) | Platform for multi-stream sampling and visualization | |
| WO2023230797A1 (en) | Cross-system test method and apparatus | |
| CN114996345B (en) | Online service combination method based on OGC network processing service | |
| US11966719B2 (en) | Event consumption for high-level programing language platform | |
| US20240036831A1 (en) | An extensible binding mechanism for translating between application programming interface description languages | |
| US20240036830A1 (en) | Event consumption for high-level programing language platform | |
| US11755681B2 (en) | Real-time equivalent user interaction generation |
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 |