gs_preinstall

背景信息

MogDB提供了gs_preinstall工具来帮助完成MogDB的环境配置，以保证MogDB安装的正常进行。

注意事项

用户需要检查上层目录权限，保证安装用户对安装包和配置文件目录读写执行的权限。
xml文件中各主机的名称与IP映射配置正确。
只能使用root用户执行gs_preinstall命令。
执行gs_preinstall会清理/etc/hosts中的MogDB映射信息，可能存在已部署数据库连接丢失风险，可以在安装结束后手动添加其它数据库映射至/etc/hosts文件中。
本产品支持同一操作系统大版本下的小版本混合部署，其支持列表如下：
```
CentOS 6.4/6.5/6.6/6.7/6.8/6.9
CentOS 7.0/7.1/7.2/7.3/7.4
openEuler
```

语法

准备MogDB环境

gs_preinstall -U USER -G GROUP -X XMLFILE [-L] [--skip-os-set] [--env-var="ENVVAR" [...]] [--sep-env-file=MPPRCFILE] [--skip-hostname-set] [-l LOGFILE] [--non-interactive]

显示帮助信息
```
gs_preinstall -? | --help
```
显示版本号信息
```
gs_preinstall -V | --version
```

参数说明

-U

运行MogDB的操作系统用户名。

取值范围: 字符串，要符合标识符的命名规范。

