Open-WebUI 服务器本地部署

ggsmida · 2024 年11 月 14 日 00:43

1c1g的小鸡加上虚拟内存勉强运行

Reno · 2024 年11 月 15 日 10:34

谢谢您的建议！非常有帮助！

Cook_Sleep · 2024 年11 月 26 日 14:52

支持！

如果有朋友需要更加小白的部署教程：

Rookie · 2024 年11 月 30 日 12:10

这个Open-WebUI可真是太卡了，试了论坛里的优化方法，感觉没多大改善。

Diamond1noob · 2024 年12 月 12 日 05:59

大佬，想请教一下，如果想把postgres切换为mysql怎么操作呢，因为其他服务在用mysql，机器有限，

NaMei_ZZ · 2024 年12 月 12 日 06:38

官方暂时不支持，等后续吧

github.com/open-webui/open-webui

feat: support mysql.

open-webui:dev ← zy526:support-mysql

opened 03:05PM - 18 Aug 24 UTC

zy526

+50 -10

# Pull Request Checklist - [x] **Target branch:** Please verify that the pull r…equest targets the `dev` branch. - [x] **Description:** Provide a concise description of the changes made in this pull request. - [x] **Changelog:** Ensure a changelog entry following the format of [Keep a Changelog](https://keepachangelog.com/) is added at the bottom of the PR description. - [ ] **Documentation:** Have you updated relevant documentation [Open WebUI Docs](https://github.com/open-webui/docs), or other documentation sources? - [x] **Dependencies:** Are there any new dependencies? Have you updated the dependency versions in the documentation? - [x] **Testing:** Have you written and run sufficient tests for validating the changes? Yes, the testing was performed for postgres, sqlite and mysql successfully. - [x] **Code review:** Have you performed a self-review of your code, addressing any coding standard issues and ensuring adherence to the project's coding standards? - [x] **Prefix:** The pull request title is prefixed with "FEAT" to indicate a new feature. # Changelog Entry ### Description This pull request enhances to support mysql database besides sqlite and postgres. It'll solve the problem or feedback of the below discussions [How to use MySQL as database not noly sqlite.](https://github.com/open-webui/open-webui/discussions/4544) [Failed to start with mysql](https://github.com/open-webui/open-webui/discussions/3903) [Is possible to customize the OpenWebUI application database and Chrom](https://github.com/open-webui/open-webui/discussions/4288) [May I ask if I can use an external MySQL to store data?](https://github.com/open-webui/open-webui/discussions/2529) ### Changed - relevant migration scripts under backend/apps/webui/internal/migrations, so that to support sqlite, postgres and mysql during db schema creation and migration. - 007_add_user_last_active_at.py added database_type check, when that type is mysql, use `, while postgres or sqlite, use ". - for 009_add_models.py, 012_add_tools.py, 014_add_files.py, 015_add_functions.py, all the id = pw.TextField(unique=True) is changed to be pw.CharField(max_length=255, unique=True) so that it wouldn't hit limitation in mysql. - 017_add_user_oauth_sub.py the oauth_sub is changed to be pw.CharField(max_length=255, null=True, unique=True), so that it wouldn't hit limitation in mysql. - regarding backend/apps/webui/internal/wrappers.py, import MySQLDatabase, added reconnecting logic for it also. - There is new dependency added in backend/requirements.txt, which is mysqlclient==2.2.4. because sqlalchemy relies on it and it's more stable. ### Additional Information To use mysql database, just like using postgres, specify the DATABASE_URL as mysql://username:passwd@host:port/database ### Screenshots or Videos Please refer testing screenshots: For sqlite: ![SQLite1](https://github.com/user-attachments/assets/4e289622-bafe-4c36-9737-4b10641a3e78) ![SQLite2](https://github.com/user-attachments/assets/f2566423-3e6c-49c4-b07e-5604951983e8) For postgresql: ![Postgresql1](https://github.com/user-attachments/assets/c450c560-4093-4a65-bbb2-b52eb5b79835) ![Postgresql2](https://github.com/user-attachments/assets/94b844bf-47b3-4f4c-b737-68ccd5ae7164) ![Postgresql3](https://github.com/user-attachments/assets/d6f2ebe4-6294-4770-a091-bb5481e05d07) For mysql: ![MySQL1](https://github.com/user-attachments/assets/bb26b8ea-ae5d-4ae0-8085-6a53d5409295) ![MySQL2](https://github.com/user-attachments/assets/4bfef448-a081-4dce-87ad-41547af8d7e0) ![MySQL3](https://github.com/user-attachments/assets/1f421455-4eaf-455b-8379-47dc3a3a684e)

Diamond1noob · 2024 年12 月 12 日 06:57

好吧，麻了，要启动多个sql，那边也不能换，我的垃圾小鸡有点不堪重负

NaMei_ZZ · 2024 年12 月 12 日 07:02

可以sqlite啊，做好挂载就行

Diamond1noob · 2024 年12 月 12 日 07:05

我记得如果不配置sql的话默认是不是就是sqlite

NaMei_ZZ · 2024 年12 月 12 日 07:06

对，但是你不设置挂载的话，sqlite文件是在docker内部的，容易丢，最好是挂载到你的机器上

话题		回复	浏览量
Open-WebUI 快速部署开发调优教程 , 人工智能	23	1431	2024 年12 月 13 日
求助各位佬友要不要换服务器开发调优快问快答	20	1106	2024 年12 月 18 日
腾讯云GPU+Ollama+开源模型+搭配OpenWebUI 资源荟萃人工智能 , 纯水	52	2182	2024 年12 月 19 日
抱脸部署OpenWebUI教程资源荟萃人工智能 , OpenWebUI	211	11184	2024 年12 月 21 日
10秒，优雅的部署本地大模型ollama+openwebui 资源荟萃人工智能	32	2530	2024 年12 月 9 日

Open-WebUI 服务器本地部署

相关话题