Gekko: Unable to install [email protected]

[cometbus]

**Note: for support questions, please join
db.run("PRAGMA journal_mode = DEL")

• I'm submitting a ...
  [ x] bug report
  [ ] feature request
  [ ] question about the decisions made in the repository

• Action taken (what you did)
  I installed win 10 bash gekko following: https://gekko.wizb.it/docs/installation/installing_gekko_on_windows_with_bash_on_windows_10.html

I had trouble with the handle.js line, I deleted what was on line 53 and replaced it with
db.run("PRAGMA journal_mode = DEL");
this cleared up my sql i/o error

RECEIVED ERROR IN GEKKO 6431250939473818

Gekko encountered an error and can't continue

Gekko encountered an error and can't continue

Error:

The plugin sqlite adapter expects the module sqlite3 to be installed. However it is not, install it by running:

    npm install [email protected]

Meta debug info:

Gekko version: v0.5.10
Nodejs version: v9.2.0

I tried running

npm install [email protected]

• Expected result (what you hoped would happen)
  sqlite installs

• Actual result (unexpected outcome)
  npm install [email protected]

[email protected] install /home/andy/gekko/node_modules/sqlite3
node-pre-gyp install --fallback-to-build
node-pre-gyp info it worked if it ends with ok
node-pre-gyp verb cli [ '/usr/bin/node',
node-pre-gyp verb cli '/home/andy/gekko/node_modules/sqlite3/node_modules/.bin/node-pre-gyp',
node-pre-gyp verb cli 'install',
node-pre-gyp verb cli '--fallback-to-build' ]
node-pre-gyp info using [email protected]
node-pre-gyp info using [email protected] | linux | x64
node-pre-gyp verb command install []
node-pre-gyp info check checked for "/home/andy/gekko/node_modules/sqlite3/lib/binding/node-v59-linux-x64/node_sqlite3.node" (not found)
node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.4/node-v59-linux-x64.tar.gz
node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.4/node-v59-linux-x64.tar.gz
node-pre-gyp ERR! Tried to download: https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.4/node-v59-linux-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v59 ABI) (falling back to source compile with node-gyp)
node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.4/node-v59-linux-x64.tar.gz
node-pre-gyp verb command build [ 'rebuild' ]
make: Entering directory '/home/andy/gekko/node_modules/sqlite3/build'
ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3090100/sqlite3.c
TOUCH Release/obj.target/deps/action_before_build.stamp
CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3090100/sqlite3.o
AR(target) Release/obj.target/deps/sqlite3.a
COPY Release/sqlite3.a
CXX(target) Release/obj.target/node_sqlite3/src/database.o
In file included from ../node_modules/nan/nan.h:190:0,
from ../src/database.h:10,
from ../src/database.cc:4:
../node_modules/nan/nan_maybe_43_inl.h: In function ‘Nan::Maybe Nan::ForceSet(v8::Localv8::Object, v8::Localv8::Value, v8::Localv8::Value, v8::PropertyAttribute)’:
../node_modules/nan/nan_maybe_43_inl.h:88:64: warning: ‘v8::Maybe v8::Object::ForceSet(v8::Localv8::Context, v8::Localv8::Value, v8::Localv8::Value, v8::PropertyAttribute)’ is deprecated: Use CreateDataProperty / DefineOwnProperty [-Wdeprecated-declarations]
return obj->ForceSet(GetCurrentContext(), key, value, attribs);
^
In file included from /home/andy/.node-gyp/9.2.0/include/node/v8.h:26:0,
from /home/andy/.node-gyp/9.2.0/include/node/node.h:63,
from ../node_modules/nan/nan.h:47,
from ../src/database.h:10,
from ../src/database.cc:4:
/home/andy/.node-gyp/9.2.0/include/node/v8.h:3115:29: note: declared here
Maybe ForceSet(Local context, Local key,
^
/home/andy/.node-gyp/9.2.0/include/node/v8config.h:318:3: note: in definition of macro ‘V8_DEPRECATED’
declarator attribute((deprecated(message)))
^
../src/database.cc: In static member function ‘static Nan::NAN_METHOD_RETURN_TYPE node_sqlite3::Database::New(Nan::NAN_METHOD_ARGS_TYPE)’:
../src/database.cc:132:96: error: no matching function for call to ‘v8::Object::ForceSet(v8::Localv8::String, v8::Localv8::String, v8::PropertyAttribute)’
info.This()->ForceSet(Nan::New("filename").ToLocalChecked(), info[0].As(), ReadOnly);
^
In file included from /home/andy/.node-gyp/9.2.0/include/node/v8.h:26:0,
from /home/andy/.node-gyp/9.2.0/include/node/node.h:63,
from ../node_modules/nan/nan.h:47,
from ../src/database.h:10,
from ../src/database.cc:4:
/home/andy/.node-gyp/9.2.0/include/node/v8.h:3115:29: note: candidate: v8::Maybe v8::Object::ForceSet(v8::Localv8::Context, v8::Localv8::Value, v8::Localv8::Value, v8::PropertyAttribute)
Maybe ForceSet(Local context, Local key,
^
/home/andy/.node-gyp/9.2.0/include/node/v8config.h:318:3: note: in definition of macro ‘V8_DEPRECATED’
declarator attribute((deprecated(message)))
^
/home/andy/.node-gyp/9.2.0/include/node/v8.h:3115:29: note: no known conversion for argument 3 from ‘v8::PropertyAttribute’ to ‘v8::Localv8::Value’
Maybe ForceSet(Local context, Local key,
^
/home/andy/.node-gyp/9.2.0/include/node/v8config.h:318:3: note: in definition of macro ‘V8_DEPRECATED’
declarator attribute((deprecated(message)))
^
../src/database.cc:133:86: error: no matching function for call to ‘v8::Object::ForceSet(v8::Localv8::String, Nan:👿:IntegerFactoryv8::Int32::return_t, v8::PropertyAttribute)’
info.This()->ForceSet(Nan::New("mode").ToLocalChecked(), Nan::New(mode), ReadOnly);
^
In file included from /home/andy/.node-gyp/9.2.0/include/node/v8.h:26:0,
from /home/andy/.node-gyp/9.2.0/include/node/node.h:63,
from ../node_modules/nan/nan.h:47,
from ../src/database.h:10,
from ../src/database.cc:4:
/home/andy/.node-gyp/9.2.0/include/node/v8.h:3115:29: note: candidate: v8::Maybe v8::Object::ForceSet(v8::Localv8::Context, v8::Localv8::Value, v8::Localv8::Value, v8::PropertyAttribute)
Maybe ForceSet(Local context, Local key,
^
/home/andy/.node-gyp/9.2.0/include/node/v8config.h:318:3: note: in definition of macro ‘V8_DEPRECATED’
declarator attribute((deprecated(message)))
^
/home/andy/.node-gyp/9.2.0/include/node/v8.h:3115:29: note: no known conversion for argument 3 from ‘v8::PropertyAttribute’ to ‘v8::Localv8::Value’
Maybe ForceSet(Local context, Local key,
^
/home/andy/.node-gyp/9.2.0/include/node/v8config.h:318:3: note: in definition of macro ‘V8_DEPRECATED’
declarator attribute((deprecated(message)))
^
../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginOpen(node_sqlite3::Database::Baton)’:
../src/database.cc:143:9: warning: unused variable ‘status’ [-Wunused-variable]
int status = uv_queue_work(uv_default_loop(),
^
../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginClose(node_sqlite3::Database::Baton)’:
../src/database.cc:227:9: warning: unused variable ‘status’ [-Wunused-variable]
int status = uv_queue_work(uv_default_loop(),
^
../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginExec(node_sqlite3::Database::Baton)’:
../src/database.cc:505:9: warning: unused variable ‘status’ [-Wunused-variable]
int status = uv_queue_work(uv_default_loop(),
^
../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginLoadExtension(node_sqlite3::Database::Baton)’:
../src/database.cc:605:9: warning: unused variable ‘status’ [-Wunused-variable]
int status = uv_queue_work(uv_default_loop(),
^
node_sqlite3.target.mk:113: recipe for target 'Release/obj.target/node_sqlite3/src/database.o' failed
make: * [Release/obj.target/node_sqlite3/src/database.o] Error 1
make: Leaving directory '/home/andy/gekko/node_modules/sqlite3/build'
gyp ERR! build error
gyp ERR! stack Error: make failed with exit code: 2
gyp ERR! stack at ChildProcess.onExit (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:258:23)
gyp ERR! stack at ChildProcess.emit (events.js:159:13)
gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:209:12)
gyp ERR! System Linux 4.4.0-43-Microsoft
gyp ERR! command "/usr/bin/node" "/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/home/andy/gekko/node_modules/sqlite3/lib/binding/node-v59-linux-x64/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/andy/gekko/node_modules/sqlite3/lib/binding/node-v59-linux-x64"
gyp ERR! cwd /home/andy/gekko/node_modules/sqlite3
gyp ERR! node -v v9.2.0
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok
node-pre-gyp ERR! build error
node-pre-gyp ERR! stack Error: Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/andy/gekko/node_modules/sqlite3/lib/binding/node-v59-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/andy/gekko/node_modules/sqlite3/lib/binding/node-v59-linux-x64' (1)
node-pre-gyp ERR! stack at ChildProcess. (/home/andy/gekko/node_modules/sqlite3/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
node-pre-gyp ERR! stack at ChildProcess.emit (events.js:159:13)
node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:943:16)
node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:220:5)
node-pre-gyp ERR! System Linux 4.4.0-43-Microsoft
node-pre-gyp ERR! command "/usr/bin/node" "/home/andy/gekko/node_modules/sqlite3/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd /home/andy/gekko/node_modules/sqlite3
node-pre-gyp ERR! node -v v9.2.0
node-pre-gyp ERR! node-pre-gyp -v v0.6.28
node-pre-gyp ERR! not ok
Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/andy/gekko/node_modules/sqlite3/lib/binding/node-v59-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/andy/gekko/node_modules/sqlite3/lib/binding/node-v59-linux-x64' (1)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] install: node-pre-gyp install --fallback-to-build
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

• Other information (e.g. detailed explanation, stacktraces, related issues, suggestions how to fix, links for us to have context, eg. stackoverflow, etc)

this error is always present when launching gekko

[welly59]

that error at the bottom i believe is from it failing to open a browser window direct to gekko gui

[cmroche]

The error is not related, and when using BASH the browser will not launch automatically since the open command is not interpreted to mean anything on a linux shell.

What are the settings you are using for your candles (size and history?), can you start a live gekko wait 5 minutes and then take a screen shot of the market watcher to validate that it is receiving market data. Bittrex does not support importing historical data, so I suspect that you might have large candles/history which requires a long pre-warm time... in this case you would have to wait for the market watcher before graph data will be displayed, and longer for trades to start in the paper trader. If you check the market watch though it will show you the time of the last trade it processed, that should periodically update even if the rest hasn't started yet.

[Johannnnes]

This might work for installing sqlite:

npm i sqlite3 --build-from-source

[twingall1]

Tried this but same problem..

[jfima]

The same problem with nodejs 9.2.0 (raspberry pi stretch)
solved with nodejs 8.9.1 (last LTS version at this moment)
uninstall nodejs complitly

sudo rm -rf /usr/local/bin/npm /usr/local/share/man/man1/node* /usr/local/lib/dtrace/node.d ~/.npm ~/.node-gyp /opt/local/bin/node opt/local/include/node /opt/local/lib/node_modules

install 8.9.1
curl -sL https://deb.nodesource.com/setup_8.x | sudo -E bash -

npm update

sqlite3 will be installed from source

[cometbus]

I reinstalled Ubuntu Bash, which wasn't easy to do... completely reinstalled everything

Get-AppxPackage -AllUsers| Foreach {Add-AppxPackage -DisableDevelopmentMode -Register “$($_.InstallLocation)AppXManifest.xml”}

http://www.intowindows.com/how-to-reinstall-store-and-other-preinstalled-apps-in-windows-10/

lxrun /install /y
https://www.howtogeek.com/249966/how-to-install-and-use-the-linux-bash-shell-on-windows-10/

this gave my what looks like a different version of Ubuntu than from the windows store
my bash said bash before now it says "Bash on Ubuntu on Windows"

redid everything for gekko
https://gekko.wizb.it/docs/installation/installing_gekko_on_windows_with_bash_on_windows_10.html

It's working now

[cometbus]

/root/gekko/exchanges/bittrex.js:227
var stillThere = _.find(result.result, function(o) { return o.OrderUuid === order });
^

TypeError: Cannot read property 'result' of null
at Trader. (/root/gekko/exchanges/bittrex.js:227:36)
at Request._callback (/root/gekko/node_modules/node.bittrex.api/node.bittrex.api.js:124:15)
at self.callback (/root/gekko/node_modules/request/request.js:188:22)
at emitOne (events.js:116:13)
at Request.emit (events.js:211:7)
at Request.onRequestError (/root/gekko/node_modules/request/request.js:884:8)
at emitOne (events.js:116:13)
at ClientRequest.emit (events.js:211:7)
at TLSSocket.socketErrorListener (_http_client.js:387:9)
at emitOne (events.js:116:13)
RECEIVED ERROR IN GEKKO 898932506697928
Child process has died.

[DoomerDGR8]

I'm facing the same error installing sqlite on win10

`
npm WARN deprecated [email protected]: This package is no longer supported. It's now a built-in Node module. If you've depended on crypto, you should switch to the one that's built-in.
npm WARN deprecated [email protected]: ReDoS vulnerability parsing Set-Cookie https://nodesecurity.io/advisories/130
npm WARN deprecated [email protected]: Use uuid module instead

[email protected] install J:\Projects\Repos\gekko-stable\node_modulessqlite3
node-pre-gyp install --fallback-to-build

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.11/node-v59-win32-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v59 ABI) (falling back to source compile with node-gyp)
Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
unpack_sqlite_dep
'python' is not recognized as an internal or external command,
operable program or batch file.
C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V140\Microsoft.CppCommon.targets(171,5): error MSB6006: "cmd.exe" exi
ted with code 1. [J:\Projects\Repos\gekko-stable\node_modulessqlite3\build\depsaction_before_build.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: msbuild failed with exit code: 1
gyp ERR! stack at ChildProcess.onExit (C:\Users\hassaAppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\build.js:258:23)
gyp ERR! stack at ChildProcess.emit (events.js:159:13)
gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:209:12)
gyp ERR! System Windows_NT 10.0.16299
gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\hassa\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "build" "--fallback-to-build" "--module=J:\Projects\Repos\gekko-stable\node_modules\sqlite3\lib\binding\node-v59-win32-x64\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=J:\Projects\Repos\gekko-stable\node_modules\sqlite3\lib\binding\node-v59-win32-x64"
gyp ERR! cwd J:\Projects\Repos\gekko-stable\node_modulessqlite3
gyp ERR! node -v v9.2.1
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok
node-pre-gyp ERR! build error
node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\hassaAppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=J:\Projects\Repos\gekko-stable\node_modulessqlite3\lib\binding\node-v59-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=J:\Projects\Repos\gekko-stable\node_modulessqlite3\lib\binding\node-v59-win32-x64' (1)
node-pre-gyp ERR! stack at ChildProcess. (J:\Projects\Repos\gekko-stable\node_modulessqlite3\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
node-pre-gyp ERR! stack at ChildProcess.emit (events.js:159:13)
node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:943:16)
node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:220:5)
node-pre-gyp ERR! System Windows_NT 10.0.16299
node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "J:\Projects\Repos\gekko-stable\node_modules\sqlite3\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd J:\Projects\Repos\gekko-stable\node_modulessqlite3
node-pre-gyp ERR! node -v v9.2.1
node-pre-gyp ERR! node-pre-gyp -v v0.6.37
node-pre-gyp ERR! not ok
Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\hassaAppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=J:\Projects\Repos\gekko-stable\node_modulessqlite3\lib\binding\node-v59-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=J:\Projects\Repos\gekko-stable\node_modulessqlite3\lib\binding\node-v59-win32-x64' (1)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] install: node-pre-gyp install --fallback-to-build
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install 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! C:\Users\hassaAppData\Roaming\npm-cache_logs\2017-12-08T20_55_11_221Z-debug.log
`

I tried downloading the files directly specified at these two lines from above:

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.11/node-v59-win32-x64.tar.gz node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v59 ABI) (falling back to source compile with node-gyp)

There is an authorization error on https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.11/node-v59-win32-x64.tar.gz

[TonyStark]

install node v8.9.3
that solved me

[magicdude4eva]

I agree with @TonyStark - falling back to v8.9.3 removes most of the problems. I suggest that people use nvm as it allows to easily switch node.

[alexleventer]

Installing Node v8.9.3 worked for me. If you're using nvm, nvm install 8.9.3 && nvm use 8.9.3.

[askmike]

great :)

[DoomerDGR8]

How to execute this command om Windows using NPM?

Regards,
Hassan Gulzar

On Wed, Dec 13, 2017 at 7:37 AM, Alex Leventer [e-mail]
wrote:

Installing Node v8.9.3 worked for me. If you're using nvm, nvm install
8.9.3 && nvm use 8.9.3.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
https://github.com/askmike/gekko/issues/1380#issuecomment-351272824, or mute
the thread
https://github.com/notifications/unsubscribe-auth/AAyW9ow90MOqB5Ycc1zxAxZ4540yl2nHks5s_0aKgaJpZM4QvnPn
.

[digital-state]

Can confirm, Node v8.9.3 solved the problem.

I had the same error on my Mac (High Sierra).

[jabarua]

I have Node v8.9.3 and show me the same problem

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.11/node-v59-win32-x64.tar.gz node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v59 ABI) (falling back to source compile with node-gyp)

[TonyStark]

@jabarua but in your error it says [email protected]
what you get when you type node -v

[Obsessive]

Had the same problem
fortunately, I'm on mac and use n.
Shifted to n 8.9.3 and works now.

[ChadTaljaardt]

changing https://github.com/askmike/gekko/blob/3429baa5c2d3926177207e393b85c548fb516152/package.json#L59 to this fixed it for me.

"sqlite3": "git+https://github.com/mapbox/node-sqlite3",

[taoism-o]

!!!!!!!!!!!!!!!!!!!!!
THXXXXXXXXXXXXXXXXX!!! For you guys give a big step on
I've already sucked in this problem almost the whole day.

now
plz
shift
to
the lower/higher node version
to
8.9.3

dam**

[MartijnvanGoor]

DoomerDGR8 is completely right. The only reason for returnig this error is because the sqlite file can't be retrieved at amazonaws.com, due to no authorisation.

Simply forget the error given in gekko while running with the hint to- "sudo apt install [email protected]" You only need to "sudo apt install sqlite" and the right/best source will be found automaticly.

Resulting in the flawless install of [email protected] (which can always be upgraded afterwards)

Good luck my fellow traders (and adventure seekers, haha)

[viclen]

If you just change in the package.json file the
"sqlite3": "^3.1.4",
line for the current version of the sqlite3 installed in your machine, it should work.

By the way, install sqlite3 like this:
sudo npm install sqlite3 --unsafe-perm
and you should not get any errors