Meituan-Dianping / SQLAdvisor

输入SQL,输出索引优化建议
GNU General Public License v2.0
5.58k stars 1.24k forks source link

安装最后失败 #60

Open slimina opened 6 years ago

slimina commented 6 years ago

[root@devcenter-8-36 sqladvisor]# sudo cmake -DCMAKE_BUILD_TYPE=debug ./ -- The C compiler identification is GNU 4.8.5 -- The CXX compiler identification is GNU 4.8.5 -- Check for working C compiler: /bin/cc -- Check for working C compiler: /bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Check for working CXX compiler: /bin/c++ -- Check for working CXX compiler: /bin/c++ -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Configuring done -- Generating done -- Build files have been written to: /opt/software/SQLAdvisor/sqladvisor [root@devcenter-8-36 sqladvisor]# make Scanning dependencies of target sqladvisor [100%] Building CXX object CMakeFiles/sqladvisor.dir/main.cc.o In file included from /usr/local/sqlparser/include/sql/item.h:2470:0, from /usr/local/sqlparser/include/sql/sql_class.h:39, from /opt/software/SQLAdvisor/sqladvisor/main.cc:6: /usr/local/sqlparser/include/sql/item_timefunc.h: In member function ‘virtual longlong Item_time_func::val_int()’: /usr/local/sqlparser/include/sql/item_timefunc.h:533:12: warning: converting to non-pointer type ‘longlong {aka long long int}’ from NULL [-Wconversion-null] return NULL; ^ Linking CXX executable sqladvisor /usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../lib64/libperconaserverclient_r.so: undefined reference to X509_check_ip@libcrypto.so.10' /usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../lib64/libperconaserverclient_r.so: undefined reference toX509_check_host@libcrypto.so.10' collect2: error: ld returned 1 exit status make[2]: [sqladvisor] Error 1 make[1]: [CMakeFiles/sqladvisor.dir/all] Error 2 make: *** [all] Error 2

herouu commented 6 years ago

同样的问题,不知道是什么鬼

pengpai2016 commented 6 years ago

我遇到同样问题,执行 yum install openssl-devel 解决。

ppabc commented 6 years ago

美团SQLAdvisor工具docker镜像 https://aqzt.com/5390.html docker run -d --name=sqladvisor ppabc/sqladvisor