hello
I've an error message for my "influxdb out node"
however my previous debug node indicates that I enter a number for it, what happens?
thanks a lot.
Show us what is going into the influx node.
Hi,
an example of what does not work
[{"id":"bd1e8b01.c1f1b","type":"debug","z":"caac2f35.7f1d1","name":"conf http","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":300,"y":100,"wires":[]},{"id":"566a9805.64396","type":"json","z":"caac2f35.7f1d1","name":"","property":"payload","action":"obj","pretty":false,"x":230,"y":180,"wires":[["19124406.2b4c8c","cf38891e.685ad"]]},{"id":"19124406.2b4c8c","type":"debug","z":"caac2f35.7f1d1","name":"message Json","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":421,"y":146,"wires":[]},{"id":"cf38891e.685ad","type":"switch","z":"caac2f35.7f1d1","name":"routage capteurs","property":"payload.payload.DevAddr","propertyType":"msg","rules":[{"t":"cont","v":"","vt":"str"},{"t":"cont","v":"","vt":"str"},{"t":"cont","v":"","vt":"str"},{"t":"cont","v":"","vt":"str"},{"t":"cont","v":"","vt":"str"},{"t":"cont","v":"","vt":"str"},{"t":"cont","v":"","vt":"str"},{"t":"cont","v":"00a8c47e","vt":"str"},{"t":"else"}],"checkall":"true","repair":true,"outputs":9,"x":224,"y":352,"wires":[[],[],[],[],[],[],[],["fbb4a86b.d7c028"],["b8f34b43.356d98"]]},{"id":"b8f34b43.356d98","type":"debug","z":"caac2f35.7f1d1","name":"error routage","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":192.28573608398438,"y":439.142822265625,"wires":[]},{"id":"fbb4a86b.d7c028","type":"function","z":"caac2f35.7f1d1","name":"extract rssi agrisense","func":"msg.topic = \"rssi\";\nmsg.payload=msg.payload.payload.rxpk.rssi;\nreturn msg;\n","outputs":1,"noerr":0,"x":500,"y":380,"wires":[["a37a11f4.2299e","7af8e351.0a2164"]]},{"id":"a37a11f4.2299e","type":"debug","z":"caac2f35.7f1d1","name":"rssi agrisense","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":510,"y":320,"wires":[]},{"id":"1a2e165a.bb90f2","type":"influxdb out","z":"caac2f35.7f1d1","influxdb":"96a75b04.e09d2","name":"rssi Agrisense","measurement":"rssi Agrisense","precision":"","retentionPolicy":"","x":830,"y":540,"wires":[]},{"id":"405c400b.ec958","type":"inject","z":"caac2f35.7f1d1","name":"","topic":"","payload":"{\"_msgid\":\"8bdee0ee.3c4a1\",\"payload\":{\"frame\":\"494e5249415f524f4f54202831343a30303a3030292056626174203c20332e363537303431203e2054656d702f487964726f203c3e200a\",\"protocol\":\"NONE\",\"timestamp\":1611234073,\"delay\":\"0\",\"DevAddr\":\"00a8c47e\",\"DevEUI\":\"50b3d54998a8c47e\",\"sensorInstallId\":\"50b3d54998a8c47e\",\"loraPort\":2,\"gatewayID\":\"AA555A000B030964\",\"othersGw\":[],\"clientID\":\"inra\",\"azure_device_id\":\"\",\"decoder_type\":\"0\",\"AppEUI\":\"0000000000000000\",\"useAppEUI\":false,\"fcnt\":601,\"coeff\":1,\"unit\":\"\",\"stream_name\":\"\",\"serversList\":[\"Inra_Virtual_perso\"],\"rxpk\":{\"tmst\":861333227,\"time\":\"2021-01-21T13:01:13.847385Z\",\"chan\":3,\"rfch\":0,\"freq\":867.7,\"stat\":1,\"modu\":\"LORA\",\"datr\":\"SF7BW125\",\"codr\":\"4/5\",\"lsnr\":10.5,\"rssi\":-81,\"size\":68,\"data\":\"QH7EqAAAWQICdxYIjdZja8mIcstuH14u2JYQHNuUprhB4ATvdg2VAYvKMBnxtnUeFzCY2zhd/g6KmQRagWe97kvO6/s=\"},\"data\":null},\"req\":{\"_readableState\":{\"objectMode\":false,\"highWaterMark\":16384,\"buffer\":{\"head\":null,\"tail\":null,\"length\":0},\"length\":0,\"pipes\":null,\"pipesCount\":0,\"flowing\":true,\"ended\":true,\"endEmitted\":true,\"reading\":false,\"sync\":false,\"needReadable\":false,\"emittedReadable\":false,\"readableListening\":false,\"resumeScheduled\":false,\"paused\":false,\"emitClose\":true,\"autoDestroy\":false,\"destroyed\":false,\"defaultEncoding\":\"utf8\",\"awaitDrain\":0,\"readingMore\":false,\"decoder\":null,\"encoding\":null},\"readable\":false,\"_events\":{},\"_eventsCount\":1,\"socket\":\"[internal]\",\"connection\":\"[internal]\",\"httpVersionMajor\":1,\"httpVersionMinor\":1,\"httpVersion\":\"1.1\",\"complete\":true,\"headers\":{\"host\":\"138.102.159.81:1880\",\"user-agent\":\"libcurl-agent/1.0\",\"content-type\":\"application/json\",\"accept\":\"application/json\",\"content-length\":\"806\"},\"rawHeaders\":[\"Host\",\"138.102.159.81:1880\",\"User-Agent\",\"libcurl-agent/1.0\",\"Content-type\",\"application/json\",\"Accept\",\"application/json\",\"Content-Length\",\"806\"],\"trailers\":{},\"rawTrailers\":[],\"aborted\":false,\"upgrade\":false,\"url\":\"/perso\",\"method\":\"POST\",\"statusCode\":null,\"statusMessage\":null,\"client\":\"[internal]\",\"_consuming\":true,\"_dumped\":false,\"baseUrl\":\"\",\"originalUrl\":\"/perso\",\"_parsedUrl\":{\"protocol\":null,\"slashes\":null,\"auth\":null,\"host\":null,\"port\":null,\"hostname\":null,\"hash\":null,\"search\":null,\"query\":null,\"pathname\":\"/perso\",\"path\":\"/perso\",\"href\":\"/perso\",\"_raw\":\"/perso\"},\"params\":{},\"query\":{},\"res\":\"[internal]\",\"body\":{\"frame\":\"494e5249415f524f4f54202831343a30303a3030292056626174203c20332e363537303431203e2054656d702f487964726f203c3e200a\",\"protocol\":\"NONE\",\"timestamp\":1611234073,\"delay\":\"0\",\"DevAddr\":\"00a8c47e\",\"DevEUI\":\"50b3d54998a8c47e\",\"sensorInstallId\":\"50b3d54998a8c47e\",\"loraPort\":2,\"gatewayID\":\"AA555A000B030964\",\"othersGw\":[],\"clientID\":\"inra\",\"azure_device_id\":\"\",\"decoder_type\":\"0\",\"AppEUI\":\"0000000000000000\",\"useAppEUI\":false,\"fcnt\":601,\"coeff\":1,\"unit\":\"\",\"stream_name\":\"\",\"serversList\":[\"Inra_Virtual_perso\"],\"rxpk\":{\"tmst\":861333227,\"time\":\"2021-01-21T13:01:13.847385Z\",\"chan\":3,\"rfch\":0,\"freq\":867.7,\"stat\":1,\"modu\":\"LORA\",\"datr\":\"SF7BW125\",\"codr\":\"4/5\",\"lsnr\":10.5,\"rssi\":-82,\"size\":68,\"data\":\"QH7EqAAAWQICdxYIjdZja8mIcstuH14u2JYQHNuUprhB4ATvdg2VAYvKMBnxtnUeFzCY2zhd/g6KmQRagWe97kvO6/s=\"},\"data\":null},\"_body\":true,\"_passport\":{\"instance\":{\"_key\":\"passport\",\"_strategies\":{\"session\":{\"name\":\"session\"},\"bearer\":{\"name\":\"bearer\",\"_realm\":\"Users\"},\"oauth2-client-password\":{\"name\":\"oauth2-client-password\"},\"anon\":{\"name\":\"anon\"}},\"_serializers\":[],\"_deserializers\":[],\"_infoTransformers\":[],\"_framework\":{},\"_userProperty\":\"user\",\"_sm\":{\"_key\":\"passport\"},\"strategies\":{}}},\"route\":{\"path\":\"/perso\",\"stack\":[{\"name\":\"cookieParser\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"},{\"name\":\"httpMiddleware\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"},{\"name\":\"corsHandler\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"},{\"name\":\"metricsHandler\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"},{\"name\":\"jsonParser\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"},{\"name\":\"urlencodedParser\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"},{\"name\":\"multipartParser\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"},{\"name\":\"rawBodyParser\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"},{\"name\":\"<anonymous>\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"},{\"name\":\"<anonymous>\",\"keys\":[],\"regexp\":{\"fast_star\":false,\"fast_slash\":false},\"method\":\"post\"}],\"methods\":{\"post\":true}},\"cookies\":{},\"signedCookies\":{}},\"res\":{}}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":70,"y":160,"wires":[["566a9805.64396","bd1e8b01.c1f1b"]]},{"id":"7af8e351.0a2164","type":"function","z":"caac2f35.7f1d1","name":"number","func":"msg.payload = Number(msg.payload);\nreturn msg;\n","outputs":1,"noerr":0,"x":670,"y":540,"wires":[["1a2e165a.bb90f2","3ffd02b4.f58b96"]]},{"id":"3ffd02b4.f58b96","type":"debug","z":"caac2f35.7f1d1","name":"","active":true,"tosidebar":true,"console":true,"tostatus":true,"complete":"payload","targetType":"msg","x":830,"y":600,"wires":[]},{"id":"96a75b04.e09d2","type":"influxdb","z":"","hostname":"138.102.159.81","port":"8086","protocol":"http","database":"Agrisense","name":"Agrisense","usetls":false,"tls":""}]
ok I find my error
underscore in definition of database is not allowed !!!!
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
