myide / see Goto Github PK

View Code? Open in Web Editor NEW

1.5K 69.0 599.0 48.05 MB

基于开源组件（Inception & SQLAdvisor & SOAR）的SQL审核&SQL优化的Web平台

License: Eclipse Public License 2.0

Python 4.25% HTML 0.06% Vue 94.77% CSS 0.92%

mysql django inception vue sqladvisor soar

see's People

Contributors

Stargazers

Watchers

Forkers

klande mh-zook weiguang1017 lannyma eagle2015 cdz620 joewen85 linuxzh wynallen rain0193 chenyzhe ilovedocker zhangyunan1994 hjc123186 tomlinux coosir ltxin dfcoding bobzhanggmail qingduyu cnbillow wuchengjiang dikang123 dingyiran yangruiyou85 hhr66 chenjinhui520 sunyongtao87 limuitech cmccone ifpython fuquanjun wopost jackerzhou yezimai tom2jack 957204459 qyt2018 liliang8858 cnjllin pytomtoto kurolz ayocross ethan-2017 frank8862017 hello-000 sysoadv 948990668 hanchuanchuan zwunix xyl5869 pengyuanwen jions7ihj huangzhiyong xzwen96 liuyongqing1 israel-lu zhulibo86 kjilupin guaiwolou showsmall 07053220ab vamxiaomi raopeng rob-bao yiyufeng1986 wangwei0326 bbcw zshmmm dengyingguo dbhelp nanzhushan 49257620 liuziping thinkingqi asd80703406 whantt duiniwukenaihe yunshitiger lehman3087 aaronzmia weijie199148 luyouli izhangyuer dbaops-com looism jasonchoi517 lsjun eagle9527 ren-i jason-liew ecore2018 zksfyz yuzg667 xingcici nicksors zhaozlgit wsaxun zhaojinhong loveliuli

see's Issues

工单审核报数据库连接错误

报错信息如下：
{"MySQL连接异常 ":"((1, 'NONE', 2, 'None', 'Invalid source infomation.', 'Global environment', 0, 'None', 'None', '0', 'None'),)"}

请问mysql是不是要二进制安装？什么时候有docker部署呢？

centos7用yum安装MySQL后，后面步骤又要卸载，请问是不是之前的mysql前提是二进制包下载后安装？如有docker部署可能会好一些

sql语句过长引起的问题

查询优化->sql评分，当sql语句长度超过get请求的长度时，会报错，不方便长语句的优化

建议使用社区维护新版sql索引审查建议模块

现由社区共同维护，看到see使用到了sqladvisor，建议使用社区维护新版：https://github.com/mysqladvisor/MySQLAdvisor

安装步骤混乱，希望能更新。

在步骤4.2 安装依赖中，把 mysql 卸载了yum remove -y mysql-community-client mysql-community-server mysql-community-common mysql-community-libs
然后在7.4 中又做 migration
有点莫名其妙

http://oldcat.online:52080/ 演示网站暂时无法访问

http://oldcat.online:52080/ 演示网站暂时无法打开，麻烦帮忙查看下呢

工单点击执行，inception日志显示执行了2次update

如图所示

about db

Is the environment dependent on percona or mysql

sql审核那块，建表语句语法检测必须字段为非空哪里可以设置，我已经关闭inception了

回滚时报错，但找不到错误信息

如上图，报错时提示查看Inception结果集，但Inception日志输出并无错误

pip install -r requirements.txt 安装失败

windows 下 pip install -r requirements.txt 安装各种依赖报错，能整理一个详细安装文档吗，问一下作者，实在windows 下开发的吗

500 Internal Server Error

http://xxx.xxx.xx.xx/api/dashboard/chart/

500 Internal Server Error

/usr/bin/ld: cannot find -lperconaserverclient_r

