SQL-History Adapter Update failed (1.3.2 auf 1.4.0)

Homoran

@Homoran: Kannst Du vllt mal deinen Hardware-Zoo darauf ansetzen? :-) `
gerne, aber worauf soll ich da achten?

Ich meine gestern ohne Probleme den pine64 auf 1.4.0 upgedated zu haben - hatte ich jedoch spät abends vom tablet gemacht und dann war ich da im timeout. Fehler im Log waren anschließend nicht drin.

Muss heute abend nochmal über den PC nachsehen. bin jetzt im Büro

Vorab:
~~@apollon77:~~

Unter Linux bitte mal versuchen ob es nach
apt-get install build-essential
tut. `
sollte in allen meinen Installationen drin und aktuell sein.

Mac und Windows hab ich nicht

Gruß

Rainer

apollon77

Ich denke das "aktuelle OSe" kein so großes Problem darstellen. Auf dem Pine ist ein Debian Jessie?

Raspi wäre denke ich interessant und naja Synology ist ein Spezialfall der immer wieder Probleme machen wird es sei denn man kann wirklich eigene Pakete nachinstallieren

Homoran

~~@apollon77:~~

Auf dem Pine ist ein Debian Jessie? `
Ja, aktuelle (Beta-) Version vom Armbian (ich meine Kernel 4.xx)

Gruß

Rainer

apollon77

Naja mal schauen was die weiteren Problemkandidaten (neben der Synology) sind. Ältere OS (Raspbian Wheezy glaube ich) haben halt den g++4,8 nicht dabei und damit wird immer mehr schwierig

Homoran

Mit so etwas antiken beschäftige ich mich doch gar nicht :D

Aber im Ernst: ich glaube da war etwas in der Richtung (mit g++), was es schwierig machte unter Wheezy auf node 4.xx zu wechseln.

Gruß

Rainer

apollon77

Ne dfas war die libc version …

Naja mal schauen was die anderen betroffenen Nutzer oben zu Ihren Systemen schreiben

Homoran

Habe gerade mal nachgesehen.

Seid ihr sicher, dass ihr vom History-Adapter redet?

Da habe ich die v1.5.0 :shock:

admin 1.6.8

controller 0.14.0

Gruß

Rainer

apollon77

Es geht um den SQL-History-Adapter :-) ääähm ja, der Thread Tittel ist misleading :-)

Kannste mal "ioBroker.sql" updaten/installieren ? :-)

Homoran

~~@apollon77:~~

Kannste mal "ioBroker.sql" updaten/installieren ? `
läuft, dauert aber anscheinend Stunden.

Die ersten Meldungen:

WARN deprecated node-uuid@1.4.7: use uuid module instead
gyp
 WARN EACCES user "root" does not have permission to access the dev dir "/root/.node-gyp/4.6.1"
gyp WARN EACCES attempting to reinstall using temporary dev dir "/opt/iobroker/node_modules/iobroker.sql/node_modules/sql-client/node_modules/inote-util/node_modules/mmmagic/.node-gyp"

haben mich wieder daran erinnert, dass es sich hier um meine Installation mittels sudo handelt.

Mal sehen was dabei rauskommt :(

EDIT:

Sowas kommt dabei raus:

! ````
$ ./iobroker add sql
npm install iobroker.sql --production --prefix "/opt/iobroker" (System call)
npm

WARN deprecated node-uuid@1.4.7: use uuid module instead
gyp
WARN EACCES user "root" does not have permission to access the dev dir "/root/.node-gyp/4.6.1"
gyp WARN EACCES attempting to reinstall using temporary dev dir "/opt/iobroker/node_modules/iobroker.sql/node_modules/sql-client/node_modules/inote-util/node_modules/mmmagic/.node-gyp"
../deps/libmagic/pcre/pcre_jit_compile.c:65:2: error: #error Unsupported architecture #error Unsupported architecture
^

! make: *** [Release/obj.target/libpcre/deps/libmagic/pcre/pcre_jit_compile.o] Error 1
gyp
ERR! build error
gyp
ERR! stack Error: make failed with exit code: 2gyp ERR! stack at ChildProcess.onExit (/usr/local/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:276:23)
! gyp ERR! stack at emitTwo (events.js:87:13)gyp ERR! stack at ChildProcess.emit (events.js:172:7)
gyp
ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:200:12)
gyp ERR! System Linux 3.10.104-pine64gyp

ERR! command "/usr/local/bin/node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "rebuild"gyp ERR! cwd /opt/iobroker/node_modules/iobroker.sql/node_modules/sql-client/node_modules/inote-util/node_modules/mmmagic
gyp ERR! node -v v4.6.1
gyp ERR! node-gyp -v v3.4.0
gyp ERR! not ok

! node-pre-gyp
ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v46-linux-arm64.tar.gz node-pre-gyp
ERR! Pre-built binaries not found for sqlite3@3.1.8 and node@4.6.1 (node-v46 ABI) (falling back to source compile with node-gyp)
gyp

WARN
EACCES user "root" does not have permission to access the dev dir "/root/.node-gyp/4.6.1"
gyp
WARN EACCES
attempting to reinstall using temporary dev dir "/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/.node-gyp"
make: *** No rule to make target '../.node-gyp/4.6.1/include/node/common.gypi', needed by 'Makefile'. Stop.
gyp

