Pre-built binaries not found for sqlite3@3.1.13 and node@6.12.3

[jhg]

Hallo zusammen,

ich erhalte seit kurzem beim Update jedes Adapters die oben genannte Fehlermeldung.

Es kommt danach die Meldung "falling back to source compile with node-gyp" und am Ende funktioniert auch alles.

Aber jeder Adapter-Update dauert sehr lange und der Raspi ist dabei völlig ausgelastet.

Admin ist 2.0.9

Ich verwende SQL auf einer Synology

Kann mir jemand einen Tipp geben, was hier falsch läuft und wie das zu beheben ist.

Danke im Voraus.

[apollon77]

wie ist denn das vollständige Log? Ist das kompilieren der sqlite erfolgreich? Dann sollte er es nämlich nicht jedes mal neu versuchen …

Poste mal log bitte

[Kueppert]

Den Fehler hab ich auch, nur dass er bei mir nicht Mal innerhalb 1h fertig wurde… Kaltstart hat geholfen und es tat nachher auch wieder alles...

Gesendet von meinem HUAWEI RIO-L01 mit Tapatalk

[jhg]

Im Log ist keine Fehlermeldung sichtbar, auch deshalb weil die ersten Einträge im Log von 1:00 Uhr heute morgen sind, der Fehler aber gestern abend schon auftrat.

[apollon77]

Auf der Platte liegt in /opt/iobroker/log/iobroker* noch die Logfiles der letzten 7 Tage

[jhg]

Danke für die Info.

Hier der Auszug aus dem Log.

