philip-wernersbach/influx-mysql

influx-mysql is a daemon that converts between InfluxDB and MySQL protocol. It allows time series tools that speak InfluxDB protocol to store and query data natively in MySQL, using InfluxQL or SQL.

influx-mysql's Issues

Compiling Errors

Dear Philip,

I am trying to create a "influx-mysql" daemon using the this github repo. I have installed all dependencies such as qt5, snappy, Nim and nimble on centos 7 server.

When i tried to compile using the below instructions, i am getting the compile error as below.

Instructions followed:

nimble cpp --out:bin/influx_mysql influx_mysql/src/influx_mysql # 4

Compile time error:

[root@grafana nimble]# src/nimble cpp --out:bin/influx_mysql /usr/local/influx-mysql/influx_mysql/src/influx_mysql.nim # 4
Verifying dependencies for [email protected]
Info: Dependency on compiler@#head already satisfied
Verifying dependencies for compiler@#head
Compiling /usr/local/influx-mysql/influx_mysql/src/influx_mysql.nim (from package nimble) using cpp backend
Output: Hint: used config file '/usr/local/Nim/config/nim.cfg' [Conf]
... Hint: used config file '/usr/local/influx-mysql/influx_mysql/src/nim.cfg' [Conf]
... Hint: system [Processing]
... Hint: influx_mysql [Processing]
... Hint: future [Processing]
... Hint: macros [Processing]
... Hint: strtabs [Processing]
... Hint: hashes [Processing]
... Hint: strutils [Processing]
... Hint: parseutils [Processing]
... Hint: math [Processing]
... Hint: algorithm [Processing]
... Hint: etcpriv [Processing]
... Hint: os [Processing]
... Hint: times [Processing]
... Hint: posix [Processing]
... Hint: asyncdispatch [Processing]
... Hint: oids [Processing]
... Hint: endians [Processing]
... Hint: tables [Processing]
... Hint: heapqueue [Processing]
... Hint: nativesockets [Processing]
... Hint: net [Processing]
... Hint: sets [Processing]
... Hint: deques [Processing]
... Hint: selectors [Processing]
... Hint: epoll [Processing]
... Hint: asyncnet [Processing]
... Hint: httpcore [Processing]
... Hint: asynchttpserver [Processing]
... Hint: uri [Processing]
... Hint: lists [Processing]
... Hint: json [Processing]
... Hint: lexbase [Processing]
... Hint: streams [Processing]
... Hint: unicode [Processing]
... Hint: base64 [Processing]
... Hint: cgi [Processing]
... Hint: cookies [Processing]
... influx_mysql.nim(32, 8) Error: cannot open 'qt5_qtsql'
Tip: 2 messages have been suppressed, use --verbose to show them.
Error: Traceback (most recent call last)
... nimble.nim(1068) nimble
... nimble.nim(1016) doAction
... nimble.nim(659) execBackend
... tools.nim(33) doCmd
... Execution failed with exit code 1
... Command: "/usr/local/Nim/bin/nim" cpp --noNimblePath --path:"/root/.nimble/pkgs/compiler-#head" --out:bin/influx_mysql "/usr/local/influx-mysql/influx_mysql/src/influx_mysql.nim"
... Output: Hint: used config file '/usr/local/Nim/config/nim.cfg' [Conf]
... Hint: used config file '/usr/local/influx-mysql/influx_mysql/src/nim.cfg' [Conf]
... Hint: system [Processing]
... Hint: influx_mysql [Processing]
... Hint: future [Processing]
... Hint: macros [Processing]
... Hint: strtabs [Processing]
... Hint: hashes [Processing]
... Hint: strutils [Processing]
... Hint: parseutils [Processing]
... Hint: math [Processing]
... Hint: algorithm [Processing]
... Hint: etcpriv [Processing]
... Hint: os [Processing]
... Hint: times [Processing]
... Hint: posix [Processing]
... Hint: asyncdispatch [Processing]
... Hint: oids [Processing]
... Hint: endians [Processing]
... Hint: tables [Processing]
... Hint: heapqueue [Processing]
... Hint: nativesockets [Processing]
... Hint: net [Processing]
... Hint: sets [Processing]
... Hint: deques [Processing]
... Hint: selectors [Processing]
... Hint: epoll [Processing]
... Hint: asyncnet [Processing]
... Hint: httpcore [Processing]
... Hint: asynchttpserver [Processing]
... Hint: uri [Processing]
... Hint: lists [Processing]
... Hint: json [Processing]
... Hint: lexbase [Processing]
... Hint: streams [Processing]
... Hint: unicode [Processing]
... Hint: base64 [Processing]
... Hint: cgi [Processing]
... Hint: cookies [Processing]
... influx_mysql.nim(32, 8) Error: cannot open 'qt5_qtsql'

