GBase 8s
安装配置
问答
gbasedbt用户连接到数据库报错：The password is too simple.
发表于2025-09-17 14:27:39330次浏览17个评论
为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【GBase版本】:GBase8s V8.8
【操作系统】:CentOS
【CPU】:
【问题描述】*:系统用户密码已修改，用系统gbasedbt用户密码连接数据库失败，尝试输入gbasedbt似乎成功了但是报以下错误，怎么去修改数据库用户gbasedbt的密码
悬赏:10吉币
回答被发帖人采纳后可获得赏金
评论
登录后才可以发表评论
路路路发表于 10个月前
稍等
路路路发表于 10个月前
passwd gbasedbt 新密码
梦之泪殇严肃版发表于 10个月前
@路路路：如图
梦之泪殇严肃版发表于 10个月前
@路路路：试过，目前系统gbasedbt用户和数据库gbasedbt用户密码不一致
梦之泪殇严肃版发表于 10个月前
@路路路：[root@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]# passwd gbasedbt
更改用户 gbasedbt 的密码 。
新的密码：
重新输入新的密码：
passwd：所有的身份验证令牌已经成功更新。
[root@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]# su - gbasedbt
上一次登录： 三 9月 17 14:08:05 CST 2025 pts/0 上
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]$ dbaccess - -
Your evaluation license will expire on 2026-09-10 00:00:00
> connect to 'iecp@gbase01' user 'gbasedbt';
ENTER PASSWORD:
951: Incorrect password or user gbasedbt@localhost[Server-96e1ce31-0b2a-450a-ba37-4c699e57c664.novalocal] is not known on the database server.
Error in line 1
Near character position 1
更改用户 gbasedbt 的密码 。
新的密码：
重新输入新的密码：
passwd：所有的身份验证令牌已经成功更新。
[root@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]# su - gbasedbt
上一次登录： 三 9月 17 14:08:05 CST 2025 pts/0 上
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]$ dbaccess - -
Your evaluation license will expire on 2026-09-10 00:00:00
> connect to 'iecp@gbase01' user 'gbasedbt';
ENTER PASSWORD:
951: Incorrect password or user gbasedbt@localhost[Server-96e1ce31-0b2a-450a-ba37-4c699e57c664.novalocal] is not known on the database server.
Error in line 1
Near character position 1
hugolin发表于 10个月前
@梦之泪殇严肃版：gbasedbt执行onmode -wf NS_CACHE="user=0"或者重启数据库onmode -ky && oninit -vy试试
梦之泪殇严肃版发表于 10个月前
@hugolin：[root@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]# su - gbasedbt
上一次登录： 三 9月 17 15:33:58 CST 2025 pts/0 上
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]$ onmode -ky
Your evaluation license will expire on 2026-09-10 00:00:00
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]$ oninit -vy
Your evaluation license will expire on 2026-09-10 00:00:00
Reading configuration file '/gbasedata/gbase8s/etc/onconfig.gbase01'...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 1501566 kbytes...succeeded
Creating infos file "/gbasedata/gbase8s/etc/.infos.gbase01"...succeeded
Linking conf file "/gbasedata/gbase8s/etc/.conf.gbase01"...succeeded
Initializing rhead structure...rhlock_t 1048576 (32768K)... rlock_t (1460937K)... Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 32 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
Checking database partition index...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Updating Global Row Counter...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Creating periodic thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]$ dbaccess - -
Your evaluation license will expire on 2026-09-10 00:00:00
> connect to 'iecp@gbase01' user 'gbasedbt';
ENTER PASSWORD:
951: Incorrect password or user gbasedbt@localhost[Server-96e1ce31-0b2a-450a-ba37-4c699e57c664.novalocal] is not known on the database server.
Error in line 1
Near character position 1
上一次登录： 三 9月 17 15:33:58 CST 2025 pts/0 上
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]$ onmode -ky
Your evaluation license will expire on 2026-09-10 00:00:00
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]$ oninit -vy
Your evaluation license will expire on 2026-09-10 00:00:00
Reading configuration file '/gbasedata/gbase8s/etc/onconfig.gbase01'...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 1501566 kbytes...succeeded
Creating infos file "/gbasedata/gbase8s/etc/.infos.gbase01"...succeeded
Linking conf file "/gbasedata/gbase8s/etc/.conf.gbase01"...succeeded
Initializing rhead structure...rhlock_t 1048576 (32768K)... rlock_t (1460937K)... Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 32 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
Checking database partition index...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Updating Global Row Counter...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Creating periodic thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 ~]$ dbaccess - -
Your evaluation license will expire on 2026-09-10 00:00:00
> connect to 'iecp@gbase01' user 'gbasedbt';
ENTER PASSWORD:
951: Incorrect password or user gbasedbt@localhost[Server-96e1ce31-0b2a-450a-ba37-4c699e57c664.novalocal] is not known on the database server.
Error in line 1
Near character position 1
hugolin发表于 10个月前
@梦之泪殇严肃版：1、用普通用户su - gbasedbt方式输入密码切到gbasedbt
2、检查onconfig文件的DBSERVERNAME和sqlhosts文件
3、安装目录下，root执行RUNasroot.installserver
2、检查onconfig文件的DBSERVERNAME和sqlhosts文件
3、安装目录下，root执行RUNasroot.installserver
梦之泪殇严肃版发表于 10个月前
@hugolin：[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 etc]$ grep -r "DBSERVER" /gbasedata/gbase8s/etc/onconfig.gbase01
# DBSERVERNAME - The name of the default database server
# DBSERVERALIASES - The list of up to 32 alternative dbservernames,
DBSERVERNAME gbase01
DBSERVERALIASES
# DBSERVERNAME or DBSERVERALIASES that uses a
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 etc]$ cat sqlhosts.gbase01
gbase01 onsoctcp 0.0.0.0 9088
# DBSERVERNAME - The name of the default database server
# DBSERVERALIASES - The list of up to 32 alternative dbservernames,
DBSERVERNAME gbase01
DBSERVERALIASES
# DBSERVERNAME or DBSERVERALIASES that uses a
[gbasedbt@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 etc]$ cat sqlhosts.gbase01
gbase01 onsoctcp 0.0.0.0 9088
hugolin发表于 10个月前
@梦之泪殇严肃版：用普通用户su - gbasedbt方式输入密码切到gbasedbt验证密码
如果密码正确，停库后到安装目录下，root执行RUNasroot.installserver脚本
如果密码正确，停库后到安装目录下，root执行RUNasroot.installserver脚本
梦之泪殇严肃版发表于 10个月前
@hugolin：需要手动创建吗
[root@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 gbase8s]# ./RUNasroot.installserver
chown: 无法访问 'properties': 没有那个文件或目录
chmod: 无法访问 'properties': 没有那个文件或目录
chown: 无法访问 'properties/version': 没有那个文件或目录
chmod: 无法访问 'properties/version': 没有那个文件或目录
chown: 无法访问 'etc/secswitch.std.on': 没有那个文件或目录
chmod: 无法访问 'etc/secswitch.std.on': 没有那个文件或目录
chown: 无法访问 'etc/secswitch.std.off': 没有那个文件或目录
chmod: 无法访问 'etc/secswitch.std.off': 没有那个文件或目录
chown: 无法访问 'forms': 没有那个文件或目录
chmod: 无法访问 'forms': 没有那个文件或目录
chown: 无法访问 'GBase_GLS_InstallLog.log': 没有那个文件或目录
chmod: 无法访问 'GBase_GLS_InstallLog.log': 没有那个文件或目录
chown: 无法访问 'uninstall.log': 没有那个文件或目录
chmod: 无法访问 'uninstall.log': 没有那个文件或目录
chown: 无法访问 'gls/lc11/zh_hk': 没有那个文件或目录
chmod: 无法访问 'gls/lc11/zh_hk': 没有那个文件或目录
[root@Server-96e1ce31-0b2a-450a-ba37-4c699e57c664 gbase8s]# ./RUNasroot.installserver
chown: 无法访问 'properties': 没有那个文件或目录
chmod: 无法访问 'properties': 没有那个文件或目录
chown: 无法访问 'properties/version': 没有那个文件或目录
chmod: 无法访问 'properties/version': 没有那个文件或目录
chown: 无法访问 'etc/secswitch.std.on': 没有那个文件或目录
chmod: 无法访问 'etc/secswitch.std.on': 没有那个文件或目录
chown: 无法访问 'etc/secswitch.std.off': 没有那个文件或目录
chmod: 无法访问 'etc/secswitch.std.off': 没有那个文件或目录
chown: 无法访问 'forms': 没有那个文件或目录
chmod: 无法访问 'forms': 没有那个文件或目录
chown: 无法访问 'GBase_GLS_InstallLog.log': 没有那个文件或目录
chmod: 无法访问 'GBase_GLS_InstallLog.log': 没有那个文件或目录
chown: 无法访问 'uninstall.log': 没有那个文件或目录
chmod: 无法访问 'uninstall.log': 没有那个文件或目录
chown: 无法访问 'gls/lc11/zh_hk': 没有那个文件或目录
chmod: 无法访问 'gls/lc11/zh_hk': 没有那个文件或目录
levvel发表于 8个月前
我看好你哟！
mittens发表于 1个月前
使用复杂度高的密码
热门帖子
- 12025-12-01浏览数：182759
- 22023-05-09浏览数：25044
- 42023-09-25浏览数：18519
- 52020-05-11浏览数：17526