Can't run PopSQL in Ubuntu 18.04 with node v11.2.0
1
To learn MySQL I installed PopSQL using .deb package but it's not working, when I launch PopSQL from terminal with sudo popsql I get these error in the terminal and PopSQL ui shows blank screen.
{"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
mysql node.js
edited Nov 22 '18 at 12:25
Billal Begueradj
5,843132640
asked Nov 22 '18 at 12:21
Avash NekrosAvash Nekros
84
add a comment |
1
To learn MySQL I installed PopSQL using .deb package but it's not working, when I launch PopSQL from terminal with sudo popsql I get these error in the terminal and PopSQL ui shows blank screen.
{"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
mysql node.js
edited Nov 22 '18 at 12:25
Billal Begueradj
5,843132640
asked Nov 22 '18 at 12:21
Avash NekrosAvash Nekros
84
add a comment |
1
1
1
To learn MySQL I installed PopSQL using .deb package but it's not working, when I launch PopSQL from terminal with sudo popsql I get these error in the terminal and PopSQL ui shows blank screen.
{"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
mysql node.js
edited Nov 22 '18 at 12:25
Billal Begueradj
5,843132640
asked Nov 22 '18 at 12:21
Avash NekrosAvash Nekros
84
To learn MySQL I installed PopSQL using .deb package but it's not working, when I launch PopSQL from terminal with sudo popsql I get these error in the terminal and PopSQL ui shows blank screen.
{"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
mysql node.js
mysql node.js
edited Nov 22 '18 at 12:25
Billal Begueradj
5,843132640
asked Nov 22 '18 at 12:21
Avash NekrosAvash Nekros
84
edited Nov 22 '18 at 12:25
Billal Begueradj
5,843132640
asked Nov 22 '18 at 12:21
Avash NekrosAvash Nekros
84
edited Nov 22 '18 at 12:25
Billal Begueradj
5,843132640
edited Nov 22 '18 at 12:25
Billal Begueradj
5,843132640
edited Nov 22 '18 at 12:25
Billal Begueradj
5,843132640
5,843132640
asked Nov 22 '18 at 12:21
Avash NekrosAvash Nekros
84
asked Nov 22 '18 at 12:21
Avash NekrosAvash Nekros
84
asked Nov 22 '18 at 12:21
Avash NekrosAvash Nekros
84
84
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
0
You don't need PopSQL to learn MySQL.
But, if you want it, to get it going, follow the error message instructions:
- download the Instant Client Basic Light package from
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
- unzip it
- add the directory to your library search path, either via LD_LIBRARY_PATH or using ldconfig (I recommend the latter), as shown at
https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html#ic_x64_inst
PopSQL should use a try/catch block when it requires oracledb so you don't see the error.
answered Nov 23 '18 at 2:16
Christopher JonesChristopher Jones
1,9001615
after installing Instant Client Basic Light package I was able to run PopSQL using gksu popsql command.
– Avash Nekros
Nov 25 '18 at 1:00
add a comment |
0
It looks like you are missing the required driver from mysql. You can download and install this from
https://dev.mysql.com/downloads/connector/odbc/
The answer here should help.
https://askubuntu.com/questions/800216/installing-ubuntu-16-04-lts-how-to-install-odbc?answertab=votes#tab-top
answered Nov 22 '18 at 12:49
davedave
1,095934
Downloaded zip contains libmyodbc8a.so, libmyodbc8S.so and libmyodbc8w.so in /lib folder, there's no libmyodbc5a.so and libodbcmyS.so Do I even need popSQL? It's not necessary to use MySQL so can't I just use MySQL workbench? Today is my first day in MySQL world so I am kinda lost.
– Avash Nekros
Nov 22 '18 at 14:32
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53430926%2fcant-run-popsql-in-ubuntu-18-04-with-node-v11-2-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
You don't need PopSQL to learn MySQL.
But, if you want it, to get it going, follow the error message instructions:
- download the Instant Client Basic Light package from
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
- unzip it
- add the directory to your library search path, either via LD_LIBRARY_PATH or using ldconfig (I recommend the latter), as shown at
https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html#ic_x64_inst
PopSQL should use a try/catch block when it requires oracledb so you don't see the error.
answered Nov 23 '18 at 2:16
Christopher JonesChristopher Jones
1,9001615
after installing Instant Client Basic Light package I was able to run PopSQL using gksu popsql command.
– Avash Nekros
Nov 25 '18 at 1:00
add a comment |
0
You don't need PopSQL to learn MySQL.
But, if you want it, to get it going, follow the error message instructions:
- download the Instant Client Basic Light package from
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
- unzip it
- add the directory to your library search path, either via LD_LIBRARY_PATH or using ldconfig (I recommend the latter), as shown at
https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html#ic_x64_inst
PopSQL should use a try/catch block when it requires oracledb so you don't see the error.
answered Nov 23 '18 at 2:16
Christopher JonesChristopher Jones
1,9001615
after installing Instant Client Basic Light package I was able to run PopSQL using gksu popsql command.
– Avash Nekros
Nov 25 '18 at 1:00
add a comment |
0
0
0
You don't need PopSQL to learn MySQL.
But, if you want it, to get it going, follow the error message instructions:
- download the Instant Client Basic Light package from
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
- unzip it
- add the directory to your library search path, either via LD_LIBRARY_PATH or using ldconfig (I recommend the latter), as shown at
https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html#ic_x64_inst
PopSQL should use a try/catch block when it requires oracledb so you don't see the error.
answered Nov 23 '18 at 2:16
Christopher JonesChristopher Jones
1,9001615
You don't need PopSQL to learn MySQL.
But, if you want it, to get it going, follow the error message instructions:
- download the Instant Client Basic Light package from
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
- unzip it
- add the directory to your library search path, either via LD_LIBRARY_PATH or using ldconfig (I recommend the latter), as shown at
https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html#ic_x64_inst
PopSQL should use a try/catch block when it requires oracledb so you don't see the error.
answered Nov 23 '18 at 2:16
Christopher JonesChristopher Jones
1,9001615
answered Nov 23 '18 at 2:16
Christopher JonesChristopher Jones
1,9001615
answered Nov 23 '18 at 2:16
Christopher JonesChristopher Jones
1,9001615
answered Nov 23 '18 at 2:16
Christopher JonesChristopher Jones
1,9001615
1,9001615
after installing Instant Client Basic Light package I was able to run PopSQL using gksu popsql command.
– Avash Nekros
Nov 25 '18 at 1:00
add a comment |
after installing Instant Client Basic Light package I was able to run PopSQL using gksu popsql command.
– Avash Nekros
Nov 25 '18 at 1:00
after installing Instant Client Basic Light package I was able to run PopSQL using gksu popsql command.
– Avash Nekros
Nov 25 '18 at 1:00
after installing Instant Client Basic Light package I was able to run PopSQL using gksu popsql command.
– Avash Nekros
Nov 25 '18 at 1:00
add a comment |
0
It looks like you are missing the required driver from mysql. You can download and install this from
https://dev.mysql.com/downloads/connector/odbc/
The answer here should help.
https://askubuntu.com/questions/800216/installing-ubuntu-16-04-lts-how-to-install-odbc?answertab=votes#tab-top
answered Nov 22 '18 at 12:49
davedave
1,095934
Downloaded zip contains libmyodbc8a.so, libmyodbc8S.so and libmyodbc8w.so in /lib folder, there's no libmyodbc5a.so and libodbcmyS.so Do I even need popSQL? It's not necessary to use MySQL so can't I just use MySQL workbench? Today is my first day in MySQL world so I am kinda lost.
– Avash Nekros
Nov 22 '18 at 14:32
add a comment |
0
It looks like you are missing the required driver from mysql. You can download and install this from
https://dev.mysql.com/downloads/connector/odbc/
The answer here should help.
https://askubuntu.com/questions/800216/installing-ubuntu-16-04-lts-how-to-install-odbc?answertab=votes#tab-top
answered Nov 22 '18 at 12:49
davedave
1,095934
Downloaded zip contains libmyodbc8a.so, libmyodbc8S.so and libmyodbc8w.so in /lib folder, there's no libmyodbc5a.so and libodbcmyS.so Do I even need popSQL? It's not necessary to use MySQL so can't I just use MySQL workbench? Today is my first day in MySQL world so I am kinda lost.
– Avash Nekros
Nov 22 '18 at 14:32
add a comment |
0
0
0
It looks like you are missing the required driver from mysql. You can download and install this from
https://dev.mysql.com/downloads/connector/odbc/
The answer here should help.
https://askubuntu.com/questions/800216/installing-ubuntu-16-04-lts-how-to-install-odbc?answertab=votes#tab-top
answered Nov 22 '18 at 12:49
davedave
1,095934
It looks like you are missing the required driver from mysql. You can download and install this from
https://dev.mysql.com/downloads/connector/odbc/
The answer here should help.
https://askubuntu.com/questions/800216/installing-ubuntu-16-04-lts-how-to-install-odbc?answertab=votes#tab-top
answered Nov 22 '18 at 12:49
davedave
1,095934
answered Nov 22 '18 at 12:49
davedave
1,095934
answered Nov 22 '18 at 12:49
davedave
1,095934
answered Nov 22 '18 at 12:49
davedave
1,095934
1,095934
Downloaded zip contains libmyodbc8a.so, libmyodbc8S.so and libmyodbc8w.so in /lib folder, there's no libmyodbc5a.so and libodbcmyS.so Do I even need popSQL? It's not necessary to use MySQL so can't I just use MySQL workbench? Today is my first day in MySQL world so I am kinda lost.
– Avash Nekros
Nov 22 '18 at 14:32
add a comment |
Downloaded zip contains libmyodbc8a.so, libmyodbc8S.so and libmyodbc8w.so in /lib folder, there's no libmyodbc5a.so and libodbcmyS.so Do I even need popSQL? It's not necessary to use MySQL so can't I just use MySQL workbench? Today is my first day in MySQL world so I am kinda lost.
– Avash Nekros
Nov 22 '18 at 14:32
Downloaded zip contains libmyodbc8a.so, libmyodbc8S.so and libmyodbc8w.so in /lib folder, there's no libmyodbc5a.so and libodbcmyS.so Do I even need popSQL? It's not necessary to use MySQL so can't I just use MySQL workbench? Today is my first day in MySQL world so I am kinda lost.
– Avash Nekros
Nov 22 '18 at 14:32
Downloaded zip contains libmyodbc8a.so, libmyodbc8S.so and libmyodbc8w.so in /lib folder, there's no libmyodbc5a.so and libodbcmyS.so Do I even need popSQL? It's not necessary to use MySQL so can't I just use MySQL workbench? Today is my first day in MySQL world so I am kinda lost.
– Avash Nekros
Nov 22 '18 at 14:32
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53430926%2fcant-run-popsql-in-ubuntu-18-04-with-node-v11-2-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
