lazzyfu / goinsight Goto Github PK

View Code? Open in Web Editor NEW

615.0 26.0 195.0 87.12 MB

集MySQL数据库工单和数据查询的Web平台

License: MIT License

Vue 40.00% JavaScript 11.01% Less 0.88% Dockerfile 0.01% Go 48.09%

mysql tidb gaudit go order clickhouse data-query-ui

goinsight's Introduction

Hi ~

About Me

给岁月以文明，给时光以生命。

goinsight's People

Contributors

Stargazers

Watchers

Forkers

kevin1898 zhanglei qyt2018 org8888 jeffreymingyue databaseresearch jackerzhou whantt zjdpf tom2jack lukehuang winnerwn lujianduan guofengchao wxgang168 progpark jiangming1 newbelee limuitech taco-wang looism jjxxff2000 frank8862017 dingzhaopeng 5sdba hanchuanchuan minggeng b-xiang dolphinsboy myocm pengyuanwen cloudufull a1418692409 alwynxu fanlifei zhaozlgit abaozone hulaoan zkd01 leihuagh tonyzhimin cnbillow antflux cfz1860 xdd0102 zwunix jiangnanora giftlee junetws gitjacky wangyu0817 felix98205 bbotte caiqing0204 haochenxiao666 zhaojinhong qt-pay turi-fly szliuyujie slamdunkdcc lkcjh yanzongzhen ifpython huanlongzhou zj15243885020 wzxjayce qq290070744 wangjianshan jinjin123 gdzy1987 jdk6979 ghzeng ddzzj dbsky1985 lydialyd0121 xingganfengxing xcg zyx852963 zhouyh139 thb7758 tangzhen10 woniuzhang wangkunk callmedba touchgold songfucai gavinhwa lmy4710 taozywu funjackyone hear7 qiu957919102 fannyfur gbsnaker liugaohui luolin0313 zhengjunqiang 18621621452 neeky isgasho

goinsight's Issues

delete操作，如果值里面有['auth_user_groups', 'cmdb_module']这种的值的话，生成的回滚语句有问题

优化memory相关metrics名字

total_memory容易引起歧义，会以为是redis实例的总内存
另外加个maxmeory展示吧

本月底发布新版本

支持自定义级联环境(可以定义多个，根据自己业务需求)
集成钉钉推送、邮件推送、支持自定义开启，同时支持同时推送
支持多实例、多集群（解决了当前版本的重复库名问题）
优化了上线任务版本号、钩子功能
优化了后台配置，实现了更友好的配置
6.一些其他的优化，比如：用户头像修改、样式等

MySQL5.7.8 版本以下不支持 MAX_EXECUTION_TIME设置

可以增加下MySQL版本的兼容性说明，或者支持兼容低版本集群，毕竟5.6也还是主流。

配置https

该系统支持配置https支持，需要手动修改如下代码：

https流程：
web --> https(自己部署的ssl证书) --> docker(nginx)

vim static/c_websocket.js 
let socket = new WebSocket('ws://' + window.location.host + '/ws/');
修改为：
let socket = new WebSocket('wss://' + window.location.host + '/ws/');

vim templates/sqlquery/sql_query.html
let socket = new WebSocket('ws://' + window.location.host + '/ws/');
修改为：
let socket = new WebSocket('wss://' + window.location.host + '/ws/');

vim templates/webshell/webshell.html

sock = new WebSocket('ws://' + window.location.host + '/ssh/'),
修改为：
sock = new WebSocket('wss://' + window.location.host + '/ssh/'),

初始化SQL错误

(yasql) [root@10-77-10-166 yasql]# python3 manage.py migrate
段错误(吐核)

首页 › MySQL查询 › 库表业务组 › 增加库表业务组中“映射的mysql用户:”添加报错403 Forbidden

