虚谷数据库v12.9安装测试

多年前用过他们的产品，无意看到他们在微信公众号上教怎么快速上手，自以为凭旧经验可以轻松搞定，想简单了。

首先到官网https://xugudb.com/的软件下载栏目下载安装包，无需注册用户，这点需要表扬。

wget https://download.xugudb.com/v12.9.10/XuguDB-12.0.0-linux-aarch64-20250731-1209010.zip

进入kylin Linux控制台，解压缩到/shujv/par目录下
执行报错

/shujv/par/XuguDB/Server/BIN$ ./xugu_linux_aarch64_20250731 –child
./xugu_linux_aarch64_20250731: error while loading shared libraries: libcrypto.so.1.1: cannot open shared object file: No such file or directory

用ldd检查缺少不止一个动态库

/shujv/par/XuguDB/Server/BIN$ ldd ./xugu_linux_aarch64_20250731
./xugu_linux_aarch64_20250731: /lib/aarch64-linux-gnu/libm.so.6: version `GLIBC_2.27' not found (required by ./xugu_linux_aarch64_20250731)
./xugu_linux_aarch64_20250731: /lib/aarch64-linux-gnu/libc.so.6: version `GLIBC_2.28' not found (required by ./xugu_linux_aarch64_20250731)
linux-vdso.so.1 => (0x0000007fa5f96000)
/usr/lib/libzfh.so (0x0000007fa5efc000)
libpthread.so.0 => /lib/aarch64-linux-gnu/libpthread.so.0 (0x0000007fa5eb1000)
librt.so.1 => /lib/aarch64-linux-gnu/librt.so.1 (0x0000007fa5e9a000)
libaio.so.1 => /lib/aarch64-linux-gnu/libaio.so.1 (0x0000007fa5e88000)
libdl.so.2 => /lib/aarch64-linux-gnu/libdl.so.2 (0x0000007fa5e75000)
libcrypto.so.1.1 => not found

缺少高版本glibc，如果贸然升级就会把系统瘫痪掉，以前有过惨痛的经验，最后只能重装系统。那就用docker容器，我用的gcc官方容器，glibc的版本应该有保证。
执行仍然报错，这次是缺libaio.so.1。连ldd执行都出错。

/shujv/par/XuguDB/Server/BIN$ sudo docker exec -it gcc bash

/par/XuguDB/Server/BIN# ./xugu_linux_aarch64_20250731 –child
./xugu_linux_aarch64_20250731: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

/par/XuguDB/Server/BIN# ldd ./xugu_linux_aarch64_20250731
ldd: error: you do not have read permission for `./xugu_linux_aarch64_20250731'

先不管它，因为我的apt install功能不正常，所以手工在网上找deb安装包，在https://debian.pkgs.org/12/debian-main-arm64/libaio1_0.3.113-4_arm64.deb.html上搜到，下载一个装上

wget http://ftp.de.debian.org/debian/pool/main/liba/libaio/libaio1_0.3.113-4_arm64.deb

dpkg -i libaio1_0.3.113-4_arm64.deb
Selecting previously unselected package libaio1:arm64.
(Reading database ... 23430 files and directories currently installed.)
Preparing to unpack libaio1_0.3.113-4_arm64.deb ...
Unpacking libaio1:arm64 (0.3.113-4) ...
Setting up libaio1:arm64 (0.3.113-4) ...
Processing triggers for libc-bin (2.36-9+deb12u9) ...

执行说还缺一个动态库，其实就是kylin Linux下提示的libcrypto.so

/par/XuguDB/Server/BIN# ./xugu_linux_aarch64_20250731 –child
./xugu_linux_aarch64_20250731: error while loading shared libraries: libcrypto.so.1.1: cannot open shared object file: No such file or directory

再次在上述网站找了一个不能用，说依赖GLIBC_2.38，这个容器都没有，那真没招了。

wget https://eu.mirror.archlinuxarm.org/aarch64/core/openssl-1.1-1.1.1.w-2-aarch64.pkg.tar.xz
/par/XuguDB/Server/BIN# tar xf openssl-1.1-1.1.1.w-2-aarch64.pkg.tar.xz

/par/XuguDB/Server/BIN/usr/lib# ls
libcrypto.so.1.1 libssl.so.1.1 openssl-1.1
/par/XuguDB/Server/BIN/usr/lib# export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/par/XuguDB/Server/BIN/usr/lib

/par/XuguDB/Server/BIN# ./xugu_linux_aarch64_20250731 –child
./xugu_linux_aarch64_20250731: /lib/aarch64-linux-gnu/libc.so.6: version `GLIBC_2.38' not found (required by /par/XuguDB/Server/BIN/usr/lib/libcrypto.so.1.1)

