I have tried " apt-get install libmysqlclient-dev" and tried "apt-get install libmysqlclient18 libmysql++-dev", so libmysqlclient.so.18.0.0 is installed.
but libmysqlclient.so.18.0.0 has no symbols such as 'mysql_init'
yanggeorge@ubuntu:~/gitsource/fnordmetric/fnordmetric-core$ nm /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0
nm: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0: no symbols
so fnordmetric-cli does not work.
yanggeorge@ubuntu:~/tmp$ fnordmetric-cli example_query.sql
[ERROR] error opening file '': No such file or directory while executing query: IMPORT TABLE city_temperatures FROM "csv://city_temperatures.csv?headers=true"
I have got success of compiling this On Mac OSX10.8.5 , every tests shows PASS . But I have got issue on Ubuntu 14.04 LTS.
yanggeorge@ubuntu:~/gitsource/fnordmetric/fnordmetric-core$ sudo make [sudo] password for yanggeorge: (cd ../fnordmetric-webui && make) make[1]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-webui' make[1]: Leaving directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-webui' (cd build/cmake && make) make[1]: Entering directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake' ./assets.sh mkdir -p target/tests mkdir -p stage/src test -e stage/src/fnordmetric || ln -s ../../../../src stage/src/fnordmetric || true (cd target && cmake .. -DCMAKE_BUILD_TYPE=Release && make) -- MySQL Include dir: /usr/include/mysql library dir: /usr/lib/x86_64-linux-gnu -- MySQL client libraries: mysqlclient_r -- Configuring done -- Generating done -- Build files have been written to: /home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target make[2]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[3]: Entering directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[4]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' Scanning dependencies of target fnord make[4]: Leaving directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[4]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' [ 0%] Building CXX object CMakeFiles/fnord.dir/stage/src/fnordmetric/util/assets.cc.o Linking CXX shared library libfnord.so make[4]: Leaving directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' [ 31%] Built target fnord make[4]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' Scanning dependencies of target fnordmetric-cli make[4]: Leaving directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[4]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' [ 31%] Building CXX object CMakeFiles/fnordmetric-cli.dir/stage/src/fnordmetric/util/assets.cc.o Linking CXX executable fnordmetric-cli make[4]: Leaving directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' [ 64%] Built target fnordmetric-cli make[4]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' Scanning dependencies of target fnordmetric-server make[4]: Leaving directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[4]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' [ 65%] Building CXX object CMakeFiles/fnordmetric-server.dir/stage/src/fnordmetric/util/assets.cc.o Linking CXX executable fnordmetric-server make[4]: Leaving directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' [ 96%] Built target fnordmetric-server make[4]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[4]: Leaving directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[4]: Entering directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' Linking CXX executable tests/test-cli libfnord.so: undefined reference tomysql_fetch_field_direct' libfnord.so: undefined reference to
mysql_num_fields' libfnord.so: undefined reference tomysql_init' libfnord.so: undefined reference to
mysql_real_query' libfnord.so: undefined reference tomysql_fetch_row' libfnord.so: undefined reference to
mysql_close' libfnord.so: undefined reference tomysql_real_connect' libfnord.so: undefined reference to
mysql_fetch_lengths' libfnord.so: undefined reference tomysql_server_init' libfnord.so: undefined reference to
mysql_error' libfnord.so: undefined reference tomysql_use_result' libfnord.so: undefined reference to
mysql_list_fields' libfnord.so: undefined reference tomysql_free_result' collect2: error: ld returned 1 exit status make[4]: *** [tests/test-cli] Error 1 make[4]: Leaving directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[3]: * [CMakeFiles/tests/test-cli.dir/all] Error 2 make[3]: Leaving directory/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[2]: *** [all] Error 2 make[2]: Leaving directory
/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake/target' make[1]: *\ [all] Error 2 make[1]: Leaving directory `/home/yanggeorge/gitsource/fnordmetric/fnordmetric-core/build/cmake' make: * [build] Error 2 yanggeorge@ubuntu:~/gitsource/fnordmetric/fnordmetric-core$I have tried " apt-get install libmysqlclient-dev" and tried "apt-get install libmysqlclient18 libmysql++-dev", so libmysqlclient.so.18.0.0 is installed.
yanggeorge@ubuntu:~/gitsource/fnordmetric/fnordmetric-core$ locate libmysqlclient /usr/lib/libmysqlclient /usr/lib/x86_64-linux-gnu/libmysqlclient.a /usr/lib/x86_64-linux-gnu/libmysqlclient.so /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18 /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0 /usr/lib/x86_64-linux-gnu/libmysqlclient_r.a /usr/lib/x86_64-linux-gnu/libmysqlclient_r.so /usr/lib/x86_64-linux-gnu/libmysqlclient_r.so.18 /usr/lib/x86_64-linux-gnu/libmysqlclient_r.so.18.0.0
but libmysqlclient.so.18.0.0 has no symbols such as 'mysql_init'
yanggeorge@ubuntu:~/gitsource/fnordmetric/fnordmetric-core$ nm /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0 nm: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0: no symbols
so fnordmetric-cli does not work.
yanggeorge@ubuntu:~/tmp$ fnordmetric-cli example_query.sql [ERROR] error opening file '': No such file or directory while executing query: IMPORT TABLE city_temperatures FROM "csv://city_temperatures.csv?headers=true"
SELECT * FROM city_temperatures;
Thanks in advance