安装后连接出现的问题总结

2018.11.1

错误1：

[kingbase@localhost ~]$ /etc/init.d/krms7d status
wrong config value: [Y/N] [FAILED]
krms of kingbase: running [ OK ]
[kingbase@localhost ~]$
问题分析解决：初始化参错配置出错，删除相关文件，重新初始化，报错：不能二次初始化，最终重新安装。。

错误2：

[root@localhost 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：

[kingbase@localhost ~]$ isql -USYSTEM -WMANAGER -d TEST
isql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

问题分析：杀进程 [kingbase@localhost ~]$ ps -ef| grep kingbase
[kingbase@localhost ~]$ kill -9 13343
（最终判断！！密码错误！）

错误4：(求帮助）

[kingbase@localhost ~]$ 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”?
！！！
问题分析：
[kingbase@localhost ~]$ cd KingbaseES/bin/
[kingbase@localhost bin]$ cd …
[kingbase@localhost KingbaseES]$ ls
…略
[kingbase@localhost KingbaseES]$ cd bin/
[kingbase@localhost 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.

解决：
[kingbase@localhost bin]$ cd /dbdata/data/data/
[kingbase@localhost data]$ ls
CTL high.sql kingbase.opts low.sql REDOLOG sys_ident.conf
DB kingbase.conf kingbase.pid middle.sql sys_hba.conf
[kingbase@localhost data]$ rm kingbase.pid
[kingbase@localhost data]$ cd /home/kingbase/KingbaseES/bin/
[kingbase@localhost 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

…(略）可以了。。

用常规方法登陆：
[kingbase@localhost bin]$ logout
[root@localhost ~]# /etc/init.d/kingbase7d start
[root@localhost ~]#
不行，，因为之前把进程都杀掉了。。
重新注册下：
[root@localhost ~]# cd /home/kingbase/KingbaseES/config/
[root@localhost config]# vi instance.conf
[root@localhost config]# su - kingbase
[kingbase@localhost ~]$ cd KingbaseES/bin/
[kingbase@localhost bin]$ ./kingbase --install kingbasees_instance1 -D /dbdata/data/data -p 54321 -U kingbase
Succeed to set instance “kingbasees_instance1” as system service.
注册成功，重启：
[kingbase@localhost bin]$
[kingbase@localhost bin]$ logout
[root@localhost 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 ]
[root@localhost 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
起了。

。。。

[kingbase@localhost ~]$ isql -USYSTEM -WMANAGER -d TEST
isql: FATAL: password authentication failed for user “SYSTEM”
[kingbase@localhost ~]$ 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,兜兜转转引发的各种问题只因密码错误而杀了进程而起。。。

附：