I am trying to install the ODBC Loader on Vertica
so first I downloaded the unixODBC from here
I was successfully able to do, .configure, make and sudo make install. I can see that files like libodbc.so are created in /usr/lib and usr/local/lib
next I download the ODBC Loader package from here
https://github.com/vertica/Vertica-Extension-Packages
Here also I did
cd odbc_loader_package
.configure
make
I can see a file called ./build/ODBCLoader.so. I copied this directory into ./ddl folder
Now I launched vsql as verticadba and executed the .\ddl\install.sql
but I get this error
vsql:install.sql:3: ROLLBACK 2175: An error occurred when loading library file on node v_ddcanalytics_node0003, message:
Failure in UDx RPC call InvokeCheckLibrary(): Error calling setupExecContext() in User Defined Object [] at [/scratch_a/release/24526/vbuild/vertica/OSS/UDxFence/vertica-udx-C++.cpp:204], error code: 0, message: Error happened in dlopen(): [libodbc.so.2: cannot open shared object file: No such file or directory]
vsql:install.sql:4: ROLLBACK 3861: Library not found: ODBCLoaderLib
vsql:install.sql:5: ROLLBACK 3861: Library not found: ODBCLoaderLib
I googled and tried make things like
1. created a file under /etc/ld.so.config.d/odbc.conf
2. entered the lines /usr/lib and /usr/local/lib
2. modified the makefile of ODBCLoader to
$(CXX) $(ALL_CXXFLAGS) -o $@ $(SDK_HOME)/include/Vertica.cpp ODBCLoader.cpp -L/usr/local/lib -lodbc -Wl,-rpath=/usr/local/lib
but nothing works and I keep getting the same error again and again.