Can you kindly help me to fix this error and proceed further.

Thanks
Venki

Extension: SQL MERGE via MySQL REPLACE

An extension to the normal InfluxDB functionality to add SQL MERGE functionality (via MySQL REPLACE) would be useful. This extension needs to be opt-in for backwards compatibility, possibly by adding a "sql_merge=true" URL parameter?

Qt5 dependencies

Hi, as I am new to infulx-mysql, I am not able to install Qt5core due to these dependencies
libQt5Core5 = 5.5.1 is needed by libQt5Core-devel-5.5.1-10.1.x86_64
libqt5-qtbase-common-devel = 5.5.1 is needed by libQt5Core-devel-5.5.1-10.1.x86_64
libc.so.6(GLIBC_2.14)(64bit) is needed by libQt5Core5-5.5.1-10.1.x86_64
libc.so.6(GLIBC_2.15)(64bit) is needed by libQt5Core5-5.5.1-10.1.x86_64
libicui18n.so.52.1()(64bit) is needed by libQt5Core5-5.5.1-10.1.x86_64
libicuuc.so.52.1()(64bit) is needed by libQt5Core5-5.5.1-10.1.x86_64
libpcre16.so.0()(64bit) is needed by libQt5Core5-5.5.1-10.1.x86_64
and I am not able to find them even in google to install. can anyone help me in finding the solution to issue?

Compilation issue at step #4

Hi, thanks for the project.

I have an Oracle Linux 7.5 system that I am trying to compile this code on. After installing dependencies and patching the code, I executed the compiling steps. I get an error that I can't get passed;

Error output

/root/.nimble/pkgs/qt5_qtsql-1.1.1/qt5_qtsql/src/immutablecstring.nim(31, 37) Error: undeclared identifier: 'expr'
     Error: Execution failed with exit code 1
        ... Command: "/usr/local/nim/bin/nim" cpp --noNimblePath -d:NimblePkgVersion=1.0.0 --path:"/root/.nimble/pkgs/qt5_qtsql-1.1.1" --path:"/root/.nimble/pkgs/microasynchttpserver-0.10.2" --path:"/root/.nimble/pkgs/picohttpparser-0.10.0" "--out:bin/influx_mysql"  "influx_mysql/src/influx_mysql"

Step 1

# pwd
/usr/local/influx-mysql
# git submodule update --init
#

Step 2

# nimble install -d

  Verifying dependencies for [email protected]
      Info: Dependency on qt5_qtsql@>= 1.0.1 already satisfied
  Verifying dependencies for [email protected]
      Info: Dependency on microasynchttpserver@>= 0.10.0 already satisfied
  Verifying dependencies for [email protected]
      Info: Dependency on picohttpparser@>= 0.10.0 already satisfied
   Warning: Package 'picohttpparser' has an incorrect structure. The top level of the package source directory should contain at most one module, named 'picohttpparser.nim', but a file named 'picohttpparser_api.nim' was found. This will be an error in the future.
      Hint: If this is the primary source file in the package, rename it to 'picohttpparser.nim'. If it's a source file required by the main module, or if it is one of several modules exposed by 'picohttpparser', then move it into a 'picohttpparser/' subdirectory. If it's a test file or otherwise not required to build the the package 'picohttpparser.nim', prevent its installation by adding `skipFiles = @["picohttpparser_api.nim"]` to the .nimble file. See https://github.com/nim-lang/nimble#libraries for more info.
  Verifying dependencies for [email protected]
   Warning: The .nimble file for this project could make use of additional features, if converted into the new NimScript format.
        ... For more details see:https://github.com/nim-lang/nimble#creating-packages

