在节点v11.2.0的Ubuntu18.04中无法运行PopSQL

Question

为了学习MySQL，我使用.deb包安装了PopSQL，但它不起作用，当我使用sudo popsql从终端启动PopSQL时，我在终端中得到了这些错误，PopSQL ui显示了空白屏幕。

{"name":"PopSQL","hostname":"ivyRose","pid":16621,"level":30,"msg":"Starting app. Look for crash reports in /tmp and error logs in /home/neon/.config/PopSQL/error.log","time":"2018-11-22T12:15:27.927Z","v":0}

(popsql:16621): IBUS-WARNING **: 18:00:28.174: The owner of /home/neon/.config/ibus/bus is not root!
[Oracle] NJS-045: cannot load the oracledb add-on binary for Node.js 8.2.1 (linux, x64)
Node.js require() error was: 
  DPI-1047: 64-bit Oracle Client library cannot be loaded: "libclntsh.so: cannot open shared object file: No such file or directory". See https://oracle.github.io/odpi/doc/installation.html#linux for help
Node.js require() mapped to /opt/PopSQL/resources/app.asar/node_modules/oracledb/build/Release/oracledb.node
Node-oracledb installation instructions: https://github.com/oracle/node-oracledb/blob/master/INSTALL.md
You must have 64-bit Oracle client libraries in LD_LIBRARY_PATH, or configured with ldconfig.
If you do not have Oracle Database on this computer, then install the Instant Client Basic or Basic Light package from 
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

[ODBC] libodbc.so.1: cannot open shared object file: No such file or directory

Answer 1

你不需要PopSQL来学习MySQL。

但是，如果您想要运行，请按照错误消息说明进行：

1. 从http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html下载即时客户端基本轻型包
2. 解拉链
3. 通过LD_LIBRARY_PATH或使用ldconfig将目录添加到库搜索路径(我建议使用后者)，如inst所示

当需要oracledb时，PopSQL应该使用try/catch块，这样您就不会看到错误。

Answer 2

看起来，您缺少了mysql所需的驱动程序。您可以从

https://dev.mysql.com/downloads/connector/odbc/

这里的答案应该会有所帮助。

https://askubuntu.com/questions/800216/installing-ubuntu-16-04-lts-how-to-install-odbc?answertab=votes#tab-top