When I follow this doc I am able to correctly query a PostgreSQL data source using the following
import "sql" sql.from( driverName: "postgres", dataSourceName: "postgresql://username:password@localhost/mydb", query: "SELECT * FROM sensors" )
When I use SQlite to create a test.db file with the same sensor table and sensor info and I change the DataSourceName to the one specified in the example I get “An internal error has occurred”. Not really an helpful error message.
import "sql" sql.from( driverName: "sqlite3", dataSourceName: "file:test.db?cache=shared&mode=memory", query: "SELECT * FROM sensors" )
- Where should I place the file test.db to be accessible to influx? the DataSourceName is relative to which path? I tried changing everything I could in dataSourceName without success.
- How could I have access to more Influx beta logs? Maybe there is something there.
I am using InfluxDB 2.0 Beta 6 where influxd is located at /usr/local/bin/