再执行一下/home/admin/oceanbase/bin/obshell task show -i 23232261533028864 -d,看看任务报错是不是import mysql.connector失败,如果是的话,执行一下pip install mysql-connector,然后重试一下这个任务即可。
几位大哥,终于好了。感谢啊。一会我再全部重新来一次,复验下。
文档缺失东西 ,以下命令必须能成功,才能确保安装成功。
1: 不仅是python环境,需要直接执行python命令能进环境
2: pip install mysql-connector
遗留问题 obclient执行失败,少了依赖。
[root@euler157 ~]#
[root@euler157 ~]# obclient
obclient: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# python
Python 3.9.9 (main, Oct 25 2023, 15:16:57)
[GCC 10.3.1] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>>
>>>
>>> import mysql.connector
>>>
>>>
>>>
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
Active: active (running) since Fri 2024-10-18 16:17:02 CST; 1min 45s ago
Process: 1704 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=0/SUCCESS)
Main PID: 2335 (observer)
Tasks: 425 (limit: 47367)
Memory: 2.4G
CGroup: /system.slice/oceanbase.service
├─ 2263 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
├─ 2284 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
└─ 2335 /home/admin/oceanbase/bin/observer
10月 18 16:16:36 euler157.local bash[1704]: wait 6s and the retry
10月 18 16:16:42 euler157.local bash[1704]: the response state is RUNNING
10月 18 16:16:42 euler157.local bash[1704]: wait 6s and the retry
10月 18 16:16:48 euler157.local bash[1704]: the response state is RUNNING
10月 18 16:16:48 euler157.local bash[1704]: wait 6s and the retry
10月 18 16:16:54 euler157.local bash[1704]: the response state is RUNNING
10月 18 16:16:54 euler157.local bash[1704]: wait 6s and the retry
10月 18 16:17:00 euler157.local bash[1704]: the response state is SUCCEED
10月 18 16:17:00 euler157.local bash[1704]: start observer request successfully
10月 18 16:17:02 euler157.local systemd[1]: Started oceanbase.
[root@euler157 ~]#
[root@euler157 ~]#
全新安装验证如下,可参考下面操作记录,再次感谢各位帮忙排查
一次通过
环境信息如下 , 注意官方文档,需要强调python依赖,确保python可以执行。
同时安装连接依赖包 pip install mysql-connector
[root@euler157 ~]#
[root@euler157 ~]# cat /etc/os-release
NAME="openEuler"
VERSION="22.03 (LTS-SP2)"
ID="openEuler"
VERSION_ID="22.03"
PRETTY_NAME="openEuler 22.03 (LTS-SP2)"
ANSI_COLOR="0;31"
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# cat /proc/version
Linux version 5.10.0-153.56.0.134.oe2203sp2.x86_64 (root@dc-64g.compass-ci) (gcc_old (GCC) 10.3.1, GNU ld (GNU Binutils) 2.37) #1 SMP Wed May 29 14:04:28 CST 2024
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# uname -ra
Linux euler157.local 5.10.0-153.56.0.134.oe2203sp2.x86_64 #1 SMP Wed May 29 14:04:28 CST 2024 x86_64 x86_64 x86_64 GNU/Linux
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# free -h
total used free shared buff/cache available
Mem: 7.3Gi 2.3Gi 1.9Gi 8.7Mi 3.4Gi 5.0Gi
Swap: 4.0Gi 0B 4.0Gi
[root@euler157 ~]#
[root@euler157 ~]# df -h
文件系统 容量 已用 可用 已用% 挂载点
devtmpfs 4.0M 0 4.0M 0% /dev
tmpfs 3.7G 0 3.7G 0% /dev/shm
tmpfs 1.5G 8.7M 1.5G 1% /run
tmpfs 4.0M 0 4.0M 0% /sys/fs/cgroup
/dev/mapper/openeuler-root 45G 22G 21G 51% /
tmpfs 3.7G 0 3.7G 0% /tmp
/dev/sda1 974M 226M 682M 25% /boot
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# free -h
total used free shared buff/cache available
Mem: 7.3Gi 427Mi 6.9Gi 8.7Mi 220Mi 6.8Gi
Swap: 4.0Gi 0B 4.0Gi
[root@euler157 ~]# getenforce
Enforcing
[root@euler157 ~]# setenforce 0
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# getenforce
Permissive
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# ln -sf /usr/bin/python3 /usr/bin/python
[root@euler157 ~]# yum install tar
Last metadata expiration check: 0:09:27 ago on 2024年10月18日 星期五 17时21分00秒.
Dependencies resolved.
==================================================================================================================================
Package Architecture Version Repository Size
==================================================================================================================================
Installing:
tar x86_64 2:1.34-5.oe2203sp2 update 784 k
Transaction Summary
==================================================================================================================================
Install 1 Package
Total download size: 784 k
Installed size: 3.3 M
Is this ok [y/N]: y
Downloading Packages:
tar-1.34-5.oe2203sp2.x86_64.rpm 340 kB/s | 784 kB 00:02
----------------------------------------------------------------------------------------------------------------------------------
Total 314 kB/s | 784 kB 00:02
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: tar-2:1.34-5.oe2203sp2.x86_64 1/1
Installing : tar-2:1.34-5.oe2203sp2.x86_64 1/1
Running scriptlet: tar-2:1.34-5.oe2203sp2.x86_64 1/1
Verifying : tar-2:1.34-5.oe2203sp2.x86_64 1/1
Installed:
tar-2:1.34-5.oe2203sp2.x86_64
Complete!
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# cat /etc/os-release
NAME="openEuler"
VERSION="22.03 (LTS-SP2)"
ID="openEuler"
VERSION_ID="22.03"
PRETTY_NAME="openEuler 22.03 (LTS-SP2)"
ANSI_COLOR="0;31"
[root@euler157 ~]#
[root@euler157 ~]# uname -ra
Linux euler157.local 5.10.0-153.56.0.134.oe2203sp2.x86_64 #1 SMP Wed May 29 14:04:28 CST 2024 x86_64 x86_64 x86_64 GNU/Linux
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# getenforce
Permissive
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# which python
/usr/bin/python
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# tar zxvf mysql-connector-2.2.9.tar.gz
mysql-connector-2.2.9/
mysql-connector-2.2.9/CHANGES.txt
mysql-connector-2.2.9/LICENSE.txt
mysql-connector-2.2.9/MANIFEST.in
mysql-connector-2.2.9/PKG-INFO
mysql-connector-2.2.9/README.txt
mysql-connector-2.2.9/docs/
mysql-connector-2.2.9/docs/README_DOCS.txt
mysql-connector-2.2.9/examples/
mysql-connector-2.2.9/examples/__init__.py
mysql-connector-2.2.9/examples/dates.py
mysql-connector-2.2.9/examples/engines.py
mysql-connector-2.2.9/examples/inserts.py
mysql-connector-2.2.9/examples/microseconds.py
mysql-connector-2.2.9/examples/multi_resultsets.py
mysql-connector-2.2.9/examples/mysql_warnings.py
mysql-connector-2.2.9/examples/prepared_statements.py
mysql-connector-2.2.9/examples/transaction.py
mysql-connector-2.2.9/examples/unicode.py
mysql-connector-2.2.9/examples/warnings.py
mysql-connector-2.2.9/lib/
mysql-connector-2.2.9/lib/__init__.py
mysql-connector-2.2.9/lib/cpy_distutils.py
mysql-connector-2.2.9/lib/mysql/
mysql-connector-2.2.9/lib/mysql/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/
mysql-connector-2.2.9/lib/mysql/connector/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/abstracts.py
mysql-connector-2.2.9/lib/mysql/connector/authentication.py
mysql-connector-2.2.9/lib/mysql/connector/catch23.py
mysql-connector-2.2.9/lib/mysql/connector/charsets.py
mysql-connector-2.2.9/lib/mysql/connector/connection.py
mysql-connector-2.2.9/lib/mysql/connector/connection_cext.py
mysql-connector-2.2.9/lib/mysql/connector/constants.py
mysql-connector-2.2.9/lib/mysql/connector/conversion.py
mysql-connector-2.2.9/lib/mysql/connector/cursor.py
mysql-connector-2.2.9/lib/mysql/connector/cursor_cext.py
mysql-connector-2.2.9/lib/mysql/connector/custom_types.py
mysql-connector-2.2.9/lib/mysql/connector/dbapi.py
mysql-connector-2.2.9/lib/mysql/connector/django/
mysql-connector-2.2.9/lib/mysql/connector/django/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/django/base.py
mysql-connector-2.2.9/lib/mysql/connector/django/client.py
mysql-connector-2.2.9/lib/mysql/connector/django/compiler.py
mysql-connector-2.2.9/lib/mysql/connector/django/creation.py
mysql-connector-2.2.9/lib/mysql/connector/django/features.py
mysql-connector-2.2.9/lib/mysql/connector/django/introspection.py
mysql-connector-2.2.9/lib/mysql/connector/django/operations.py
mysql-connector-2.2.9/lib/mysql/connector/django/schema.py
mysql-connector-2.2.9/lib/mysql/connector/django/validation.py
mysql-connector-2.2.9/lib/mysql/connector/errorcode.py
mysql-connector-2.2.9/lib/mysql/connector/errors.py
mysql-connector-2.2.9/lib/mysql/connector/fabric/
mysql-connector-2.2.9/lib/mysql/connector/fabric/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/fabric/balancing.py
mysql-connector-2.2.9/lib/mysql/connector/fabric/caching.py
mysql-connector-2.2.9/lib/mysql/connector/fabric/connection.py
mysql-connector-2.2.9/lib/mysql/connector/locales/
mysql-connector-2.2.9/lib/mysql/connector/locales/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/locales/eng/
mysql-connector-2.2.9/lib/mysql/connector/locales/eng/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/locales/eng/client_error.py
mysql-connector-2.2.9/lib/mysql/connector/network.py
mysql-connector-2.2.9/lib/mysql/connector/optionfiles.py
mysql-connector-2.2.9/lib/mysql/connector/pooling.py
mysql-connector-2.2.9/lib/mysql/connector/protocol.py
mysql-connector-2.2.9/lib/mysql/connector/utils.py
mysql-connector-2.2.9/lib/mysql/connector/version.py
mysql-connector-2.2.9/lib/mysql_connector.egg-info/
mysql-connector-2.2.9/lib/mysql_connector.egg-info/PKG-INFO
mysql-connector-2.2.9/lib/mysql_connector.egg-info/SOURCES.txt
mysql-connector-2.2.9/lib/mysql_connector.egg-info/dependency_links.txt
mysql-connector-2.2.9/lib/mysql_connector.egg-info/top_level.txt
mysql-connector-2.2.9/lib/mysqlx/
mysql-connector-2.2.9/lib/mysqlx/__init__.py
mysql-connector-2.2.9/lib/mysqlx/authentication.py
mysql-connector-2.2.9/lib/mysqlx/charsets.py
mysql-connector-2.2.9/lib/mysqlx/compat.py
mysql-connector-2.2.9/lib/mysqlx/connection.py
mysql-connector-2.2.9/lib/mysqlx/constants.py
mysql-connector-2.2.9/lib/mysqlx/crud.py
mysql-connector-2.2.9/lib/mysqlx/dbdoc.py
mysql-connector-2.2.9/lib/mysqlx/errorcode.py
mysql-connector-2.2.9/lib/mysqlx/errors.py
mysql-connector-2.2.9/lib/mysqlx/expr.py
mysql-connector-2.2.9/lib/mysqlx/expr_unparser.py
mysql-connector-2.2.9/lib/mysqlx/locales/
mysql-connector-2.2.9/lib/mysqlx/locales/__init__.py
mysql-connector-2.2.9/lib/mysqlx/locales/eng/
mysql-connector-2.2.9/lib/mysqlx/locales/eng/__init__.py
mysql-connector-2.2.9/lib/mysqlx/locales/eng/client_error.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/
mysql-connector-2.2.9/lib/mysqlx/protobuf/__init__.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_connection_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_crud_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_datatypes_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_expect_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_expr_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_notice_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_resultset_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_session_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_sql_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/t.py
mysql-connector-2.2.9/lib/mysqlx/protocol.py
mysql-connector-2.2.9/lib/mysqlx/result.py
mysql-connector-2.2.9/lib/mysqlx/statement.py
mysql-connector-2.2.9/setup.cfg
mysql-connector-2.2.9/setup.py
mysql-connector-2.2.9/setupinfo.py
mysql-connector-2.2.9/src/
mysql-connector-2.2.9/src/exceptions.c
mysql-connector-2.2.9/src/force_cpp_linkage.cc
mysql-connector-2.2.9/src/include/
mysql-connector-2.2.9/src/include/catch23.h
mysql-connector-2.2.9/src/include/exceptions.h
mysql-connector-2.2.9/src/include/mysql_capi.h
mysql-connector-2.2.9/src/include/mysql_capi_conversion.h
mysql-connector-2.2.9/src/include/mysql_connector.h
mysql-connector-2.2.9/src/mysql_capi.c
mysql-connector-2.2.9/src/mysql_capi_conversion.c
mysql-connector-2.2.9/src/mysql_connector.c
mysql-connector-2.2.9/tests/
mysql-connector-2.2.9/tests/__init__.py
mysql-connector-2.2.9/tests/cext/
mysql-connector-2.2.9/tests/cext/__init__.py
mysql-connector-2.2.9/tests/cext/test_cext_api.py
mysql-connector-2.2.9/tests/cext/test_cext_connection.py
mysql-connector-2.2.9/tests/cext/test_cext_cursor.py
mysql-connector-2.2.9/tests/data/
mysql-connector-2.2.9/tests/data/local_data.csv
mysql-connector-2.2.9/tests/data/option_files/
mysql-connector-2.2.9/tests/data/option_files/dup_groups.cnf
mysql-connector-2.2.9/tests/data/option_files/include_files/
mysql-connector-2.2.9/tests/data/option_files/include_files/1.cnf
mysql-connector-2.2.9/tests/data/option_files/include_files/2.cnf
mysql-connector-2.2.9/tests/data/option_files/my.cnf
mysql-connector-2.2.9/tests/data/option_files/pool.cnf
mysql-connector-2.2.9/tests/data/random_big_bin.csv
mysql-connector-2.2.9/tests/data/ssl/
mysql-connector-2.2.9/tests/data/ssl/tests_CA_cert.pem
mysql-connector-2.2.9/tests/data/ssl/tests_CA_key.pem
mysql-connector-2.2.9/tests/data/ssl/tests_client_cert.pem
mysql-connector-2.2.9/tests/data/ssl/tests_client_key.pem
mysql-connector-2.2.9/tests/data/ssl/tests_server_cert.pem
mysql-connector-2.2.9/tests/data/ssl/tests_server_key.pem
mysql-connector-2.2.9/tests/issues/
mysql-connector-2.2.9/tests/issues/__init__.py
mysql-connector-2.2.9/tests/issues/test_bug21449207.py
mysql-connector-2.2.9/tests/issues/test_bug21449996.py
mysql-connector-2.2.9/tests/issues/test_bug21879859.py
mysql-connector-2.2.9/tests/issues/test_bug21879914.py
mysql-connector-2.2.9/tests/issues/test_bug22545879.py
mysql-connector-2.2.9/tests/mysqld.py
mysql-connector-2.2.9/tests/py26.py
mysql-connector-2.2.9/tests/test_abstracts.py
mysql-connector-2.2.9/tests/test_authentication.py
mysql-connector-2.2.9/tests/test_bugs.py
mysql-connector-2.2.9/tests/test_connection.py
mysql-connector-2.2.9/tests/test_constants.py
mysql-connector-2.2.9/tests/test_conversion.py
mysql-connector-2.2.9/tests/test_cursor.py
mysql-connector-2.2.9/tests/test_django.py
mysql-connector-2.2.9/tests/test_errorcode.py
mysql-connector-2.2.9/tests/test_errors.py
mysql-connector-2.2.9/tests/test_examples.py
mysql-connector-2.2.9/tests/test_fabric.py
mysql-connector-2.2.9/tests/test_locales.py
mysql-connector-2.2.9/tests/test_mysql_datatypes.py
mysql-connector-2.2.9/tests/test_mysqlx_connection.py
mysql-connector-2.2.9/tests/test_mysqlx_crud.py
mysql-connector-2.2.9/tests/test_mysqlx_errorcode.py
mysql-connector-2.2.9/tests/test_mysqlx_errors.py
mysql-connector-2.2.9/tests/test_network.py
mysql-connector-2.2.9/tests/test_optionfiles.py
mysql-connector-2.2.9/tests/test_pep249.py
mysql-connector-2.2.9/tests/test_pooling.py
mysql-connector-2.2.9/tests/test_protocol.py
mysql-connector-2.2.9/tests/test_setup.py
mysql-connector-2.2.9/tests/test_style.py
mysql-connector-2.2.9/tests/test_utils.py
mysql-connector-2.2.9/unittests.py
[root@euler157 ~]# cd mysql-connector-2.2.9
[root@euler157 mysql-connector-2.2.9]# pip install .
WARNING: Running pip install with root privileges is generally not a good idea. Try `pip install --user` instead.
Processing /root/mysql-connector-2.2.9
Preparing metadata (setup.py) ... done
Using legacy 'setup.py install' for mysql-connector, since package 'wheel' is not installed.
Installing collected packages: mysql-connector
Running setup.py install for mysql-connector ... done
Successfully installed mysql-connector-2.2.9
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
[root@euler157 mysql-connector-2.2.9]#
[root@euler157 mysql-connector-2.2.9]# python
Python 3.9.9 (main, Oct 25 2023, 15:16:57)
[GCC 10.3.1] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>>
>>>
>>> import mysql.connector
>>>
>>>
>>>
[root@euler157 mysql-connector-2.2.9]#
[root@euler157 mysql-connector-2.2.9]#
[root@euler157 mysql-connector-2.2.9]#
[root@euler157 mysql-connector-2.2.9]#
[root@euler157 mysql-connector-2.2.9]#
[root@euler157 mysql-connector-2.2.9]# cd
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[
[root@euler157 ~]#
[root@euler157 ~]# netstat -tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1027/sshd: /usr/sbi
tcp6 0 0 :::22 :::* LISTEN 1027/sshd: /usr/sbi
udp 0 0 127.0.0.1:323 0.0.0.0:* 999/chronyd
udp6 0 0 ::1:323 :::* 999/chronyd
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# yum install oceanbase-ce oceanbase-ce-libs obclient
Last metadata expiration check: 0:03:08 ago on 2024年10月18日 星期五 17时32分43秒.
Dependencies resolved.
==================================================================================================================================
Package Architecture Version Repository Size
==================================================================================================================================
Installing:
obclient x86_64 2.2.6-1.el7 local 11 M
oceanbase-ce x86_64 4.3.3.0-100000142024101215.el7 local 138 M
oceanbase-ce-libs x86_64 4.3.3.0-100000142024101215.el7 local 155 k
Installing dependencies:
jq x86_64 1.6-2.oe2203sp2 local 167 k
oniguruma x86_64 6.9.6-1.oe2203sp2 local 160 k
Transaction Summary
==================================================================================================================================
Install 5 Packages
Total size: 150 M
Installed size: 747 M
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : oniguruma-6.9.6-1.oe2203sp2.x86_64 1/5
Installing : jq-1.6-2.oe2203sp2.x86_64 2/5
Running scriptlet: jq-1.6-2.oe2203sp2.x86_64 2/5
Installing : oceanbase-ce-libs-4.3.3.0-100000142024101215.el7.x86_64 3/5
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
Running scriptlet: oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64 4/5
execute pre install script
Installing : oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64 4/5
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
Running scriptlet: oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64 4/5
execute post install script
To configure OceanBase : edit /etc/oceanbase.cnf
To start OceanBase : systemctl start oceanbase
To enable OceanBase auto reboot : systemctl enable oceanbase
To get more infomation : https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000640297
Running scriptlet: obclient-2.2.6-1.el7.x86_64 5/5
Installing : obclient-2.2.6-1.el7.x86_64 5/5
Running scriptlet: obclient-2.2.6-1.el7.x86_64 5/5
Verifying : jq-1.6-2.oe2203sp2.x86_64 1/5
Verifying : obclient-2.2.6-1.el7.x86_64 2/5
Verifying : oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64 3/5
Verifying : oceanbase-ce-libs-4.3.3.0-100000142024101215.el7.x86_64 4/5
Verifying : oniguruma-6.9.6-1.oe2203sp2.x86_64 5/5
Installed:
jq-1.6-2.oe2203sp2.x86_64 obclient-2.2.6-1.el7.x86_64
oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64 oceanbase-ce-libs-4.3.3.0-100000142024101215.el7.x86_64
oniguruma-6.9.6-1.oe2203sp2.x86_64
Complete!
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# systemctl status oceanbase
○ oceanbase.service - oceanbase
Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
Active: inactive (dead)
10月 18 17:36:26 euler157.local systemd[1]: /etc/systemd/system/oceanbase.service:7: Unit configured to use KillMode=none. This i>
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# systemctl start oceanbase
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# systemctl status oceanbase
● oceanbase.service - oceanbase
Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
Active: active (running) since Fri 2024-10-18 17:38:33 CST; 16s ago
Process: 5290 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=0/SUCCESS)
Main PID: 5950 (observer)
Tasks: 416 (limit: 47367)
Memory: 2.1G
CGroup: /system.slice/oceanbase.service
├─ 5835 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
├─ 5856 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
└─ 5950 /home/admin/oceanbase/bin/observer -c 1 -d /home/admin/oceanbase/store -z zone1 -p 2881 -n ob -I 192.168.101>
10月 18 17:38:08 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:14 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:14 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:20 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:20 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:26 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:26 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:32 euler157.local bash[5290]: the response state is SUCCEED
10月 18 17:38:32 euler157.local bash[5290]: start observer request successfully
10月 18 17:38:33 euler157.local systemd[1]: Started oceanbase.
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# systemctl status oceanbase
● oceanbase.service - oceanbase
Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
Active: active (running) since Fri 2024-10-18 17:38:33 CST; 20s ago
Process: 5290 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=0/SUCCESS)
Main PID: 5950 (observer)
Tasks: 416 (limit: 47367)
Memory: 2.1G
CGroup: /system.slice/oceanbase.service
├─ 5835 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
├─ 5856 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
└─ 5950 /home/admin/oceanbase/bin/observer -c 1 -d /home/admin/oceanbase/store -z zone1 -p 2881 -n ob -I 192.168.101>
10月 18 17:38:08 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:14 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:14 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:20 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:20 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:26 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:26 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:32 euler157.local bash[5290]: the response state is SUCCEED
10月 18 17:38:32 euler157.local bash[5290]: start observer request successfully
10月 18 17:38:33 euler157.local systemd[1]: Started oceanbase.
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]# netstat -tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1027/sshd: /usr/sbi
tcp 0 0 0.0.0.0:2881 0.0.0.0:* LISTEN 5950/observer
tcp 0 0 0.0.0.0:2882 0.0.0.0:* LISTEN 5950/observer
tcp 0 0 192.168.101.157:2886 0.0.0.0:* LISTEN 5856/obshell
tcp6 0 0 :::22 :::* LISTEN 1027/sshd: /usr/sbi
tcp6 0 0 :::2882 :::* LISTEN 5950/observer
udp 0 0 127.0.0.1:323 0.0.0.0:* 999/chronyd
udp6 0 0 ::1:323 :::* 999/chronyd
[root@euler157 ~]#
[root@euler157 ~]#
[root@euler157 ~]#
root@euler157 ~]#
[root@euler157 ~]# mysql -h 127.0.0.1 -u root --port=2881 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3221487622
Server version: 5.7.25 OceanBase_CE 4.3.3.0 (r100000142024101215-0723f9774e5f77a1253149261ba75a94414625d0) (Built Oct 12 2024 15:58:11)
Copyright (c) 2000, 2024, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ocs |
| ORAAUDITOR |
| SYS |
| sys_external_tbs |
| test |
+--------------------+
9 rows in set (0.00 sec)
mysql>
mysql>
1 个赞