! 2018-01-30 22:13:52.967 - ^[[32minfo^[[39m: iobroker upgrade hm-rpc
! 2018-01-30 22:13:56.277 - ^[[32minfo^[[39m: iobroker Update hm-rpc from @1.5.0 to @1.5.1
! 2018-01-30 22:13:56.284 - ^[[32minfo^[[39m: iobroker npm install iobroker.hm-rpc@1.5.1 –production --prefix "/opt/iobroker" (System call)
! 2018-01-30 22:14:17.848 - ^[[32minfo^[[39m: smartmeter.0 Received 10 values, 3 updated
! 2018-01-30 22:15:02.502 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:02.496Z Connected system.user.admin
! 2018-01-30 22:15:10.701 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:10.700Z Connected system.user.admin
! 2018-01-30 22:15:10.923 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:10.923Z Connected system.user.admin
! 2018-01-30 22:15:11.299 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:11.299Z Connected system.user.admin
! 2018-01-30 22:15:11.578 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:11.578Z Connected system.user.admin
! 2018-01-30 22:15:15.485 - ^[[32minfo^[[39m: hm-rpc.2 Disconnected
! 2018-01-30 22:15:16.139 - ^[[32minfo^[[39m: hm-rpc.2 binrpc -> listDevices 21
! 2018-01-30 22:15:16.173 - ^[[32minfo^[[39m: hm-rpc.2 new CUxD devices/channels after filter: 0
! 2018-01-30 22:15:16.175 - ^[[32minfo^[[39m: hm-rpc.2 Connected
! 2018-01-30 22:15:28.216 - ^[[32minfo^[[39m: iobroker node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws ... arm.tar.gz node-pre-gyp ERR! Pre-built bina$
! 2018-01-30 22:15:30.566 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:30.566Z Connected system.user.admin
! 2018-01-30 22:15:30.689 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:30.689Z Connected system.user.admin
! 2018-01-30 22:15:32.656 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:32.655Z Connected system.user.admin
! 2018-01-30 22:15:34.525 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:34.525Z Connected system.user.admin
! 2018-01-30 22:15:53.526 - ^[[32minfo^[[39m: web.0 2018-01-30T21:15:53.526Z Connected system.user.admin
! 2018-01-30 22:16:24.140 - ^[[32minfo^[[39m: web.0 2018-01-30T21:16:24.140Z Connected system.user.admin
! 2018-01-30 22:16:37.412 - ^[[32minfo^[[39m: web.0 2018-01-30T21:16:37.412Z Connected system.user.admin
! 2018-01-30 22:16:59.787 - ^[[32minfo^[[39m: web.0 2018-01-30T21:16:59.786Z Connected system.user.admin
! 2018-01-30 22:17:08.556 - ^[[32minfo^[[39m: web.0 2018-01-30T21:17:08.556Z Connected system.user.admin
! 2018-01-30 22:17:08.729 - ^[[32minfo^[[39m: web.0 2018-01-30T21:17:08.729Z Connected system.user.admin
! 2018-01-30 22:17:09.009 - ^[[32minfo^[[39m: web.0 2018-01-30T21:17:09.009Z Connected system.user.admin
! 2018-01-30 22:17:09.146 - ^[[32minfo^[[39m: web.0 2018-01-30T21:17:09.146Z Connected system.user.admin
! 2018-01-30 22:17:18.631 - ^[[32minfo^[[39m: web.0 2018-01-30T21:17:18.631Z Connected system.user.admin
! 2018-01-30 22:17:19.832 - ^[[32minfo^[[39m: web.0 2018-01-30T21:17:19.832Z Connected system.user.admin
! 2018-01-30 22:17:20.477 - ^[[32minfo^[[39m: web.0 2018-01-30T21:17:20.477Z Connected system.user.admin
! 2018-01-30 22:19:37.886 - ^[[32minfo^[[39m: hm-rpc.2 Disconnected
! 2018-01-30 22:19:38.203 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.202Z Connected system.user.admin
! 2018-01-30 22:19:38.212 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.212Z Connected system.user.admin
! 2018-01-30 22:19:38.222 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.222Z Connected system.user.admin
! 2018-01-30 22:19:38.245 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.244Z Connected system.user.admin
! 2018-01-30 22:19:38.275 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.275Z Connected system.user.admin
! 2018-01-30 22:19:38.312 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.312Z Connected system.user.admin
! 2018-01-30 22:19:38.322 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.322Z Connected system.user.admin
! 2018-01-30 22:19:38.329 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.328Z Connected system.user.admin
! 2018-01-30 22:19:38.335 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.335Z Connected system.user.admin
! 2018-01-30 22:19:38.346 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.346Z Connected system.user.admin
! 2018-01-30 22:19:38.350 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.350Z Connected system.user.admin
! 2018-01-30 22:19:38.366 - ^[[32minfo^[[39m: web.0 2018-01-30T21:19:38.366Z Connected system.user.admin
! 2018-01-30 22:19:38.502 - ^[[32minfo^[[39m: iobroker Killed
! 2018-01-30 22:19:38.517 - ^[[31merror^[[39m: iobroker host.ioB-Master Cannot install iobroker.hm-rpc@1.5.1: 137
! 2018-01-30 22:19:38.655 - ^[[32minfo^[[39m: iobroker exit 25
! 2018-01-30 22:19:38.681 - ^[[33mwarn^[[39m: email.0 Reconnection to DB.
! 2018-01-30 22:19:38.712 - ^[[33mwarn^[[39m: web.0 Reconnection to DB.
! 2018-01-30 22:19:38.781 - ^[[33mwarn^[[39m: email.0 Reconnection to DB.
! 2018-01-30 22:19:38.855 - ^[[33mwarn^[[39m: web.0 Reconnection to DB.
! 2018-01-30 22:19:39.844 - ^[[32minfo^[[39m: smartmeter.0 Received 10 values, 3 updated
! 2018-01-30 22:19:40.703 - ^[[32minfo^[[39m: email.0 starting. Version 1.0.2 in /opt/iobroker/node_modules/iobroker.email, node: v6.12.3
! 2018-01-30 22:19:41.457 - ^[[33mwarn^[[39m: hm-rpc.0 Reconnection to DB.
! 2018-01-30 22:19:41.465 - ^[[33mwarn^[[39m: telegram.0 Reconnection to DB.
! 2018-01-30 22:19:41.472 - ^[[33mwarn^[[39m: hm-rpc.1 Reconnection to DB.
! 2018-01-30 22:19:41.485 - ^[[33mwarn^[[39m: hm-rega.0 Reconnection to DB.
! 2018-01-30 22:19:41.508 - ^[[33mwarn^[[39m: cloud.0 Reconnection to DB.
! 2018-01-30 22:19:41.506 - ^[[33mwarn^[[39m: hm-rpc.2 Reconnection to DB.
! 2018-01-30 22:19:41.522 - ^[[33mwarn^[[39m: smartmeter.0 Reconnection to DB.
! 2018-01-30 22:19:41.524 - ^[[33mwarn^[[39m: socketio.0 Reconnection to DB.
! 2018-01-30 22:19:41.502 - ^[[33mwarn^[[39m: sql.0 Reconnection to DB.
! 2018-01-30 22:19:41.568 - ^[[32minfo^[[39m: email.0 starting. Version 1.0.2 in /opt/iobroker/node_modules/iobroker.email, node: v6.12.3
! 2018-01-30 22:19:41.559 - ^[[33mwarn^[[39m: admin.0 Reconnection to DB.
! 2018-01-30 22:19:44.643 - ^[[33mwarn^[[39m: telegram.0 Reconnection to DB.
! 2018-01-30 22:19:44.656 - ^[[33mwarn^[[39m: hm-rpc.1 Reconnection to DB.
! 2018-01-30 22:19:44.674 - ^[[33mwarn^[[39m: hm-rpc.0 Reconnection to DB.
! 2018-01-30 22:19:44.666 - ^[[33mwarn^[[39m: hm-rega.0 Reconnection to DB.
! 2018-01-30 22:19:44.679 - ^[[33mwarn^[[39m: socketio.0 Reconnection to DB.
! 2018-01-30 22:19:44.692 - ^[[33mwarn^[[39m: cloud.0 Reconnection to DB.
! 2018-01-30 22:19:44.711 - ^[[33mwarn^[[39m: hm-rpc.2 Reconnection to DB.
! 2018-01-30 22:19:44.723 - ^[[33mwarn^[[39m: sql.0 Reconnection to DB.
! 2018-01-30 22:19:44.758 - ^[[33mwarn^[[39m: admin.0 Reconnection to DB.
! 2018-01-30 22:19:44.763 - ^[[33mwarn^[[39m: smartmeter.0 Reconnection to DB.
! 2018-01-30 22:19:45.162 - ^[[33mwarn^[[39m: rpi2.0 Reconnection to DB.
! 2018-01-30 22:19:45.180 - ^[[32minfo^[[39m: hm-rpc.1 starting. Version 1.5.0 in /opt/iobroker/node_modules/iobroker.hm-rpc, node: v6.12.3
! 2018-01-30 22:19:45.208 - ^[[32minfo^[[39m: hm-rpc.0 starting. Version 1.5.0 in /opt/iobroker/node_modules/iobroker.hm-rpc, node: v6.12.3
! 2018-01-30 22:19:45.214 - ^[[32minfo^[[39m: hm-rega.0 starting. Version 1.6.6 in /opt/iobroker/node_modules/iobroker.hm-rega, node: v6.12.3
! 2018-01-30 22:19:45.254 - ^[[32minfo^[[39m: hm-rpc.2 starting. Version 1.5.0 in /opt/iobroker/node_modules/iobroker.hm-rpc, node: v6.12.3
! 2018-01-30 22:19:45.222 - ^[[32minfo^[[39m: hm-rega.0 subscribe hm-rpc.0.BidCoS-RF.50.PRESS_SHORT
! 2018-01-30 22:19:45.459 - ^[[32minfo^[[39m: hm-rega.0 ReGaHSS 192.168.2.15 up
! 2018-01-30 22:19:45.479 - ^[[32minfo^[[39m: hm-rega.0 time difference local-ccu 0s
! 2018-01-30 22:19:45.518 - ^[[32minfo^[[39m: hm-rega.0 added/updated 1 favorites to enum.favorite
! 2018-01-30 22:19:45.610 - ^[[32minfo^[[39m: hm-rega.0 added/updated functions to enum.functions
! 2018-01-30 22:19:45.728 - ^[[32minfo^[[39m: hm-rega.0 added/updated rooms to enum.rooms
! 2018-01-30 22:19:46.489 - ^[[33mwarn^[[39m: rpi2.0 Reconnection to DB.
! 2018-01-30 22:19:46.806 - ^[[32minfo^[[39m: socketio.0 starting. Version 1.8.6 in /opt/iobroker/node_modules/iobroker.socketio, node: v6.12.3
! 2018-01-30 22:19:46.808 - ^[[32minfo^[[39m: telegram.0 starting. Version 1.1.0 in /opt/iobroker/node_modules/iobroker.telegram, node: v6.12.3
! 2018-01-30 22:19:46.841 - ^[[32minfo^[[39m: cloud.0 starting. Version 2.4.4 in /opt/iobroker/node_modules/iobroker.cloud, node: v6.12.3
! 2018-01-30 22:19:46.856 - ^[[32minfo^[[39m: sql.0 starting. Version 1.6.1 in /opt/iobroker/node_modules/iobroker.sql, node: v6.12.3
! 2018-01-30 22:19:46.867 - ^[[32minfo^[[39m: telegram.0 getMe (reconnect): {"id":542992241,"is_bot":true,"first_name":"iob-jg","username":"iobjgBot"}
! 2018-01-30 22:19:46.881 - ^[[32minfo^[[39m: smartmeter.0 starting. Version 1.1.0 in /opt/iobroker/node_modules/iobroker.smartmeter, node: v6.12.3
! 2018-01-30 22:19:46.849 - ^[[32minfo^[[39m: cloud.0 Connecting with https://iobroker.pro:10555 with "@pro_XXXXXXXXXXXXXXXXXX"
! 2018-01-30 22:19:46.918 - ^[[31merror^[[39m: socketio.0 port 8084 already in use
! 2018-01-30 22:19:46.983 - ^[[32minfo^[[39m: sql.0 Connected to mysql
! 2018-01-30 22:19:48.978 - ^[[32minfo^[[39m: smartmeter.0 Received 10 values, 3 updated
! 2018-01-30 22:19:49.022 - ^[[32minfo^[[39m: admin.0 starting. Version 2.0.9 in /opt/iobroker/node_modules/iobroker.admin, node: v6.12.3
! 2018-01-30 22:19:49.463 - ^[[31merror^[[39m: Caught by controller[0]: 2018-01-30 22:19:46.919 - socketio.0 port 8084 already in use
! 2018-01-30 22:19:49.697 - ^[[32minfo^[[39m: smartmeter.0 starting. Version 1.1.0 in /opt/iobroker/node_modules/iobroker.smartmeter, node: v6.12.3
! 2018-01-30 22:19:49.697 - ^[[32minfo^[[39m: cloud.0 starting. Version 2.4.4 in /opt/iobroker/node_modules/iobroker.cloud, node: v6.12.3
! 2018-01-30 22:19:49.690 - ^[[32minfo^[[39m: telegram.0 starting. Version 1.1.0 in /opt/iobroker/node_modules/iobroker.telegram, node: v6.12.3
! 2018-01-30 22:19:49.465 - ^[[31merror^[[39m: host.ioB-Master instance system.adapter.socketio.0 terminated with code 1 ()
! 2018-01-30 22:19:49.465 - ^[[32minfo^[[39m: host.ioB-Master Restart adapter system.adapter.socketio.0 because enabled
! 2018-01-30 22:19:49.727 - ^[[32minfo^[[39m: sql.0 starting. Version 1.6.1 in /opt/iobroker/node_modules/iobroker.sql, node: v6.12.3
! 2018-01-30 22:19:49.705 - ^[[32minfo^[[39m: cloud.0 Connecting with https://iobroker.pro:10555 with "@pro_XXXXXXXXXXXXXXXXXXXXXXXX"
! 2018-01-30 22:19:49.881 - ^[[32minfo^[[39m: sql.0 Connected to mysql
! 2018-01-30 22:19:50.039 - ^[[32minfo^[[39m: telegram.0 getMe (reconnect): {"id":542992241,"is_bot":true,"first_name":"iob-jg","username":"iobjgBot"}
! 2018-01-30 22:19:50.075 - ^[[32minfo^[[39m: admin.0 starting. Version 2.0.9 in /opt/iobroker/node_modules/iobroker.admin, node: v6.12.3
! 2018-01-30 22:19:50.086 - ^[[32minfo^[[39m: admin.0 requesting all states
! 2018-01-30 22:19:50.090 - ^[[32minfo^[[39m: admin.0 requesting all objects
! 2018-01-30 22:19:50.993 - ^[[32minfo^[[39m: hm-rpc.1 starting. Version 1.5.0 in /opt/iobroker/node_modules/iobroker.hm-rpc, node: v6.12.3
! 2018-01-30 22:19:51.033 - ^[[32minfo^[[39m: rpi2.0 starting. Version 0.3.2 in /opt/iobroker/node_modules/iobroker.rpi2, node: v6.12.3
! 2018-01-30 22:19:51.361 - ^[[32minfo^[[39m: smartmeter.0 Received 10 values, 3 updated
! 2018-01-30 22:19:53.783 - ^[[32minfo^[[39m: sql.0 enabled logging of hm-rpc.0.LEQ1069213.1.HUMIDITY
! 2018-01-30 22:19:53.849 - ^[[32minfo^[[39m: sql.0 enabled logging of javascript.0.StromAuto.CurrentMonth
! 2018-01-30 22:19:56.198 - ^[[32minfo^[[39m: rpi2.0 starting. Version 0.3.2 in /opt/iobroker/node_modules/iobroker.rpi2, node: v6.12.3
! 2018-01-30 22:19:56.198 - ^[[32minfo^[[39m: hm-rpc.2 starting. Version 1.5.0 in /opt/iobroker/node_modules/iobroker.hm-rpc, node: v6.12.3
! 2018-01-30 22:19:56.305 - ^[[32minfo^[[39m: hm-rpc.1 xmlrpc server is trying to listen on 192.168.2.12:2011
! 2018-01-30 22:19:56.307 - ^[[32minfo^[[39m: hm-rpc.1 xmlrpc client is trying to connect to 192.168.2.15:2010 with ["http://192.168.2.12:2011","hm-rpc.1"]
! 2018-01-30 22:19:56.660 - ^[[32minfo^[[39m: hm-rpc.1 xmlrpc <- listDevices ["hm-rpc.1"]
! 2018-01-30 22:19:57.936 - ^[[32minfo^[[39m: hm-rega.0 starting. Version 1.6.6 in /opt/iobroker/node_modules/iobroker.hm-rega, node: v6.12.3
! 2018-01-30 22:19:57.936 - ^[[32minfo^[[39m: hm-rpc.0 starting. Version 1.5.0 in /opt/iobroker/node_modules/iobroker.hm-rpc, node: v6.12.3
! 2018-01-30 22:32:27.196 - ^[[31merror^[[39m: cloud.0 Ping timeout
! ^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^

[apollon77]

Der interessante Part fehlt aber irgendwie:

`2018-01-30 22:15:28.216 - ^[[32minfo^[[39m: iobroker node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws ... arm.tar.gz node-pre-gyp ERR! Pre-built bina$[/code]`

... ist bissl wenig

[AlCalzone]

Hab mal deinen Cloud-Pro-Key aus dem Log entfernt. Nicht dass noch wer auf dumme Gedanken kommt.

[jhg]

@apollon77:

Der interessante Part fehlt aber irgendwie:

`2018-01-30 22:15:28.216 - ^[[32minfo^[[39m: iobroker node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws ... arm.tar.gz node-pre-gyp ERR! Pre-built bina$[/code]`

... ist bissl wenig

Hier die komplette Meldung:

2018-01-30 22:15:28.216  - ^[[32minfo^[[39m: iobroker node-pre-gyp ERR! Tried to download(403):

[https://mapbox-node-binary.s3.amazonaws ... arm.tar.gz](https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v48-linux-arm.tar.gz) node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.13 and node@6.12.3 (node-v48 ABI) (falling back to source compile with node-gyp)

Wurde beim Kopieren leider abgeschnitten. :-(
``` ` 

[apollon77]

viel interessanter ist alles von node-gyp, npm und so was danach kommt!

[jhg]

Da kommt nichts mehr im Log.

Ich habe alles bis zum runterfahren des raspi kopiert.

ich kann nochmal einen anderen Adapter testen um zu sehen was passiert.

[Kueppert]

Bei mir sieht das genau so aus, danach kommt bei mir nix mehr, weil der pi3 auf 100% läuft (denke ich, lenkte leuchtet durchgehend) und auch auch über Nacht nicht mehr beruhigt. Komme mit putty dann auch nicht mehr auf den pi3, bis ich einen Kaltstart mache.

Bin gespannt ob es hierfür eine Lösung hier geben wird

Gesendet von meinem HUAWEI RIO-L01 mit Tapatalk

[apollon77]

@Kueppert:

Bin gespannt ob es hierfür eine Lösung hier geben wird `

Die einzige lösung die mir einfällt ist das Du den compile prozess killst … Bei vielen Usern läuft das problemlos ... Könnte es bei Dir vllt andere probleme haben? SD Karte noch in Ordnung (...)?

[jhg]

Hallo,

ich habe gestern auf npm 4.1 aktualisiert und heute den aktuellen SQL-Adapter installiert (1.6.7).

Weder bei der Aktualisierung des SQL-Adapters noch bei den anderen Adaptern ist der Fehler wieder aufgetreten.

Ich werde das weiter verfolgen.

[Kueppert]

OK,

vielleicht ist das bei mir auch die Lösung. Wir aktualisiere ich nmp auf dem pi? Was hast du genau gemacht? Ich habe das Problem immer noch…

Danke und Grüße, Thorsten

Gesendet von meinem HUAWEI RIO-L01 mit Tapatalk

[Kueppert]

Ok,

ich hab jetzt einfach mal im Netz gesucht und folgendes in der Konsole ausgeführt:

! ` > sudo apt-get update

sudo apt-get upgrade `

installiert habe ich nun:

npm v2.15.11

node v4.8.7

nodejs 4.8.7

So, dann wollen wir doch mal sehen, ob ich jetzt den SQL-Adapter mal aktualisiert bekomme…hab nach dem fehlgeschlagenen Update immer noch die 1.6.5 druff :-S

[Kueppert]

Ich werd bekloppt…diesmal ging es weiter

So hab ich weiter gemacht:

iobroker stop

dann````
sudo npm install iobroker.sql@1.6.7

raus kam folgendes:

>!  ` > npm WARN deprecated node-uuid@1.4.8: Use uuid module instead
> 
> npm WARN deprecated sprintf@0.1.5: The sprintf package is deprecated in favor of sprintf-js.
> 
> /
> 
> > sqlite3@3.1.13 install /root/node_modules/iobroker.sql/node_modules/sqlite3
> 
> > node-pre-gyp install –fallback-to-build
> 
> node-pre-gyp ERR! Tried to download(403): [https://mapbox-node-binary.s3.amazonaws ... arm.tar.gz](https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v46-linux-arm.tar.gz)
> 
> node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.13 and node@4.8.7 (node-v46 ABI) (falling back to source compile with node-gyp)
> 
> make: Entering directory '/root/node_modules/iobroker.sql/node_modules/sqlite3/build'
> 
> ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3150000/sqlite3.c
> 
> TOUCH Release/obj.target/deps/action_before_build.stamp
> 
> CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3150000/sqlite3.o
> 
> AR(target) Release/obj.target/deps/sqlite3.a
> 
> COPY Release/sqlite3.a
> 
> CXX(target) Release/obj.target/node_sqlite3/src/database.o
> 
> ../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(),
> 
> ^
> 
> CXX(target) Release/obj.target/node_sqlite3/src/node_sqlite3.o
> 
> CXX(target) Release/obj.target/node_sqlite3/src/statement.o
> 
> ../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);
> 
> ^
> 
> SOLINK_MODULE(target) Release/obj.target/node_sqlite3.node
> 
> COPY Release/node_sqlite3.node
> 
> COPY /root/node_modules/iobroker.sql/node_modules/sqlite3/lib/binding/node-v46-linux-arm/node_sqlite3.node
> 
> TOUCH Release/obj.target/action_after_build.stamp
> 
> make: Leaving directory '/root/node_modules/iobroker.sql/node_modules/sqlite3/build'
> 
> iobroker.sql@1.6.7 node_modules/iobroker.sql
> 
> ├── pg@6.4.2 (js-string-escape@1.0.1, packet-reader@0.3.1, pg-connection-string@0.1.3, buffer-writer@1.0.1, semver@4.3.2, pg-pool@1.8.0, pg-types@1.13.0, pgpass@1.0.2)
> 
> ├── mysql@2.15.0 (safe-buffer@5.1.1, sqlstring@2.3.0, bignumber.js@4.0.4, readable-stream@2.3.3)
> 
> ├── sql-client@0.7.0 (argf@0.0.1, optimist@0.6.1, inote-util@0.8.1)
> 
> ├── mssql@3.3.0 (generic-pool@2.5.4, promise@7.3.1, tedious@1.14.0)
> 
> └── sqlite3@3.1.13 (nan@2.7.0) `  

sieht für mich jetzt erst mal gut aus.

Das System hab ich wieder mit````
iobroker start
````hochgefahren…

UND WAS SEHE ICH IM ADMIN??? SQL-ADAPTER 1.6.5??????????????? Kann doch nicht wahr sein :(

[apollon77]

iobroker upload sql

Wenn man es direkt per npm installiert fehlen halt die iobroker spezifischen Dinge die noch so kommen

[Kueppert]

@apollon77:

iobroker upload sql

Wenn man es direkt per npm installiert fehlen halt die iobroker spezifischen Dinge die noch so kommen `

Hab es im Admin nochmal ausprobiert, leider ohne Erfolg. Hab 1h auf den sich drehenden Kreis geschaut - Hintergrund komplett grau…also wieder dr gute alte Kaltstart.

Habe in der Konsole iobroker beendet.

Habe dann aus dem Screen einen Befehl genommen und den mal benutzt und deinen Befehl hinterher:

! ` > root@raspberrypi3:~# sudo npm install iobroker.sql@1.6.7 –production --prefix "/opt/iobroker"

npm WARN deprecated node-uuid@1.4.8: Use uuid module instead

^Croot@raspberrypi3:~# cd /opt/iobroker

root@raspberrypi3:/opt/iobroker# sudo npm install iobroker.sql@1.6.7 --production --prefix "/opt/iobroker"

npm WARN deprecated node-uuid@1.4.8: Use uuid module instead

npm WARN deprecated sprintf@0.1.5: The sprintf package is deprecated in favor of sprintf-js.

sqlite3@3.1.13 install /opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3

node-pre-gyp install --fallback-to-build

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws ... arm.tar.gz

node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.13 and node@4.8.7 (node-v46 ABI) (falling back to source compile with node-gyp)

make: Entering directory '/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/build'

ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3150000/sqlite3.c

TOUCH Release/obj.target/deps/action_before_build.stamp

CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3150000/sqlite3.o

AR(target) Release/obj.target/deps/sqlite3.a

COPY Release/sqlite3.a

CXX(target) Release/obj.target/node_sqlite3/src/database.o

../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(),

^

CXX(target) Release/obj.target/node_sqlite3/src/node_sqlite3.o

CXX(target) Release/obj.target/node_sqlite3/src/statement.o

../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);

^

SOLINK_MODULE(target) Release/obj.target/node_sqlite3.node

COPY Release/node_sqlite3.node

COPY /opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/lib/binding/node-v46-linux-arm/node_sqlite3.node

TOUCH Release/obj.target/action_after_build.stamp

make: Leaving directory '/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/build'

iobroker.sql@1.6.7 node_modules/iobroker.sql

├── pg@6.4.2 (js-string-escape@1.0.1, packet-reader@0.3.1, pg-connection-string@0.1.3, buffer-writer@1.0.1, semver@4.3.2, pg-pool@1.8.0, pg-types@1.13.0, pgpass@1.0.2)

├── mysql@2.15.0 (safe-buffer@5.1.1, sqlstring@2.3.0, bignumber.js@4.0.4, readable-stream@2.3.3)

├── sql-client@0.7.0 (argf@0.0.1, optimist@0.6.1, inote-util@0.8.1)

├── mssql@3.3.0 (generic-pool@2.5.4, promise@7.3.1, tedious@1.14.0)

└── sqlite3@3.1.13 (nan@2.7.0)

root@raspberrypi3:/opt/iobroker# ^C

root@raspberrypi3:/opt/iobroker# iobroker upload sql

got /opt/iobroker/node_modules/iobroker.sql/admin

upload [5] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/words.js words.js application/javascript

upload [4] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/sql.png sql.png image/png

upload [3] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/index_m.html index_m.html text/html

upload [2] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/index.html index.html text/html

upload [1] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/custom_m.html custom_m.html text/html

upload [0] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/custom.html custom.html text/html

Update "system.adapter.sql.0"

root@raspberrypi3:/opt/iobroker# `

Soooo, insgesamt habe ich nun doch den neuen SQL-Adapter drauf. Anscheinend geht das bei mir nur über den sehr sehr umständlichen Weg Konsole Oh man…hab aber echt keine Lust das ganze System deswegen neu zu machen...

Danke dir für deine Hilfe mit dem iobroker upload sql

VG Thorsten
2700_sql.png