Taking NTU general as an example, let’s talk about how to complete the compatibility verification with the dragon lizard operating system

Time:2022-5-5

Dragon lizard community adheres to openness and cooperation and continues to build an ecological certification system for software and hardware. You can safely use the verified application on the dragon lizard operating system (Anolis OS). Recently, dragon lizard community and NTU general gbase have completed product compatibility and mutual certification, and the verification results show that the product function is normal. Taking this as an example, this paper introduces how to quickly complete the verification.

The following are the specific steps of NTU general gbase 8A compatibility verification.

preparation

1. Version information

  • Anolis 7.7 anck 64 bit
  • GBase8a-NoLicense-Free-8.6.2_ build43-R7-redhat7. 3-x86_ 64 (Note: Note: this binary version is a version compiled based on RedHat 7.3 downloaded from the official website of NTU general. We run this version on Anolis OS 7.7 to verify the basic functional compatibility)

2. Supported architectures

  • x86_64

3. Resource preparation

  • 8-core 32g OS
  • Gbase 8A database installation package (gbase8a-nolicense-free-8.6.2_build43-r7-redhat7.3-x86_64.tar.bz2, you can apply for trial on the official website of NTU general database (see the link at the end of the text))

Step 1: installation

1. Create user gbase, and subsequent operations are carried out under gbase user.

useradd -m gbase
su - gbase

2. Assuming that the installation package has been placed under the / home / gbase directory, unzip the data to the / home / gbase / install directory.

mkdir ~/install
tar -xjvf GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64.tar.bz2 -C ~/install/

3. Execute the command to install.

cd install/GBaseInstall/
./Install_lin.shd
#When prompted as follows, enter yes to accept the license to continue the installation

*********************************************************************************
Thank you for choosing GBase product!

Please read carefully the following licencing agreement before installing any product:

Disclaimer of Product Trial License:
1. Any user who tries out (including self-downloaded trial or trial version provided by General Data Technology Co., Ltd) General Data Technology Co., Ltd Software Products should read this statement carefully. Users may choose not to try Nanda General Software Products. The user's tries out General Data Technology Co., Ltd Software Products will be deemed to be an endorsement of the full content of this statement.
2. Universal software products of General Data Technology Co., Ltd have complete autonomous knowledge rights and do not infringe on the relevant rights and interests of any other unit or individual. Universal software products of General Data Technology Co., Ltd are protected by law. Any transfer, reproduction, dissemination or use in unauthorized projects are strictly prohibited without the written permission of Universal of Nanda. Otherwise, the infringer will bear full responsibility.
3. Except for the terms of service specified by General Data Technology Co., Ltd, General Data Technology Co., Ltd is not liable or liable for any accident, negligence, contract destruction, defamation, copyright or intellectual property infringement caused by the trial use of General Data Technology Co., Ltd software products and any losses (including virus infection due to downloading).
4. The relevant information of General Data Technology Co., Ltd Software Products is the original information released. If there are any changes, no further notice will be given. Software may run differently from the final version, and features and functions in pre-release software may not appear in the final version. The risk of trying out the software should be borne by you.
5. Users assume their own risks for the trial of General Data Technology Co., Ltd Software Products. General Data Technology Co., Ltd does not guarantee any form of guarantee, does not guarantee that the trial products meet the user's requirements, does not guarantee that the trial service is uninterrupted, and does not guarantee the safety of the trial products. Due to any technical reasons such as network status, communication lines and so on, users can not normally try out General Data Technology Co., Ltd Products, or the impact or loss on third parties in the process of trial, General Data Technology Co., Ltd does not bear any legal liability.
6. General Data Technology Co., Ltd respects and protects the personal privacy rights of all users who try out General Data Technology Co., Ltd Products. Without the personal permission of users or mandatory provisions of relevant laws, General Data Technology Co., Ltd will not voluntarily disclose other third parties.
7. Any unit or individual who considers that General Data Technology Co., Ltd Software products may be suspected of infringing on its legitimate rights and interests should promptly give written feedback to General Data Technology Co., Ltd or its service website, and provide identity certificates, ownership certificates and detailed tort proof. After receiving the verification of the above-mentioned legal documents, General Data Technology Co., Ltd l will make corresponding treatment as soon as possible.
8. General Data Technology Co., Ltd Corporation has the final right to interpret General Data Technology Co., Ltd Products and this statement.
*********************************************************************************
Do you accept the above licence agreement (Yes/No, default=No) ?
Yes

