使用openEuler 24.03 LTS SP3 安装openGauss 6.0.0 在安装7.4 报错以下错误:(问题解决如下)
目前这个版本的安装完后 zabbix-server 与opengauss数据库仍然不能正常运行,测试结果为两者使用了不同的动态连接,而且两者对pg_version_num版本不一致,需要在zabbix上修改源码后解决
zabbix需要libpq.so.5.14 对应 PostgreSQL 12.14 版本,opengauss 需要libpq.so.5.5 对应 PostgreSQL 9.5.5 版本。
systemctl restart zabbix-server
Job for zabbix-server.service failed because the control process exited with error code.
See “systemctl status zabbix-server.service” and “journalctl -xeu zabbix-server.service” for details.
journalctl -xeu zabbix-server.service --no-pager
1月 18 18:27:19 plat1 zabbix_server[90572]: /usr/sbin/zabbix_server: symbol lookup error: /usr/sbin/zabbix_server: undefined symbol: usmAES256CiscoPrivProtocol
1月 18 18:27:19 plat1 systemd[1]: zabbix-server.service: Control process exited, code=exited, status=127/n/a
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ An ExecStart= process belonging to unit zabbix-server.service has exited.
░░
░░ The process’ exit code is ‘exited’ and its exit status is 127.
1月 18 18:27:19 plat1 systemd[1]: zabbix-server.service: Failed with result ‘exit-code’.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ The unit zabbix-server.service has entered the ‘failed’ state with result ‘exit-code’.
1月 18 18:27:19 plat1 systemd[1]: Failed to start Zabbix Server.
░░ Subject: zabbix-server.service 单元已失败
░░ Defined-By: systemd
░░ Support: systemd-devel Info Page
░░
░░ zabbix-server.service 单元已失败。
以上问题为系统使用的net-snmp-libs net-snmp版本与zabbix 需要的版本的不一致,新版本的符号表已变更,需要安装支持的版本,相关变动:
最后的匹配关系:
系统 :openEuler 24.03 LTS SP3
数据库 : openGauss 6.0.0
zabbix —- 官方选择7.0 LTS CentOS,9,Server, Frontend, Agent 版本: 7.0.el9
具体操作如下:
第一步安装 net-snmp-libs net-sn:
1.先卸载系统自带的net-snmp-libs net-sn:
yum remove net-snmp-libs net-sn
2.新增下载源:
#cd /etc/yum.repos.d
touch oepkgs.repo 新增以下内容,其中选择openEuler-24.03-LTS-SP1版本的包:
[oepkgs]
name=oepkgs openEuler Extras
baseurl= Index of /rpm/openEuler-24.03-LTS-SP1/extras/x86_64/
enabled=1
gpgcheck=0
priority=95
3.执行安装:
dnf install net-snmp-libs net-sn
第二步安装 zabbix:
如果原本已安装zabbix相关服务先卸载,包括zabbix-release.noarch 也要卸载
yum remove zabbix-server-pgsql zabbix-web-pgsql zabbix-apache-conf zabbix-sql-scripts zabbix-selinux-policy zabbix-agent zabbix-release.noarch
登录zabbix 下载7.0 LTS ,CentOS,9,Server, Frontend, Agent 下
# rpm -Uvh https://repo.zabbix.com/zabbix/7.0/centos/9/x86_64/zabbix-release-latest-7.0.el9.noarch.rpm
dnf clean all
将/etc/yum.repos.d涉及zabbix 的源地址中增加priority=95
dnf install zabbix-server-mysql zabbix-web-mysql zabbix-apache-conf zabbix-sql-scripts zabbix-selinux-policy zabbix-agent
启动服务即可:
[root@plat1 yum.repos.d]# systemctl restart zabbix-server
[root@plat1 yum.repos.d]# systemctl status zabbix-server
● zabbix-server.service - Zabbix Server
Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; disabled; preset: disabled)
Active: active (running) since Sun 2026-01-18 22:00:52 CST; 15s ago
Process: 146344 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE (code=exited, status=0/SUCCESS)
Main PID: 146346 (zabbix_server)
Tasks: 1 (limit: 43638)
Memory: 2.3M ()
CGroup: /system.slice/zabbix-server.service
└─146346 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
完成后,还需,安装php-fpm、php-pgsql、zabbix-sender、zabbix-get
su - opengauss
设置MD5认证,修改/var/lib/opengauss/data/pg_hba.conf 认证MD5或者scram-sha-256 ,默认php不支持sha256 ,
gsql -c “ALTER SYSTEM SET password_encryption_type = 1;” 对应 MD5
或者
gsql -c “ALTER SYSTEM SET password_encryption_type =3;” 对应 MD5
gsql -c “SELECT pg_reload_conf();”
修改完后,需要重新修改数据库用户密码