只好回到官网，老老实实看文档，https://docs.xugudb.com/content/deployment/requirement 中提到

虚谷数据库自V12.8.5版本起（之前版本不受影响），运行依赖于OpenSSL，请在安装部署前配置正确版本的OpenSSL。
OpenSSL 1.1.0到1.1.1w的任意版本均可，OpenSSL 1.1.1* 是LTS版本，推荐优先使用。
OpenSSL 1.1.0以下版本和OpenSSL 3.0.0以上版本，均无法使用。

巧的是，pkgs.org也是在线文档推荐的方法。但是还有一个我不知道，https://ftp.debian.org/debian/pool/main/o/openssl/，其实就是刚才下载libaio.so.1安装包的同一个网站，它可以列出目录中的文件。按照上述提示，我下载了libssl1.1_1.1.1w，装上，服务器就能起来了

wget https://ftp.debian.org/debian/pool/main/o/openssl/libssl1.1_1.1.1w-0+deb11u1_arm64.deb

/par/XuguDB/Server/BIN# dpkg -i libssl1.1_1.1.1w-0+deb11u1_arm64.deb
Selecting previously unselected package libssl1.1:arm64.
(Reading database ... 23436 files and directories currently installed.)
Preparing to unpack libssl1.1_1.1.1w-0+deb11u1_arm64.deb ...
Unpacking libssl1.1:arm64 (1.1.1w-0+deb11u1) ...
Setting up libssl1.1:arm64 (1.1.1w-0+deb11u1) ...
debconf: unable to initialize frontend: Dialog
debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 78.)
debconf: falling back to frontend: Readline
Processing triggers for libc-bin (2.36-9+deb12u9) ...
/par/XuguDB/Server/BIN# ./xugu_linux_aarch64_20250731 –child
XuguDB 12.0.0 (Built:2025-07-31 12:00:00 GA)
Start at: 2025-08-13 09:15:01
database server PID=88
CPU info:
Node 0: 0 1 2 3 4 5 6 7
Resource limit:
File number: hard limit=1048576,soft limit=1048576
File size(M): hard limit=-1,soft limit=-1
Data memory(M): hard limit=-1,soft limit=-1
Resident(M): hard limit=-1,soft limit=-1
Proc's total memory(M): hard limit=-1,soft limit=-1
Open file cluster.ini failed.
Loading license ... failed!
init data buffer...ok.
Perform control file checksum...ok.
Trial Edition,remain 360 days
Mount all gstore...ok.
Open all system tables...ok
Create system database...ok.
Open all system views...ok
Load all jobs...ok
All service started.
Listening at port 5138

首次的启动过程有点长，因为它要建表空间，初始化，一个小小的20MB服务器文件就建立了1GB的空间。
服务器开始监听后，打开另一个终端，按照文档https://docs.xugudb.com/content/client-tool/xgconsole 的提示，输出命令行参数：

sudo docker exec -it gcc bash

/par/XuguDB/Client/xgconsole/xgconsole -s nssl -h 127.0.0.1 -P 5138 -d SYSTEM -u SYSDBA -p SYSDBA

XuguDB Linux Console GA V2.2.7

Copyright (c) 2002-2025 XuGuWeiYe Technologies Co., Ltd. All rights reserved.

Connect to 127.0.0.1:5138 SYSTEM SYSDBA. Connect ok.

SQL> select * from dual;

+—-+
| ID |
+—-+
| 1 |
+—-+

(1 row)
Use time:16 ms.

连接服务器成功，可以愉快地使用了。

我记得虚谷数据库网站以前有pdf文档，可以线下查看，希望能重新提供。