*********************************************************************************
                     Welcome to install GBase products
*********************************************************************************
Please input the GBase software installation directory (Default:/home/gbase/GBase):


Installing all software packages ...

Software packages installation done.

*********************************************************************************
                  Welcome to create GBase database instance
*********************************************************************************
Please input the new database instance name (default: gbase8a):


Please input the port number for the new database instance (default:5258):

GBase is creating the New 'gbase8a' instance ...

hostkey: 2bc385b******
The host key file is genarate at GBASE_BASE/config/gbase_host.cnf.


Congratulations.  Your GBase installation is successful.

Please execute $source ~/.bashrc manually on the first run.

Please refer to the product's manuals and readme.txt to start using GBase product.

Click enter all the way to use the default configuration. Gbase software will be installed in the / home / gbase directory, and a database instance of gbase 8A will be created. The default service port of the instance is 5258. Execute source to load environment variables.

source ~/.bashrc

4. Start the database service.

gbase.server start

#You can see the following output
# Starting GBase. SUCCESS!

Step 2: Test

1. Log in to the database through the following command.

gbase -uroot

If there is no problem with the installation, we can log in to the database smoothly.

GBase client Free Edition 8.6.2.43-R7-free.110605. Copyright (c) 2004-2021, GBase.  All Rights Reserved.

gbase>

2. Display database.

gbase> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
| gbase              |
| gclusterdb         |
| gctmpdb            |
+--------------------+
5 rows in set (Elapsed: 00:00:00.00)

gbase>

3. Create test dB.

gbase> create database test;
Query OK, 1 row affected (Elapsed: 00:00:00.00)

gbase> use test;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase>

4. Create a table.

gbase> create table hola(bonj text);
Query OK, 0 rows affected (Elapsed: 00:00:00.01)

gbase>

5. Insert data.

gbase> insert into test.hola(bonj) values('Mundo');
Query OK, 1 row affected (Elapsed: 00:00:00.01)

gbase> insert into test.hola(bonj) values('Lundo');
Query OK, 1 row affected (Elapsed: 00:00:00.01)

gbase> insert into test.hola(bonj) values('Nundo');
Query OK, 1 row affected (Elapsed: 00:00:00.00)

gbase> select * from test.hola;
+-------+
| bonj  |
+-------+
| Mundo |
| Lundo |
| Nundo |
+-------+
3 rows in set (Elapsed: 00:00:00.00)

gbase>

6. Update data.

gbase> select * from test.hola;
+-------+
| bonj  |
+-------+
| Mundo |
| Lundo |
| Nundo |
+-------+
3 rows in set (Elapsed: 00:00:00.00)

gbase> update test.hola set bonj='Xundo' where bonj='Mundo';
Query OK, 1 row affected (Elapsed: 00:00:00.01)
Rows matched: 1  Changed: 1  Warnings: 0

gbase> select * from test.hola;
+-------+
| bonj  |
+-------+
| Xundo |
| Lundo |
| Nundo |
+-------+
3 rows in set (Elapsed: 00:00:00.00)

gbase>

7. Query data.

gbase> select * from test.hola;
+-------+
| bonj  |
+-------+
| Xundo |
| Lundo |
| Nundo |
+-------+
3 rows in set (Elapsed: 00:00:00.00)

gbase>

8. Delete data.

gbase> delete from test.hola where bonj='Xundo';
Query OK, 1 row affected (Elapsed: 00:00:00.00)

gbase> select * from test.hola;
+-------+
| bonj  |
+-------+
| Lundo |
| Nundo |
+-------+
2 rows in set (Elapsed: 00:00:00.00)

gbase>

9. Exit SQL.

gbase> exit
Bye

The above is the introduction of NTU universal gbase 8A compatibility verification. You are welcome to verify the adaptation. If you need verification, please contact: Chen Jia[email protected]

The follow-up community will provide online certification process, which is more efficient and transparent. Please look forward to it!

NTU general official website:http://www.gbase8a.com/Topic/173

Welcome more developers to join the software compatibility sig:

https://openanolis.cn/sig/thi…

Mailing list:[email protected]

——Finish——