为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
启动命令:
docker run -d -p 5236:5236 --restart=always --name dm8_01 --privileged=true -e PAGE_SIZE=16 -e LD_LIBRARY_PATH=/opt/dmdbms/bin -e INSTANCE_NAME=dm8_01 -v /data/dm8_01:/opt/dmdbms/data dm8:dm8_20250206_rev257733_x86_rh6_64
镜像是官方提供的最新版本
日志:
(.conda) yf@yf-SA5212M5:~/workspaces/beihang$ docker logs -f dm8_01
Script start.
log file path: /opt/dmdbms/data/DAMENG/DAMENG01.log
log file path: /opt/dmdbms/data/DAMENG/DAMENG02.log
write to dir [/opt/dmdbms/data/DAMENG].
create dm database success. 2025-03-10 13:15:00
initdb V8
db version: 0x7000d
Init DM success!
Start DmAPService...
Starting DmAPService: [ OK ]
/opt/dmdbms/conf/dm.ini does not exist, use default dm.ini
Start DMSERVER success!
Dmserver is running.
DM Database is not OK, please wait...
DM Database is not OK, please wait...
DM Database is OK
Start DMSERVER success!
Dmserver is running.
DM Database is OK
Finished soft link DM current dm_DM8_01_202503.log to dm_DMSERVER.log
2025-03-10 13:15:25.954 [INFO] database P0000000096 T0000000000000000096 nsvr_process_before_open success.
2025-03-10 13:15:25.955 [INFO] database P0000000096 T0000000000000000150 hpc_clear_active_trx adjust n_crash_active_trx from 0 to 0.
2025-03-10 13:15:25.955 [INFO] database P0000000096 T0000000000000000257 nsvr_lsnr_thread successfully created.
2025-03-10 13:15:25.955 [INFO] database P0000000096 T0000000000000000096 backup control file /opt/dmdbms/data/DAMENG/dm.ctl to file /opt/dmdbms/data/DAMENG/dm_20250310131525_955708.ctl
2025-03-10 13:15:25.956 [INFO] database P0000000096 T0000000000000000096 backup control file /opt/dmdbms/data/DAMENG/dm.ctl to file /opt/dmdbms/data/DAMENG/ctl_bak/dm_20250310131525_956129.ctl succeed
2025-03-10 13:15:25.956 [INFO] database P0000000096 T0000000000000000096 local instance name is DM8_01, mode is NORMAL, status is OPEN.
2025-03-10 13:15:25.956 [INFO] database P0000000096 T0000000000000000096 SYSTEM IS READY.
2025-03-10 13:15:25.956 [INFO] database P0000000096 T0000000000000000096 [for dem]SYSTEM IS READY.
2025-03-10 13:15:25.956 [INFO] database P0000000096 T0000000000000000096 set g_dw_stat from UNDEFINED to NONE success, g_dw_recover_stop is 0
2025-03-10 13:15:26.955 [INFO] database P0000000096 T0000000000000000145 trx4_min_tid_collect set min_active_id_opt, min_active_id: 6773, first_tid: 6006
2025-03-10 13:18:17.027 [INFO] database P0000000096 T0000000000000000256 checkpoint requested by INI_INTERVAL, rlog free space[524083200], used space[12779520]
2025-03-10 13:18:17.027 [INFO] database P0000000096 T0000000000000000256 checkpoint generate by ckpt_interval
2025-03-10 13:18:17.027 [INFO] database P0000000096 T0000000000000000205 checkpoint begin, used_space[12779520], free_space[524083200]...
2025-03-10 13:18:17.030 [INFO] database P0000000096 T0000000000000000205 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2025-03-10 13:18:17.030 [INFO] database P0000000096 T0000000000000000205 ckpt2_log_adjust: ckpt_lsn(46182), ckpt_fil(0), ckpt_off(12746752), cur_lsn(46218), l_next_seq(3183), g_next_seq(3183), cur_free(12795904), total_space(536862720), used_space(49152), free_space(536813568), n_ep(1), db_open_id(1)
2025-03-10 13:18:17.030 [INFO] database P0000000096 T0000000000000000205 checkpoint end, 0 pages flushed, used_space[49152], free_space[536813568].
如上 日志显示已经正常启动
两种连接方式:
conn = dmPython.connect('sysdba', 'SYSDBA001', 'localhost:5236')
dmPython.apilevel
官方提供的这种方式 提示
(.conda) yf@yf-SA5212M5:~/workspaces/beihang$ python test_db.py
Traceback (most recent call last):
File "/home/yf/workspaces/beihang/test_db.py", line 3, in <module>
conn = dmPython.connect('sysdba', 'SYSDBA001', 'localhost:5236')
dmPython.DatabaseError: [CODE:-2501]用户名或密码错误
用docker 登录到容器中
docker exec -it dm8_01 /bin/bash
然后执行
root@e661ef33a705:/opt/dmdbms/bin# ./disql
disql V8
username:sysdba
password:
[-2501]:Invalid username or password.
username:
我测试了如下密码组合:
SYSDBA + SYSDBA001
sysdba + sysdba001
SYSDBA + SYSDBA
SYSDBA + sysdba123
SYSDBA + SYSDBA123
以上结果均提示密码错误
试了网上各种设置密码的方式,重新部署了十几次,最后实在受不了了去找了一个2024版本的镜像,第一次登录就成功了,离谱
试试SYSDBA_dm001