2019-05-22 14:48:31,344 [uWSGIWorker4Core0:140672907941952] [django.request:228] [log:log_response] [WARNING]- Forbidden (Permission denied): /admin/query/mysqlusergroupmap/add/
Traceback (most recent call last):
File "/venv_py36/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/venv_py36/lib/python3.6/site-packages/django/core/handlers/base.py", line 126, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/venv_py36/lib/python3.6/site-packages/django/core/handlers/base.py", line 124, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/options.py", line 604, in wrapper
return self.admin_site.admin_view(view)(*args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/utils/decorators.py", line 142, in _wrapped_view
response = view_func(request, *args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/views/decorators/cache.py", line 44, in _wrapped_view_func
response = view_func(request, *args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/sites.py", line 223, in inner
return view(request, *args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/options.py", line 1637, in add_view
return self.changeform_view(request, None, form_url, extra_context)
File "/venv_py36/lib/python3.6/site-packages/django/utils/decorators.py", line 45, in _wrapper
return bound_method(*args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/utils/decorators.py", line 142, in _wrapped_view
response = view_func(request, *args, **kwargs)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/options.py", line 1525, in changeform_view
return self._changeform_view(request, object_id, form_url, extra_context)
File "/venv_py36/lib/python3.6/site-packages/django/contrib/admin/options.py", line 1542, in _changeform_view
raise PermissionDenied
django.core.exceptions.PermissionDenied

新版本2.1.0

修复左侧导航栏点击后自动折叠bug
优化celery异步任务，结果推送
支持SQL语法自动补全、支持表名、列名补全
新增定时任务功能，支持定义表结构监控、数据库备份
体验优化，其他bug修复等

test

咨询：能否修改项目开源协议？

作者鼓励二开，但是我看协议是gpLv3，使用担心有污染风险公司内部不允许使用。

docker部署的文档怎么了

docker部署的文档怎么了，能否提供docker部署的

语法检查报“语法检查失败，错误码：413”

一次提交了9K多条dml语句，语法检查报错413

后端安装Twisted的时候出错

set up ldap auth

AUTH_LDAP_BIND_DN = "uid=root,cn=root,cn=root,dc=xinchanedu,dc=com"
这两个cn是写原来DEMO里的，还是写UID的，我的一直不行

角色权限

你这块角色权限是需要手动插入数据吧，默认没有角色权限数据，后台管理我看你代码也是关了着的

开发者，您好，可以支持一下postgresql吗？

开发者，您好，可以支持一下postgresql吗？
这是非常伟大的一款产品，但希望可以支持一下postgresql,谢谢

python manage.py migrate建表结构报错

报：ImportError: cannot import name 'charset_to_encoding'

ModuleNotFoundError: No module named 'celery.apps'

(auditsql) [root@devops opsql]# celery worker -A opsql --loglevel=INFO --time-limit=7200 --concurrency=10 --uid=nginx
Traceback (most recent call last):
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/kombu/utils/objects.py", line 42, in __get__
KeyError: 'Worker'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/.virtualenvs/auditsql/bin/celery", line 10, in <module>
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/__main__.py", line 16, in main
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/celery.py", line 322, in main
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/celery.py", line 496, in execute_from_commandline
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/base.py", line 275, in execute_from_commandline
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/celery.py", line 488, in handle_argv
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/celery.py", line 420, in execute
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/worker.py", line 223, in run_from_argv
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/base.py", line 238, in __call__
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/bin/worker.py", line 252, in run
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/kombu/utils/objects.py", line 44, in __get__
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/app/base.py", line 1100, in Worker
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/celery/app/base.py", line 1026, in subclass_with_self
  File "/root/.virtualenvs/auditsql/lib/python3.6/site-packages/kombu/utils/imports.py", line 56, in symbol_by_name
  File "/root/.virtualenvs/auditsql/lib/python3.6/importlib/__init__.py", line 126, in import_module
  File "<frozen importlib._bootstrap>", line 994, in _gcd_import
  File "<frozen importlib._bootstrap>", line 971, in _find_and_load
  File "<frozen importlib._bootstrap>", line 941, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "<frozen importlib._bootstrap>", line 994, in _gcd_import
  File "<frozen importlib._bootstrap>", line 971, in _find_and_load
  File "<frozen importlib._bootstrap>", line 953, in _find_and_load_unlocked
ModuleNotFoundError: No module named 'celery.apps'
(auditsql) [root@devops opsql]# pwd
/data/web/opsql
(auditsql) [root@devops opsql]#

(auditsql) [root@devops opsql]# python -m pip freeze
aioredis==1.2.0
amqp==2.4.2
asgiref==2.3.2
asn1crypto==0.24.0
astroid==2.2.5
async-timeout==3.0.1
attrs==19.1.0
autobahn==19.2.1
Automat==0.7.0
bcrypt==3.1.6
billiard==3.5.0.5
celery==4.2.1
certifi==2019.3.9
cffi==1.12.2
channels==2.1.7
channels-redis==2.3.3
chardet==3.0.4
constantly==15.1.0
cryptography==2.6.1
daphne==2.2.5
DingtalkChatbot==1.3.0
Django==2.2.3
django-auth-ldap==1.7.0
django-celery-beat==1.4.0
django-celery-results==1.0.4
django-redis==4.10.0
django-stubs==1.0.2
django-timezone-field==3.0
djangorestframework==3.9.2
djangorestframework-stubs==0.3.0
et-xmlfile==1.0.1
gevent==1.4.0
greenlet==0.4.15
hiredis==1.0.0
humanfriendly==4.18
hyperlink==18.0.0
idna==2.8
incremental==17.5.0
isort==4.3.20
jdcal==1.4
kombu==4.4.0
lazy-object-proxy==1.4.1
mccabe==0.6.1
meld3==1.0.2
msgpack==0.6.1
mypy==0.720
mypy-extensions==0.4.1
mysql-replication==0.18
mysqlclient==1.3.13
openpyxl==2.6.1
paramiko==2.4.2
Pillow==5.4.1
pyasn1==0.4.5
pyasn1-modules==0.2.4
pycparser==2.19
PyHamcrest==1.9.0
pylint==2.3.1
PyMySQL==0.9.3
PyNaCl==1.3.0
python-crontab==2.3.6
python-dateutil==2.8.0
python-ldap==3.2.0
pytz==2018.9
redis==3.2.0
requests==2.21.0
simplejson==3.16.0
six==1.12.0
sqlparse==0.3.0
supervisor==4.0.4
Twisted==19.2.1
txaio==18.8.1
typed-ast==1.3.5
typing-extensions==3.7.4
urllib3==1.24.2
uWSGI==2.0.18
vine==1.2.0
wrapt==1.11.1
zope.interface==4.6.0

下一个开发功能（版本:2.2.0）

实现MySQL查询接口，提供给开发查询数据使用，避免使用本地navicat等客户端
实现查询的审核功能，记录开发的相关操作

留个联系方式

您好,请问为啥我这边没有权限管理,用户管理,数据库管理啥的呢?

您好,我登录的是管理员账号,但是没有用户管理,权限管理,数据库管理啥的,是不是项目的初始化迁移数据不完整呢?另外能让我进下qq群吗,谢谢

可以支持英文吗？

本地dev环境配置

Hello，请问此平台可以mac本地安装开发环境么，是否有相应文档呢

这个DML语句备份到底是怎么使用的

DML语句执行成功，备份一直不可以。这个具体还需要怎么配置，他备份的的sql或者文件是存在那里

系统使用的mysql、redis等最好能自己配置连接

【不影响使用】bootstrap.css和ant design vue的样式冲突导致icon移位

目前发现bootstrap.min.css和ant design vue的样式冲突，导致icon移位问题。
该BUG不影响使用，暂时未解决，会影响部分icon和文字错位，视觉差不大。
开发者有强迫症，寻找有前端很厉害的可以帮忙解决下，感谢~
例如：

執行gh-ost 遇到錯誤

執行gh-ost遇到註解為中文的報錯問題
'ascii' codec can't encode characters in position 343-348: ordinal not in range(128)

请问这个可以用windows的pycharm开发工具运行吗?

请问这个可以用windows的pycharm开发工具运行吗?或者有没用教程呢,我运行不起来

請問如何正確重啟Incecption

請問如何正確重啟Incecption?

kill -9 inception
./opt/inception/bin/Inception --defaults-file=/etc/inception.cnf &

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 100' at line 58

工单系统执行 sql出现语法错误，在服务器端及 Navicat 都可以运行成功。
sql如下：

55 (SELECT b.*
56 FROM um AS b
57 join
58 (select um_no
59 from um_d where license_status ='01' limit 2290010,10) a on a.um_no=b.um_no

时间：2019/9/23 上午10:16:58
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 59

这么牛逼的东西，组qq群交流呗

前台页面无法打开，一直在转圈圈

前台页面无法打开，/admin后端页面没问题。换了好几个版本的Nginx了

提交导出工单的文件在那里？

正在执行导出SQL: select * from pay_package_deals_details p where p.trader_type='一般纳税人' and p.invoice_type='增值税专用发票'

正在处理并生成CSV数据

正在压缩文件: export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv -> export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv.zip

7-Zip (a) [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21
p7zip Version 16.02 (locale=en_US.UTF-8,Utf16=on,HugeFiles=on,64 bits,2 CPUs Intel(R) Xeon(R) CPU E7-4830 v2 @ 2.20GHz (306E7),ASM,AES-NI)

Scanning the drive:
1 file, 17177 bytes (17 KiB)

Creating archive: export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv.zip

Items to compress: 1

Files read from disk: 1
Archive size: 2980 bytes (3 KiB)
Everything is Ok
删除临时文件: export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv

删除临时文件: export_file_452a642ff8f346ef819df2b403c2e8a6_16049031454893.csv.zip

执行耗时: 0.059

按照文档部署，niginx报500

访问主页跳转到登陆后变成500

nginx没有错误日志没有内容，是否是最新代码登陆这块有问题，求指导，谢谢！！！