说明: 配置-U参数值时，字符串中不能包含“|”、“;”、“&”、“$”、“<”、“>”、“`”、“\”、“'”、“\”、“{”、“}”、“(”、“)”、“[”、“]”、“~”、“*”、“?”特殊字符。
-G

运行MogDB的操作系统用户的群组名。

取值范围: 字符串，要符合标识符的命名规范。
-X

MogDB配置文件路径。

取值范围: xml文件的存储路径。
-L

指定该参数则仅给当前节点准备好MogDB安装环境。适用于不允许使用root互信的场景和设置安全加固参数PermitRootLogin为no的场景。需要满足如下前提条件：
1. 安装包和MogDB配置文件已提前上传到所有主机；
2. MogDB安装用户已提前创建好并建立好互信关系；
3. 用户需要自己保证各台主机上所执行命令的一致性；
4. 手动将所有节点的主机名和ip映射关系写入各个主机的/etc/hosts，并在每个映射关系后边加入注释内容：#Gauss OM IP Hosts Mapping。
--skip-os-set

是否设置操作系统参数。默认设置系统参数。如果指定该参数则不设置。
--env-var=“ENVVAR”

配置普通用户环境变量。可以指定多个。

取值范围: 字符串。

说明: 本参数不能指定为MogDB默认创建的环境变量。否则，MogDB的环境变量将被覆盖。MogDB默认创建的环境变量见表1。
--sep-env-file=MPPRCFILE

保存环境变量的文件。如果指定该参数，表示将使用环境变量分离的版本。

说明: 不能指定环境变量文件为MogDB相关目录或者和这些目录同名，不能和MogDB用户的目录相同。

在执行gs_preinstall时若是指定--sep-env-file=/home/omm/envfile，需要到omm用户下先执行source /home/omm/envfile，否则环境变量不会生效。执行gs_preinstall成功之后，切换到omm用户下执行gs_install时若遇到如下报错，建议执行source /home/omm/envfile
```
[GAUSS-51402]: Failed to generate certs.openssl rand -base64 12 | tr "[0-9][a-z]" "[A-Z]" | tr -d [/+=] |cut -c 1-3
```
--skip-hostname-set

是否将xml配置文件中主机名与IP的映射关系写入“/etc/hosts”文件中。默认写入，如果指定该参数则不写入。
-l

指定日志文件名及路径。在内部会自动给日志名添加一个时间戳。

默认值：/var/log/mogdb/用户名/om/gs_preinstall.log

当不明确指定-l，但在XML文件中配置了gaussdbLogPath时，默认值为gaussdbLogPath的值、用户名和om/gs_preinstall-YYYY-MM-DD_hhmmss.log的组合。
--non-interactive

指定前置执行模式。
- 当不指定该参数时，则为安全交互模式，在此模式下用户需要人机交互输入密码。
- 当指定该参数时，为非交互模式，不需要进行人机交互。
-?, --help

显示帮助信息。

-V, --version

显示版本号信息。

表 1 MogDB默认创建的环境变量

环境变量名称	说明
MPPDB_ENV_SEPARATE_PATH	MogDB环境变量分离文件路径
GPHOME	MogDB工具目录
PATH	MogDB工具脚本目录
LD_LIBRARY_PATH	MogDB引用第三方动态库路径
PYTHONPATH	python软件路径
GAUSS_WARNING_TYPE	告警类型
GAUSSHOME	MogDB安装路径
GAUSS_VERSION	MogDB版本号
PGHOST	MogDB用户的临时目录路径
GS_CLUSTER_NAME	MogDB名称
GAUSSLOG	MogDB日志路径
GAUSS_ENV	MogDB环境变量标识

手动设置服务端SYSLOG配置

设置“/etc/syslog-ng/syslog-ng.conf”文件，在文件中添加如下内容：

template t_gaussdb {template("$DATE $SOURCEIP $MSGONLY\n");template_escape(no);};
source s_gaussdb{ udp(); };
filter f_gaussdb    { level(err,  crit) and match('GaussDB'); };
destination d_gaussdb { file("/var/log/syslog_MPPDB", template(t_gaussdb)); };
log { source(s_gaussdb); filter(f_gaussdb); destination(d_gaussdb); };

设置“/etc/sysconfig/syslog”文件，在文件中添加如下内容：

SYSLOGD_OPTIONS="-r -m 0"
KLOGD_OPTIONS="-x"

说明: 该配置需要在MogDB每台机器上都要修改。

示例

使用非交互方式进行MogDB环境准备：

./gs_preinstall -U omm -G dbgrp -X /opt/software/MogDB/clusterconfig.xml --non-interactive
Parsing the configuration file.
Successfully parsed the configuration file.
Installing the tools on the local node.
Successfully installed the tools on the local node.
Distributing package.
Successfully distributed package.
Installing the tools in the cluster.
Successfully installed the tools in the cluster.
Checking hostname mapping.
Successfully checked hostname mapping.
Checking OS version.
Successfully checked OS version.
Creating cluster's path.
Successfully created cluster's path.
Set and check OS parameter.
Setting OS parameters.
Successfully set OS parameters.
Warning: Installation environment contains some warning messages.
Please get more details by "/package_r8/sudo/gs_checkos -i A -h host179174,host179175,host179176".
Set and check OS parameter completed.
Preparing CRON service.
Successfully prepared CRON service.
Preparing SSH service.
Successfully prepared SSH service.
Setting user environmental variables.
Successfully set user environmental variables.
Configuring alarms on the cluster nodes.
Successfully configured alarms on the cluster nodes.
Setting the dynamic link library.
Successfully set the dynamic link library.
Setting finish flag.
Successfully set finish flag.
Preinstallation succeeded.

使用交互模式进行MogDB环境准备：

./gs_preinstall -U omm -G dbgrp -X /opt/software/MogDB/clusterconfig.xml
Parsing the configuration file.
Successfully parsed the configuration file.
Installing the tools on the local node.
Successfully installed the tools on the local node.
Are you sure you want to create trust for root (yes/no)? yes
Please enter password for root.
Password:
Creating SSH trust for the root permission user.
Please enter password for current user[root].
Password:
Checking network information.
All nodes in the network are Normal.
Successfully checked network information.
Creating SSH trust.
Creating the local key file.
Successfully created the local key files.
Appending local ID to authorized_keys.
Successfully appended local ID to authorized_keys.
Updating the known_hosts file.
Successfully updated the known_hosts file.
Appending authorized_key on the remote node.
Successfully appended authorized_key on all remote node.
Checking common authentication file content.
Successfully checked common authentication content.
Distributing SSH trust file to all node.
Successfully distributed SSH trust file to all node.
Verifying SSH trust on all hosts.
Successfully verified SSH trust on all hosts.
Successfully created SSH trust.
Successfully created SSH trust for the root permission user.
Distributing package.
Successfully distributed package.
Are you sure you want to create the user[omm] and create trust for it (yes/no)? yes
Please enter password for cluster user.
Password:
Please enter password for cluster user again.
Password:
Creating [omm] user on all nodes.
Successfully created [omm] user on all nodes.
Installing the tools in the cluster.
Successfully installed the tools in the cluster.
Checking hostname mapping.
Successfully checked hostname mapping.
Creating SSH trust for [omm] user.
Please enter password for current user[omm].
Password:
Checking network information.
All nodes in the network are Normal.
Successfully checked network information.
Creating SSH trust.
Creating the local key file.
Successfully created the local key files.
Appending local ID to authorized_keys.
Successfully appended local ID to authorized_keys.
Updating the known_hosts file.
Successfully updated the known_hosts file.
Appending authorized_key on the remote node.
Successfully appended authorized_key on all remote node.
Checking common authentication file content.
Successfully checked common authentication content.
Distributing SSH trust file to all node.
Successfully distributed SSH trust file to all node.
Verifying SSH trust on all hosts.
Successfully verified SSH trust on all hosts.
Successfully created SSH trust.
Successfully created SSH trust for [omm] user.
Checking OS version.
Successfully checked OS version.
Creating cluster's path.
Successfully created cluster's path.
Set and check OS parameter.
Setting OS parameters.
Successfully set OS parameters.
Warning: Installation environment contains some warning messages.
Please get more details by "/package_r8/sudo/gs_checkos -i A -h host179174,host179175,host179176".
Set and check OS parameter completed.
Preparing CRON service.
Successfully prepared CRON service.
Preparing SSH service.
Successfully prepared SSH service.
Setting user environmental variables.
Successfully set user environmental variables.
Configuring alarms on the cluster nodes.
Successfully configured alarms on the cluster nodes.
Setting the dynamic link library.
Successfully set the dynamic link library.
Setting finish flag.
Successfully set finish flag.
Preinstallation succeeded.

反馈