1> 编译sqladvisor时依赖perconaserverclient_r, 因此需要安装Percona-Server-shared-56。
#wget http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
#yum install percona-release-0.1-3.noarch.rpm -y
#yum install Percona-Server-shared-56 -y
2> 编译sqladvisor的依赖项sqlparser（源码目录）
#cd /usr/local/src/SQLAdvisor/
#cmake -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=debug -DCMAKE_INSTALL_PREFIX=/usr/local/sqlparser -DIGNORE_AIO_CHECK=/usr/share/doc/libaio-0.3.109 ./
#make && make install
3> 编译sqladvisor(源码目录)
#cd ./sqladvisor/
#cmake -DCMAKE_BUILD_TYPE=debug ./
#make

4> Finished

frontend 安装编译报错

文档上没有frontend的安装操作步骤，在frontend目录下执行npm install 然后在执行npm run build报错

更新数据一直显示执行中，但实际mysql端以完成执行。

比如没有数据delete,update是返回很快。执行成功。
一旦执行有数据，实际也commit了。始终显示执行中。

npm run build 报错

[root@vultr frontend]# npm run build 

> [email protected] build /root/see/frontend
> webpack --progress --hide-modules --config build/webpack.prod.config.js

clean-webpack-plugin: /root/see/frontend/dist/* has been removed.
Happy[happybabel]: Version: 4.0.1. Threads: 1 (shared pool)
fs.js:128
  throw new ERR_INVALID_CALLBACK();
  ^

TypeError [ERR_INVALID_CALLBACK]: Callback must be a function
    at maybeCallback (fs.js:128:9)
    at Object.write (fs.js:540:14)
    at /root/see/frontend/build/webpack.prod.config.js:16:8
    at FSReqWrap.args [as oncomplete] (fs.js:140:20)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] build: `webpack --progress --hide-modules --config build/webpack.prod.config.js`
npm ERR! Exit status 1
npm ERR! 
npm ERR! Failed at the [email protected] build script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     /root/.npm/_logs/2019-06-28T07_09_09_510Z-debug.log
[root@vultr frontend]# ls dist/clean-webpack-plugin
ls: cannot access dist/clean-webpack-plugin: No such file or directory

为用户分配权限报错500 Internal Server Error

功能是不错，把密码放Cookie里是否有点太飘了呢？

请问下mysql5.7是如何支持的呢？因为我看到inception是不支持的5.7的

SQLAdvisor结束！错误日志:Invalid parameter number

部署后测试SQL优化功能，填写的语句是
select * from area limit 100;

点击查询在右侧第3行就显示报错
SQLAdvisor结束！错误日志:Invalid parameter number

只有审核功能，没有查询功能吗

对比了一下see、archery、yearning，感觉archery的工作最全，包含sql审核，sql查询，binlog2sql，soar优化、sechemasync、thimes等功能。

希望see也有这些功能。

inception 安装失败

/usr/local/inception-master/sql/sql_yacc.yy:31:23: 错误：‘yythd’在此作用域中尚未声明
#define YYTHD ((THD *)yythd)

环境:
centos7 mysql(5.6,5.7,8)均尝试，bison 2.5.1
求大神帮助

工单创建后，点击执行，没有任何响应

创建一个新的工单，提交审核后，点击执行，没有任何相应，再次点击就提示工单已经锁定，等一会儿（解锁之后）在次点击就会立即执行，这个是里面是什么逻辑？是有bug还是我操作方式有问题？
我在demo平台上测试了下，创建了3个工单，一次点击执行，也偶有这个状况出现，但是比我本地的情况好很多
测试的建表语句用的utils中的那个示例，测试insert语句，结果也同上。

inception回滚看不到回滚语句

Dashboard 怎么启动的

建议：添加Dockerfile

see 项目整合了许多组件，功能强大。但于此同时，确实增加了安装的复杂性。对于想体验的同学，并不是很友好。因此建议作者添加Dockerfile，以简化安装，让新同学更方便体验。

默认用户名密码是什么呀？

请问，默认用户名密码是什么呀？

安装好后，没法登陆啊。大大

任务异常有点笼统

测试的时候发现，任务异常没有任何原因的日志出现的web页面
1 比如执行的时候warning，会出现任务异常，但是sql已经执行成功了
2 如果一大堆sql中出现一条执行报错，但是这个sql之前的也会执行成功，没有任何提示

建议新增docker，安装有点麻烦

备份库连接失败 500 Internal Server Error

[2019-03-28 18:17:53,310][MainThread:140695313114944][task_id:django.request][exception.py:118][ERROR][Internal Server Error: /api/sqlmng/inception/conncheck/]
Traceback (most recent call last):
File "/usr/local/python3.6/lib/python3.6/configparser.py", line 1138, in _unify_values
sectiondict = self._sections[section]
KeyError: 'inception'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/local/seevenv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 35, in inner
response = get_response(request)
File "/usr/local/seevenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 128, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/seevenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 126, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/seevenv/lib/python3.6/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
return view_func(*args, **kwargs)
File "/usr/local/seevenv/lib/python3.6/site-packages/django/views/generic/base.py", line 69, in view
return self.dispatch(request, *args, **kwargs)
File "/usr/local/seevenv/lib/python3.6/site-packages/rest_framework/views.py", line 483, in dispatch
response = self.handle_exception(exc)
File "/usr/local/seevenv/lib/python3.6/site-packages/rest_framework/views.py", line 443, in handle_exception
self.raise_uncaught_exception(exc)
File "/usr/local/seevenv/lib/python3.6/site-packages/rest_framework/views.py", line 480, in dispatch
response = handler(request, *args, **kwargs)
File "/usr/local/seevenv/see-master/backend/sqlmng/views/settings.py", line 122, in post
ret = func(self, request)
File "/usr/local/seevenv/see-master/backend/sqlmng/mixins.py", line 95, in inception_backup
password = self.conf.get('inception', 'inception_remote_system_password')
File "/usr/local/python3.6/lib/python3.6/configparser.py", line 781, in get
d = self._unify_values(section, vars)
File "/usr/local/python3.6/lib/python3.6/configparser.py", line 1141, in _unify_values
raise NoSectionError(section)
configparser.NoSectionError: No section: 'inception'

能把Inception切换到goInception吗？Inception已经闭源商业化了。

改完setting文件后如何重启这个项目

除了grep python杀掉进程这种方法还有别的吗

see报错

Traceback (most recent call last):
File "/data/vmpython/lib/python3.6/site-packages/django/core/handlers/exception.py", line 35, in inner
response = get_response(request)
File "/data/vmpython/lib/python3.6/site-packages/django/core/handlers/base.py", line 128, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/data/vmpython/lib/python3.6/site-packages/django/core/handlers/base.py", line 126, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/data/vmpython/lib/python3.6/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
return view_func(*args, **kwargs)
File "/data/vmpython/lib/python3.6/site-packages/django/views/generic/base.py", line 69, in view
return self.dispatch(request, *args, **kwargs)
File "/data/vmpython/lib/python3.6/site-packages/rest_framework/views.py", line 483, in dispatch
response = self.handle_exception(exc)
File "/data/vmpython/lib/python3.6/site-packages/rest_framework/views.py", line 443, in handle_exception
self.raise_uncaught_exception(exc)
File "/data/vmpython/lib/python3.6/site-packages/rest_framework/views.py", line 480, in dispatch
response = handler(request, *args, **kwargs)
File "/data/see/backend/sqlmng/views/settings.py", line 111, in post
ret = func(self, request)
File "/data/see/backend/sqlmng/mixins.py", line 127, in inception_backup
password = self.conf.get('inception', 'inception_remote_system_password')
File "/data/python3/lib/python3.6/configparser.py", line 781, in get
d = self._unify_values(section, vars)
File "/data/python3/lib/python3.6/configparser.py", line 1141, in _unify_values
print section

inception 测试无问题，可以正常进行备份，但是页面点击备份数据库连接失败

支持mssql吗？

sql server 2016