Step 3

# mkdir -p bin

Step 4

# nimble cpp --out:bin/influx_mysql influx_mysql/src/influx_mysql
   Warning: The .nimble file for this project could make use of additional features, if converted into the new NimScript format.
        ... For more details see:https://github.com/nim-lang/nimble#creating-packages
  Verifying dependencies for [email protected]
      Info: Dependency on qt5_qtsql@>= 1.0.1 already satisfied
  Verifying dependencies for [email protected]
      Info: Dependency on microasynchttpserver@>= 0.10.0 already satisfied
  Verifying dependencies for [email protected]
      Info: Dependency on picohttpparser@>= 0.10.0 already satisfied
  Verifying dependencies for [email protected]
  Compiling influx_mysql/src/influx_mysql (from package influx_mysql) using cpp backend
Hint: used config file '/usr/local/nim/config/nim.cfg' [Conf]
Hint: used config file '/usr/local/influx-mysql/influx_mysql/src/nim.cfg' [Conf]
Hint: system [Processing]
Hint: widestrs [Processing]
Hint: io [Processing]
Hint: influx_mysql [Processing]
Hint: future [Processing]
Hint: macros [Processing]
/usr/local/influx-mysql/influx_mysql/src/influx_mysql.nim(15, 8) Warning: Use the new 'sugar' module instead; future is deprecated [Deprecated]
Hint: strtabs [Processing]
Hint: hashes [Processing]
Hint: strutils [Processing]
Hint: parseutils [Processing]
Hint: math [Processing]
Hint: bitops [Processing]
Hint: algorithm [Processing]
Hint: unicode [Processing]
Hint: os [Processing]
Hint: pathnorm [Processing]
Hint: osseps [Processing]
Hint: posix [Processing]
Hint: times [Processing]
Hint: options [Processing]
Hint: typetraits [Processing]
Hint: asyncdispatch [Processing]
Hint: tables [Processing]
Hint: heapqueue [Processing]
Hint: lists [Processing]
Hint: asyncstreams [Processing]
Hint: asyncfutures [Processing]
Hint: deques [Processing]
Hint: cstrutils [Processing]
Hint: monotimes [Processing]
Hint: nativesockets [Processing]
Hint: net [Processing]
Hint: sets [Processing]
Hint: selectors [Processing]
Hint: epoll [Processing]
Hint: asyncnet [Processing]
Hint: httpcore [Processing]
Hint: asynchttpserver [Processing]
Hint: uri [Processing]
Hint: json [Processing]
Hint: lexbase [Processing]
Hint: streams [Processing]
Hint: parsejson [Processing]
Hint: base64 [Processing]
Hint: cgi [Processing]
Hint: cookies [Processing]
Hint: qt5_qtsql [Processing]
Hint: immutablecstring [Processing]
/root/.nimble/pkgs/qt5_qtsql-1.1.1/qt5_qtsql/src/immutablecstring.nim(31, 37) Error: undeclared identifier: 'expr'
       Tip: 6 messages have been suppressed, use --verbose to show them.
     Error: Execution failed with exit code 1
        ... Command: "/usr/local/nim/bin/nim" cpp --noNimblePath -d:NimblePkgVersion=1.0.0 --path:"/root/.nimble/pkgs/qt5_qtsql-1.1.1" --path:"/root/.nimble/pkgs/microasynchttpserver-0.10.2" --path:"/root/.nimble/pkgs/picohttpparser-0.10.0" "--out:bin/influx_mysql"  "influx_mysql/src/influx_mysql"