使用离线包sqlbot-offline-installer-v1.8.0-ce启动失败

[believerHan]

配置如下：

基础配置

安装目录

SQLBOT_BASE=/opt

SQLBot 端口

SQLBOT_WEB_PORT=8000
SQLBOT_MCP_PORT=8001

数据库配置

是否使用外部数据库

SQLBOT_EXTERNAL_DB=false

数据库地址

SQLBOT_DB_HOST=10.10.90.166

数据库端口 (仅使用外部数据库时才生效)

SQLBOT_DB_PORT=5432

SQLBot 数据库库名

SQLBOT_DB_DB=sqlbot

数据库用户名

SQLBOT_DB_USER=root

数据库密码，密码如包含特殊字符，请用双引号引起来

SQLBOT_DB_PASSWORD=root

其他配置

普通用户默认密码

SQLBOT_DEFAULT_PWD=123456

SQLBot Secret Key

SQLBOT_SECRET_KEY=y5txe1mRmS_JpOrUzFzHEu-kIQn3lf7ll0AOv9DQh0s

Cross-Origin Resource Sharing (CORS) 设置

SQLBOT_CORS_ORIGINS=http://10.10.90.166,http://10.10.90.166:5173,https://10.10.90.166,https://10.10.90.166:5173

日志级别 DEBUG, INFO, WARNING, ERROR

SQLBOT_LOG_LEVEL="INFO"

缓存类型

SQLBOT_CACHE_TYPE="memory"

MCP 图片存储路径

SQLBOT_SERVER_IMAGE_HOST=http://10.10.90.166:8001/images/
##Token过期时间: 60 minutes * 24 hours * 8 days = 11520 minutes
SQLBOT_ACCESS_TOKEN_EXPIRE_MINUTES=11520
报错如下：
t_ddl
sqlbot | 2026-06-05 15:41:41,732 - alembic.runtime.migration - INFO:621 - Running upgrade 6549e47f9adc -> 3cb5d6a54f2e, 033_chat_origin_ddl
sqlbot | 2026-06-05 15:41:41,733 - alembic.runtime.migration - INFO:621 - Running upgrade 3cb5d6a54f2e -> e8b470d2b150, 034_field_sort
sqlbot | 2026-06-05 15:41:41,734 - alembic.runtime.migration - INFO:621 - Running upgrade e8b470d2b150 -> 29559ee607af, 035_sys_arg_ddl
sqlbot | 2026-06-05 15:41:41,740 - alembic.runtime.migration - INFO:621 - Running upgrade 29559ee607af -> 646e7ca28e0e, 036_modify_assistant
sqlbot | 2026-06-05 15:41:41,742 - alembic.runtime.migration - INFO:621 - Running upgrade 646e7ca28e0e -> 68a06302cf70, 035_create_chat_log
sqlbot | 2026-06-05 15:41:41,749 - alembic.runtime.migration - INFO:621 - Running upgrade 68a06302cf70 -> fc23c4f3e755, 038_remove_chat_record_cloumns
sqlbot | 2026-06-05 15:41:41,752 - alembic.runtime.migration - INFO:621 - Running upgrade fc23c4f3e755 -> 25cbc85766fd, 039_create_terminology
sqlbot | ERROR: Traceback (most recent call last):
sqlbot | File "/opt/sqlbot/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
sqlbot | self.dialect.do_execute(
sqlbot | File "/opt/sqlbot/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
sqlbot | cursor.execute(statement, parameters)
sqlbot | File "/opt/sqlbot/app/.venv/lib/python3.11/site-packages/psycopg/cursor.py", line 117, in execute
sqlbot | raise ex.with_traceback(None)
sqlbot | psycopg.errors.FeatureNotSupported: extension "vector" is not available
sqlbot | DETAIL: Could not open extension control file "/opt/bitnami/postgresql/share/extension/vector.control": No such file or directory.
sqlbot | HINT: The extension must first be installed on the system where PostgreSQL is running.
sqlbot |
sqlbot | The above exception was the direct cause of the following exception:
sqlbot |
sqlbot | Traceback (most recent call last):
sqlbot | File "/opt/sqlbot/app/.venv/lib/python3.11/site-packages/starlette/routing.py", line 692, in lifespan
sqlbot | async with self.lifespan_context(app) as maybe_state:
sqlbot | File "/usr/local/lib/python3.11/contextlib.py", line 210, in aenter

[xuwei-fit2cloud]

因为第一次安装没成功，所以比较简单的办法是执行安装包里的 uninstall.sh 命令卸载，然后重新安装一下。
如果要使用外部 pg 数据库的话，需要在安装配置文件install.conf 里将SQLBOT_EXTERNAL_DB设置成 true，且需要保证外部 pg 数据库安装了 pgvector 扩展。
如果要使用内部 pg 数据库的话，则注意 install.conf 里的SQLBOT_EXTERNAL_DB设置成 false，且SQLBOT_DB_HOST=localhost。