ERR! build error
gyp ERR! stack Error: make failed with exit code: 2gyp ERR!
stack at ChildProcess.onExit (/usr/local/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:276:23)gyp ERR! stack
at emitTwo (events.js:87:13)
gyp ERR! stack at ChildProcess.emit (events.js:172:7)gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:200:12)

! gyp
ERR! System Linux 3.10.104-pine64gyp ERR! command "/usr/local/bin/node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/lib/binding/node-v46-linux-arm64/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/lib/binding/node-v46-linux-arm64"
! gyp ERR! cwd /opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3gyp ERR! node -v v4.6.1
gyp ERR! node-gyp -v v3.4.0
gyp ERR! not ok
node-pre-gyp ERR! build error
! node-pre-gyp
ERR! stack Error: Failed to execute '/usr/local/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/lib/binding/node-v46-linux-arm64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/lib/binding/node-v46-linux-arm64' (1)node-pre-gyp ERR! stack at ChildProcess. <anonymous>(/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
node-pre-gyp ERR! stack at emitTwo (events.js:87:13)
node-pre-gyp
ERR! stack at ChildProcess.emit (events.js:172:7)node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:829:16)
node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:211:5)
node-pre-gyp ERR! System Linux 3.10.104-pine64
! node-pre-gyp ERR! command "/usr/local/bin/node" "/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"node-pre-gyp ERR! cwd /opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3
node-pre-gyp ERR! node -v v4.6.1
node-pre-gyp ERR! node-pre-gyp -v v0.6.31
node-pre-gyp ERR! not ok
! npm

WARN optional dep failed, continuing sqlite3@3.1.8
npm
ERR! Linux 3.10.104-pine64
npm ERR!

argv
"/usr/local/bin/node" "/usr/local/bin/npm" "install" "iobroker.sql" "--production" "--prefix" "/opt/iobroker"npm ERR! node v4.6.1
npm ERR! npm v2.15.9
npm ERR! code ELIFECYCLE

! npm ERR! mmmagic@0.4.5 install: node-gyp rebuild
npm
ERR! Exit status 1npm ERR!
npm ERR! Failed at the mmmagic@0.4.5 install script 'node-gyp rebuild'.
npm ERR! This is most likely a problem with the mmmagic package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node-gyp rebuild
npm ERR! You can get information on how to open an issue for this project with:
npm ERR! npm bugs mmmagic
npm ERR! Or if that isn't available, you can get their info via:
npm ERR!
npm ERR! npm owner ls mmmagic
npm ERR! There is likely additional logging output above.
! npm

ERR! Please include the following file with any support request:npm
ERR! /opt/npm-debug.log
ERROR: host.ioBroker_Pine64 Cannot install iobroker.sql: 1
ERROR: process exited with code 25</anonymous>


Gruß

Rainer

Homoran

bin jetzt mit putty als root drauf:

root@ioBroker_Pine64:~# chmod -R 777 /opt/iobroker
root@ioBroker_Pine64:~# cd /opt/iobroker
root@ioBroker_Pine64:/opt/iobroker# iobroker del sql
host.ioBroker_Pine64 no instances of adapter sql found

kann ich verstehen, denn unter /opt/iobroker/node_modules ist kein Ordner iobroker.sql

Werde jetzt von der Konsole iobroker add sql ausführen

Auch hier ein EDIT:

Ich habe natürlich keine SQL Installation auf dem Pine64!

Gruß

Rainer

Homoran

und nochmal.

Hier das log:

! root@ioBroker_Pine64:/opt/iobroker# iobroker add sql npm install iobroker.sql --production --prefix "/opt/iobroker" (System call) npm WARN deprecated node-uuid@1.4.7: use uuid module instead ../deps/libmagic/pcre/pcre_jit_compile.c:65:2: error: #error Unsupported architecture #error Unsupported architecture ^ make: *** [Release/obj.target/libpcre/deps/libmagic/pcre/pcre_jit_compile.o] Error 1 gyp ERR! build error gyp ERR! stack Error: `make` failed with exit code: 2 gyp ERR! stack at ChildProcess.onExit (/usr/local/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:276:23) gyp ERR! stack at emitTwo (events.js:87:13) gyp ERR! stack at ChildProcess.emit (events.js:172:7) gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:200:12) gyp ERR! System Linux 3.10.104-pine64 gyp ERR! command "/usr/local/bin/node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "rebuild" gyp ERR! cwd /opt/iobroker/node_modules/iobroker.sql/node_modules/sql-client/node_modules/inote-util/node_modules/mmmagic gyp ERR! node -v v4.6.1 gyp ERR! node-gyp -v v3.4.0 gyp ERR! not ok node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v46-linux-arm64.tar.gz node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.8 and node@4.6.1 (node-v46 ABI) (falling back to source compile with node-gyp) ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginOpen(node_sqlite3::Database::Baton*)’: ../src/database.cc:144:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), ^ ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginClose(node_sqlite3::Database::Baton*)’: ../src/database.cc:230:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), ^ ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginExec(node_sqlite3::Database::Baton*)’: ../src/database.cc:525:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), ^ ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginLoadExtension(node_sqlite3::Database::Baton*)’: ../src/database.cc:625:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), ^ ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginPrepare(node_sqlite3::Database::Baton*)’: ../src/statement.cc:118:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), ^ In file included from ../src/statement.cc:6:0: ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginBind(node_sqlite3::Statement::Baton*)’: ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), \ ^ ../src/statement.cc:322:5: note: in expansion of macro ‘STATEMENT_BEGIN’ STATEMENT_BEGIN(Bind); ^ ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginGet(node_sqlite3::Statement::Baton*)’: ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), \ ^ ../src/statement.cc:370:5: note: in expansion of macro ‘STATEMENT_BEGIN’ STATEMENT_BEGIN(Get); ^ ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginRun(node_sqlite3::Statement::Baton*)’: ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), \ ^ ../src/statement.cc:438:5: note: in expansion of macro ‘STATEMENT_BEGIN’ STATEMENT_BEGIN(Run); ^ ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginAll(node_sqlite3::Statement::Baton*)’: ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), \ ^ ../src/statement.cc:504:5: note: in expansion of macro ‘STATEMENT_BEGIN’ STATEMENT_BEGIN(All); ^ ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginEach(node_sqlite3::Statement::Baton*)’: ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), \ ^ ../src/statement.cc:601:5: note: in expansion of macro ‘STATEMENT_BEGIN’ STATEMENT_BEGIN(Each); ^ ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginReset(node_sqlite3::Statement::Baton*)’: ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable] int status = uv_queue_work(uv_default_loop(), \ ^ ../src/statement.cc:724:5: note: in expansion of macro ‘STATEMENT_BEGIN’ STATEMENT_BEGIN(Reset); ^ npm ERR! Linux 3.10.104-pine64 npm ERR! argv "/usr/local/bin/node" "/usr/local/bin/npm" "install" "iobroker.sql" "--production" "--prefix" "/opt/iobroker" npm ERR! node v4.6.1 npm ERR! npm v2.15.9 npm ERR! code ELIFECYCLE ! npm ERR! mmmagic@0.4.5 install: `node-gyp rebuild` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the mmmagic@0.4.5 install script 'node-gyp rebuild'. npm ERR! This is most likely a problem with the mmmagic package, npm ERR! not with npm itself. npm ERR! Tell the author that this fails on your system: npm ERR! node-gyp rebuild npm ERR! You can get information on how to open an issue for this project with: npm ERR! npm bugs mmmagic npm ERR! Or if that isn't available, you can get their info via: npm ERR! npm ERR! npm owner ls mmmagic npm ERR! There is likely additional logging output above. ! npm ERR! Please include the following file with any support request: npm ERR! /opt/iobroker/npm-debug.log host.ioBroker_Pine64 Cannot install iobroker.sql: 1 root@ioBroker_Pine64:/opt/iobroker# !

Was mir direkt ins Auge sprang:

 npm owner ls mmmagic

Gruß

Rainer

Homoran

Nachdem es hier so ruhig bleibt ;-) habe ich mich durchj Internet gequält.

Dann habe ich festgestellt, dass mit mmmagic wahrscheinlich https://www.npmjs.com/package/mmmagic gemeint ist.

Habe versucht das zu installieren, aber….

! ````
root@ioBroker_Pine64:/opt/iobroker# npm install mmmagic
|
mmmagic@0.4.5 install /opt/iobroker/node_modules/mmmagic
node-gyp rebuild
! make: Entering directory '/opt/iobroker/node_modules/mmmagic/build'
CC(target) Release/obj.target/libmagic/deps/libmagic/src/apprentice.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/apptype.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/ascmagic.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/cdf.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/cdf_time.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/compress.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/der.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/encoding.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/fsmagic.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/funcs.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/is_tar.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/magic.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/print.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/readcdf.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/readelf.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/softmagic.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/fmtcheck.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/strlcat.o
CC(target) Release/obj.target/libmagic/deps/libmagic/src/strlcpy.o
AR(target) Release/obj.target/deps/libmagic/magic.a
COPY Release/magic.a
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_byte_order.o
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_chartables.o
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_compile.o
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_config.o
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_dfa_exec.o
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_exec.o
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_fullinfo.o
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_get.o
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_globals.o
CC(target) Release/obj.target/libpcre/deps/libmagic/pcre/pcre_jit_compile.o
../deps/libmagic/pcre/pcre_jit_compile.c:65:2: error: #error Unsupported architecture
#error Unsupported architecture
^
deps/libmagic/pcre/libpcre.target.mk:129: recipe for target 'Release/obj.target/libpcre/deps/libmagic/pcre/pcre_jit_compile.o' failed
make: *** [Release/obj.target/libpcre/deps/libmagic/pcre/pcre_jit_compile.o] Error 1
make: Leaving directory '/opt/iobroker/node_modules/mmmagic/build'
gyp ERR! build error
gyp ERR! stack Error: make failed with exit code: 2
gyp ERR! stack at ChildProcess.onExit (/usr/local/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:276:23)
gyp ERR! stack at emitTwo (events.js:87:13)
gyp ERR! stack at ChildProcess.emit (events.js:172:7)
gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:200:12)
gyp ERR! System Linux 3.10.104-pine64
gyp ERR! command "/usr/local/bin/node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "rebuild"
gyp ERR! cwd /opt/iobroker/node_modules/mmmagic
gyp ERR! node -v v4.6.1
gyp ERR! node-gyp -v v3.4.0
gyp ERR! not ok
npm ERR! Linux 3.10.104-pine64
npm ERR! argv "/usr/local/bin/node" "/usr/local/bin/npm" "install" "mmmagic"
npm ERR! node v4.6.1
npm ERR! npm v2.15.9
npm ERR! code ELIFECYCLE
! npm ERR! mmmagic@0.4.5 install: node-gyp rebuild
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the mmmagic@0.4.5 install script 'node-gyp rebuild'.
npm ERR! This is most likely a problem with the mmmagic package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node-gyp rebuild
npm ERR! You can get information on how to open an issue for this project with:
npm ERR! npm bugs mmmagic
npm ERR! Or if that isn't available, you can get their info via:
npm ERR!
npm ERR! npm owner ls mmmagic
npm ERR! There is likely additional logging output above.
! npm ERR! Please include the following file with any support request:
npm ERR! /opt/iobroker/npm-debug.log


kann natürlich wieder an meiner 64Bit Umgebung auf dem Pine64 liegen.

Werde da jetzt auch erst mal nicht weitermachen, da es meine Produktivumgebung ist.

Wie bekomme ich es da jetzt wieder runter?

So jedenfalls nicht:

root@ioBroker_Pine64:/opt/iobroker# npm uninstall mmmagic
npm WARN uninstall not installed in /opt/iobroker/node_modules: "mmmagic"


oder heisst das, dass da wirklich nichts hängengeblieben ist?

Mache jetzt auf dem Cubie weiter.

Gruß

Rainer

Homoran

So: Monolog die fünfte ;-)

Auf dem Cubie läuft der Adapter.

Installation im Admin hatte leider ein paar Hindernisse.

Ich Depp habe das Installationsfenster geschlossen, daher habe ich keine durchgehende Doku über die Meldungen.

Habe mal versucht dies aus dem Log noch zu extrahieren, hoffentlich nicht zuviel gelöscht:

! ````
sql.0 2016-12-21 19:02:25.092 info Connected to sqlite
sql.0 2016-12-21 19:02:22.724 info starting. Version 1.4.0 in /opt/iobroker/node_modules/iobroker.sql, node: v6.9.2
host. 2016-12-21 19:02:22.466 info States connected to redis 127.0.0.1:6379
iobroker 2016-12-21 19:02:13.079 info exit 0
iobroker 2016-12-21 19:02:12.909 info host.ioBroker_Cubie object system.adapter.sql.0 created
host.ioBroker_Cubie 2016-12-21 19:02:12.862 info instance system.adapter.sql.0 started with pid 13487
host.ioBroker_Cubie 2016-12-21 19:02:12.736 info object change system.adapter.sql.0
iobroker 2016-12-21 19:02:12.681 info host.ioBroker_Cubie object system.adapter.sql.0.alive created
iobroker 2016-12-21 19:02:12.639 info host.ioBroker_Cubie object system.adapter.sql.0.connected created
iobroker 2016-12-21 19:02:12.595 info host.ioBroker_Cubie object system.adapter.sql.0.memHeapUsed created
iobroker 2016-12-21 19:02:12.552 info host.ioBroker_Cubie object system.adapter.sql.0.memHeapTotal created
iobroker 2016-12-21 19:02:12.508 info host.ioBroker_Cubie object system.adapter.sql.0.memRss created
iobroker 2016-12-21 19:02:12.462 info host.ioBroker_Cubie object system.adapter.sql.0.uptime created
iobroker 2016-12-21 19:02:12.426 info host.ioBroker_Cubie create instance sql
iobroker 2016-12-21 19:02:12.251 info host.ioBroker_Cubie object _design/custom created
iobroker 2016-12-21 19:02:12.182 info host.ioBroker_Cubie object system.adapter.sql created
iobroker 2016-12-21 19:02:11.672 info upload [0] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/custom.html custom.html text/html
iobroker 2016-12-21 19:02:11.444 info upload [1] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/index.html index.html text/html
iobroker 2016-12-21 19:02:11.162 info upload [2] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/sql.png sql.png image/png
iobroker 2016-12-21 19:02:11.122 info got /opt/iobroker/node_modules/iobroker.sql/admin
iobroker 2016-12-21 19:01:37.459 info ^
iobroker 2016-12-21 19:01:37.459 info STATEMENT_BEGIN(Reset);
iobroker 2016-12-21 19:01:37.459 info ../src/statement.cc:724:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 19:01:37.459 info ^
iobroker 2016-12-21 19:01:37.459 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:37.459 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginReset(node_sqlite3::Statement::Baton*)’:../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:37.379 info ^
iobroker 2016-12-21 19:01:37.379 info STATEMENT_BEGIN(Each);
iobroker 2016-12-21 19:01:37.379 info ../src/statement.cc:601:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 19:01:37.379 info ^
iobroker 2016-12-21 19:01:37.379 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:37.379 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginEach(node_sqlite3::Statement::Baton*)’:../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:37.305 info ^
iobroker 2016-12-21 19:01:37.305 info STATEMENT_BEGIN(All);
iobroker 2016-12-21 19:01:37.305 info ../src/statement.cc:504:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 19:01:37.305 info ^
iobroker 2016-12-21 19:01:37.305 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:37.305 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginAll(node_sqlite3::Statement::Baton*)’:../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:37.219 info ^
iobroker 2016-12-21 19:01:37.219 info STATEMENT_BEGIN(Run);
iobroker 2016-12-21 19:01:37.219 info ../src/statement.cc:438:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 19:01:37.219 info ^
iobroker 2016-12-21 19:01:37.219 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:37.219 info ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:37.219 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginRun(node_sqlite3::Statement::Baton*)’:
iobroker 2016-12-21 19:01:37.219 info ^
iobroker 2016-12-21 19:01:37.219 info STATEMENT_BEGIN(Get);
iobroker 2016-12-21 19:01:37.219 info ../src/statement.cc:370:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 19:01:37.219 info ^
iobroker 2016-12-21 19:01:37.219 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:37.219 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginGet(node_sqlite3::Statement::Baton*)’:../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:37.193 info ^
iobroker 2016-12-21 19:01:37.193 info STATEMENT_BEGIN(Bind);
iobroker 2016-12-21 19:01:37.193 info ../src/statement.cc:322:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 19:01:37.193 info ^
iobroker 2016-12-21 19:01:37.193 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:37.193 info ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:37.193 info In file included from ../src/statement.cc:6:0:../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginBind(node_sqlite3::Statement::Baton*)’:
iobroker 2016-12-21 19:01:37.132 info ^
iobroker 2016-12-21 19:01:37.132 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:37.132 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginPrepare(node_sqlite3::Database::Baton*)’:../src/statement.cc:118:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:37.106 info ^
iobroker 2016-12-21 19:01:37.106 info info.This()->ForceSet(Nan::New('sql').ToLocalChecked(), sql, ReadOnly);
iobroker 2016-12-21 19:01:37.106 info ../src/statement.cc: In static member function ‘static Nan::NAN_METHOD_RETURN_TYPE node_sqlite3::Statement::New(Nan::NAN_METHOD_ARGS_TYPE)’:../src/statement.cc:103:74: warning: ‘bool v8::Object::ForceSet(v8::Local, v8::Local, v8::PropertyAttribute)’ is deprecated (declared at /root/.node-gyp/6.9.2/include/node/v8.h:2694): Use CreateDataProperty / DefineOwnProperty [-Wdeprecated-declarations]
iobroker 2016-12-21 19:01:07.102 info ^
iobroker 2016-12-21 19:01:07.102 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:07.102 info ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginLoadExtension(node_sqlite3::Database::Baton*)’:../src/database.cc:625:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:07.060 info ^
iobroker 2016-12-21 19:01:07.060 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:07.060 info ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginExec(node_sqlite3::Database::Baton*)’:../src/database.cc:525:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:06.805 info ^
iobroker 2016-12-21 19:01:06.805 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:06.805 info ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginClose(node_sqlite3::Database::Baton*)’:../src/database.cc:230:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:06.761 info ^
iobroker 2016-12-21 19:01:06.761 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 19:01:06.761 info ../src/database.cc:144:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 19:01:06.761 info ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginOpen(node_sqlite3::Database::Baton*)’:
iobroker 2016-12-21 19:01:06.761 info ^
iobroker 2016-12-21 19:01:06.761 info ../src/database.cc:134:86: warning: ‘bool v8::Object::ForceSet(v8::Local, v8::Local, v8::PropertyAttribute)’ is deprecated (declared at /root/.node-gyp/6.9.2/include/node/v8.h:2694): Use CreateDataProperty / DefineOwnProperty [-Wdeprecated-declarations] info.This()->ForceSet(Nan::New('mode').ToLocalChecked(), Nan::New(mode), ReadOnly);
iobroker 2016-12-21 19:01:06.745 info ^
iobroker 2016-12-21 19:01:06.745 info info.This()->ForceSet(Nan::New('filename').ToLocalChecked(), info[0].As(), ReadOnly);
iobroker 2016-12-21 19:01:06.745 info ../src/database.cc: In static member function ‘static Nan::NAN_METHOD_RETURN_TYPE node_sqlite3::Database::New(Nan::NAN_METHOD_ARGS_TYPE)’:../src/database.cc:133:96: warning: ‘bool v8::Object::ForceSet(v8::Local, v8::Local, v8::PropertyAttribute)’ is deprecated (declared at /root/.node-gyp/6.9.2/include/node/v8.h:2694): Use CreateDataProperty / DefineOwnProperty [-Wdeprecated-declarations]
iobroker 2016-12-21 18:52:16.538 info ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v48-linux-arm.tar.gz node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.8 and node@6.9.2 (node-v48 ABI) (falling back to source compile with node-gyp)
iobroker 2016-12-21 18:52:16.527 info node-pre-gyp
iobroker 2016-12-21 18:50:50.883 info ^
iobroker 2016-12-21 18:50:50.883 info static sljit_si getput_arg(struct sljit_compiler compiler, sljit_si flags, sljit_si reg, sljit_si arg, sljit_sw argw, sljit_si next_arg, sljit_sw next_argw)
iobroker 2016-12-21 18:50:50.883 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:1019:148: warning: parameter ‘next_argw’ set but not used [-Wunused-but-set-parameter]
iobroker 2016-12-21 18:50:50.883 info ^
iobroker 2016-12-21 18:50:50.883 info sljit_si tmp_r;
iobroker 2016-12-21 18:50:50.883 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c: In function ‘getput_arg’:../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:1021:11: warning: variable ‘tmp_r’ set but not used [-Wunused-but-set-variable]
iobroker 2016-12-21 18:50:50.867 info ^
iobroker 2016-12-21 18:50:50.867 info if (value != INVALID_IMM)
iobroker 2016-12-21 18:50:50.867 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:905:13: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:50:50.867 info ^
iobroker 2016-12-21 18:50:50.867 info if (value != INVALID_IMM)
iobroker 2016-12-21 18:50:50.867 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:897:13: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:50:50.867 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c: In function ‘emit_set_delta’:
iobroker 2016-12-21 18:50:50.867 info ^
iobroker 2016-12-21 18:50:50.867 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:50:50.867 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:800:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:50:50.867 info ^
iobroker 2016-12-21 18:50:50.867 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:50:50.867 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:796:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:50:50.867 info ^
iobroker 2016-12-21 18:50:50.867 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:792:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare] if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:50:50.833 info ^
iobroker 2016-12-21 18:50:50.833 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:50:50.833 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:788:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:50:50.833 info ^
iobroker 2016-12-21 18:50:50.833 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:50:50.833 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:784:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:50:50.833 info ^
iobroker 2016-12-21 18:50:50.833 info if (dst == arg1 && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:50:50.833 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:777:12: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:50:50.833 info ^
iobroker 2016-12-21 18:50:50.833 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:50:50.833 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:765:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:50:50.833 info ^
iobroker 2016-12-21 18:50:50.833 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:50:50.833 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:757:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:50:50.833 info ^
iobroker 2016-12-21 18:50:50.833 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:753:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare] if (dst == arg1 && !(flags & SET_FLAGS))
iobroker 2016-12-21 18:50:50.815 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c: In function ‘emit_op_imm’:
iobroker 2016-12-21 18:50:50.815 info In file included from ../deps/libmagic/pcre/sljit/sljitLir.c:1333:0, from ../deps/libmagic/pcre/pcre_jit_compile.c:62:
iobroker 2016-12-21 18:43:46.296 info node-uuid@1.4.7: use uuid module instead
iobroker 2016-12-21 18:43:46.290 info npm WARN deprecated
iobroker 2016-12-21 18:42:35.521 info host.ioBroker_Cubie install adapter sqlnpm install --production --prefix '/opt/iobroker/node_modules/iobroker.sql' (System call)
iobroker 2016-12-21 18:41:27.018 info ^
iobroker 2016-12-21 18:41:27.018 info STATEMENT_BEGIN(Reset);
iobroker 2016-12-21 18:41:27.018 info ../src/statement.cc:724:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 18:41:27.018 info ^
iobroker 2016-12-21 18:41:27.018 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:41:27.018 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginReset(node_sqlite3::Statement::Baton)’:../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:41:26.925 info ^
iobroker 2016-12-21 18:41:26.925 info STATEMENT_BEGIN(Each);
iobroker 2016-12-21 18:41:26.925 info ../src/statement.cc:601:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 18:41:26.925 info ^
iobroker 2016-12-21 18:41:26.925 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:41:26.925 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginEach(node_sqlite3::Statement::Baton*)’:../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:41:26.853 info ^
iobroker 2016-12-21 18:41:26.853 info STATEMENT_BEGIN(All);
iobroker 2016-12-21 18:41:26.853 info ../src/statement.cc:504:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 18:41:26.853 info ^
iobroker 2016-12-21 18:41:26.853 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:41:26.853 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginAll(node_sqlite3::Statement::Baton*)’:../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:41:26.810 info ^
iobroker 2016-12-21 18:41:26.810 info STATEMENT_BEGIN(Run);
iobroker 2016-12-21 18:41:26.810 info ../src/statement.cc:438:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 18:41:26.810 info ^
iobroker 2016-12-21 18:41:26.810 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:41:26.810 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginRun(node_sqlite3::Statement::Baton*)’:../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:41:26.774 info ^
iobroker 2016-12-21 18:41:26.774 info STATEMENT_BEGIN(Get);
iobroker 2016-12-21 18:41:26.774 info ../src/statement.cc:370:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 18:41:26.774 info ^
iobroker 2016-12-21 18:41:26.774 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:41:26.774 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginGet(node_sqlite3::Statement::Baton*)’:../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:41:26.752 info ^
iobroker 2016-12-21 18:41:26.752 info STATEMENT_BEGIN(Bind);
iobroker 2016-12-21 18:41:26.752 info ../src/statement.cc:322:5: note: in expansion of macro ‘STATEMENT_BEGIN’
iobroker 2016-12-21 18:41:26.752 info ^
iobroker 2016-12-21 18:41:26.752 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:41:26.752 info ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:41:26.752 info In file included from ../src/statement.cc:6:0:../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginBind(node_sqlite3::Statement::Baton*)’:
iobroker 2016-12-21 18:41:26.699 info ^
iobroker 2016-12-21 18:41:26.699 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:41:26.699 info ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginPrepare(node_sqlite3::Database::Baton*)’:../src/statement.cc:118:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:41:26.665 info ^
iobroker 2016-12-21 18:41:26.665 info info.This()->ForceSet(Nan::New('sql').ToLocalChecked(), sql, ReadOnly);
iobroker 2016-12-21 18:41:26.665 info ../src/statement.cc: In static member function ‘static Nan::NAN_METHOD_RETURN_TYPE node_sqlite3::Statement::New(Nan::NAN_METHOD_ARGS_TYPE)’:../src/statement.cc:103:74: warning: ‘bool v8::Object::ForceSet(v8::Local, v8::Local, v8::PropertyAttribute)’ is deprecated (declared at /root/.node-gyp/6.9.2/include/node/v8.h:2694): Use CreateDataProperty / DefineOwnProperty [-Wdeprecated-declarations]
iobroker 2016-12-21 18:40:56.740 info ^
iobroker 2016-12-21 18:40:56.740 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:40:56.740 info ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginLoadExtension(node_sqlite3::Database::Baton*)’:../src/database.cc:625:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:40:56.694 info ^
iobroker 2016-12-21 18:40:56.694 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:40:56.694 info ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginExec(node_sqlite3::Database::Baton*)’:../src/database.cc:525:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:40:56.424 info ^
iobroker 2016-12-21 18:40:56.424 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:40:56.424 info ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginClose(node_sqlite3::Database::Baton*)’:../src/database.cc:230:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:40:56.381 info ^
iobroker 2016-12-21 18:40:56.381 info int status = uv_queue_work(uv_default_loop(),
iobroker 2016-12-21 18:40:56.381 info ../src/database.cc:144:9: warning: unused variable ‘status’ [-Wunused-variable]
iobroker 2016-12-21 18:40:56.381 info ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginOpen(node_sqlite3::Database::Baton*)’:
iobroker 2016-12-21 18:40:56.381 info ^
iobroker 2016-12-21 18:40:56.381 info ../src/database.cc:134:86: warning: ‘bool v8::Object::ForceSet(v8::Local, v8::Local, v8::PropertyAttribute)’ is deprecated (declared at /root/.node-gyp/6.9.2/include/node/v8.h:2694): Use CreateDataProperty / DefineOwnProperty [-Wdeprecated-declarations] info.This()->ForceSet(Nan::New('mode').ToLocalChecked(), Nan::New(mode), ReadOnly);
iobroker 2016-12-21 18:40:56.368 info ^
iobroker 2016-12-21 18:40:56.368 info info.This()->ForceSet(Nan::New('filename').ToLocalChecked(), info[0].As(), ReadOnly);
iobroker 2016-12-21 18:40:56.368 info ../src/database.cc: In static member function ‘static Nan::NAN_METHOD_RETURN_TYPE node_sqlite3::Database::New(Nan::NAN_METHOD_ARGS_TYPE)’:../src/database.cc:133:96: warning: ‘bool v8::Object::ForceSet(v8::Local, v8::Local, v8::PropertyAttribute)’ is deprecated (declared at /root/.node-gyp/6.9.2/include/node/v8.h:2694): Use CreateDataProperty / DefineOwnProperty [-Wdeprecated-declarations]
iobroker 2016-12-21 18:32:05.398 info Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v48-linux-arm.tar.gz node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.8 and node@6.9.2 (node-v48 ABI) (falling back to source compile with node-gyp)
iobroker 2016-12-21 18:32:05.379 info ERR!
iobroker 2016-12-21 18:32:05.368 info node-pre-gyp
iobroker 2016-12-21 18:30:40.378 info ^
iobroker 2016-12-21 18:30:40.378 info static sljit_si getput_arg(struct sljit_compiler *compiler, sljit_si flags, sljit_si reg, sljit_si arg, sljit_sw argw, sljit_si next_arg, sljit_sw next_argw)
iobroker 2016-12-21 18:30:40.378 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:1019:148: warning: parameter ‘next_argw’ set but not used [-Wunused-but-set-parameter]
iobroker 2016-12-21 18:30:40.378 info ^
iobroker 2016-12-21 18:30:40.378 info sljit_si tmp_r;
iobroker 2016-12-21 18:30:40.378 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c: In function ‘getput_arg’:../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:1021:11: warning: variable ‘tmp_r’ set but not used [-Wunused-but-set-variable]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (value != INVALID_IMM)
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:905:13: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (value != INVALID_IMM)
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:897:13: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c: In function ‘emit_set_delta’:
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:800:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:796:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:792:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:788:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:784:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (dst == arg1 && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:777:12: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:765:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info if (dst == arg1 && !(flags & KEEP_FLAGS) && IS_2_LO_REGS(dst, arg2))
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:757:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare]
iobroker 2016-12-21 18:30:40.346 info ^
iobroker 2016-12-21 18:30:40.346 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c:753:11: warning: comparison between signed and unsigned integer expressions [-Wsign-compare] if (dst == arg1 && !(flags & SET_FLAGS))
iobroker 2016-12-21 18:30:40.256 info ../deps/libmagic/pcre/sljit/sljitNativeARM_Thumb2.c: In function ‘emit_op_imm’:
iobroker 2016-12-21 18:30:40.256 info In file included from ../deps/libmagic/pcre/sljit/sljitLir.c:1333:0, from ../deps/libmagic/pcre/pcre_jit_compile.c:62:

…und natürlich rückwärts.

Weiterhin habe ich nichts vorher auf den neuesten Stand gebracht, vielleicht ist das aber von Vorteil:

Controller: 0.13.2

Admin: 1.6.7

Cubietruck mit Ambian auf jessie mit Kernel 4.8.4

  ` > ____ _ _ _ _
> 
> / ___| _| |__ (_) ___| |_ _ __ _ _ ___| | __
> 
> | | | | | | '_ \| |/ _ \ __| '__| | | |/ __| |/ /
> 
> | |__| |_| | |_) | | __/ |_| | | |_| | (__| <
> 
> \____\__,_|_.__/|_|\___|\__|_| \__,_|\___|_|\_\
> 
> Welcome to ARMBIAN Debian GNU/Linux 8 (jessie) 4.8.4-sunxi
> 
> System load: 0.13 Up time: 16 days
> 
> Memory usage: 27 % of 2006Mb IP: 192.168.xxx.yyy
> 
> CPU temp: 38°C HDD temp: 40°C
> 
> Usage of /: 14% of 15G `  

Gruß

Rainer

apollon77

Hey Rainer,

Danke!!!

Also das mit der mmageic fürchte liegt an deinem 64bit ARM Ding … kannst versucen manuell (siehe ein Post von mir oben) "libmagic1" per apg-get install zu installieren, danach tuts vielleicht.

Aber das es dem cubie geht ist schonmal cool. Ja da kommen eine melnge warnungen - scheinbar nicht ganz sauber programmiert, sind aber nur Warnungen.

Jetzt müssen die anderen mal was sagen!

Homoran

~~@apollon77:~~

"libmagic1" per apg-get install zu installieren, `
libmagic1 heisst das Teil????

ohne 1 hatte ich nichts installieren können, deswegen der Versuch über npm :(

~~@apollon77:~~

Aber das es dem cubie geht ist schonmal cool. Ja da kommen eine melnge warnungen - scheinbar nicht ganz sauber programmiert, sind aber nur Warnungen. ` eben, irgendwelche 404 dann geht er zum build und alles ist gut

läuft auch und ich könnte Datenpunkte dafür aktivieren, aber ohne SQL(ite) ergibt das keinen Sinn.

Ich könnte höchstens noch auf dem NUC testen, da ist auch natives Debian Jessie drauf und ich glaube auch sql.

Merke gerade der NUC ist tot :cry: :cry: :cry:

Gruß

Rainer

apollon77

Ich denke sqlite ist drauf!

Der versucht zuerst ein fertig kompiliertes Paket von SQLite runterzuladen für dein system. 404 heisst das er es nicht gefunden hat. Dann sagt er sich "Mist, naja dann kompilier ichs halt selber" und dann kommen die ganzen Compiler-Warnungen.

AM Ende stand bei DIr ja "SQLite connected" … also das sollte geklappt haben!

Homoran

~~@apollon77:~~

AM Ende stand bei DIr ja "SQLite connected" `
Das hatte mich ja irritiert, aber wenn das sqlite bei armbian drauf ist (oder ich hatte es mal selber draufgespielt, oder….

Ist ja gut.

Mein NUC sagt nichts mehr :cry:

er ist noch warm, der Speicher auch, und im innern leuchtet etwas grün.

Kein Bild, kein BIOS, keine Festplattenzugriffe.....

Kennt sich da jemand aus??

NUC5PPYH

Jede Hilfe dankend angenommen

Rainer

apollon77

Hallo an die anderen User mit Problemen … hbt Ihr weitere Details? Sonnst kann ich Euch nicht helfen!

RizoliBS

~~@apollon77:~~

Hallo an die anderen User mit Problemen … hbt Ihr weitere Details? Sonnst kann ich Euch nicht helfen! `

Hallo Apollon77,

frohe Weihnachten vorab.

Auf meinem Windows-System will das SQL-History Adapter leider noch nicht.

Welche Daten benötigst Du?

Danke & schöne Feiertage

Sven aka RizoliBS

apollon77

Hey Sven,

siehe http://forum.iobroker.net/viewtopic.php … 508#p43698

Community Forum

NEWS

SQL-History Adapter Update failed (1.3.2 auf 1.4.0)

Support us

746

32.6k

82.1k

1.3m