2018.11.1
错误1：
[[email protected] ~]$ /etc/init.d/krms7d status
wrong config value: [Y/N] [FAILED]
krms of kingbase: running [ OK ]
[[email protected] ~]$
问题分析解决：初始化参错配置出错，删除相关文件，重新初始化，报错：不能二次初始化，最终重新安装。。
错误2：
[[email protected] kingbase]# isql -USYSTEM -WMANAGER -d TEST
isql: error while loading shared libraries: libkci.so.5: cannot open shared object file: No such file or directory
问题分析：网上查是因为没权限，则切在kingbase下执行可以？。。
（最终判断！！密码错误！）
错误3：
[[email protected] ~]$ isql -USYSTEM -WMANAGER -d TEST
isql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
问题分析：杀进程 [[email protected] ~]$ ps -ef| grep kingbase
[[email protected] ~]$ kill -9 13343
（最终判断！！密码错误！）
错误4：(求帮助）
[[email protected] ~]$ isql -USYSTEM -WMANAGER -d TEST
isql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket “/tmp/.s.KINGBASE.54321”?
！！！
问题分析：
[[email protected] ~]$ cd KingbaseES/bin/
[[email protected] bin]$ cd …
[[email protected] KingbaseES]$ ls
…略
[[email protected] KingbaseES]$ cd bin/
[king[email protected] bin]$ ./kingbase -D /dbdata/data/data/
LOG: dumping license information…
LOG: file version: 2.0
LOG: product line: ES
LOG: product version: 7.1.2
LOG: distribution type: EE
LOG: operating system: LNX
LOG: architecture: X64
LOG: floating mode: yes
LOG: base date: 2018-11-01
LOG: valid period: 180 days
LOG: max connections: unlimited
LOG: user information: ��ҵ
LOG: trial mode: no
LOG: MAC address checking mode: no
LOG: MAC address:
LOG: IPV4 address checking mode: no
LOG: IPV4 address:
LOG: S/N: c47ee2bd-87546f05-e6037736-0a6a5d64
[2018-11-01 02:06:03.965 PDT][][][1][][][]FATAL: old lock file “kingbase.pid” already exists, please remove it by hand.
[2018-11-01 02:06:03.965 PDT][][][1][][][]HINT: The file seems accidentally left over.
解决：
[[email protected] bin]$ cd /dbdata/data/data/
[[email protected] data]$ ls
CTL high.sql kingbase.opts low.sql REDOLOG sys_ident.conf
DB kingbase.conf kingbase.pid middle.sql sys_hba.conf
[[email protected] data]$ rm kingbase.pid
[[email protected] data]$ cd /home/kingbase/KingbaseES/bin/
[[email protected] bin]$ ./kingbase -D /dbdata/data/data/
LOG: dumping license information…
LOG: file version: 2.0
LOG: product line: ES
LOG: product version: 7.1.2
LOG: distribution type: EE
LOG: operating system: LNX
LOG: architecture: X64
LOG: floating mode: yes
LOG: base date: 2018-11-01
LOG: valid period: 180 days
LOG: max connections: unlimited
…(略）可以了。。
用常规方法登陆：
[[email protected] bin]$ logout
[[email protected] ~]# /etc/init.d/kingbase7d start
[[email protected] ~]#
不行，，因为之前把进程都杀掉了。。
重新注册下：
[[email protected] ~]# cd /home/kingbase/KingbaseES/config/
[[email protected] config]# vi instance.conf
[[email protected] config]# su - kingbase
[[email protected] ~]$ cd KingbaseES/bin/
[[email protected] bin]$ ./kingbase --install kingbasees_instance1 -D /dbdata/data/data -p 54321 -U kingbase
Succeed to set instance “kingbasees_instance1” as system service.
注册成功，重启：
[[email protected] bin]$
[[email protected] bin]$ logout
[[email protected] config]# /etc/init.d/kingbase7d start
do not exist a kingbase process which pid is 13343, remove the lock file /tmp/.s.KINGBASE.54321.lock.
do not exist a kingbase process which pid is 25720, remove the lock file /tmp/.s.KINGBASE.54322.lock.
starting kingbasees_instance1 of kingbase [ OK ]
[[email protected] config]# ps -ef|grep kingbase
…,
kingbase 35769 1 4 02:08 ? 00:00:00 /home/kingbase/KingbaseES/bin/kingbase kingbasees_instance1
root 35789 35313 0 02:09 pts/0 00:00:00 grep kingbase
起了。
。。。
[[email protected] ~]$ isql -USYSTEM -WMANAGER -d TEST
isql: FATAL: password authentication failed for user “SYSTEM”
[[email protected] ~]$ isql -USYSTEM -W123456 -d TEST
Welcome to isql 7.1.2.0935 release 64 bit, the Kingbase interactive terminal.
Type: \h for help with SQL commands
? for help with isql commands
\g or terminate with semicolon to execute query
\q to quit
TEST=#
TEST=#
TEST=#
。。。真的是。。，原来是之前初始化时改了密码为123456，并没有用manager,兜兜转转引发的各种问题只因密码错误而杀了进程而起。。。
附：
