Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

使用helm安装,使用外部MySQL库,没有新建表 #95

Open
kazu12 opened this issue May 25, 2023 · 3 comments
Open

使用helm安装,使用外部MySQL库,没有新建表 #95

kazu12 opened this issue May 25, 2023 · 3 comments

Comments

@kazu12
Copy link

kazu12 commented May 25, 2023

helm安装,MySQL使用外部数据库,database下没有新建表指令,导致n9e主实例崩溃。
`runner.cwd: /app
runner.hostname: n9e-nightingale-center-6bb5866f77-pxsh5
runner.fd_limits: (soft=1048576, hard=1048576)
runner.vm_limits: (soft=unlimited, hard=unlimited)

2023/05/25 11:13:34 /home/runner/work/nightingale/nightingale/models/user.go:179 Error 1146: Table 'n9e_v6.users' doesn't exist
[0.845ms] [rows:0] SELECT * FROM users WHERE username='root'
`

@kongfei605
Copy link
Contributor

kongfei605 commented May 25, 2023

内部数据库是利用pod启动时创建db。helm不管理外部数据库,只是连接,写入等。

@kazu12
Copy link
Author

kazu12 commented May 25, 2023

请问能提供建表SQL语句吗?

修改values.yaml。使用内部MySQL,MySQL出现另外一个问题:

2023-05-25 14:16:22+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.36-1debian10 started. 2023-05-25 14:16:22+08:00 [Note] [Entrypoint]: Initializing database files 2023-05-25T06:16:22.373507Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2023-05-25T06:16:22.374717Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting. 2023-05-25T06:16:22.374733Z 0 [ERROR] Aborting

@kongfei605
Copy link
Contributor

建表的sql都在夜莺的repo中 ,可以在夜莺中找 https://github.com/ccfos/nightingale/tree/main/docker/initsql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants