journeyapps / node-sqlcipher Goto Github PK

SQLCipher bindings for Node

License: BSD 3-Clause "New" or "Revised" License

JavaScript 14.81% Makefile 0.33% PLpgSQL 64.35% Python 0.29% Batchfile 1.23% Shell 2.04% C++ 15.55% C 0.21% HTML 0.04% Dockerfile 1.15%

electron nodejs sqlcipher sqlite

node-sqlcipher's People

Contributors

Stargazers

Watchers

Forkers

vigetlabs scottnonnenberg-signal aellison5505 fholzer 1107979819 ostrichegret kunjun akiratfli dreadful-dev wspl tuoxiaozhong sfpgmr hojackwoo laoq112 d4tocchini junyoung-jeong realmee patlamontagne yehengxuan davidpini rayhu codewhitemonkey sts0mrg0 evanhahn-signal devartsoftware rhklee dennisameling tunecino muscipular diegoe dn3010 electron-modules getcommande o1dmate christianezeani ajiaxi z411500976 fdt2k jayge-ekenstam sirhall monkeydledger codingforme zengdukan ashvinkasture zz-link inerasrl tugrulturkkan tomshare kuromiii csedwickbec victoryxu38 bilal-z thanhle7 binkzhou judx susheer fork-anyone

node-sqlcipher's Issues

Pre-built Binaries Not Found. [Electron]

Getting this error message when trying to run npm install in Electron project.

node-pre-gyp ERR! Pre-built binaries not found for @journeyapps/[email protected] and [email protected] (electron-v2.0 ABI, unknown) (falling back to source compile with node-gyp)

Build fails on Windows with Electron 11: 'napi_is_detached_arraybuffer': identifier not found

√ Checking your system
√ Locating Application
/ Preparing native dependencies: 0 / 1←[2K←[1G←[36m-←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m\←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m|←[39m Preparing native dependencies: 0 / 1Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
←[2K←[1G←[36m/←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m-←[39m Preparing native dependencies: 0 / 1  nothing.c
←[2K←[1G←[36m\←[39m Preparing native dependencies: 0 / 1  win_delay_load_hook.cc
←[2K←[1G←[36m|←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m/←[39m Preparing native dependencies: 0 / 1  nothing.vcxproj -> C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\build\Release\\nothing.lib
←[2K←[1G←[36m-←[39m Preparing native dependencies: 0 / 1  unpack_sqlite_dep
←[2K←[1G←[36m\←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m|←[39m Preparing native dependencies: 0 / 1  Copying C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\build\Release\/obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/msvcr12
  0.dll to C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\build\Release\
          1 file(s) copied.
  Copying C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\build\Release\/obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/libeay3
  2.dll to C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\build\Release\
          1 file(s) copied.
←[2K←[1G←[36m/←[39m Preparing native dependencies: 0 / 1  sqlite3.c
←[2K←[1G←[36m-←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m\←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m|←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m/←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m-←[39m Preparing native dependencies: 0 / 1  win_delay_load_hook.cc
←[2K←[1G←[36m\←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m|←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m/←[39m Preparing native dependencies: 0 / 1  sqlite3.vcxproj -> C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\build\Release\\sqlite3.lib
←[2K←[1G←[36m-←[39m Preparing native dependencies: 0 / 1  backup.cc
←[2K←[1G←[36m\←[39m Preparing native dependencies: 0 / 1c:\users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\node_modules\node-addon-api\napi-inl.h(1575): error C3861: 'napi_is_detached_arraybuffer': identifier
 not found [C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
c:\users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\node_modules\node-addon-api\napi-inl.h(1581): error C3861: 'napi_detach_arraybuffer': identifier not
found [C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
←[2K←[1G←[36m|←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m/←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[36m-←[39m Preparing native dependencies: 0 / 1←[2K←[1G←[?25h←[31m×←[39m Preparing native dependencies: 0 / 1
←[31m
An unhandled error has occurred inside Forge:←[39m
←[31mnode-gyp failed to rebuild 'C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher'.←[39m
←[31mError: `C:\Program Files (x86)\MSBuild\14.0\bin\MSBuild.exe` failed with exit code: 1←[39m

←[31m←[39m
←[31mError: node-gyp failed to rebuild 'C:\Users\user\workspace\my-app\node_modules\@journeyapps\sqlcipher'.←[39m
←[31mError: `C:\Program Files (x86)\MSBuild\14.0\bin\MSBuild.exe` failed with exit code: 1←[39m


←[31m    at ModuleRebuilder.rebuildNodeGypModule (C:\Users\user\workspace\my-app\node_modules\electron-rebuild\src\module-rebuilder.ts:231:13)←[39m
←[31m    at processTicksAndRejections (internal/process/task_queues.js:97:5)←[39m
←[?25h←[?25hnpm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] dev: `npm run build && electron-forge start`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] dev 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\user\AppData\Roaming\npm-cache\_logs\2021-01-11T10_52_39_185Z-debug.log

Using version 5.0.0 with Electron 11.0.3 and Node 12.20.1 on Windows 10

I'm building it with electron-forge.

Anything I can try?

How can I default to sqlcipher4 with sequelize?

const Sequelize = require("sequelize");
const db = new Sequelize({
    dialect: 'sqlite',
    storage: path.join(process.cwd(), "sample.db"),
    dialectModulePath: '@journeyapps/sqlcipher',
    logging: false,
    define: {
        freezeTableName: true
    }
});
db.query("PRAGMA key = 'password'");

I am not able to open the sample.db file with sqlitebrowser SQLCIPHER 4.

The only way its works is by adding the below line and then use SQLICIPHER 3 in sqlitebrowser
db.query('PRAGMA cipher_compatibility = 3');

where to store DB on MAC OS

I cannot find folder where I can store DB file, for now, I find only /tmp/ that is writable :/

Worker_Threads: Unable to find dialect

Hello, I'm running a worker_thread that needs to read a copy of my encrypted database.

Unfortunately when I try to connect to my database I get the following error: UnhandledPromiseRejectionWarning: Error: Unable to find dialect at @journeyapps/sqlcipher.

This is my database setup

sequelize = new Sequelize(null, null, key, {
    dialect: 'sqlite',
    dialectModulePath: '@journeyapps/sqlcipher',
    storage: path,
    logging: false,
    transactionType: 'IMMEDIATE'
  });

I have been reading about this issue and it might be related to Enabling Context-Awareness, here's some info about it Context-Awareness and Example of Context-Awareness Fix

I'm running Electron 8 which runs Node 12.13.0 and I'm using Sequelize 5.21.2 and @journeyapps/sqlcipher 4.0.0
I'm able to import any other module I use on the rest of my electron app but this one, any help would be much appreciated

Build for window fail on Mac

node: v12.13.x
electron: v8.2.5
Mac: macOS Catalina v10.15.5

@journeyapps/sqlcipher/lib/binding/electron-v8.2-win32-x64/node_sqlite3.node is not a valid Win32 application

Incompatible with electron-rebuild / electron-forge

Previously reported in #53 #54 #55 #56 #57 #58 #61 #63. Creating one issue to keep track of this.

There are now workaround instructions here: https://github.com/journeyapps/node-sqlcipher#usage-with-electron-forge--electron-rebuild
It would still be great to find a solution that works without additional configuration.

There are multiple issues with electron-rebuild (which is also used by default with electron-forge) attempting to rebuild this module.

It does not support {napi_build_version} in the module_path. See electron/rebuild#554 / electron/rebuild#546.
It does not use the pre-built modules. See electron/rebuild#367.
When building from source, there is something wrong in the build environment causing a compile error (#63).

The workaround is to disable rebuilding of this module with electron-rebuild. However, there are still potential issues:

If the node version and electron versions don't match, the correct N-API version would not be installed automatically.
When cross-compiling for a different architecture or platform, the correct N-API version would not be installed automatically.

Disabling N-API v6 support would solve (1) above, but not (2). It would also remove worker_thread support, which is not ideal.

Number is saved twice as high to database

Couldn't find anything about this odd issue so maybe someone here can shed light on it.

I'm running this query:

      INSERT INTO List (
        id,
        type,
        title,
        path,
        isFolder,
        trackCount,
        ordering,
        isExplicitlyExported
      )

      VALUES (
        5,
        1,
        "test",
        "test;",
        0,
        4,
        1,
        1
      )

And everything saves correctly except trackCount, it always saves 8 instead of 4 when I run this query from Nodejs. That goes for all rows that I'm saving, every value is double the actual input. Always only that field.

When I run the query with the SQLite Browser, the expected 4 is saved.

This is the table definition:

CREATE TABLE List ( [id] INTEGER, [type] INTEGER, [title] TEXT, [path] TEXT, [isFolder] NUMERIC, [trackCount] INTEGER, [ordering] INTEGER, [isExplicitlyExported] NUMERIC DEFAULT 1, PRIMARY KEY ( [id], [type] ) )

I can upload the database I'm using for this if that helps.

CentOS 7 - libcrypto.so.1.1 not found

Everything works great on Windows, but Cent OS 7 doesn't seem to like my setup.

internal/modules/cjs/loader.js:1003
  return process.dlopen(module, path.toNamespacedPath(filename));
                 ^

Error: libcrypto.so.1.1: cannot open shared object file: No such file or directory
    at Object.Module._extensions..node (internal/modules/cjs/loader.js:1003:18)
    at Module.load (internal/modules/cjs/loader.js:812:32)
    at Function.Module._load (internal/modules/cjs/loader.js:724:14)
    at Module.require (internal/modules/cjs/loader.js:849:19)
    at require (internal/modules/cjs/helpers.js:74:18)
    at Object.<anonymous> (/home/gerrit/project/node_modules/@journeyapps/sqlcipher/lib/sqlite3.js:4:15)
    at Module._compile (internal/modules/cjs/loader.js:956:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:973:10)
    at Module.load (internal/modules/cjs/loader.js:812:32)
    at Function.Module._load (internal/modules/cjs/loader.js:724:14)

As I saw this mentioned in another issue:

$ ls -l /usr/lib*/libcrypto.so*
lrwxrwxrwx. 1 root root      19 Oct 29 19:30 /usr/lib64/libcrypto.so -> libcrypto.so.1.0.2k
lrwxrwxrwx. 1 root root      19 Oct 29 19:30 /usr/lib64/libcrypto.so.10 -> libcrypto.so.1.0.2k
-rwxr-xr-x. 1 root root 2521144 Aug  8 19:38 /usr/lib64/libcrypto.so.1.0.2k

The readme mentions OpenSSL 1.0.2n bundled install on Windows, I tried installing 1.0.2t since it was the most recent version with the same major/minor/patch listed here: https://www.openssl.org/source/, but this gives a different error:

internal/modules/cjs/loader.js:1003
  return process.dlopen(module, path.toNamespacedPath(filename));
                 ^

Error: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /home/gerrit/project/node_modules/@journeyapps/sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node)
    at Object.Module._extensions..node (internal/modules/cjs/loader.js:1003:18)
    at Module.load (internal/modules/cjs/loader.js:812:32)
    at Function.Module._load (internal/modules/cjs/loader.js:724:14)
    at Module.require (internal/modules/cjs/loader.js:849:19)
    at require (internal/modules/cjs/helpers.js:74:18)
    at Object.<anonymous> (/home/gerrit/CS-3160-Final-Project/node_modules/@journeyapps/sqlcipher/lib/sqlite3.js:4:15)
    at Module._compile (internal/modules/cjs/loader.js:956:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:973:10)
    at Module.load (internal/modules/cjs/loader.js:812:32)
    at Function.Module._load (internal/modules/cjs/loader.js:724:14)

Am I missing something obvious?

Doesn't work on macOS 10.14.5 node-pre-gyp WARN Tried to download(403)

node-pre-gyp WARN Tried to download(403): https://journeyapps-node-binary.s3.amazonaws.com/@journeyapps/sqlcipher/v4.0.0/node-v79-darwin-x64.tar.gz

can not download

please check, thanks!

node_sqlite3.node crashing on Windows arm64

I'm trying to get Signal Desktop to work on Windows arm64 (signalapp/Signal-Desktop#3745 (comment)), and it's crashing with error code 3228369023 when I try to run it. I debugged in Visual Studio (on an x64 machine, since Microsoft doesn't support debugging on arm64 yet) and it looks like it's crashing on node_sqlite3.node:

When I clone this repo and build it, it fails with the following error:

C:\repos\node-sqlcipher>npm install

> @journeyapps/[email protected] install C:\repos\node-sqlcipher
> node-pre-gyp install --fallback-to-build

node-pre-gyp WARN Using request for node-pre-gyp https download 
node-pre-gyp WARN Tried to download(403): https://journeyapps-node-binary.s3.amazonaws.com/@journeyapps/sqlcipher/v5.0.0/napi-v6-win32-arm64.tar.gz
node-pre-gyp WARN Pre-built binaries not found for @journeyapps/[email protected] and [email protected] (node-v83 ABI, unknown) (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.
  nothing.c
  win_delay_load_hook.cc
  nothing.vcxproj -> C:\repos\node-sqlcipher\build\Release\\nothing.lib
  unpack_sqlite_dep
  Copying C:\repos\node-sqlcipher\build\Release\obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/msvcr120.dll to C
  :\repos\node-sqlcipher\build\Release\\msvcr120.dll
          1 file(s) copied.
  Copying C:\repos\node-sqlcipher\build\Release\obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/libeay32.dll to C 
  :\repos\node-sqlcipher\build\Release\\libeay32.dll
          1 file(s) copied.
  sqlite3.c
C:\repos\node-sqlcipher\build\Release\obj\global_intermediate\sqlcipher-amalgamation-3031000\sqlite3.c(27233,1): error C2099: initiali
zer is not a constant [C:\repos\node-sqlcipher\build\deps\sqlite3.vcxproj]
C:\repos\node-sqlcipher\build\Release\obj\global_intermediate\sqlcipher-amalgamation-3031000\sqlite3.c(27234,1): error C2099: initiali 
zer is not a constant [C:\repos\node-sqlcipher\build\deps\sqlite3.vcxproj]
C:\repos\node-sqlcipher\build\Release\obj\global_intermediate\sqlcipher-amalgamation-3031000\sqlite3.c(27235,1): error C2099: initiali
zer is not a constant [C:\repos\node-sqlcipher\build\deps\sqlite3.vcxproj]
C:\repos\node-sqlcipher\build\Release\obj\global_intermediate\sqlcipher-amalgamation-3031000\sqlite3.c(27237,1): error C2099: initiali 
zer is not a constant [C:\repos\node-sqlcipher\build\deps\sqlite3.vcxproj]
C:\repos\node-sqlcipher\build\Release\obj\global_intermediate\sqlcipher-amalgamation-3031000\sqlite3.c(27238,1): error C2099: initiali 
zer is not a constant [C:\repos\node-sqlcipher\build\deps\sqlite3.vcxproj]
gyp ERR! build error 
gyp ERR! stack Error: `C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Current\Bin\MSBuild.exe` failed with exit 
code: 1
gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:194:23)
gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:277:12)
gyp ERR! System Windows_NT 10.0.19042
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "build" "--fallback-to-build" "--module=C:\\repos\\node-sqlcipher\\lib\\binding\\napi-v6-win32-arm64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\repos\\node-sqlcipher\\lib\\binding\\napi-v6-win32-arm64" "--napi_version=7" "--node_abi_napi=napi" "--napi_build_version=6" "--node_napi_label=napi-v6"
gyp ERR! cwd C:\repos\node-sqlcipher
gyp ERR! node -v v14.14.0
gyp ERR! node-gyp -v v5.1.0
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:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\repos\node-sqlcipher\lib\binding\napi-v6-win32-arm64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\repos\node-sqlcipher\lib\binding\napi-v6-win32-arm64 --napi_version=7 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1)
node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\repos\node-sqlcipher\node_modules\node-pre-gyp\lib\util\compile.js:83:29)  
node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:1048:16)
node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
node-pre-gyp ERR! System Windows_NT 10.0.19042
node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\repos\\node-sqlcipher\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd C:\repos\node-sqlcipher
node-pre-gyp ERR! node -v v14.14.0
node-pre-gyp ERR! node-pre-gyp -v v0.15.0
node-pre-gyp ERR! not ok 
Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\repos\node-sqlcipher\lib\binding\napi-v6-win32-arm64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\repos\node-sqlcipher\lib\binding\napi-v6-win32-arm64 --napi_version=7 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! @journeyapps/[email protected] install: `node-pre-gyp install --fallback-to-build`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the @journeyapps/[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\denni\AppData\Roaming\npm-cache\_logs\2021-02-20T15_50_38_549Z-debug.log

C:\repos\node-sqlcipher>

I tried building node-sqlite3 locally, and it works. Running tests through npm test results in:

160 passing (16s)

... so that's a good start.

I don't know yet what exactly is going wrong, but will investigate later. Wanted to at least report my findings so far here 😊

Would love to get node-sqlcipher to build/run on Windows arm64 and have a device (Surface Pro X) at hand for testing.

Electron crash on Windows on v5.0.0

"electron": "^11.1.0",
"@journeyapps/sqlcipher": "^5.0.0",
node version: 12.20.0
npm version: 6.14.8

error:

npm ERR! code ELIFECYCLE
npm ERR! errno 3228369023
npm ERR! [email protected] ele: electron .
npm ERR! Exit status 3228369023
npm ERR!
npm ERR! Failed at the [email protected] ele 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\Administrator\AppData\Roaming\npm-cache_logs\2021-01-27T13_27_23_388Z-debug.log

The electron exe is closing if I run db.run("PRAGMA key ='mySecret'");

Could you please help on this.

sqlcipher_export not working

Can you help me to take a look at the flowing snippet? I'm trying to export the encrypted db to a decrypted db but it seems not working.
`
async function demo() {
var db = new sqlite3.Database(ENCRYPTED_DB_FOLDER)

db.serialize(function () {
// db.run('PRAGMA cipher_compatibility = 3')
db.run("PRAGMA key = 'abc'")
db.run('PRAGMA cipher_page_size = 1024')
db.run("PRAGMA kdf_iter = '64000'")
db.run('PRAGMA cipher_hmac_algorithm = HMAC_SHA1')
db.run('PRAGMA cipher_kdf_algorithm = PBKDF2_HMAC_SHA1')

db.run(
  `
    ATTACH DATABASE "data/global/db/decrypted_database.db" AS plaintext KEY "";
    SELECT sqlcipher_export("plaintext");
    DETACH DATABASE plaintext;
  `,
)

})

db.close()
}
`

Version 5.0.0 doesn't work on Windows 10

i am using v5.0.0 version, and not able to get past the keying while db setup, fails at the step where i m trying to key the sqlite database without any errors in logs.

  await instance.run(`PRAGMA key = "x'${key}'";`);

If I don't do the above step, everything works fine. Is this linked to ISSUE 46 , because i had to rename napi folders v6 as v3 and make it run on windows

It works in Mac but not in Windows 10 (Parallels machine i have on my machine)

v5.0.0 napi-v6 instead of napi-v3

when using with cordova-electron 2.0.0 that is using electron 10.1.2
https://cordova.apache.org/announcements/2020/10/02/cordova-electron-release-2.0.0.html

it will build napi-v6 instead of napi-v3, any idea how to fix it?

Uncaught (in promise) Error: Cannot find module 'C:\Projects\insight-assess-mobile-app\node_modules\@journeyapps\sqlcipher\lib\binding\napi-v3-win32-x64\node_sqlite3.node'
Require stack:
- C:\Projects\insight-assess-mobile-app\node_modules\@journeyapps\sqlcipher\lib\sqlite3-binding.js
- C:\Projects\insight-assess-mobile-app\node_modules\@journeyapps\sqlcipher\lib\sqlite3.js

Empty results if query starts on new line

WebSQL / Android / iOS SQLCipher works fine, but for electron (node.js integration) will return empty array if query stars on new line

db.run(`
SELECT * FROM TABLE
`);

return [];

db.run(`SELECT * FROM TABLE`);

will return data

output filename matches input filename

Hello, locally it's working but on pipeline is throwing error with electron-rebuild windows server + python 2.7 + ms studio 2015

I found just fatal error LNK1149: output filename matches input filename 'D:\a\1\s\node_modules@journeyapps\sqlcipher\build\Release\InSight Assess.lib' but not sure how to fix it...

2020-10-08T10:59:33.6229411Z ##[debug]Evaluating condition for step: 'Electron rebuild'
2020-10-08T10:59:33.6230989Z ##[debug]Evaluating: succeeded()
2020-10-08T10:59:33.6231471Z ##[debug]Evaluating succeeded:
2020-10-08T10:59:33.6232468Z ##[debug]=> True
2020-10-08T10:59:33.6233078Z ##[debug]Result: True
2020-10-08T10:59:33.6233566Z ##[section]Starting: Electron rebuild
2020-10-08T10:59:33.6335382Z ==============================================================================
2020-10-08T10:59:33.6335623Z Task         : Command line
2020-10-08T10:59:33.6335908Z Description  : Run a command line script using Bash on Linux and macOS and cmd.exe on Windows
2020-10-08T10:59:33.6336136Z Version      : 2.176.1
2020-10-08T10:59:33.6336350Z Author       : Microsoft Corporation
2020-10-08T10:59:33.6336607Z Help         : https://docs.microsoft.com/azure/devops/pipelines/tasks/utility/command-line
2020-10-08T10:59:33.6336901Z ==============================================================================
2020-10-08T10:59:34.9304266Z ##[debug]VstsTaskSdk 0.9.0 commit 6c48b16164b9a1c9548776ad2062dad5cd543352
2020-10-08T10:59:35.2303261Z ##[debug]Entering D:\a\_tasks\CmdLine_d9bafed4-0b18-4f58-968d-86655b4d2ce9\2.176.1\cmdline.ps1.
2020-10-08T10:59:35.2402004Z ##[debug]Loading resource strings from: D:\a\_tasks\CmdLine_d9bafed4-0b18-4f58-968d-86655b4d2ce9\2.176.1\task.json
2020-10-08T10:59:35.2749729Z ##[debug]Loaded 6 strings.
2020-10-08T10:59:35.2810261Z ##[debug]SYSTEM_CULTURE: 'en-US'
2020-10-08T10:59:35.2817560Z ##[debug]Loading resource strings from: D:\a\_tasks\CmdLine_d9bafed4-0b18-4f58-968d-86655b4d2ce9\2.176.1\Strings\resources.resjson\en-US\resources.resjson
2020-10-08T10:59:35.2974014Z ##[debug]Loaded 6 strings.
2020-10-08T10:59:35.3269563Z ##[debug]INPUT_FAILONSTDERR: 'false'
2020-10-08T10:59:35.3321210Z ##[debug] Converted to bool: False
2020-10-08T10:59:35.3336254Z ##[debug]INPUT_SCRIPT: '.\node_modules\.bin\electron-rebuild'
2020-10-08T10:59:35.3350277Z ##[debug]INPUT_WORKINGDIRECTORY: 'D:\a\1\s'
2020-10-08T10:59:35.3552535Z ##[debug]Asserting container path exists: 'D:\a\1\s'
2020-10-08T10:59:35.3565313Z Generating script.
2020-10-08T10:59:35.3664032Z Script contents:
2020-10-08T10:59:35.3673753Z .\node_modules\.bin\electron-rebuild
2020-10-08T10:59:35.3787730Z ##[debug]AGENT_VERSION: '2.175.2'
2020-10-08T10:59:35.3863046Z ##[debug]AGENT_TEMPDIRECTORY: 'D:\a\_temp'
2020-10-08T10:59:35.3884711Z ##[debug]Asserting container path exists: 'D:\a\_temp'
2020-10-08T10:59:35.4037706Z ##[debug]Asserting leaf path exists: 'C:\windows\system32\cmd.exe'
2020-10-08T10:59:35.4090864Z ========================== Starting Command Output ===========================
2020-10-08T10:59:35.4177123Z ##[debug]Entering Invoke-VstsTool.
2020-10-08T10:59:35.4281924Z ##[debug] Arguments: '/D /E:ON /V:OFF /S /C "CALL "D:\a\_temp\d01d225a-31d4-4041-9702-1b29144b22e2.cmd""'
2020-10-08T10:59:35.4302017Z ##[debug] FileName: 'C:\windows\system32\cmd.exe'
2020-10-08T10:59:35.4323547Z ##[debug] WorkingDirectory: 'D:\a\1\s'
2020-10-08T10:59:35.4370850Z ##[command]"C:\windows\system32\cmd.exe" /D /E:ON /V:OFF /S /C "CALL "D:\a\_temp\d01d225a-31d4-4041-9702-1b29144b22e2.cmd""
2020-10-08T10:59:35.8556746Z - Searching dependency tree
2020-10-08T11:01:10.8423631Z Ã— Rebuild Failed
2020-10-08T11:01:10.8434052Z �[31m
2020-10-08T11:01:10.8434263Z An unhandled error occurred inside electron-rebuild�[39m
2020-10-08T11:01:10.8439733Z �[31mgyp info it worked if it ends with ok
2020-10-08T11:01:10.8440311Z gyp info using [email protected]
2020-10-08T11:01:10.8441060Z gyp info using [email protected] | win32 | x64
2020-10-08T11:01:10.8441508Z gyp info find Python using Python version 2.7.18 found at "C:\hostedtoolcache\windows\Python\2.7.18\x64\python.exe"
2020-10-08T11:01:10.8442086Z gyp http GET https://www.electronjs.org/headers/v4.2.12/node-v4.2.12-headers.tar.gz
2020-10-08T11:01:10.8442686Z gyp http 200 https://www.electronjs.org/headers/v4.2.12/node-v4.2.12-headers.tar.gz
2020-10-08T11:01:10.8443799Z gyp http GET https://www.electronjs.org/headers/v4.2.12/SHASUMS256.txt
2020-10-08T11:01:10.8446046Z gyp http GET https://www.electronjs.org/headers/v4.2.12/win-x86/node.lib
2020-10-08T11:01:10.8446493Z gyp http GET https://www.electronjs.org/headers/v4.2.12/win-x64/node.lib
2020-10-08T11:01:10.8446848Z gyp http GET https://www.electronjs.org/headers/v4.2.12/win-arm64/node.lib
2020-10-08T11:01:10.8447234Z gyp http 200 https://www.electronjs.org/headers/v4.2.12/SHASUMS256.txt
2020-10-08T11:01:10.8447577Z gyp http 403 https://www.electronjs.org/headers/v4.2.12/win-arm64/node.lib
2020-10-08T11:01:10.8447917Z gyp http 200 https://www.electronjs.org/headers/v4.2.12/win-x64/node.lib
2020-10-08T11:01:10.8448312Z gyp http 200 https://www.electronjs.org/headers/v4.2.12/win-x86/node.lib
2020-10-08T11:01:10.8448648Z gyp info find VS using VS2017 (15.9.28307.1259) found at:
2020-10-08T11:01:10.8449094Z gyp info find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise"
2020-10-08T11:01:10.8449794Z gyp info find VS run with --verbose for detailed information
2020-10-08T11:01:10.8450168Z gyp info spawn C:\hostedtoolcache\windows\Python\2.7.18\x64\python.exe
2020-10-08T11:01:10.8450517Z gyp info spawn args [ 'D:\\a\\1\\s\\node_modules\\node-gyp\\gyp\\gyp_main.py',
2020-10-08T11:01:10.8451040Z gyp info spawn args   'binding.gyp',
2020-10-08T11:01:10.8451269Z gyp info spawn args   '-f',
2020-10-08T11:01:10.8451531Z gyp info spawn args   'msvs',
2020-10-08T11:01:10.8451758Z gyp info spawn args   '-I',
2020-10-08T11:01:10.8452043Z gyp info spawn args   'D:\\a\\1\\s\\node_modules\\@journeyapps\\sqlcipher\\build\\config.gypi',
2020-10-08T11:01:10.8452349Z gyp info spawn args   '-I',
2020-10-08T11:01:10.8452641Z gyp info spawn args   'D:\\a\\1\\s\\node_modules\\node-gyp\\addon.gypi',
2020-10-08T11:01:10.8452973Z gyp info spawn args   '-I',
2020-10-08T11:01:10.8453263Z gyp info spawn args   'C:\\Users\\VssAdministrator\\.electron-gyp\\4.2.12\\include\\node\\common.gypi',
2020-10-08T11:01:10.8454020Z gyp info spawn args   '-Dlibrary=shared_library',
2020-10-08T11:01:10.8454284Z gyp info spawn args   '-Dvisibility=default',
2020-10-08T11:01:10.8454618Z gyp info spawn args   '-Dnode_root_dir=C:\\Users\\VssAdministrator\\.electron-gyp\\4.2.12',
2020-10-08T11:01:10.8454998Z gyp info spawn args   '-Dnode_gyp_dir=D:\\a\\1\\s\\node_modules\\node-gyp',
2020-10-08T11:01:10.8455458Z gyp info spawn args   '-Dnode_lib_file=C:\\\\Users\\\\VssAdministrator\\\\.electron-gyp\\\\4.2.12\\\\<(target_arch)\\\\node.lib',
2020-10-08T11:01:10.8455907Z gyp info spawn args   '-Dmodule_root_dir=D:\\a\\1\\s\\node_modules\\@journeyapps\\sqlcipher',
2020-10-08T11:01:10.8456223Z gyp info spawn args   '-Dnode_engine=v8',
2020-10-08T11:01:10.8456499Z gyp info spawn args   '--depth=.',
2020-10-08T11:01:10.8456726Z gyp info spawn args   '--no-parallel',
2020-10-08T11:01:10.8457008Z gyp info spawn args   '--generator-output',
2020-10-08T11:01:10.8457457Z gyp info spawn args   'D:\\a\\1\\s\\node_modules\\@journeyapps\\sqlcipher\\build',
2020-10-08T11:01:10.8457811Z gyp info spawn args   '-Goutput_dir=.' ]
2020-10-08T11:01:10.8458149Z gyp info spawn C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\MSBuild.exe
2020-10-08T11:01:10.8458574Z gyp info spawn args [ 'build/binding.sln',
2020-10-08T11:01:10.8458867Z gyp info spawn args   '/clp:Verbosity=minimal',
2020-10-08T11:01:10.8459143Z gyp info spawn args   '/nologo',
2020-10-08T11:01:10.8459407Z gyp info spawn args   '/p:Configuration=Release;Platform=x64' ]
2020-10-08T11:01:10.8459755Z Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
2020-10-08T11:01:10.8460091Z   unpack_sqlite_dep
2020-10-08T11:01:10.8460510Z   Copying D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/msvcr120.dll to D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\\msvcr120.dll
2020-10-08T11:01:10.8461020Z           1 file(s) copied.
2020-10-08T11:01:10.8461447Z   Copying D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/libeay32.dll to D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\\libeay32.dll
2020-10-08T11:01:10.8462316Z           1 file(s) copied.
2020-10-08T11:01:10.8462507Z   sqlite3.c
2020-10-08T11:01:10.8463110Z D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\obj\global_intermediate\sqlcipher-amalgamation-3031000\sqlite3.c(24444): warning C4101: 'temp_mutex': unreferenced local variable [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\deps\sqlite3.vcxproj]
2020-10-08T11:01:10.8463658Z   win_delay_load_hook.cc
2020-10-08T11:01:10.8464010Z   sqlite3.vcxproj -> D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\\InSight Assess.lib
2020-10-08T11:01:10.8464290Z   backup.cc
2020-10-08T11:01:10.8464467Z   database.cc
2020-10-08T11:01:10.8464994Z ..\src\database.cc(49): warning C4996: 'Nan::MakeCallback': was declared deprecated..\src\backup.cc(105): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8465529Z   
2020-10-08T11:01:10.8465826Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8466510Z ..\src\backup.cc(119): warning C4996: 'Nan::MakeCallback': was declared deprecatedD:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback' [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8467077Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8467392Z   
2020-10-08T11:01:10.8467864Z ..\src\database.cc(63): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8468401Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8468923Z ..\src\database.cc(92): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8469452Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8469930Z ..\src\database.cc(96): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8470445Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8470921Z ..\src\backup.cc(167): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8471445Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8472035Z ..\src\backup.cc(168): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8472570Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8473454Z ..\src\database.cc(133): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8474152Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'..\src\backup.cc(169): warning C4996: 'Nan::ForceSet': was declared deprecated
2020-10-08T11:01:10.8474577Z   
2020-10-08T11:01:10.8475004Z ..\src\database.cc(134): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8475638Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'd:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8476149Z   
2020-10-08T11:01:10.8476927Z ..\src\backup.cc(170): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8477424Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8477917Z ..\src\database.cc(190): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8478449Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8479154Z ..\src\database.cc(194): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8479918Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8480444Z ..\src\database.cc(199): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8481024Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8481541Z ..\src\backup.cc(236): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8482106Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8482932Z ..\src\database.cc(273): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8483462Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8483940Z ..\src\database.cc(277): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8484466Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8484950Z ..\src\database.cc(282): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8485466Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8485941Z ..\src\backup.cc(301): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8486461Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8486937Z ..\src\database.cc(297): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8487543Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8488024Z ..\src\database.cc(314): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8488578Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8489024Z ..\src\backup.cc(336): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8489561Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8490305Z ..\src\database.cc(421): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8491310Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8492071Z ..\src\database.cc(462): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8492753Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8493307Z ..\src\database.cc(507): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8493905Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8494455Z ..\src\database.cc(564): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8495527Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8496256Z ..\src\database.cc(568): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8496823Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8497347Z ..\src\database.cc(573): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8498165Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8499015Z ..\src\database.cc(603): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8499565Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8500067Z ..\src\database.cc(666): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8500615Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8501122Z ..\src\database.cc(670): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8501835Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8502310Z ..\src\database.cc(675): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8502831Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8503303Z ..\src\backup.cc(78): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8503830Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8504339Z   ..\src\backup.cc(228): note: see reference to function template instantiation 'void node_sqlite3::Backup::Error<node_sqlite3::Backup::InitializeBaton>(T *)' being compiled
2020-10-08T11:01:10.8504869Z           with
2020-10-08T11:01:10.8505004Z           [
2020-10-08T11:01:10.8505269Z               T=node_sqlite3::Backup::InitializeBaton
2020-10-08T11:01:10.8505497Z           ]
2020-10-08T11:01:10.8506006Z ..\src\backup.cc(82): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8506558Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8506849Z   node_sqlite3.cc
2020-10-08T11:01:10.8507080Z   statement.cc
2020-10-08T11:01:10.8507435Z ..\src\statement.cc(103): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8507996Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8508546Z ..\src\statement.cc(161): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8509963Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8510477Z ..\src\statement.cc(347): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8511247Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8511770Z ..\src\statement.cc(412): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8512553Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8513093Z ..\src\statement.cc(416): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8513688Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8514222Z ..\src\statement.cc(483): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8514799Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8515332Z ..\src\statement.cc(556): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8515916Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8516449Z ..\src\statement.cc(564): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8517037Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8517579Z ..\src\statement.cc(680): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8518308Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8519185Z ..\src\statement.cc(694): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8519756Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8520430Z ..\src\statement.cc(743): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8520974Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8521566Z ..\src\statement.cc(837): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8522323Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8522800Z ..\src\statement.cc(873): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8523322Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8523798Z ..\src\statement.cc(887): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8524317Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8524794Z ..\src\node_sqlite3.cc(23): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8525409Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8526076Z ..\src\node_sqlite3.cc(24): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8526652Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8527170Z ..\src\node_sqlite3.cc(25): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8527727Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8528247Z ..\src\node_sqlite3.cc(26): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8529023Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8529560Z ..\src\node_sqlite3.cc(27): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8530291Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8530808Z ..\src\node_sqlite3.cc(28): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8531557Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8532230Z ..\src\node_sqlite3.cc(29): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8532979Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8533516Z ..\src\node_sqlite3.cc(30): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8534097Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8534774Z ..\src\node_sqlite3.cc(32): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8535326Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8536007Z ..\src\node_sqlite3.cc(34): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8536795Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8538132Z ..\src\node_sqlite3.cc(36): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8541586Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8542408Z ..\src\node_sqlite3.cc(37): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8543459Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8544082Z ..\src\node_sqlite3.cc(38): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8545053Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8546311Z ..\src\node_sqlite3.cc(39): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8546840Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8547861Z ..\src\node_sqlite3.cc(40): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8549077Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8549699Z ..\src\node_sqlite3.cc(41): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8550491Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8551234Z ..\src\node_sqlite3.cc(42): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8551828Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8552613Z ..\src\node_sqlite3.cc(43): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8553373Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8554291Z ..\src\node_sqlite3.cc(44): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8555141Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8555699Z ..\src\node_sqlite3.cc(45): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8556217Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8556772Z ..\src\node_sqlite3.cc(46): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8557294Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8557858Z ..\src\node_sqlite3.cc(47): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8558556Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8559110Z ..\src\node_sqlite3.cc(48): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8559615Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8560516Z ..\src\node_sqlite3.cc(49): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8561315Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8561972Z ..\src\node_sqlite3.cc(50): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8562520Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8563109Z ..\src\node_sqlite3.cc(51): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8563658Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8564240Z ..\src\node_sqlite3.cc(52): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8564939Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8565920Z ..\src\node_sqlite3.cc(53): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8566447Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8567022Z ..\src\node_sqlite3.cc(54): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8567719Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8568865Z ..\src\node_sqlite3.cc(55): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8569520Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8570217Z ..\src\node_sqlite3.cc(56): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8570825Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8571720Z ..\src\node_sqlite3.cc(57): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8572271Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8575576Z ..\src\node_sqlite3.cc(58): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8576206Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8576813Z ..\src\node_sqlite3.cc(59): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8577356Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8578121Z ..\src\node_sqlite3.cc(60): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8579010Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8579650Z ..\src\node_sqlite3.cc(61): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8580201Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8580783Z ..\src\node_sqlite3.cc(62): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8581869Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8582622Z ..\src\statement.cc(74): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8583148Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8583764Z   ..\src\statement.cc(153): note: see reference to function template instantiation 'void node_sqlite3::Statement::Error<node_sqlite3::Statement::PrepareBaton>(T *)' being compiled
2020-10-08T11:01:10.8584214Z           with
2020-10-08T11:01:10.8584401Z           [
2020-10-08T11:01:10.8584598Z               T=node_sqlite3::Statement::PrepareBaton
2020-10-08T11:01:10.8584849Z           ]
2020-10-08T11:01:10.8585403Z ..\src\statement.cc(78): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8586318Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8586687Z   win_delay_load_hook.cc
2020-10-08T11:01:10.8587165Z LINK : fatal error LNK1149: output filename matches input filename 'D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\InSight Assess.lib' [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8587652Z gyp ERR! build error 
2020-10-08T11:01:10.8588059Z gyp ERR! stack Error: `C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\MSBuild.exe` failed with exit code: 1
2020-10-08T11:01:10.8588657Z gyp ERR! stack     at ChildProcess.onExit (D:\a\1\s\node_modules\node-gyp\lib\build.js:194:23)
2020-10-08T11:01:10.8589060Z gyp ERR! stack     at ChildProcess.emit (events.js:189:13)
2020-10-08T11:01:10.8589464Z gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:248:12)
2020-10-08T11:01:10.8589790Z gyp ERR! System Windows_NT 10.0.14393
2020-10-08T11:01:10.8591669Z gyp ERR! command "C:\\hostedtoolcache\\windows\\node\\10.15.3\\x64\\node.exe" "D:\\a\\1\\s\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild" "--target=4.2.12" "--arch=x64" "--dist-url=https://www.electronjs.org/headers" "--build-from-source" "--module_name=node_sqlite3" "--module_path=D:\\a\\1\\s\\node_modules\\@journeyapps\\sqlcipher\\lib\\binding\\electron-v4.2-win32-x64" "--host=https://journeyapps-node-binary.s3.amazonaws.com" "--remote_path=./{name}/v4.1.0/{toolset}/" "--package_name=electron-v4.2-win32-x64.tar.gz"
2020-10-08T11:01:10.8593290Z gyp ERR! cwd D:\a\1\s\node_modules\@journeyapps\sqlcipher
2020-10-08T11:01:10.8593652Z gyp ERR! node -v v10.15.3
2020-10-08T11:01:10.8593907Z gyp ERR! node-gyp -v v6.1.0
2020-10-08T11:01:10.8594425Z gyp ERR! not ok 
2020-10-08T11:01:10.8594593Z 
2020-10-08T11:01:10.8594974Z Failed with exit code: 1
2020-10-08T11:01:10.8595150Z 
2020-10-08T11:01:10.8595378Z Error: gyp info it worked if it ends with ok
2020-10-08T11:01:10.8595827Z gyp info using [email protected]
2020-10-08T11:01:10.8596301Z gyp info using [email protected] | win32 | x64
2020-10-08T11:01:10.8596661Z gyp info find Python using Python version 2.7.18 found at "C:\hostedtoolcache\windows\Python\2.7.18\x64\python.exe"
2020-10-08T11:01:10.8597178Z gyp http GET https://www.electronjs.org/headers/v4.2.12/node-v4.2.12-headers.tar.gz
2020-10-08T11:01:10.8597591Z gyp http 200 https://www.electronjs.org/headers/v4.2.12/node-v4.2.12-headers.tar.gz
2020-10-08T11:01:10.8598025Z gyp http GET https://www.electronjs.org/headers/v4.2.12/SHASUMS256.txt
2020-10-08T11:01:10.8598546Z gyp http GET https://www.electronjs.org/headers/v4.2.12/win-x86/node.lib
2020-10-08T11:01:10.8599462Z gyp http GET https://www.electronjs.org/headers/v4.2.12/win-x64/node.lib
2020-10-08T11:01:10.8599814Z gyp http GET https://www.electronjs.org/headers/v4.2.12/win-arm64/node.lib
2020-10-08T11:01:10.8600318Z gyp http 200 https://www.electronjs.org/headers/v4.2.12/SHASUMS256.txt
2020-10-08T11:01:10.8600856Z gyp http 403 https://www.electronjs.org/headers/v4.2.12/win-arm64/node.lib
2020-10-08T11:01:10.8601267Z gyp http 200 https://www.electronjs.org/headers/v4.2.12/win-x64/node.lib
2020-10-08T11:01:10.8601880Z gyp http 200 https://www.electronjs.org/headers/v4.2.12/win-x86/node.lib
2020-10-08T11:01:10.8602289Z gyp info find VS using VS2017 (15.9.28307.1259) found at:
2020-10-08T11:01:10.8602851Z gyp info find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise"
2020-10-08T11:01:10.8603431Z gyp info find VS run with --verbose for detailed information
2020-10-08T11:01:10.8603780Z gyp info spawn C:\hostedtoolcache\windows\Python\2.7.18\x64\python.exe
2020-10-08T11:01:10.8604155Z gyp info spawn args [ 'D:\\a\\1\\s\\node_modules\\node-gyp\\gyp\\gyp_main.py',
2020-10-08T11:01:10.8604523Z gyp info spawn args   'binding.gyp',
2020-10-08T11:01:10.8604772Z gyp info spawn args   '-f',
2020-10-08T11:01:10.8605054Z gyp info spawn args   'msvs',
2020-10-08T11:01:10.8605285Z gyp info spawn args   '-I',
2020-10-08T11:01:10.8605756Z gyp info spawn args   'D:\\a\\1\\s\\node_modules\\@journeyapps\\sqlcipher\\build\\config.gypi',
2020-10-08T11:01:10.8606099Z gyp info spawn args   '-I',
2020-10-08T11:01:10.8606448Z gyp info spawn args   'D:\\a\\1\\s\\node_modules\\node-gyp\\addon.gypi',
2020-10-08T11:01:10.8606752Z gyp info spawn args   '-I',
2020-10-08T11:01:10.8607300Z gyp info spawn args   'C:\\Users\\VssAdministrator\\.electron-gyp\\4.2.12\\include\\node\\common.gypi',
2020-10-08T11:01:10.8607741Z gyp info spawn args   '-Dlibrary=shared_library',
2020-10-08T11:01:10.8608037Z gyp info spawn args   '-Dvisibility=default',
2020-10-08T11:01:10.8608461Z gyp info spawn args   '-Dnode_root_dir=C:\\Users\\VssAdministrator\\.electron-gyp\\4.2.12',
2020-10-08T11:01:10.8609230Z gyp info spawn args   '-Dnode_gyp_dir=D:\\a\\1\\s\\node_modules\\node-gyp',
2020-10-08T11:01:10.8609749Z gyp info spawn args   '-Dnode_lib_file=C:\\\\Users\\\\VssAdministrator\\\\.electron-gyp\\\\4.2.12\\\\<(target_arch)\\\\node.lib',
2020-10-08T11:01:10.8610399Z gyp info spawn args   '-Dmodule_root_dir=D:\\a\\1\\s\\node_modules\\@journeyapps\\sqlcipher',
2020-10-08T11:01:10.8610777Z gyp info spawn args   '-Dnode_engine=v8',
2020-10-08T11:01:10.8611021Z gyp info spawn args   '--depth=.',
2020-10-08T11:01:10.8611477Z gyp info spawn args   '--no-parallel',
2020-10-08T11:01:10.8611744Z gyp info spawn args   '--generator-output',
2020-10-08T11:01:10.8612074Z gyp info spawn args   'D:\\a\\1\\s\\node_modules\\@journeyapps\\sqlcipher\\build',
2020-10-08T11:01:10.8612452Z gyp info spawn args   '-Goutput_dir=.' ]
2020-10-08T11:01:10.8612807Z gyp info spawn C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\MSBuild.exe
2020-10-08T11:01:10.8613213Z gyp info spawn args [ 'build/binding.sln',
2020-10-08T11:01:10.8613485Z gyp info spawn args   '/clp:Verbosity=minimal',
2020-10-08T11:01:10.8613796Z gyp info spawn args   '/nologo',
2020-10-08T11:01:10.8614077Z gyp info spawn args   '/p:Configuration=Release;Platform=x64' ]
2020-10-08T11:01:10.8614535Z Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
2020-10-08T11:01:10.8614851Z   unpack_sqlite_dep
2020-10-08T11:01:10.8615357Z   Copying D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/msvcr120.dll to D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\\msvcr120.dll
2020-10-08T11:01:10.8615800Z           1 file(s) copied.
2020-10-08T11:01:10.8616528Z   Copying D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/libeay32.dll to D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\\libeay32.dll
2020-10-08T11:01:10.8617041Z           1 file(s) copied.
2020-10-08T11:01:10.8617269Z   sqlite3.c
2020-10-08T11:01:10.8617914Z D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\obj\global_intermediate\sqlcipher-amalgamation-3031000\sqlite3.c(24444): warning C4101: 'temp_mutex': unreferenced local variable [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\deps\sqlite3.vcxproj]
2020-10-08T11:01:10.8619004Z   win_delay_load_hook.cc
2020-10-08T11:01:10.8619263Z   sqlite3.vcxproj -> D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\\InSight Assess.lib
2020-10-08T11:01:10.8619497Z   backup.cc
2020-10-08T11:01:10.8619659Z   database.cc
2020-10-08T11:01:10.8620319Z ..\src\database.cc(49): warning C4996: 'Nan::MakeCallback': was declared deprecated..\src\backup.cc(105): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8621468Z   
2020-10-08T11:01:10.8621719Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8622345Z ..\src\backup.cc(119): warning C4996: 'Nan::MakeCallback': was declared deprecatedD:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback' [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8623098Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8623333Z   
2020-10-08T11:01:10.8623873Z ..\src\database.cc(63): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8624320Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8624812Z ..\src\database.cc(92): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8625562Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8626115Z ..\src\database.cc(96): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8626634Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8627180Z ..\src\backup.cc(167): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8627695Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8628255Z ..\src\backup.cc(168): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8628790Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8629725Z ..\src\database.cc(133): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8630419Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'..\src\backup.cc(169): warning C4996: 'Nan::ForceSet': was declared deprecated
2020-10-08T11:01:10.8630905Z   
2020-10-08T11:01:10.8631812Z ..\src\database.cc(134): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8633042Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'd:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8633448Z   
2020-10-08T11:01:10.8634056Z ..\src\backup.cc(170): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8634636Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8635281Z ..\src\database.cc(190): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8636434Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8637457Z ..\src\database.cc(194): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8638151Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8639008Z ..\src\database.cc(199): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8639875Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8640777Z ..\src\backup.cc(236): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8641387Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8642300Z ..\src\database.cc(273): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8642858Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8643364Z ..\src\database.cc(277): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8644637Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8645206Z ..\src\database.cc(282): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8645823Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8646394Z ..\src\backup.cc(301): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8647166Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8648054Z ..\src\database.cc(297): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8648642Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8649316Z ..\src\database.cc(314): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8649868Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8650369Z ..\src\backup.cc(336): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8651160Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8651873Z ..\src\database.cc(421): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8652450Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8653039Z ..\src\database.cc(462): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8653727Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8654900Z ..\src\database.cc(507): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8655548Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8656128Z ..\src\database.cc(564): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8656795Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8657345Z ..\src\database.cc(568): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8658017Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8658551Z ..\src\database.cc(573): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8659071Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8660135Z ..\src\database.cc(603): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8660753Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8661332Z ..\src\database.cc(666): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8661864Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8662436Z ..\src\database.cc(670): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8663278Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8664052Z ..\src\database.cc(675): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8664554Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8665082Z ..\src\backup.cc(78): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8665572Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8666143Z   ..\src\backup.cc(228): note: see reference to function template instantiation 'void node_sqlite3::Backup::Error<node_sqlite3::Backup::InitializeBaton>(T *)' being compiled
2020-10-08T11:01:10.8666556Z           with
2020-10-08T11:01:10.8666693Z           [
2020-10-08T11:01:10.8666919Z               T=node_sqlite3::Backup::InitializeBaton
2020-10-08T11:01:10.8667151Z           ]
2020-10-08T11:01:10.8667574Z ..\src\backup.cc(82): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8668071Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8668404Z   node_sqlite3.cc
2020-10-08T11:01:10.8668574Z   statement.cc
2020-10-08T11:01:10.8668999Z ..\src\statement.cc(103): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8669501Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8670055Z ..\src\statement.cc(161): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8670551Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8671089Z ..\src\statement.cc(347): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8671662Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8672206Z ..\src\statement.cc(412): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8672699Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8673231Z ..\src\statement.cc(416): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8673721Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8674254Z ..\src\statement.cc(483): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8674752Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8675358Z ..\src\statement.cc(556): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8675853Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8676390Z ..\src\statement.cc(564): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8676989Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8677509Z ..\src\statement.cc(680): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8677987Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8678511Z ..\src\statement.cc(694): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8679024Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8679547Z ..\src\statement.cc(743): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8680202Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8680759Z ..\src\statement.cc(837): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8681272Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8681823Z ..\src\statement.cc(873): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8682330Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8682883Z ..\src\statement.cc(887): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8683389Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8684082Z ..\src\node_sqlite3.cc(23): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8684576Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8685111Z ..\src\node_sqlite3.cc(24): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8685681Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8686229Z ..\src\node_sqlite3.cc(25): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8686721Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8687250Z ..\src\node_sqlite3.cc(26): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8687741Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8688265Z ..\src\node_sqlite3.cc(27): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8688784Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8689326Z ..\src\node_sqlite3.cc(28): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8690050Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8690591Z ..\src\node_sqlite3.cc(29): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8691083Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8691618Z ..\src\node_sqlite3.cc(30): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8692285Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8693256Z ..\src\node_sqlite3.cc(32): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8694243Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8694889Z ..\src\node_sqlite3.cc(34): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8695491Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8696139Z ..\src\node_sqlite3.cc(36): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8697291Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8697820Z ..\src\node_sqlite3.cc(37): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8698319Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8699161Z ..\src\node_sqlite3.cc(38): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8699678Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8700228Z ..\src\node_sqlite3.cc(39): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8700926Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8701504Z ..\src\node_sqlite3.cc(40): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8702253Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8703623Z ..\src\node_sqlite3.cc(41): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8704548Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8705311Z ..\src\node_sqlite3.cc(42): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8705857Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8706456Z ..\src\node_sqlite3.cc(43): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8707284Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8707875Z ..\src\node_sqlite3.cc(44): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8708871Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8709634Z ..\src\node_sqlite3.cc(45): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8710585Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8711709Z ..\src\node_sqlite3.cc(46): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8712368Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8713595Z ..\src\node_sqlite3.cc(47): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8714127Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8714911Z ..\src\node_sqlite3.cc(48): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8715459Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8716055Z ..\src\node_sqlite3.cc(49): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8718013Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8718706Z ..\src\node_sqlite3.cc(50): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8719837Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8721589Z ..\src\node_sqlite3.cc(51): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8722332Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8723091Z ..\src\node_sqlite3.cc(52): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8723815Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8725516Z ..\src\node_sqlite3.cc(53): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8726294Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8727234Z ..\src\node_sqlite3.cc(54): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8728681Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8729835Z ..\src\node_sqlite3.cc(55): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8730410Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8731019Z ..\src\node_sqlite3.cc(56): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8731739Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8732327Z ..\src\node_sqlite3.cc(57): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8733335Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8733999Z ..\src\node_sqlite3.cc(58): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8734837Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8735851Z ..\src\node_sqlite3.cc(59): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8736517Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8737177Z ..\src\node_sqlite3.cc(60): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8738126Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8739463Z ..\src\node_sqlite3.cc(61): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8740192Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8740993Z ..\src\node_sqlite3.cc(62): warning C4996: 'Nan::ForceSet': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8741869Z   d:\a\1\s\node_modules\nan\nan_maybe_43_inl.h(117): note: see declaration of 'Nan::ForceSet'
2020-10-08T11:01:10.8742743Z ..\src\statement.cc(74): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8743398Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8744000Z   ..\src\statement.cc(153): note: see reference to function template instantiation 'void node_sqlite3::Statement::Error<node_sqlite3::Statement::PrepareBaton>(T *)' being compiled
2020-10-08T11:01:10.8744589Z           with
2020-10-08T11:01:10.8744801Z           [
2020-10-08T11:01:10.8745200Z               T=node_sqlite3::Statement::PrepareBaton
2020-10-08T11:01:10.8745530Z           ]
2020-10-08T11:01:10.8746009Z ..\src\statement.cc(78): warning C4996: 'Nan::MakeCallback': was declared deprecated [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8746581Z   D:\a\1\s\node_modules\nan\nan.h(1024): note: see declaration of 'Nan::MakeCallback'
2020-10-08T11:01:10.8746993Z   win_delay_load_hook.cc
2020-10-08T11:01:10.8747862Z LINK : fatal error LNK1149: output filename matches input filename 'D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\Release\InSight Assess.lib' [D:\a\1\s\node_modules\@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
2020-10-08T11:01:10.8748655Z gyp ERR! build error 
2020-10-08T11:01:10.8749167Z gyp ERR! stack Error: `C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\MSBuild.exe` failed with exit code: 1
2020-10-08T11:01:10.8749847Z gyp ERR! stack     at ChildProcess.onExit (D:\a\1\s\node_modules\node-gyp\lib\build.js:194:23)
2020-10-08T11:01:10.8750473Z gyp ERR! stack     at ChildProcess.emit (events.js:189:13)
2020-10-08T11:01:10.8750899Z gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:248:12)
2020-10-08T11:01:10.8751515Z gyp ERR! System Windows_NT 10.0.14393
2020-10-08T11:01:10.8752608Z gyp ERR! command "C:\\hostedtoolcache\\windows\\node\\10.15.3\\x64\\node.exe" "D:\\a\\1\\s\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild" "--target=4.2.12" "--arch=x64" "--dist-url=https://www.electronjs.org/headers" "--build-from-source" "--module_name=node_sqlite3" "--module_path=D:\\a\\1\\s\\node_modules\\@journeyapps\\sqlcipher\\lib\\binding\\electron-v4.2-win32-x64" "--host=https://journeyapps-node-binary.s3.amazonaws.com" "--remote_path=./{name}/v4.1.0/{toolset}/" "--package_name=electron-v4.2-win32-x64.tar.gz"
2020-10-08T11:01:10.8754301Z gyp ERR! cwd D:\a\1\s\node_modules\@journeyapps\sqlcipher
2020-10-08T11:01:10.8754651Z gyp ERR! node -v v10.15.3
2020-10-08T11:01:10.8754898Z gyp ERR! node-gyp -v v6.1.0
2020-10-08T11:01:10.8755166Z gyp ERR! not ok 
2020-10-08T11:01:10.8755392Z 
2020-10-08T11:01:10.8755628Z Failed with exit code: 1
2020-10-08T11:01:10.8756024Z     at SafeSubscriber._error (D:\a\1\s\node_modules\spawn-rx\lib\src\index.js:267:84)
2020-10-08T11:01:10.8756551Z     at SafeSubscriber.__tryOrUnsub (D:\a\1\s\node_modules\rxjs\internal\Subscriber.js:205:16)
2020-10-08T11:01:10.8757825Z     at SafeSubscriber.error (D:\a\1\s\node_modules\rxjs\internal\Subscriber.js:156:26)
2020-10-08T11:01:10.8758387Z     at Subscriber._error (D:\a\1\s\node_modules\rxjs\internal\Subscriber.js:92:26)
2020-10-08T11:01:10.8759426Z     at Subscriber.error (D:\a\1\s\node_modules\rxjs\internal\Subscriber.js:72:18)
2020-10-08T11:01:10.8759943Z     at MapSubscriber.Subscriber._error (D:\a\1\s\node_modules\rxjs\internal\Subscriber.js:92:26)
2020-10-08T11:01:10.8760509Z     at MapSubscriber.Subscriber.error (D:\a\1\s\node_modules\rxjs\internal\Subscriber.js:72:18)
2020-10-08T11:01:10.8761010Z     at SafeSubscriber._next (D:\a\1\s\node_modules\spawn-rx\lib\src\index.js:242:65)
2020-10-08T11:01:10.8761495Z     at SafeSubscriber.__tryOrUnsub (D:\a\1\s\node_modules\rxjs\internal\Subscriber.js:205:16)
2020-10-08T11:01:10.8762519Z     at SafeSubscriber.next (D:\a\1\s\node_modules\rxjs\internal\Subscriber.js:143:22)�[39m
2020-10-08T11:01:10.8834344Z ##[debug]Exit code: -1
2020-10-08T11:01:10.8856961Z ##[debug]Leaving Invoke-VstsTool.
2020-10-08T11:01:10.9742196Z ##[error]Cmd.exe exited with code '-1'.
2020-10-08T11:01:10.9753391Z ##[debug]Processed: ##vso[task.logissue type=error]Cmd.exe exited with code '-1'.
2020-10-08T11:01:10.9837649Z ##[debug]Processed: ##vso[task.complete result=Failed]Error detected
2020-10-08T11:01:10.9860818Z ##[debug]Leaving D:\a\_tasks\CmdLine_d9bafed4-0b18-4f58-968d-86655b4d2ce9\2.176.1\cmdline.ps1.
2020-10-08T11:01:11.0273681Z ##[section]Finishing: Electron rebuild

Error: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found

I’m using “https://www.npmjs.com/package/@journeyapps/sqlcipher 1” with node js on linux centos 7, but getting run time error : “Error: /lib64/libstdc++.so.6: version `CXXABI_1.3.9’ not found (required by /home/avista-dev/server/source/node_modules/@journeyapps/sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node)”

I don’t have any option to upgrade my Linux centos 7 or GCC.
current versions:
GCC 4.8.5
Linux centos 7 (core)
highest version of CXABI is 1.3.7

prebuilt binaries are currently available for electron 6.1, 7.1, and 8.1. (I would have expected the same version to be used for all the 7.x versions, but seems like that is not the case here).

A future version will using NAPI, which will reduce these issues (only a single pre-built version will work with all node & electron versions). However, that will require some work to migrate.

In the meantime, the rebuild scripts should work if you follow the node-gyp setup instructions:
https://github.com/nodejs/node-gyp#on-windows

Originally posted by @rkistner in #35 (comment)

N-API version

When installing on windows everything is fine, but on mac I get this:
Cannot find module '.../node_modules/@journeyapps/sqlcipher/lib/binding/napi-v3-darwin-x64/node_sqlite3.node'
And I have napi-v6-darwin-x64 in binding folder

In console I get this as well: node-pre-gyp info This Node instance does not support builds for N-API version 6

I even lowered node from 14.x to 12.18.4
Also Ive tried building from source and issue persists

Any advice?

Building for Windows from OSX

Hi!

I'm building from an OSX environment, using Electron v1.8.7

I've been able to successfully build my electron app for OSX with node-sqlcipher, but when I try to build for Windows I get the following error:

Uncaught Error: The specified module could not be found.
\\?\C:\Users\USER_NAME\AppData\Local\Temp\0729404d-1f94-4f70-b897-4282e4d00c92.tmp.node
    at process.module.(anonymous function) [as dlopen] (ELECTRON_ASAR.js:172:20)
    at Object.Module._extensions..node (module.js:598:18)
    at Object.module.(anonymous function) [as .node] (ELECTRON_ASAR.js:186:18)
    at Module.load (module.js:503:32)
    at tryModuleLoad (module.js:466:12)
    at Function.Module._load (module.js:458:3)
    at Module.require (module.js:513:17)
    at require (internal/module.js:11:18)
    at Object.<anonymous> ([FILE_PATH]\resources\app.asar\node_modules\@journeyapps\sqlcipher\lib\sqlite3.js:4:15)
    at Object.<anonymous> ([FILE_PATH]\resources\app.asar\node_modules\@journeyapps\sqlcipher\lib\sqlite3.js:190:3)

In my build command, I am using electron-builder install-app-deps --platform=win32 && cross-env BUILD_TARGET=win32 before executing my build. This was required to build platform-dependent binaries and get other modules working across platforms (e.g. keytar, sqlite3)

If it is any help, in node_modules/@journeyapps/sqlcipher/lib/binding/electron-v1.8-win32-x64 I can see the following:

libeay32.dll
msvcr120.dll
node_sqlite3.node

which makes me think the binaries are there but aren't being included in the build?

Any help massively appreciated!

can su electron 10?

v5.0.0 looking for "v6" but node_module folder is "v3"

v5.0.0 fails on Mac (and possibly windows) because the node_modules path is wrong.

The path in node_modules is:
/node_modules/@journeyapps/sqlcipher/lib/binding/napi-v3-darwin-x64/

This throws an error on launch:
"Cannot find module '.../node_modules/@journeyapps/sqlcipher/lib/binding/napi-v6-darwin-x64/"

As you can see it's looking for:
napi-v6-darwin-x64
but the module folder is named:
napi-v3-darwin-x64

This can be fixed locally and everything works, but it's a headache for automated builds!

Fails to run with Electron 4

Running this on Windows 10 with Electron 4.0.0 throws a build error.

Error output:
node-pre-gyp WARN Tried to download(403): https://journeyapps-node-binary.s3.amazonaws.com/@journeyapps/sqlcipher/v3.2.1/electron-v4.0-win32-x64.tar.gz
node-pre-gyp WARN Pre-built binaries not found for @journeyapps/[email protected] and [email protected] (electron-v4.0 ABI, unknown) (falling back to source compile with node-gyp)

Does this package plan to update for using newer version of Electron? We can see that it does work with Electron version 2.0.4 but that is fairly outdated at this point.

Error: SQLITE_NOTADB: file is not a database

when I first time starting my electron app, It created xxx.db can insert data within no problem.
but when I restart my app, It got an error: Error: SQLITE_NOTADB: file is not a database.
The xxx.db file exists actually, and I can open it with passport well.

here is my code:
const sqlite3 = require('@journeyapps/sqlcipher').verbose()
const db = new sqlite3.Database('./xxx.db'))
db.run('PRAGMA cipher_compatibility = 3')
db.run("PRAGMA key = 'abc'")
db.run('PRAGMA page_size=1024')

Version 5.0.0 doesn't compile on MacOS Catalina 10.15.7

node -v : v12.18.3

MacOS Catalina 10.15.7

I have install the package with
npm install --save @journeyapps/sqlcipher

see package.json file below

{
  "name": "my-electron-sqlite",
  "version": "1.0.0",
  "description": "",
  "main": "main.js",
  "keywords": [],
  "author": "",
  "license": "ISC",

  "scripts": {
    "build": "npm run electron:tsc",
    "electron:tsc": "tsc main.ts",
    "start": "electron .",
    "postinstall": "electron-rebuild ",
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "dependencies": {
    "@journeyapps/sqlcipher": "^5.0.0"
  },
  "devDependencies": {
    "@types/sqlite3": "^3.1.6",
    "electron": "^10.1.5",
    "electron-is-dev": "^1.2.0",
    "electron-rebuild": "^2.3.2",
    "tslib": "^2.0.3",
    "typescript": "^3.9.7"
  }
}

error when running npm run postinstall

⠏ Building module: sqlcipher, Completed: 03 warnings and 8 errors generated.
make: *** [Release/obj.target/node_sqlite3/src/backup.o] Error 1
✖ Rebuild Failed

An unhandled error occurred inside electron-rebuild
node-gyp failed to rebuild '/Users/queaujeanpierre/Documents/ElectronProjects/my-electron-sqlite/node_modules/@journeyapps/sqlcipher'.
Error: `make` failed with exit code: 2

Error: node-gyp failed to rebuild '/Users/queaujeanpierre/Documents/ElectronProjects/my-electron-sqlite/node_modules/@journeyapps/sqlcipher'.
Error: `make` failed with exit code: 2
    at ModuleRebuilder.rebuildNodeGypModule (/Users/queaujeanpierre/Documents/ElectronProjects/my-electron-sqlite/node_modules/electron-rebuild/lib/src/module-rebuilder.js:193:19)
    at processTicksAndRejections (internal/process/task_queues.js:97:5)

i step back to @journeyapps/[email protected] and the npm run postinstall works fine.

Any idea?

Openssl version issue with Centos

Error: libcrypto.so.1.0.0: cannot open shared object file: No such file or directory at Object.Module._extensions..node (module.js:681:18) at Module.load (module.js:565:32) at tryModuleLoad (module.js:505:12) at Function.Module._load (module.js:497:3) at Module.require (module.js:596:17) at require (internal/module.js:11:18) at Object.<anonymous> (/PATH/node_modules/@journeyapps/sqlcipher/lib/sqlite3.js:4:15) at Module._compile (module.js:652:30) at Object.Module._extensions..js (module.js:663:10) at Module.load (module.js:565:32)
It works with Windows and Ubuntu but my centos has openssl 1.0.2k version which is not picking by sqlcipher node module.

openssl version
OpenSSL 1.0.2k-fips 26 Jan 2017

can support electron 10?

Upstream the SQLCipher & other fixes

Hi,

I'm the maintainer of node-sqlite3 and I'm looking for people interested in helping maintain the original fork.
I was wondering if perhaps we could upstream the changes for SQLCipher and other fixes into the original fork and work together in a single repository.

Please let me know if you're interested into verifying the feasibility of such endeavor.

the db file cannot open by sqlitestudio

why the db file cannot open by sqlitestudio

electron-rebuild fails with v5

\ Building module: sqlcipher, Completed: 0Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.

Building module: sqlcipher, Completed: 0 nothing.c
| Building module: sqlcipher, Completed: 0 win_delay_load_hook.cc
| Building module: sqlcipher, Completed: 0 nothing.vcxproj -> D:\dev\test-app\src\node_modules@journeyapps\sqlcipher\build\Release\nothing.lib
/ Building module: sqlcipher, Completed: 0 unpack_sqlite_dep
Building module: sqlcipher, Completed: 0 Copying D:\dev\test-app\src\node_modules@journeyapps\sqlcipher\build\Release/obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/msvcr120
.dll to D:\dev\test-app\src\node_modules@journeyapps\sqlcipher\build\Release
1 file(s) copied.
Copying D:\dev\test-app\src\node_modules@journeyapps\sqlcipher\build\Release/obj/global_intermediate/sqlcipher-amalgamation-3031000/OpenSSL-Win64/libeay32
.dll to D:\dev\test-app\src\node_modules@journeyapps\sqlcipher\build\Release
1 file(s) copied.
\ Building module: sqlcipher, Completed: 0 sqlite3.c
Building module: sqlcipher, Completed: 0 win_delay_load_hook.cc
Building module: sqlcipher, Completed: 0 sqlite3.vcxproj -> D:\dev\test-app\src\node_modules@journeyapps\sqlcipher\build\Release\sqlite3.lib
| Building module: sqlcipher, Completed: 0 backup.cc
\ Building module: sqlcipher, Completed: 0D:\dev\test-app\src\node_modules\node-addon-api\napi-inl.h(752): error C3861: 'napi_create_bigint_int64': identifier not found [D:\dev\test-app\src\n
ode_modules@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
D:\dev\test-app\src\node_modules\node-addon-api\napi-inl.h(759): error C3861: 'napi_create_bigint_uint64': identifier not found [D:\dev\test-app\src
node_modules@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
D:\dev\test-app\src\node_modules\node-addon-api\napi-inl.h(766): error C3861: 'napi_create_bigint_words': identifier not found [D:\dev\test-app\src\n
ode_modules@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
D:\dev\test-app\src\node_modules\node-addon-api\napi-inl.h(779): error C3861: 'napi_get_value_bigint_int64': identifier not found [D:\dev\test-app\sr
c\node_modules@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
D:\dev\test-app\src\node_modules\node-addon-api\napi-inl.h(787): error C3861: 'napi_get_value_bigint_uint64': identifier not found [D:\dev\test-app\s
rc\node_modules@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
D:\dev\test-app\src\node_modules\node-addon-api\napi-inl.h(795): error C3861: 'napi_get_value_bigint_words': identifier not found [D:\dev\test-app\sr
c\node_modules@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
D:\dev\test-app\src\node_modules\node-addon-api\napi-inl.h(802): error C3861: 'napi_get_value_bigint_words': identifier not found [D:\dev\test-app\sr
c\node_modules@journeyapps\sqlcipher\build\node_sqlite3.vcxproj]
× Rebuild Failed

An unhandled error occurred inside electron-rebuild
node-gyp failed to rebuild 'D:\dev\test-app\src\node_modules@journeyapps\sqlcipher'.
Error: C:\Program Files (x86)\MSBuild\14.0\bin\MSBuild.exe failed with exit code: 1

Error: node-gyp failed to rebuild 'D:\dev\test-app\src\node_modules@journeyapps\sqlcipher'.
Error: C:\Program Files (x86)\MSBuild\14.0\bin\MSBuild.exe failed with exit code: 1

at ModuleRebuilder.rebuildNodeGypModule (D:\dev\test-app\node_modules\electron-rebuild\lib\src\module-rebuilder.js:193:19)
at processTicksAndRejections (internal/process/task_queues.js:97:5)
npm ERR! code ELIFECYCLE
npm ERR! errno 4294967295
npm ERR! [email protected] postinstall: npx webdriver-manager update --versions.chrome 83.0.4103.39 && npx bower i -p --allow-root && cd src && npm i --production && cd .. && npx electron-rebuild -m src && node task/post-install.js && npm run gen
npm ERR! Exit status 4294967295
npm ERR!
npm ERR! Failed at the [email protected] postinstall 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\admin\AppData\Roaming\npm-cache_logs\2020-10-19T14_21_13_593Z-debug.log

node -v => v12.17.0

npx electron -v =>v10.1.3

SQLite 3.26.0 Support

Hallo!

Could you please say, how about sqlite v3.26.0?

Thanks

password check

how can I check if the password is correct when connecting to the database?
Now, if the password is not correct, there are not even any errors

Can't run sqlcipher on Windows

node-v : v12.19.0

Hi, I can't seem to be able to get sqlcipher running on Windows. I've created a repo of the minimal problem. Help would be appreciated. Thank you!

Steps to repro are here:
https://github.com/benprattinduction/sqlcipher_windows_issue

yarn install
try yarn run start (will get errors on rebuild step, can fix by renaming below)
rename node_modules/@journeyapps/sqlcipher/lib/binding/napi-v6-win32-x64 TO node_modules/@journeyapps/sqlcipher/lib/binding/napi-v3-win32-x64
uncomment ln33 in main.js, it will throw error below

0 info it worked if it ends with ok 1 verbose cli [ 1 verbose cli 'C:\Program Files\nodejs\node.exe', 1 verbose cli 'C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js', 1 verbose cli 'start' 1 verbose cli ] 2 info using [email protected] 3 info using [email protected] 4 verbose run-script [ 'prestart', 'start', 'poststart' ] 5 info lifecycle [email protected]: [email protected] 6 info lifecycle [email protected]: [email protected] 7 verbose lifecycle [email protected]: unsafe-perm in lifecycle true 8 verbose lifecycle [email protected]: PATH: C:\Program Files\nodejs\node_modules\npm\node_modules\npm-lifecycle\node-gyp-bin;C:\Users\ben.p\Documents\electron_test\node_modules.bin;C:\Python39\Scripts;C:\Python39;C:\Program Files (x86)\Parallels\Parallels Tools\Applications;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Windows\System32\OpenSSH;C:\Program Files\nodejs;C:\ProgramData\chocolatey\bin;C:\Program Files (x86)\Yarn\bin;C:\Users\ben.p\AppData\Local\Microsoft\WindowsApps;;C:\Users\ben.p\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\ben.p\AppData\Roaming\npm;C:\Users\ben.p\AppData\Local\Yarn\bin 9 verbose lifecycle [email protected]: CWD: C:\Users\ben.p\Documents\electron_test 10 silly lifecycle [email protected]: Args: [ '/d /s /c', 'electron .' ] 11 silly lifecycle [email protected]: Returned: code: 3228369023 signal: null 12 info lifecycle [email protected]: Failed to exec start script 13 verbose stack Error: [email protected] start: electron . 13 verbose stack Exit status 3228369023 13 verbose stack at EventEmitter. (C:\Program Files\nodejs\node_modules\npm\node_modules\npm-lifecycle\index.js:332:16) 13 verbose stack at EventEmitter.emit (events.js:314:20) 13 verbose stack at ChildProcess. (C:\Program Files\nodejs\node_modules\npm\node_modules\npm-lifecycle\lib\spawn.js:55:14) 13 verbose stack at ChildProcess.emit (events.js:314:20) 13 verbose stack at maybeClose (internal/child_process.js:1021:16) 13 verbose stack at Process.ChildProcess._handle.onexit (internal/child_process.js:286:5) 14 verbose pkgid [email protected] 15 verbose cwd C:\Users\ben.p\Documents\electron_test 16 verbose Windows_NT 10.0.19041 17 verbose argv "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js" "start" 18 verbose node v12.19.0 19 verbose npm v6.14.8 20 error code ELIFECYCLE 21 error errno 3228369023 22 error [email protected] start: electron . 22 error Exit status 3228369023 23 error Failed at the [email protected] start script. 23 error This is probably not a problem with npm. There is likely additional logging output above. 24 verbose exit [ 3228369023, true ]

some dependence problem

1.iojs.lib location error
after install
.node-gyp\iojs-1.8.7\ia32\iojs.lib

compile
.node-gyp\iojs-1.8.7\x86\iojs.lib

2.upgrade binding.sln to vs2017 compatible
3.node_sqlite3 link error
change
$(OutDir)obj\global_intermediate\sqlcipher-amalgamation-3020001\OpenSSL-Win64;%(AdditionalLibraryDirectories)
to
$(OutDir)obj\global_intermediate\sqlcipher-amalgamation-3020001\OpenSSL-Win32;%(AdditionalLibraryDirectories)

Not valid Win32 application before update to 4.1.0

Ho @rkistner, I've updated the library from 4.0.0 to 4.1.0 and get this error when compiling to windows using electron 8.0.0:

Not valid Win32 application before update to 4.1.0

Compiling for Mac or Linux work fine 😄

Any idea?

Thanks!

can support Electron 6 ?

this package failed to compile with Electron 6.0.8 on Mac.

Module not found: Error: Can't resolve 'aws-sdk'

electron:4.2.2
在mac上编译报错，用node-sqlite3，在wabpack里加上
externals: {
sqlite3: 'commonjs2 sqlite3',
},

可以忽略，但是你这个不知掉怎么忽略

我试过:
externals: {
"journeyapps/sqlcipher": 'commonjs2 "journeyapps/sqlcipher"',
},
或：
externals: {
"journeyapps/sqlcipher": "journeyapps/sqlcipher',
},

都无法避免报错

Build fails on Linux with "not a gzip file"

I am trying to build this on Linux, but to no avail.

Any idea what I am doing wrong?

using latest master, Linux x64, Arch Linux, node v12.13.0

I have tried with Python 2.7 and with Python 3.8.5, see below for logs:

PYTHON 3:

make verbose
./node_modules/.bin/node-pre-gyp rebuild --loglevel=verbose
node-pre-gyp info it worked if it ends with ok
node-pre-gyp verb cli [
node-pre-gyp verb cli   '/home/olof/.nvm/versions/node/v12.13.0/bin/node',
node-pre-gyp verb cli   '/home/olof/git/node-sqlcipher/node_modules/.bin/node-pre-gyp',
node-pre-gyp verb cli   'rebuild',
node-pre-gyp verb cli   '--loglevel=verbose'
node-pre-gyp verb cli ]
node-pre-gyp info using [email protected]
node-pre-gyp info using [email protected] | linux | x64
node-pre-gyp verb command rebuild []
node-pre-gyp verb command clean []
node-pre-gyp verb command build [ 'rebuild' ]
gyp info it worked if it ends with ok
gyp info using [email protected]
gyp info using [email protected] | linux | x64
gyp info ok 
gyp info it worked if it ends with ok
gyp verb cli [
gyp verb cli   '/home/olof/.nvm/versions/node/v12.13.0/bin/node',
gyp verb cli   '/home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js',
gyp verb cli   'configure',
gyp verb cli   '--loglevel=verbose',
gyp verb cli   '--module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node',
gyp verb cli   '--module_name=node_sqlite3',
gyp verb cli   '--module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64',
gyp verb cli   '--napi_version=5',
gyp verb cli   '--node_abi_napi=napi',
gyp verb cli   '--napi_build_version=0',
gyp verb cli   '--node_napi_label=node-v72'
gyp verb cli ]
gyp info using [email protected]
gyp info using [email protected] | linux | x64
gyp verb command configure []
gyp verb find Python Python is not set from command line or npm configuration
gyp verb find Python Python is not set from environment variable PYTHON
gyp verb find Python checking if "python3" can be used
gyp verb find Python - executing "python3" to get executable path
gyp verb find Python - executable path is "/usr/bin/python3"
gyp verb find Python - executing "/usr/bin/python3" to get version
gyp verb find Python - version is "3.8.5"
gyp info find Python using Python version 3.8.5 found at "/usr/bin/python3"
gyp verb get node dir no --target version specified, falling back to host node version: 12.13.0
gyp verb command install [ '12.13.0' ]
gyp verb install input version string "12.13.0"
gyp verb install installing version: 12.13.0
gyp verb install --ensure was passed, so won't reinstall if already installed
gyp verb install version is already installed, need to check "installVersion"
gyp verb got "installVersion" 9
gyp verb needs "installVersion" 9
gyp verb install version is good
gyp verb get node dir target node version installed: 12.13.0
gyp verb build dir attempting to create "build" dir: /home/olof/git/node-sqlcipher/build
gyp verb build dir "build" dir needed to be created? /home/olof/git/node-sqlcipher/build
gyp verb build/config.gypi creating config file
gyp verb build/config.gypi writing out config file: /home/olof/git/node-sqlcipher/build/config.gypi
gyp verb config.gypi checking for gypi file: /home/olof/git/node-sqlcipher/config.gypi
gyp verb common.gypi checking for gypi file: /home/olof/git/node-sqlcipher/common.gypi
gyp verb gyp gyp format was not specified; forcing "make"
gyp info spawn /usr/bin/python3
gyp info spawn args [
gyp info spawn args   '/home/olof/git/node-sqlcipher/node_modules/node-gyp/gyp/gyp_main.py',
gyp info spawn args   'binding.gyp',
gyp info spawn args   '-f',
gyp info spawn args   'make',
gyp info spawn args   '-I',
gyp info spawn args   '/home/olof/git/node-sqlcipher/build/config.gypi',
gyp info spawn args   '-I',
gyp info spawn args   '/home/olof/git/node-sqlcipher/node_modules/node-gyp/addon.gypi',
gyp info spawn args   '-I',
gyp info spawn args   '/home/olof/.cache/node-gyp/12.13.0/include/node/common.gypi',
gyp info spawn args   '-Dlibrary=shared_library',
gyp info spawn args   '-Dvisibility=default',
gyp info spawn args   '-Dnode_root_dir=/home/olof/.cache/node-gyp/12.13.0',
gyp info spawn args   '-Dnode_gyp_dir=/home/olof/git/node-sqlcipher/node_modules/node-gyp',
gyp info spawn args   '-Dnode_lib_file=/home/olof/.cache/node-gyp/12.13.0/<(target_arch)/node.lib',
gyp info spawn args   '-Dmodule_root_dir=/home/olof/git/node-sqlcipher',
gyp info spawn args   '-Dnode_engine=v8',
gyp info spawn args   '--depth=.',
gyp info spawn args   '--no-parallel',
gyp info spawn args   '--generator-output',
gyp info spawn args   'build',
gyp info spawn args   '-Goutput_dir=.'
gyp info spawn args ]
gyp info ok 
gyp info it worked if it ends with ok
gyp verb cli [
gyp verb cli   '/home/olof/.nvm/versions/node/v12.13.0/bin/node',
gyp verb cli   '/home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js',
gyp verb cli   'build',
gyp verb cli   '--loglevel=verbose',
gyp verb cli   '--module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node',
gyp verb cli   '--module_name=node_sqlite3',
gyp verb cli   '--module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64',
gyp verb cli   '--napi_version=5',
gyp verb cli   '--node_abi_napi=napi',
gyp verb cli   '--napi_build_version=0',
gyp verb cli   '--node_napi_label=node-v72'
gyp verb cli ]
gyp info using [email protected]
gyp info using [email protected] | linux | x64
gyp verb command build []
gyp verb build type Release
gyp verb architecture x64
gyp verb node dev dir /home/olof/.cache/node-gyp/12.13.0
gyp verb `which` succeeded for `make` /usr/bin/make
gyp info spawn make
gyp info spawn args [ 'V=1', 'BUILDTYPE=Release', '-C', 'build' ]
make[1]: Entering directory '/home/olof/git/node-sqlcipher/build'
  LD_LIBRARY_PATH=/home/olof/git/node-sqlcipher/build/Release/lib.host:/home/olof/git/node-sqlcipher/build/Release/lib.target:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH; cd ../deps; mkdir -p /home/olof/git/node-sqlcipher/build/Release/obj/gen/sqlcipher-amalgamation-3031000; python ./extract.py ./sqlcipher-amalgamation-3031000.tar.gz "/home/olof/git/node-sqlcipher/build/Release/obj/gen"
Traceback (most recent call last):
  File "/usr/lib/python3.8/tarfile.py", line 1672, in gzopen
    t = cls.taropen(name, mode, fileobj, **kwargs)
  File "/usr/lib/python3.8/tarfile.py", line 1649, in taropen
    return cls(name, mode, fileobj, **kwargs)
  File "/usr/lib/python3.8/tarfile.py", line 1512, in __init__
    self.firstmember = self.next()
  File "/usr/lib/python3.8/tarfile.py", line 2313, in next
    tarinfo = self.tarinfo.fromtarfile(self)
  File "/usr/lib/python3.8/tarfile.py", line 1102, in fromtarfile
    buf = tarfile.fileobj.read(BLOCKSIZE)
  File "/usr/lib/python3.8/gzip.py", line 292, in read
    return self._buffer.read(size)
  File "/usr/lib/python3.8/_compression.py", line 68, in readinto
    data = self.read(len(byte_view))
  File "/usr/lib/python3.8/gzip.py", line 479, in read
    if not self._read_gzip_header():
  File "/usr/lib/python3.8/gzip.py", line 427, in _read_gzip_header
    raise BadGzipFile('Not a gzipped file (%r)' % magic)
gzip.BadGzipFile: Not a gzipped file (b've')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "./extract.py", line 7, in <module>
    tfile = tarfile.open(tarball,'r:gz');
  File "/usr/lib/python3.8/tarfile.py", line 1619, in open
    return func(name, filemode, fileobj, **kwargs)
  File "/usr/lib/python3.8/tarfile.py", line 1676, in gzopen
    raise ReadError("not a gzip file")
tarfile.ReadError: not a gzip file
make[1]: *** [deps/action_before_build.target.mk:13: Release/obj/gen/sqlcipher-amalgamation-3031000/sqlite3.c] Error 1
make[1]: Leaving directory '/home/olof/git/node-sqlcipher/build'
gyp ERR! build error 
gyp ERR! stack Error: `make` failed with exit code: 2
gyp ERR! stack     at ChildProcess.onExit (/home/olof/git/node-sqlcipher/node_modules/node-gyp/lib/build.js:194:23)
gyp ERR! stack     at ChildProcess.emit (events.js:210:5)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:272:12)
gyp ERR! System Linux 5.8.10-arch1-1
gyp ERR! command "/home/olof/.nvm/versions/node/v12.13.0/bin/node" "/home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js" "build" "--loglevel=verbose" "--module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64" "--napi_version=5" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v72"
gyp ERR! cwd /home/olof/git/node-sqlcipher
gyp ERR! node -v v12.13.0
gyp ERR! node-gyp -v v6.1.0
gyp ERR! not ok 
node-pre-gyp ERR! build error 
node-pre-gyp ERR! stack Error: Failed to execute '/home/olof/.nvm/versions/node/v12.13.0/bin/node /home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js build --loglevel=verbose --module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64 --napi_version=5 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v72' (1)
node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/home/olof/git/node-sqlcipher/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:210:5)
node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:1021:16)
node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:283:5)
node-pre-gyp ERR! System Linux 5.8.10-arch1-1
node-pre-gyp ERR! command "/home/olof/.nvm/versions/node/v12.13.0/bin/node" "/home/olof/git/node-sqlcipher/node_modules/.bin/node-pre-gyp" "rebuild" "--loglevel=verbose"
node-pre-gyp ERR! cwd /home/olof/git/node-sqlcipher
node-pre-gyp ERR! node -v v12.13.0
node-pre-gyp ERR! node-pre-gyp -v v0.11.0
node-pre-gyp ERR! not ok 
Failed to execute '/home/olof/.nvm/versions/node/v12.13.0/bin/node /home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js build --loglevel=verbose --module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64 --napi_version=5 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v72' (1)
make: *** [Makefile:15: verbose] Error 1

PYTHON 2:

make verbose                  
./node_modules/.bin/node-pre-gyp rebuild --loglevel=verbose
node-pre-gyp info it worked if it ends with ok
node-pre-gyp verb cli [
node-pre-gyp verb cli   '/home/olof/.nvm/versions/node/v12.13.0/bin/node',
node-pre-gyp verb cli   '/home/olof/git/node-sqlcipher/node_modules/.bin/node-pre-gyp',
node-pre-gyp verb cli   'rebuild',
node-pre-gyp verb cli   '--loglevel=verbose'
node-pre-gyp verb cli ]
node-pre-gyp info using [email protected]
node-pre-gyp info using [email protected] | linux | x64
node-pre-gyp verb command rebuild []
node-pre-gyp verb command clean []
node-pre-gyp verb command build [ 'rebuild' ]
gyp info it worked if it ends with ok
gyp info using [email protected]
gyp info using [email protected] | linux | x64
gyp info ok 
gyp info it worked if it ends with ok
gyp verb cli [
gyp verb cli   '/home/olof/.nvm/versions/node/v12.13.0/bin/node',
gyp verb cli   '/home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js',
gyp verb cli   'configure',
gyp verb cli   '--loglevel=verbose',
gyp verb cli   '--module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node',
gyp verb cli   '--module_name=node_sqlite3',
gyp verb cli   '--module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64',
gyp verb cli   '--napi_version=5',
gyp verb cli   '--node_abi_napi=napi',
gyp verb cli   '--napi_build_version=0',
gyp verb cli   '--node_napi_label=node-v72'
gyp verb cli ]
gyp info using [email protected]
gyp info using [email protected] | linux | x64
gyp verb command configure []
gyp verb find Python Python is not set from command line or npm configuration
gyp verb find Python checking Python explicitly set from environment variable PYTHON
gyp verb find Python - process.env.PYTHON is "/usr/bin/python2"
gyp verb find Python - executing "/usr/bin/python2" to get executable path
gyp verb find Python - executable path is "/usr/bin/python2"
gyp verb find Python - executing "/usr/bin/python2" to get version
gyp verb find Python - version is "2.7.18"
gyp info find Python using Python version 2.7.18 found at "/usr/bin/python2"
gyp verb get node dir no --target version specified, falling back to host node version: 12.13.0
gyp verb command install [ '12.13.0' ]
gyp verb install input version string "12.13.0"
gyp verb install installing version: 12.13.0
gyp verb install --ensure was passed, so won't reinstall if already installed
gyp verb install version is already installed, need to check "installVersion"
gyp verb got "installVersion" 9
gyp verb needs "installVersion" 9
gyp verb install version is good
gyp verb get node dir target node version installed: 12.13.0
gyp verb build dir attempting to create "build" dir: /home/olof/git/node-sqlcipher/build
gyp verb build dir "build" dir needed to be created? /home/olof/git/node-sqlcipher/build
gyp verb build/config.gypi creating config file
gyp verb build/config.gypi writing out config file: /home/olof/git/node-sqlcipher/build/config.gypi
gyp verb config.gypi checking for gypi file: /home/olof/git/node-sqlcipher/config.gypi
gyp verb common.gypi checking for gypi file: /home/olof/git/node-sqlcipher/common.gypi
gyp verb gyp gyp format was not specified; forcing "make"
gyp info spawn /usr/bin/python2
gyp info spawn args [
gyp info spawn args   '/home/olof/git/node-sqlcipher/node_modules/node-gyp/gyp/gyp_main.py',
gyp info spawn args   'binding.gyp',
gyp info spawn args   '-f',
gyp info spawn args   'make',
gyp info spawn args   '-I',
gyp info spawn args   '/home/olof/git/node-sqlcipher/build/config.gypi',
gyp info spawn args   '-I',
gyp info spawn args   '/home/olof/git/node-sqlcipher/node_modules/node-gyp/addon.gypi',
gyp info spawn args   '-I',
gyp info spawn args   '/home/olof/.cache/node-gyp/12.13.0/include/node/common.gypi',
gyp info spawn args   '-Dlibrary=shared_library',
gyp info spawn args   '-Dvisibility=default',
gyp info spawn args   '-Dnode_root_dir=/home/olof/.cache/node-gyp/12.13.0',
gyp info spawn args   '-Dnode_gyp_dir=/home/olof/git/node-sqlcipher/node_modules/node-gyp',
gyp info spawn args   '-Dnode_lib_file=/home/olof/.cache/node-gyp/12.13.0/<(target_arch)/node.lib',
gyp info spawn args   '-Dmodule_root_dir=/home/olof/git/node-sqlcipher',
gyp info spawn args   '-Dnode_engine=v8',
gyp info spawn args   '--depth=.',
gyp info spawn args   '--no-parallel',
gyp info spawn args   '--generator-output',
gyp info spawn args   'build',
gyp info spawn args   '-Goutput_dir=.'
gyp info spawn args ]
gyp info ok 
gyp info it worked if it ends with ok
gyp verb cli [
gyp verb cli   '/home/olof/.nvm/versions/node/v12.13.0/bin/node',
gyp verb cli   '/home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js',
gyp verb cli   'build',
gyp verb cli   '--loglevel=verbose',
gyp verb cli   '--module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node',
gyp verb cli   '--module_name=node_sqlite3',
gyp verb cli   '--module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64',
gyp verb cli   '--napi_version=5',
gyp verb cli   '--node_abi_napi=napi',
gyp verb cli   '--napi_build_version=0',
gyp verb cli   '--node_napi_label=node-v72'
gyp verb cli ]
gyp info using [email protected]
gyp info using [email protected] | linux | x64
gyp verb command build []
gyp verb build type Release
gyp verb architecture x64
gyp verb node dev dir /home/olof/.cache/node-gyp/12.13.0
gyp verb `which` succeeded for `make` /usr/bin/make
gyp info spawn make
gyp info spawn args [ 'V=1', 'BUILDTYPE=Release', '-C', 'build' ]
make[1]: Entering directory '/home/olof/git/node-sqlcipher/build'
  LD_LIBRARY_PATH=/home/olof/git/node-sqlcipher/build/Release/lib.host:/home/olof/git/node-sqlcipher/build/Release/lib.target:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH; cd ../deps; mkdir -p /home/olof/git/node-sqlcipher/build/Release/obj/gen/sqlcipher-amalgamation-3031000; python ./extract.py ./sqlcipher-amalgamation-3031000.tar.gz "/home/olof/git/node-sqlcipher/build/Release/obj/gen"
Traceback (most recent call last):
  File "/usr/lib/python3.8/tarfile.py", line 1672, in gzopen
    t = cls.taropen(name, mode, fileobj, **kwargs)
  File "/usr/lib/python3.8/tarfile.py", line 1649, in taropen
    return cls(name, mode, fileobj, **kwargs)
  File "/usr/lib/python3.8/tarfile.py", line 1512, in __init__
    self.firstmember = self.next()
  File "/usr/lib/python3.8/tarfile.py", line 2313, in next
    tarinfo = self.tarinfo.fromtarfile(self)
  File "/usr/lib/python3.8/tarfile.py", line 1102, in fromtarfile
    buf = tarfile.fileobj.read(BLOCKSIZE)
  File "/usr/lib/python3.8/gzip.py", line 292, in read
    return self._buffer.read(size)
  File "/usr/lib/python3.8/_compression.py", line 68, in readinto
    data = self.read(len(byte_view))
  File "/usr/lib/python3.8/gzip.py", line 479, in read
    if not self._read_gzip_header():
  File "/usr/lib/python3.8/gzip.py", line 427, in _read_gzip_header
    raise BadGzipFile('Not a gzipped file (%r)' % magic)
gzip.BadGzipFile: Not a gzipped file (b've')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "./extract.py", line 7, in <module>
    tfile = tarfile.open(tarball,'r:gz');
  File "/usr/lib/python3.8/tarfile.py", line 1619, in open
    return func(name, filemode, fileobj, **kwargs)
  File "/usr/lib/python3.8/tarfile.py", line 1676, in gzopen
    raise ReadError("not a gzip file")
tarfile.ReadError: not a gzip file
make[1]: *** [deps/action_before_build.target.mk:13: Release/obj/gen/sqlcipher-amalgamation-3031000/sqlite3.c] Error 1
make[1]: Leaving directory '/home/olof/git/node-sqlcipher/build'
gyp ERR! build error 
gyp ERR! stack Error: `make` failed with exit code: 2
gyp ERR! stack     at ChildProcess.onExit (/home/olof/git/node-sqlcipher/node_modules/node-gyp/lib/build.js:194:23)
gyp ERR! stack     at ChildProcess.emit (events.js:210:5)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:272:12)
gyp ERR! System Linux 5.8.10-arch1-1
gyp ERR! command "/home/olof/.nvm/versions/node/v12.13.0/bin/node" "/home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js" "build" "--loglevel=verbose" "--module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64" "--napi_version=5" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v72"
gyp ERR! cwd /home/olof/git/node-sqlcipher
gyp ERR! node -v v12.13.0
gyp ERR! node-gyp -v v6.1.0
gyp ERR! not ok 
node-pre-gyp ERR! build error 
node-pre-gyp ERR! stack Error: Failed to execute '/home/olof/.nvm/versions/node/v12.13.0/bin/node /home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js build --loglevel=verbose --module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64 --napi_version=5 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v72' (1)
node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/home/olof/git/node-sqlcipher/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:210:5)
node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:1021:16)
node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:283:5)
node-pre-gyp ERR! System Linux 5.8.10-arch1-1
node-pre-gyp ERR! command "/home/olof/.nvm/versions/node/v12.13.0/bin/node" "/home/olof/git/node-sqlcipher/node_modules/.bin/node-pre-gyp" "rebuild" "--loglevel=verbose"
node-pre-gyp ERR! cwd /home/olof/git/node-sqlcipher
node-pre-gyp ERR! node -v v12.13.0
node-pre-gyp ERR! node-pre-gyp -v v0.11.0
node-pre-gyp ERR! not ok 
Failed to execute '/home/olof/.nvm/versions/node/v12.13.0/bin/node /home/olof/git/node-sqlcipher/node_modules/node-gyp/bin/node-gyp.js build --loglevel=verbose --module=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/olof/git/node-sqlcipher/lib/binding/node-v72-linux-x64 --napi_version=5 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v72' (1)
make: *** [Makefile:15: verbose] Error 1

How to reduce the installation package after electron integrates @journeyapps/sqlcipher ?

Installation package after electron integrates @journeyapps/sqlcipher is too large（102MB）. Package after electron integrates sqlite3 just 60+MB. How to reduce package after integrates @journeyapps/sqlcipher ?
electron version: 10.1.5
@journeyapps/sqlcipher version: 5.2.0

Doesn't work on MacOS Mojave 10.14.2

I've been struggling to make the @journeyapps/sqlcipher work on a mac without any success for a few days already.

I successfully installed brew install openssl
Used both yarn and npm installation. The installation part is done successfully.

However, when I run the example code from readme file using node I'm getting the following error

Vitaliis-MacBook-Pro:cipher-test vbratok$ node index.js
events.js:173
throw er; // Unhandled 'error' event
^

Error: SQLITE_ERROR: SQL logic error
Emitted 'error' event at:

Vitaliis-MacBook-Pro:cipher-test vbratok$

That's it and nothing more.

The test.db file is created in the folder, but it's empty and has zero bytes.
If I comment out the db.run("PRAGMA key = 'mysecret'"); line, it works file, but db isn't encoded.

I did a lot of experiments and I checked that node-sqlite3 and SQLCipher work fine separately and together when I bind them together as described here

p.s. I noticed that there're a new version of openssl came out since the latest release of node-sqlcipher https://www.openssl.org/source/. Could it be an issue?

403 on downloading sqlcipher as dependency

Hello,

while building signal-desktop on Linux x64 the downloader can't access the prebuilt binaries or the source tar ball for electron-v3.

Those are the URLs returning 403:
https://journeyapps-node-binary.s3.amazonaws.com/@journeyapps/sqlcipher/v3.2.1/electron-v3.0-linux-x64.tar.gz

https://journeyapps-node-binary.s3.amazonaws.com/@journeyapps/sqlcipher/v3.2.1/electron-v3.0-linux-x64.tar.gz

Can't open database file in Android

Hi,
I am trying to import the database file in Android app however I get the error:

net.sqlcipher.database.SQLiteException: file is not a database: , while compiling: select count(*) from sqlite_master;

I also tried decrypting this test database file following the link here but to no avail.

Javascript code:

const self = this
const sqlite3 = require('@journeyapps/sqlcipher').verbose()
const dbPath = 'path/metadata.db'
const db = new sqlite3.Database(dbPath)
// create syllabus table
      db.run("CREATE TABLE IF NOT EXISTS my_table (id TEXT, title TEXT)")
      // add new data
      let i=0
      for(i=0;i<self.sylList.length;i+=1) {
        const item = self.sylList[i]
        db.run("INSERT INTO my_table VALUES ($id, $title)", {
          $id: item.id,
          $title: item.title
        })
      }

Android side:

public static void getList(Context context) throws SQLiteException {
    SQLiteDatabase.loadLibs(context);
    final String dbFilePath = FileUtils.getMetadataFile();
    SQLiteDatabase database = SQLiteDatabase.
            openOrCreateDatabase(new File(dbFilePath), "12345678", null);
    Cursor cursor = database.rawQuery("SELECT * FROM my_table", null);
    while(cursor.moveToNext()) {
        Log.d(TAG, cursor.getString(1));
    }
}

Some help?

node v10 support?

When installing under node 10.3.0 I get these errors from node_modules\nan\nan.h(834)

error C2039: 'ForceSet': is not a member of 'v8::Object' (compiling source file ..\src\statement.cc)

they're the same as this issue: Level/leveldown#448

I think the solution is to update nan to the latest version. Could you do so?

sqlcipher-amalgamation-3031000/sqlite3.c:24328:10: fatal error: 'openssl/rand.h' file not found

i am using the below comman for jourenyapps/sqlcipher and build sqlite3 from source on Mac Apple M1 chip. Node is v12.18.3, electron 11.0.0.

npm install @journeyapps/sqlcipher --runtime=electron --target=11.0.0 --sqlite_libname=sqlcipher --disturl=https://atom.io/download/atom-shell --build-from-source -w sqlite3

Got the error as below:

node-pre-gyp WARN Using request for node-pre-gyp https download 
  ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlcipher-amalgamation-3031000/sqlite3.c
  TOUCH Release/obj.target/deps/action_before_build.stamp
  TOUCH Release/obj.target/deps/copy_dll.stamp
  CC(target) Release/obj.target/sqlite3/gen/sqlcipher-amalgamation-3031000/sqlite3.o
Release/obj/gen/sqlcipher-amalgamation-3031000/sqlite3.c:24328:10: fatal error: 'openssl/rand.h' file not found
#include <openssl/rand.h>
         ^~~~~~~~~~~~~~~~
1 error generated.
make: *** [Release/obj.target/sqlite3/gen/sqlcipher-amalgamation-3031000/sqlite3.o] Error 1

openssl did installed. I manually tested for build-from-source sqlite3 is ok without sqlicipher as below:
npm rebuild --runtime=electron --target=11.0.0 --disturl=https://atom.io/download/atom-shell --build-from-source --sqlite_libname=sqlcipher -w sqlite3

It successfully installed [email protected], but install with @journeyapps/[email protected] it failed as above. I would like to ask that the journeyapps/sqlicipher has support for Apple M1 chip? My old mac intel chip is working good with above script. But new M1 mac is not working.

Compiling fails on Linux

Doing an npm install @journeyapps/sqlcipher, I get lots of errors of the sort

/usr/lib/gcc/i686-pc-linux-gnu/7.3.0/../../../../i686-pc-linux-gnu/bin/ld: i386:x86-64 architecture of input file './Release/obj/gen/sqlcipher-amalgamation-3020001/OpenSSL-Linux/libcrypto.a(ecp_smpl.o)' is incompatible with i386 output

and finally

./Release/obj/gen/sqlcipher-amalgamation-3020001/OpenSSL-Linux/libcrypto.a(dso_dlfcn.o): In function 'dlfcn_globallookup':
dso_dlfcn.c:(.text+0x11): undefined reference to 'dlopen'
dso_dlfcn.c:(.text+0x24): undefined reference to 'dlsym'
dso_dlfcn.c:(.text+0x2f): undefined reference to 'dlclose'
./Release/obj/gen/sqlcipher-amalgamation-3020001/OpenSSL-Linux/libcrypto.a(dso_dlfcn.o): In function 'dlfcn_bind_func':
dso_dlfcn.c:(.text+0x334): undefined reference to 'dlsym'
dso_dlfcn.c:(.text+0x3f2): undefined reference to 'dlerror'
./Release/obj/gen/sqlcipher-amalgamation-3020001/OpenSSL-Linux/libcrypto.a(dso_dlfcn.o): In function 'dlfcn_bind_var':
dso_dlfcn.c:(.text+0x464): undefined reference to 'dlsym'
dso_dlfcn.c:(.text+0x522): undefined reference to 'dlerror'
./Release/obj/gen/sqlcipher-amalgamation-3020001/OpenSSL-Linux/libcrypto.a(dso_dlfcn.o): In function 'dlfcn_load':
dso_dlfcn.c:(.text+0x589): undefined reference to 'dlopen'
dso_dlfcn.c:(.text+0x5ed): undefined reference to 'dlclose'
dso_dlfcn.c:(.text+0x625): undefined reference to 'dlerror'
./Release/obj/gen/sqlcipher-amalgamation-3020001/OpenSSL-Linux/libcrypto.a(dso_dlfcn.o): In function 'dlfcn_pathbyaddr':
dso_dlfcn.c:(.text+0x6b1): undefined reference to 'dladdr'
dso_dlfcn.c:(.text+0x711): undefined reference to 'dlerror'

./Release/obj/gen/sqlcipher-amalgamation-3020001/OpenSSL-Linux/libcrypto.a(dso_dlfcn.o): In function 'dlfcn_unload':
dso_dlfcn.c:(.text+0x772): undefined reference to 'dlclose'

npm ERR! Failed at the @journeyapps/[email protected] install script 'node-pre-gyp install --build-from-source'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the @journeyapps/sqlcipher package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     node-pre-gyp install --build-from-source

Silently loses encryption capabilities with some gtk3 configurations

hey!

I forgot to file a bug here too, we've been investigating a problem with signal-desktop, node-sqlcipher and gtk3 recently.

The relevant bug reports are:

The short version is:

sqlcipher doesn't support libsqlite to co-exist in the same process with the configuration node-sqlcipher is currently building it with
gnome wants to introduce a sqlite dependency and therefore load libsqlite into all gui processes
this would make node-sqlcipher incompatible with gnome
this was discovered when an update in Arch Linux (that was temporarily reverted) broke signal-desktop

Is there any way you can help, specifically with the feedback from the sqlcipher issue?

Thank you very much!

node-pre-gyp info This Node instance does not support builds for N-API version 6

Fails on W10 with node v12.16.3

Electron 9

I just want to report that I'm using this on Electron 9.1.1 with OSX Catalina without any issues.

Also, I want to thank you for the effort you have been putting in this library.

Webpack node-sqlcipher

I tried to add to mozilla-iot code , @ry @journeyapps/sqlcipher
gateway/build/webpack:/src/sqlcipher/lib sync:2
var e = new Error("Cannot find module '" + req + "'");
^
Error: Cannot find module gateway/src/sqlcipher/lib/binding/napi-v6-linux-x64/node_sqlite3.node'
at webpackEmptyContext (gateway/build/webpack:/src/sqlcipher/lib sync:2:1)
at Object. (gateway/build/webpack:/src/sqlcipher/lib/sqlite3-binding.js:4:15)
at Object../src/sqlcipher/lib/sqlite3-binding.js gateway/build/gateway.js:17792:30)
at webpack_require (/gateway/build/webpack:/webpack/bootstrap:19:1)
at Object../src/sqlcipher/lib/sqlite3.js (gateway/build/webpack:/src/sqlcipher/lib/sqlite3.js:2:15)
at webpack_require (/home/nimesh/workspace/XERUS/HUB/Sriharsha-alert/gateway/build/webpack:/webpack/bootstrap:19:1)
at Object../src/sqlcipher/sqlite3.js (gateway/build/webpack:/src/sqlcipher/sqlite3.js:1:18)
at webpack_require (gateway/build/webpack:/webpack/bootstrap:19:1)
at Object../src/db.js gateway/build/webpack:/src/db.js:15:19)
at webpack_require (gateway/build/webpack:/webpack/bootstrap:19:1)

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.